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

[Mark.B]

I have something to report on the Lottery.

One of my members reported that they had a ticket with the jackpot numbers on, but it didn't pay out. On inspection I found it had done the draw, but not created a new one.

I then found out this member seems to have purchased over 600 tickets (!)

Is it possible that such a large number of tickets has caused the system to fall over? And would it also be a good idea to have limit on the number of tickets one member can purchase?

[Andrew Green]

I don't think it would, but I never tested it with that that many on the same draw...

I don't think I'll have time tonight, but tomorrow I should have time to try and break it, or at least figure out where it mighthave broken.

[Geez]

Database error in vBulletin 3.6.7:

Invalid SQL:
CREATE TABLE casino_settings (settingid integer NOT NULL PRIMARY KEY auto_increment,
settingname text, switch1 integer, switch2 text);

MySQL Error  : Table 'casino_settings' already exists
Error Number : 1050
Date         : Monday, October 29th 2007 @ 04:31:01 PM

can anyone tell me what to change in phpmyadmin to fix this? thank you

[Mark.B]

I've decided that, in common with a couple of others, I'd REALLY like the option of a third slots game with the 777 reel. Cos that reel looks great, but I don't want to lose the Ninja slots.

[Andrew Green]

Originally Posted by Geez

Database error in vBulletin 3.6.7:

Invalid SQL:
CREATE TABLE casino_settings (settingid integer NOT NULL PRIMARY KEY auto_increment,
settingname text, switch1 integer, switch2 text);

MySQL Error  : Table 'casino_settings' already exists
Error Number : 1050
Date         : Monday, October 29th 2007 @ 04:31:01 PM

can anyone tell me what to change in phpmyadmin to fix this? thank you

With .52 there is a file in the tools folder that should clean everything out, then you'll be able to uninstall (if you can't now) and then reinstall.

To do it manually delete all tables that start with casino_ plus the casino_credits field in the user table, then go to products -> edit and delete all the stuff under uninstall code for casino, uninstall and then install with the latest version.

[Geez]

thank you for your response.

this was in an attempt to INSTALL. use this same procedure anyways?

[Andrew Green]

Originally Posted by Geez

thank you for your response.

this was in an attempt to INSTALL. use this same procedure anyways?

Yes, I'm assuming you had a old version installed at one point and uninstalled? That's most likely where something failed, just needs to clean up so it can do it again.

[Geez]

oh ok i took over this board so maybe they tried to install this at one point. thank you very much, i will try this right now

[Andrew Green]

Originally Posted by Mark.B

I've decided that, in common with a couple of others, I'd REALLY like the option of a third slots game with the 777 reel. Cos that reel looks great, but I don't want to lose the Ninja slots.

I can add new 3 wheel set ups fairly easily, only pain in the but part is calculating the payouts, so a 3rd wheel is definitely doable.

[Mark.B]

Originally Posted by Andrew Green

I can add new 3 wheel set ups fairly easily, only pain in the but part is calculating the payouts, so a 3rd wheel is definitely doable.

Personally, I'm not fussed if it shares the same (or similar) payouts to one of the existing ones, though I realise that might not suit everyone.