[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