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

[ezurick]

Originally Posted by Red Blaze

Not sure if this has been asked, yet. I read and re-read your first post, but still found no solution. I see two versions of the zip. Do I install .91 first, then upgrade to .92? Or can I install version .92 right off the bat?

Yes, install only one of them. The author just left an older version online if you prefer it... but not sure why anyone would want it. Also, if you use this with vbcredits, be sure to weed back through the thread and see manual updates. I don't rmemeber them and I am not sure how far back, but there are a couple to get it working right.

[pmcnamara]

any known time table for the recode ?

developer hasn't been online since june ?

[shaunh]

For time management, does this mod use the vbulletin clock or it's own clock?

I'm considering moving from vBookie to the sports pool in this mod because vBookie will not observe the new US daylight savings, though the rest of the board does.

[WildFire.ca]

I am getting this error "This game is AJAX powered and requires JavaScript to be turned on" It seemed to be working at first now its causing some problems. The problem seems to be with hold'em but one of the members were getting the error in 21 also. My site url is www.couchlockcafe.com if you want to take a look

[troybtj]

Version 0.92 Installed and working in vB 3.7.3 PL1. This add-on ROCKS!

Warning - Raw Database and system changes used below. Do not attempt if changes aren't clear, you could hork your entire installation!

That aside.. The Casino worked OK for a while, then I was getting the "This game is AJAX Powered", or random user page reloads, booting them. By this time, myself, as well as a huge mob of members were... unhappy addicts, and needed their casino back! This is the most AWESOME add-on I've ever come across, by the way! First I unloaded/reloaded add-on. Finally corrected errors by optimizing the DB Tables, then tweaking php5-xcache module options. Optimizer/Cache could also be Zend Server, or any other PHP caching optimizer, something vBulletin recommends for all larger installations.

Below are the general steps I took, which reduced server load greatly, and increased speed by ∞, followed by "Suggestions for next version".

*Note: The below does depend on free real RAM for caching, so if server is digging heavily into swap space to start with, the below may not be as magic as they were for this case, but should still help.

What I did to speed up existing code database access by ∞, most commands entered at mysql client prompt:

• Change the "text" field types in database to varchar(x) with x being between 20 and 64 for most fields, like game name, in all tables. Make sure the field is big enough, but not overboard, e.g. 200 chars for 'username'. Any time a text field is used in query, it forces a temp table, no matter how small the query. The only fields that couldn't be readily changed were the PHP code storage.
• Add indexes to all tables linked or used in conditions, pretty good performance increase, small DB size increase due to small table size.
• Once most "text" fields in most casino_* files were changed to "varchar()", then indexed if needed:
• Run ANALYZE TABLE casino_<tablename> - for each table.
• If required, install php5-xcache module (or similar) and tweak settings.

WishList for next version

• Would LOVE to have plugin use the vbulletin Datastore memcache config if enabled.
• Lacking full memcache ability, ability to use the php5-memcache module if available, greatly reducing overhead from very frequent DB Reads

Details: Easy-ish explanation, hosting providers may be able/eager to help with this as well. In my.cnf, enable slow-query-log at 1-3 seconds, AND "log queries without indexes". For each <query> that shows up in mysql-slow, run "Explain <query>" in mySQL CLI, if it doesn't show indexes, add them to the fields in search portion of query (where clause, in, =, etc), especially if under "Extra" it says "using filesort" or similar, those are killing performance, especially at the rate the query is called.

Hope this helps some that were having problems with overloading/speed problems.

[shot2bits]

Hi, wondered if someone may be able to help.

I reverted my default template back and all of a sudden the casino (and arcade) vanished from the navbar.

They appear to both still be installed and active according to the admin panel yet thay are no longer on the navbar.

Any ideas?

Thanks, Rob.

[troybtj]

Originally Posted by shot2bits

Hi, wondered if someone may be able to help.

I reverted my default template back and all of a sudden the casino (and arcade) vanished from the navbar.

They appear to both still be installed and active according to the admin panel yet thay are no longer on the navbar.

Any ideas?

Thanks, Rob.

In "navbar" template in your theme under AdminCP -> Style Manager -> <<expand>>
Search for:

<td class="vbmenu_control"><a href="calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

Above that, add in the template:

<td class="vbmenu_control"><a href="casino.php?$session[sessionurl]">$vbphrase[casino_casino]</a></td>

That puts the link to the left of Calendar, the default. You can put it in a different spot as well, make sure to not miss a tag for an <if> statment, or put it inside another <td></td>

If you use template-modifications add on, that might be a better way to do the edits.

Disclaimer: I am not the developer of this, or affiliated in any way, just thought I'd help.

[RichieBoy67]

I am sorry I haven't read through this thread yet-- Is there a version for 3.7+ coming out any time soon??

Thanks

[dxlwebs]

does vbcredits work with this ?

[sandt38]

Originally Posted by RichieBoy67

I am sorry I haven't read through this thread yet-- Is there a version for 3.7+ coming out any time soon??

Thanks

A friend of mine had issues with his 3.7.X board running .92. They were freezing up constantly. I sent him .91 (I have every version of every software I load on my hard drive at home, in case I need to revert) and it ran smoothly for him. At that time .91 wasn't up here. I can only assume he realized .91 works better with 3.7 then .92 did.

I had to switch to 3.7.3 2 weeks ago (had to get vBCommerce running ) and have also had no issues with .91 running.

Originally Posted by dxlwebs

does vbcredits work with this ?

Yes, just change the cash field in the adminCP to "credits".