[BuckRodgers]

Originally Posted by Andrew Green

Strange, should be rendering that as a '

You can rename games and rewrite the descriptions in the CP, so change it there

when i try to save the changes i get

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         : Monday, October 22nd 2007 @ 12:30:41 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+%26apos%3Bem+Ride&gamedesc7=5+Card+stud+variation&gameactive7=1&submit=Update+Games
Referrer     : http://www.datadrome.co.uk/forum/admincp/casino_settings.php
IP Address   : ***********
Username     : samorite
Classname    : vb_database

any ideas ?