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

[Kingzor]

New sql error from a forum member.

Database error in vBulletin 3.5.4:

Invalid SQL:

               INSERT INTO rpg_ibot_templates
                       (`userid`,
                       `ibotid`,
                       `hp`,
                       `maxhp`,
                       `mp`,
                       `maxmp`,
                       `pp`,
                       `maxpp`,
                       `ap`)
               VALUES
                       ('443',
                       '2',
                       '200',
                       '200',
                       '25',
                       '25',
                       '30',
                       '30',
                       '0');

MySQL Error  : Duplicate entry '443' for key 1
Error Number : 1062
Date         : Saturday, April 15th 2006 @ 08:14:30 AM
Script       : http://www.hiberniagaming.net/vbull/monsterarena.php
Referrer     : http://www.hiberniagaming.net/vbull/monsterarena.php?do=newbattle&ibotid=2
IP Address   : x.x.x.x
Username     : Fosilex
Classname    : vb_database

[Revan]

The user must have had an ibot battle half-made or something, because that should not happen.
run DELETE FROM rpg_ibot_templates WHERE userid = 443 and DELETE FROM rpg_monster_battle WHERE userid = 443 and have him remake the battle.

[Tyegurl]

oh yes i did forget to tell you that i cannot creat I bots....

one more thing....how would i create a dropdown menu on the first navbar? i am getting rid of clutter in my navbar....added two dropdown menus all ready and would like to tidy up the 2nd navbar and move the links to the first navbar? not sure how i would get rid of the 2nd navbar though....

[Travis641]

If you were getting the error I was, then you need to edit:

	$db->query_write("
		INSERT INTO `" . TABLE_PREFIX . "rpg_ibots` 
			(`botname`,
			`levelrequired`,
			`cost`,
			`expdrop`,
			`cashdrop`
			`limitname`,
			`hp`,
			`maxhp`,
			`mp`,
			`maxmp`,
			`pp`,
			`maxpp`,
			`ap`,
			`xp`,
			`genderid`)

`cashdrop` needs a comma after it in /admincp/rpg_monsters.php which allowed me to make ibots.

[nadanada]

should clan invites be working?

[Tyegurl]

Originally Posted by Travis641

If you were getting the error I was, then you need to edit:

	$db->query_write("
		INSERT INTO `" . TABLE_PREFIX . "rpg_ibots` 
			(`botname`,
			`levelrequired`,
			`cost`,
			`expdrop`,
			`cashdrop`
			`limitname`,
			`hp`,
			`maxhp`,
			`mp`,
			`maxmp`,
			`pp`,
			`maxpp`,
			`ap`,
			`xp`,
			`genderid`)

`cashdrop` needs a comma after it in /admincp/rpg_monsters.php which allowed me to make ibots.

tyvm that worked

[Revan]

Originally Posted by nadanada

should clan invites be working?

They don't? I tested them thoroughly... :surprised:


As for that SQL error, thanks for spotting it.

I hope to release 3.5.2 soon, with some new features as well as a new Stats system that will be the first step towards returning the stats to their "former glory" so to speak.
I don't know exactly when this will be ready, but as soon as possible.

[Rated]

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `rpg_clans`
(
`clanid` int(10) UNSIGNED NOT NULL auto_increment,
`title` varchar(50) NOT NULL DEFAULT '',
`leader` int(10) UNSIGNED NOT NULL DEFAULT '0',
`clanpoints` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`logo` varchar(100) NOT NULL DEFAULT '',
`signature` VARCHAR( 255 ) NOT NULL DEFAULT '',
`ally` MEDIUMTEXT NOT NULL,
`enemy` MEDIUMTEXT NOT NULL,
`members` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1',
`maxmem` tinyint(3) UNSIGNED NOT NULL DEFAULT '5',
`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',
`col1` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col2` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col3` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col4` int(10) UNSIGNED NOT NULL DEFAULT '0',
`cm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`ci_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`rm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`midiurl` varchar(100) NOT NULL DEFAULT '',
`rank` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`clanid`)
) TYPE=InnoDB;

MySQL Error : BLOB column 'invite' can't have a default value
Error Number : 1101

[Decado]

I guess I'll get to work on those stats properly then, seeing as how everyone is waiting on the formulae for them.

[Ziki]

When my member wants to end a battle he can't.I tried to cancel his battle and it said

Warning: Invalid argument supplied for foreach() in /includes/class_rpg_battle.php on line 717

Any ideas?