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]

Invalid SQL:
SELECT casino_cash FROM vbuser AS user WHERE userid =;

Pretty sure I found the problem with this, will post a fix later today.

[Robbed]

Where still having problems with the payouts and payout alignment.

[Andrew Green]

Originally Posted by Robbed

Where still having problems with the payouts and payout alignment.

What site is this on?

[Robbed]

<a href="http://thebreakaway.net/forums" target="_blank">http://thebreakaway.net/forums</a>

u: test
p: test

Another issue, no lottery winners but in stats it shows
Lottery 13375 23655 177%

[Andrew Green]

Originally Posted by Robbed

http://thebreakaway.net/forums

u: test
p: test

Another issue, no lottery winners but in stats it shows
Lottery 13375 23655 177%

payout problem is that you have a older version of the slotwheel image in there, New one doesn't have banana's at all so it's showing different results then it thinks it has.

The other one, not sure, that one is odd. I'll play with it a little and get something that works in.

[dyna88]

Ok I figured out I got this error because I didn't enter an amount when I tried to reset the amount...

Database error in vBulletin 3.6.7:

Invalid SQL:

			UPDATE vb3_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 15th 2007 @ 01:28:09 PM
Script       : http://........../casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash
Referrer     : http://........../casino_settings.php
IP Address   : XXX.XXX.XXX.XXX
Username     : XXXXXX
Classname    : vb_database

[Andrew Green]

Originally Posted by jay007

im getting a database error after an install, any suggestions/Help greatfully appreciated.
THX

Database error in vBulletin 3.6.8:

Invalid SQL:

							SELECT cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active
							FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4    
							WHERE cs1.switch1=cs2.switch1 
							AND cs1.switch1= cs3.switch1 
							AND cs1.switch1= cs4.switch1 
							AND cs1.settingname='gamefile' 
							AND cs2.settingname='gamename' 
							AND cs3.settingname='gamedesc'
							AND cs4.settingname='gameactive'
							AND cs4.switch2='1';

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

This is a difference in your mysql settings not liking that query, I'll rework it into something simpler with the next update.

[hoopsta]

Is it possible to have stats for -

Top Casino Winners - Day
Top Casino Winners - Week

This might encourage more competition for those who don't show up on the overall winner board.

Also, it would be cool if down the road the Texas Hold 'Em was set up with a TOURAMENT feature where members had to "BUY IN" (say for $1,000 or so and play until they drop out or have no money left) so that a tournament could be held with a defined winner.

*not that you don't have enough time doing other stuff... just a thought!

thx

[Andrew Green]

Originally Posted by hoopsta

Is it possible to have stats for -

Top Casino Winners - Day
Top Casino Winners - Week

This might encourage more competition for those who don't show up on the overall winner board.

The with the way those numbers are tracked, it's a one or the other thing. I could add a option to have them clear weekly or monthly, but no dates are tracked, just totals.

Also, it would be cool if down the road the Texas Hold 'Em was set up with a TOURAMENT feature where members had to "BUY IN" (say for $1,000 or so and play until they drop out or have no money left) so that a tournament could be held with a defined winner.

*not that you don't have enough time doing other stuff... just a thought!

thx

Have to get all the bugs out of the stuff I have in there before thinking about what else I want to do

[FreeFall1]

Hi im still getting this database error when i try to install, it looks like the Casino_Cash has been duplicated, anyone know how i get this sorted??

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Monday, October 15th 2007 @ 12:15:08 PM