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

[dodgeboard.com]

Originally Posted by dave9720

Deleted Files and Re Install 0.90 and now I get this message when I upload in admincp, manage product, product-casino.xml



Database error
The Forums database has encountered a problem.

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

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the XXXXXX.com home page, then try to open another page.
Click the Back button to try another link.

The bestsatellitepros.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin 3.6.8:

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

MySQL Error : Duplicate column name 'casino_cash'
Error Number : 1060
Date : Friday, January 11th 2008 @ 08:29:13 PM
Script : http://xoxoxo.com/admincp/plugin.php?do=productimport
Referrer : http://xoxoxo.com/admincp/plugin.php?do=productadd
IP Address : xx.xxx.xx.xxx
Username : dave9720
Classname : vB_Database

Shame on you for not reading the directions in the original post (see bolded text) or the readme that came with the mod!

That question has been asked 161 times in this thread.

USE THE SEARCH FUNCTION!!

[Shazz]

Great support andrew

[Captain Kirk76]

Does this work on vB 3.7.0, or have plans to make it work on that version?

[dave9720]

Can you tell me how to correct this? What file to edit?
Did a search with no results. Thanks Dave

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT casino_cash
FROM user as abc
WHERE userid = 1;

MySQL Error : Unknown column 'casino_cash' in 'field list'
Error Number : 1054

[dodgeboard.com]

No Dave, most of us cannot bring ourselves to repeating it for the 100th time for the ones that do not know how to search a thread or are too lazy to read back a page or two.

HINT: at the top of the thread choose "search mod"
enter "casino_cash" or "duplicate column name"

[mastertek2000]

Originally Posted by River_rush

Posts from members


Texas hold'em doesn't work for me. keeps saying " This game is AJAX powered and requires javascript to be turned on." but javascript is turned on. Anyone else getting this problem. The other games like blackjack works.
Get the same also. Clicking on the start game button does nothing either.




any ideas?

i also got this problem OK if you have this error and you have the archive mod installed that's what it seem to be
i just remove archive mod and works fine

[Andrew Green]

Originally Posted by dave9720

Can you tell me how to correct this? What file to edit?
Did a search with no results. Thanks Dave

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT casino_cash
FROM user as abc
WHERE userid = 1;

MySQL Error : Unknown column 'casino_cash' in 'field list'
Error Number : 1054

Go to phpymyadmin, remove any tables that start with casino_, then remove the casino_cash field from your user table. Begin install again.

Originally Posted by mastertek2000

i also got this problem OK if you have this error and you have the archive mod installed that's what it seem to be
i just remove archive mod and works fine

Which archive mod? If there is a conflict I can probably work around it.

And to the original problem, this has also happened to a few people where the files didn't get uploaded properly. Reupload, making sure that the new ones replace the old ones.

[Andrew Green]

Originally Posted by Captain Kirk76

Does this work on vB 3.7.0, or have plans to make it work on that version?

Until 3.7 gets out of Beta I'm going to continue working to get this out of Beta on 3.6, once it's done here, and 3.7 is final I'll make any updates that are needed and release a 3.7 version.

[dave9720]

[QUOTE=Andrew Green;1420320]Go to phpymyadmin, remove any tables that start with casino_, then remove the casino_cash field from your user table. Begin install again.

New Error! I think i will pass on this hack. Thanks for your time. Dave
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT count(userid) AS np FROM casino_texasholdem_whoisin WHERE lastcheck > 1200176476;

MySQL Error : Table 'bestsate_vb.casino_texasholdem_whoisin' doesn't exist
Error Number : 1146
Date : Saturday, January 12th 2008 @ 04:21:46 PM
Script : http://xoxoxoxo.com/
Referrer :
IP Address : 71.188.98.125
Username : dave9720
Classname : vB_Database

[Andrew Green]

Once your tables are removed, you do have to reinstall the product, otherwise you got no tables and get errors...