Toggle sidebar
  • Regolamento Macrocategoria DEV
    Prima di aprire un topic nella Macrocategoria DEV, è bene leggerne il suo regolamento. Sei un'azienda o un hosting/provider? Qui sono anche contenute informazioni per collaborare con Sciax2 ed ottenere l'accredito nella nostra community!

Domanda Phpnuke clan

F

Felix

Utente Normale
Autore del topic
20 Novembre 2007
94
0
Miglior risposta
0
Premetto che non capisco un H
Qualcuno sa spiegarmi (oppure se sa riedrizzarmi su un link)da dove scaricare,come installarlo e configurare il phpnuke clan?
PS. E' a pagamento?
Illuminatemi :Muhaha:
Grazie in anticipo per le vostre eventuali risposte.
 
Scusa hai ragione cercavo il nuked clan :| pensavo ad altro e ho scritto phpnuke clan..

Ok,girando un pò su google ho letto che è molto semplice installarlo(anche perchè e automatico) il problema è la configurazione di install.php e conf.inc.php cioè immettere i propi dati database.
Se qualcuno si offre volontario ad aiutarmi o meglio dire dove aggiungere i dati del mio database in conf.inc.php e install.php gliene sarei grato
Questo è il link:
Perfavore, Entra oppure Registrati per vedere i Link!

potrei anche incollare il contenuto e voi mi potreste semplicemente evidenziare in grassetto i dati da aggiungere.
Fatemi sapere,spero in voi siete la mia ultima speranza :emoji_slight_smile:

Questo è il testo di CON.FINC
<?php
//-------------------------------------------------------------------------//
// Nuked-KlaN - PHP Portal //
//
Perfavore, Entra oppure Registrati per vedere i Link!
//
//-------------------------------------------------------------------------//
// 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. //
//-------------------------------------------------------------------------//

$global['db_host'] = 'localhost';
$global['db_user'] = 'root';
$global['db_pass'] = '';
$global['db_name'] = '';
$db_prefix = 'nuked';

//define('NK_INSTALLED', true);
define('NK_OPEN', true);
define('NK_GZIP', true);

?>

QUESTO INSTALL
<?php
//-------------------------------------------------------------------------//
// Nuked-KlaN 1.7 - Portal PHP //
//
Perfavore, Entra oppure Registrati per vedere i Link!
//
//-------------------------------------------------------------------------//
// 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>&nbsp;&nbsp;<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&amp;op=save_config&amp;langue=" . $langue . "';\" value=\""._INSTALL."\" />"
. "&nbsp;<input type=\"button\" name=\"upgrade\" onclick=\"document.location='update.php?action=edit_config&amp;op=update_config&amp;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\">&nbsp;</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_banned</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_block</b>" . _CREATES . "&nbsp;');</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=\"http://www.nuked-klan.org\" onclick=\"window.open(this.href); return false;\"><img style=\"border: 0;\" src=\"http://www.nuked-klan.org/ban.gif\" alt=\"\" title=\"Nuked-klaN CMS\" /></a></div><div style=\"text-align: center;padding: 10px;\"><a href=\"http://www.nitroserv.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('&nbsp;&nbsp;','<b>" . $db_prefix . "_calendar</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_comment</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_config</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_defie</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_downloads</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_downloads_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_fichiers_joins</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_messages</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_threads</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_rank</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_read</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_poll</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_options</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_forums_vote</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_gallery</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_gallery_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_games</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_games_prefs</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_guestbook</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_irc_awards</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_liens</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_liens_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_match</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_modules</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_nbconnecte</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_news</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_news_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_recrute</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_sections</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_sections_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_serveur</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_serveur_cat</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_sessions</b>" . _CREATES . "&nbsp;');</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('&nbsp;&nbsp;','<b>" . $db_prefix . "_smilies</b>" . _CREATES . "&nbsp;');</script>";

$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (1, ':emoji_smiley:', 'biggrin.gif', 'Very Happy');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (2, ':emoji_slight_smile:', 'smile.gif', 'Smile');";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_smilies (id, code, url, name) VALUES (3, ':emoji_slight_frown:', '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('&nbsp;&nbsp;','<b>" . $db_prefix . "_sondage</b>" . _CREATES . "&nbsp;');</script>";

