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

Page 84 of 353

« First

134

184

Last »

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)

Andrew Green

10-21-2007 04:44 PM

Quote:

Originally Posted by samorite (Post 1365195)

errr is there any way to fix ?
carnt get it to unistall so i am a bit stuck

If you have direct access to mysql, most likely through phpmyadmin, run these two queries:

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);

BuckRodgers

10-21-2007 04:59 PM

my sql said:

#1064 - You have an er in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Andrew Green

10-21-2007 05:01 PM

bracket got left off in the copy and paste, fixed now.

BuckRodgers

10-21-2007 05:08 PM

ok that seems to have worked but got this now

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

INSERT INTO casino_texasholdem_chatlog (msg, msgtime) VALUES ('&lt;b&gt;Samorite joins the game&lt;/b&gt;', 1192990049);



MySQL Error  : Table 'web93-datadrome.casino_texasholdem_chatlog' doesn't exist

Error Number : 1146

Date         : Sunday, October 21st 2007 @ 07:07:29 PM

Script       : http://www.datadrome.co.uk/forum/casino.php?do=texasholdem&action=joingame

Referrer     : 

IP Address   : 82.22.587.216

Username     : Samorite

Classname    : vb_database

Andrew Green

10-21-2007 05:12 PM

Do your other games work?

Looks almost like it was partially uninstalled...

Anyways, running these should fix the other tables associated with Texas Hold'em

Code:

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);

BuckRodgers

10-21-2007 05:22 PM

yaaaay all back working just got the admin error now

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:



                SELECT cs1.switch1 AS gameid, cs1.switch2 AS gamefile, cs2.switch2 AS gamename, cs3.switch2 AS gamedesc, cs4.switch2 AS active

                FROM casino_settings AS cs1, casino_settings AS cs2, casino_settings AS cs3, casino_settings AS cs4    

                WHERE cs1.switch1=cs2.switch1 

                AND cs1.switch1= cs3.switch1 

                AND cs1.switch1= cs4.switch1 

                AND cs1.settingname='gamefile' 

                AND cs2.settingname='gamename' 

                AND cs3.settingname='gamedesc'

                AND cs4.settingname='gameactive';



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         : Sunday, October 21st 2007 @ 07:19:50 PM

Script       : http://www.datadrome.co.uk/forum/admincp/casino_settings.php

Referrer     : http://www.datadrome.co.uk/forum/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct

IP Address   : **********

Username     : Samorite

Classname    : vb_database

anyway to sort that ? I know i asked ya earler but while i got ya in the zone :P

Andrew Green

10-21-2007 05:26 PM

Quote:

Originally Posted by samorite (Post 1365229)

anyway to sort that i know i asked ya earler but while i got ya in the zone :P

It's actually fixed, in the next update. As well as everything else that I know about. Plus a new interface for the sportspool setup, and a new game (Let it Ride). Just finishing some stuff up with it, and hopefully will be able to get that out later today.

BuckRodgers

10-21-2007 05:32 PM

OK and a big thanks :D

Donation sent keep up the good work !

towermatt

10-21-2007 07:44 PM

Quote:

Originally Posted by Andrew Green (Post 1365234)

**does big happy banana dance**

Can't wait Andrew

Andrew Green

10-21-2007 07:54 PM

v 0.40 is up :)

Added a new game, redid the sportspool interface, fixed a bunch of bugs, etc

All times are GMT. The time now is 07:58 AM.

Page 84 of 353

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03316 seconds Memory Usage 1,746KB 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 (4)bbcode_code_printable (3)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: