Superb mod - my members love it !

I only have one problem - Texas Hold 'Em worked when i first installed. Once i posted to the board for people to test EVERYONE (inc me) gets the message "This game is AJAX powered and requires javascript to be turned on"

I also see others with this same problem - any help is appreciated

My setup:
vb 3.6.4
Vista / IE7

What Query do i send to the database im getting 10 of these database emails every 12 hours

Re: What did you do to do this
Quote: Originally Posted by DieselMinded
Quote: Originally Posted by MEMBER
Quote: Originally Posted by DieselMinded
Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT sum(bet) AS bet, sum(won) AS 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 : Monday, December 31st 2007 @ 06:46:05 PM
Script : http://www.dieselbombers.com/casino.php?
Referrer : http://www.dieselbombers.com/
IP Address : ipipipipipip
Username : MEMBER
Classname : vb_database


????

Did you get an error in the casino a little bit ago?


Ya I had $70 and tried to bet $100

Hi Andrew... Ok, that makes sense. I'll wait until the next drawing for it to change to the correct amount.

Is there a quick fix to remove games that are not active from the Casino menu? I thought you had this fixed at one time... not sure, but I don't use the Texas Hold 'em... and it is annoying to have users constantly ask about it cause it is on the Casino menu, but when they click it, they get the typical vb error of not having permission.

Thanks for your great Mod! And Happy New Year!!!

Andrew! Help! I just setup a Sports Bet for the NFL playoffs... AFC and NFC having multiple games for each. I saved them and refreshed my browser... Now I get a database error with no details. How frustrating. I can't do anything because of this error. I can't even get into my adminCP... anything I do I get a database error.

[Edit] Andrew... Nevermind. I figured it. I needed to change something in my config.php file so the admin could change the admin user account... I uploaded it and didn't realize it had the wrong database name in it... False alarm... Sorry....

is it possible to add more games.... like No limit holdem?

No query, do it through phpmyadmin.

Select the table, it will show the structure, beside each field there will be a bunch of little boxes, click the one that says "index"

Thanks Sir

I have a bit of a weird problem. In my casino, I have all the chips set up and I can see them.

It does not allow me to choose the 500 and 100 for some reason. That is as high as it goes and its just those two.

I combed the settings and couldn't figure it out. I also unchecked and rechecked all, after that re saved the overall casino settings.

EDIT--Sorry, I figured it out. Table limit field.

I love this. I just wanted to add that so far this is working fine with 3.7 beta 3.