RPG Integration Hack - Old Support Thread

Nice conversion there mate, lot of work has gone into it so well done and thanks for sharing it

[SB2002]

I have a question. I've divided the itemshop into different sections for the different classes, the only thing is, the only weapons people can buy are the generic ones, no matter what class they chose. When they access their classes weapons, it tells them that they must be that class to buy them.

ie i have a pistoleer class, and they should be able to buy the pistols, but whenever they go to that classes shop they are told they must be a pistoleer to purchase them...... any ideas?

Or do I have to just have everything as generic?

[Revan]

Originally Posted by winlya

hic,I just testing on localhost.But not work.
some error with me when install

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_clan` (
  `clanid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `pass` varchar(50) NOT NULL default '',
  `leader` varchar(50) NOT NULL default '',
  `clanpoints` varchar(5) NOT NULL default '',
  `logo` varchar(100) NOT NULL default '',
  `ally` varchar(10) NOT NULL default '0',
  `enemy` varchar(10) NOT NULL default '0',
  `sb_settings` char(1) NOT NULL default '0',
  `maxmem` int(3) NOT NULL default '5',
  `col1` varchar(5) NOT NULL default '0',
  `col2` varchar(5) NOT NULL default '0',
  `col3` varchar(5) NOT NULL default '0',
  `col4` varchar(5) NOT NULL default '0',
  `sb_col_access` varchar(5) NOT NULL default '0',
  `cm_col_access` varchar(5) NOT NULL default '0',
  `ci_col_access` varchar(5) NOT NULL default '0',
  `rm_col_access` varchar(5) NOT NULL default '0',
  `clanmidiurl` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`clanid`)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 22

mysql error number: 1064

Date: Saturday 21st of August 2004 03:08:46 AM
Script: http://localhost/vB3.0.3/install/battleinstall.php?step=1
Referer: http://localhost/vB3.0.3/install/menue.htm
Username: admin
IP Address: 127.0.0.1 


I cant seem to find an error in this installer, just yesterday I installed perfectly on the beta board I use to track down bugs.
At any rate, the new installer has redundant sections removed from it, patches for which will be found in the new version due to be released once all bugs have been pinned.

Originally Posted by ogetbilo

With the updated heal.php healing is working now.
But I found 2 more problems.
When I tried to optimize my database tables I had this warning :

PHP Code:

rpg_rpg_alignment      Check      Warning: Found row where the auto_increment column has the value 0
rpg_rpg_alignment     Check     Status: OK
rpg_rpg_alignment     Optimize     Status: OK
rpg_rpg_classf     Check     Warning: Found row where the auto_increment column has the value 0
rpg_rpg_classf     Check     Status: OK
rpg_rpg_classf     Optimize     Status: OK
rpg_rpg_classm     Check     Warning: Found row where the auto_increment column has the value 0
rpg_rpg_classm     Check     Status: OK
rpg_rpg_classm     Optimize     Status: OK
rpg_rpg_element     Check     Warning: Found row where the auto_increment column has the value 0
rpg_rpg_element     Check     Status: OK
rpg_rpg_element     Optimize     Status: OK
rpg_rpg_race     Check     Warning: Found row where the auto_increment column has the value 0
rpg_rpg_race     Check     Status: OK
rpg_rpg_race     Optimize     Status: OK
rpg_rpg_type     Check     Warning: Found row where the auto_increment column has the value 0
rpg_rpg_type     Check     Status: OK
rpg_rpg_type     Optimize     Status: OK 


Why do i have a warning like this when I optimize the tables.
Also I dont know why but character names are always same with your location.
I thiink you miss coded something ovet there.Noone can update their names.

2 things for you:
First of all, those warnings appear because the rpg_rpg_type is of course auto_increment (since if you add more than one type you would get SQL errors if it didnt automatically increment by one.)
But the default value, the value that your users have BEFORE they update their stats, are "Unknown" which has an ID of 0.
I might change the numbers to have 1 be the default, but this would NOT work if you already installed the hack.
Dont worry about it

Second, please consult the FAQ_FRE file for solution to your RPG Name problem.
I will move that info over to the installer as it seems like everyone gets this problem

Originally Posted by Starscream

Revan, thanks for the dropdown in the postbit. It is perfect for my forum. All things seem to be running great on my site. I have even heavily modified/adapted the RPG elements to fit my site theme and everything has gone pretty smoothly and is operational.

I am having one minor problem concerning the dropdown. I can't figure out how to make the dropdown in the postbit become the default view. I like that you made it so you can choose between having the dropdown or not, but I wish the dropdown would be the default view. It's probably a simple change, but I can't see it. Any help would be very appreciated.

*Clicks Install*

You can make the dropdown be the default view by running these 2 queries:
[SQL]ALTER TABLE `user` DROP `rpgstats`;
ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '0';[/SQL]
0 is the dropdown value and 1 is the normal postbit value
(Just remember to run these seperately in acp, and in quick succession to avoid SQL errors if an user tries to update )
Thanks for clicking install btw

