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

[DS MrSinister]

Originally Posted by Major Miner II

Hey - I'm having a couple of problems. First - while installing the hack I could not complete this option.



Second - I can't find the RPG Admin area - lol. Where do I find that?

Third - after installing this I get the following error on ALL old messages. Not new ones.

you have to change uttpoints to ucash or ebux on which point system you are running..

Admincp

RPG Navigation --> RPG Integration Hack Menu --> RPG Options --> Itemshop Options

or

vBulletin Options --> RPG Integration Hack - Cash Options

[Major Miner II]

great! fixed that - and apparently I have a permissions issue keeping me from seeing the RPG stuff.

[Major Miner II]

I'm all good! woohoo! thanks to all responsible for the hack and thanks for those who helped me.

[bubba1977]

Originally Posted by Revan

Well this aint the eBux thread is it
My RPG didn't add that code and hence I can't give support for it.

thanks... i slipped up when updateing ebux / eshop.

[blablablabla]

does it work on vbulletin 3.5.3?

[Replicators]

It works with 3.5.4 so yea, i cannot wait for the next version, i wanna kill monster's.

[ffevo]

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `.sqlrpg_alignments` 
(
	`alignmentid` int(10) unsigned NOT NULL auto_increment,
	`alignmentname` varchar(50) NOT NULL DEFAULT '',
	`alignmentleader` varchar(50) NOT NULL DEFAULT '',
	PRIMARY KEY (`alignmentid`)
) TYPE=InnoDB;

MySQL Error  : Incorrect table name '.sqlrpg_alignments'
Error Number : 1103
Date         : Friday, March 3rd 2006 @ 09:46:13 PM
Script       : http://www.squaresyndicate.com/forum...ller/index.php
Referrer     : http://www.squaresyndicate.com/forum...ller/index.php
IP Address   : 209.165.35.111
Username     : Loathor__Healer
Classname    : vb_database

What the hell. Okay. I get this error while trying to create the tables. right?

PHP Code:

$this->query("
            UPDATE `" . TABLE_PREFIX . "setting` SET 


SEE THAT ` before the " <-- if I remove that. it works Pefect.

and then.. Ill install it. and then.. when I want to get to ANY ++++ing Page. I get the same Error. wtf??

[Revan]

Your table prefix does not comply with MySQL standards. That's what causes the error, and I used the ` everywhere just because it is MySQL standard.
Please change your table prefix using tableprefix.php from the original vBulletin installation.

[Sykoi]

I'm having some problems with the install...
During the first time, I had gotten to the 16th or 17th step but had forgotten to change my old installion's (From 3.0.x) cash field name from uttpoints (Doesn't exist) to ebux (What I use now), and it spit out the following error:

Invalid SQL:

SELECT
user.`userid`,
user.`username`,
user.`clan`,
user.`rpgclass`,
user.`rpgrace`,
user.`alignment`,
user.`rpgtype`,
user.`rpggender`,
user.`hp`,
user.`maxhp`,
user.`ma`,
user.`maxma`,
user.`pp`,
user.`maxpp`,
user.`ap`,
user.`element`,
user.`inbattle`,
user.`xp`,
user.`chalable`,
user.`rpgstats`,
user.`inmonsterbattle`,
user.`uttpoints` AS `points`,
rpg_clan.leader_old,
rpg_clan.clanid,
rpg_battle_stats.battles,
rpg_battle_stats.wins,
rpg_battle_stats.losses,
rpg_battle_stats.draws,
rpg_battle_stats.retreats,
rpg_items_user.*,
userfield.rpgname AS rpgname
FROM vb3_user AS user
LEFT JOIN vb3_rpg_clan AS rpg_clan ON(rpg_clan.clanid = user.clan)
LEFT JOIN vb3_rpg_items_user AS rpg_items_user ON(rpg_items_user.userid = user.userid)
LEFT JOIN vb3_rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid = user.userid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
WHERE user.`userid` >= 1
AND user.`userid` < 21;

MySQL Error : Unknown column 'user.uttpoints' in 'field list'

Now I've obviously fixed this, but ran into another problem... I can't get past step 3 because I've already went through these steps.
So, how do I manually bypass the steps I've done?

[ffevo]

Im wondering. Thanks for telling me to change that.

Im using The Itemshop Know. For Points. Is their a way I can intergrate this RPG with that hack?