This error is coming up about 30 times per day, how can I fix it???

I think this is a fantastic mod and my users love it. The only problem I have is my forum which has a fixed width of 760 doesnt display the roulette table properly. Is there any way to make the roulette table smaller?
Thanks.

For some reason my Texas Holdem has stopped working, it keeps showing

There are no free seats available, please try again later.

Players are set to ten. All the other games work without any problems

Tried updating to the latest version of the casino and the problem is still there

Any ideas

Thanks Lee

what is the Casino Cash this adds?

I added that as discussed. I never touched that part of the system before. Now I hope that stops the errors as there going up I get an email for each error. These seems to have started when I did the most recent upgrade to VB.

I have had none since I did that mod. It is a server setting apparently that causes it.

Had to turn off the roulette .. the ball has been round enough times to have gone to the moon and back and its still going :D

Db error for user names containing: '
e.g
john'sgirls

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE user
SET casino_cash = casino_cash + 10000
WHERE username = 'john'sgirls';

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 's'' at line 3
Error Number : 1064

=================================================

The ' in the users name is messing with the database.

Will be fixed tomorrow, as well as all the other things I know of (well, it's fixed now, will be posted tomorrow :D)

Andrew,

For all the games is the max bet $25, exept is this not possible for the roulette..
Yes, $25 fiches, but you can place 100 of them on the table.

Like a real roulette, is it possible to set a table limit, pretty please? :D

Andrew,

I mentioned this error some time back and you said to reapply settings in ACP, I did that and the error still exists...but I think I have narrowed down the problem.

It happens once per day, at the same time each night; between 9:01 and 9:04 pm. Some sort of CRON?

I'll have a look at the code again, it is the cron task that settles and adds draws that is causing it. But you are still having draws get created properly?

draws? what are draws?
:)

There are no numbers being created in the Lottery, if that's what you mean.

It doesn't show casino in my vbulletin admin option!

Why is this?
thanks

includes/xml/cpnav_casino.php probably didn't get uploaded.

is there a known issue with roulette paying out on zero?

hi,
i have a suggestion which could be interesting to most of Casino users.
is it possible to have Sound Effects for Casino games. specially Roullette and slots machine...

thanks

PS: will this product also be supported in vb 3.7.x ?

Yes, and the fixed version should go up tonight.

Yes, not sure how soon after the release though, depends on how much, if anything, needs to be redone

First of all, thanks for sharing this wonderful mod.

However, Im not sure my roulette is working correctly. I cant place bets on the table or I just dont know how. Clicking the chips and placing them on the board isnt doing anything.

Also, and I apologize if this double posts, but how do I enable javascript? One of the games states it needs it on.

ty

v.71 is up, fixes the bugs listed in the first post.

to place bets select the chip by clicking on it, it should get brighter. Then click on the board where you want to place it.

All games use javascript, so if it is telling you that ensure that all files got uploaded, relupload and overwrite the associated files, make sure the templates are the original versions, and if that doesn't work let me know, as well as which game and I will login and have a look.

Thanks for the quick reply. I just ULed .71 and I still cant get roulette to work nor the Video Poker with the JS issue. Im sure it's the user (me) but Im now getting portions of the roullete screen missing as well.

ok, I'll register tomorrow and have a look.

Andrew- great job.

One cosmetic issue only on the new release .71

Roulette screens are funky now. These were okay in .70

The corners wrap at the top and the bottom (top shown in pic)

1024x768

Works fine in Opera and Firefox... someone must be using a browser that has yet to follow standards ;)

I'll mess around with IE in the next couple days.

But if you like, there are two lines commented out in the _main template:

Just remove the comment wrappers, and the colspan='3' from the line below the first one and it should be back to normal

Yep, I use IE...and Yep that fixed it.

For those that have the same problem...

Edit template casino_roulette_main

find:

replace with:

Thanks Andrew!!

Andrew, didnt get any reply on this, but is this "table limit" an option in future updates?

After the update, I also have the same problem, changed the code and the rounded corners are fine now, but missing the pieces between the corners, like in the screenshot.
This is in IE and Firefox, only in roulette, not in Texas hold em.

Hi Andrew,

we where running version .51 and have upgraded to .71 I reverted all the templates uploaded all the files and have upgraded but we are getting random db errors especially when pressing stats which consistantly gives a db error, and texas holdem doesnt show anyone else in so if two people are playing they dont see each other. Any ideas? Thanks for all your work on this mod our members love it.

Database error in vBulletin 3.6.5:

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 : Tuesday, November 27th 2007 @ 04:29:16 AM
Script : http://www.ausjeepoffroad.com/forum/casino.php?
Referrer : http://www.ausjeepoffroad.com/forum/...=72210&page=15
IP Address : 124.169.141.225
Username : Dave
Classname : vb_database



http://www.ausjeepoffroad.com/forum/casino.php

Hey Andrew, on Let 'em ride, could you move the chips to below your dollar amount? when the game ends, and the chips get drawn, the board extends pretty far to the right.

Thanks!

Yeah, I am using IE (as most my users are using) and I applied this edit and now it is worse... The left corner is corrected, but the right one is off drastically and the piece between must be in cyber space somewhere... lol.

Also, since I updated to .71, when I play roulette... I click on a chip... no matter what number I select, it places the chip in the 2 to 1 slot. This didn't happen until I updated... something has changed and ruined the roulette fer me... :( It was working great until this update.

Lastly, and so berry important... is there a way to turn of the donations, or perhaps limit the amount. I see no settings. The reason is I have some hardcore users with amount in the hundred thousands... and they have either close friends or multiple accounts... and they place high bets in vbookie football games on both teams to get a sure win. So I restrict the amount to donate/transfer... but with the feature in casino, they are by passing my restriction... please help me correct this... Oh! I am using vbcredits 1.4RC1...

my lotto has not worked right at all and waited for this update to see if it would fix it... no luck tho...

I have been running the cron after every draw manually but now that wont work.
also I have not been able to get the box to show how many people are in hold 'em game, even on a stock VB template with placing the $inpoker at the bottom of the navbar template????

thanks for any help:D

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 : Tuesday, November 27th 2007 @ 01:20:47 PM
Script : http://www.********.com/forum/casino.php?
Referrer : http://www.********.com/forum/casino.php?do=blackjack
IP Address : #####################
Username : ********
Classname : vB_Database

==============================

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 : Tuesday, November 27th 2007 @ 12:47:24 PM
Script : http://www.####.com/forum/casino.php?do=stats
Referrer : http://www.####.com/forum/casino.php?
IP Address : ####
Username : ####
Classname : vB_Database

=========================

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 : Tuesday, November 27th 2007 @ 11:45:24 AM
Script : http://www.*****.com/forum/casino.php?
Referrer : http://www.*****.com/forum/casino.php?do=texasholdem
IP Address : *****
Username : *****
Classname : vB_Database

After last update, many things dont work anymore in IE, only in firefox.
No Texas Hold em, and Roulette isnt working (no fishes on table and buggy) and a lot of images aint working, they are called jpg instead of png.
Maybe also test on IE? :)

me either, with many problem with IE after upgraded.

after the last update lot of bugs!

I'll get back to you on that later today


What in Texas Hold'em isn't working?

All I can see in my rather quick IE test is that Roulette is rather buggered up, anything else?