hi manne
während du dein bier schlürfst
hier die erste:
Code: Alles auswählen
CREATE TABLE `phpbb_introportalmod` (
`config_name` varchar(255) NOT NULL default '',
`config_value` text NOT NULL,
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
#
# Daten für Tabelle `phpbb_introportalmod`
#
INSERT INTO `phpbb_introportalmod` VALUES ('config_id', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('modversion', '1.50');
INSERT INTO `phpbb_introportalmod` VALUES ('introportalmod_disable', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('intro_disable', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('intro_disable_msg', 'Intro derzeit deaktiviert');
INSERT INTO `phpbb_introportalmod` VALUES ('introlasttopics_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('introlasttopics_limit', '10');
INSERT INTO `phpbb_introportalmod` VALUES ('lasttopics_length_intro', '25');
INSERT INTO `phpbb_introportalmod` VALUES ('portal_disable', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('portal_disable_msg', 'Portal derzeit deaktiviert');
INSERT INTO `phpbb_introportalmod` VALUES ('navigation_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('navigationquote_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('lastnewmembers_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('lastnewmembers_limit', '8');
INSERT INTO `phpbb_introportalmod` VALUES ('topposter_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('topposter_limit', '8');
INSERT INTO `phpbb_introportalmod` VALUES ('topposts_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('topposts_limit', '8');
INSERT INTO `phpbb_introportalmod` VALUES ('searchtopics_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('pollbox_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('pollbox_forums', '1,2,3,4,5,6,7,8,9,10,11');
INSERT INTO `phpbb_introportalmod` VALUES ('forumview_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('lasttopics_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('lasttopics_limit', '8');
INSERT INTO `phpbb_introportalmod` VALUES ('lasttopics_length_portal', '25');
INSERT INTO `phpbb_introportalmod` VALUES ('freenet_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('heise_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('whoisonline_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('webmaster_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('partners_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('Partnersitelinks', 'http://www.westieclan.de\r\nhttp://www.westiepalace.com\r\nhttp://www.zwingervonderlerche.de\r\nhttp://www.rehm-neuss.de\r\n ');
INSERT INTO `phpbb_introportalmod` VALUES ('google_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('calendar_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('calendar_nbc', 'EEEEEE');
INSERT INTO `phpbb_introportalmod` VALUES ('calendar_mbc', 'ABC390');
INSERT INTO `phpbb_introportalmod` VALUES ('calendar_tfc', 'F5B723');
INSERT INTO `phpbb_introportalmod` VALUES ('left_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('center_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('right_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('border_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('fpost_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('fpost_numofnews', '3');
INSERT INTO `phpbb_introportalmod` VALUES ('fpost_forums', '1,2,3,4,5');
INSERT INTO `phpbb_introportalmod` VALUES ('fpost_newslength', '250');
INSERT INTO `phpbb_introportalmod` VALUES ('loginform_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('welcomeuser_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('forumlegend_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('userpostcount_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('birthdaymod_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('lastvisitmod_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('chatboxmod_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('globalannouncemod_active', '0');
INSERT INTO `phpbb_introportalmod` VALUES ('portalamazonbox_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('portalamazonbox_limit', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('portalamazonbox_partnerid', 'partner-id');
INSERT INTO `phpbb_introportalmod` VALUES ('downloadbox_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('downloadnew_active', '1');
INSERT INTO `phpbb_introportalmod` VALUES ('newsbox_active', '1');
und die zweite:
Code: Alles auswählen
#
# Tabellenstruktur für Tabelle `phpbb_introportalmodnav`
#
DROP TABLE IF EXISTS `phpbb_introportalmodnav`;
CREATE TABLE `phpbb_introportalmodnav` (
`link_active` tinyint(1) NOT NULL default '1',
`link_id` mediumint(5) NOT NULL default '0',
`link_cat` mediumint(5) NOT NULL default '0',
`link_sub` mediumint(5) NOT NULL default '0',
`link_name` varchar(60) NOT NULL default '',
`link_url` varchar(100) NOT NULL default '',
`link_level` tinyint(1) NOT NULL default '0',
`link_level_type` tinyint(1) NOT NULL default '0',
KEY `link_id` (`link_id`),
KEY `link_cat` (`link_cat`),
KEY `link_sub` (`link_sub`)
) TYPE=MyISAM;
#
# Daten für Tabelle `phpbb_introportalmodnav`
#
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 0, 0, 0, 'Navigation', '', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 0, 0, 1, 'Forum', '', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 1, 0, 1, '$lang[\'IntroPortalMOD1\']', 'intro.php', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 2, 0, 1, '$lang[\'IntroPortalMOD2\']', 'portal.php', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 3, 0, 1, '$lang[\'IntroPortalMOD3\']', 'index.php', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 0, 0, 2, '$lang[\'Registered_users\']', '', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 4, 0, 3, '$lang[\'Register\']', 'profile.php?mode=register', -1, 0);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 5, 0, 2, '$lang[\'Profile\']', 'profile.php?mode=editprofile', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 6, 0, 2, '$lang[\'Search\']', 'search.php', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 7, 0, 2, '$lang[\'Memberlist\']', 'memberlist.php', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 8, 0, 2, '$lang[\'FAQ\']', 'faq.php', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 9, 0, 2, '$lang[\'Usergroups\']', 'groupcp.php', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 10, 0, 2, '$lang[\'Private_Messages\']', 'privmsg.php', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 11, 0, 2, '$lang[\'Who_is_Online\']', 'viewonline.php', 0, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 0, 0, 4, '$lang[\'IntroPortalMOD6\']', '', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 12, 0, 4, '$lang[\'IntroPortalMOD4\']', 'http://www.phpbb.de', -1, 2);
INSERT INTO `phpbb_introportalmodnav` VALUES (1, 0, 0, 3, '$lang[\'Guest\']', '', -1, 2);
markus