vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   vbProArcade Beta 2 (https://vborg.vbsupport.ru/showthread.php?t=42880)

defcon1 11-25-2003 09:28 PM

I have everything working ....'cept I can't figure out how to get the arcade to work with my theme(surge from vbskins). Proarcade can be used with any theme(skin) right?? If not what needs to be modified? It works fine with the default theme.

Thank you
Deffy

Digikilla 11-26-2003 08:18 PM

Well I installed Pro Arcade and when I go to the admin Pannel for it I get this error

Code:

Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: SELECT * FROM arcadeconfig
mysql error: Table 'd60003098.arcadeconfig' doesn't exist

mysql error number: 1146

Date: Wednesday 26th of November 2003 05:02:50 PM
Script: http://www.killuclan.com/forums/foru...changeoptions&
Referer: http://www.killuclan.com/forums/admi...n=nav&cpnavjs=

I went to myphpadmin and checked and the SQL quiries are there but the SQL Database has a diffrent name than the one above. So I went to the config.php file and changed it (backed up the original) to the correct database/username/pw and loaded it up.

The whole site went down. I loaded the orgiginal config.php file and every thing came back, but I still have the problem with the arcade hack pointing to what the config.php file says is the corect SQL but myphpadmin says is incorrect. How do I get the Pro Arcade to look to the correct SQL Database and still have a working site?

DigiKilla

GamerForums.net 11-29-2003 10:12 AM

I have searched this thread for about an hour trying to find someone with the exact same problem or a solution to adding games. Everything works fine with the arcade except that when i try to edit a game or add a game I get an error. This is the error that i recieve when trying to add a game.
Anyone know what the problem might be?

CODE:

Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: INSERT INTO arcadegames (name,title,description,filename,active,scorevar,w idth,height,codebase,querystri ng,
objectparam,embedparam,championactive,championtext ,championcolor,playcost,jackpo t,jackpotadd,thumbnailname,thumbnaildata)
VALUES ('asteroids','Asteroids','A Great Arcade Classic.','asteroids.swf','0','$asteroidsscore','' ,'','','',
'','','1','Asteroids Champion','','10','0','5','asteroids.gif','GIF89a\ 0\0÷\0\0\0\0\0ÿÿÿ
%#%1/1;9;:8:hehgdgHFH@>@}z}NLNKIK*)*(\'(˜•˜—”—„ „ece_]_VTV323/./.-.,+,+*+²¯²«¨«¢Ÿ¢|z|xvxvtv?>?<;<:9:6565454 34ÖÓÖ¨¦¨¦¤¦›™›”’”‘‘‹ŒŠŒ ‰‡‰‡…‡NMNDCD· µ·~{z{zyzvuvututstsrshghede[Z[¨§¨”“”Œ‹ŒŠ‰Š‰ˆ‰…„…‚‚\0\0\0\0 \0\0\0\0

#
.1.585(*(&(&ADAEHEZ]Z9;9 qtqnqn`b`\\^\\232./.,-,+,+}}vxvuwutvtprp898GHGEFEßáßuvututmnm ¸·°±°›œ›”•”ŽŽííí¨¨¨¤¤¤Œ Œ………yyyv vvuuugggeee\\\\\\VVVOOO???>>>===<<<;;;666555444222///,,,+++***&&&\"\"\" ÿÿÿ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ 0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0!ù\0\0 ž\0,\0\0\0\0\0\0\0ÿ\0(° @ *\\˜p’P*aH1áBTÜ8p €p°PYƒ‰#G5\0HÀÄ&K˜È„YÑ#ƒ
9yxQÉ$Å DfŠ\0\0ENO¢,d P‚›ÎxI´Ñ
FVq@ÔåÊÂ&\00ÀPxGŽ<Cð¨Í‚E)K4° ¥…thªèˆÏCI&\0`ºKšA&à a#ÐãÂE<p<AâÇF=Ll¼AB…ÉF
Uć\0°A‹f¸ ˆ¡Ó¨+Bòအ„>Ž|
’C¥B
?ªèfºÃÈB0q¶è>
’„Q¾\\ Ÿ=;% #©SuÎ
S8 ƒŒ“ïy`àdŠI”Äö vÄ\0Rè¡$p¾î1f´@!s\\ò]B(”ðH$4(r`Bj|ñFV\00уiáFøaHPYˆá!tœø·\\ @\0;')
mysql error: Unknown column 'width' in 'field list'

mysql error number: 1054

Thanks,
Sidney

Pseudomizer 11-29-2003 10:27 AM

Hi,

this is your query:

Quote:

INSERT INTO arcadegames (name,title,description,filename,active,scorevar,w idth,height,codebase,querystri ng,
objectparam,embedparam,championactive,championtext ,championcolor,playcost,jackpo t,jackpotadd,thumbnailname,thumbnaildata)
There seems to be a problem with the list of your parameters. Do the following command in the command line and compare the paramaters:

Quote:

mysqlshow -u user -p password database arcadegames
You should see the table arcadegames and all corresponding fields. Compare these fields with query i quoted and you should find your problem straight away.

Cheers,

Pseudomizer

GamerForums.net 11-29-2003 06:22 PM

Thanks for the assistance,

I have done this and added the columns "height" , "width" , "codebase" , "querystring" , "objectparam" in the arcadegames table, and it solved the problem of adding the new game, but for some reason it is not passing the score variables now. The game is Asteroids, and it just loads the blank leaderboard after the game is completed.

Pseudomizer 11-29-2003 06:37 PM

Hmmm. Then it's either the wrong variable for the score OR the hash is wrong. Please check with the corresponding game thread and the description for this specific game.

Cheers,

Pseudomizer

SharronH 11-30-2003 01:20 AM

Any updates on v2.1 guys? Keep up the hard work guys. This is one of the best hacks I've seen.

PixelFx 11-30-2003 01:55 PM

I've worked out a lot of the template stuff and sent one update to future real, I'm hoping to get another done today. Although I haven't seen him online much this week, so not sure if we are just missing each other or not.

I have it setup here, the current version of 2.1 on the template side doesn't look much different, but how the arcade installs is much more stable and cleaner. I've tried to make the templates very easy to update for different colored layouts.

demo: http://www.orbsydia.com/forum/proarc...?action=arcade (vbproarcade 2.1 & vb2.3.3)

SharronH 11-30-2003 06:05 PM

It looks very nice.... looking forward for it to get released soon. Good job! :)

FinalAngel 12-01-2003 12:17 PM

hi,
i have an Error with Netscape after I play a Game then come Game Over and:
"vbProArcade Error: Invalid game name specified (todo: put something pretty here later)"
who can help me


All times are GMT. The time now is 02:07 PM.

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.02810 seconds
  • Memory Usage 1,747KB
  • 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
  • (1)bbcode_code_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