function install()
{
//bind password
$password = post("adminpassword1");
//create important vars
$salt = rand(0, 99999);
$md5_password = md5($salt . $password);
DB::query("DROP TABLE IF EXISTS " . DB_PREFIX . "user");
DB::query("CREATE TABLE " . DB_PREFIX . "user(\r\n user_id int(11) NOT NULL AUTO_INCREMENT,\r\n name varchar(90) NOT NULL,\r\n salt int(5) NOT NULL default '0',\r\n password varchar(32) NOT NULL default '0',\r\n email varchar(255) NOT NULL,\r\n last_ip varchar(255) NOT NULL default '127.0.0.1',\r\n data_login int(15) NULL,\r\n status int(1) NOT NULL default 1,\r\n activation_code varchar(40) NULL,\r\n lang_id varchar(2) NOT NULL default 'EN',\r\n PRIMARY KEY (user_id)\r\n ) ENGINE=MyISAM");
DB::insert(DB_PREFIX . "user", array("name" => post("adminname"), "salt" => "{$salt}", "password" => "{$md5_password}", "email" => post("adminemail", FILTER_SANITIZE_EMAIL), "status" => 3));
DB::query("DROP TABLE IF EXISTS " . DB_PREFIX . "user_where_is");
DB::query("CREATE TABLE " . DB_PREFIX . "user_where_is ( \r\n user_where_is_id int(11) NOT NULL AUTO_INCREMENT,\r\n user_id int(11) NOT NULL,\r\n guest_id int(11) NOT NULL,\r\n ip varchar(20) NOT NULL default '127.0.0.1',\r\n name varchar(90) NOT NULL,\r\n sid varchar(32) NOT NULL,\r\n url varchar(255) NOT NULL,\r\n id int(11) NOT NULL,\r\n file varchar(255) NOT NULL,\r\n os varchar(255) NOT NULL,\r\n browser varchar(255) NOT NULL,\r\n time int(15) NOT NULL , \r\n time_first_click int(15) NOT NULL,\r\n country_code varchar(2) NOT NULL,\r\n country_name varchar(90) NOT NULL,\r\n region_code varchar(15) NOT NULL,\r\n region_name varchar(255) NOT NULL,\r\n city_name varchar(255) NOT NULL,\r\n zip varchar(20) NOT NULL,\r\n latitude varchar(55) NOT NULL,\r\n longitude varchar(55) NOT NULL,\r\n timezone_name varchar(255) NOT NULL,\r\n gmt_offset varchar(255) NOT NULL,\r\n PRIMARY KEY (user_where_is_id)\r\n ) ENGINE=MyISAM");
DB::query("DROP TABLE IF EXISTS " . DB_PREFIX . "usergroup");
DB::query("CREATE TABLE " . DB_PREFIX . "usergroup(\r\n group_id int(11) NOT NULL AUTO_INCREMENT,\r\n parent_id int(11) NOT NULL,\r\n name varchar(255) NOT NULL,\r\n position int(11) NOT NULL,\r\n nuser int(11) NOT NULL,\r\n PRIMARY KEY (group_id)\r\n ) ENGINE=MyISAM");
DB::query("DROP TABLE IF EXISTS " . DB_PREFIX . "usergroup_user");
DB::query("CREATE TABLE " . DB_PREFIX . "usergroup_user(\r\n group_id int(11) NOT NULL,\r\n user_id int(11) NOT NULL,\r\n PRIMARY KEY (group_id , user_id)\r\n ) ENGINE=MyISAM");
DB::query("DROP TABLE IF EXISTS " . DB_PREFIX . "user_localization");
DB::query("CREATE TABLE " . DB_PREFIX . "user_localization(\r\n user_localization_id int(11) NOT NULL AUTO_INCREMENT,\r\n ip varchar(20) NOT NULL DEFAULT '127.0.0.1',\r\n sid varchar(32) NOT NULL,\r\n user_id int(11) NOT NULL,\r\n guest_id int(11) NOT NULL,\r\n name varchar(90) NOT NULL,\r\n url varchar(255) NOT NULL,\r\n id int(11) NOT NULL,\r\n file varchar(255) NOT NULL,\r\n os varchar(255) NOT NULL,\r\n browser varchar(255) NOT NULL,\r\n time int(15) NOT NULL,\r\n time_first_click int(15) NOT NULL,\r\n country_code varchar(2) NOT NULL,\r\n country_name varchar(90) NOT NULL,\r\n region_code varchar(15) NOT NULL,\r\n region_name varchar(255) NOT NULL,\r\n city_name varchar(255) NOT NULL,\r\n zip varchar(20) NOT NULL,\r\n latitude varchar(55) NOT NULL,\r\n longitude varchar(55) NOT NULL,\r\n timezone_name varchar(255) NOT NULL,\r\n gmt_offset varchar(255) NOT NULL,\r\n PRIMARY KEY (user_localization_id)\r\n )");
$querys = DB::get_executed_query();
$html_message = '<br /><strong>Install Complete!!!<br /></strong> Please Delete: <br /><strong>' . CONTROLLERS_DIR . 'install
</strong><br />Please read next steps in the "Install-notes" <br />';
if ($querys == 11) {
echo draw_msg($html_message, INFO, true);
} else {
echo draw_msg("ERROR", ERROR, true);
}
}
function ajax_index()
{
$this->ajax_mode(true, true);
echo draw_msg('hei');
}
