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

[buurman]

Originally Posted by dodgeboard.com

Andrew- great job.

One cosmetic issue only on the new release .71

Roulette screens are funky now. These were okay in .70

The corners wrap at the top and the bottom (top shown in pic)

1024x768

After the update, I also have the same problem, changed the code and the rounded corners are fine now, but missing the pieces between the corners, like in the screenshot.
This is in IE and Firefox, only in roulette, not in Texas hold em.

[ausjeepo]

Hi Andrew,

we where running version .51 and have upgraded to .71 I reverted all the templates uploaded all the files and have upgraded but we are getting random db errors especially when pressing stats which consistantly gives a db error, and texas holdem doesnt show anyone else in so if two people are playing they dont see each other. Any ideas? Thanks for all your work on this mod our members love it.

Database error in vBulletin 3.6.5:

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 : Tuesday, November 27th 2007 @ 04:29:16 AM
Script : http://www.ausjeepoffroad.com/forum/casino.php?
Referrer : http://www.ausjeepoffroad.com/forum/...=72210&page=15
IP Address : 124.169.141.225
Username : Dave
Classname : vb_database



http://www.ausjeepoffroad.com/forum/casino.php

[rwilkins108]

Hey Andrew, on Let 'em ride, could you move the chips to below your dollar amount? when the game ends, and the chips get drawn, the board extends pretty far to the right.

Thanks!

[ezurick]

Originally Posted by buurman

After the update, I also have the same problem, changed the code and the rounded corners are fine now, but missing the pieces between the corners, like in the screenshot.
This is in IE and Firefox, only in roulette, not in Texas hold em.

Yeah, I am using IE (as most my users are using) and I applied this edit and now it is worse... The left corner is corrected, but the right one is off drastically and the piece between must be in cyber space somewhere... lol.

Also, since I updated to .71, when I play roulette... I click on a chip... no matter what number I select, it places the chip in the 2 to 1 slot. This didn't happen until I updated... something has changed and ruined the roulette fer me... It was working great until this update.

Lastly, and so berry important... is there a way to turn of the donations, or perhaps limit the amount. I see no settings. The reason is I have some hardcore users with amount in the hundred thousands... and they have either close friends or multiple accounts... and they place high bets in vbookie football games on both teams to get a sure win. So I restrict the amount to donate/transfer... but with the feature in casino, they are by passing my restriction... please help me correct this... Oh! I am using vbcredits 1.4RC1...

[hgb]

my lotto has not worked right at all and waited for this update to see if it would fix it... no luck tho...

I have been running the cron after every draw manually but now that wont work.

Casino Lottery Draw

Fatal error: Call to a member function on a non-object in /home/******/public_html/forums/includes/cron/casino_lotto.php on line 127

also I have not been able to get the box to show how many people are in hold 'em game, even on a stock VB template with placing the $inpoker at the bottom of the navbar template????

thanks for any help

[punchbowl]

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 : Tuesday, November 27th 2007 @ 01:20:47 PM
Script : http://www.********.com/forum/casino.php?
Referrer : http://www.********.com/forum/casino.php?do=blackjack
IP Address : #####################
Username : ********
Classname : vB_Database

==============================

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 : Tuesday, November 27th 2007 @ 12:47:24 PM
Script : http://www.####.com/forum/casino.php?do=stats
Referrer : http://www.####.com/forum/casino.php?
IP Address : ####
Username : ####
Classname : vB_Database

=========================

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 : Tuesday, November 27th 2007 @ 11:45:24 AM
Script : http://www.*****.com/forum/casino.php?
Referrer : http://www.*****.com/forum/casino.php?do=texasholdem
IP Address : *****
Username : *****
Classname : vB_Database

[buurman]

After last update, many things dont work anymore in IE, only in firefox.
No Texas Hold em, and Roulette isnt working (no fishes on table and buggy) and a lot of images aint working, they are called jpg instead of png.
Maybe also test on IE?

[Kmaster]

Originally Posted by buurman

After last update, many things dont work anymore in IE, only in firefox.
No Texas Hold em, and Roulette isnt working (no fishes on table and buggy) and a lot of images aint working, they are called jpg instead of png.
Maybe also test on IE?

me either, with many problem with IE after upgraded.

[jewropa]

after the last update lot of bugs!

[Andrew Green]

Originally Posted by hgb

my lotto has not worked right at all and waited for this update to see if it would fix it... no luck tho...

I have been running the cron after every draw manually but now that wont work.


also I have not been able to get the box to show how many people are in hold 'em game, even on a stock VB template with placing the $inpoker at the bottom of the navbar template????

thanks for any help

I'll get back to you on that later today

Originally Posted by buurman

After last update, many things dont work anymore in IE, only in firefox.
No Texas Hold em, and Roulette isnt working (no fishes on table and buggy) and a lot of images aint working, they are called jpg instead of png.
Maybe also test on IE?

What in Texas Hold'em isn't working?

All I can see in my rather quick IE test is that Roulette is rather buggered up, anything else?