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

[daydie]

Hey,

I had this hack installed n running for about 2 week,s suddenly it started getting errors when ppl wanted to play blackjack, so i uninstalled and try re-installing, i get this error:

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 : Friday, November 23rd 2007 @ 06:35:57 PM
Script : http://daydie.co.uk/admincp/plugin.php?do=productimport
Referrer : http://daydie.co.uk/admincp/plugin.php?do=productadd
IP Address : 82.23.183.49
Username : daydie
Classname : vb_database

Please hlp

[Skyline_GT]

Originally Posted by peterpigman

https://vborg.vbsupport.ru/showpost....postcount=1855

Thanks a lot.

[hgb]

bet was plased on black but went to even

user says this

This is a 20" flatpanel viewsonic in 1280 x 1024...... small windows.

My roulette wheel looks just like the pic you posted ***** when I first openit up..... ballis slightly off set like that.

But if the window is to the right side and I place a bet.... the bet will not be on the number I clicked.... the bet will be placed far to the left..... example; if the window is all the way to the right so I can choose the bet amount chip...... and I place that bet on Black... it will instead place the bet on Even.
If you center the window the bet will be placed on Red, instead of Black.
BUT when the window is all the way to the left it will place the bet where I click.

does that make sense?

Oh by the way.. I use Mozilla Sea Monkey.

[Erika]

Originally Posted by daydie

Hey,

I had this hack installed n running for about 2 week,s suddenly it started getting errors when ppl wanted to play blackjack, so i uninstalled and try re-installing, i get this error:

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 : Friday, November 23rd 2007 @ 06:35:57 PM
Script : http://daydie.co.uk/admincp/plugin.php?do=productimport
Referrer : http://daydie.co.uk/admincp/plugin.php?do=productadd
IP Address : 82.23.183.49
Username : daydie
Classname : vb_database

Please hlp

I tried uninstalling myself, so that I could reset the casino values - I told my members to play with it and added a ton of money each day, but wanted to reset it all ---

I went remove all the files and then to re-install as well and get the exact same error:
Duplicate column name 'casino_cash'

I went into MySQL's, but it didn't have a casino_cash --- I did drop all the other casino tables I saw though and tried the re-install - still no luck.

Please help!

[Mark.B]

casino_cash isn't a database table, it's a column within the USER table....have a look in there, it MUST still exist. Delete it from there and then try to reinstall.

[Erika]

That did the trick Mark! Thanks so much!

[Mark.B]

Originally Posted by Erika

That did the trick Mark! Thanks so much!

Fantastic stuff, glad you got it sorted.

[Dermo-MIO]

great mod was just wondering how do i edit things in the admin cp ? i can find an option anywere thanks

[Mark.B]

Originally Posted by Dermo-MIO

great mod was just wondering how do i edit things in the admin cp ? i can find an option anywere thanks

Make sure you have uploaded the files in the admincp folder, the options should be on the left under "casino".

[Robbed]

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

        SELECT sum(bet) AS bet, sum(won) AS won, cs1.switch2 
        FROM casino_settings AS cs1
        LEFT JOIN casino_settings AS cs2 ON cs1.switch1 = cs2.switch1  
        LEFT JOIN casino_bet_stats ON cs1.switch1 = gameid 
        WHERE cs1.settingname = 'gamename' 
        AND cs2.settingname = 'gameactive'
        AND cs2.switch2 = '1' 
        GROUP BY gameid;

MySQL Error  : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Date         : Saturday, November 24th 2007 @ 07:21:18 PM
Script       : forums/casino.php?do=stats
Referrer     : /forums/casino.php?
IP Address   : 
Username     : Rob
Classname    : vB_Database 


Get this when clicking more stats