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

[TazeredBlackMan]

Originally Posted by Andrew Green

Everything I know about has been fixed, what issues where you having?

For BJ: The issue where if you bet 250 dollars and the dealer matches your hand, there is a ridiculous payout.

Roulette: The placement of the ball is still off.

[wolfyman]

Originally Posted by Andrew Green

Then anyone in one of those groups should see a "add event" link at the bottom of the "Open events" section.

Ahhhh gotcha, now I find it. How do I change the style? My "Add event" link is the same color as my background lol!


Also, can I add more Possible Outcomes?

[Bounce]

Any plans for a 3.7.x version as Texas Holdem has stopped working

Serves me right for upgrading I suppose

[Andrew Green]

Once 3.7 goes gold I'll do a 3.7 version, until then I plan on just finishing this one off.

[wolfyman]

Originally Posted by hIBEES

Any plans for a 3.7.x version as Texas Holdem has stopped working

Serves me right for upgrading I suppose

glad I didn't upgrade.

[wolfyman]

you know, I love the sports betting bit. I'd love to see that refined.

Such as go into sports betting, choose your sport, then see the open bets; rather than simply a list of all open bets.

[mastertek2000]

I only have one problem - Texas Hold 'Em worked when i first installed. Once i posted to the board for people to test EVERYONE (inc me) gets the message "This game is AJAX powered and requires javascript to be turned on"

I also see others with this same problem - any help is appreciated
thanks

[Andrew Green]

Originally Posted by mastertek2000

I only have one problem - Texas Hold 'Em worked when i first installed. Once i posted to the board for people to test EVERYONE (inc me) gets the message "This game is AJAX powered and requires javascript to be turned on"

I also see others with this same problem - any help is appreciated
thanks

Send me a link to the site and I'll have a look.

[Bounce]

Originally Posted by Andrew Green

Once 3.7 goes gold I'll do a 3.7 version, until then I plan on just finishing this one off.

Fair enough, how do i uninstall all the tables..

I uninstalled the product from admincp but now that folk go to play it I'm getting DB errors

PHP Code:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_casino AS phrasegroup_casino,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 

WHERE user.userid = 209;

MySQL Error   : Unknown column 'language.phrasegroup_casino' in 'field list' 


HOW do I remove everything the casino installed

Originally Posted by wolfyman

glad I didn't upgrade.

aye lol

[wolfyman]

quick notes:

It should not be possible to double down when the dealer has blackjack.
The dealer shouldn't play when the player busts, it should just be "hand ended".