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 Escoh

Didnt work for me i tried the same thing odd.

Should i remove then reimport ?

If it's the same problem all you need to do is replace those files, if that doesn't do it send me a link and I'll have a look.

[bobster65]

Originally Posted by Andrew Green

I doubt that would help. It's a rather odd thing happening, the XML file is being created properly, but with then end off the _functions.php file slapped in front of it. Best I can figure is that the file got a little bigger during the upgrade and pushed it over some sort of choke point, I have no idea why that would occur, and might not even be it. But give the attached a try, I split the file into 2 pieces, so if that is it this will hopefully fix it.

Hey Andrew,

Not sure if this is related or not, but I've not had one single problem yet until I downloaded this and added it...

now I've got a couple DB errors on Stats..

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE casino_bet_stats
SET won = won + 0, bet = bet + 
WHERE userid = 8
AND gameid = 5;

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 'WHERE userid = 8
AND gameid = 5' at line 3
Error Number : 1064
Date         : Friday, October 19th 2007 @ 06:32:21 PM
Script       : http://~REMOVED~/forums/casino/slots_ajax.php
Referrer     : http://~REMOVED~/forums/casino.php?do=slots
IP Address   : ~REMOVED~
Username     : ~REMOVED~
Classname    : vb_database 


Everything else is working fine tho... just got a few of these in the last hr or so..

[aztecboi2003]

I haven't had any errors but my users cash isn't updating when they post, or log in.

[Mark.B]

Originally Posted by aztecboi2003

I haven't had any errors but my users cash isn't updating when they post, or log in.

Check your scheduled task logs...there was a syntax error in one of the previous versions that was stopping this from running. The version in the latest zip works, the file is casino_update.php. Have that uploaded and make sure the scheduled task is active and it should work.

Test it by pressing "run now" against the Casino Update in scheduled tasks, you'll soon see if you've got the file with the error.

[aztecboi2003]

Originally Posted by Mark.B

Check your scheduled task logs...there was a syntax error in one of the previous versions that was stopping this from running. The version in the latest zip works, the file is casino_update.php. Have that uploaded and make sure the scheduled task is active and it should work.

Test it by pressing "run now" against the Casino Update in scheduled tasks, you'll soon see if you've got the file with the error.

Thanks, I did as you said and it just has a blue screen that says update casino cash. Should I just grab the new casino_update.php and overwrite the file?

[Mark.B]

Originally Posted by aztecboi2003

Thanks, I did as you said and it just has a blue screen that says update casino cash. Should I just grab the new casino_update.php and overwrite the file?

That message indicates it ought to have worked, if it says "Done". Have you checked everyone's cash to see if it has increased by the amount set in your admin cp?

[aztecboi2003]

Originally Posted by Mark.B

That message indicates it ought to have worked, if it says "Done". Have you checked everyone's cash to see if it has increased by the amount set in your admin cp?

It says done in the bottom of the browser, but not on the cp page. I checked and it hasn't increased at all.

[Mark.B]

Sounds like it's not running then for some reason.

When manually running it the result should say:

Update Casino Cash

Done

Try grabbing the latest file, uploading it, and seeing if that works. Make sure it's in the includes/cron directory.

[aztecboi2003]

Originally Posted by Mark.B

Sounds like it's not running then for some reason.

When manually running it the result should say:

Update Casino Cash

Done

Try grabbing the latest file, uploading it, and seeing if that works. Make sure it's in the includes/cron directory.

I did as you said and it works now. Thanks for the great support.

[Mark.B]

Originally Posted by aztecboi2003

I did as you said and it works now. Thanks for the great support.

Great stuff...glad you got it fixed.