Besions d'aide pour un neked clan
tiver11
Messages postés
241
Date d'inscription
Statut
Membre
Dernière intervention
-
tiver11 Messages postés 241 Date d'inscription Statut Membre Dernière intervention -
tiver11 Messages postés 241 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
j'ai quel que petit probleme pour instale mon neked clan sur un serv ftp
tout et bien fais j'ai verifier mes le momen ou je dois l'instalé bam!!
ou lieu de maffiché l'installation il maffiche la code source je croi :
<?php
//-------------------------------------------------------------------------//
// Nuked-KlaN 1.7 - Portal PHP //
// https://nuked-klan.org/ //
//-------------------------------------------------------------------------//
// This program is free software. you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License. //
//-------------------------------------------------------------------------//
include ("globals.php");
function index()
{
style();
echo "<div style=\"text-align: center;\"><br /><br /><br /><br /><h3>Select your language : </h3></div><br />\n"
. "<form method=\"post\" action=\"install.php?action=install\">\n"
. "<div style=\"text-align: center;\"><select name=\"langue\">\n";
if ($handle = opendir("lang/"))
{
while ($f = readdir($handle))
{
if ($f != ".." && $f != "." && $f != "index.html")
{
list ($langfile, ,) = split ('[.]', $f);
echo "<option value=\"" . $langfile . "\">" . $langfile . "</option>\n";
}
}
closedir($handle);
}
echo "</select> <input type=\"submit\" name=\"ok\" value=\"send\" /><br /><br /></div></form></body></html>";
}
function install()
{
global $langue;
include("lang/" . $langue . ".lang.php");
style();
echo "<div style=\"text-align: center;\"><br /><br /><br /><br /><h3>" . _WELCOMEINSTALL . "</h3><br />" . _GUIDEINSTALL . "<hr /><br />\n"
. "<input type=\"button\" name=\"install\" onclick=\"document.location='install.php?action=edit_config&op=save_config&langue=" . $langue . "';\" value=\""._INSTALL."\" />"
. " <input type=\"button\" name=\"upgrade\" onclick=\"document.location='update.php?action=edit_config&op=update_config&langue=" . $langue . "';\" value=\"" . _UPGRADE . "\" /></div></body></html>";
}
function style()
{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n"
. "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"fr\">\n"
. "<head><title>Nuked-KlaN</title>\n"
. "<style>\n"
. "h3{color:#666666;font-size:18px;font-weight:bold;font-family:Arial, verdana, Sans serif;line-height:0px;}\n"
. "a:link,a:visited,a:hover,a:active{color:#666666;font-size:12px;font-weight:bold;font-family:Arial, verdana, Sans serif;}\n"
. "body{background-color:#CCCCCC;color:#333333;font-family:arial,verdana, sans serif;}\n"
. "input{background-color:#999999;color:#FFFFFF;border: solid 1 rgb( 0 0 0);}\n"
. "select{background-color:#999999;color:#FFFFFF;border: solid 1 rgb( 0 0 0);}\n"
. ".barre{width:1px;background-color:white;align:left;}\n"
. "</style>\n"
. "<script type=\"text/javascript\">\n"
. "<!--\n"
. "var progr = 20;\n"
. "function show_progress(val, msg){\n"
. "if (msg == 'upgrade'){progr= progr+34;}\n"
. "else{\n"
. "progr+=2;"
. "Bw = document.getElementById('barre').innerHTML;\n"
. "var Nw = Bw + val;\n"
. "document.getElementById('barre').innerHTML = Nw;\n"
. "document.getElementById('infos').innerHTML = msg;\n"
. "//alert(Nw+' - '+msg);\n"
. "}\n"
. "}\n"
. "//-->\n"
. "</script>\n"
. "</head>\n"
. "<body>\n";
}
function progress()
{
echo "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" width=\"350\" border=\"0\"><tr><td>\n"
. "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n"
. "<tr><td><div id=\"barre\" class=\"barre\"> </div></td></tr>\n"
. "<tr><td colspan=\"2\"><div id=\"infos\">" . _INSTALLPROGRESS . "</div></td></tr>\n"
. "</table></td></tr></table>\n";
}
if (isset($action) && $action != "save_config" && $action != "update_config" && $action != "edit_config" && $action != "install")
{
include ("conf.inc.php");
connect();
}
function redirect($url, $tps)
{
$temps = $tps * 1000;
echo "<script type=\"text/javascript\">\n"
. "<!--\n"
. "\n"
. "function redirect() {\n"
. "window.location='" . $url . "'\n"
. "}\n"
. "setTimeout('redirect()','" . $temps ."');\n"
. "\n"
. "// -->\n"
. "</script>\n";
}
function connect()
{
global $global;
$db = mysql_connect($global['db_host'], $global['db_user'], $global['db_pass']) or die ("<div style=\"text-align: center;\">Error ! Database connexion failed<br />Check your user's name/password</div>");
$connect= mysql_select_db($global['db_name'], $db) or die ("<div style=\"text-align: center;\">Error ! Database connexion failed<br />Check your database's name</div>");
}
function create_db()
{
global $nuked, $langue, $db_prefix;
include ("lang/" . $langue . ".lang.php");
style();
echo "<div style=\"text-align: center;\"><br /><br /><h3>" . _INSTALLNK . "</h3><br />\n";
progress();
$time = time();
///////////////////////////////////////////////////////
// Creation des Tables
///////////////////////////////////////////////////////
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_banned";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_banned (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(50) NOT NULL default '',
`pseudo` varchar(50) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`texte` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_banned</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_block";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_block (
`bid` int(10) NOT NULL auto_increment,
`active` int(1) NOT NULL default '0',
`position` int(2) NOT NULL default '0',
`module` varchar(100) NOT NULL default '',
`titre` text NOT NULL,
`content` text NOT NULL,
`type` varchar(30) NOT NULL default '0',
`nivo` int(1) NOT NULL default '0',
`page` text NOT NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_block</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (1, 2, 1, '', '" . _BLOKLOGIN . "', '', 'login', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (2, 1, 1, '', '" . _NAV . "', '[News]|" . _NAVNEWS . "||0|NEWLINE[Archives]|" . _NAVARCHIV . "||0|NEWLINE[Forum]|" . _NAVFORUM . "||0|NEWLINE[Download]|" . _NAVDOWNLOAD . "||0|NEWLINE[Members]|" . _NAVMEMBERS . "||0|NEWLINE[Team]|" . _NAVTEAM . "||0|NEWLINE[Defy]|" . _NAVDEFY . "||0|NEWLINE[Recruit]|" . _NAVRECRUIT . "||0|NEWLINE[Sections]|" . _NAVART . "||0|NEWLINE[Server]|" . _NAVSERVER . "||0|NEWLINE[Links]|" . _NAVLINKS . "||0|NEWLINE[Calendar]|" . _NAVCALENDAR . "||0|NEWLINE[Gallery]|" . _NAVGALLERY . "||0|NEWLINE[Wars]|" . _NAVMATCHS . "||0|NEWLINE[Irc]|" . _NAVIRC . "||0|NEWLINE[Guestbook]|" . _NAVGUESTBOOK . "||0|NEWLINE[Search]|" . _NAVSEARCH . "||0|NEWLINE|<b>" . _MEMBER . "</b>||1|NEWLINE[User]|" . _NAVACCOUNT . "||1|NEWLINE|<b>" . _ADMIN . "</b>||2|NEWLINE[Admin]|" . _NAVADMIN . "||2|', 'menu', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (3, 1, 2, 'Search', '" . _BLOKSEARCH . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (4, 2, 2, '', '" . _POLL . "', '', 'survey', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (5, 2, 3, 'Wars', '" . _NAVMATCHS . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (6, 1, 3, 'Stats', '" . _BLOKSTATS . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (7, 0, 0, 'Irc', '" . _IRCAWARD . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (8, 0, 0, 'Server', '" . _SERVERMONITOR . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (9, 0, 0, '', '" . _SUGGEST . "', '', 'suggest', 1, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (10, 0, 0, 'Textbox', '" . _BLOKSHOUT . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (11, 1, 4, '', '" . _BLOKPARTNERS . "', '<div style=\"text-align: center;padding: 10px;\"><a href=\"https://nuked-klan.org/\" onclick=\"window.open(this.href); return false;\"><img style=\"border: 0;\" src=\"https://nuked-klan.org/ban.gif\" alt=\"\" title=\"Nuked-klaN CMS\" /></a></div><div style=\"text-align: center;padding: 10px;\"><a href=\"https://www.nitroserv.com/fr/\" onclick=\"window.open(this.href); return false;\"><img style=\"border: 0;\" src=\"http://www.nitroserv.com/images/logo_88x31.jpg\" alt=\"\" title=\"Location de serveurs de jeux\" /></a></div>', 'html', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_calendar";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_calendar (
`id` int(11) NOT NULL auto_increment,
`titre` text NOT NULL,
`description` text NOT NULL,
`date_jour` int(2) default NULL,
`date_mois` int(2) default NULL,
`date_an` int(4) default NULL,
`heure` varchar(5) NOT NULL default '',
`auteur` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_calendar</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_comment";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_comment (
`id` int(10) NOT NULL auto_increment,
`module` varchar(30) NOT NULL default '0',
`im_id` int(100) default NULL,
`autor` text,
`autor_id` varchar(20) NOT NULL default '',
`titre` text NOT NULL,
`comment` text,
`date` varchar(12) default NULL,
`autor_ip` varchar(20) default NULL,
PRIMARY KEY (`id`),
KEY `im_id` (`im_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_comment</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_config";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_config (
`name` varchar(255) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`name`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_config</b>" . _CREATES . " ');</script>";
$date = time();
$siteurl = "http://" . $_SERVER['SERVER_NAME'] . str_replace("install.php", "", $_SERVER['SCRIPT_NAME']);
if (substr($siteurl, -1) == "/") $siteurl = substr($siteurl, 0, -1);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('version', '1.7');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('date_install', '" . $date. "');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('langue', '" . $langue . "');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('name', 'Nuked-klaN 1.7');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('slogan', 'PHP 4 Gamers');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('tag_pre', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('tag_suf', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('url', '" . $siteurl . "');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('mail', 'mail@hotmail.com');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('footmessage', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('nk_status', 'open');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('index_site', 'News');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('theme', 'deus_17');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('keyword', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('description', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription_mail', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription_avert', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription_charte', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('validation', 'auto');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('user_delete', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('suggest_avert', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('irc_chan', 'nuked-klan');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('irc_serv', 'quakenet.eu.org');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_ip', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_port', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_pass', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_game', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_title', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_desc', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_rank_team', 'off');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_field_max', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_file', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_file_level', '1');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_file_maxsize', '1000');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('thread_forum_page', '20');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('mess_forum_page', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('hot_topic', '20');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('post_flood', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('gallery_title', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_img_line', '2');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_img', '6');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_news', '5');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_download', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('hide_download', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_liens', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_sections', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_wars', '30');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_archives', '30');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_members', '30');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_shout', '20');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('mess_guest_page', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('sond_delay', '24');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('level_analys', '-1');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('visit_delay', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute', '1');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute_charte', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute_mail', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute_inbox', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('defie_charte', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('defie_mail', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('defie_inbox', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('birthday', 'all');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('avatar_upload', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('avatar_url', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('cookiename', 'nuked');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('sess_inactivemins', '5');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('sess_days_limit', '365');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('nbc_timeout', '300');";
$req=mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_defie";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_defie (
`id` int(11) NOT NULL auto_increment,
`send` varchar(12) NOT NULL default '',
`pseudo` text NOT NULL,
`clan` text NOT NULL,
`mail` varchar(80) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`irc` varchar(50) NOT NULL default '',
`url` varchar(200) NOT NULL default '',
`pays` text NOT NULL,
`date` varchar(20) NOT NULL default '',
`heure` varchar(10) NOT NULL default '',
`serveur` text NOT NULL,
`game` int(11) NOT NULL default '0',
`type` text NOT NULL,
`map` text NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_defie</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_downloads";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_downloads (
`id` int(11) NOT NULL auto_increment,
`date` varchar(12) NOT NULL default '',
`taille` varchar(6) NOT NULL default '0',
`titre` text NOT NULL,
`description` text NOT NULL,
`type` int(11) NOT NULL default '0',
`count` int(10) NOT NULL default '0',
`url` varchar(200) NOT NULL default '',
`url2` varchar(200) NOT NULL default '',
`broke` int(11) NOT NULL default '0',
`url3` varchar(200) NOT NULL default '',
`level` int(1) NOT NULL default '0',
`hit` int(11) NOT NULL default '0',
`edit` varchar(12) NOT NULL default '',
`screen` varchar(200) NOT NULL default '',
`autor` text NOT NULL,
`url_autor` varchar(200) NOT NULL default '',
`comp` text NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_downloads</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_downloads_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_downloads_cat (
`cid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`titre` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`level` int(1) NOT NULL default '0',
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_downloads_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_fichiers_joins";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_fichiers_joins (
`id` int(10) NOT NULL auto_increment,
`module` varchar(30) NOT NULL default '',
`im_id` int(10) NOT NULL default '0',
`type` varchar(30) NOT NULL default '',
`url` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `im_id` (`im_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_fichiers_joins</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums (
`id` int(5) NOT NULL auto_increment,
`cat` int(11) NOT NULL default '0',
`nom` text NOT NULL,
`comment` text NOT NULL,
`moderateurs` text NOT NULL,
`niveau` int(1) NOT NULL default '0',
`level` int(1) NOT NULL default '0',
`ordre` int(5) NOT NULL default '0',
`level_poll` int(1) NOT NULL default '0',
`level_vote` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums (id, cat, nom, comment, moderateurs, niveau, level, ordre, level_poll, level_vote) VALUES (1, 1, 'Forum', 'Test Forum', '', 0, 0, 0, 1 ,1);";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_cat (
`id` int(11) NOT NULL auto_increment,
`nom` varchar(100) default NULL,
`ordre` int(5) NOT NULL default '0',
`niveau` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
$sql="INSERT INTO " . $db_prefix . "_forums_cat (id, nom, ordre, niveau) VALUES (1, 'Categorie 1', 0, 0);";
$req=mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_messages";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_messages (
`id` int(5) NOT NULL auto_increment,
`titre` text NOT NULL,
`txt` text NOT NULL,
`date` varchar(12) NOT NULL default '',
`edition` text NOT NULL,
`auteur` text NOT NULL,
`auteur_id` varchar(20) NOT NULL default '',
`auteur_ip` varchar(20) NOT NULL default '',
`bbcodeoff` int(1) NOT NULL default '0',
`smileyoff` int(1) NOT NULL default '0',
`cssoff` int(1) NOT NULL default '0',
`usersig` int(1) NOT NULL default '0',
`emailnotify` int(1) NOT NULL default '0',
`thread_id` int(5) NOT NULL default '0',
`forum_id` mediumint(10) NOT NULL default '0',
`file` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `auteur_id` (`auteur_id`),
KEY `thread_id` (`thread_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_messages</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_threads";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_threads (
`id` int(5) NOT NULL auto_increment,
`titre` text NOT NULL,
`date` varchar(10) default NULL,
`closed` int(1) NOT NULL default '0',
`auteur` text NOT NULL,
`auteur_id` varchar(20) NOT NULL default '',
`forum_id` int(5) NOT NULL default '0',
`last_post` varchar(20) NOT NULL default '',
`view` int(10) NOT NULL default '0',
`annonce` int(1) NOT NULL default '0',
`sondage` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `auteur_id` (`auteur_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_threads</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_rank";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_rank (
`id` int(10) NOT NULL auto_increment,
`nom` varchar(100) NOT NULL default '',
`type` int(1) NOT NULL default '0',
`post` int(4) NOT NULL default '0',
`image` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (1, 'Newbie', 0, 0, 'modules/Forum/images/rank/star1.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (2, 'Junior Member', 0, 10, 'modules/Forum/images/rank/star2.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (3, 'Member', 0, 100, 'modules/Forum/images/rank/star3.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (4, 'Senior Member', 0, 500, 'modules/Forum/images/rank/star4.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (5, 'Posting Freak', 0, 1000, 'modules/Forum/images/rank/star5.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (6, 'Moderator', 1, 0, 'modules/Forum/images/rank/mod.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (7, 'Administrator', 2, 0, 'modules/Forum/images/rank/mod.gif');";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_rank</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_read";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_read (
`id` int(11) NOT NULL auto_increment,
`user_id` varchar(20) NOT NULL default '',
`thread_id` int(11) NOT NULL default '0',
`forum_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `thread_id` (`thread_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_read</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_poll";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_poll (
`id` int(11) NOT NULL auto_increment,
`thread_id` int(11) NOT NULL default '0',
`titre` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `thread_id` (`thread_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_poll</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_options";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_options (
`id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
`option_text` varchar(255) NOT NULL default '',
`option_vote` int(11) NOT NULL default '0',
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_options</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_vote";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_vote (
`poll_id` int(11) NOT NULL default '0',
`auteur_id` varchar(20) NOT NULL default '',
`auteur_ip` varchar(20) NOT NULL default '',
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_vote</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_gallery";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_gallery (
`sid` int(11) NOT NULL auto_increment,
`titre` text NOT NULL,
`description` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`url2` varchar(200) NOT NULL default '',
`url_file` varchar(200) NOT NULL default '',
`cat` int(11) NOT NULL default '0',
`date` varchar(12) NOT NULL default '',
`count` int(10) NOT NULL default '0',
`autor` text NOT NULL,
PRIMARY KEY (`sid`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_gallery</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_gallery_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_gallery_cat (
`cid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`titre` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_gallery_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_games";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_games (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`titre` varchar(50) NOT NULL default '',
`icon` varchar(150) NOT NULL default '',
`pref_1` varchar(50) NOT NULL default '',
`pref_2` varchar(50) NOT NULL default '',
`pref_3` varchar(50) NOT NULL default '',
`pref_4` varchar(50) NOT NULL default '',
`pref_5` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_games</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_games (id, name, titre, icon, pref_1, pref_2, pref_3, pref_4, pref_5) VALUES (1, 'Counter-Strike', '" . _PREFCS . "', 'images/games/cs.gif', '" . _OTHERNICK . "', '" . _FAVMAP . "', '" . _FAVWEAPON . "', '" . _SKINT . "', '" . _SKINCT . "');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_games_prefs";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_games_prefs (
`id` int(11) NOT NULL auto_increment,
`game` int(11) NOT NULL default '0',
`user_id` varchar(20) NOT NULL default '',
`pref_1` text NOT NULL,
`pref_2` text NOT NULL,
`pref_3` text NOT NULL,
`pref_4` text NOT NULL,
`pref_5` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_games_prefs</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_guestbook";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_guestbook (
`id` int(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`url` varchar(70) NOT NULL default '',
`date` int(11) NOT NULL default '0',
`host` varchar(60) NOT NULL default '',
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_guestbook</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_irc_awards";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_irc_awards (
`id` int(20) NOT NULL auto_increment,
`text` text NOT NULL,
`date` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_irc_awards</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_liens";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_liens (
`id` int(10) NOT NULL auto_increment,
`date` varchar(12) NOT NULL default '',
`titre` text NOT NULL,
`description` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`cat` int(11) NOT NULL default '0',
`webmaster` text NOT NULL,
`country` varchar(50) NOT NULL default '',
`count` int(11) NOT NULL default '0',
`broke` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_liens</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_liens_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_liens_cat (
`cid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`titre` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_liens_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_match";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_match (
`warid` int(10) NOT NULL auto_increment,
`etat` int(1) NOT NULL default '0',
`team` int(11) NOT NULL default '0',
`game` int(11) NOT NULL default '0',
`adversaire` text,
`url_adv` varchar(60) default NULL,
`pays_adv` varchar(50) NOT NULL default '',
`type` varchar(100) default NULL,
`style` varchar(100) NOT NULL default '',
`date_jour` int(2) default NULL,
`date_mois` int(2) default NULL,
`date_an` int(4) default NULL,
`heure` varchar(10) NOT NULL default '',
`map_1` varchar(100) default NULL,
`map_2` varchar(100) default NULL,
`map_3` varchar(100) default NULL,
`score_team` int(10) NOT NULL default '0',
`score_adv` int(10) NOT NULL default '0',
`report` text,
`auteur` varchar(50) default NULL,
`url_league` varchar(100) default NULL,
`dispo` text,
`pas_dispo` text,
PRIMARY KEY (`warid`)
) TYPE=MyISAM;";
$req =mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_match</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_modules";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_modules (
`id` int(2) NOT NULL auto_increment,
`nom` varchar(50) NOT NULL default '',
`niveau` int(1) NOT NULL default '0',
`admin` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_modules</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (1, 'News', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (2, 'Forum', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (3, 'Wars', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (4, 'Irc', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (5, 'Survey', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (6, 'Links', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (7, 'Sections', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (8, 'Server', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (9, 'Download', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (10, 'Gallery', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (11, 'Guestbook', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (12, 'Suggest', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (13, 'Textbox', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (14, 'Calendar', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (15, 'Members', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (16, 'Team', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (17, 'Defy', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (18, 'Recruit', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (19, 'Comment', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (20, 'Vote', 0, 9);";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_nbconnecte";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_nbconnecte (
`IP` varchar(15) NOT NULL default '',
`type` int(10) NOT NULL default '0',
`date` int(14) NOT NULL default '0',
`user_id` varchar(20) NOT NULL default '',
`username` varchar(40) NOT NULL default '',
PRIMARY KEY ( `IP` , `user_id` )
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_nbconnecte</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_news";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_news (
`id` int(11) NOT NULL auto_increment,
`cat` varchar(30) NOT NULL default '',
`titre` text,
`auteur` text,
`auteur_id` varchar(20) NOT NULL default '',
`texte` text,
`suite` text,
`date` varchar(30) NOT NULL default '',
`bbcodeoff` int(1) NOT NULL default '0',
`smileyoff` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_news</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_news_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_news_cat (
`nid` int(11) NOT NULL auto_increment,
`titre` text,
`description` text,
`image` text,
PRIMARY KEY (`nid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_news_cat</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_news_cat VALUES ('1', 'Counter-Strike', '" . _BESTMOD . "', 'modules/News/images/cs.gif');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_recrute";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_recrute (
`id` int(11) NOT NULL auto_increment,
`date` varchar(12) NOT NULL default '',
`pseudo` text NOT NULL,
`prenom` text NOT NULL,
`age` int(3) NOT NULL default '0',
`mail` varchar(80) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`country` text NOT NULL,
`game` int(11) NOT NULL default '0',
`connection` text NOT NULL,
`experience` text NOT NULL,
`dispo` text NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`),
KEY `game` (`game`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_recrute</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sections";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sections (
`artid` int(11) NOT NULL auto_increment,
`secid` int(11) NOT NULL default '0',
`title` text NOT NULL,
`content` text NOT NULL,
`autor` text NOT NULL,
`autor_id` varchar(20) NOT NULL default '',
`counter` int(11) NOT NULL default '0',
`bbcodeoff` int(1) NOT NULL default '0',
`smileyoff` int(1) NOT NULL default '0',
`date` varchar(12) NOT NULL default '',
PRIMARY KEY (`artid`),
KEY `secid` (`secid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sections</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sections_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sections_cat (
`secid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`secname` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`secid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sections_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_serveur";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_serveur (
`sid` int(30) NOT NULL auto_increment,
`game` varchar(30) NOT NULL default '',
`ip` varchar(30) NOT NULL default '',
`port` varchar(10) NOT NULL default '',
`pass` varchar(10) NOT NULL default '',
`cat` varchar(30) NOT NULL default '',
PRIMARY KEY (`sid`),
KEY `game` (`game`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_serveur</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_serveur_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_serveur_cat (
`cid` int(30) NOT NULL auto_increment,
`titre` varchar(30) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_serveur_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sessions";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sessions (
`id` varchar(50) NOT NULL default '0',
`user_id` varchar(20) NOT NULL default '0',
`date` varchar(30) NOT NULL default '',
`last_used` varchar(30) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
`vars` blob NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sessions</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_smilies";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_smilies (
`id` int(5) NOT NULL auto_increment,
`code` varchar(50) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_smilies</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (1, ':D', 'biggrin.gif', 'Very Happy');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (2, ':)', 'smile.gif', 'Smile');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (3, ':(', 'frown.gif', 'Sad');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (4, ':o', 'eek.gif', 'Surprised');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (5, ':?', 'confused.gif', 'Confused');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (6, '8)', 'cool.gif', 'Cool');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (7, ':P', 'tongue.gif', 'Razz');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (8, ':x', 'mad.gif', 'Mad');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (9, ';)', 'wink.gif', 'Wink');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (10, ':red:', 'redface.gif', 'Embarassed');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (11, ':roll:', 'rolleyes.gif', 'Rolling Eyes');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sondage";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sondage (
`sid` int(11) NOT NULL auto_increment,
`titre` varchar(100) NOT NULL default '',
`date` varchar(15) NOT NULL default '0',
`niveau` int(1) NOT NULL default '0',
PRIMARY KEY (`sid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sond
j'ai quel que petit probleme pour instale mon neked clan sur un serv ftp
tout et bien fais j'ai verifier mes le momen ou je dois l'instalé bam!!
ou lieu de maffiché l'installation il maffiche la code source je croi :
<?php
//-------------------------------------------------------------------------//
// Nuked-KlaN 1.7 - Portal PHP //
// https://nuked-klan.org/ //
//-------------------------------------------------------------------------//
// This program is free software. you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License. //
//-------------------------------------------------------------------------//
include ("globals.php");
function index()
{
style();
echo "<div style=\"text-align: center;\"><br /><br /><br /><br /><h3>Select your language : </h3></div><br />\n"
. "<form method=\"post\" action=\"install.php?action=install\">\n"
. "<div style=\"text-align: center;\"><select name=\"langue\">\n";
if ($handle = opendir("lang/"))
{
while ($f = readdir($handle))
{
if ($f != ".." && $f != "." && $f != "index.html")
{
list ($langfile, ,) = split ('[.]', $f);
echo "<option value=\"" . $langfile . "\">" . $langfile . "</option>\n";
}
}
closedir($handle);
}
echo "</select> <input type=\"submit\" name=\"ok\" value=\"send\" /><br /><br /></div></form></body></html>";
}
function install()
{
global $langue;
include("lang/" . $langue . ".lang.php");
style();
echo "<div style=\"text-align: center;\"><br /><br /><br /><br /><h3>" . _WELCOMEINSTALL . "</h3><br />" . _GUIDEINSTALL . "<hr /><br />\n"
. "<input type=\"button\" name=\"install\" onclick=\"document.location='install.php?action=edit_config&op=save_config&langue=" . $langue . "';\" value=\""._INSTALL."\" />"
. " <input type=\"button\" name=\"upgrade\" onclick=\"document.location='update.php?action=edit_config&op=update_config&langue=" . $langue . "';\" value=\"" . _UPGRADE . "\" /></div></body></html>";
}
function style()
{
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n"
. "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"fr\">\n"
. "<head><title>Nuked-KlaN</title>\n"
. "<style>\n"
. "h3{color:#666666;font-size:18px;font-weight:bold;font-family:Arial, verdana, Sans serif;line-height:0px;}\n"
. "a:link,a:visited,a:hover,a:active{color:#666666;font-size:12px;font-weight:bold;font-family:Arial, verdana, Sans serif;}\n"
. "body{background-color:#CCCCCC;color:#333333;font-family:arial,verdana, sans serif;}\n"
. "input{background-color:#999999;color:#FFFFFF;border: solid 1 rgb( 0 0 0);}\n"
. "select{background-color:#999999;color:#FFFFFF;border: solid 1 rgb( 0 0 0);}\n"
. ".barre{width:1px;background-color:white;align:left;}\n"
. "</style>\n"
. "<script type=\"text/javascript\">\n"
. "<!--\n"
. "var progr = 20;\n"
. "function show_progress(val, msg){\n"
. "if (msg == 'upgrade'){progr= progr+34;}\n"
. "else{\n"
. "progr+=2;"
. "Bw = document.getElementById('barre').innerHTML;\n"
. "var Nw = Bw + val;\n"
. "document.getElementById('barre').innerHTML = Nw;\n"
. "document.getElementById('infos').innerHTML = msg;\n"
. "//alert(Nw+' - '+msg);\n"
. "}\n"
. "}\n"
. "//-->\n"
. "</script>\n"
. "</head>\n"
. "<body>\n";
}
function progress()
{
echo "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" width=\"350\" border=\"0\"><tr><td>\n"
. "<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n"
. "<tr><td><div id=\"barre\" class=\"barre\"> </div></td></tr>\n"
. "<tr><td colspan=\"2\"><div id=\"infos\">" . _INSTALLPROGRESS . "</div></td></tr>\n"
. "</table></td></tr></table>\n";
}
if (isset($action) && $action != "save_config" && $action != "update_config" && $action != "edit_config" && $action != "install")
{
include ("conf.inc.php");
connect();
}
function redirect($url, $tps)
{
$temps = $tps * 1000;
echo "<script type=\"text/javascript\">\n"
. "<!--\n"
. "\n"
. "function redirect() {\n"
. "window.location='" . $url . "'\n"
. "}\n"
. "setTimeout('redirect()','" . $temps ."');\n"
. "\n"
. "// -->\n"
. "</script>\n";
}
function connect()
{
global $global;
$db = mysql_connect($global['db_host'], $global['db_user'], $global['db_pass']) or die ("<div style=\"text-align: center;\">Error ! Database connexion failed<br />Check your user's name/password</div>");
$connect= mysql_select_db($global['db_name'], $db) or die ("<div style=\"text-align: center;\">Error ! Database connexion failed<br />Check your database's name</div>");
}
function create_db()
{
global $nuked, $langue, $db_prefix;
include ("lang/" . $langue . ".lang.php");
style();
echo "<div style=\"text-align: center;\"><br /><br /><h3>" . _INSTALLNK . "</h3><br />\n";
progress();
$time = time();
///////////////////////////////////////////////////////
// Creation des Tables
///////////////////////////////////////////////////////
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_banned";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_banned (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(50) NOT NULL default '',
`pseudo` varchar(50) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`texte` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_banned</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_block";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_block (
`bid` int(10) NOT NULL auto_increment,
`active` int(1) NOT NULL default '0',
`position` int(2) NOT NULL default '0',
`module` varchar(100) NOT NULL default '',
`titre` text NOT NULL,
`content` text NOT NULL,
`type` varchar(30) NOT NULL default '0',
`nivo` int(1) NOT NULL default '0',
`page` text NOT NULL,
PRIMARY KEY (`bid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_block</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (1, 2, 1, '', '" . _BLOKLOGIN . "', '', 'login', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (2, 1, 1, '', '" . _NAV . "', '[News]|" . _NAVNEWS . "||0|NEWLINE[Archives]|" . _NAVARCHIV . "||0|NEWLINE[Forum]|" . _NAVFORUM . "||0|NEWLINE[Download]|" . _NAVDOWNLOAD . "||0|NEWLINE[Members]|" . _NAVMEMBERS . "||0|NEWLINE[Team]|" . _NAVTEAM . "||0|NEWLINE[Defy]|" . _NAVDEFY . "||0|NEWLINE[Recruit]|" . _NAVRECRUIT . "||0|NEWLINE[Sections]|" . _NAVART . "||0|NEWLINE[Server]|" . _NAVSERVER . "||0|NEWLINE[Links]|" . _NAVLINKS . "||0|NEWLINE[Calendar]|" . _NAVCALENDAR . "||0|NEWLINE[Gallery]|" . _NAVGALLERY . "||0|NEWLINE[Wars]|" . _NAVMATCHS . "||0|NEWLINE[Irc]|" . _NAVIRC . "||0|NEWLINE[Guestbook]|" . _NAVGUESTBOOK . "||0|NEWLINE[Search]|" . _NAVSEARCH . "||0|NEWLINE|<b>" . _MEMBER . "</b>||1|NEWLINE[User]|" . _NAVACCOUNT . "||1|NEWLINE|<b>" . _ADMIN . "</b>||2|NEWLINE[Admin]|" . _NAVADMIN . "||2|', 'menu', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (3, 1, 2, 'Search', '" . _BLOKSEARCH . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (4, 2, 2, '', '" . _POLL . "', '', 'survey', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (5, 2, 3, 'Wars', '" . _NAVMATCHS . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (6, 1, 3, 'Stats', '" . _BLOKSTATS . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (7, 0, 0, 'Irc', '" . _IRCAWARD . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (8, 0, 0, 'Server', '" . _SERVERMONITOR . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (9, 0, 0, '', '" . _SUGGEST . "', '', 'suggest', 1, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (10, 0, 0, 'Textbox', '" . _BLOKSHOUT . "', '', 'module', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_block (bid, active, position, module, titre, content, type, nivo, page) VALUES (11, 1, 4, '', '" . _BLOKPARTNERS . "', '<div style=\"text-align: center;padding: 10px;\"><a href=\"https://nuked-klan.org/\" onclick=\"window.open(this.href); return false;\"><img style=\"border: 0;\" src=\"https://nuked-klan.org/ban.gif\" alt=\"\" title=\"Nuked-klaN CMS\" /></a></div><div style=\"text-align: center;padding: 10px;\"><a href=\"https://www.nitroserv.com/fr/\" onclick=\"window.open(this.href); return false;\"><img style=\"border: 0;\" src=\"http://www.nitroserv.com/images/logo_88x31.jpg\" alt=\"\" title=\"Location de serveurs de jeux\" /></a></div>', 'html', 0, 'Tous');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_calendar";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_calendar (
`id` int(11) NOT NULL auto_increment,
`titre` text NOT NULL,
`description` text NOT NULL,
`date_jour` int(2) default NULL,
`date_mois` int(2) default NULL,
`date_an` int(4) default NULL,
`heure` varchar(5) NOT NULL default '',
`auteur` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_calendar</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_comment";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_comment (
`id` int(10) NOT NULL auto_increment,
`module` varchar(30) NOT NULL default '0',
`im_id` int(100) default NULL,
`autor` text,
`autor_id` varchar(20) NOT NULL default '',
`titre` text NOT NULL,
`comment` text,
`date` varchar(12) default NULL,
`autor_ip` varchar(20) default NULL,
PRIMARY KEY (`id`),
KEY `im_id` (`im_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_comment</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_config";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_config (
`name` varchar(255) NOT NULL default '',
`value` text NOT NULL,
PRIMARY KEY (`name`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_config</b>" . _CREATES . " ');</script>";
$date = time();
$siteurl = "http://" . $_SERVER['SERVER_NAME'] . str_replace("install.php", "", $_SERVER['SCRIPT_NAME']);
if (substr($siteurl, -1) == "/") $siteurl = substr($siteurl, 0, -1);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('version', '1.7');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('date_install', '" . $date. "');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('langue', '" . $langue . "');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('name', 'Nuked-klaN 1.7');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('slogan', 'PHP 4 Gamers');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('tag_pre', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('tag_suf', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('url', '" . $siteurl . "');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('mail', 'mail@hotmail.com');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('footmessage', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('nk_status', 'open');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('index_site', 'News');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('theme', 'deus_17');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('keyword', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('description', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription_mail', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription_avert', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('inscription_charte', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('validation', 'auto');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('user_delete', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('suggest_avert', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('irc_chan', 'nuked-klan');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('irc_serv', 'quakenet.eu.org');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_ip', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_port', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_pass', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('server_game', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_title', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_desc', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_rank_team', 'off');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_field_max', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_file', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_file_level', '1');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('forum_file_maxsize', '1000');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('thread_forum_page', '20');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('mess_forum_page', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('hot_topic', '20');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('post_flood', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('gallery_title', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_img_line', '2');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_img', '6');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_news', '5');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_download', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('hide_download', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_liens', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_sections', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_wars', '30');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_archives', '30');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_members', '30');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('max_shout', '20');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('mess_guest_page', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('sond_delay', '24');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('level_analys', '-1');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('visit_delay', '10');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute', '1');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute_charte', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute_mail', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('recrute_inbox', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('defie_charte', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('defie_mail', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('defie_inbox', '');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('birthday', 'all');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('avatar_upload', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('avatar_url', 'on');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('cookiename', 'nuked');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('sess_inactivemins', '5');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('sess_days_limit', '365');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_config (name, value) VALUES ('nbc_timeout', '300');";
$req=mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_defie";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_defie (
`id` int(11) NOT NULL auto_increment,
`send` varchar(12) NOT NULL default '',
`pseudo` text NOT NULL,
`clan` text NOT NULL,
`mail` varchar(80) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`irc` varchar(50) NOT NULL default '',
`url` varchar(200) NOT NULL default '',
`pays` text NOT NULL,
`date` varchar(20) NOT NULL default '',
`heure` varchar(10) NOT NULL default '',
`serveur` text NOT NULL,
`game` int(11) NOT NULL default '0',
`type` text NOT NULL,
`map` text NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_defie</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_downloads";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_downloads (
`id` int(11) NOT NULL auto_increment,
`date` varchar(12) NOT NULL default '',
`taille` varchar(6) NOT NULL default '0',
`titre` text NOT NULL,
`description` text NOT NULL,
`type` int(11) NOT NULL default '0',
`count` int(10) NOT NULL default '0',
`url` varchar(200) NOT NULL default '',
`url2` varchar(200) NOT NULL default '',
`broke` int(11) NOT NULL default '0',
`url3` varchar(200) NOT NULL default '',
`level` int(1) NOT NULL default '0',
`hit` int(11) NOT NULL default '0',
`edit` varchar(12) NOT NULL default '',
`screen` varchar(200) NOT NULL default '',
`autor` text NOT NULL,
`url_autor` varchar(200) NOT NULL default '',
`comp` text NOT NULL,
PRIMARY KEY (`id`),
KEY `type` (`type`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_downloads</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_downloads_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_downloads_cat (
`cid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`titre` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`level` int(1) NOT NULL default '0',
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_downloads_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_fichiers_joins";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_fichiers_joins (
`id` int(10) NOT NULL auto_increment,
`module` varchar(30) NOT NULL default '',
`im_id` int(10) NOT NULL default '0',
`type` varchar(30) NOT NULL default '',
`url` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `im_id` (`im_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_fichiers_joins</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums (
`id` int(5) NOT NULL auto_increment,
`cat` int(11) NOT NULL default '0',
`nom` text NOT NULL,
`comment` text NOT NULL,
`moderateurs` text NOT NULL,
`niveau` int(1) NOT NULL default '0',
`level` int(1) NOT NULL default '0',
`ordre` int(5) NOT NULL default '0',
`level_poll` int(1) NOT NULL default '0',
`level_vote` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums (id, cat, nom, comment, moderateurs, niveau, level, ordre, level_poll, level_vote) VALUES (1, 1, 'Forum', 'Test Forum', '', 0, 0, 0, 1 ,1);";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_cat (
`id` int(11) NOT NULL auto_increment,
`nom` varchar(100) default NULL,
`ordre` int(5) NOT NULL default '0',
`niveau` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
$sql="INSERT INTO " . $db_prefix . "_forums_cat (id, nom, ordre, niveau) VALUES (1, 'Categorie 1', 0, 0);";
$req=mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_messages";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_messages (
`id` int(5) NOT NULL auto_increment,
`titre` text NOT NULL,
`txt` text NOT NULL,
`date` varchar(12) NOT NULL default '',
`edition` text NOT NULL,
`auteur` text NOT NULL,
`auteur_id` varchar(20) NOT NULL default '',
`auteur_ip` varchar(20) NOT NULL default '',
`bbcodeoff` int(1) NOT NULL default '0',
`smileyoff` int(1) NOT NULL default '0',
`cssoff` int(1) NOT NULL default '0',
`usersig` int(1) NOT NULL default '0',
`emailnotify` int(1) NOT NULL default '0',
`thread_id` int(5) NOT NULL default '0',
`forum_id` mediumint(10) NOT NULL default '0',
`file` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `auteur_id` (`auteur_id`),
KEY `thread_id` (`thread_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_messages</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_threads";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_threads (
`id` int(5) NOT NULL auto_increment,
`titre` text NOT NULL,
`date` varchar(10) default NULL,
`closed` int(1) NOT NULL default '0',
`auteur` text NOT NULL,
`auteur_id` varchar(20) NOT NULL default '',
`forum_id` int(5) NOT NULL default '0',
`last_post` varchar(20) NOT NULL default '',
`view` int(10) NOT NULL default '0',
`annonce` int(1) NOT NULL default '0',
`sondage` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `auteur_id` (`auteur_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_threads</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_rank";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_rank (
`id` int(10) NOT NULL auto_increment,
`nom` varchar(100) NOT NULL default '',
`type` int(1) NOT NULL default '0',
`post` int(4) NOT NULL default '0',
`image` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (1, 'Newbie', 0, 0, 'modules/Forum/images/rank/star1.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (2, 'Junior Member', 0, 10, 'modules/Forum/images/rank/star2.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (3, 'Member', 0, 100, 'modules/Forum/images/rank/star3.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (4, 'Senior Member', 0, 500, 'modules/Forum/images/rank/star4.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (5, 'Posting Freak', 0, 1000, 'modules/Forum/images/rank/star5.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (6, 'Moderator', 1, 0, 'modules/Forum/images/rank/mod.gif');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_forums_rank (id, nom, type, post, image) VALUES (7, 'Administrator', 2, 0, 'modules/Forum/images/rank/mod.gif');";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_rank</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_read";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_read (
`id` int(11) NOT NULL auto_increment,
`user_id` varchar(20) NOT NULL default '',
`thread_id` int(11) NOT NULL default '0',
`forum_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `thread_id` (`thread_id`),
KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_read</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_poll";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_poll (
`id` int(11) NOT NULL auto_increment,
`thread_id` int(11) NOT NULL default '0',
`titre` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `thread_id` (`thread_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_poll</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_options";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_options (
`id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
`option_text` varchar(255) NOT NULL default '',
`option_vote` int(11) NOT NULL default '0',
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_options</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_forums_vote";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_forums_vote (
`poll_id` int(11) NOT NULL default '0',
`auteur_id` varchar(20) NOT NULL default '',
`auteur_ip` varchar(20) NOT NULL default '',
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_forums_vote</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_gallery";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_gallery (
`sid` int(11) NOT NULL auto_increment,
`titre` text NOT NULL,
`description` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`url2` varchar(200) NOT NULL default '',
`url_file` varchar(200) NOT NULL default '',
`cat` int(11) NOT NULL default '0',
`date` varchar(12) NOT NULL default '',
`count` int(10) NOT NULL default '0',
`autor` text NOT NULL,
PRIMARY KEY (`sid`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_gallery</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_gallery_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_gallery_cat (
`cid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`titre` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_gallery_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_games";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_games (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`titre` varchar(50) NOT NULL default '',
`icon` varchar(150) NOT NULL default '',
`pref_1` varchar(50) NOT NULL default '',
`pref_2` varchar(50) NOT NULL default '',
`pref_3` varchar(50) NOT NULL default '',
`pref_4` varchar(50) NOT NULL default '',
`pref_5` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_games</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_games (id, name, titre, icon, pref_1, pref_2, pref_3, pref_4, pref_5) VALUES (1, 'Counter-Strike', '" . _PREFCS . "', 'images/games/cs.gif', '" . _OTHERNICK . "', '" . _FAVMAP . "', '" . _FAVWEAPON . "', '" . _SKINT . "', '" . _SKINCT . "');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_games_prefs";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_games_prefs (
`id` int(11) NOT NULL auto_increment,
`game` int(11) NOT NULL default '0',
`user_id` varchar(20) NOT NULL default '',
`pref_1` text NOT NULL,
`pref_2` text NOT NULL,
`pref_3` text NOT NULL,
`pref_4` text NOT NULL,
`pref_5` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_games_prefs</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_guestbook";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_guestbook (
`id` int(9) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`url` varchar(70) NOT NULL default '',
`date` int(11) NOT NULL default '0',
`host` varchar(60) NOT NULL default '',
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_guestbook</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_irc_awards";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_irc_awards (
`id` int(20) NOT NULL auto_increment,
`text` text NOT NULL,
`date` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_irc_awards</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_liens";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_liens (
`id` int(10) NOT NULL auto_increment,
`date` varchar(12) NOT NULL default '',
`titre` text NOT NULL,
`description` text NOT NULL,
`url` varchar(200) NOT NULL default '',
`cat` int(11) NOT NULL default '0',
`webmaster` text NOT NULL,
`country` varchar(50) NOT NULL default '',
`count` int(11) NOT NULL default '0',
`broke` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_liens</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_liens_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_liens_cat (
`cid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`titre` varchar(50) NOT NULL default '',
`description` text NOT NULL,
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_liens_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_match";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_match (
`warid` int(10) NOT NULL auto_increment,
`etat` int(1) NOT NULL default '0',
`team` int(11) NOT NULL default '0',
`game` int(11) NOT NULL default '0',
`adversaire` text,
`url_adv` varchar(60) default NULL,
`pays_adv` varchar(50) NOT NULL default '',
`type` varchar(100) default NULL,
`style` varchar(100) NOT NULL default '',
`date_jour` int(2) default NULL,
`date_mois` int(2) default NULL,
`date_an` int(4) default NULL,
`heure` varchar(10) NOT NULL default '',
`map_1` varchar(100) default NULL,
`map_2` varchar(100) default NULL,
`map_3` varchar(100) default NULL,
`score_team` int(10) NOT NULL default '0',
`score_adv` int(10) NOT NULL default '0',
`report` text,
`auteur` varchar(50) default NULL,
`url_league` varchar(100) default NULL,
`dispo` text,
`pas_dispo` text,
PRIMARY KEY (`warid`)
) TYPE=MyISAM;";
$req =mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_match</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_modules";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_modules (
`id` int(2) NOT NULL auto_increment,
`nom` varchar(50) NOT NULL default '',
`niveau` int(1) NOT NULL default '0',
`admin` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_modules</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (1, 'News', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (2, 'Forum', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (3, 'Wars', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (4, 'Irc', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (5, 'Survey', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (6, 'Links', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (7, 'Sections', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (8, 'Server', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (9, 'Download', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (10, 'Gallery', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (11, 'Guestbook', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (12, 'Suggest', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (13, 'Textbox', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (14, 'Calendar', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (15, 'Members', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (16, 'Team', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (17, 'Defy', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (18, 'Recruit', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (19, 'Comment', 0, 9);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_modules (id, nom, niveau, admin) VALUES (20, 'Vote', 0, 9);";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_nbconnecte";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_nbconnecte (
`IP` varchar(15) NOT NULL default '',
`type` int(10) NOT NULL default '0',
`date` int(14) NOT NULL default '0',
`user_id` varchar(20) NOT NULL default '',
`username` varchar(40) NOT NULL default '',
PRIMARY KEY ( `IP` , `user_id` )
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_nbconnecte</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_news";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_news (
`id` int(11) NOT NULL auto_increment,
`cat` varchar(30) NOT NULL default '',
`titre` text,
`auteur` text,
`auteur_id` varchar(20) NOT NULL default '',
`texte` text,
`suite` text,
`date` varchar(30) NOT NULL default '',
`bbcodeoff` int(1) NOT NULL default '0',
`smileyoff` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_news</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_news_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_news_cat (
`nid` int(11) NOT NULL auto_increment,
`titre` text,
`description` text,
`image` text,
PRIMARY KEY (`nid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_news_cat</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_news_cat VALUES ('1', 'Counter-Strike', '" . _BESTMOD . "', 'modules/News/images/cs.gif');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_recrute";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_recrute (
`id` int(11) NOT NULL auto_increment,
`date` varchar(12) NOT NULL default '',
`pseudo` text NOT NULL,
`prenom` text NOT NULL,
`age` int(3) NOT NULL default '0',
`mail` varchar(80) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`country` text NOT NULL,
`game` int(11) NOT NULL default '0',
`connection` text NOT NULL,
`experience` text NOT NULL,
`dispo` text NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`),
KEY `game` (`game`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_recrute</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sections";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sections (
`artid` int(11) NOT NULL auto_increment,
`secid` int(11) NOT NULL default '0',
`title` text NOT NULL,
`content` text NOT NULL,
`autor` text NOT NULL,
`autor_id` varchar(20) NOT NULL default '',
`counter` int(11) NOT NULL default '0',
`bbcodeoff` int(1) NOT NULL default '0',
`smileyoff` int(1) NOT NULL default '0',
`date` varchar(12) NOT NULL default '',
PRIMARY KEY (`artid`),
KEY `secid` (`secid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sections</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sections_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sections_cat (
`secid` int(11) NOT NULL auto_increment,
`parentid` int(11) NOT NULL default '0',
`secname` varchar(40) NOT NULL default '',
`description` text NOT NULL,
`position` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`secid`),
KEY `parentid` (`parentid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sections_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_serveur";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_serveur (
`sid` int(30) NOT NULL auto_increment,
`game` varchar(30) NOT NULL default '',
`ip` varchar(30) NOT NULL default '',
`port` varchar(10) NOT NULL default '',
`pass` varchar(10) NOT NULL default '',
`cat` varchar(30) NOT NULL default '',
PRIMARY KEY (`sid`),
KEY `game` (`game`),
KEY `cat` (`cat`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_serveur</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_serveur_cat";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_serveur_cat (
`cid` int(30) NOT NULL auto_increment,
`titre` varchar(30) NOT NULL default '',
`description` text NOT NULL,
PRIMARY KEY (`cid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_serveur_cat</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sessions";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sessions (
`id` varchar(50) NOT NULL default '0',
`user_id` varchar(20) NOT NULL default '0',
`date` varchar(30) NOT NULL default '',
`last_used` varchar(30) NOT NULL default '',
`ip` varchar(50) NOT NULL default '',
`vars` blob NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sessions</b>" . _CREATES . " ');</script>";
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_smilies";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_smilies (
`id` int(5) NOT NULL auto_increment,
`code` varchar(50) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_smilies</b>" . _CREATES . " ');</script>";
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (1, ':D', 'biggrin.gif', 'Very Happy');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (2, ':)', 'smile.gif', 'Smile');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (3, ':(', 'frown.gif', 'Sad');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (4, ':o', 'eek.gif', 'Surprised');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (5, ':?', 'confused.gif', 'Confused');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (6, '8)', 'cool.gif', 'Cool');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (7, ':P', 'tongue.gif', 'Razz');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (8, ':x', 'mad.gif', 'Mad');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (9, ';)', 'wink.gif', 'Wink');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (10, ':red:', 'redface.gif', 'Embarassed');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (11, ':roll:', 'rolleyes.gif', 'Rolling Eyes');";
$req = mysql_query($sql);
$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sondage";
$req = mysql_query($sql);
$sql = "CREATE TABLE " . $db_prefix . "_sondage (
`sid` int(11) NOT NULL auto_increment,
`titre` varchar(100) NOT NULL default '',
`date` varchar(15) NOT NULL default '0',
`niveau` int(1) NOT NULL default '0',
PRIMARY KEY (`sid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);
echo "<script>show_progress(' ','<b>" . $db_prefix . "_sond
A voir également:
- Besions d'aide pour un neked clan
- Clash of clan pc - Télécharger - Jeux vidéo
- Le clan - Guide
- Pourquoi clash of clan ne se lance pas ✓ - Forum jeux en ligne
- Clash of clan bug au chargement - Forum jeux en ligne
- Gemme clash of clan - Forum jeux en ligne
