[ABD] Arcade Room 0.6.9c

[AngelMike]

At profile, the trophies don't show up.
At the arcade room itzelf it said one trophie gold for me.
But at my profile it said gold trophie: 0.
How come?

and
how to enable high scores :S
Cus it still say its disabled :S
while adding the game i enabled it.

[fahad4x4]

hi
I have no message Forum says

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'xxxxx_xxx.phpbb_ar_hotlinks' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

Manually tried cultivation of this code

Code: Select all

CREATE TABLE phpbb_ar_hotlinks (
  hotlink_id mediumint(8) unsigned NOT NULL auto_increment,
  hotlink_game mediumint(8) unsigned NOT NULL,
  hotlink_file varchar(255) collate utf8_bin NOT NULL,
  PRIMARY KEY  (hotlink_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

But confronted this letter

Code: Select all

Error

SQL query:

CREATE TABLE phpbb_ar_hotlinks(
hotlink_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
hotlink_game mediumint( 8 ) unsigned NOT NULL ,
hotlink_file varchar( 255 ) COLLATE utf8_bin NOT NULL ,
PRIMARY KEY ( hotlink_id )
) DEFAULT CHARSET = utf8 COLLATE = utf8_bin

MySQL said: Documentation
#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 'collate utf8_bin NOT NULL,
  PRIMARY KEY  (hotlink_id)
) DEFA 

Help me please Forum closed now

Version forum RC7
Version ar 0.6.9

[t27duck]

Try the SQL...

Code: Select all

CREATE TABLE phpbb_ar_hotlinks (
  hotlink_id mediumint(8) unsigned NOT NULL auto_increment,
  hotlink_game mediumint(8) unsigned NOT NULL,
  hotlink_file varchar(255) collate utf8_bin NOT NULL
  PRIMARY KEY  (hotlink_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

I don't think the last "," was needed.

[fahad4x4]

Try the SQL...

Code: Select all

CREATE TABLE phpbb_ar_hotlinks (
  hotlink_id mediumint(8) unsigned NOT NULL auto_increment,
  hotlink_game mediumint(8) unsigned NOT NULL,
  hotlink_file varchar(255) collate utf8_bin NOT NULL
  PRIMARY KEY  (hotlink_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

I don't think the last "," was needed.

Thank you brother to help but did not succeed try and show this message

Code: Select all

Error

SQL query:

CREATE TABLE phpbb_ar_hotlinks(
hotlink_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
hotlink_game mediumint( 8 ) unsigned NOT NULL ,
hotlink_file varchar( 255 ) COLLATE utf8_bin NOT NULL PRIMARY KEY ( hotlink_id )
) DEFAULT CHARSET = utf8 COLLATE = utf8_bin

MySQL said: Documentation
#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 'collate utf8_bin NOT NULL
      PRIMARY KEY  (hotlink_id)
   

[fahad4x4]

Also attempted to implement install.php But once again show this message

Arcade Room 0.6.9

mySQL EDITS:
phpbb_ar_categories had an error being added to the database.
phpbb_ar_games had an error being added to the database.
phpbb_ar_ratings already exists in the database.
phpbb_ar_settings had an error being added to the database.
phpbb_ar_comments had an error being added to the database.
phpbb_ar_favorites already exists in the database.
phpbb_ar_hotlinks had an error being added to the database.
phpbb_ar_highscores already exists in the database.
phpbb_ar_viewing already exists in the database.
phpbb_ar_played already exists in the database.

[patrikstar]

Are we no longer using the file includes\ucp\ ucp. whatever, I still have the arcade tab in the UCP and it just errors out because I have no includes/ucp file for Arcade. Was wondering cause the ucp stuff is not in the download for 0.6.9

the ucp just showed favorited games and now there is a cateogory for that so there is no need for the whole ucp thing

Get tokens -Disabled
Ticket store -Disabled
Highscores -Disabled
Recent Wins -Disabled

Can these be enabled?

Thanx

Sorry, for my bad english

no they are just place holders for another version

Fix it

hm.. why u dont tell it because i cant´t find the fix

thx

the installer had a problem with part of the file and i dont the exact line but here was the issue

variable++;

when the auto installer edited the files it changed the ++ to a ' ' which is a *space**space*

so it would be this in the file

variable ;



Also as stated above the parts that say - disabled on says
Highscore - Disabled
Well sorry for the mis understanding but that is just saying that link is disabled not the actual highscores


I am going to pay for my website also -> I however do not have time to edit the posts or the files for the demo board on that website so it will be up for game downloads and discussion only but the main download post and test forum will remain at http://www.gleasonator.com/patrikstar/phpBB3/

Its payed but I don't know when it will be processed and come back online

[Tripp]

I updated from 67 to 69 and worked fine minus two problems:

One, the trophies variable isn't defined or something. It shows as {trophies]

And it makes my overall footer expand all the way across. I had this problem with 67 but just removed the edits for membership_view.html.

Both problems are show in the screen shot below:

http://i11.tinypic.com/6l9rolu.jpg

[Rafterman1]

Ok, another error. I think i installed all files as well as they should... but i get severall errors
one of these is when i open the arcade.php:

Code: Select all

[phpBB Debug] PHP Notice: in file /arcade.php on line 245: Undefined variable: highscores
[phpBB Debug] PHP Notice: in file /arcade.php on line 286: Undefined variable: result3
[phpBB Debug] PHP Notice: in file /arcade.php on line 372: Undefined variable: sql_addition

Can you help me?

[oglach]

Hey,

when installin in sql I have too install it in andrew -> ppbb31 database,ive to change the tables name sto uppercase and remove PHPBB so itts just AR_FAVOURITES_TABLE etc

Can any1 help out on this?

[AngelMike]

Hey,

when installin in sql I have too install it in andrew -> ppbb31 database,ive to change the tables name sto uppercase and remove PHPBB so itts just AR_FAVOURITES_TABLE etc

Can any1 help out on this?

You have to go to myphp to change it.
had to do it myzelf also

[oglach]

can u just change the mysql code before you run it?

[Rafterman1]

mmmmh, on serveral pages i get php notice that there are undefinend variables

this is here is from the viewtopic.php

Code: Select all

[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1385: Undefined variable: highscores
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1385: Undefined index: Funkoid
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1426: Undefined variable: result4
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1426: Undefined variable: result4
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1385: Undefined index: Defend your Stronghold
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1385: Undefined index: Funkoid
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1426: Undefined variable: result4
[phpBB Debug] PHP Notice: in file /viewtopic.php on line 1426: Undefined variable: result4
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3368: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2899)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3370: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2899)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3371: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2899)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3372: Cannot modify header information - headers already sent by (output started at /includes/functions.php:2899)

what can it be? iam really sure that if installed the mod correct?!

[AngelMike]

can u just change the mysql code before you run it?

Yeah you can change the name to what it said.
I dint had it at all had to make it myzelf.

[oglach]

Where it says create I changed to fit as required, however im not sure what to change the end part into, the 'insert' part at the bottom

phpbb_ar_categories is now AR_CATEGORIES_TABLE

and on down the list, for some reason thast what it looks for when i clcik aracde, php
So they are all listed like that AR_COMMENTS_TABLE etc, just not sure what to change insert too?

Code: Select all

CREATE TABLE phpbb_ar_categories (
  category_id mediumint(8) unsigned NOT NULL auto_increment,
  category_name varchar(255) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (category_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_comments (
  comment_id mediumint(8) unsigned NOT NULL auto_increment,
  comment_user mediumint(8) unsigned NOT NULL default '0',
  comment_game mediumint(8) unsigned NOT NULL default '0',
  `comment` varchar(255) collate utf8_bin NOT NULL default '',
  bbcode_uid varchar(5) collate utf8_bin NOT NULL default '',
  bbcode_bitfield varchar(255) collate utf8_bin NOT NULL default '',
  enable_bbcode tinyint(1) unsigned NOT NULL default '1',
  enable_smilies tinyint(1) unsigned NOT NULL default '1',
  enable_urls tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (comment_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_favorites (
  favorite_id mediumint(8) unsigned NOT NULL auto_increment,
  favorite_game mediumint(8) unsigned NOT NULL,
  favorite_user mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (favorite_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_games (
  game_id mediumint(8) unsigned NOT NULL auto_increment,
  game_name varchar(100) collate utf8_bin NOT NULL default '',
  game_image varchar(255) collate utf8_bin NOT NULL default 'no_image.gif',
  game_directions varchar(255) collate utf8_bin NOT NULL default '',
  game_description varchar(255) collate utf8_bin NOT NULL default '',
  game_category mediumint(8) unsigned NOT NULL default '0',
  game_filename varchar(255) collate utf8_bin NOT NULL default '',
  game_plays mediumint(8) unsigned NOT NULL default '0',
  game_rating mediumint(8) NOT NULL default '0',
  game_num_ratings mediumint(8) NOT NULL default '0',
  game_width mediumint(8) unsigned NOT NULL default '0',
  game_height mediumint(8) unsigned NOT NULL default '0',
  game_highscore tinyint(1) unsigned NOT NULL default '0',
  game_newscore tinyint(1) unsigned NOT NULL default '0',
  game_rev_score tinyint(1) unsigned NOT NULL default '0',
  game_enabled tinyint(1) unsigned NOT NULL,
  PRIMARY KEY  (game_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_highscores (
  highscore_id mediumint(8) unsigned NOT NULL auto_increment,
  highscore_game mediumint(8) unsigned NOT NULL,
  highscore_user mediumint(8) unsigned NOT NULL,
  highscore double(21,1) unsigned NOT NULL,
  PRIMARY KEY  (highscore_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_hotlinks (
  hotlink_id mediumint(8) unsigned NOT NULL auto_increment,
  hotlink_game mediumint(8) unsigned NOT NULL,
  hotlink_file varchar(255) collate utf8_bin NOT NULL,
  PRIMARY KEY  (hotlink_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_played (
  played_id mediumint(8) unsigned NOT NULL auto_increment,
  played_user mediumint(8) unsigned NOT NULL,
  played_games mediumtext character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (played_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_ratings (
  rating_id mediumint(8) NOT NULL auto_increment,
  rating_game mediumint(8) NOT NULL default '0',
  rating_user mediumint(8) NOT NULL default '0',
  rating_score mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (rating_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_settings (
  setting_id mediumint(8) NOT NULL auto_increment,
  setting_name varchar(255) collate utf8_bin NOT NULL default '',
  setting_value varchar(255) collate utf8_bin NOT NULL default '0',
  PRIMARY KEY  (setting_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(1, 'Allow guest view', '1');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(2, 'Guest increases game plays', '0');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(3, 'Allow games to be commented on', '1');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(4, 'Enable hotlink protection', '1');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(5, 'Enable game favorites', '1');

CREATE TABLE phpbb_ar_viewing (
  viewing_id mediumint(8) unsigned NOT NULL auto_increment,
  viewing_user mediumint(8) unsigned NOT NULL,
  viewing_game mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (viewing_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[AngelMike]

Where it says create I changed to fit as required, however im not sure what to change the end part into, the 'insert' part at the bottom

phpbb_ar_categories is now AR_CATEGORIES_TABLE

and on down the list, for some reason thast what it looks for when i clcik aracde, php
So they are all listed like that AR_COMMENTS_TABLE etc, just not sure what to change insert too?

Code: Select all

CREATE TABLE phpbb_ar_categories (
  category_id mediumint(8) unsigned NOT NULL auto_increment,
  category_name varchar(255) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (category_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_comments (
  comment_id mediumint(8) unsigned NOT NULL auto_increment,
  comment_user mediumint(8) unsigned NOT NULL default '0',
  comment_game mediumint(8) unsigned NOT NULL default '0',
  `comment` varchar(255) collate utf8_bin NOT NULL default '',
  bbcode_uid varchar(5) collate utf8_bin NOT NULL default '',
  bbcode_bitfield varchar(255) collate utf8_bin NOT NULL default '',
  enable_bbcode tinyint(1) unsigned NOT NULL default '1',
  enable_smilies tinyint(1) unsigned NOT NULL default '1',
  enable_urls tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (comment_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_favorites (
  favorite_id mediumint(8) unsigned NOT NULL auto_increment,
  favorite_game mediumint(8) unsigned NOT NULL,
  favorite_user mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (favorite_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_games (
  game_id mediumint(8) unsigned NOT NULL auto_increment,
  game_name varchar(100) collate utf8_bin NOT NULL default '',
  game_image varchar(255) collate utf8_bin NOT NULL default 'no_image.gif',
  game_directions varchar(255) collate utf8_bin NOT NULL default '',
  game_description varchar(255) collate utf8_bin NOT NULL default '',
  game_category mediumint(8) unsigned NOT NULL default '0',
  game_filename varchar(255) collate utf8_bin NOT NULL default '',
  game_plays mediumint(8) unsigned NOT NULL default '0',
  game_rating mediumint(8) NOT NULL default '0',
  game_num_ratings mediumint(8) NOT NULL default '0',
  game_width mediumint(8) unsigned NOT NULL default '0',
  game_height mediumint(8) unsigned NOT NULL default '0',
  game_highscore tinyint(1) unsigned NOT NULL default '0',
  game_newscore tinyint(1) unsigned NOT NULL default '0',
  game_rev_score tinyint(1) unsigned NOT NULL default '0',
  game_enabled tinyint(1) unsigned NOT NULL,
  PRIMARY KEY  (game_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_highscores (
  highscore_id mediumint(8) unsigned NOT NULL auto_increment,
  highscore_game mediumint(8) unsigned NOT NULL,
  highscore_user mediumint(8) unsigned NOT NULL,
  highscore double(21,1) unsigned NOT NULL,
  PRIMARY KEY  (highscore_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_hotlinks (
  hotlink_id mediumint(8) unsigned NOT NULL auto_increment,
  hotlink_game mediumint(8) unsigned NOT NULL,
  hotlink_file varchar(255) collate utf8_bin NOT NULL,
  PRIMARY KEY  (hotlink_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_played (
  played_id mediumint(8) unsigned NOT NULL auto_increment,
  played_user mediumint(8) unsigned NOT NULL,
  played_games mediumtext character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (played_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_ratings (
  rating_id mediumint(8) NOT NULL auto_increment,
  rating_game mediumint(8) NOT NULL default '0',
  rating_user mediumint(8) NOT NULL default '0',
  rating_score mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (rating_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_ar_settings (
  setting_id mediumint(8) NOT NULL auto_increment,
  setting_name varchar(255) collate utf8_bin NOT NULL default '',
  setting_value varchar(255) collate utf8_bin NOT NULL default '0',
  PRIMARY KEY  (setting_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(1, 'Allow guest view', '1');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(2, 'Guest increases game plays', '0');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(3, 'Allow games to be commented on', '1');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(4, 'Enable hotlink protection', '1');
INSERT INTO phpbb_ar_settings (setting_id, setting_name, setting_value) VALUES(5, 'Enable game favorites', '1');

CREATE TABLE phpbb_ar_viewing (
  viewing_id mediumint(8) unsigned NOT NULL auto_increment,
  viewing_user mediumint(8) unsigned NOT NULL,
  viewing_game mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (viewing_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

As dar as i can see, its the same way as ''inserting;; fields for the AR_CATEGORIES_TABLE
If your not sure and your in, phpmyadmin.
Just go to your forum database, click on sql tab, paste it in to there, and hit the button.
If it works it wil put in automaticly at the right place.