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 |