Sorry....Thread #109

Everything works fine right up until this... I spent over an hour onthe phone with my host trying to sort this out. If I already have access to the database what's the problem here?

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
CREATE TABLE gamechallenges (
challengeid int(10) unsigned NOT NULL auto_increment,
type tinyint(1) unsigned NOT NULL default '0',
challengerid int(10) unsigned NOT NULL default '0',
challengedid int(10) unsigned NOT NULL default '0',
game varchar(30) NOT NULL default '',
status tinyint(1) unsigned NOT NULL default '0',
datestamp int(13) unsigned NOT NULL default '0',
challengersession int(20) unsigned NOT NULL default '0',
challengedsession int(20) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
) TYPE=MyISAM

mysql error: Access denied for user: 'pwna1b_vbbs@localhost' to database
'pwna1b_vbbs'

mysql error number: 1044

Date: Friday 09th of April 2004 12:14:54 PM
Script: http://pwnabbs.org/admincp/install_arcade.php
Referer: http://pwnabbs.org/admincp/install_arcade.php
Username: (removed for sake of post)
IP Address: (removed for sake of post)

Is that the right db name?

Anyone?
I have the same problem....

cLord

seems like a good hack but should i install this one or the latest version?

everythings been working fine but today we received an errror. Running Gold and using latest arcade version. Here is the error

Error

SQL-query :

SELECT COUNT( * ) +1 AS scoresAbove
FROM gamesessions
WHERE score > AND valid =1 AND gamename = ''

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND valid =1 AND gamename = ''' at line 3

I'm having a small problem, whenever I finish a game and it's loading to take me to the comments page, it just returns me to Arcade Home and it says this at the very top:

Warning: No content-type in POST request in Unknown on line 0

Warning: Cannot add header information - headers already sent in Unknown on line 0

Any reason why?

MGM out

Hi,

this sounds like a typical PHP Error where someone did not put the session variables into the right order. They have to be placed directly after <?php. If there is something between the header is already placed and cannot be redefined twice. I am not sure if this applies here but please have a look at the beginning of your PHP file. Just a hint.

Cheers,

Pseudomizer

I'm trying to translate and I almost near the end but I can find this phrase:

Welcome back, admin!
So, you think you're the best!?! Prove it! Earn your trophy!

In fact I'm missing other phrases but I guess that If I find where is this one I can find the other ones missing, thanks to anyone who can help me with this.

What do you mean by "session variables"??

Are you saying I should look through and see if something is written more than once in the beginning somewhere? And which PHP file?

I've been totally stumped by my error.... I mean..... an Unknown file on Line 0 is causing an error..... how do I go about troubleshooting that :P

Juanchi, I think that not everything is phrased and some things are in the templates, try looking in the Arcade Hack's various templates for those words. (And then try phrasing them yourself)

MGM out