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

Database error in vBulletin 3.6.7:

Invalid SQL:

UPDATE casino_bet_stats
SET won = won + 0, bet = bet +
WHERE userid = 1
AND gameid = 8;

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 'WHERE userid = 1
AND gameid = 8' at line 3
Error Number : 1064
Date : Thursday, October 25th 2007 @ 07:23:03 AM

Andrew Green

10-25-2007 01:31 PM

Quote:

Originally Posted by SLY LS1 (Post 1368309)

just upgraded to .50 and both the slots games just keep spining, then I got an email DB error - see below

update and overwrite the casino.php, slots.php and slots_ajax.php files, as well as revert the slots_main template if it needs it.

The one set of files now runs both slot machines, so if any of the files where missed spinning forever would be the likely result.

SLY LS1

10-25-2007 01:36 PM

Quote:

Originally Posted by Andrew Green (Post 1368311)

When you say slots_main template you mean ?

Ive uploaded all the files once again but its still doing it

Andrew Green

10-25-2007 01:55 PM

the template named "casino_slots_main" in the "casino" template group.

towermatt

10-25-2007 02:00 PM

Mine is doing the same Andrew--should I re download the zip to make those changes or just reload the ones from my downloads?

SLY LS1

10-25-2007 02:04 PM

Quote:

Originally Posted by Andrew Green (Post 1368328)

the template named "casino_slots_main" in the "casino" template group.

Ahh ok I worked out how to revertit, what exactly does that do, revert back to the previous version does it ?

Its working fine now after doing that

Cheers

Andrew Green

10-25-2007 02:08 PM

Styles and Templates -> Style manager -> Edit Templates ->
select the one you want to revert, and over on the right you'll have a "revert" button.

If that doesn't do it I'll need a link to your site to see what it's doing.

Andrew Green

10-25-2007 02:09 PM

Quote:

Originally Posted by towermatt (Post 1368336)

Mine is doing the same Andrew--should I re download the zip to make those changes or just reload the ones from my downloads?

slots_ajax.php is the one causing you problems, overwrite that and you should be ok.

Andrew Green

10-25-2007 02:10 PM

Quote:

Originally Posted by SLY LS1 (Post 1368341)

Ahh ok I worked out how to revertit, what exactly does that do, revert back to the previous version does it ?

Its working fine now after doing that

Cheers

Reverts back to the "original" version, and when you upgrade the original version changes, but it doesn't undo your changes, so you have the modified version of the old one, not the new one.

towermatt

10-25-2007 02:11 PM

:D

Works great--you just made my Christmas Card list.

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

Page 114 of 353

114

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03513 seconds Memory Usage 1,745KB 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 (6)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: