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

[Twilkey]

Originally Posted by TaBaTaN

Please help me, y cant uninstall it

i use 0.50 and installed over 0.51, with either of this uninstall works.

Please post the error you are getting.

[team76]

hi,sorry im use translator,i'm french
I have an error message after the importation of the file:

Database error in vBulletin 3.6.8:

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

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Saturday, October 27th 2007 @ 09:27:13 PM
Script : http://www.team76.fr/team/admincp/pl...=productimport
Referrer : http://www.team76.fr/team/admincp/pl...?do=productadd
IP Address : 62.201.69.45
Username : Team76
Classname : vb_database

[BuckRodgers]

Originally Posted by Andrew Green

Delet the "casino_cash" field from your user table and you will be able to install again, that's the only leftover piece.

can any one tell me how to do this please ?

[Twilkey]

Originally Posted by team76

hi,sorry im use translator,i'm french
I have an error message after the importation of the file:

Database error in vBulletin 3.6.8:

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

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Saturday, October 27th 2007 @ 09:27:13 PM
Script : http://www.team76.fr/team/admincp/pl...=productimport
Referrer : http://www.team76.fr/team/admincp/pl...?do=productadd
IP Address : 62.201.69.45
Username : Team76
Classname : vb_database

Originally Posted by samorite

can any one tell me how to do this please ?

You both need to do the same thing. Delete the casino cash column in the user table.

Steps:
1. Sign in to your phpMyAdmin.

2. On the left column, click the database you use for your forums.

3. After clicking it, it should extend to show all the tables in that database.

4. Scroll down to the user table and click it.

5. Now on the right, scroll down till you see a row that says casino_cash.

6. Directly to the right you will see a red X. Click it. That drops the column.

Now you can reinstall the product or whatever you were planning to do.

[chatzworld]

Feature Request - Would love to see when bets are settled a PM sent to the user saying it they won, lost, or drew

[rungok]

Excellent mod. The MP Texas just rocks! Keep up the good work dude....

[BuRuNDi]

Hi,

I got this error, could you please tell me what to do?

Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,
drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, 'range' integer, numbers integer, totalodds integer, odds text, winper text);

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 ''range' integer, numbers integer, totalodds integer, odds text, winper text)' at line 2
Error Number : 1064
Date         : Saturday, October 27th 2007 @ 04:59:52 PM
Script       : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport
Referrer     : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd
IP Address   : 189.131.68.222
Username     : BuRuNDi
Classname    : vb_database

Thanks in advance

[Twilkey]

Originally Posted by chatzworld

Feature Request - Would love to see when bets are settled a PM sent to the user saying it they won, lost, or drew

You would be better to post that in the right forum on the vbgaming.org board.

Originally Posted by BuRuNDi

Hi,

I got this error, could you please tell me what to do?

Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,
drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, 'range' integer, numbers integer, totalodds integer, odds text, winper text);

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 ''range' integer, numbers integer, totalodds integer, odds text, winper text)' at line 2
Error Number : 1064
Date         : Saturday, October 27th 2007 @ 04:59:52 PM
Script       : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport
Referrer     : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd
IP Address   : 189.131.68.222
Username     : BuRuNDi
Classname    : vb_database

Thanks in advance

You seem to have an error in your SQL syntax. You should contact your web host.

[Freesteyelz]

Originally Posted by Andrew Green

Attached file fixes.

Some left over testing code, replace existing file with this one.

(This goes for everyone that updated before this post, otherwise two of the seats will get nothing but a 3 & 4. )

Main .zip has been updated.

Thank you for the fix. :up:

[Kalina]

Was wondering if you take requests? My members are complaining about the new payout adjustment you've made, they tell me you basically only get back what you put in, is it possible to make it so we can adjust the setting within the casino settings in the admincp? Thank you!