vb.org Archive
Page 4 of 312 « First 23 4 561454104 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - v3 Arcade - Games Arcade System for 3.6.0 (https://vborg.vbsupport.ru/showthread.php?t=114012)

pyro.699 11-27-2005 11:36 AM
damit nvm /;

Error:
PHP Code:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635 
got this when updating my usergroups

jaffaman 11-27-2005 11:36 AM
I am getting this as well i have updated from a beta version
PHP Code:
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
    LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
    LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
    LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
    WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error  : Unknown table 'arcade_challenges'
Error Number : 1051
Date         : Sunday, November 27th 2005 @ 08:32:35 AM
Script       : http://www.grimreapers.co.uk/vb/arcade.php
Referrer     : http://www.grimreapers.co.uk/vb/arcade.php
IP Address   : 212.159.109.203
Username     : jaffaman
Classname    : vb_database 

tidy_boy 11-27-2005 11:38 AM
Quote:
Originally Posted by John
That's weird. Run this:

CREATE TABLE arcade_challenges (
challengeid int(10) unsigned NOT NULL auto_increment,
fromuserid int(10) unsigned NOT NULL default '0',
touserid int(10) unsigned NOT NULL default '0',
winnerid int(10) unsigned NOT NULL default '0',
loserid int(10) unsigned NOT NULL default '0',
gameid int(10) unsigned NOT NULL default '0',
datestamp int(10) unsigned NOT NULL default '0',
fromsessionid int(10) unsigned NOT NULL default '0',
tosessionid int(10) unsigned NOT NULL default '0',
fromscore float(15,3) unsigned NOT NULL default '0.000',
toscore float(15,3) unsigned NOT NULL default '0.000',
status tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
)

It should have done that as part of the product upgrade, though. :/
That did not work still get an error

John 11-27-2005 11:39 AM
Quote:
Originally Posted by tidy_boy
That did not work still get an error
The same error?

Lizard King 11-27-2005 11:40 AM
It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.

tidy_boy 11-27-2005 11:40 AM
Quote:
Originally Posted by John
The same error?
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error : Unknown table 'arcade_challenges'
Error Number : 1051
Date : Sunday, November 27th 2005 @ 02:38:05 PM
Script : http://www.harddanceaddict.net/forum/arcade.php
Referrer : http://www.harddanceaddict.net/forum/index.php
IP Address :
Username : tidy_boy
Classname : vb_database

John 11-27-2005 11:40 AM
Quote:
Originally Posted by jaffaman
I am getting this as well i have updated from a beta version
PHP Code:
Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM vb3_arcade_challenges
    LEFT JOIN vb3_user AS touser ON (touser.userid=arcade_challenges.touserid)
    LEFT JOIN vb3_user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)
    LEFT JOIN vb3_arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)
    WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error  : Unknown table 'arcade_challenges'
Error Number : 1051
Date         : Sunday, November 27th 2005 @ 08:32:35 AM
Script       : http://www.grimreapers.co.uk/vb/arcade.php
Referrer     : http://www.grimreapers.co.uk/vb/arcade.php
IP Address   : 212.159.109.203
Username     : jaffaman
Classname    : vb_database 
And if you try to add the table manually, using that query I posted?

jaffaman 11-27-2005 11:40 AM
This is the error i get

An error occurred while attempting to execute your query. The following information was returned.
error number: 1050
error desc: Table 'arcade_challenges' already exists

John 11-27-2005 11:41 AM
Quote:
Originally Posted by Lizard King
It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.
admincp/arcadeimport.php :)

Zachariah 11-27-2005 11:42 AM
Quote:
Originally Posted by Lizard King
It worked out. Thanks for the awesome script John. I have one question. I still have all my games and i never dropped my tables. Is there any chance i can get these games working ? Because i dont have the game install scripts anymore.
Ouch, usaly in the install script has size, keys to use, directions, and the $score key to use for that game.


All times are GMT. The time now is 12:27 PM.
Page 4 of 312 « First 23 4 561454104 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03087 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
  • (3)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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