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

Hey,

I had this hack installed n running for about 2 week,s suddenly it started getting errors when ppl wanted to play blackjack, so i uninstalled and try re-installing, 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'
Error Number : 1060
Date : Friday, November 23rd 2007 @ 06:35:57 PM
Script : http://daydie.co.uk/admincp/plugin.php?do=productimport
Referrer : http://daydie.co.uk/admincp/plugin.php?do=productadd
IP Address : 82.23.183.49
Username : daydie
Classname : vb_database

Please hlp

Skyline_GT

11-23-2007 11:24 PM

Quote:

Originally Posted by peterpigman (Post 1388264)

https://vborg.vbsupport.ru/showpost....postcount=1855

Thanks a lot.

hgb	11-24-2007 02:21 AM

bet was plased on black but went to even

user says this

This is a 20" flatpanel viewsonic in 1280 x 1024...... small windows.

My roulette wheel looks just like the pic you posted ***** when I first openit up..... ballis slightly off set like that.

But if the window is to the right side and I place a bet.... the bet will not be on the number I clicked.... the bet will be placed far to the left..... example; if the window is all the way to the right so I can choose the bet amount chip...... and I place that bet on Black... it will instead place the bet on Even.
If you center the window the bet will be placed on Red, instead of Black.
BUT when the window is all the way to the left it will place the bet where I click.

does that make sense?

Oh by the way.. I use Mozilla Sea Monkey.

Erika

11-24-2007 08:59 AM

Quote:

Originally Posted by daydie (Post 1388347)

I tried uninstalling myself, so that I could reset the casino values - I told my members to play with it and added a ton of money each day, but wanted to reset it all ---

I went remove all the files and then to re-install as well and get the exact same error:
Duplicate column name 'casino_cash'

I went into MySQL's, but it didn't have a casino_cash --- I did drop all the other casino tables I saw though and tried the re-install - still no luck.

Please help!

Mark.B

11-24-2007 10:03 AM

casino_cash isn't a database table, it's a column within the USER table....have a look in there, it MUST still exist. Delete it from there and then try to reinstall.

Erika

11-24-2007 04:10 PM

That did the trick Mark! Thanks so much!

Mark.B

11-24-2007 06:24 PM

Quote:

Originally Posted by Erika (Post 1388695)

That did the trick Mark! Thanks so much!

Fantastic stuff, glad you got it sorted.

Dermo-MIO

11-24-2007 07:07 PM

great mod was just wondering how do i edit things in the admin cp ? i can find an option anywere thanks

Mark.B

11-24-2007 07:18 PM

Quote:

Originally Posted by Dermo-MIO (Post 1388783)

great mod was just wondering how do i edit things in the admin cp ? i can find an option anywere thanks

Make sure you have uploaded the files in the admincp folder, the options should be on the left under "casino".

Robbed

11-24-2007 10:19 PM

PHP 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

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

All times are GMT. The time now is 11:00 PM.

Page 192 of 353

192

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03084 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 (1)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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: