I can not for the life of me get this to work, I install the mod, then go to the casino area in my admincp on the left side colum, click "casino settings" and get this
Code:
Database error in vBulletin 3.7.2:
Invalid SQL:
UPDATE casino_settings SET switch1 = WHERE settingname = 'ratebonus';
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 'WHERE settingname = 'ratebonus'' at line 1
Error Number : 1064
Request Date : Saturday, April 4th 2009 @ 01:25:44 PM
Error Date : Saturday, April 4th 2009 @ 01:25:44 PM
Script : http://www.documentingreality.com/forum/admincp/casino_settings.php
Referrer : http://www.documentingreality.com/forum/admincp/index.php?do=nav
IP Address : xxxxxxxxx
Username : xxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4-log
Then if I click "game settings" I get this
Code:
Database error in vBulletin 3.7.2:
Invalid SQL:
UPDATE casino_games SET
gamename = '',
imagefile = '',
description = '',
active = '',
chipsused = '',
tablelimit = ,
permissions = ''
WHERE gameid = 2;
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 '
permissions = ''
WHERE gameid = 2' at line 7
Error Number : 1064
Request Date : Saturday, April 4th 2009 @ 01:29:01 PM
Error Date : Saturday, April 4th 2009 @ 01:29:01 PM
Script : http://www.documentingreality.com/forum/admincp/casino_games.php
Referrer : http://www.documentingreality.com/forum/admincp/index.php?do=nav
IP Address : xxxxxxxxxxxx
Username : xxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4-log
I have read through this thread for people that have had a problem like this and the answer is always, "you can't leave a setting blank, if you want it zero make it zero" Well the problem is I can't edit any settings, it just throws that at me as soon as I click the settings area...
Any help would really be appreciated.