vb.org Archive
Page 11 of 312 « First 910 11 12132161111 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)

FleaBag 11-27-2005 12:31 PM
Ho John, in the ACP when clicking to remove all 0 scores I get the following error...
Quote:
Database error in vBulletin 3.5.1:

Invalid SQL:
UPDATE arcade_games AS arcade_games SET sessioncount=4704, highscorerid=651, highscore=3295.000 WHERE gameid=1;

MySQL Error : You have an error in your SQL syntax near 'AS arcade_games SET sessioncount=4704, highscorerid=651, highscore=3295.000 WHER' at line 1
Error Number : 1064
Date : Sunday, November 27th 2005 @ 07:14:02 AM
Script : http://www.dragonninja.co.uk/admincp/arcadeadmin.php
Referrer : http://www.dragonninja.co.uk/admincp....php?do=scores
IP Address : 62.252.32.11
Username : FleaBag
Classname : vb_database
And also, when downloading a game from v3arcade.com I get the following errors.

Quote:
Warning: fopen(/www/dragonninja/games/simon.swf): failed to open stream: Permission denied in /admin/arcadeadmin.php on line 225

Warning: fopen(/www/dragonninja/images/arcade/simon1.gif): failed to open stream: Permission denied in /admin/arcadeadmin.php on line 225

Warning: fopen(/www/dragonninja/images/arcade/simon2.gif): failed to open stream: Permission denied in /admin/arcadeadmin.php on line 225

Installing Simon
Obviously the game or the images are not installed and I now have a dud entry. Any idea why?

Any help is appreciated... Thanks. :)

Supes 11-27-2005 12:32 PM
Quote:
Originally Posted by John
Set your usergroup permissions?
I forgot abut that, it works now! :D

nexialys 11-27-2005 12:33 PM
Quote:
Originally Posted by FleaBag
Ho John, in the ACP when clicking to remove all 0 scores I get the following error...
Any help is appreciated... Thanks. :)
missing quotes in the SQL query!

divided_by_fear 11-27-2005 12:34 PM
when i click remove all high score it dont even remove them dont feel bad

waza 11-27-2005 12:34 PM
John, I can't verify my license on v3arcade.com.
I'm sure the url works and guest can see the arcade.

yoyoyoyo 11-27-2005 12:36 PM
Quote:
Originally Posted by nexialys
this is stupid logic...

just after
PHP Code:
include_once "./global.php"; 
add this:
PHP Code:
    if (!$vbulletin->userinfo['userid'])
    {
        print_no_permission();
    } 
this will prevent ALL non-logged-in users to be locked out

when you have a need, just request it instead of telling it's a non-avenue!

and btw, if your users have no access to the board, they will not have more access to the arcade, as it is driven by vBulletin authentication...
I don't see how this will help... in order to verify the license the site checks to see if the arcade.php is viewable by guests - if it is not it will not verify your license. My USERS have access to the board - just not GUESTS.

tcs 11-27-2005 12:36 PM
Do you still have to open up your server or site with allow_url_fopen to get games?

Abbas 11-27-2005 12:36 PM
I tried installing and although the Product Added fine, when I try to access the arcade.php page, I get a "You dont have sufficient privelages" message from vBulletin and an email with the following error comes to my inbox:

MySQL Error : Unknown column 'language.phrasegroup_arcade' in 'field list'

Help would be appreciated!

Thanks
Abbas

FleaBag 11-27-2005 12:37 PM
Quote:
Originally Posted by nexialys
missing quotes in the SQL query!
Ah, I suspected as much. So that's at least 1 bug hehe. :D Any idea what I replace nex?

RWDF1 11-27-2005 12:38 PM
Quote:
Originally Posted by John
You already had an arcade_challenges table to begin with? :ermm:

The current version number you've got installed is 1.0.0, right? If so, run this:

DROP TABLE IF EXISTS arcade_challenges

And then 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)
)

Ok this may sound stupid, but where do I run this? in my mySQL database, in the vB Cpannel?


All times are GMT. The time now is 08:16 AM.
Page 11 of 312 « First 910 11 12132161111 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.07976 seconds
  • Memory Usage 1,758KB
  • 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
  • (2)bbcode_php_printable
  • (7)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