Major Additions - Casino (w/ 10 player poker)

The Gameroom is the follow up to this, and expands on its features. This mod will no longer be supported, Gameroom is here: https://vborg.vbsupport.ru/showthread.php?t=219483

This is a casino addition for vBulletin, so far containing video poker, blackjack, Slots, a lottery, Let 'em Ride, Roulette and a betting pool.

It can use it's own cash as well as cash fields from other products for easy integration. Cash bonuses are also awarded for various actions (posting, starting threads, etc.), you can alter the bonus values through the admincp.

Each of the 10 games can be turned on or off through the control panel, and the casino can be restricted by user group.

I'd consider this a test run, everything should work, but some of the template's and all of the phrasing are not done yet.

Screenshots are attached.

If you want to see a demo, it's live at http://vbgaming.org, it does require registration though as it needs a userid to attach your money too Bug reports and requests can also be posted there, and will probably have less chance of getting buried in this rather massive thread. If you are having a problem, please look there. If it is one that others have been having, there will likely be a solution there (as well as in this thread, just harder to find here)

v 0.90 (Jan 6)
- Fixed a bug in lottery odds calculation that was casuing problems with the jackpot.
- Completed Phrasing of all games & admincp
- Removed card flicker some people experienced in Texas Hold'em
- Removed unused table limit setting from Video Poker settings
- Handled a DB error that occasionally came out of the slots game
- Sports Pool groups are now edited through the game, not the admincp
- Blackjack: Dealer checks for blackjack on A or 10
- Blackjack: Added Five card charlie rule
- Texas Hold'em: poker mod groups can now use the command "/kick username" to kick people out of the game. If a hand is in progress it counts as a forced fold, not returning their share of the pot.
- Blackjack - Fixed bug on bet amount when splitting more then once on a hand

v 0.91 (Jan 13)
- Added missing field for holdem mod groups to settings table
- Removed 0.90 test code of drawin same numbers in lottery
- Piped all the ajax files through casino.php, this should solve some of the conflicts people where having (ex. mkportal)
- Added missing link to add / edit groups in sports pool
- Fixed extra \'s in chatbox some users where getting
- Added a reset cash button in the ACP
- Fixed a bug where the blackjack_dealt table wasn't getting cleared properly
- Fixed "Most Lost" stat calculation


v 0.92 (Feb 18)
- Fixed Default Cash not saving
- Texas Hold'em no longer shows hand after folding
- Texas Hold'em buttons should not reappear after clicking if a request was in progress when they where clicked
- Fixed some of the reinstall issues people have been having

This is pretty minor, working on some major changes to the Texas Hold'em game that are taking longer then I planned due to other things coming up.

Known issues:
- The same player attempting to play more then one instance of the same game at the same time will cause errors.

To update overwrite all of the old files and import the product, revert any modified (casino) templates and don't forget the files in other folders Also some of the images have changed, those need uploaded again. (as well as the includes and admincp files) You DO NOT need to uninstall the previous version to upgrade, this will cause problems. Just overwrite existing files and import the product again, allowing overwrite.

**Make sure you overwrite ALL existing files and revert ALL casino templates**

[Andrew Green]

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.

[ezurick]

Originally Posted by Andrew Green

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...

[Andrew Green]

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

[paldo]

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

[Andrew Green]

Go to the game settings and turn them on.

[paldo]

they are on thats the first thing i checked

[paldo]

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

[DieselMinded]

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?

[ezurick]

Originally Posted by Andrew Green

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

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?

[Andrew Green]

Originally Posted by paldo

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

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

Originally Posted by DiesellMinded

Got multiple Database errors Last Night

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.

Originally Posted by ezurick

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?

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.