vb.org Archive - Major Additions - Casino (w/ 10 player poker)

Page 90 of 353

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Major Additions - Casino (w/ 10 player poker) (https://vborg.vbsupport.ru/showthread.php?t=159151)

leeman

10-22-2007 02:33 PM

Quote:

Originally Posted by Andrew Green (Post 1365878)

Those 3 function in more or less the same way, and it does look like some sort of conflict with the Inferno stuff. When does the error show up? Does the start button flash up first? Do you get nothing but the error? Most of the page show up, but the error come in the place where the cards should be?

I get it as soon as I click the link to the game ....

Where the cards should be I guess ...

BuckRodgers

10-22-2007 03:16 PM

ok thanks for the admin patch thats worked fine but when i click on more stats i get

Code:

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, casino_settings AS cs2, casino_bet_stats 

                WHERE cs1.settingname = 'gamename' 

                AND cs2.settingname = 'gameactive'

                AND cs1.switch1 = gameid 

                AND cs2.switch2 = '1' 

                AND cs1.switch1 = cs2.switch1 

                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

and when i click on let em ride it just goes back to the casino main menu ?

Mark.B

10-22-2007 04:04 PM

Quote:

Originally Posted by samorite (Post 1365978)

and when i click on let em ride it just goes back to the casino main menu ?

I think the original casino.php file that was uploaded was missing a couple of lines that would solve that.

Looking at the ZIP file now, the lines are present, so if you redownload and replace the casino.php file, it should work.

Andrew Green

10-22-2007 04:10 PM

Quote:

Originally Posted by samorite (Post 1365978)

ok thanks for the admin patch thats worked fine but when i click on more stats i get

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

ok, not allowed to connect more then 2 tables at a time... got it.

Quote:

and when i click on let em ride it just goes back to the casino main menu ?

Upload and overwrite the casino.php file ;)

Mark.B

10-22-2007 04:12 PM

I've only just spotted this, but the new texasholdem_ajax.php file seems to be causing the game to refuse to load, just showing the start button which has no effect.

Reverting to the old file fixes it.

blind-eddie

10-22-2007 04:38 PM

I am getting alot of db errors when I try to reset cash....

Code:

Database error in vBulletin 3.6.5:



Invalid SQL:



UPDATE user 

SET casino_cash =;



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 '' at line 2

Error Number : 1064

Date         : Monday, October 22nd 2007 @ 03:53:54 AM

Script       : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash

Referrer     : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Code:

Database error in vBulletin 3.6.5:



Invalid SQL:



UPDATE user 

SET casino_cash = o.oo;



MySQL Error  : Unknown table 'o' in field list

Error Number : 1109

Date         : Monday, October 22nd 2007 @ 03:55:10 AM

Script       : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=o.oo&submit=Adjust+Cash

Referrer     : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Code:

Database error in vBulletin 3.6.5:



Invalid SQL:



UPDATE user 

SET casino_cash =;



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 '' at line 2

Error Number : 1064

Date         : Monday, October 22nd 2007 @ 03:55:46 AM

Script       : http://outerzone.us/forum/xxxxxxx/casino_settings.php?massadj=1&usergroups=&amount=&submit=Adjust+Cash

Referrer     : http://outerzone.us/forum/xxxxxxx/casino_settings.php

Andrew Green

10-22-2007 05:09 PM

Quote:

Originally Posted by blind-eddie (Post 1366044)

I am getting alot of db errors when I try to reset cash....

You're trying to reset to zero?

Put "0" in the field.

Leaving it blank won't work, decimals aren't needed.

BWilliams

10-22-2007 05:13 PM

Just installed this and getting this error up on loading the site. I can't even get into the admin area to try to uninstall it.

MySQL Error : Table 'socaps_vBulletin.casino_texasholdem_whoisin' doesn't exist Error Number : 1146

Please help ASAP, my eMail inbox is filling up by the 100's every few minutes with this error.

Andrew Green

10-22-2007 05:25 PM

Quote:

Originally Posted by BWilliams (Post 1366063)

phpmyadmin and enter the following:

Code:

DROP TABLE casino_texasholdem_whoisin;

CREATE TABLE casino_texasholdem_whoisin (whoisinid integer NOT NULL PRIMARY KEY auto_increment, userid integer, seat integer, lastcheck integer, status integer, bet integer);



DROP TABLE casino_texasholdem_chatlog;

CREATE TABLE casino_texasholdem_chatlog (chatlogid integer NOT NULL PRIMARY KEY auto_increment, msg text, msgtime integer);



DROP TABLE casino_texasholdem_dealt;

CREATE TABLE casino_texasholdem_dealt (dealtid integer NOT NULL PRIMARY KEY auto_increment, playerid integer, card integer);

Where you upgrading or installing from scratch?

aggiefan

10-22-2007 05:30 PM

has there been any movement on a "who is in the casino" option for the "Whats going on?".... would be very nice to be able to tell who is in a game of texas holdem especially since its multiplayer.

All times are GMT. The time now is 12:16 AM.

Page 90 of 353

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02596 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: