vb.org Archive

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)

Blam Forumz 11-27-2005 03:10 PM

I repeat, :(

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO arcade_games VALUES (1, 'asteroids', 'Asteroids', 'Kill some asteroids and flying saucers!', 'asteroids.swf', '500', '375', '', 'asteroids1.gif', 7, 0, 0, '', 1, 29, 1110794236, 0, 0, 0, 0, 0, 0, 0, 0);

MySQL Error  : Column count doesn't match value count at row 1
Error Number : 1136
Date        : Sunday, November 27th 2005 @ 11:45:04 AM
Script      : http://www.blamforums.com/forum/arcadeupdate.php
Referrer    :
IP Address  : 86.137.210.113
Username    : Blaminator
Classname    : vb_database


When trying to run the arcadeupdate.php file :/

Vizionz 11-27-2005 03:12 PM

you repeating aint helping nothing specially when the coder is asleep after 60 hours of coding. so be patient he will be back and help out, but posting it over and over and over is not gonna make your problem get fixed faster

Blam Forumz 11-27-2005 03:13 PM

Calm down, I only posted it twice, and just because the coder isn't awake, doesn't mean other people can't help me

BoYagoob 11-27-2005 03:15 PM

Thanks a lot :)

nexus851 11-27-2005 03:18 PM

Quote:

Originally Posted by ConqSoft
The game has to be modified to work. "just any old flash game" won't work.

how do you modify the flash games to make it work and send the score to the v3 arcade ranking????

Maagic 11-27-2005 03:18 PM

Quote:

Originally Posted by Blam Forumz
Calm down, I only posted it twice, and just because the coder isn't awake, doesn't mean other people can't help me

True, but if no one offered any advice after your first post, bumping it won't really help. In fact some go out of their way to not help people who bump their own posts.

I'm getting that error as well, but I have my arcade disabled until the coder wakes back up and can help or someone else happens upon a fix.

ConqSoft 11-27-2005 03:21 PM

Quote:

Originally Posted by nexus851
how do you modify the flash games to make it work and send the score to the v3 arcade ranking????

There are instructions on the v3arcade.com site. You will have to have the "source" to the game, and permission from the game author to edit it.

Chadi 11-27-2005 03:25 PM

What's wrong with this site?
http://www.vbulletingames.com/Database/

I registered, confirmed, logged in and see no download options

nexus851 11-27-2005 03:27 PM

Quote:

Originally Posted by ConqSoft
There are instructions on the v3arcade.com site. You will have to have the "source" to the game, and permission from the game author to edit it.

where on v3arcade site???? i cant seem to find it..

i have a few games with author permissions so that's why i would like to know how to edit these flash games for scoring...

ConqSoft 11-27-2005 03:27 PM

That site has nothing to do with this hack...

ConqSoft 11-27-2005 03:28 PM

Quote:

Originally Posted by nexus851
where on v3arcade site???? i cant seem to find it..

i have a few games with author permissions so that's why i would like to know how to edit these flash games for scoring...

http://www.v3arcade.com/forums/showthread.php?t=272

WNxWakko 11-27-2005 03:29 PM

oh ya, Ive been waiting for this release. V3 Rocks!

I am not to fond of what ibProArcade is doing regarding limitations of game downloads and forcing members to post ads to get in.

GoTTi 11-27-2005 03:31 PM

Quote:

Originally Posted by chadi
What's wrong with this site?
http://www.vbulletingames.com/Database/

I registered, confirmed, logged in and see no download options

you need to wait a day or so for the admin to activate your account. he does it manually.

nexus851 11-27-2005 03:33 PM

Quote:

Originally Posted by ConqSoft

seems like i dont have access to that thread b/c i didnt buy the unbranded option.. may you please paste the instructions in this thread so i can figure out the flash games,... greatly appreciated... =)

jrofosho 11-27-2005 03:33 PM

It seems like a common problem with the installation is that the database changes are being made. Any clue why? I have none of the database tables that were supposed to be added.

yoyoyoyo 11-27-2005 03:33 PM

Quote:

Originally Posted by WNxWakko
I am not to fond of what ibProArcade is doing regarding limitations of game downloads and forcing members to post ads to get in.

