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

[leeman]

Originally Posted by Andrew Green

Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?

I get it as soon as I click the link to the game ....

Where the cards should be I guess ...

[BuckRodgers]

ok thanks for the admin patch thats worked fine but when i click on more stats i get

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, casino_settings AS cs2, casino_bet_stats 
		WHERE cs1.settingname = 'gamename' 
		AND cs2.settingname = 'gameactive'
		AND cs1.switch1 = gameid 
		AND cs2.switch2 = '1' 
		AND cs1.switch1 = cs2.switch1 
		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

and when i click on let em ride it just goes back to the casino main menu ?

[Mark.B]

Originally Posted by samorite

and when i click on let em ride it just goes back to the casino main menu ?

I think the original casino.php file that was uploaded was missing a couple of lines that would solve that.

Looking at the ZIP file now, the lines are present, so if you redownload and replace the casino.php file, it should work.

[Andrew Green]

Originally Posted by samorite

ok thanks for the admin patch thats worked fine but when i click on more stats i get


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

ok, not allowed to connect more then 2 tables at a time... got it.

and when i click on let em ride it just goes back to the casino main menu ?

Upload and overwrite the casino.php file

[Mark.B]

I've only just spotted this, but the new texasholdem_ajax.php file seems to be causing the game to refuse to load, just showing the start button which has no effect.

Reverting to the old file fixes it.

[blind-eddie]

I am getting alot of db errors when I try to reset cash....

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user 
SET casino_cash =;

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 '' at line 2
Error Number : 1064
Date         : Monday, October 22nd 2007 @ 03:53:54 AM
Script       : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer     : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user 
SET casino_cash = o.oo;

MySQL Error  : Unknown table 'o' in field list
Error Number : 1109
Date         : Monday, October 22nd 2007 @ 03:55:10 AM
Script       : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=o.oo&submit=Adjust+Cash
Referrer     : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE user 
SET casino_cash =;

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 '' at line 2
Error Number : 1064
Date         : Monday, October 22nd 2007 @ 03:55:46 AM
Script       : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer     : http://outerzone.us/forum/xxxxxxx/casino_settings.php

[Andrew Green]

Originally Posted by blind-eddie

I am getting alot of db errors when I try to reset cash....

You're trying to reset to zero?

Put "0" in the field.

Leaving it blank won't work, decimals aren't needed.

[BWilliams]

Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146

Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.

[Andrew Green]

Originally Posted by BWilliams

Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146


Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.

phpmyadmin and enter the following:

DROP TABLE casino_texasholdem_whoisin;
CREATE TABLE casino_texasholdem_whoisin (whoisinid integer NOT NULL PRIMARY KEY auto_increment, userid integer, seat integer, lastcheck integer, status integer, bet integer);

DROP TABLE casino_texasholdem_chatlog;
CREATE TABLE casino_texasholdem_chatlog (chatlogid integer NOT NULL PRIMARY KEY auto_increment, msg text, msgtime integer);

DROP TABLE casino_texasholdem_dealt;
CREATE TABLE casino_texasholdem_dealt (dealtid integer NOT NULL PRIMARY KEY auto_increment, playerid integer, card integer);

Where you upgrading or installing from scratch?

[aggiefan]

has there been any movement on a "who is in the casino" option for the "Whats going on?".... would be very nice to be able to tell who is in a game of texas holdem especially since its multiplayer.