Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Casino (w/ 10 player poker) Details »»
Casino (w/ 10 player poker)
Version: 0.92, by Andrew Green Andrew Green is offline
Developer Last Online: Apr 2010 Show Printable Version Email this Page

Category: Major Additions - Version: 3.6.x Rating:
Released: 09-29-2007 Last Update: 02-17-2008 Installs: 1064
DB Changes Uses Plugins Template Edits
Additional Files Is in Beta Stage  
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #1922  
Old 11-25-2007, 12:53 AM
rknight111 rknight111 is offline
 
Join Date: Oct 2006
Posts: 145
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This error is coming up about 30 times per day, how can I fix it???


Quote:
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 : Saturday, November 24th 2007 @ 09:44:00 PM
Script : http://www......../forum/casino.php?do=stats
Referrer :
IP Address : ............
Username : r........
Classname : vb_database
Reply With Quote
  #1923  
Old 11-25-2007, 07:36 AM
peterpigman peterpigman is offline
 
Join Date: May 2006
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Robbed View Post
PHP Code:
Database error in vBulletin 3.6.8:

Invalid SQL:

        
SELECT sum(bet) AS betsum(won) AS woncs1.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 rowscheck your WHERE and use SET SQL_BIG_SELECTS=or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number 1104
Date         
SaturdayNovember 24th 2007 07:21:18 PM
Script       
forums/casino.php?do=stats
Referrer     
: /forums/casino.php?
IP Address   
Username     Rob
Classname    
vB_Database 
Get this when clicking more stats
Quote:
Originally Posted by rknight111 View Post
This error is coming up about 30 times per day, how can I fix it???
https://vborg.vbsupport.ru/showpost....postcount=1855
Reply With Quote
  #1924  
Old 11-25-2007, 12:02 PM
wattieuk's Avatar
wattieuk wattieuk is offline
 
Join Date: Jul 2004
Posts: 59
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think this is a fantastic mod and my users love it. The only problem I have is my forum which has a fixed width of 760 doesnt display the roulette table properly. Is there any way to make the roulette table smaller?
Thanks.
Reply With Quote
  #1925  
Old 11-25-2007, 04:28 PM
Lee G Lee G is offline
 
Join Date: Jun 2006
Location: Costa Blanca
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For some reason my Texas Holdem has stopped working, it keeps showing

There are no free seats available, please try again later.

Players are set to ten. All the other games work without any problems

Tried updating to the latest version of the casino and the problem is still there

Any ideas

Thanks Lee
Reply With Quote
  #1926  
Old 11-25-2007, 04:45 PM
forumrunt forumrunt is offline
 
Join Date: Sep 2007
Posts: 177
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what is the Casino Cash this adds?
Reply With Quote
  #1927  
Old 11-25-2007, 05:14 PM
rknight111 rknight111 is offline
 
Join Date: Oct 2006
Posts: 145
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I added that as discussed. I never touched that part of the system before. Now I hope that stops the errors as there going up I get an email for each error. These seems to have started when I did the most recent upgrade to VB.
Reply With Quote
  #1928  
Old 11-25-2007, 06:14 PM
peterpigman peterpigman is offline
 
Join Date: May 2006
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by rknight111 View Post
I added that as discussed. I never touched that part of the system before. Now I hope that stops the errors as there going up I get an email for each error. These seems to have started when I did the most recent upgrade to VB.
I have had none since I did that mod. It is a server setting apparently that causes it.
Reply With Quote
  #1929  
Old 11-25-2007, 09:24 PM
TTG's Avatar
TTG TTG is offline
 
Join Date: May 2004
Location: Sth London
Posts: 1,042
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Had to turn off the roulette .. the ball has been round enough times to have gone to the moon and back and its still going
Reply With Quote
  #1930  
Old 11-25-2007, 10:26 PM
punchbowl punchbowl is offline
 
Join Date: Nov 2006
Posts: 505
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Db error for user names containing: '
e.g
john'sgirls

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE user
SET casino_cash = casino_cash + 10000
WHERE username = 'john'sgirls';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's'' at line 3
Error Number : 1064

=================================================
Reply With Quote
  #1931  
Old 11-26-2007, 04:20 AM
Twilkey's Avatar
Twilkey Twilkey is offline
 
Join Date: Oct 2006
Posts: 314
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by punchbowl View Post
Db error for user names containing: '
e.g
john'sgirls

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE user
SET casino_cash = casino_cash + 10000
WHERE username = 'john'sgirls';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's'' at line 3
Error Number : 1064

=================================================
The ' in the users name is messing with the database.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:11 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.11284 seconds
  • Memory Usage 2,340KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete