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]

Originally Posted by kylek

Only thing I can see right now is that it names the casino - Innovative Martial Arts Casino. Will have to search to see where it can be changed.

I'll track that down and fix it for the next update, thought I'd go all of them.

A question - When setting up first draw in Lottery the jackpot had a number already set, I think in one site it was $24320.00 Is this resettable? It would be nice if we could have a set amount to start out with.

Draw amount is based off of the range and number of balls and price, it's setup to calculate a jackpot that will maintain about 100% win, and increases over time until it's won. I could add a option to manually edit it though.

A suggestion or two - instead of showing richest users top 10 could it maybe just show the top 10 members who have made the most in the casino? Have it separate from total points (use vbcredits which has option to keep amounts private) as some members do not like others seeing how much they have.

Yes, it does track a number of stats that aren't being used for anything yet, so in later versions there should be more available.

And the possibility of adding a $25 or $50 token for the big spenders. So poker and blackjack would have $1, $5, $10, and $25 or $50.00

Yes, it's in the plans, as well as a switch to allow each amount in the admincp.

[kiril_cvetkov]

When i want to uninstall this modification - i get mysql error

Database error in vBulletin 3.6.8:

Invalid SQL:
ALTER TABLE user DROP '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 ''casino_cash'' at line 1
Error Number : 1064
Date         : Tuesday, October 2nd 2007 @ 07:29:01 AM
Script       : http://www.bryansrequestsite.com/forum/admincp/plugin.php?do=productkill
Referrer     : http://www.bryansrequestsite.com/forum/admincp/plugin.php?do=productdelete&productid=casino&s=
IP Address   : 85.30.68.39
Username     : kiril_Cvetkov
Classname    : vb_database

Can i uninstall this when i disable the hooks

 define('DISABLE_HOOKS', true);

[Andrew Green]

Originally Posted by kiril_cvetkov

When i want to uninstall this modification - i get mysql error

The update to .11 should fix that. You can also manually fix the uninstall code:

Change the uninstall code for the product, first line to:

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP COLUMN 'casino_cash'";

Adding "COLUMN" in between "DROP" and "'casino_cash'"

[acegames]

Originally Posted by Andrew Green

as in vbookie_cash?

in the setup change the cash field to "vbookie_cash"

Perfect thankyou

[ChU v2]

Looks good, I'll be watching this mod for a texas hold em integration and multiplayer will be great.

[ArchangelX]

Anyway to integrate this with the other casino mod available? Thanks!

And will this work on 3.5? Thanks again!

[Andrew Green]

Originally Posted by ArchangelX

Anyway to integrate this with the other casino mod available? Thanks!

I'm not sure which other casino mod you mean, but I imagine that they would have no problem sharing the same cash. In the admincp you can set the name of the cash field to match the one the other casino uses.

And will this work on 3.5? Thanks again!

I see no reason why it shouldn't, but haven't actually tried it.

[ArchangelX]

Thanks for the quick response!

It's here: https://vborg.vbsupport.ru/showthread.php?t=158139

It's been out for a while now...and has been constantly updated for each new version of VB. One of the oldest hacks, I believe.

I'll try it out...unfortunately, I'll have to change the casino.php file's name. Thanks!

[Andrew Green]

Originally Posted by ArchangelX

I'll try it out...unfortunately, I'll have to change the casino.php file's name. Thanks!

Might be trickier then it sounds, all of the links go through "casino.php", so changing it without also changing any reference to it in the templates and files will break it. Which of course would need to be done again with every update...

[stangger5]

I have them both installed with no problems...

Casino for vBulletin uses casino.php
and
vbcasino uses lottery.php