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)

The Chief 11-30-2005 01:53 AM

Quote:

Originally Posted by Cap'n Steve
For everyone getting errors upgrading from 1.0.0 to 1.0.1, running these two queries should enable you to upgrade successfully.

Code:

DELETE FROM $TParcade_news WHERE newsid = 1
Code:

DELETE FROM $TParcade_categories WHERE categoryid IN(1, 2, 3, 4, 5, 7, 8)
Be sure to replace $TP with your table prefix.

What could be my table prefix??

Cap'n Steve 11-30-2005 01:55 AM

It's in your includes/config.php. It's one of the options you set when you first install vBulletin.

Mastar 11-30-2005 01:56 AM

Good to go have it working. Thanks John for the upgrade.

The Chief 11-30-2005 01:57 AM

Quote:

Originally Posted by Cap'n Steve
It's in your includes/config.php. It's one of the options you set when you first install vBulletin.

it says that I don't have any, ' '??

Cap'n Steve 11-30-2005 02:00 AM

Then just replace the $TP with nothing.

BamaStangGuy 11-30-2005 02:04 AM

Quote:

Originally Posted by Cap'n Steve
For everyone getting errors upgrading from 1.0.0 to 1.0.1, running these two queries should enable you to upgrade successfully.

Code:

DELETE FROM $TParcade_news WHERE newsid = 1
Code:

DELETE FROM $TParcade_categories WHERE categoryid IN(1, 2, 3, 4, 5, 7, 8)
Be sure to replace $TP with your table prefix.


I love you

The Chief 11-30-2005 02:07 AM

Quote:

Originally Posted by Cap'n Steve
Then just replace the $TP with nothing.

ok this seemed to work but I lost some highscores, mostly some from the default games??



That's pretty weird... but at least it is better then nothing ;)

Thanks!

The Chief 11-30-2005 02:10 AM

Quote:

Originally Posted by gamebgs
ok this seemed to work but I lost some highscores, mostly some from the default games??



That's pretty weird... but at least it is better then nothing ;)

Thanks!

I take that back, it just seemed that when I reuploaded my files it had like copied the games twice, so I just deleted them.

Thanks John also for this great product :)

Cap'n Steve 11-30-2005 02:16 AM

That's odd. The queries I posted just delete the default news and categories, which was what was causing those errors. The high scores must get overwritten when the import re-adds the default games.

The Chief 11-30-2005 02:26 AM

Quote:

Originally Posted by Cap'n Steve
That's odd. The queries I posted just delete the default news and categories, which was what was causing those errors. The high scores must get overwritten when the import re-adds the default games.


Well I think it has been fixed, it just deleted the images and some games, weird, but now everything is working fine :)

Thankls!

sully02 11-30-2005 02:41 AM

Quote:

Originally Posted by gamebgs
Well I think it has been fixed, it just deleted the images and some games, weird, but now everything is working fine :)

Thankls!

Hey, John... I know you've got a lot on your plate with this modification, but what is the feasibility of adding a tournament feature to this? I think that would make a sweet mod even better.

Clanshosting 11-30-2005 03:07 AM

Hm..what about my post like 4 pages ago? It says for more games go to your website, but none are listed.

Anyone else know where to get a boatload of games?

The Chief 11-30-2005 03:19 AM

Quote:

Originally Posted by Clanshosting
Hm..what about my post like 4 pages ago? It says for more games go to your website, but none are listed.

Anyone else know where to get a boatload of games?

uhh...http://vbulletingames.com/?

BamaStangGuy 11-30-2005 04:46 AM

Quote:

Originally Posted by gamebgs

Holy shit I love you too!

G-Force 199 11-30-2005 07:25 AM

How to import a game ?
I uploaded to my "games" folder but cant import from Admin CP

Code:

Fatal error: Call to a member function on a non-object in C:/Xampp/htdocs/forum/admincp/arcadeadmin.php on line 586

Paul M 11-30-2005 07:27 AM

