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

[Gamelobby]

Originally Posted by scottjonesqpr

no-one?

might as well uninstall it then

Waaahhh..:erm:

Give it some time man.
Jeez, 3 posts in 22 minutes.. lol

You expected a reply in less than 10 minutes..!?
Then threaten to uninstall. if you want that kind of service you should just pay someone to do stuff for you.. i mean clearly no company that YOU PAY monthly for (Cable TV, Cell Phone, Web Hosting, Etc..) would ever make you wait longer than 10 minutes when you have a problem.

If you want your money back you'll need to go stand in THAT line over there.

[Jebadiah04]

Originally Posted by Gamelobby

Waaahhh..:erm:

Give it some time man.
Jeez, 3 posts in 22 minutes.. lol

You expected a reply in less than 10 minutes..!?
Then threaten to uninstall. if you want that kind of service you should just pay someone to do stuff for you.. i mean clearly no company that YOU PAY monthly for (Cable TV, Cell Phone, Web Hosting, Etc..) would ever make you wait longer than 10 minutes when you have a problem.

If you want your money back you'll need to go stand in THAT line over there.

TRUF!

[skylab]

Users are being kicked out of the texas holdem game for no reason. Any ideas on this?

[Lahoria]

just installed this ju 3.8.1 the slot machines just keep spinning the same with roulette

how do i fix that )=?

[mindhunter77]

I can not for the life of me get this to work, I install the mod, then go to the casino area in my admincp on the left side colum, click "casino settings" and get this

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE casino_settings SET switch1 =  WHERE settingname = 'ratebonus';

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 settingname = 'ratebonus'' at line 1
Error Number  : 1064
Request Date  : Saturday, April 4th 2009 @ 01:25:44 PM
Error Date    : Saturday, April 4th 2009 @ 01:25:44 PM
Script        : http://www.documentingreality.com/forum/admincp/casino_settings.php
Referrer      : http://www.documentingreality.com/forum/admincp/index.php?do=nav
IP Address    : xxxxxxxxx
Username      : xxxxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4-log

Then if I click "game settings" I get this

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE casino_games SET
			gamename = '',
			imagefile = '',
			description = '',
			active = '',
			chipsused = '',
			tablelimit = ,
			permissions = ''
			WHERE gameid = 2;

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 '
			permissions = ''
			WHERE gameid = 2' at line 7
Error Number  : 1064
Request Date  : Saturday, April 4th 2009 @ 01:29:01 PM
Error Date    : Saturday, April 4th 2009 @ 01:29:01 PM
Script        : http://www.documentingreality.com/forum/admincp/casino_games.php
Referrer      : http://www.documentingreality.com/forum/admincp/index.php?do=nav
IP Address    : xxxxxxxxxxxx
Username      : xxxxxxxxx
Classname     : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4-log

I have read through this thread for people that have had a problem like this and the answer is always, "you can't leave a setting blank, if you want it zero make it zero" Well the problem is I can't edit any settings, it just throws that at me as soon as I click the settings area...

Any help would really be appreciated.

[Raptor]

works great on 3.8.1 PL1 - thanks

[NavS]

if you want to make money retro active just run this query

UPDATE user SET casino_cash = casino_cash + posts + reputation + ((**unix time** - joindate)86400);

**unix time** can be had from: http://www.unixtimestamp.com/index.php

[rob4448585]

Originally Posted by NavS

if you want to make money retro active just run this query

UPDATE user SET casino_cash = casino_cash + posts + reputation + ((**unix time** - joindate)86400);

**unix time** can be had from: http://www.unixtimestamp.com/index.php

should be /86400

[doemasters]

After donating members money to get the casino started, the iCash total is resetting itself to zero after a few hours have past.

After donating to members a certain amount, that $ figure shows up on their profiles and they can, and have, used it in the casino.

But, lo and behold, when I come back to the forum in a few hours it's back to $0.00

Suggestions?

Any idea what I'm missing?

[Manic Mechanic]

Quote from original modification post;
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)

I have this installed on 3.73 and it works great. Members love it. I have also been to the above mentioned forum and found it to be a great help. Thank you for this modification.