[BuckRodgers]

okie done update got a few problems,

1, ninja slots. when you place your bet the reels just keep spinning never stop ?

2, more stats. when i click on the more stats still getting db error

Database error in vBulletin 3.6.8:

Invalid SQL:

		SELECT bet, won, cs1.switch2 
		FROM casino_settings AS cs1
		LEFT JOIN casino_settings AS cs2 ON cs1.switch1 = cs2.switch1  
		LEFT JOIN casino_bet_stats ON cs1.switch1 = gameid 
		WHERE cs1.settingname = 'gamename' 
		AND cs2.settingname = 'gameactive'
		AND cs2.switch2 = '1' 
		GROUP BY gameid;

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         : Wednesday, October 24th 2007 @ 01:46:45 PM
Script       : http://www.datadrome.co.uk/forum/casino.php?do=stats
Referrer     : http://www.datadrome.co.uk/forum/casino.php
IP Address   : 
Username     : Samorite
Classname    : vb_database

3, admin cp, in "Games Available" when i try to update settings i get this db error

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         : Wednesday, October 24th 2007 @ 01:49:39 PM
Script       : http://www.datadrome.co.uk/forum/admincp/casino_settings.php?gamename1=Video+Poker&gamedesc1=Jacks+or+better+to+win.&gameactive1=1&gamename2=Blackjack&gamedesc2=Classic+Casino+Game.&gameactive2=1&gamename3=Sports+Betting+Pool&gamedesc3=Place+bets+on+upcoming+events.&gameactive3=1&gamename4=Lottery&gamedesc4=Buy+into+the+lottery&gameactive4=1&gamename5=Slots&gamedesc5=3+wheel+slot+machine&gameactive5=1&gamename6=Texas+Hold+&gamedesc6=Limit+game+of+Poker%2C+up+to+10+players&gameactive6=1&gamename7=Let+em+Ride&gamedesc7=5+Card+stud+variation&gameactive7=1&gamename8=Ninja+Slots&gamedesc8=3+wheel+ninja+slot+machine&gameactive8=1&submit=Update+Games
Referrer     : http://www.datadrome.co.uk/forum/admincp/casino_settings.php
IP Address   : 
Username     : Samorite
Classname    : vb_database

any help is greatly recived as allways