Will erstmal sicherstellen, dass das nicht schon in Arbeit ist. Falls ich nich weiterkomme frag ich nach
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||


CREATE TABLE `prefix_allg` (
`id` int(5) unsigned NOT NULL auto_increment,
`k` varchar(255) NOT NULL default '',
`v1` varchar(255) NOT NULL default '',
`v2` varchar(255) NOT NULL default '',
`v3` varchar(255) NOT NULL default '',
`v4` varchar(255) NOT NULL default '',
`v5` varchar(255) NOT NULL default '',
`v6` varchar(255) NOT NULL default '',
`t1` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_awards` (
`id` int(10) unsigned NOT NULL auto_increment,
`time` int(20) NOT NULL default '0',
`platz` varchar(10) NOT NULL default '',
`team` varchar(100) NOT NULL default '',
`wofur` text NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_awaycal` (
`id` int(14) unsigned NOT NULL auto_increment,
`nick` char(80) default NULL,
`uid` tinyint(3) default NULL,
`pruef` tinyint(2) default '2',
`von` date default NULL,
`bis` date default NULL,
`betreff` char(255) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by silentforces.de';
CREATE TABLE `prefix_counter` (
`date` date NOT NULL default '0000-00-00',
`count` smallint(5) NOT NULL default '0'
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_downcats` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`cat` mediumint(8) default '0',
`pos` smallint(6) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_downloads` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`cat` mediumint(8) default '0',
`pos` smallint(6) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`creater` varchar(250) default NULL,
`version` varchar(20) default NULL,
`hits` int(11) NOT NULL default '0',
`downs` int(11) NOT NULL default '0',
`url` varchar(100) NOT NULL default '',
`surl` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`desc` varchar(255) default NULL,
`descl` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_forumcats` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`pos` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_forums` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`cid` mediumint(8) NOT NULL default '0',
`last_post_id` int(11) NOT NULL default '0',
`view` smallint(6) NOT NULL default '0',
`reply` smallint(6) NOT NULL default '0',
`start` smallint(6) NOT NULL default '0',
`mods` smallint(6) NOT NULL default '0',
`pos` tinyint(3) NOT NULL default '0',
`posts` mediumint(8) NOT NULL default '0',
`topics` mediumint(8) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`besch` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_gbook` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`mail` varchar(100) NOT NULL default '',
`page` varchar(100) NOT NULL default '',
`time` int(20) NOT NULL default '0',
`ip` varchar(20) NOT NULL default '',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_groups` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_groupusers` (
`uid` mediumint(9) NOT NULL default '0',
`gid` smallint(6) NOT NULL default '0',
`fid` smallint(6) NOT NULL default '0',
PRIMARY KEY (`uid`,`gid`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_history` (
`id` smallint(6) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`title` varchar(100) NOT NULL default '',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_koms` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` varchar(15) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`text` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_linkcats` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`cat` mediumint(8) default '0',
`pos` smallint(6) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_links` (
`id` smallint(6) NOT NULL auto_increment,
`cat` mediumint(8) default '0',
`pos` smallint(6) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
`banner` varchar(100) NOT NULL default '',
`link` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_menu` (
`id` smallint(6) NOT NULL auto_increment,
`sub` smallint(6) NOT NULL default '0',
`wo` tinyint(1) NOT NULL default '0',
`pos` tinyint(4) NOT NULL default '0',
`was` tinyint(1) NOT NULL default '0',
`recht` tinyint(2) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`link` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_modulerights` (
`uogid` mediumint(9) NOT NULL default '0',
`module` varchar(20) NOT NULL default '',
PRIMARY KEY (`uogid`,`module`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_modules` (
`module` varchar(20) NOT NULL default '',
`gshow` tinyint(1) NOT NULL default '0',
`ashow` tinyint(1) NOT NULL default '0',
`fright` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`module`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_news` (
`news_id` int(10) unsigned NOT NULL auto_increment,
`news_title` varchar(100) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
`news_time` datetime NOT NULL default '0000-00-00 00:00:00',
`news_recht` int(11) NOT NULL default '0',
`news_kat` varchar(100) NOT NULL default '',
`news_text` text NOT NULL,
PRIMARY KEY (`news_id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_newsletter` (
`email` varchar(100) NOT NULL default ''
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_online` (
`uid` int(10) NOT NULL default '0',
`uptime` int(20) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`sid` varchar(35) NOT NULL default ''
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_partners` (
`id` smallint(6) NOT NULL auto_increment,
`pos` smallint(6) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`banner` varchar(100) NOT NULL default '',
`link` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_pm` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`sid` mediumint(8) NOT NULL default '0',
`eid` mediumint(8) NOT NULL default '0',
`gelesen` tinyint(1) NOT NULL default '0',
`time` int(20) NOT NULL default '0',
`titel` varchar(100) NOT NULL default '',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_poll` (
`poll_id` mediumint(8) unsigned NOT NULL auto_increment,
`frage` varchar(200) NOT NULL default '',
`recht` tinyint(1) NOT NULL default '0',
`stat` tinyint(1) NOT NULL default '0',
`text` text NOT NULL,
PRIMARY KEY (`poll_id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_poll_res` (
`sort` tinyint(2) NOT NULL default '0',
`poll_id` mediumint(8) NOT NULL default '0',
`antw` varchar(100) NOT NULL default '',
`res` tinyint(4) NOT NULL default '0'
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_posts` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`tid` mediumint(8) NOT NULL default '0',
`fid` mediumint(9) NOT NULL default '0',
`erst` varchar(100) NOT NULL default '',
`erstid` int(10) NOT NULL default '0',
`time` bigint(20) NOT NULL default '0',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_profilefields` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`change` varchar(100) NOT NULL default '',
`show` varchar(100) NOT NULL default '',
`pos` int(11) NOT NULL default '0',
`udel` tinyint(1) NOT NULL default '0',
`func` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_ranks` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`bez` varchar(100) NOT NULL default '',
`min` int(10) NOT NULL default '0',
`spez` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_rules` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`zahl` smallint(6) NOT NULL default '0',
`titel` varchar(200) NOT NULL default '',
`text` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_smilies` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`ent` varchar(50) NOT NULL default '',
`url` varchar(250) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_shoutbox` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`nickname` varchar(50) NOT NULL default '',
`textarea` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_stats` (
`wtag` tinyint(2) NOT NULL default '0',
`stunde` tinyint(2) NOT NULL default '0',
`day` tinyint(2) NOT NULL default '0',
`mon` tinyint(2) NOT NULL default '0',
`yar` int(4) NOT NULL default '0',
`os` varchar(50) NOT NULL default '',
`browser` varchar(50) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`ref` varchar(255) NOT NULL default ''
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_teams` (
`gid` smallint(6) NOT NULL default '0',
`img` varchar(100) NOT NULL default '',
`mod` mediumint(9) NOT NULL default '0',
`pos` smallint(6) NOT NULL default '0',
PRIMARY KEY (`gid`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`fid` int(10) NOT NULL default '0',
`last_post_id` mediumint(9) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`erst` varchar(100) NOT NULL default '',
`art` int(1) NOT NULL default '0',
`stat` int(1) NOT NULL default '0',
`rep` int(10) NOT NULL default '0',
`hit` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_user` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`pass` varchar(32) NOT NULL default '',
`recht` int(1) NOT NULL default '0',
`posts` int(5) NOT NULL default '0',
`regist` int(20) default NULL,
`email` varchar(100) NOT NULL default '',
`llogin` int(20) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_usercheck` (
`check` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`pass` varchar(100) NOT NULL default '',
`datime` datetime NOT NULL default '0000-00-00 00:00:00',
`ak` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`check`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_userfields` (
`uid` mediumint(8) NOT NULL default '0',
`fid` mediumint(8) NOT NULL default '0',
`val` varchar(255) NOT NULL default '',
PRIMARY KEY (`uid`,`fid`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_userfuncs` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`pos` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_warmaps` (
`wid` smallint(6) NOT NULL default '0',
`mnr` tinyint(4) NOT NULL default '0',
`map` varchar(100) NOT NULL default '',
`opp` smallint(6) NOT NULL default '0',
`owp` smallint(6) NOT NULL default '0',
PRIMARY KEY (`wid`,`mnr`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_warmember` (
`wid` smallint(6) NOT NULL default '0',
`uid` mediumint(9) NOT NULL default '0',
`aktion` tinyint(1) NOT NULL default '0',
`kom` text NOT NULL
) TYPE=MyISAM COMMENT='powered by ilch.de';
CREATE TABLE `prefix_wars` (
`id` int(10) unsigned NOT NULL auto_increment,
`datime` datetime NOT NULL default '0000-00-00 00:00:00',
`status` tinyint(2) NOT NULL default '0',
`wlp` tinyint(1) NOT NULL default '0',
`owp` smallint(6) NOT NULL default '0',
`opp` smallint(6) NOT NULL default '0',
`gegner` varchar(100) NOT NULL default '',
`page` varchar(100) NOT NULL default '',
`tid` smallint(6) NOT NULL default '0',
`mod` varchar(100) NOT NULL default '',
`game` varchar(100) NOT NULL default '',
`mtyp` varchar(100) NOT NULL default '',
`land` varchar(100) NOT NULL default '',
`txt` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='powered by ilch.de';
INSERT INTO prefix_allg VALUES ('', 'Contact', '', '1', '1', '', '', '', '');
INSERT INTO `prefix_allg` VALUES ('', 'Impressum', 'Responsible for this page:', 'Max Mustermann', 'Street, No', 'Postal code, City', '', '', 'Text');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'gbook_posts_per_site', '20', 't', 'Guestbook Options', '', '', 'Entries per site');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'gallery_imgs_per_line', '4', 't', 'Gallery Options', '', '', 'Pictures per line');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Aanz', '3', 't', 'Archive Options', '', '', 'Number of Banners in the Partners Box');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Nlimit', '5', 't', 'News Options', '', '', 'News per site');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Ftanz', '10', 't', 'Forum Options', '', '', 'Topics on a site');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Fpanz', '15', 't', 'Forum Options', '', '', 'Posts on a site');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'forum_avatar_upload', '1', 'r2', 'Forum Options', '', '', 'Avatar Upload?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'gallery_imgs_per_site', '12', 't', 'Gallery Options', '', '', 'Pictures per site');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'gallery_preview_width', '50', 't', 'Gallery Options', '', '', 'Width of Thumbnails');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Fpmf', '1', 'r2', 'Forum Optionen', '', '', 'Message Function');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'gfx', 'ilchClan', 's', 'General Options', '', '', 'Default Design');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'adminMail', 'dddd', 't', 'General Options', '', '', 'Administrator eMail');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'smodul', 'news', 's', 'General Options', '', '', 'Start Modul der Seite');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'title', 'The Clanscript for everyone!', 't', 'General Options', '', '', 'Title of the page');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Flogintry', '5', 't', 'Forum Options', '', '', 'Login ');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Fabreite', '80', 't', 'Forum Options', '', '', 'max width for avatar');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Fahohe', '80', 't', 'Forum Options', '', '', 'max height for avatar');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Fasize', '16161', 't', 'Forum Options', '', '', 'max size (Bytes) for avatar');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Gsperre', '3600', 't', 'Guestbook Options', '', '', 'Ip ban in seconds');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Gtxtl', '600', 't', 'Guestbook Options', '', '', 'max text length in the guestbook');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Aart', '0', 'r2', 'Archiv Options', '', '', 'Shall the Partners Box be sorted?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Ngkoms', '1', 'r2', 'News Options', '', '', 'Are guests allowed to write comments?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'Nukoms', '1', 'r2', 'News Options', '', '', 'Are users allowed to write comments?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'allg_menupoint_access', '1', 'r2', 'General Options', '', '', 'Access to modules not linked in menus for everyone?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'forum_regist', '1', 'r2', 'Forum Options', '', '', 'Are users allowed to register?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'forum_regist_user_pass', '0', 'r2', 'Forum Options', '', '', 'Password choosable by user during registration?');
INSERT INTO `prefix_allg` VALUES ('', 'ALLG', 'forum_regist_confirm_link', '1', 'r2', 'Forum Options', '', '', 'Confirm registration per link in email?');
INSERT INTO `prefix_menu` VALUES (1, 1, 1, 0, 2, 0, 'Menu', 'allianz.php');
INSERT INTO `prefix_menu` VALUES (2, 2, 1, 10, 2, 0, 'Clan Menu', 'allianz.php');
INSERT INTO `prefix_menu` VALUES (3, 3, 1, 19, 1, 0, 'Login', 'login.php');
INSERT INTO `prefix_menu` VALUES (4, 1, 1, 1, 3, 0, 'News', '?m=news');
INSERT INTO `prefix_menu` VALUES (5, 1, 1, 9, 3, 0, 'Links', '?m=links');
INSERT INTO `prefix_menu` VALUES (6, 1, 1, 7, 3, 0, 'Downloads', '?m=downloads');
INSERT INTO `prefix_menu` VALUES (7, 1, 1, 8, 3, 0, 'Gallery', '?m=gallery');
INSERT INTO `prefix_menu` VALUES (8, 1, 1, 2, 3, 0, 'Forum', '?m=forum');
INSERT INTO `prefix_menu` VALUES (9, 1, 1, 3, 3, 0, 'Contact', '?m=contact');
INSERT INTO `prefix_menu` VALUES (10, 1, 1, 4, 3, 0, 'Guestbuch', '?m=gbook');
INSERT INTO `prefix_menu` VALUES (11, 2, 1, 12, 3, 0, 'Wars', '?m=wars');
INSERT INTO `prefix_menu` VALUES (13, 2, 1, 16, 3, 0, 'AwayCal', '?m=awaycal');
INSERT INTO `prefix_menu` VALUES (15, 2, 1, 13, 3, 0, 'Awards', '?m=awards');
INSERT INTO `prefix_menu` VALUES (16, 2, 1, 18, 3, 0, 'Fightus', '?m=fightus');
INSERT INTO `prefix_menu` VALUES (17, 2, 1, 17, 3, 0, 'Joinus', '?m=joinus');
INSERT INTO `prefix_menu` VALUES (18, 2, 1, 14, 3, 0, 'Rules', '?m=rules');
INSERT INTO `prefix_menu` VALUES (20, 2, 1, 11, 3, 0, 'Squads', '?m=teams');
INSERT INTO `prefix_menu` VALUES (21, 1, 1, 6, 3, 0, 'Members', '?m=user');
INSERT INTO `prefix_menu` VALUES (22, 22, 2, 0, 1, 0, 'Vote', 'vote.php');
INSERT INTO `prefix_menu` VALUES (23, 23, 2, 1, 1, 0, 'Alliance', 'allianz.php');
INSERT INTO `prefix_menu` VALUES (24, 24, 2, 2, 1, 0, 'Statistic', 'statistik.php');
INSERT INTO `prefix_menu` VALUES (25, 25, 2, 3, 1, 0, 'Lastwars', 'lastwars.php');
INSERT INTO `prefix_menu` VALUES (26, 26, 2, 4, 1, 0, 'Nextwars', 'nextwars.php');
INSERT INTO `prefix_menu` VALUES (27, 27, 2, 5, 1, 0, 'Newsletter', 'newsletter.php');
INSERT INTO `prefix_menu` VALUES (28, 28, 2, 6, 1, 0, 'Last Forum', 'lastforum.php');
INSERT INTO `prefix_menu` VALUES (29, 29, 2, 7, 1, 0, 'Last News', 'lastnews.php');
INSERT INTO `prefix_menu` VALUES (30, 30, 2, 8, 1, 0, 'Designs', 'designs.php');
INSERT INTO `prefix_menu` VALUES (31, 31, 1, 20, 1, 0, 'Shoutbox', 'shoutbox.php');
INSERT INTO `prefix_menu` VALUES (32, 1, 1, 5, 3, 0, 'Impressum', '?m=impressum');
INSERT INTO `prefix_menu` VALUES (33, 2, 1, 15, 3, 0, 'History', '?m=history');
INSERT INTO prefix_modules VALUES ('gallery', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('news', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('teams', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('groups', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('rules', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('awards', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('wars', 1, 0, 1);
INSERT INTO prefix_modules VALUES ('forumsite', 0, 0, 1);
INSERT INTO prefix_modules VALUES ('forum', 1, 0, 1);
INSERT INTO prefix_profilefields VALUES (1, 'Residence', 'Residence', 0, 0, 1);
INSERT INTO prefix_profilefields VALUES (2, 'Activate PrivMsg?', 'PrivMsg', 9, 0, 3);
INSERT INTO prefix_profilefields VALUES (3, 'Email from users?', 'eMail', 8, 0, 3);
INSERT INTO prefix_profilefields VALUES (4, 'Homepage', 'Homepage', 10, 0, 1);
INSERT INTO prefix_profilefields VALUES (5, 'Signature', 'Signature', 5, 0, 4);
INSERT INTO prefix_profilefields VALUES (6, 'Avatar', 'Avatar', 6, 0, 2);
INSERT INTO prefix_profilefields VALUES (7, 'ICQ Number', 'ICQ Number', 11, 0, 1);
INSERT INTO prefix_profilefields VALUES (8, 'Date of birth', 'Date of birth', 1, 0, 1);
INSERT INTO prefix_profilefields VALUES (9, 'Sex', 'Sex', 3, 0, 1);
INSERT INTO prefix_profilefields VALUES (10, 'Nationality', 'Nationality', 4, 0, 5);
INSERT INTO prefix_profilefields VALUES (11, 'Activ?', 'Status', 2, 0, 3);
INSERT INTO prefix_profilefields VALUES (12, 'Contact', 'Contact', 7, 0, 6);
INSERT INTO prefix_ranks VALUES (1, 'Grünschnabel', 1, 0);
INSERT INTO prefix_ranks VALUES (2, 'Jungspund', 25, 0);
INSERT INTO prefix_ranks VALUES (3, 'Mitglied', 50, 0);
INSERT INTO prefix_ranks VALUES (4, 'Eroberer', 75, 0);
INSERT INTO prefix_ranks VALUES (6, 'Doppel-As', 150, 0);
INSERT INTO prefix_ranks VALUES (7, 'Tripel-As', 250, 0);
INSERT INTO prefix_ranks VALUES (8, 'Haudegen', 500, 0);
INSERT INTO prefix_ranks VALUES (9, 'Routinier', 1000, 0);
INSERT INTO prefix_ranks VALUES (10, 'König', 2000, 0);
INSERT INTO prefix_ranks VALUES (11, 'Kaiser', 5000, 0);
INSERT INTO prefix_ranks VALUES (12, 'Legende', 7000, 0);
INSERT INTO prefix_ranks VALUES (13, 'Foren Gott', 10000, 0);
INSERT INTO prefix_ranks VALUES (14, 'Administrator', 0, 1);
INSERT INTO prefix_smilies VALUES (1, ':)', 'include/images/smiles/1.gif');
INSERT INTO prefix_smilies VALUES (2, ':D', 'include/images/smiles/2.gif');
INSERT INTO prefix_smilies VALUES (3, ':O', 'include/images/smiles/3.gif');
INSERT INTO prefix_smilies VALUES (4, ':P', 'include/images/smiles/4.gif');
INSERT INTO prefix_smilies VALUES (5, '', 'include/images/smiles/5.gif');
INSERT INTO prefix_smilies VALUES (6, ':(', 'include/images/smiles/6.gif');
INSERT INTO prefix_smilies VALUES (7, ':S', 'include/images/smiles/7.gif');
INSERT INTO prefix_smilies VALUES (8, ':|', 'include/images/smiles/8.gif');


| Geschlossen | ||
![]() |
Zurück zu Allgemein | |