Did you upload to the games folder in admincp, not the one in your forum root ?

G-Force 199 11-30-2005 07:36 AM

I uploaded to my forum root & admincp games folder but no result.

Moparx 11-30-2005 07:44 AM

Found another bug John. Line 670 of arcade.php
PHP Code:

            $postcheck $db->query_first("SELECT COUNT(*) AS count FROM post WHERE userid=" $vbulletin->userinfo['userid'] . " AND dateline<" TIMENOW " AND dateline>" . (TIMENOW-(24*60*60))); 

the table prefix was left off of post which causes a database error if someone uses the new post per day option

trilljester 11-30-2005 08:29 AM

Uninstalled this unfortunately. Could never get it to upgrade correctly. Went back to IBPro which has a new version and works great. No issues with the upgrade there.

I like the concept of v3Arcade, just don't like the quirks/bugs/installation woes. Maybe down the road a little when it's more stable.

Jon_Simmonds 11-30-2005 08:31 AM

Quote:

Originally Posted by Cap'n Steve
For everyone getting errors upgrading from 1.0.0 to 1.0.1, running these two queries should enable you to upgrade successfully.

Code:

DELETE FROM $TParcade_news WHERE newsid = 1
Code:

DELETE FROM $TParcade_categories WHERE categoryid IN(1, 2, 3, 4, 5, 7, 8)
Be sure to replace $TP with your table prefix.

I had to use those queries, as well as editing the product so it would not add the included games again to upgrade, and it all works good now ;)

egyptsons 11-30-2005 08:42 AM

When I import the product file (making sure overwrite is yes) I get the following sql error

Code:

Database error in vBulletin 3.5.1:

Invalid SQL:
INSERT INTO arcade_categories VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sp ort',4),(5,'Shooters',5),(1,'Other',100),(2,'Favor ites',101);

MySQL Error : Duplicate entry '7' for key 1
Error Number : 1062


Oblivion Knight 11-30-2005 08:45 AM

Please refer to the following bug (and fix):
http://www.v3arcade.com/forums/vbugs...iew&vbug_id=50

:)

egyptsons 11-30-2005 09:18 AM

Quote:

Originally Posted by Oblivion Knight
Please refer to the following bug (and fix):
http://www.v3arcade.com/forums/vbugs...iew&vbug_id=50

:)

Thanks I do it

memoriess 11-30-2005 11:12 AM

Hi, I tried to import the plugins, but it keep loading and loading.. Very long.

John 11-30-2005 12:24 PM

Quote:

Originally Posted by fringehead
Maybe if you had better instructions and included the details I wouldn't have to read every single post in these forums to find the information you left out in the 1st place. Try to improve the documentation... First and foremost try to be polite to people. Ignoring people is just rude.

I see many people have suggested you add the info to the docs, but I guess you decided against it.

Here is the link to the thread with the information on how to change the permissions so you can use the arcade:

http://www.v3arcade.com/forums/showt...set+permission

53 pages of support questions in a couple of days, if I replied to everyone who was too lazy to search the thread I'd never have any time for anything else.

ShadowOne 11-30-2005 01:43 PM

Everything works great for me....

glorify 11-30-2005 01:51 PM

sql error on challenges--any ideas?

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO arcade_challenges (fromuserid, touserid, gameid, datestamp, status) VALUES (1, 559, 100, 1133364256, '1');

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, November 30th 2005 @ 09:24:16 AM
Script : http://www.glorifythepast.com/forums/arcade.php

John 11-30-2005 02:06 PM

Quote:

Originally Posted by glorify
sql error on challenges--any ideas?

Upgrade to 1.0.2. (Uploading it now.)

Impreza04 11-30-2005 02:24 PM

Still getting the error even with 1.0.2

PHP Code:

Invalid SQL:
INSERT INTO vB_arcade_categories VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sport',4),(5,'Shooters',5),(1,'Other',100),(2,'Favorites',101);

