$user = htmlspecialchars($_POST['user']); $pass = htmlspecialchars($_POST['pass']); $name = htmlspecialchars($_POST['name']); //Dati Connessione MySQL e Connessione $db_connect = @mysql_connect($host, $user, $pass); $db_select = @mysql_select_db($name); if (!$db_connect) { die("<b>Errore durante la connessione al database MySQL</b><br>" . mysql_errno() . " : " . mysql_error()); } elseif (!$db_select) { die("<b>Errore durante la selezione del database MySQL</b><br>" . mysql_errno() . " : " . mysql_error()); } //dati amministrazione $pass_admin = md5($_POST['password']); //dati di configurazione $title = VarProtect($_POST['title']); $prefix = VarProtect($_POST['prefix']); //creo la tabella users mysql_query("CREATE TABLE `" . $prefix . "users` (\n\t `id` int(11) NOT NULL auto_increment,\n\t `password` text NOT NULL,\n\t KEY `id` (`id`)\n\t);") or die(mysql_error()); print "Table <b>'" . $prefix . "users'</b> created with success<br />\n"; mysql_query("INSERT INTO " . $prefix . "users (password) VALUES ('" . $pass_admin . "');") or die(mysql_error()); //tabella config mysql_query("CREATE TABLE `" . $prefix . "config` (\n\t `title` text NOT NULL,\n\t `view_all` INT NOT NULL\n\t);") or die(mysql_error()); print "Table <b>'" . $prefix . "config'</b> created with success<br />\n"; mysql_query("INSERT INTO " . $prefix . "config (`title`, `view_all`) VALUES ('" . $title . "', 1);") or die(mysql_error()); print "Table <b>'" . $prefix . "config'</b> created with success<br />\n"; //tabella PASTES mysql_query("CREATE TABLE `" . $prefix . "pastes` (\n\t `id` int(255) default NULL,\n\t `author` text NOT NULL NOT NULL,\n\t `title` text,\n\t `ip` text NOT NULL,\n\t `language` mediumtext NOT NULL,\n\t `text` longtext NOT NULL,\n\t `data` text NOT NULL,\n\t `expire_date` TEXT\n\t);") or die(mysql_error()); print "Table <b>'" . $prefix . "pastes'</b> created with success<br />\n"; //creo il file config.php ;) $config = '<?php /*
if (!$db_connect) { die("<b>Errore durante la connessione al database MySQL</b><br />" . mysql_errno() . " : " . mysql_error()); } elseif (!$db_select) { die("<b>Errore durante la selezione del database MySQL</b><br />" . mysql_errno() . " : " . mysql_error()); } //dati amministrazione $user_admin = VarProtect($_POST['username']); $pass_admin = md5($_POST['password']); //dati di configurazione $title = VarProtect($_POST['title']); $desc = VarProtect($_POST['desc']); $email = VarProtect($_POST['email']); $limit = intval($_POST['limit']); $footer = VarProtect($_POST['footer']); $prefix = VarProtect($_POST['prefix']); $lang = VarProtect($_POST['lang']); //creo la tabella users mysql_query("CREATE TABLE `" . $prefix . "users` (\n\t `id` int(11) NOT NULL auto_increment,\n\t `username` text NOT NULL,\n\t `password` text NOT NULL,\n\t `email` text NOT NULL,\n\t KEY `id` (`id`)\n\t);") or die(mysql_error()); echo "Table <b>'" . $prefix . "users'</b> created with success<br />\n"; mysql_query("INSERT INTO " . $prefix . "users (username, password, email) VALUES ('" . $user_admin . "', '" . $pass_admin . "', '" . $email . "');") or die(mysql_error()); echo "User <b>" . $user_admin . "</b> added with success<br />\n"; //tabella config mysql_query("CREATE TABLE `" . $prefix . "config` (\n\t `title` text NOT NULL,\n\t `description` text NOT NULL,\n\t `themes` text NOT NULL,\n\t `lang` text NOT NULL,\n\t `limit` INT NOT NULL,\n\t `footer` text NOT NULL, \n\t `ip_log_active` INT NOT NULL \n\t);") or die(mysql_error()); echo "Table <b>'" . $prefix . "config'</b> created with success<br />\n"; mysql_query("INSERT INTO " . $prefix . "config (`title`, `description`, `themes`, `lang`, `limit`, `footer`, `ip_log_active`\n\t\t\t\t) VALUES (\n\t\t\t\t'" . $title . "', '" . $desc . "', 'default.css', '" . $lang . "', '" . $limit . "', '" . $footer . "', 1);") or die(mysql_error()); echo "<b>Configuration</b> added with success<br />\n"; //tabella articles mysql_query("CREATE TABLE `" . $prefix . "articles` (\n\t `id` int(11) NOT NULL auto_increment,\n\t `author` text NOT NULL,\n\t `title` text NOT NULL,\n\t `post` text NOT NULL,\n\t `post_date` text NOT NULL,\n\t `num_read` INT NOT NULL,\n \t `cat_id` INT NOT NULL,\n\t KEY `id` (`id`)\n\t);") or die(mysql_error()); echo "Table <b>'" . $prefix . "articles'</b> created with success<br />\n"; //tabella comments mysql_query("CREATE TABLE `" . $prefix . "comments` (\n\t `id` int(11) NOT NULL auto_increment,\n\t `blog_id` int(11) NOT NULL default '0',\n\t `name` text NOT NULL,\n\t `comment` text NOT NULL,\n\t `ip` text NOT NULL,\n\t KEY `id` (`id`)\n\t);") or die(mysql_error());