Originally Posted by SB2002

I have a question. I've divided the itemshop into different sections for the different classes, the only thing is, the only weapons people can buy are the generic ones, no matter what class they chose. When they access their classes weapons, it tells them that they must be that class to buy them.

ie i have a pistoleer class, and they should be able to buy the pistols, but whenever they go to that classes shop they are told they must be a pistoleer to purchase them...... any ideas?

Or do I have to just have everything as generic?

I believe you have to update the Classes as well. Currently all your classes are (probs) set to Generic type, and so they can only get Generic items
I have not done extensive testing on the Battle Types yet, but it will come in time



Thats about everything I guess
The Service Pack 1 that will update this hack to v2.5 build1 is in the works, with new bugs being squashed every day
I cannot tell an ETA yet, but heres the remaining sections to test:
* Itemshop
* User's Battle Types as discussed in the above quote
* Battle
* Healing

Finished sections:
* Entire ACP
* Entire ClanCP
* RPG CP

Additional work:
* Templates

[SB2002]

yeah, that was one of the first things i did (altering the classes etc into specific groups) and that is where the problem began, as the itemshop shows the classes, but when you clik them it doesnt actually let you buy the weapons for that class. If needs be I will drop in a test account, give it an rpg class and let you see what i mean.

[deathemperor]

Originally Posted by winlya

wow..cool hack..
I am waiting this hack a long time.
But I look this hack same RPG Inferno V1...

believe it or not, RPG Inferno is based on Bitsys' RPG hack and another old IB hack that I've used both of them. Bitsys' RPG has been here months (even more than 1 year) before ZT made RPG Inferno and honestly one of the reason drove me to use vb was the RPG hack.

@SB2002, there's no problem with the Itemshop, I've tested and I can buy any items I want while my class is generic and that item is for generic class.

But well the itemshop is messy, Revan. I asked you to let users have many items in their inventories, it meant: you can buy 10 swords in the weapon shop, 5 armors in the armor shop, 4 accessories and 13 potions in different kind from the Potions Shop, 7 spells from the spell shop but can only equip 1 weapon/1 armor/2 accessories/4 potions/3 spells at a time, and the total items you can buy is 30.

well that way everything would be very easy and comfortable for users. We don't need something like: If you want to let user has 2 weapon, create 2 weapon shop hence if I wish to let them own 10 swords I will have to forget everything to sit there and create items for the shops. But actually with this items system, If I create 10 weapon shops it means everyone will be able to have 10 weapons in battle.

my idea sounds troublesome huh ? it's ok, it's just MHO

[Revan]

death; yes I understand what you mean but it is not possible to let an user equip more items than theres categories.
At least not with the current way of storing items, an Im not sure its smart to go about redesigning the entire item storage database

Originally Posted by SB2002

yeah, that was one of the first things i did (altering the classes etc into specific groups) and that is where the problem began, as the itemshop shows the classes, but when you clik them it doesnt actually let you buy the weapons for that class. If needs be I will drop in a test account, give it an rpg class and let you see what i mean.

EDIT: I tried this on my localhost also, and I see what you mean now. Ill get right on fixing it.
EDIT2: I have fixed that bug along with some other small graphical bugs, expect a fully working itemshop in v2.5!

[SB2002]

splendid. Much appriciated. What sort of eta do you have on 2.5 as I have a board full of members wanting to buy things, lol

[Revan]

I dont really know, I have to finish writing the changelog for the itemshop.php as well as test every aspect of the battles.
Plus I hear DeMiNe0 got some errors for me in the showthread and showpost files....

Id rather not rush the new update, just to be sure I got all the errors.
Such as your error, at first I had this long step by step update gotten as to what I did to get it working (cos it LOOKED like it worked), but then after about 15 mins I saw "wtf this is bs it doesnt work *runs to edit post before he sees it and thinks Im dumb*"
Plus I think its dumb to release quickfixes, because this would just confuse users that downloads the new zip and sees the changelog and goes "hey I cant find this it tells me to find in the changelog!"

Im working thoroughly fast

[SB2002]

nah thats cool dude, no rush on it, i'll just throw a couple more arcade games at them to keep the masses happy, lol.

[Rahzel_hx]

i'm not able to reset the rpg stats it goes to a blank page

When i try to start the battle accepting it , it says invaild password or battle

i also get this error when i try to cancle a battle

PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQL: DELETE FROM battle WHERE battlenumber='1'
mysql error: Table 'spiritno_forum.battle' doesn't exist

mysql error number: 1146

Date: Saturday 21st of August 2004 03:00:45 PM
Script: http://--------/forum/battlefight.php?action=cancelbattle
Referer: http://--------forum/battlefight.php?action=enterbattle&battlenumber=1
Username: ----------
IP Address: ---------- 


Edit wish i could fix this my self but umm

PHP Code:

Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1318 


i get this when i goto look at users profiles

[Pixelgrounds]

have al lthe bug fixes iv read in this thread and all the little mods been added to the main page zip file yet?