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 tigrattack

Hi,

I'm getting this error when importing the product:

Invalid SQL:
ALTER TABLE user ADD casino_cash integer default 250;

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060

I've deleted all the casino referrences in sql, any ideas?


Thanks

It means you still have a "casino_cash" field in your user table, you can remove it through phpmyadmin.

[tigrattack]

Originally Posted by Andrew Green

It means you still have a "casino_cash" field in your user table, you can remove it through phpmyadmin.

It's not there...I even did a search and it came up empty

[Andrew Green]

pretty sure it's there, would likely be the last column in the table.

But you can also do this, find these lines in the product_casino.xml file (line 140 / 141)

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP casino_cash";

$db->query_write(($query);

and delete them, then try importing the product again.

[tigrattack]

Originally Posted by Andrew Green

pretty sure it's there, would likely be the last column in the table.

But you can also do this, find these lines in the product_casino.xml file (line 140 / 141)

$query = "ALTER TABLE ". TABLE_PREFIX . "user DROP casino_cash";

$db->query_write(($query);

and delete them, then try importing the product again.

Still getting the same error :erm:

Since I'm using an outside credit system (vbcredits), can I delete this line:

$query = "ALTER TABLE ". TABLE_PREFIX . "user ADD casino_cash integer default 250";
$db->query($query);

I deleted that line and it imported fine...thanks

[skcyber]

thank you very much andrew ! it works nice

this hack is better every update !

[wolfyman]

no known issues with the new update?

[punchbowl]

Seems a lot snappier now.

One minor thing is the table just seems a bit big especially in hold'em. Could we tighten it up easily or is that a major thing?

[Andrew Green]

Originally Posted by wolfyman

no known issues with the new update?

Only thing I've heard back so far is a missing link on the add event page, should point to the new add / edit groups page. It's located here: casino.php?do=sportspool&action=editgroups

Originally Posted by punchbowl

Seems a lot snappier now.

One minor thing is the table just seems a bit big especially in hold'em. Could we tighten it up easily or is that a major thing?

Not much, 10 players on the screen is going to take up a fair bit of room no matter how it's laid out. The entire board is visible on 1024x768, can always hit the full screen button as well to get a little more. But I don't have any plans to try and shrink it beyond that.

[punchbowl]

Originally Posted by Andrew Green

Only thing I've heard back so far is a missing link on the add event page, should point to the new add / edit groups page. It's located here: casino.php?do=sportspool&action=editgroups



Not much, 10 players on the screen is going to take up a fair bit of room no matter how it's laid out. The entire board is visible on 1024x768, can always hit the full screen button as well to get a little more. But I don't have any plans to try and shrink it beyond that.

i'm on 1280x800 and it doesn't - i have a couple of toolbars. No big deal at all just thought there was a bit of excess space up top.

Oh and if someones name is john's_mate then their name will appear as john\\'s_mate at the table and john\'s_mate in the text window.

Again very minor. Anyway I've left the members loose on it some if they can't break it no one can

I'd love the sporting pool to be thread based. People won't see the bets otherwise.

I'll probably give it a go on 3.7 in about 2 weeks too.

Great work and happy new year.

[Freesteyelz]

Originally Posted by Andrew Green

Editing groups looks like a missing link, go to: casino.php?do=sportspool&action=editgroups to add / edit.

In my test I didn't get the effect you get for #1, but I'll try a few other things when I have more time.

In Template casino_sportspool_main I've changed (in red):

<if condition="! $recentevents">
<tr>
<td style='text-align:center' class='alt1'>
<a href='casino.php?do=sportspool&action=editgroups'>Edit Groups</a>
&nbsp;&nbsp;
<a href='casino.php?do=sportspool&action=addevent'>$vbphrase[casino_addevent]</a>
</td>
</tr>
</if>

Friendly suggestion: $vbphrase[casino_edit_group] should be added in next release.

----------------------

1) The #1 issue of edting events (adding the last option in all blank option fields) is confirmed (at least by me ). I've done an upgrade, several fresh installs, dropped all Casino tables in process to start fresh with all the same result. *Attachments below.

2) I also confirmed that when adding an event and leaving out a required field (ex. didn't select group), the entries (questions and answers) are cleared.

----------------------

3) The ability to remove groups is non-existent.

----------------------

I've been testing it on vB versions 3.6.4, 3.6.8 and 3.7 Beta 3.

Again, I hope you don't mind my postings. I know you work very hard on this script and it's much appreciated. I just want to help if I can.