MySQL Error  Duplicate entry '7' for key 1
Error Number 
1062
Date         
WednesdayNovember 30th 2005 04:23:26 PM
Script       
http://www.playstation-racing.co.uk/forum/admincp/plugin.php
Referrer     http://www.playstation-racing.co.uk/forum/admincp/plugin.php?do=productadd 


John 11-30-2005 02:27 PM

Quote:

Originally Posted by Impreza04
Still getting the error even with 1.0.2

PHP Code:

Invalid SQL:
INSERT INTO vB_arcade_categories VALUES (7,'Puzzle',1),(8,'Action',2),(3,'Retro',3),(4,'Sport',4),(5,'Shooters',5),(1,'Other',100),(2,'Favorites',101);

MySQL Error  Duplicate entry '7' for key 1
Error Number 
1062
Date         
WednesdayNovember 30th 2005 04:23:26 PM
Script       
http://www.playstation-racing.co.uk/forum/admincp/plugin.php
Referrer     http://www.playstation-racing.co.uk/forum/admincp/plugin.php?do=productadd 


You'd only get that if your product was uninstalled, and your tables already exist. You can use the attached XML file to install, which will skip the inserting of new records.

Impreza04 11-30-2005 02:29 PM

Hmm, I has been uninstalled..
ANy idea how to fix it?

EDIT: Thanks John :)

Snoop-It 11-30-2005 02:32 PM

Upgrade was successful :D cheers John!

John 11-30-2005 02:34 PM

Quote:

Originally Posted by Impreza04
Hmm, I has been uninstalled..
ANy idea how to fix it?

https://vborg.vbsupport.ru/showpost....&postcount=790

jesus likes pie 11-30-2005 02:46 PM

does 1.0.2 fix game install problems?

renots 11-30-2005 02:46 PM

Posted this over in v3arcade support forums as well:

Getting a blank page when you click on Arcade in the navbar. I've tried reverting.

http://respite.clockwatching.org

I'm a vBulletin NOOB, but I'm fairly certain I can read and follow directions.
I grabbed 1.00 when it came out: Blank page
I grabbed 1.01 when it came out, uninstalled 1.00 first: Blank Page
I grabbed 1.02 just now, uninstalled again: Blank Page

I can type in the address to the actual game and it wil lcome up and I can play it, but after I win/lose a game it goes back to a blank screen and says at the bottom of my browser: "...waiting on respite.clockwatching.org/arcade.php"

edit: this happens in IE and FF.

jesus likes pie 11-30-2005 02:50 PM

I'm at school that has macs, when I click on arcade in yor forum (using safari) I get this. Might help you

Quote:

]Safari can?t open the page ?http://respite.clockwatching.org/arcade.php??. The error was: ?bad server response? (NSURLErrorDomain:-1011) Please choose Report Bug to Apple from the Safari menu, note the error number, and describe what you did before you saw this message.

renots 11-30-2005 03:08 PM

Googled that error and it looks like that is a Safari issue:

Quote:

From a quick google search, it appears to be a widespread problem with people thinking anything from PHP version problems to ZOPE (an optimizer) to gzip compression to who knows what being the cause. I've seen a couple pages saying it was a known problem with Safari that woudl be fixed in a future version as well. In general, most threads seem to blame gzip support in Safari for it.

GoTTi 11-30-2005 03:23 PM

john in your descriptions can u change the 1.0.1 to 1.0.2 please.

GoTTi 11-30-2005 03:24 PM

also john u should put in big letters BUGS AND PROBLEMS COME TO V3ARCADE.COM or something pointing to your bugs page so you can deal with these things in a better order...

jesus likes pie 11-30-2005 03:27 PM

I still dont know wha 1.0.2 fixes...


All times are GMT. The time now is 09:34 AM.

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.02468 seconds
  • Memory Usage 1,851KB
  • 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
  • (8)bbcode_code_printable
  • (3)bbcode_php_printable
  • (18)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
  • (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