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

[Virulent1]

revan, if i were to install the lottery part ONLY and not the RPG stuff will it work properly with Ushop?

[Valr the Slain]

Hello,
I recently tried to install this hack and came up with this error:

Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_items_options` (
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '0',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
) TYPE=MyISAM;
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 11

mysql error number: 1064

Any possible ways to fix this?

Thank you.

[Revan]

Originally Posted by Valr the Slain

Hello,
I recently tried to install this hack and came up with this error:

Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_items_options` (
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '0',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
) TYPE=MyISAM;
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ') TYPE=MyISAM' at line 11

mysql error number: 1064

Any possible ways to fix this?

Thank you.

Ugh... find this:
[sql]
`hidelevel` tinyint(4) NOT NULL default '0',[/sql]
change to this:
[sql]`hidelevel` tinyint(4) NOT NULL default '0'[/sql]

Originally Posted by Virulent1

revan, if i were to install the lottery part ONLY and not the RPG stuff will it work properly with Ushop?

No clue.
Its worth a test, but I cannot provide support should anything go wrong

[HiDeo]

Nice hack, thanks

[DaPro]

Ok guys, I have fixed my install problems that most of you were having, so if you would like help, please use my battleinstall.php file and preform these few simple tasks.

*Note: I am not an experienced PHP coder, I am just trying to help myself and others, I will not offer support for this fix, so don't PM me! LOL

Now go into your PHPMYADMIN and go into your users table. Now DROP the following rows before you try to reinstall with the fixed install:

DROP rpgclass
DROP rpgrace
DROP alignment
DROP rpgtype
DROP rpggender
DROP hp
DROP maxhp
DROP ma
DROP maxma
DROP pp
DROP maxpp
DROP ap
DROP element
DROP inbattle
DROP clan
DROP xp

Now after that is all done, we need to clean out all of those old RPG tables added by any previous install attempt. So loud up the installer/installer.php files and click delete on the side menu. Go into your PHPMYADMIN and make sure they were all deleted. If you get an error when you click, don't worry, I got that too :P

Now you are safe to upload the battleinstall.php and run the install. If it says Success or Install OK, then you are GOOD2GO. If you have problems, post here, no PM's!

[Revan]

Originally Posted by DaPro

Ok guys, I have fixed my install problems that most of you were having, so if you would like help, please use my battleinstall.php file and preform these few simple tasks.

*Note: I am not an experienced PHP coder, I am just trying to help myself and others, I will not offer support for this fix, so don't PM me! LOL

Now go into your PHPMYADMIN and go into your users table. Now DROP the following rows before you try to reinstall with the fixed install:

DROP rpgclass
DROP rpgrace
DROP alignment
DROP rpgtype
DROP rpggender
DROP hp
DROP maxhp
DROP ma
DROP maxma
DROP pp
DROP maxpp
DROP ap
DROP element
DROP inbattle
DROP clan
DROP xp

Now after that is all done, we need to clean out all of those old RPG tables added by any previous install attempt. So loud up the installer/installer.php files and click delete on the side menu. Go into your PHPMYADMIN and make sure they were all deleted. If you get an error when you click, don't worry, I got that too :P

Now you are safe to upload the battleinstall.php and run the install. If it says Success or Install OK, then you are GOOD2GO. If you have problems, post here, no PM's!

Thank you very much, if this really does help the other users then you are getting a place in the first post in the thanks section
I'll wait to see if people report error fixed before I update the first zip

[DaPro]

Thanks, I just try to help, I will also be re-doing all the RPG templates to make them look more vB Intergrated than off with the style. I should have it done sometime by next week I hope, because there are alot of templates and doing them all today is out of the question :P LOL.

[MayhemSI]

Finally! an installer that works! I had given up on this hack after about 30 minutes of messing with the script.. I'm lazy.. what can I say.. hehe

[DaPro]

Glad to have helped! Well, hopefully it will serve others well, it did take me alot of messing around with the whole shabang of this hack to actually get the damn thing running right. LOL, so the installer unfortunately is only half the battle. No offense to the makers of this port, but there should have been a little wait until you fixed most of the kinks, more beta testing and what not. I would ask for more reorganizing in the readme.

Hopefully my new templates will make it look nicer as well.

[Revan]

Um just FYI the v2.5 Gold version fixes all bugs, apart from apparently this installer.
And the readme IS as organised as it gets... what version did you dload anyways? :ermm:

Aight if the installer works Ill update the zip and send out an update....