[BuckRodgers]

yaaaay all back working just got the admin error now

Database error in vBulletin 3.6.8:

Invalid SQL:

		SELECT cs1.switch1 AS gameid, cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active
		FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4    
		WHERE cs1.switch1=cs2.switch1 
		AND cs1.switch1= cs3.switch1 
		AND cs1.switch1= cs4.switch1 
		AND cs1.settingname='gamefile' 
		AND cs2.settingname='gamename' 
		AND cs3.settingname='gamedesc'
		AND cs4.settingname='gameactive';

MySQL Error  : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date         : Sunday, October 21st 2007 @ 07:19:50 PM
Script       : http://www.datadrome.co.uk/forum/admincp/casino_settings.php
Referrer     : http://www.datadrome.co.uk/forum/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct
IP Address   : **********
Username     : Samorite
Classname    : vb_database

anyway to sort that ? I know i asked ya earler but while i got ya in the zone :P