vb.org Archive - Major Additions - ibProArcade

Hi, Im having problems with the footer layout since installing the game... seems to have lost its original format...
https://vborg.vbsupport.ru/external/2010/04/69.jpg

anyone can help me?

wikked

01-10-2010 10:58 AM

Quote:

Originally Posted by wikked (Post 1951012)

Everything installed fine

tested out the first game which played ok...new score showed ok

but then trying to access the arcade again brings up this database error

i can access the games individually but cant get to the arcade home as soon as a score is posted. I have removed and reinstalled and the same error occurred

Help please :D:D:up:

by the way...im running Vb CMPS and had to do the changes to get the scores to be recorded

anyone?

wikked

01-11-2010 06:33 PM

Quote:

Originally Posted by wikked (Post 1951012)

just done another instal today following every instruction to the letter byt again as soon as it posts a score i get the following database error

Quote:

mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM user WHERE userid=1) AS user LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=1 OR user.userid=1

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 'SELECT * FROM user WHERE userid=1) AS user LEFT JOIN avatar AS
mySQL error code:
Date: Saturday 09th of January 2010 12:30:14 PM

can anyone shed any light on this as its doing my head in now :down:

TimberFloorAu

01-12-2010 03:30 AM

Quote:

Originally Posted by WEBDosser (Post 1951354)

would like this sorted too.

This has been mentioned MANY MANY times mate.

edit index.php ( in forum root )

after:

Code:

<?php

add

Code:

// ibProArcade

if($_POST['module'] == "pnFlashGames")

{

        require_once('./global.php');



        switch($_POST['func'])

        {

                case "storeScore":

                $_GET['act'] = "Arcade";

                $_GET['module'] = "arcade";

                $_GET['do'] = "pnFStoreScore";

                break;



                case "saveGame":

                $_GET['do'] = "pnFSaveGame";

                break;



                case "loadGame":

                $_GET['do'] = "pnFLoadGame";

                break;



                case "loadGameScores":

                $gid = $vbulletin->input->clean_gpc('p', 'gid', TYPE_INT);

                $uid= $vbulletin->userinfo['userid'];

                $game = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "games_scores WHERE mid=$uid AND gid = $gid ORDER BY score DESC LIMIT 0,1");

                $scores = $game[score];



                if($scores != false)

                {

                        //Return true

                        print "&opSuccess=true&gameScores=$scores&endvar=1"; //send endvar to keep opSuccess separate from all other output from PostNuke

                }

                else

                {

                        print "&opSuccess=false&error=Error&endvar=1";

                }

                break;

        }

}



$act = $_GET[act];

$autocom = $_GET[autocom];

$showuser= $_GET[showuser];

if($act == "Arcade" || $autocom=="arcade") {

include "arcade.php";

exit();

}

if(!empty($showuser) && $showuser >= 1) {

$u = $showuser;

$_GET[u] = $showuser;

include "member.php";

exit();

}

// ibProArcade

Sorted

Nintendo-Daily

01-12-2010 04:00 PM

Is there some kind of exploit that can be used in Video Poker in the Casino? I have one member who is winning a TON of credits and that's the only game he plays in the casino. Is there possibly a bug with the Video Poker feature? Has anyone else seen this?

Juggernaut

01-13-2010 12:41 AM

The fonts in the arcade are extremely difficult to read with any skin I install, is there
a way to fix this in the arcade settings or by altering a file?

WEBDosser

01-13-2010 06:26 AM

Quote:

Originally Posted by TimberFloorAu (Post 1953258)

This has been mentioned MANY MANY times mate.

edit index.php ( in forum root )

after:

Code:

<?php

add

Code:

// ibProArcade

if($_POST['module'] == "pnFlashGames")

{

        require_once('./global.php');



        switch($_POST['func'])

        {

                case "storeScore":

                $_GET['act'] = "Arcade";

                $_GET['module'] = "arcade";

                $_GET['do'] = "pnFStoreScore";

                break;



                case "saveGame":

                $_GET['do'] = "pnFSaveGame";

                break;



                case "loadGame":

                $_GET['do'] = "pnFLoadGame";

                break;



                case "loadGameScores":

                $gid = $vbulletin->input->clean_gpc('p', 'gid', TYPE_INT);

                $uid= $vbulletin->userinfo['userid'];

                $game = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "games_scores WHERE mid=$uid AND gid = $gid ORDER BY score DESC LIMIT 0,1");

                $scores = $game[score];



                if($scores != false)

                {

                        //Return true

                        print "&opSuccess=true&gameScores=$scores&endvar=1"; //send endvar to keep opSuccess separate from all other output from PostNuke

                }

                else

                {

                        print "&opSuccess=false&error=Error&endvar=1";

                }

                break;

        }

}



$act = $_GET[act];

$autocom = $_GET[autocom];

$showuser= $_GET[showuser];

if($act == "Arcade" || $autocom=="arcade") {

include "arcade.php";

exit();

}

if(!empty($showuser) && $showuser >= 1) {

$u = $showuser;

$_GET[u] = $showuser;

include "member.php";

exit();

}

// ibProArcade

Sorted

i think i will leave it if this is required as editing files voids support.

All times are GMT. The time now is 04:29 AM.

Page 535 of 758

535

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

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