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

[frosch68]

Originally Posted by frosch68

i have the same error only in texas holdem in a new installation of the casino 0.81 under vb 3.6.8 , computer with windows vista in ie 7.0... in Firefox all works perfect.

error: This game is AJAX powered and requires javascript to be turned on

the errors appears only in texas holdem, not in the other games.

no idea ?

[DrKNickel]

Yeah, bring the casino to 3.7

[Hornstar]

Casino is working perfectly on 3.7

[Andrew Green]

Originally Posted by frosch68

no idea ?

Usually that happens when a file hasn't been uploaded properly, or one of the casino templates has been altered.

[YvaN]

Hi, I have regulary this error by mail :

Database error in vBulletin 3.6.4:

Invalid SQL:
;

MySQL Error : Query was empty
Error Number : 1065
Date : Tuesday, December 18th 2007 @ 09:30:15 PM
Script : http://xxxxxx/forum/casino/slots_ajax.php
Referrer : http://xxxxxx/forum/casino.php?do=slots
IP Address : xx.xx.xx.xx
Username : xxxxxxxx
Classname : vB_Database

Always with the slots...

Someone have an idea?

(sorry for my poor english)

[5th-Level]

i get this error when trying to import the product

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         : Wednesday, December 19th 2007 @ 01:40:32 PM
Script       : http://www.mafialifecity.com/admincp/plugin.php?do=productimport
Referrer     : http://www.mafialifecity.com/admincp/plugin.php?do=productadd
IP Address   : XX.XX.XXX.XXXX
Username     : XXXXXXX
Classname    : vB_Database

[Hornstar]

Originally Posted by 5th-Level

i get this error when trying to import the product

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         : Wednesday, December 19th 2007 @ 01:40:32 PM
Script       : http://www.mafialifecity.com/admincp/plugin.php?do=productimport
Referrer     : http://www.mafialifecity.com/admincp/plugin.php?do=productadd
IP Address   : XX.XX.XXX.XXXX
Username     : XXXXXXX
Classname    : vB_Database

I think that database error occurs if you try and uninstall it and install it again by memory. You just had to overwrite the upgrade. Is that what you did?

If the casino cash of your members is not important, and you dont mind starting fresh, then you can try this unoffical support: Uninstall the product, then Open up phpMyAdmin (If you have it) and then delete all tables that consist of casino_ Then try and install it again.

[frosch68]

Originally Posted by Andrew Green

Usually that happens when a file hasn't been uploaded properly, or one of the casino templates has been altered.

i have the original templates..

it?s only in texas holdem, and as i said, in firefox it works fine, only in IE is the problem.... i have unsinstalled the casiono and a new install was done... the same effects....

[TCE Killa]

Can the problems be fixed for this because I wouldn't mind it for my forum?

Thanks.

[dodgeboard.com]

Originally Posted by TCE Killa

Can the problems be fixed for this because I wouldn't mind it for my forum?

Thanks.

The problems are fixed! If you follow the directions for installing it, it works great. If you don't read the directions and you try to uninstall before upgrading, you'll get the errors described above.

All the issues mentioned on this page have been discussed tirelessly- there are fixes for all of these issues in this thread, if you are up to reading back a few pages.

Understand though, this is a beta release.


BTW Andrew - Casino works great on my board with 3.7 with no template reverts or other edits. well, except for the obvious- postbit (for the cash display)

Later today, I may expirement with getting the cash to display on the new user profiles.