vb.org Archive - v3 Arcade - Games Arcade & Challenge System [vB 3.0.3]

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - v3 Arcade - Games Arcade & Challenge System [vB 3.0.3] (https://vborg.vbsupport.ru/showthread.php?t=60377)

Uploaded and installed - however I have one error in the home page of the vB backend home page:

Code:

Fatal error: Call to undefined function: construct_nav_option() in /home/XXX/public_html/boards/admincp/index.php on line 456

Now this is the code it is referring to:

PHP Code:


		
			
construct_nav_option("General Settings", 'arcadeadmin.php?do=general', '<br />');

construct_nav_option("Game Settings", 'arcadeadmin.php?do=games', '<br />');

construct_nav_option("Score Settings", 'arcadeadmin.php?do=scores', '<br />');

construct_nav_option("Challenges", 'arcadeadmin.php?do=challenges', '<br />');

construct_nav_group("Arcade", '<hr />');

My arcadeadmin.php file is also not working. Whenever I try to load it, it's just a blank page. Anyonw know what's wrong?

Where do you download games from now??

Quote:

Originally Posted by pgowder

Where do you download games from now??

Code:

https://vborg.vbsupport.ru/showpost.php?p=763408&postcount=4111

and in the first post pages of this forum

I think they should prune this thread down to game links & fixes to questions that are not double.

Quote:

Originally Posted by lairnoc

arcadeadmin doesn't show so i cannot disble games.. but install them no problem anyone an idea how to repair it?
vbb 3.08

Anyone?

Have you verified your AdminCP modifications? If so, paste 3 lines above to 3 lines below so we can see what you have in there.

I'm trying to convert back from IBProArcade. I think I got everything, but apparently I missed something.

Here's the arcade page:

http://www.powwows.com/gathering/arcade.php

The header shows, but nothing else???

Thanks

Ok, got that part working. Now you can see all the games and my old scores are still there.

Now when you play a game, it won't submit the score. It says, waiting on powwows.com, but it doesn't go through??

Thanks!!

I've only recieved 2 error emails, and not for the games I was trying. But maybe it will help:

PHP Code:


		
			
Database error in vBulletin 3.0.0:



Invalid SQL: UPDATE games SET highscorerid=,highscore=65750 WHERE shortname='moonpatrol'

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 'highscore=65750 WHERE shortname='moonpatrol'' at line 1



mysql error number: 1064

PHP Code:


		
			
Database error in vBulletin 3.0.0:



Invalid SQL: UPDATE games SET highscorerid=,highscore=65750 WHERE shortname='moonpatrol'

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 'highscore=65750 WHERE shortname='moonpatrol'' at line 1



mysql error number: 1064

Maybe this bug has already been reported, but with 250+ pages to search through, I thought I would try this...

So the bug is this: When someone matches the high score for a game, the arcade homepage will sometimes show the wrong trophy holder. It appears the query to select the current champ is a bit flawed as it queries only for the highest score, and if it finds two or more, will sometimes select the wrong person (ie. The person who did not get the high score first.)

The bug appears to be in this code block in the arcade.php file:

PHP Code:


		
			
    // While loop, where part of an SQL query is constructed

    while ($thesession = $DB_site->fetch_array($result_topscores))

    {

        $where[] = "(gamename='$thesession[gamename]' AND score='$thesession[score]')";

        $playedcounter[$thesession[gamename]] = $thesession['played'];

    }

    $DB_site->free_result($result_topscores);

    // Query built

    if(!empty($where)) {

        $whereclause = "WHERE ".implode(' OR ', $where);

    }

    

    // Query to get the other data for the high scores

    $result_topscore2 = $DB_site->query("

        SELECT gamesessions.*, user.username, user.userid, games.*, games.title AS title FROM " . TABLE_PREFIX . "gamesessions AS gamesessions

        LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = gamesessions.userid

        LEFT JOIN " . TABLE_PREFIX . "games AS games ON gamesessions.gamename = games.shortname

        $whereclause AND $sessionclause ORDER BY gamesessions.gamename DESC

    ");

This query needs to be modified to search for the high score AND the lowest final session time (final). I lack the SQL skill to get this done, can anyone help out here?

Thank you!

I've started over from scratch. Now you can play the games, but it won't submit scores. None of the games work. They just hang there at the end.

I've seen several people post about this, but no solutions.

Help!!!

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05453 seconds Memory Usage 1,764KB 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 (4)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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: