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

hi,sorry im use translator,i'm french
I have an error message after the importation of the file:

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 : Saturday, October 27th 2007 @ 09:27:13 PM
Script : http://www.team76.fr/team/admincp/pl...=productimport
Referrer : http://www.team76.fr/team/admincp/pl...?do=productadd
IP Address : 62.201.69.45
Username : Team76
Classname : vb_database

BuckRodgers

10-27-2007 06:34 PM

Quote:

Originally Posted by Andrew Green (Post 1369492)

Delet the "casino_cash" field from your user table and you will be able to install again, that's the only leftover piece.

can any one tell me how to do this please ?

Twilkey

10-27-2007 07:12 PM

Quote:

Originally Posted by team76 (Post 1369929)

Quote:

Originally Posted by samorite (Post 1369931)

can any one tell me how to do this please ?

You both need to do the same thing. Delete the casino cash column in the user table.

Steps:
1. Sign in to your phpMyAdmin.

2. On the left column, click the database you use for your forums.

3. After clicking it, it should extend to show all the tables in that database.

4. Scroll down to the user table and click it.

5. Now on the right, scroll down till you see a row that says casino_cash.

6. Directly to the right you will see a red X. Click it. That drops the column.

Now you can reinstall the product or whatever you were planning to do.

chatzworld

10-27-2007 08:13 PM

Feature Request - Would love to see when bets are settled a PM sent to the user saying it they won, lost, or drew

rungok

10-27-2007 08:16 PM

Excellent mod. The MP Texas just rocks! Keep up the good work dude.... :D

BuRuNDi

10-27-2007 08:17 PM

Hi,

I got this error, could you please tell me what to do?

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,

drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, 'range' integer, numbers integer, totalodds integer, odds text, winper text);



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 ''range' integer, numbers integer, totalodds integer, odds text, winper text)' at line 2

Error Number : 1064

Date         : Saturday, October 27th 2007 @ 04:59:52 PM

Script       : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport

Referrer     : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd

IP Address   : 189.131.68.222

Username     : BuRuNDi

Classname    : vb_database

Thanks in advance :)

Twilkey

10-27-2007 08:27 PM

Quote:

Originally Posted by chatzworld (Post 1369978)

Feature Request - Would love to see when bets are settled a PM sent to the user saying it they won, lost, or drew

You would be better to post that in the right forum on the vbgaming.org board.

Quote:

Originally Posted by BuRuNDi (Post 1369980)

Hi,

I got this error, could you please tell me what to do?

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

CREATE TABLE casino_lotto_draw (drawid integer NOT NULL PRIMARY KEY auto_increment,

drawtime integer, winners text, ticketnumbers text, jackpot integer, price integer, 'range' integer, numbers integer, totalodds integer, odds text, winper text);



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 ''range' integer, numbers integer, totalodds integer, odds text, winper text)' at line 2

Error Number : 1064

Date         : Saturday, October 27th 2007 @ 04:59:52 PM

Script       : http://www.chuzanet.com/foro/admincp/plugin.php?do=productimport

Referrer     : http://www.chuzanet.com/foro/admincp/plugin.php?do=productadd

IP Address   : 189.131.68.222

Username     : BuRuNDi

Classname    : vb_database

Thanks in advance :)

You seem to have an error in your SQL syntax. You should contact your web host.

Freesteyelz

10-27-2007 08:30 PM

Quote:

Originally Posted by Andrew Green (Post 1369719)

Attached file fixes.

Some left over testing code, replace existing file with this one.

(This goes for everyone that updated before this post, otherwise two of the seats will get nothing but a 3 & 4. )

Main .zip has been updated.

Thank you for the fix. :up:

Kalina

10-27-2007 09:05 PM

Was wondering if you take requests? My members are complaining about the new payout adjustment you've made, they tell me you basically only get back what you put in, is it possible to make it so we can adjust the setting within the casino settings in the admincp? Thank you!

All times are GMT. The time now is 01:38 PM.

Page 126 of 353

126

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03716 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 (2)bbcode_code_printable (7)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: