Problem mit Installation Arcade-Mod 2.1.8

LeadH · Beitrag von **LeadH** » 16.03.2009 14:03

Hallo,

ich habe gerade in mein phpbb 2.0.23 den Arcade/Activities MOD 2.1.8 eingebaut, soweit problemlos.
Um die DB upzudaten muß man ja dann noch das script /admin/admin_arcade_update.php?sid= mit angehängter aktueller SessionID ausführen, und da gibt es leider Probleme, es bricht mit einer Fehlermeldung

Code: Alles auswählen

S NOT REQUIRED?!
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 'S' at line 1

ab.

Wenn ich mir im Bereich nach

Code: Alles auswählen

//  Now lets get Building..!

(wo die Fehlermeldung ausgegeben wird) noch ein $sql ausgeben lasse erhalte ich

Code: Alles auswählen

SELECT * FROM phpbb_config

Am SQL-Statement wird der Fehler also eher weniger liegen

Beim Durchschauen des admin_arcade_update.php ist mir dann aufgefallen, dass es an mehreren Stellen versucht Kontakt mit http://www.phpbb-arcade.com aufzunehmen, z.B:

Code: Alles auswählen

    $host = 'www.phpbb-arcade.com';
    if ($fsock = @fsockopen($host, 80, $errno, $errstr, 5))

oder

Code: Alles auswählen

	default:
		require 'http://www.phpbb-arcade.com/arcade_update.php';
		exit;
		break;

Da diese Domain ja leider inzwischen offline ist vermute ich, dass der Fehler daraus resultiert.

Hat da vielleicht jemand eine Idee, wie man das trotzdem zum Laufen bekommen kann?

Viele Grüße
Lead

Andi1111 · Beitrag von **Andi1111** » 17.03.2009 22:00

hallo, also erstmal würde ich versuchen die dateien neu hochzuladen, wenn ich mich richtig erinnere kommt der feher durch eine leerzeile zu viel in einer zeile. wenns an der db update datei liegt kannst du auch die tabellen selber anlegen. ich habe jedenfalls den mod gerade erst in ein testforum neu eingebaut und hatte keine probleme.

Code: Alles auswählen

-- 
-- Table structure for table `phpbb_ina_at_scores` 
-- 