IBP Pro Arcade that is released here has nothing to do with the ibproarcade site, so it is unfair to make comparisons in that regard. There are many other places to get games other than on that site for IBP pro arcade.

redlabour 11-27-2005 03:33 PM

What about a german Translation ?

PixelFx 11-27-2005 03:33 PM

Quote:

Originally Posted by AshokForums.com
Thanks.. You rock john.. :)

woot, congrats on your release john :D

Zelda-King 11-27-2005 03:34 PM

A smooth upgrade. :)

A couple of observations after upgrading from the latest beta;

- I get no challenge link in the postbit dropdown in spite of enabling them in my profile. I don't see challenge setting in the admin settings either. (I wonder why that is. It seems some other people have it.)

- The download link has disappeared after the upgrade.

- There's a setting to make awards show in the postbit and profiles but nothing shows in profiles.

Oh, and is there any additional functionality added since the beta stage that we should know about?

ConqSoft 11-27-2005 03:34 PM

Quote:

Originally Posted by nexus851
seems like i dont have access to that thread b/c i didnt buy the unbranded option.. may you please paste the instructions in this thread so i can figure out the flash games,... greatly appreciated... =)

It just has a link to here, which is public: http://www.gamerseuphoria.com/temp/v...tructions.html

Lea Verou 11-27-2005 03:34 PM

Ehm, sorry to ask such a dumb question but I searched the whole thread and can't find the answer :o
I need to upgrade from the 3.0.x version.
The manual only writes about installation, not upgrade, and just mentions that there is an import script.
I tried running the import script but I got a db error (I don't know exactly what as the mail hasn't come yet).
What should I do and in what order?

Thanks a lot in advance :)
I told my users that the arcade came out and they are almost party-ing :p

ConqSoft 11-27-2005 03:36 PM

Quote:

Originally Posted by Michelle
Ehm, sorry to ask such a dumb question but I searched the whole thread and can't find the answer :o
I need to upgrade from the 3.0.x version.
The manual only writes about installation, not upgrade, and just mentions that there is an import script.
I tried running the import script but I got a db error (I don't know exactly what as the mail hasn't come yet).
What should I do and in what order?

Thanks a lot in advance :)
I told my users that the arcade came out and they are almost party-ing :p

After you install, run the arcadeimport.php that comes with it. It's in the AdminCP directory.

Lea Verou 11-27-2005 03:38 PM

Quote:

Originally Posted by ConqSoft
After you install, run the arcadeimport.php that comes with it. It's in the AdminCP directory.

Oh, after I install!!! Thanks a lot!!
And what about the database? Should I drop any fields? It writes something about that but I'm kinda scared to do it :o

jbd 11-27-2005 03:39 PM

All installed and running perfectly with 976 games on

http://www.GamesForum.com

Thanks very much Mr. Zeropage :)

nexus851 11-27-2005 03:42 PM

Quote:

Originally Posted by ConqSoft
It just has a link to here, which is public: http://www.gamerseuphoria.com/temp/v...tructions.html

wow that looks complicated... any newbie manual in english laymen's terms for that same instruction? =(

The Icon 11-27-2005 03:42 PM

Hey guys,

I'm getting the following error message on the 'Data Rebuilding' stage of the import script (i've deliberately taken out my IP address and username details from the message):

Invalid SQL:
UPDATE arcade_games AS arcade_games SET sessioncount=2017, highscorerid=10832, highscore=4283.000 WHERE gameid=1;

MySQL Error : You have an error in your SQL syntax near 'AS arcade_games SET sessioncount=2017, highscorerid=10832, highscore=4283.000 WH' at line 1
Error Number : 1064
Date : Sunday, November 27th 2005 @ 05:15:08 PM
Script : http://**************/admincp/arcadeimport.php
Referrer : http://***************/admincp/arcad...&startat=17000
IP Address : ***********
Username : ***********
Classname : ***********


Any ideas why this might be happeneing?

ConqSoft 11-27-2005 03:43 PM

Quote:

Originally Posted by nexus851
wow that looks complicated... any newbie manual in english laymen's terms for that same instruction? =(

That is in laymen's terms, if you know flash. If you don't know flash, then you're out of luck. ;)

sensimilla 11-27-2005 03:44 PM

Quote:

Originally Posted by jbd
All installed and running perfectly with 976 games on

