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

[AdmiralGeek]

logical error when playing the video poker, you get a pair of nines, and you get a jack wchi is better. The computer decides sure, we will make it two pair instead of letting you choose three of a kind, which is a higher pay out......

[Andrew Green]

Originally Posted by Rushty

im getting an error when installing on MySQL v5 on Windows

Database error in vBulletin 3.6.8, casino versions .38 & .4

the error seems to be down to the use of a reserved word 'range' within thw SQL that creates casino_lotto_draw. SQL below.

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);

Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/...ved-words.html

Is that the error it is giving you? I can escape it or rename it next time around which should get around that...

Originally Posted by leeman

I have Inferno Shoutbox ....

But I get confused when it conflicts with 3 outa six games ...

Well gonna try some stuff. Unless someone else have gotten the same and solved it.

Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?

Originally Posted by AdmiralGeek

the 250, 500, 1000, chip in the admin control panel are not added automatically
maybe the admin.php needs to be re-done.
They have to be entered manually?

Yes they do. I know a lot of people have added higher chips, and I didn't want to overwrite existing settings, so the images are there, but they aren't added in.

Originally Posted by samorite

when i try to save the changes i get

any ideas ?

I'll patch that query out of there and post it here when I get a few minutes.

Originally Posted by Mark.B

Thanks Andrew.

Just for information, returning to the site at 0700 BST and the events have gone, so it looks like they are closing at server time rather than vbtime.

Ok, so the times all show up properly, but the events are staying open passed the time shown?

[Andrew Green]

Originally Posted by AdmiralGeek

logical error when playing the video poker, you get a pair of nines, and you get a jack wchi is better. The computer decides sure, we will make it two pair instead of letting you choose three of a kind, which is a higher pay out......

Exactly what cards are you getting?

Any hand that would let you have both 2 pair and 3 of a kind should be a full house?

[Vizionz]

i am gonna install this shortly but mad props for putting this much work into a game mod.

[Andrew Green]

Originally Posted by samorite

when i try to save the changes i get


any ideas ?

Overwrite the existing file with the attached one in the admincp folder.

[AdmiralGeek]

Originally Posted by Andrew Green

Exactly what cards are you getting?

Any hand that would let you have both 2 pair and 3 of a kind should be a full house?

no, when i had 1 pair, and a jack. the jack takes another card and turns it into a pair, instead of leeting the 1 pair be a three of a kind. Get me now?

[AdmiralGeek]

the wild card (jack) doesn't know how to handle the situation, it cant consider that when you have just one single pair, it cant turn it into a three of a kind, unless there is another pair in the hand.

three of a kind, is stronger than two pairs.

[Andrew Green]

Jack is not treated as a wild card?

[Rushty]

Range is not listed as a reserved word: http://dev.mysql.com/doc/refman/5.0/...ved-words.html

sorry I should have said its 5.1 not 5.0 and range is a reserved word on 5.1: http://dev.mysql.com/doc/refman/5.1/...ved-words.html

[Mark.B]

Originally Posted by Andrew Green

Ok, so the times all show up properly, but the events are staying open passed the time shown?

Yep, that's exactly it.

I tested this by re-uploading the old file (which I have left up for the time being) and the events that should be closed then disappear.