vb.org Archive - vbProArcade Beta 2

I'm trying to do a quick fix of the server time issue.

My server is running 5 hours behind actual UK time, so I was wondering if it was easy enough to add a bit of code that simply added 5 hours to the times?

Looking at the code, I see that proarcade.php seems to add a "pre-score" data entry consisting of various things including time().

PHP Code:


		
			
 // insert the pre-game score entry into the table

  $score_insert = $DB_site->query("INSERT INTO arcadescores

                                   VALUES (null, '$scoregroup', '$game', '".time()."', 0, '$gamehash', 0, '$userid', '".addslashes($username)."', 0, '')");

and then has a bit that says.

PHP Code:


		
			
 // save the current time and fix username for entry

        $currenttime = time();

        $username = addslashes($username);

Would it be enough to simply add whatever value 5hours would be, to these two sections of the code or would it be more complex than that?

PixelFx

05-18-2003 09:40 PM

Savage Dragon,
make sure you don't have a blank index.html file in the directory your trying to load ;)

not sure if this is the issue, but it's something to look for :)

Savage Dragon

05-19-2003 03:35 AM

no i dont think that has anything to do with this. I wanna use the user comments bit ($lb_comment) in the vbproarcade_arcade_gamescorecellbit template. I am not sure how to go about this so any help I could get would be appreciated, thank you.

PixelFx

05-19-2003 07:59 PM

New addection, not sure what it would take to put these games into flash, for the arcade.

http://tartarus.uwa.edu.au/%7Ewedgey/slime1/

scottct1

05-20-2003 12:44 PM

Can anyone tell me what this error message means?

Quote:

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT max(score) as maxscore FROM arcadescores WHERE game='tetris' AND valid=1 AND username=Z'Loth'
mysql error: Got a packet bigger than 'max_allowed_packet'

mysql error number: 1153

I have a feeling it has to do with the username (which in this case is Z'loth - the ' is probably killing it.

KJ_innit

05-20-2003 12:46 PM

proarcade.php is still coming up with a blank white page. Getting really frustrating cos it worked with my test forums (2.2.9) but not on my live forums (2.3.0).

*cries*

obiwan8472

05-20-2003 01:07 PM

I'm on a shared host, does this hack consume loads of bandwidth or is it ok?
thanx

bloodcult

05-21-2003 04:04 PM

Quote:

05-19-03 at 09:59 PM PixelFx said this in Post #1325
New addection, not sure what it would take to put these games into flash, for the arcade.

http://tartarus.uwa.edu.au/%7Ewedgey/slime1/

i think this is a better port of it :)

http://home.t-online.de/home/mummertathome/game3.htm

Erwin

05-22-2003 06:47 AM

Anyone figured out how to fix the timezone?

Tigga

05-22-2003 03:54 PM

Quote:

Today at 03:47 AM Erwin said this in Post #1330
Anyone figured out how to fix the timezone?

Yup. Go through the date functions and change them to vbdate. ;)

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

Page 133 of 195

133

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

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