phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

Problem mit Installation Arcade-Mod 2.1.8

https://www.phpbb.de/community/viewtopic.php?t=187984

Seite 1 von 1

Problem mit Installation Arcade-Mod 2.1.8

Verfasst: 16.03.2009 14:03
von LeadH
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

Re: Problem mit Installation Arcade-Mod 2.1.8

Verfasst: 17.03.2009 22:00
von Andi1111
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`) 
) ;
Alle Zeiten sind UTC+02:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de