CREATE TABLE `phpbb_ina_at_scores` ( 
  `game_name` varchar(50) NOT NULL default '', 
  `player_id` mediumint(8) NOT NULL default '0', 
  `player_name` varchar(25) NOT NULL default '', 
  `player_ip` varchar(16) default NULL, 
  `score` double(12,4) NOT NULL default '0.0000', 
  `date` int(11) default NULL, 
  `time_taken` int(11) default NULL, 
  PRIMARY KEY  (`game_name`,`player_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_banned` 
-- 

CREATE TABLE `phpbb_ina_banned` ( 
  `username` varchar(25) default NULL, 
  `user_id` mediumint(8) default NULL, 
  `player_ip` varchar(16) default NULL, 
  `game` varchar(25) default NULL, 
  `score` mediumint(8) default NULL, 
  `date` varchar(16) default NULL, 
  KEY `user_id` (`user_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_cat` 
-- 

CREATE TABLE `phpbb_ina_cat` ( 
  `cat_id` mediumint(8) NOT NULL auto_increment, 
  `mod_id` mediumint(8) default NULL, 
  `cat_name` varchar(100) default NULL, 
  `cat_desc` text, 
  `cat_icon` varchar(255) default NULL, 
  `special_play` smallint(5) NOT NULL default '0', 
  `last_game` varchar(50) default NULL, 
  `last_player` mediumint(8) default NULL, 
  `last_time` int(11) default NULL, 
  `group_required` mediumint(8) NOT NULL default '0', 
  `cat_type` char(1) NOT NULL default 'p', 
  `cat_parent` mediumint(8) default NULL, 
    `cat_order` mediumint(8) unsigned NOT NULL default '1', 
  `total_games` int(8) unsigned NOT NULL default '0', 
  `total_played` bigint(12) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`cat_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_comment` 
-- 

CREATE TABLE `phpbb_ina_comment` ( 
  `comment_id` int(11) unsigned NOT NULL auto_increment, 
  `comment_game_name` varchar(50) default NULL, 
  `comment_user_id` mediumint(8) NOT NULL default '0', 
  `comment_username` varchar(32) default NULL, 
  `comment_user_ip` varchar(8) NOT NULL default '', 
  `comment_time` int(11) unsigned NOT NULL default '0', 
  `comment_text` text, 
  `comment_edit_time` int(11) unsigned default NULL, 
  `comment_edit_count` smallint(5) unsigned NOT NULL default '0', 
  `comment_edit_user_id` mediumint(8) default NULL, 
  PRIMARY KEY  (`comment_id`), 
  KEY `comment_game_name` (`comment_game_name`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_data` 
-- 

CREATE TABLE `phpbb_ina_data` ( 
  `config_name` varchar(255) default NULL, 
  `config_value` varchar(255) default NULL, 
  UNIQUE KEY `config_name` (`config_name`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_fav` 
-- 

CREATE TABLE `phpbb_ina_fav` ( 
  `user_id` mediumint(8) NOT NULL default '0', 
  `fav_game_name` varchar(50) NOT NULL default '', 
  PRIMARY KEY  (`fav_game_name`,`user_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_games` 
-- 

CREATE TABLE `phpbb_ina_games` ( 
  `game_id` mediumint(9) NOT NULL auto_increment, 
  `cat_id` mediumint(8) default '-1', 
    `game_order` mediumint(8) unsigned NOT NULL default '1', 
  `game_name` varchar(50) default NULL, 
  `game_path` varchar(255) default NULL, 
  `image_path` varchar(255) default NULL, 
  `game_desc` varchar(255) default NULL, 
  `game_charge` int(11) unsigned default '0', 
  `game_reward` int(11) unsigned NOT NULL default '0', 
  `game_bonus` smallint(5) unsigned default '0', 
  `at_game_bonus` smallint(5) default '0', 
  `game_use_gl` tinyint(3) unsigned default '0', 
  `game_flash` tinyint(1) unsigned NOT NULL default '0', 
  `game_show_score` tinyint(1) NOT NULL default '1', 
  `game_avail` tinyint(1) unsigned default '1', 
  `allow_guest` tinyint(1) unsigned default '0', 
  `win_width` smallint(6) NOT NULL default '0', 
  `win_height` smallint(6) NOT NULL default '0', 
  `highscore_limit` int(11) default NULL, 
  `at_highscore_limit` int(10) default '0', 
  `reverse_list` tinyint(1) NOT NULL default '0', 
  `played` int(10) unsigned NOT NULL default '0', 
  `instructions` text, 
  `score_type` smallint(1) default NULL, 
  `game_autosize` smallint(1) default NULL, 
  `date_added` int(11) default '0', 
  `rank_required` int(11) NOT NULL default '0', 
  `level_required` tinyint(4) NOT NULL default '0', 
  `group_required` mediumint(8) NOT NULL default '0', 
  `game_control` int(1) default '0', 
  `highscore_id` mediumint(8) NOT NULL default '0', 
  `at_highscore_id` mediumint(8) NOT NULL default '0', 
  PRIMARY KEY  (`game_id`), 
  KEY `game_name` (`game_name`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_highscore` 
-- 

CREATE TABLE `phpbb_ina_highscore` ( 
  `highscore_id` mediumint(8) unsigned NOT NULL auto_increment, 
  `highscore_year` year(4) NOT NULL default '0000', 
  `highscore_mon` tinyint(2) unsigned NOT NULL default '0', 
  `highscore_game` varchar(50) NOT NULL default '', 
  `highscore_player` varchar(40) NOT NULL default '', 
  `highscore_score` int(10) NOT NULL default '0', 
  `highscore_date` int(11) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`highscore_id`), 
  KEY `highscore_game` (`highscore_game`) 
) ; 

-- -------------------------------------------------------- 

CREATE TABLE `phpbb_ina_log` ( 
  `record_no` mediumint(8) unsigned NOT NULL auto_increment, 
  `user_id` mediumint(8) NOT NULL default '-1', 
  `name` text, 
  `value` text, 
  PRIMARY KEY  (`record_no`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_pms` 
-- 

CREATE TABLE `phpbb_ina_pms` ( 
  `to_id` mediumint(8) NOT NULL default '0', 
  `from_id` mediumint(8) NOT NULL default '0', 
  `last_sent` int(11) NOT NULL default '0', 
  `total_sent` mediumint(8) default NULL, 
  `code` tinyint(4) default NULL, 
  KEY `to_id` (`to_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_rate` 
-- 

CREATE TABLE `phpbb_ina_rate` ( 
  `rate_game_name` varchar(50) NOT NULL default '', 
  `rate_user_id` mediumint(8) NOT NULL default '0', 
  `rate_user_ip` varchar(8) NOT NULL default '', 
  `rate_point` tinyint(3) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`rate_game_name`,`rate_user_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_scores` 
-- 

CREATE TABLE `phpbb_ina_scores` ( 
  `game_name` varchar(50) NOT NULL default '', 
  `gameData` text, 
  `player_id` mediumint(8) NOT NULL default '0', 
  `player_ip` varchar(16) default NULL, 
  `score` double(14,4) NOT NULL default '0.0000', 
  `date` int(11) default NULL, 
  `time_taken` int(11) default NULL, 
  PRIMARY KEY  (`game_name`,`player_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_sessions` 
-- 

CREATE TABLE `phpbb_ina_sessions` ( 
  `arcade_hash` varchar(33) NOT NULL default '', 
  `user_id` mediumint(8) NOT NULL default '0', 
  `start_time` int(11) NOT NULL default '0', 
  `session_ip` varchar(8) NOT NULL default '', 
  `page` int(1) NOT NULL default '0', 
  `game_name` varchar(50) default NULL, 
  `tour_id` mediumint(5) default NULL, 
  `user_ip` varchar(16) default '0', 
  `ip_name` varchar(255) default NULL, 
  `user_win` varchar(25) NOT NULL default 'NORM', 
  `randchar1` int(4) default NULL, 
  `randchar2` int(4) default NULL, 
  PRIMARY KEY  (`arcade_hash`), 
  KEY `user_id` (`user_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_tour` 
-- 

CREATE TABLE `phpbb_ina_tour` ( 
  `tour_id` mediumint(5) NOT NULL auto_increment, 
  `tour_name` varchar(25) default NULL, 
  `tour_desc` text, 
  `tour_max_players` int(4) NOT NULL default '0', 
  `tour_player_turns` int(4) NOT NULL default '0', 
  `block_plays` int(1) default NULL, 
  `tour_active` int(1) NOT NULL default '0', 
  `start_id` mediumint(8) NOT NULL default '0', 
  `start_date` int(11) NOT NULL default '0', 
  `end_date` int(11) default NULL, 
  `length` int(11) default NULL, 
  `end_type` int(1) default NULL, 
  `champion` mediumint(8) default NULL, 
  PRIMARY KEY  (`tour_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_tour_data` 
-- 

CREATE TABLE `phpbb_ina_tour_data` ( 
  `tour_id` mediumint(5) NOT NULL default '0', 
  `game_name` varchar(50) NOT NULL default '', 
  `top_score` double(12,4) default NULL, 
  `top_player` mediumint(11) default NULL, 
  PRIMARY KEY  (`tour_id`,`game_name`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_tour_play` 
-- 

CREATE TABLE `phpbb_ina_tour_play` ( 
  `tour_id` mediumint(5) NOT NULL default '0', 
  `user_id` mediumint(8) NOT NULL default '0', 
  `last_played_time` int(11) NOT NULL default '0', 
  `last_played_game` varchar(50) default NULL, 
  `gamedata` text, 
  PRIMARY KEY  (`tour_id`,`user_id`) 
) ; 

-- -------------------------------------------------------- 

-- 
-- Table structure for table `phpbb_ina_user_data` 
-- 

CREATE TABLE `phpbb_ina_user_data` ( 
  `user_id` mediumint(8) NOT NULL default '0', 
  `last_played` varchar(50) default NULL, 
  `last_played_date` int(11) default NULL, 
  `first_places` mediumint(9) default '0', 
  `first_list` text, 
  `second_places` mediumint(8) default '0', 
  `second_list` text, 
  `third_places` mediumint(9) default NULL, 
  `third_list` text, 
  `last_won_date` int(11) default NULL, 
  `at_first_places` mediumint(9) default '0', 
  `at_first_list` text, 
  `at_second_places` mediumint(9) default NULL, 
  `at_second_list` text, 
  `at_third_places` mediumint(9) default NULL, 
  `at_third_list` text, 
  `user_game_time` int(11) default '0', 
  PRIMARY KEY  (`user_id`) 
) ;

phpBB.de

Problem mit Installation Arcade-Mod 2.1.8

Problem mit Installation Arcade-Mod 2.1.8

Re: Problem mit Installation Arcade-Mod 2.1.8