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

[tiger_scot]

I have error:

Parse error: syntax error, unexpected '<' in /home/harved2/public_html/casino.php(135) : eval()'d code on line 1

[sandt38]

Originally Posted by wickedstangs

Just upgraded to .91 and the Ajax games arent working, the slots won't stop, and also on the roulette table.

reload casino.php

[wolfyman]

My sports mod wants to add bets with up to 30 options. Is this possible?

[Andrew Green]

It was, but it needs a couple of edits to get it back on track. (Was supposed to be only 1)

sportspool.php

First line,

$maxoutcomes = 10;

change the 10 to 30

Second, on line 297:

	for($x = $x+1; $x < $11; $x++)

should be:

	for($x = $x+1; $x < $maxoutcomes+1; $x++)

[Crapaddict]

Excellent mod, our users love it and are posting frenzy just for the cash

Installed .91 few days ago, and have a few comments;

1. (minor)
   After importing the xml, i was searching all over the admincp for the games section.
   It took me a while before i found out i had to refresh the left-frame of the admincp.
   
   
2. (minor)
   I needed to set the sports betting groups to be able to set some games to bet on.
   I first was under the assumption that the admingroup should have the neccessary rights by default. Maybe this could be documented more clearly?
   
   
3. (minor)
   If you bet - for instance - $20 in Blackjack, you have to move your mousecursor to click twice on the same chip because the phrase "place your bet" dissapears, moving all chips aside.
   rather than dissapearing the phrase, just hiding it would be an idea?
   
   
4. I get reports from blackjack taking away money and simply freezing now and then.
   there are some javascript errors reported. (have a look at the attached image.)
   Used browser is IE7
   
   
5. I inserted all matches for the european soccer championship into the sports betting,
   realizing it became a lot of scrolling afterwards. (24 matches times three possible outcomes: team 1 or 2 wins, and a tie)
   I came up with the idea to make a "Future events" group, and by default only fetch events from the database which occur within 21 days from now.
   My simple solution: (sportspool.php)
   PHP Code:

   (line 339 and up:)
    if ($recentevents == 1)
    {
        $time = time();        
        $time2 = time() - (14 * 24 * 60 * 60);        
        $query = "SELECT * FROM casino_sb_events WHERE groupid = $groupid AND eventdate > $time2 AND eventdate < $time ";
    }
    else if ($recentevents == 2)
    {
        $time = time();        
        $query = "SELECT * FROM casino_sb_events WHERE groupid = $groupid AND eventdate < $time";
    }
    else if ($recentevents == 3)
    {
        $time = time();        
        $query = "SELECT * FROM casino_sb_events WHERE groupid = $groupid AND result IS NULL";
    }
    else if ($recentevents == 4)     // Add a fourth event to fetch all events.
    {
        $time = time();        
        $query = "SELECT * FROM casino_sb_events WHERE groupid = $groupid AND result IS NULL";
    }
    else 
    {
        $time = time();    
        // Add a variable to set the treshold for upcoming events
        $time3 = time() + (21 * 24 * 60 * 60);    
        // Alter the query to not fetch events occuring after $time3
        $query = "SELECT * FROM casino_sb_events WHERE groupid = $groupid AND (eventdate > $time AND eventdate < $time3) AND result IS NULL";
    } 

   (Added a recentevents #4, and changed the default query...)
   Maybe you could add something similar in future revisions?
   
   One could bet on future games if one knows the url, but it is less crowdy in the frontend.
   offcourse you can add the link in the casino_sportspool_main template if condition=$canedit so it is easy accessible for usergroups with the appropiate rights.
   
   (just an idea )
   

[lurkerx]

I had an error on the install and I tried to uninstall and reinstall and now I get this error

 
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'

[sweede]

Andrew you should add the $vbulletin->db->HideErrors(); Show errors around that alter statement. it probably would have reduced the number of posts in this thread by 1/2

[Mark.B]

Originally Posted by lurkerx

I had an error on the install and I tried to uninstall and reinstall and now I get this error

 
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'

Please use the search facility to search this thread. That question has been asked (and answered) around 2,584 times.

[Andrew Green]

Originally Posted by lurkerx

I had an error on the install and I tried to uninstall and reinstall and now I get this error

 
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'

http://vbgaming.org/forum/showthread.php?t=130

[skcyber]

I've a problem ... I can't change the default cash ! It is set up on 0 and I can't put an other amount