$sql = "INSERT INTO " . $db_prefix . "_sondage VALUES (1, '" . _LIKENK . "', '" . $time . "', 0);";
$req = mysql_query($sql);




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sondage_check";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_sondage_check (
`ip` varchar(20) NOT NULL default '',
`pseudo` varchar(50) NOT NULL default '',
`heurelimite` int(14) NOT NULL default '0',
`sid` varchar(30) NOT NULL default '',
KEY `sid` (`sid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_sondage_check</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_sondage_data";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_sondage_data (
`sid` int(11) NOT NULL default '0',
`optionText` char(50) NOT NULL default '',
`optionCount` int(11) NOT NULL default '0',
`voteID` int(11) NOT NULL default '0',
KEY `sid` (`sid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_sondage_data</b>" . _CREATES . "&nbsp;');</script>";

$sql = "INSERT INTO " . $db_prefix . "_sondage_data VALUES (1, '" . _ROXX . "', 0, 1);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_sondage_data VALUES (1, '" . _NOTBAD . "', 0, 2);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_sondage_data VALUES (1, '" . _SHIET . "', 0, 3);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_sondage_data VALUES (1, '" . _WHATSNK . "', 0, 4);";
$req = mysql_query($sql);





$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_stats";
$req = mysql_query($sql);

$sql="CREATE TABLE " . $db_prefix . "_stats (
`nom` varchar(50) NOT NULL default '',
`type` varchar(50) NOT NULL default '',
`count` int(11) NOT NULL default '0',
PRIMARY KEY (`nom`,`type`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_stats</b>" . _CREATES . "&nbsp;');</script>";

$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Gallery', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Archives', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Calendar', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Defy', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Download', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Guestbook', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Irc', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Links', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Wars', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('News', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Search', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Recruit', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Sections', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Server', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Members', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Team', 'pages', 0);";
$req = mysql_query($sql);
$sql = "INSERT INTO " . $db_prefix . "_stats (nom, type, count) VALUES ('Forum', 'pages', 0);";
$req = mysql_query($sql);





$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_stats_visitor";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_stats_visitor (
`id` int(11) NOT NULL auto_increment,
`user_id` varchar(20) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`host` varchar(100) NOT NULL default '',
`browser` varchar(50) NOT NULL default '',
`os` varchar(50) NOT NULL default '',
`referer` varchar(200) NOT NULL default '',
`day` int(2) NOT NULL default '0',
`month` int(2) NOT NULL default '0',
`year` int(4) NOT NULL default '0',
`hour` int(2) NOT NULL default '0',
`date` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `host` (`host`),
KEY `browser` (`browser`),
KEY `os` (`os`),
KEY `referer` (`referer`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_stats_visitor</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_suggest";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_suggest (
`id` int(11) NOT NULL auto_increment,
`module` mediumtext NOT NULL,
`user_id` varchar(20) NOT NULL default '',
`proposition` longtext NOT NULL,
`date` varchar(14) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_suggest</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_shoutbox";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_shoutbox (
`id` int(11) NOT NULL auto_increment,
`auteur` text,
`ip` varchar(20) NOT NULL default '',
`texte` text,
`date` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo"<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_shoutbox</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_team";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_team (
`cid` int(11) NOT NULL auto_increment,
`titre` varchar(50) NOT NULL default '',
`tag` text NOT NULL,
`tag2` text NOT NULL,
`ordre` int(5) NOT NULL default '0',
`game` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_team</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_team_rank";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_team_rank (
`id` int(11) NOT NULL auto_increment,
`titre` varchar(80) NOT NULL default '',
`ordre` int(5) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_userbox";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_userbox (
`mid` int(50) NOT NULL auto_increment,
`user_from` varchar(30) NOT NULL default '',
`user_for` varchar(30) NOT NULL default '',
`titre` varchar(50) NOT NULL default '',
`message` text NOT NULL,
`date` varchar(30) NOT NULL default '',
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`mid`),
KEY `user_from` (`user_from`),
KEY `user_for` (`user_for`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_userbox</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_users";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_users (
`id` varchar(20) NOT NULL default '',
`team` varchar(80) NOT NULL default '',
`team2` varchar(80) NOT NULL default '',
`team3` varchar(80) NOT NULL default '',
`rang` int(11) NOT NULL default '0',
`ordre` int(5) NOT NULL default '0',
`pseudo` text NOT NULL,
`mail` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`icq` varchar(50) NOT NULL default '',
`msn` varchar(80) NOT NULL default '',
`aim` varchar(50) NOT NULL default '',
`yim` varchar(50) NOT NULL default '',
`url` varchar(150) NOT NULL default '',
`pass` varchar(80) NOT NULL default '',
`niveau` int(1) NOT NULL default '0',
`date` varchar(30) NOT NULL default '',
`avatar` varchar(100) NOT NULL default '',
`signature` text NOT NULL,
`user_theme` varchar(30) NOT NULL default '',
`user_langue` varchar(30) NOT NULL default '',
`game` int(11) NOT NULL default '0',
`country` varchar(50) NOT NULL default '',
`count` int(10) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `team` (`team`),
KEY `team2` (`team2`),
KEY `team3` (`team3`),
KEY `rang` (`rang`),
KEY `game` (`game`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_users</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_users_detail";
$req = mysql_query($sql);

$sql = "CREATE TABLE " . $db_prefix . "_users_detail (
`user_id` varchar(20) NOT NULL default '0',
`prenom` text,
`age` varchar(10) NOT NULL default '',
`sexe` varchar(20) NOT NULL default '',
`ville` text,
`photo` varchar(150) NOT NULL default '',
`motherboard` text,
`cpu` varchar(50) default NULL,
`ram` varchar(10) NOT NULL default '',
`video` text,
`resolution` text,
`son` text,
`ecran` text,
`souris` text,
`clavier` text,
`connexion` text,
`system` text,
`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 (`user_id`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_users_detail</b>" . _CREATES . "&nbsp;');</script>";




$sql = "DROP TABLE IF EXISTS " . $db_prefix . "_vote";
$req = mysql_query($sql);

$sql="CREATE TABLE " . $db_prefix . "_vote (
`id` int(11) NOT NULL auto_increment,
`module` varchar(30) NOT NULL default '0',
`vid` int(100) default NULL,
`ip` varchar(20) NOT NULL default '',
`vote` int(2) default NULL,
PRIMARY KEY (`id`),
KEY `vid` (`vid`)
) TYPE=MyISAM;";
$req = mysql_query($sql);

echo "<script>show_progress('&nbsp;&nbsp;','<b>" . $db_prefix . "_vote</b>" . _CREATES . "&nbsp;');</script>";




echo "<script>show_progress('&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;','<b>" . _INSERTFIELD . "</b>.....Ok');</script>";
echo "<script>show_progress('&nbsp;&nbsp;&nbsp;','<b>" . _INSERTFINISH . "</b><br />');</script></div>";

// Config de God

echo "<script type=\"text/javascript\">\n"
."<!--\n"
."\n"
. "function verifchamps()\n"
. "{\n"
. "if (document.getElementById('install_pseudo').value.length < 3)\n"
. "{\n"
. "alert('" . _3TYPEMIN . "');\n"
. "return false;\n"
. "}\n"
. "\n"
. "if (document.getElementById('install_pass').value.length < 4)\n"
. "{\n"
. "alert('" . _4TYPEMIN . "');\n"
. "return false;\n"
. "}\n"
."\n"
."if (document.getElementById('install_pass').value != document.getElementById('install_passconf').value)\n"
."{\n"
."alert('" . _PASSFAILED . "');\n"
."return false;\n"
."}\n"
."\n"
. "return true;\n"
. "}\n"
."\n"
. "// -->\n"
. "</script>\n";

echo "<div style=\"text-align: center;\"><br /><br /><h3>" . _GODCONF . "</h3></div>\n"
. "<form method=\"post\" action=\"install.php?action=add_god\" onsubmit=\"return verifchamps();\">\n"
. "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" cellspacing=\"1\" cellpadding=\"2\" border=\"0\">\n"
. "<tr><td colspan=\"2\"><b>" . _CONFIG . "</b></td></tr>\n"
. "<tr><td colspan=\"2\">&nbsp;</td></tr>\n"
. "<tr><td>" . _GODNICK . " * :</td><td><input id=\"install_pseudo\" type=\"text\" name=\"pseudo\" size=\"30\" value=\"\" /></td></tr>\n"
. "<tr><td>" . _GODPASS . " * :</td><td><input id=\"install_pass\" type=\"password\" name=\"pass\" size=\"30\" value=\"\" /></td></tr>\n"
. "<tr><td>" . _GODPASS . " (" . _PASSCONFIRM . ") * :</td><td><input id=\"install_passconf\" type=\"password\" name=\"passconf\" size=\"30\" value=\"\" /></td></tr>\n"
. "<tr><td>" . _GODMAIL . " :</td><td><input type=\"text\" name=\"email\" size=\"40\" value=\"\" /></td></tr>\n"
. "<tr><td colspan=\"2\">&nbsp;<input type=\"hidden\" name=\"langue\" value=\"" . $langue . "\" /></td></tr>\n"
. "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\" name=\"ok\" value=\"Install\" /></td></tr></table></form></body></html>";
}




function add_god($data)
{
global $db_prefix;

style();
include ("lang/" . $data['langue'] . ".lang.php");

if (!$data['pseudo'] || ($data[pseudo] == "") || $data['pass'] != $data['passconf'] || (ereg("[\$\^\(\)'\"?%#<>,;:]",$data['pseudo'])))
{
echo "<script type=\"text/javascript\">\n"
."<!--\n"
."\n"
. "function verifchamps()\n"
. "{\n"
. "if (document.getElementById('install_pseudo').value.length < 3)\n"
. "{\n"
. "alert('" . _3TYPEMIN . "');\n"
. "return false;\n"
. "}\n"
. "\n"
. "if (document.getElementById('install_pass').value.length < 4)\n"
. "{\n"
. "alert('" . _4TYPEMIN . "');\n"
. "return false;\n"
. "}\n"
."\n"
."if (document.getElementById('install_pass').value != document.getElementById('install_passconf').value)\n"
."{\n"
."alert('" . _PASSFAILED . "');\n"
."return false;\n"
."}\n"
."\n"
. "return true;\n"
. "}\n"
."\n"
. "// -->\n"
. "</script>\n";

echo "<div style=\"text-align: center;\"><br /><b>" . _GODFAILDED . " !!!</b><br /><br /><h3>" . _GODCONF . "</h3></div>\n"
. "<form method=\"post\" action=\"install.php?action=add_god\" onsubmit=\"return verifchamps();\">\n"
. "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" cellspacing=\"1\" cellpadding=\"2\" border=\"0\">\n"
. "<tr><td colspan=\"2\"><b>" . _CONFIG . "</b></td></tr>\n"
. "<tr><td colspan=\"2\">&nbsp;</td></tr>\n"
. "<tr><td>" . _GODNICK . " :</td><td><input id=\"install_pseudo\" type=\"text\" name=\"pseudo\" size=\"30\" value=\"\" /></td></tr>\n"
. "<tr><td>" . _GODPASS . " :</td><td><input id=\"install_pass\" type=\"password\" name=\"pass\" size=\"30\" value=\"\" /></td></tr>\n"
. "<tr><td>" . _GODPASS . " (" . _PASSCONFIRM . ") :</td><td><input id=\"install_passconf\" type=\"password\" name=\"passconf\" size=\"30\" value=\"\" /></td></tr>\n"
. "<tr><td>" . _GODMAIL . " :</td><td><input type=\"text\" name=\"email\" size=\"40\" value=\"\" /></td></tr>\n"
. "<tr><td colspan=\"2\">&nbsp;<input type=\"hidden\" name=\"langue\" value=\"" . $data['langue'] . "\" /></td></tr>\n"
. "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\" name=\"ok\" value=\"Install\" /></td></tr></table></form></body></html>";

}
else
{
$pass = md5($data['pass']);
$date = time();
$ip = $_SERVER['REMOTE_ADDR'];

$taille = 20;
$lettres = "abCdefGhijklmNopqrstUvwXyz0123456789";
srand(time());

$pseudo = htmlentities($data['pseudo'], ENT_QUOTES);

for ($i=0;$i<$taille;$i++)
{
$user_id .= substr($lettres,(rand()%(strlen($lettres))), 1);
}

$sql = "INSERT INTO " . $db_prefix . "_news VALUES (1, 1, '" . _FIRSTNEWSTITLE . "', '" . $pseudo . "', '" . $user_id . "', '" . _FIRSTNEWSCONTENT . "', '', '" . $date . "', '', '');";
$req = mysql_query($sql);

$sql2 = "INSERT INTO " . $db_prefix . "_users VALUES ('" . $user_id . "', '', '', '', '', '', '" . $pseudo . "', '" . $data['email'] . "', '', '', '', '', '', '', '" . $pass . "', 9, '" . $date . "', '', '', '', '', 1, 'France.gif', '');";
$req2 = mysql_query($sql2);

$sql3 = "INSERT INTO " . $db_prefix . "_shoutbox VALUES (1, '" . $pseudo . "', '" . $ip . "', '" . _FIRSTNEWSTITLE . "', '" . $date . "');";
$req3 = mysql_query($sql3);

$error = 0;

$path1 = "upload/Download/";
if (is_dir($path1)) @chmod($path1, 0777);
if (!is_writable($path1)) $error++;

$path2 = "upload/Forum/";
if (is_dir($path2)) @chmod($path2, 0777);
if (!is_writable($path2)) $error++;

$path3 = "upload/Gallery/";
if (is_dir($path3)) @chmod($path3, 0777);
if (!is_writable($path3)) $error++;

$path4 = "upload/News/";
if (is_dir($path4)) @chmod($path4, 0777);
if (!is_writable($path4)) $error++;

$path5 = "upload/PDF/";
if (is_dir($path5)) @chmod($path5, 0777);
if (!is_writable($path5)) $error++;

$path6 = "upload/User/";
if (is_dir($path6)) @chmod($path6, 0777);
if (!is_writable($path6)) $error++;

$path7 = "upload/Wars/";
if (is_dir($path7)) @chmod($path7, 0777);
if (!is_writable($path7)) $error++;

$path8 = "images/icones/";
if (is_dir($path8)) @chmod($path8, 0777);
if (!is_writable($path8)) $error++;

$path9 = "upload/Suggest/";
if (is_dir($path9)) @chmod($path9, 0777);
if (!is_writable($path9)) $error++;

if (is_file("update.php"))
{
$path = "update.php";
$filesys = str_replace("/", "\\", $path);
@chmod($path, 0775);
@unlink($path);
@system("del $filesys");
if (is_file($path)) $error++;
}

if (is_file("install.php"))
{
$path_2="install.php";
$filesys2 = str_replace("/", "\\", $path_2);
@chmod($path_2, 0775);
@unlink($path_2);
@system("del $filesys2");
if (is_file($path_2)) $error++;
}

if ($error > 0)
{
echo "<br /><br /><div style=\"text-align: center;\"><h1>" . _CONGRATULATION . "</h1><br /><br />" . _ERRORCHMOD . "<br /><br /><a href=\"index.php\">" . _GOHOME . "</a></div></body></html>";
}
else
{
echo "<br /><br /><div style=\"text-align: center;\"><h1>" . _CONGRATULATION . "</h1><br /><br />" . _REDIRECT . "<br /><br /><a href=\"index.php\">" . _CLICIFNO . "</a></div></body></html>";
redirect("index.php", 5);
}

}
}


function edit_config($op)
{
global $langue;

include ("lang/" . $langue . ".lang.php");

style();

include("conf.inc.php");

echo "<div><a href=\"#\" onclick=\"javascript:window.open('help/" . $langue . "/install.html','Help','toolbar=0,location=0,directories=0,status=0,scrollbars=1,resizable=0,copyhistory=0,menuBar=0,width=350,height=300');return(false)\">\n"
. "<img style=\"border: 0;\" src=\"help/help.gif\" alt=\"\" title=\"" . _HELP . "\" /></a></div>\n"
. "<div style=\"text-align: center;\"><br /><br /><h3>" . _INSTALLNK . "</h3></div>\n"
. "<form method=\"post\" action=\"install.php?action=" . $op . "\">\n"
. "<table style=\"margin-left: auto;margin-right: auto;text-align: left;\" cellspacing=\"1\" cellpadding=\"2\" border=\"0\">\n"
. "<tr><td colspan=\"2\" align=\"center\"><b>" . _CONFIG . "</b></td></tr>\n"
. "<tr><td colspan=\"2\">&nbsp;<input type=\"hidden\" name=\"langue\" value=\"" . $langue . "\" /></td></tr>\n"
. "<tr><td>" . _DBHOST . " :</td><td><input type=\"text\" name=\"db_host\" size=\"40\" value=\"" . $global['db_host'] . "\" /></td></tr>\n"
. "<tr><td>" . _DBUSER . " : </td><td><input type=\"text\" name=\"db_user\" size=\"40\" value=\"" . $global['db_user'] . "\" /></td></tr>\n"
. "<tr><td>" . _DBPASS . " :</td><td><input type=\"password\" name=\"db_pass\" size=\"10\" /></td></tr><tr><td>\n"
. "<tr><td>" . _DBPREFIX . " :</td><td><input type=\"text\" name=\"prefix\" size=\"10\" value=\"" . $db_prefix . "\" /></td></tr>\n"
. "<tr><td>" . _DBNAME . " :</td><td><input type=\"text\" name=\"db_name\" size=\"10\" value=\"" . $global['db_name'] . "\" /></td></tr></table>\n"
. "<div style=\"text-align: center;\"><br />" . _CHMOD . "<br /><br /><input type=\"submit\" name=\"ok\" value=\"" . _NEXT . "\" /></div></form></body></html>";
}



function save_config($vars)
{
global $nuked;
include ("lang/" . $vars['langue'] . ".lang.php");

$db = @mysql_connect($vars['db_host'], $vars['db_user'], $vars['db_pass']);
$connect= @mysql_select_db($vars['db_name'], $db);

if(!$db || !$connect)
{
style();
echo "<br /><br /><br /><br /><div style=\"text-align: center;\"><b>" . _ERRORCONNECTDB . "</b></div></body></html>";
redirect("install.php?action=edit_config&op=save_config&langue=" . $vars['langue'], 5);
}
else
{
$content="<?php\n"
. "//-------------------------------------------------------------------------//\n"
. "// Nuked-KlaN - PHP Portal //\n"
. "// http://www.nuked-klan.org //\n"
. "//-------------------------------------------------------------------------//\n"
. "// This program is free software. you can redistribute it and/or modify //\n"
. "// it under the terms of the GNU General Public License as published by //\n"
. "// the Free Software Foundation; either version 2 of the License. //\n"
. "//-------------------------------------------------------------------------//\n"
. "\n"
. "\$global['db_host'] = '" . $vars['db_host'] . "';\n"
. "\$global['db_user'] = '" . $vars['db_user'] . "';\n"
. "\$global['db_pass'] = '" . $vars['db_pass'] . "';\n"
. "\$global['db_name'] = '" . $vars['db_name'] . "';\n"
. "\$db_prefix = '" . $vars['prefix'] . "';\n"
. "\n"
. "define('NK_INSTALLED', true);\n"
. "define('NK_OPEN', true);\n"
. "define('NK_GZIP', true);\n"
. "\n"
. "?>";

$path = "conf.inc.php";
@chmod ($path, 0666);

if (is_writable($path))
{
$fp = @fopen("conf.inc.php", w);
fwrite($fp, $content);
fclose($fp);
@chmod($path, 0644);

style();

echo "<div style=\"text-align: center;\"><br /><br /><big>" . _CONFIGSAVE . "<br />" . _CLICNEXTTOINSTALL . "</big><br /></div>\n"
. "<form method=\"post\" action=\"install.php?action=create_db&amp;langue=" . $vars['langue'] . "\" onsubmit=\"this.goButton.disabled=true; return true\">\n"
. "<div style=\"text-align: center;\"><input type=\"submit\" name=\"goButton\" value=\"" . _NEXT . "\" /></div></form></body></html>";
}
else
{
style();

echo "<div><a href=\"#\" onclick=\"javascript:window.open('help/" . $vars['langue'] . "/install.html','Help','toolbar=0,location=0,directories=0,status=0,scrollbars=1,resizable=0,copyhistory=0,menuBar=0,width=350,height=300');return(false)\">\n"
. "<img style=\"border: 0;\" src=\"help/help.gif\" alt=\"\" title=\"" . _HELP . "\" /></a></div>\n"
. "<div style=\"text-align: center;\"><br /><br /><h3>" . _INSTALLNK . "</h3></div>\n"
. "<form method=\"post\" action=\"install.php?action=save_config\">\n"
. "<div style=\"text-align: center;\">\n"
. "<input type=\"hidden\" name=\"langue\" value=\"" . $vars['langue'] . "\" />\n"
. "<input type=\"hidden\" name=\"db_host\" value=\"" . $vars['db_host'] . "\" />\n"
. "<input type=\"hidden\" name=\"db_user\" value=\"" . $vars['db_user'] . "\" />\n"
. "<input type=\"hidden\" name=\"db_pass\" value=\"" . $vars['db_pass'] . "\" />\n"
. "<input type=\"hidden\" name=\"prefix\" value=\"" . $vars['prefix'] . "\" />\n"
. "<input type=\"hidden\" name=\"db_name\" value=\"" . $vars['db_name'] . "\" />\n"
. "<br />" . _BADCHMOD . "<br /><br /><input type=\"submit\" name=\"ok\" value=\"" . _RETRY . "\" /></div></form></body></html>";
}
}
}


switch ($action)
{
case "save_config":
save_config($_POST);
break;

case "create_db":
create_db();
break;

case "add_god":
add_god($_POST);
break;

case"edit_config":
edit_config($_GET['op']);
break;

case"install":
install();
break;

default:
index();
break;
}


?>
 
Ultima modifica:
Sei su Altervista? Se si vai nel tuo pannello > Risorse & Upgrade > Database e attivane uno di livello 4

Poi compila il file config così:

$global['db_host'] = 'localhost';
$global['db_user'] = 'username altervista';
$global['db_pass'] = 'LASCIA VUOTO';
$global['db_name'] = 'my_usernamelatervista';
$db_prefix = 'nuked';

L'install non devi compilarlo tu ma mentre lo esegui ti chiederà di compilare alcuni campi.
 
Forse Nuked Clan è il miglior CMS per gestire il clan di un videogioco... eh si!
 
segui quello che ti ha detti Ketto se non ci riesci aggiungimi su msn che ne parliamo la...
 
Ok provo adesso vi faccio sapere.Un grazie a tutti ;)
--------------- AGGIUNTA AL POST ---------------
Sapete mica dove trovare i temi?
 
Ultima modifica:
Ti consiglio di cercare nel forum ufficiale la traduzione in italiano perchè c'è da qualche parte, se la trovo ti dico...
 
nn ho idea cmq esiste google..poi sei hai gia cercato..cmq è impossibile che nn ci sia..
 
la traduzione c'è! Io l'avevo l'ho persa per il formattamento... ora la cerco nei beckup e vedo se la ho. ;D
 
E' abbastanza serio come tool comunque la traduzione sta nel sito italiano :emoji_alien:
 
nuke clan è molto bello come cms, i temi sono ampi e originali, sono ocntento che tu non abbia più affrontato problemi ;)
 
Devi accedere o registrarti per rispondere qui.
 
 
Top
Indietro