http://www.GamesForum.com

Thanks very much Mr. Zeropage :)

wrong topic this is not ibproarcade thread

nexus851 11-27-2005 03:48 PM

Quote:

Originally Posted by ConqSoft
That is in laymen's terms, if you know flash. If you don't know flash, then you're out of luck. ;)

any idea where's a quick tutorial where i can learn enough to just implement the instructions?



P.S - if i dont do this, then that means no highest score will be recorded only, right??

ConqSoft 11-27-2005 03:53 PM

Yes, it means their score won't be recorded.

PKassab 11-27-2005 03:53 PM

Im gettin this error

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

nexus851 11-27-2005 04:00 PM

How do i challenge other players???? (i already turned on challenge in the profile options but I still dont see the commands anywhere for challenging others)

ConqSoft 11-27-2005 04:01 PM

When you click their name in a post, it's on the dropdown, if they chose to allow themselves to be challenged. (In their User CP -> Arcade Options settings.)

nexus851 11-27-2005 04:07 PM

Quote:

Originally Posted by ConqSoft
When you click their name in a post, it's on the dropdown, if they chose to allow themselves to be challenged. (In their User CP -> Arcade Options settings.)

it's on, but when i click their name in the post... it doesnt show it on the dropdown list.. do they have to be online to work???

ConqSoft 11-27-2005 04:08 PM

No, but THEY have to choose to make themselves available for challenges, in THEIR User CP.

And, you did make the template changes shown in the installation instructions?

ReadOrDie 11-27-2005 04:08 PM

What games does this come with?

nexus851 11-27-2005 04:11 PM

Quote:

Originally Posted by ConqSoft
No, but THEY have to choose to make themselves available for challenges, in THEIR User CP.

And, you did make the template changes shown in the installation instructions?

yeah, i made it in "postbit" not postbit_legacy... (whats the difference? or do i have to do both???)

ConqSoft 11-27-2005 04:12 PM

It depends on which postbit you're using. If your user info is shown at the left, then you're using the legacy.

Mastar 11-27-2005 04:13 PM

GETTING THIS ERROR WHEN CLICK ON THE ARCADE LINK ON MY FORUM:

Code:



Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT arcade_challenges.*, touser.username AS tousername, fromuser.username AS fromusername, arcade_games.miniimage, arcade_games.title FROM arcade_challenges AS arcade_challenges

 LEFT JOIN user AS touser ON (touser.userid=arcade_challenges.touserid)

 LEFT JOIN user AS fromuser ON (fromuser.userid=arcade_challenges.fromuserid)

 LEFT JOIN arcade_games AS arcade_games ON (arcade_games.gameid=arcade_challenges.gameid)

 WHERE status=3 ORDER BY datestamp DESC LIMIT 3;

MySQL Error  : Table 'Funnies_the.arcade_challenges' doesn't exist

Error Number : 1146

Date        : Monday, November 28th 2005 @ 02:17:36 AM

Script      : http://www.thebedrocktavern.com/arcade.php?

Referrer    : http://www.thebedrocktavern.com/index.php?

IP Address  : 12.109.5.38

Username    :Funny Man

Classname    : vb_database

AND GOT THIS WHEN I CLICK ON GAMES IN THE ACP:

Code:

Database error in vBulletin 3.5.1:

Invalid SQL:

  SELECT COUNT(*) AS total

  FROM arcade_games AS arcade_games;

MySQL Error  : Table 'Funnies_the.arcade_games' doesn't exist

Error Number : 1146

Date        : Monday, November 28th 2005 @ 02:22:42 AM

Script      : http://www.thebedrocktavern.com/admincp/arcadeadmin.php?do=games

Referrer    : http://www.thebedrocktavern.com/admincp/index.php

IP Address  : 12.109.5.38

Username    :Funny Man

Classname    : vb_database

ANY HELP?

nexus851 11-27-2005 04:13 PM

Quote:

Originally Posted by ConqSoft
It depends on which postbit you're using.


sorry, what do u mean by that??? im sorta a newbie to this "postbit" definition... pls explain...

my user info is shown on the top... how do i change to show on the left?


All times are GMT. The time now is 11:01 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.03442 seconds
  • Memory Usage 1,840KB
  • 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_code_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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