RPG Integration Hack

[high]

RPG Integration Hack v3.5.1 Patch Level 2

[/high]
RPG Integration Hack (RPG hack for short) v3.5.1 is the first step into the next generation of the classic hack compiled by Bitsys. For those that are unfamiliar with any of what I mentioned above, heres a quick rundown of what this hack is and does.
The RPG hack adds a whole new level of fun to a forum, by allowing uses to duke it out in a fierce battle. Use items to turn the tide of the battle, or use powerful spells to bring down an opponent. Or you can just rely on the good old sword to cut your enemy down to size!
Create or join a clan to amass an army and conquer the boards.
Patch yourself up after a hard battle.
Feeling lucky? Go bet on the lottery!

No RPG forum should be without. Administrator controls every single aspect of how the hack works, right down to every item and an user's level/stat gains.


[high]Important Notices:[/high]

1. You need an external Cash mod installed for this mod to function properly.
   • uCash/uShop or vBPlaza, either will do
   • The Cash mod need to use the `user` table
   • You need to configure a setting in the RPG Integration Hack - Cash Options after install/upgrade

[high]Known Issues:[/high]

1. Regular postbit doesn't contain RPG info
2. RPG Manual is still outdated

These are all issues that will be addressed in upcoming versions.



[high]Upgrading Users:[/high]
What's new in v3.5?

• OOP coding for query efficiency
• Revamped templates
• New Battle formulas (Thanks to Decado)
• Works with AJAX Quick Reply/Quick Edit
• Reoccurring Lotteries
• Improved Healing Center
• Inventory feature for the ability to carry multiple items from same item category
• RPG Info no longer changeable on the fly
• And last, but not least: [high]NO FILE EDITS![/high]

For support, please visit the RPG Integration Hack Support Forums
All support queries in this thread will be ignored by me.

If you use this mod,

Click it!


If you wish to support me in the development of the hack,

Your donations are most appreciated

[Replicators]

Just ignore that step

[xlegends]

Originally Posted by Replicators

Just ignore that step

Thanks rep, everything installed fine and I can enter the different scripts of the hack.

Having huge db problem, I cant seem to save the character creation which is required before doing anything,.,.


Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE rpg_user SET
ap = 60,
maxhp = 45,
maxmp = 33,
maxpp = 53,
hp = 45,
mp = 33,
pp = 53,
elementid = 2,
alignmentid = 2,
raceid = 2,
genderid = 3,
classid = 61,
typeid = 1,
inputlevel = 0,
dropdown = 1,
canchallenge = 1,
rpgname = 'DBG'
WHERE userid = 7105;

MySQL Error : Unknown column 'inputlevel' in 'field list'
Error Number : 1054
Date : Saturday, March 25th 2006 @ 07:53:41 AM
Script : /http://www.xxxxxxxxxx.com/forums/headquarters.php
Referrer : /http://wwwxxxxxxxxxx.com/forums/headquarters.php?

[Ziki]

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(`monsterbattleid`) AS `ibotbattles` FROM `forumziki_rpg_monster_battles`;

MySQL Error : Unknown column 'monsterbattleid' in 'field list'
Error Number : 1054
Date : Friday, March 24th 2006 @ 11:28:47 PM
Script : http://www.zikihideout.com/forums/monsterarena.php?
Referrer : http://www.zikihideout.com/forums/monsterarena.php?
IP Address : 87.197.143.145
Username : ZIKI-SET
Classname : vb_database

Revan can you please look at it?There are tables missing...

[Revan]

I will release an update that will fix all these issues in 5 minutes.

[Revan]

Beta 5 Released

I had to make this quick update because I messed up badly on the SQL tables, causing many people to have errors.
Terribly sorry for the mess, it should all be good now.

[Replicators]

We don't expect you to be perfect >8)

EDIT: Encountered this error while making a monster battle..

Database error in vBulletin 3.5.4:

Invalid SQL:

		INSERT INTO sf_rpg_monster_battles 
			(`owner`,
			`opponent`,
			`battlestate`,
			`turnid`,
			`lastactive`,
			`wager`,
			`sceneid`,
			`musicid`) 
		VALUES 
			('1',
			'32',
			'1',
			'1',
			'1143295803',
			'3',
			'4',
			'0');

MySQL Error  : Unknown column 'musicid' in 'field list'
Error Number : 1054
Date         : Saturday, March 25th 2006 @ 06:10:03 AM
Script       : http://***.******.***/monsterarena.php
Referrer     : http://***.******.***/monsterarena.php?do=newbattle
IP Address   : **.**.***.***
Username     : Replicators
Classname    : vb_database

[Revan]

[sql]ALTER TABLE `rpg_monster_battles` CHANGE `midi` `musicid` INT( 10 ) NOT NULL DEFAULT '-1'[/sql]
remember to add a table prefix.
Also will be updating the file shortly.

[Replicators]

That worked, but then i got this...

Database error in vBulletin 3.5.4:

Invalid SQL:

		INSERT INTO sf_rpg_ibot_templates 
			(`userid`,
			`ibotid`,
			`hp`,
			`maxhp`,
			`mp`,
			`maxmp`,
			`pp`,
			`maxpp`,
			`ap`) 
		VALUES 
			('1',
			'1',
			'30',
			'30',
			'10',
			'10',
			'7',
			'7',
			'0');

MySQL Error  : Duplicate entry '1' for key 1
Error Number : 1062
Date         : Saturday, March 25th 2006 @ 08:07:56 AM
Script       : http://***.******.***/monsterarena.php
Referrer     : http://***.******.***/monsterarena.php?do=newbattle
IP Address   : **.**.***.***
Username     : Replicators
Classname    : vb_database

[Revan]

That's because the battle creation halted where it shouldn't have. Run these two:
[sql]TRUNCATE TABLE `rpg_monster_battles`[/sql]
[sql]TRUNCATE TABLE `rpg_ibot_templates`[/sql]

[Otikeu]

So, how do we update from (I believe BETA 1) to BETA 5?

Also a feature request. Maybe save a payment history, incase someone like me needs to revamp their item choices (aka remove spells for different types) and will like to refund all money spent for the items? I'd be a life saving feature...