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

[sandt38]

I had a Texas Hold'em Tourney on my forum last night. It went flawlessly. I had a buy in and switched from vBCredits (my board currency) to casino_cash for markers (500/1500 respectively).

The one thing I did make a mistake on... I didn't create a special usergroup to lock others out of the casino. We had a few people straggle in and start playing with their 500 casino cash credits they are allotted via default. I created a new usergroup for the next time around.

Prizes were:
-Payouts were in casino cash converted to forum currency (so while buyin was 500, we paid out 1500, or the equivalent of casino cash they won)
-Special CT bragging on the poker champ. (will go to the next winner, so only 1 has this title at a time)
-$5000 in currency delivered to the new usergroup "Poker Champion" (to which I attatched the CT, obviously)

Just figured i would share an idea with you all to generate significant interest in the casino... it was great fun.

[Twilkey]

Originally Posted by peterpigman

getting this error when you bring up stats, I'm guessing it is a server prob and have contacted my host, am I correct?

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         : Sunday, October 28th 2007 @ 03:57:29 AM
Script       : http://forum.uncoverreality.com/casino.php?do=stats
Referrer     : http://forum.uncoverreality.com/casino.php
IP Address   : xxxxxxx
Username     : Peterpigman
Classname    : vB_Database

Contacting your host is what you needed to do.

Originally Posted by HO3R

Same error here with me!
I keep on looking!

Anyway great work

Greetz

Andrew is making an update so that this will not happen. Just keep looking back here for an update.

[Tulsa]

Question on texas hold'em play.

In one hand yesterday the table cards were a flush and each of the players only had a pair outside of the flush. The game called the hand a draw as the flush on the table was higher than anything with either players hold cards factored in. Is this typical play or should the flush have been ignored and at least one of each players cards been used to determine the winner?

Secondly I am still experiencing players freezing up and having to refresh their screens. Of course it shows as someone playing as suddenly left the game. Not sure if that is happening when they freeze up or when the refresh but I'm guessing it's when they freeze up as they don't immediately show as being back.

[TaBaTaN]

I tried uninstall with 0.50 didnt work, i tried wit 0.51 didnt work either

Database error in vBulletin 3.6.8:

Invalid SQL:
DROP TABLE casino_letitride_dealt;

MySQL Error : Unknown table 'casino_letitride_dealt'
Error Number : 1051
Date : Sunday, October 28th 2007 @ 12:35:05 PM
Script : http://www.netplay.com.ar/forum/admi...do=productkill
Referrer : http://www.netplay.com.ar/forum/admi...ctid=casino&s=
Classname : vB_Database

Please help me

[rungok]

In your xml-productfile you have to different approaches to the ' sign when putting it into the database. The second approach does not work and produces something like:

Let &epos;em Ride

The approach that works:
$query = "INSERT INTO casino_settings (settingname, switch1, switch2) VALUES ('gamename', 6, 'Texas Hold \'em')";

The approach that does not work:
$query = "INSERT INTO casino_settings (settingname, switch1, switch2) VALUES ('gamename', 7, 'Let &#3 9;em Ride')";

So you should use the first method on both games for your nest release. Not a big deal though. I just changed the title in the database myself, but that's not easy for everyone.

[SBlueman]

Originally Posted by Andrew Green

for everyone having installation / uninstallation issues:

I'll put together a update tomorrow afternoon that will be a complete rewrite of the intstall / unintall code. which will check for oddities rather then die on them.

Will also rename the range field completely for anyone using mysql 5.1 getting errors around that.

I noticed many people were bringing up the same issue so I just am quoting the mod author.

[Andrew Green]

Originally Posted by rungok

In your xml-productfile you have to different approaches to the ' sign when putting it into the database. The second approach does not work and produces something like:

Let &epos;em Ride

The approach that works:
$query = "INSERT INTO casino_settings (settingname, switch1, switch2) VALUES ('gamename', 6, 'Texas Hold \'em')";

The approach that does not work:
$query = "INSERT INTO casino_settings (settingname, switch1, switch2) VALUES ('gamename', 7, 'Let  9;em Ride')";

So you should use the first method on both games for your nest release. Not a big deal though. I just changed the title in the database myself, but that's not easy for everyone.

Newest version does do that, but won't update existing settings.

[Captain Kirk76]

I have a small feature request/suggestion.
the capability to buy multiple lottery tickets at the same time?

[rwilkins108]

Andrew, after updating to .51, I see the Let 'em Ride payouts are wrong again. They're doubled what they should be and that was fixed in .50.

Thanks

[Andrew Green]

Originally Posted by rwilkins108

Andrew, after updating to .51, I see the Let 'em Ride payouts are wrong again. They're doubled what they should be and that was fixed in .50.

Thanks

My understanding is that they are correct now, but where incorrect in .50.