Just to confirm, there is a bug in the lottery, has to do with how the odds are calculated which throws the JP off. This is fixed in my development version, so next update it will be gone. Replace existing file (includes/cron/ folder) with attached to solve it now, won't show fixed until a new draw is created.

Thanks Andrew... I updated with this, but now my Lottery is stuck on charging 2 credits when I have it set for 10. I refreshed over and over... I ran the Lottery Draw task manually... still stuck on 2. I know it was set and changed on 10 prior to this... I am not sure what happened...

Also, we started to try the Sports Betting in Casino on some football games. I settled them, but I can not see how what the jackpot is or how it was distributed. Me as the admin can't even see what a user won or lost. Is there plans to change this in your new version?

Thanks...

Until the existing draw is over a new one won't get created.

i just upgraded and lost all my big chips .. it goes to 10 bucks thats it

Go to the game settings and turn them on.

they are on ;) thats the first thing i checked

ok i went in and reset all the chips and clicked update settings now the entire area to set chip values is gone from the admin panel and still 10 bucks is as high as the chips go the last thing you see in settings is as far as it goes

https://vborg.vbsupport.ru/

Got multiple Database errors Last Night

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 @ 02:54:13 AM
Script : http://www.dieselbombers.com/casino.php
Referrer :
IP Address :
Username :
Classname : vb_database

Any Fix?

Yes, I understand that... but the ticket amount won't change until the new drawing? That's strange... Shortly after I installed the Casino I set it at 10. I refreshed my browser and went to the Casino Lottery and it showed 10. All I done was updated this latest file and ran the lottery task... I noticed that the ticket amount is now 2. I went to the settings and it is 10. I resaved it, refreshed my browser and went back to the Casino lottery and it is still 2. It is like it doesn't care what the admin settings are... I shouldn't have to wait until a new drawing to change the amount of the ticket, right?

They've just moved, the acp got restructured, look under "Casino -> Game Settings".

Need to add a index to switch1 in the casino_settings table, this can be done through phpmyadmin. Will also set the next update to do it on install.


When the admincp got reworked all of the settings reverted to their defaults, chips in use, names, descriptions and lottery settings. That's why it is back to 2.

You also cannot change a draw once it has been started, changes always effect the next draw created, never ones that are already up. The reason is, lets say the ticket price is 1, I but 10 tickets, you change the ticket price to 10, this effects jackpots and has other people paying more then I did for the same tickets. Another problem is lets say I pick the numbers 10, 15 & 23. Then you go and change the number range to 1-15, yet I have a ticket with 23 on it.