hat jemand von euch schon den arcade/activity mod eingebaut?
wenn ja, wär es super wenn mir jemand helfen könnte....
ich hab soweit alle dateien hochgeladen und auch alle files bearbeitet...
danach habe ich die "mod_install.php" ausgeführt die zur erstellung der notwendigen tabellen gedacht ist, nur kann eine tabelle nicht erstellt werden...die :
Code: Alles auswählen
Information
Database type :: mysql
phpBB version :: 2.0.6
Updating database schema & data
Progress :: .................................... Done
Result :: Some queries failed, the statements and errors are listing below
Error :: Table 'phpbb_2ina_data' already exists
SQL :: CREATE TABLE phpbb_2ina_data ( version VARCHAR(255) DEFAULT NULL )
Error :: Multiple primary key defined
SQL :: CREATE TABLE phpbb_2ina_games ( `game_id` mediumint(9) NOT NULL auto_increment, `cat_id` mediumint(8) default NULL, `game_name` varchar(25) 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, PRIMARY KEY (`game_id`), `score_type` smallint(1) default NULL, PRIMARY KEY (`game_id`))
Error :: Table 'phpbb_2ina_scores' already exists
SQL :: CREATE TABLE phpbb_2ina_scores ( `game_name` varchar(255) default NULL, `player_id` mediumint(8) default NULL, `player_ip` varchar(16) default NULL, `score` decimal(12,4) unsigned default NULL, `date` int(11) default NULL )
Error :: Table 'phpbb_2ina_at_scores' already exists
SQL :: CREATE TABLE phpbb_2ina_at_scores ( `game_name` varchar(255) default NULL, `player_id` mediumint(8) default NULL, `player_ip` varchar(16) default NULL, `score` decimal(12,4) unsigned default NULL, `date` int(11) default NULL )
Error :: Table 'phpbb_2ina_sessions' already exists
SQL :: CREATE TABLE phpbb_2ina_sessions ( `arcade_hash` varchar(33) default NULL, `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(25) default NULL, `user_ip` varchar(16) default '0', `ip_name` varchar(255) default NULL)
Error :: Table 'phpbb_2ina_banned' already exists
SQL :: CREATE TABLE phpbb_2ina_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)
Error :: Table 'phpbb_2ina_cat' already exists
SQL :: CREATE TABLE phpbb_2ina_cat ( `cat_id` mediumint(8) NOT NULL auto_increment, `mod_id` mediumint(8) default NULL, `name` varchar(100) default NULL, `desc` text, `icon` varchar(255) default NULL, `special_play` smallint(5) NOT NULL default '0', `last_game` varchar(25) default NULL, `last_player` mediumint(8) default NULL, `last_time` int(11) default NULL, PRIMARY KEY (`cat_id`) )
Error :: Table 'phpbb_2ina_fav' already exists
SQL :: CREATE TABLE phpbb_2ina_fav ( `user_id` mediumint(8) NOT NULL default '0', `game_id` mediumint(9) NOT NULL default '0')
Error :: Table 'phpbb_2ina_tour' already exists
SQL :: CREATE TABLE phpbb_2ina_tour ( `tour_id` mediumint(5) NOT NULL auto_increment, `tour_name` varchar(25) default NULL, `tour_desc` text, PRIMARY KEY (`tour_id`))
Error :: Table 'lostvoices_de.phpbb_2ina_games' doesn't exist
SQL :: INSERT INTO phpbb_2ina_games (`game_id`, `game_name`, `game_path`, `image_path`, `game_desc`, `game_charge`, `game_reward`, `game_bonus`, `game_use_gl`, `game_flash`, `game_show_score`, `win_width`, `win_height`, `highscore_limit`, `reverse_list`, `played`, `instructions`, `game_avail`, `allow_guest`, `cat_id`) VALUES (1, 'donkeykong', 'games/donkeykong/', '', 'The Classic - Donkey Kong', 0, 0, 0, 0, 1, 1, 448, 600, 0, 0, 0, 'CLICK where it says \'Press Space Bar To Start\' to start the game :(', 1, 1, NULL)
Error :: Duplicate entry 'default_reward_dbfield' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('default_reward_dbfield','')
Error :: Duplicate entry 'default_cash' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('default_cash','')
Error :: Duplicate entry 'use_rewards_mod' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('use_rewards_mod','0')
Error :: Duplicate entry 'use_cash_system' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('use_cash_system','0')
Error :: Duplicate entry 'report_cheater' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('report_cheater','0')
Error :: Duplicate entry 'warn_cheater' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('warn_cheater','0')
Error :: Duplicate entry 'use_point_system' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('use_point_system','0')
Error :: Duplicate entry 'use_gamelib' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('use_gamelib','0')
Error :: Duplicate entry 'games_path' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_path','')
Error :: Duplicate entry 'gamelib_path' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('gamelib_path','')
Error :: Duplicate entry 'use_gk_shop' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('use_gk_shop','0')
Error :: Duplicate entry 'use_allowance_system' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('use_allowance_system','0')
Error :: Duplicate entry 'games_per_page' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_per_page','20')
Error :: Duplicate entry 'games_default_img' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_default_img','templates/subSilver/images/games.gif')
Error :: Duplicate entry 'games_default_txt' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_default_txt','More games available to Registered Members - No Fee - No Catch.
')
Error :: Duplicate entry 'games_default_id' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_default_id','0')
Error :: Duplicate entry 'games_offline' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_offline','0')
Error :: Duplicate entry 'games_cheat_mode' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_cheat_mode','1')
Error :: Duplicate entry 'games_guest_highscore' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_guest_highscore', '1')
Error :: Duplicate entry 'games_auto_size' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_auto_size', '1')
Error :: Duplicate entry 'games_at_highscore' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_at_highscore', '1')
Error :: Duplicate entry 'games_show_stats' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_show_stats', '1')
Error :: Duplicate entry 'games_image_width' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_image_width', '50')
Error :: Duplicate entry 'games_image_height' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_image_height', '50')
Error :: Duplicate entry 'games_per_admin_page' for key 1
SQL :: INSERT INTO phpbb_2config VALUES ('games_per_admin_page', '')
