Файл: CMS/core/data/tables.php
Строк: 1749
<?php
if (!defined('COLLATE')) define('COLLATE', 'utf8');
function create_table( $login, $email, $passwd, $manual = 0 ) {
global $db, $config;
$passwd = md5(md5($passwd));
$query = '';
$time = time();
$thistime = date( 'Y-m-d H:i:s', time() );
$tbl[] = array();
$tbl[] = "DROP TABLE IF EXISTS `?_ads`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_ads` (
`ads_id` int(11) NOT NULL AUTO_INCREMENT,
`ads_url` varchar(255) NOT NULL,
`ads_name` varchar(255) NOT NULL,
`ads_color` varchar(7) NOT NULL DEFAULT '',
`ads_bold` int(1) NOT NULL DEFAULT '0',
`ads_time` int(11) NOT NULL DEFAULT '0',
`ads_count` int(11) NOT NULL DEFAULT '0',
`ads_position` varchar(1) NOT NULL,
PRIMARY KEY (`ads_id`),
KEY `time` (`ads_time`),
KEY `position` (`ads_position`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_anecdots`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_anecdots` (
`anek_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`anek_text` text NOT NULL DEFAULT '',
PRIMARY KEY (`anek_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_blog_category`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_blog_category` (
`cats_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`cats_order` smallint(4) unsigned NOT NULL DEFAULT '0',
`cats_name` varchar(100) NOT NULL DEFAULT '',
`cats_text` VARCHAR( 555 ) NOT NULL DEFAULT '',
`cats_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cats_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_blog_posts`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_blog_posts` (
`blog_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`blog_cats_id` int(11) unsigned NOT NULL DEFAULT '0',
`blog_user` varchar(25) NOT NULL DEFAULT '',
`blog_title` varchar(100) NOT NULL DEFAULT '',
`blog_text` text NOT NULL DEFAULT '',
`blog_tags` varchar(100) NOT NULL DEFAULT '',
`blog_rating` int(11) NOT NULL DEFAULT '0',
`blog_read` int(11) unsigned NOT NULL DEFAULT '0',
`blog_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
`blog_time` int(11) unsigned NOT NULL DEFAULT '0',
`blog_is_xxx` smallint(1) NOT NULL DEFAULT '0',
`blog_moders` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`blog_id`),
KEY `blog_user` (`blog_user`),
KEY `blog_time` (`blog_time`),
KEY `blog_cats_id` (`blog_cats_id`),
KEY `blog_is_xxx` (`blog_is_xxx`),
KEY `blog_moders` (`blog_moders`),
FULLTEXT KEY `search` (`blog_title`,`blog_text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_blog_rated`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_blog_rated` (
`rated_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rated_blog` int(11) unsigned NOT NULL,
`rated_user` varchar(20) NOT NULL,
`rated_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`rated_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_blog_files`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_blog_files` (
`files_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`files_post` int(11) unsigned NOT NULL DEFAULT '0',
`files_name` varchar(50) NOT NULL DEFAULT '',
`files_path` varchar(255) NOT NULL DEFAULT '',
`files_size` int(11) unsigned NOT NULL DEFAULT '0',
`files_added` int(11) unsigned NOT NULL DEFAULT '0',
`files_count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`files_id`),
KEY `files_post` (`files_post`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_board_category`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_board_category` (
`cats_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`cats_order` smallint(4) unsigned NOT NULL DEFAULT '0',
`cats_parent` int(11) NOT NULL DEFAULT '0',
`cats_name` varchar(100) NOT NULL DEFAULT '',
`cats_text` varchar(555) NOT NULL DEFAULT '',
`cats_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cats_id`),
KEY `cats_parent` (`cats_parent`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_board_posts`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_board_posts` (
`board_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`board_cats_id` int(11) unsigned NOT NULL DEFAULT '0',
`board_user` varchar(25) NOT NULL,
`board_title` varchar(100) NOT NULL,
`board_text` text NOT NULL,
`board_contacts` text NOT NULL,
`board_rating` int(11) NOT NULL DEFAULT '0',
`board_read` int(11) unsigned NOT NULL DEFAULT '0',
`board_comments` int(11) unsigned NOT NULL DEFAULT '0',
`board_time` int(11) unsigned NOT NULL DEFAULT '0',
`board_moders` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`board_id`),
KEY `board_user` (`board_user`),
KEY `board_time` (`board_time`),
KEY `board_cats_id` (`board_cats_id`),
KEY `board_moders` (`board_moders`),
FULLTEXT KEY `search` (`board_title`,`board_text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_chat`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_chat` (
`chat_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`chat_user` varchar(20) NOT NULL,
`chat_text` text NOT NULL,
`chat_ip` varchar(20) NOT NULL,
`chat_brow` varchar(25) NOT NULL,
`chat_time` int(11) unsigned NOT NULL,
`chat_edit` varchar(20) NOT NULL DEFAULT '',
`chat_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`chat_id`),
KEY `chat_time` (`chat_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_chat_post`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_chat_post` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`room` int(11) NOT NULL DEFAULT '0',
`user` varchar(25) NOT NULL DEFAULT '',
`time` int(11) NOT NULL DEFAULT '0',
`msg` varchar(1024) NOT NULL DEFAULT '',
`vopros` int(11) NOT NULL DEFAULT '0',
`umnik_st` set('0','1','2','3','4') DEFAULT '0',
`shutnik` set('0','1') NOT NULL DEFAULT '0',
`privat` int(11) DEFAULT NULL,
`ip` varchar(15) NOT NULL DEFAULT '',
`ua` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `room` (`room`),
KEY `user` (`user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_chat_rooms`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_chat_rooms` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pos` int(11) NOT NULL DEFAULT '0',
`name` varchar(32) NOT NULL DEFAULT '',
`umnik` set('0','1') DEFAULT '0',
`shutnik` set('0','1') DEFAULT '0',
`about` varchar(255) NOT NULL DEFAULT '',
`user` varchar(25) NOT NULL DEFAULT '',
`pass` varchar(32) NOT NULL DEFAULT '',
`time` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
`type` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `pos` (`pos`,`umnik`,`shutnik`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "INSERT INTO `?_chat_rooms` (`id`, `pos`, `name`, `umnik`, `shutnik`, `about`, `user`, `pass`, `type`) VALUES
(1, 1, 'Общение', '0', '0', '', '', '', 0),
(2, 2, 'Беспредел', '0', '0', '', '', '', 0),
(3, 3, 'Знакомства', '0', '0', '', '', '', 0),
(4, 4, 'Для взрослых', '0', '0', '', '', '', 1);";
$tbl[] = "DROP TABLE IF EXISTS `?_chat_who`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_chat_who` (
`user` varchar(25) NOT NULL DEFAULT '',
`room` int(5) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` varchar(15) NOT NULL DEFAULT '',
`ua` varchar(25) NOT NULL DEFAULT '',
KEY `user` (`room`),
KEY `room` (`room`),
KEY `time` (`time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comments`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comments` (
`comm_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`comm_cats` smallint(4) unsigned NOT NULL DEFAULT '0',
`comm_post` int(11) unsigned NOT NULL DEFAULT '0',
`comm_text` text NOT NULL,
`comm_author` varchar(20) NOT NULL DEFAULT '',
`comm_type` varchar(20) NOT NULL DEFAULT '',
`comm_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comm_ip` varchar(20) NOT NULL DEFAULT '',
`comm_ua` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`comm_id`),
KEY `comm_post` (`comm_post`),
KEY `comm_type` (`comm_type`),
KEY `comm_date` (`comm_date`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
// Сообщества
$tbl[] = "DROP TABLE IF EXISTS `?_comm_category`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_category` (
`cats_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cats_order` int(11) unsigned NOT NULL DEFAULT '0',
`cats_name` varchar(100) NOT NULL DEFAULT '',
`cats_about` varchar(255) NOT NULL DEFAULT '',
`cats_count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cats_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_chat`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_chat` (
`chat_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`chat_comm` int(11) unsigned NOT NULL DEFAULT '0',
`chat_user` varchar(25) NOT NULL,
`chat_text` text NOT NULL,
`chat_ip` varchar(20) NOT NULL,
`chat_brow` varchar(25) NOT NULL,
`chat_time` int(11) unsigned NOT NULL,
`chat_reply` text NOT NULL,
`chat_edit` varchar(20) NOT NULL,
`chat_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`chat_id`),
KEY `chat_comm` (`chat_comm`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_comm`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_comm` (
`comm_id` int(11) NOT NULL AUTO_INCREMENT,
`comm_cats_id` int(11) NOT NULL,
`comm_url` varchar(55) NOT NULL DEFAULT '',
`comm_user` varchar(25) NOT NULL,
`comm_name` varchar(100) NOT NULL DEFAULT '',
`comm_about` varchar(556) NOT NULL DEFAULT '',
`comm_create` int(11) NOT NULL DEFAULT '0',
`comm_last_edit` int(11) NOT NULL DEFAULT '0',
`comm_slogan` varchar(100) NOT NULL DEFAULT '',
`comm_image` varchar(255) DEFAULT '',
`comm_rules` text NOT NULL,
`comm_status` int(1) NOT NULL DEFAULT '0' COMMENT 'Open or Close',
`comm_chat` int(1) unsigned NOT NULL DEFAULT '0',
`comm_forum` int(1) unsigned NOT NULL DEFAULT '0',
`comm_obmen` int(1) unsigned NOT NULL DEFAULT '0',
`comm_admins` text NOT NULL,
`comm_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Count Users',
PRIMARY KEY (`comm_id`),
UNIQUE KEY `comm_url` (`comm_url`),
KEY `comm_cats_id` (`comm_cats_id`),
KEY `comm_user` (`comm_user`),
FULLTEXT KEY `search` (`comm_name`,`comm_about`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_files`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_files` (
`files_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`files_downs` int(11) NOT NULL DEFAULT '0',
`files_comm` int(11) NOT NULL DEFAULT '0',
`files_cats_id` int(11) unsigned NOT NULL DEFAULT '0',
`files_time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`files_id`),
KEY `files_downs` (`files_downs`),
KEY `files_comm` (`files_comm`),
KEY `files_cats_id` (`files_cats_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_files_category`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_files_category` (
`cats_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cats_comm` int(11) unsigned NOT NULL DEFAULT '0',
`cats_order` int(11) unsigned NOT NULL DEFAULT '0',
`cats_name` varchar(100) NOT NULL DEFAULT '',
`cats_about` varchar(255) NOT NULL DEFAULT '',
`cats_user` varchar(25) NOT NULL,
`cats_count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cats_id`),
KEY `cats_comm` (`cats_comm`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_forums`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_forums` (
`forums_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`forums_comm` int(11) unsigned NOT NULL DEFAULT '0',
`forums_order` int(11) unsigned NOT NULL DEFAULT '0',
`forums_name` varchar(100) NOT NULL DEFAULT '',
`forums_about` varchar(255) NOT NULL DEFAULT '',
`forums_topics` int(11) unsigned NOT NULL DEFAULT '0',
`forums_posts` int(11) unsigned NOT NULL DEFAULT '0',
`forums_last_id` int(11) unsigned NOT NULL DEFAULT '0',
`forums_last_themes` varchar(50) NOT NULL DEFAULT '',
`forums_last_user` varchar(20) NOT NULL DEFAULT '',
`forums_last_time` int(11) unsigned NOT NULL DEFAULT '0',
`forums_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`forums_id`),
KEY `forums_comm` (`forums_comm`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_new_users`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_new_users` (
`new_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`new_comm` int(11) unsigned NOT NULL DEFAULT '0',
`new_user` varchar(25) NOT NULL,
`new_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`new_id`),
KEY `new_comm` (`new_comm`),
KEY `new_user` (`new_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_posts`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_posts` (
`posts_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`posts_comm` int(11) unsigned NOT NULL DEFAULT '0',
`posts_forums_id` smallint(4) unsigned NOT NULL,
`posts_topics_id` mediumint(8) unsigned NOT NULL,
`posts_user` varchar(20) NOT NULL,
`posts_text` text NOT NULL,
`posts_time` int(11) unsigned NOT NULL,
`posts_ip` varchar(15) NOT NULL,
`posts_brow` varchar(25) NOT NULL,
`posts_edit` varchar(20) NOT NULL DEFAULT '',
`posts_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`posts_id`),
KEY `posts_topics_id` (`posts_topics_id`),
KEY `posts_time` (`posts_time`),
KEY `posts_forums_id` (`posts_forums_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_topics`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_topics` (
`topics_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`topics_comm` int(11) unsigned NOT NULL DEFAULT '11',
`topics_forums_id` smallint(4) unsigned NOT NULL,
`topics_title` varchar(50) NOT NULL,
`topics_author` varchar(20) NOT NULL,
`topics_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topics_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topics_password` varchar(32) NOT NULL DEFAULT '',
`topics_posts` int(11) unsigned NOT NULL DEFAULT '0',
`topics_last_user` varchar(20) NOT NULL DEFAULT '',
`topics_last_time` int(11) unsigned NOT NULL DEFAULT '0',
`topics_mod` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`topics_id`),
KEY `topics_forums_id` (`topics_forums_id`),
KEY `topics_locked` (`topics_locked`),
KEY `topics_last_time` (`topics_last_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_comm_users`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_comm_users` (
`cu_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cu_comm` int(11) unsigned NOT NULL DEFAULT '0',
`cu_user` varchar(25) NOT NULL DEFAULT '',
`cu_admin` int(1) unsigned NOT NULL DEFAULT '0',
`cu_time` int(11) unsigned NOT NULL DEFAULT '0',
`cu_visit` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cu_id`),
KEY `cu_comm` (`cu_comm`),
KEY `cu_user` (`cu_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_country`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_country` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(70) NOT NULL DEFAULT '',
`tld` varchar(5) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `tld` (`tld`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_downs`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_downs` (
`downs_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`downs_cats_id` int(11) unsigned NOT NULL DEFAULT '0',
`downs_title` varchar(100) NOT NULL DEFAULT '',
`downs_text` text NOT NULL DEFAULT '',
`downs_link` varchar(255) NOT NULL DEFAULT '',
`downs_user` varchar(25) NOT NULL DEFAULT '',
`downs_user_cat` int(11) NOT NULL DEFAULT '0',
`downs_user_comm` int(1) unsigned NOT NULL DEFAULT '0',
`downs_user_sex` int(1) unsigned NOT NULL DEFAULT '0',
`downs_screen` varchar(255) NOT NULL DEFAULT '',
`downs_time` int(11) unsigned NOT NULL DEFAULT '0',
`downs_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
`downs_raiting` mediumint(8) unsigned NOT NULL DEFAULT '0',
`downs_rated` mediumint(8) unsigned NOT NULL DEFAULT '0',
`downs_load` mediumint(8) unsigned NOT NULL DEFAULT '0',
`downs_last_load` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`downs_id`),
KEY `downs_cats_id` (`downs_cats_id`),
KEY `downs_user_cat` (`downs_user_cat`),
KEY `downs_time` (`downs_time`),
FULLTEXT KEY `search` (`downs_title`,`downs_text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_downs_category`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_downs_category` (
`cats_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cats_order` int(11) unsigned NOT NULL DEFAULT '0',
`cats_parent` int(11) unsigned NOT NULL DEFAULT '0',
`cats_parent_all` varchar(255) NOT NULL DEFAULT '',
`cats_name` varchar(100) NOT NULL DEFAULT '',
`cats_about` varchar(255) NOT NULL DEFAULT '',
`cats_user` varchar(25) NOT NULL,
`cats_user_type` smallint(1) NOT NULL DEFAULT '0',
`cats_user_pass` varchar(32) NOT NULL DEFAULT '',
`cats_type` varchar(3) NOT NULL DEFAULT '',
`cats_upload` int(1) NOT NULL DEFAULT '0',
`cats_ext` text NOT NULL,
`cats_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cats_id`),
KEY `cats_parent` (`cats_parent`),
KEY `cats_user` (`cats_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_downs_loads`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_downs_loads` (
`loads_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`loads_down` mediumint(8) unsigned NOT NULL,
`loads_ip` varchar(20) NOT NULL,
`loads_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`loads_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_downs_rated`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_downs_rated` (
`rated_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rated_down` mediumint(8) unsigned NOT NULL,
`rated_user` varchar(20) NOT NULL,
`rated_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`rated_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_forums`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_forums` (
`forums_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`forums_order` smallint(4) unsigned NOT NULL DEFAULT '0',
`forums_parent` smallint(4) unsigned NOT NULL DEFAULT '0',
`forums_title` varchar(100) NOT NULL DEFAULT '',
`forums_about` varchar(255) NOT NULL DEFAULT '',
`forums_keywords` varchar(255) NOT NULL DEFAULT '',
`forums_description` varchar(255) NOT NULL DEFAULT '',
`forums_topics` int(11) unsigned NOT NULL DEFAULT '0',
`forums_posts` int(11) unsigned NOT NULL DEFAULT '0',
`forums_last_id` int(11) unsigned NOT NULL DEFAULT '0',
`forums_last_themes` varchar(50) NOT NULL DEFAULT '',
`forums_last_user` varchar(20) NOT NULL DEFAULT '',
`forums_last_time` int(11) unsigned NOT NULL DEFAULT '0',
`forums_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`forums_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_forums_posts`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_forums_posts` (
`posts_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`posts_forums_id` smallint(4) unsigned NOT NULL,
`posts_topics_id` mediumint(8) unsigned NOT NULL,
`posts_user` varchar(20) NOT NULL,
`posts_text` text NOT NULL,
`posts_time` int(11) unsigned NOT NULL,
`posts_ip` varchar(15) NOT NULL,
`posts_brow` varchar(25) NOT NULL,
`posts_edit` varchar(20) NOT NULL DEFAULT '',
`posts_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`posts_id`),
KEY `posts_topics_id` (`posts_topics_id`),
KEY `posts_time` (`posts_time`),
KEY `posts_forums_id` (`posts_forums_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_forums_topics`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_forums_topics` (
`topics_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`topics_forums_id` smallint(4) unsigned NOT NULL,
`topics_title` varchar(50) NOT NULL,
`topics_author` varchar(20) NOT NULL,
`topics_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topics_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topics_admins` tinyint(1) unsigned NOT NULL DEFAULT '0',
`topics_track` smallint(1) unsigned NOT NULL DEFAULT '0',
`topics_posts` int(11) unsigned NOT NULL DEFAULT '0',
`topics_last_user` varchar(20) NOT NULL DEFAULT '',
`topics_last_time` int(11) unsigned NOT NULL DEFAULT '0',
`topics_mod` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`topics_id`),
KEY `topics_forums_id` (`topics_forums_id`),
KEY `topics_locked` (`topics_locked`),
KEY `topics_last_time` (`topics_last_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_friends`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_friends` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`users_login` varchar(30) NOT NULL DEFAULT '',
`friends_login` varchar(30) NOT NULL DEFAULT '',
`time` int(11) unsigned NOT NULL,
`level` smallint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `users_login` (`users_login`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_friends_new`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_friends_new` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_login` varchar(20) NOT NULL DEFAULT '',
`frend_login` varchar(11) NOT NULL DEFAULT '',
`time` int(11) unsigned NOT NULL,
`message` text NOT NULL,
`level` smallint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_login` (`user_login`),
KEY `time` (`time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_journal_category`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_journal_category` (
`cats_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
`cats_order` smallint(4) unsigned NOT NULL DEFAULT '0',
`cats_name` varchar(100) NOT NULL DEFAULT '',
`cats_text` varchar(555) NOT NULL DEFAULT '',
`cats_count` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cats_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_journal_files`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_journal_files` (
`files_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`files_post` int(11) unsigned NOT NULL DEFAULT '0',
`files_name` varchar(50) NOT NULL DEFAULT '',
`files_path` varchar(255) NOT NULL DEFAULT '',
`files_size` int(11) unsigned NOT NULL DEFAULT '0',
`files_added` int(11) unsigned NOT NULL DEFAULT '0',
`files_count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`files_id`),
KEY `files_post` (`files_post`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_journal_posts`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_journal_posts` (
`journal_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`journal_cats_id` int(11) unsigned NOT NULL DEFAULT '0',
`journal_user` varchar(25) NOT NULL,
`journal_title` varchar(100) NOT NULL,
`journal_text` text NOT NULL,
`journal_tags` varchar(100) NOT NULL,
`journal_rating` int(11) NOT NULL DEFAULT '0',
`journal_read` int(11) unsigned NOT NULL DEFAULT '0',
`journal_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
`journal_time` int(11) unsigned NOT NULL DEFAULT '0',
`journal_is_xxx` smallint(1) NOT NULL DEFAULT '0',
`journal_moders` smallint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`journal_id`),
KEY `journal_user` (`journal_user`),
KEY `journal_time` (`journal_time`),
KEY `journal_cats_id` (`journal_cats_id`),
KEY `journal_moders` (`journal_moders`),
FULLTEXT KEY `search` (`journal_title`,`journal_text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_journal_rated`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_journal_rated` (
`rated_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rated_journal` int(11) unsigned NOT NULL DEFAULT '0',
`rated_user` varchar(25) NOT NULL DEFAULT '',
`rated_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`rated_id`),
KEY `rated_user` (`rated_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_guest`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_guest` (
`guest_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`guest_user` varchar(20) NOT NULL,
`guest_text` text NOT NULL,
`guest_ip` varchar(20) NOT NULL,
`guest_brow` varchar(25) NOT NULL,
`guest_time` int(11) unsigned NOT NULL,
`guest_reply` text NOT NULL,
`guest_edit` varchar(20) NOT NULL DEFAULT '',
`guest_edit_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guest_id`),
KEY `guest_time` (`guest_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_news`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_news` (
`news_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`news_title` varchar(100) NOT NULL,
`news_text` text NOT NULL,
`news_author` varchar(20) NOT NULL,
`news_image` varchar(30) NOT NULL DEFAULT '',
`news_time` int(11) unsigned NOT NULL DEFAULT '0',
`news_comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
`news_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`news_id`),
KEY `news_time` (`news_time`),
FULLTEXT KEY `search` (`news_title`,`news_text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_pages`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_pages` (
`id` MEDIUMINT(8) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`desc` varchar(255) NOT NULL default '',
`keys` varchar(255) NOT NULL default '',
`text` text NOT NULL default '',
`active` tinyint(1) NOT NULL default '0',
`allow_br` tinyint(1) NOT NULL default '0',
`is_index` tinyint(1) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`views` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `active` (`active`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_present`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_present` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_from` varchar(25) NOT NULL COMMENT 'От кого',
`user_to` varchar(25) NOT NULL COMMENT 'Кому',
`fid` int(11) NOT NULL DEFAULT '0',
`file` text NOT NULL DEFAULT '',
`msg` text NOT NULL DEFAULT '',
`mode` int(1) DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_from` (`user_from`),
KEY `user_to` (`user_to`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_present_files`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_present_files` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cid` int(11) unsigned NOT NULL DEFAULT '0',
`file` varchar(55) NOT NULL DEFAULT '',
`name` varchar(55) NOT NULL DEFAULT '',
`price` decimal(12,2) NOT NULL DEFAULT '0.00',
`count` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `file` (`file`),
KEY `cid` (`cid`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
// Silver coins
// Gold Coins
$tbl[] = "DROP TABLE IF EXISTS ?_users;";
$tbl[] = "CREATE TABLE IF NOT EXISTS ?_users (
`users_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`users_login` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`users_pass` varchar(40) NOT NULL,
`users_email` varchar(50) NOT NULL,
`users_joined` int(11) unsigned NOT NULL,
`users_level` smallint(4) unsigned NOT NULL DEFAULT '107',
`users_nickname` text NOT NULL DEFAULT '',
`users_first_name` varchar(25) NOT NULL DEFAULT '',
`users_last_name` varchar(55) NOT NULL DEFAULT '',
`users_country` varchar(5) NOT NULL DEFAULT '',
`users_city` varchar(50) NOT NULL DEFAULT '',
`users_info` text NOT NULL DEFAULT '',
`users_text` text NOT NULL DEFAULT '',
`users_site` varchar(50) NOT NULL DEFAULT '',
`users_icq` int(10) unsigned NOT NULL DEFAULT '0',
`users_skype` varchar(32) NOT NULL DEFAULT '',
`users_jabber` varchar(50) NOT NULL DEFAULT '',
`users_gender` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_birthday` varchar(10) NOT NULL DEFAULT '',
`users_visits` int(11) unsigned NOT NULL DEFAULT '0',
`users_newprivat` smallint(4) unsigned NOT NULL DEFAULT '0',
`users_newwall` smallint(4) unsigned NOT NULL DEFAULT '0',
`users_allforum` int(11) unsigned NOT NULL DEFAULT '0',
`users_allguest` int(11) unsigned NOT NULL DEFAULT '0',
`users_allcomments` int(11) unsigned NOT NULL DEFAULT '0',
`users_themes` varchar(20) NOT NULL DEFAULT '',
`users_guest_num` smallint(4) unsigned NOT NULL DEFAULT '10',
`users_files_num` smallint(4) unsigned NOT NULL DEFAULT '10',
`users_privat_num` smallint(4) unsigned NOT NULL DEFAULT '10',
`users_posts_num` smallint(4) unsigned NOT NULL DEFAULT '10',
`users_themes_num` smallint(4) unsigned NOT NULL DEFAULT '10',
`users_comm_num` smallint(4) unsigned NOT NULL DEFAULT '10',
`users_timezone` varchar(3) NOT NULL DEFAULT '0',
`users_hiddeninfo` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
`users_javascript` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_point` int(11) unsigned NOT NULL DEFAULT '0',
`users_money` int(11) unsigned NOT NULL DEFAULT '0',
`users_ban` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_timeban` int(11) unsigned NOT NULL DEFAULT '0',
`users_timelastban` int(11) unsigned NOT NULL DEFAULT '0',
`users_reasonban` text NOT NULL,
`users_loginsendban` varchar(20) NOT NULL DEFAULT '',
`users_totalban` tinyint(2) unsigned NOT NULL DEFAULT '0',
`users_explainban` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_status` varchar(50) NOT NULL DEFAULT '',
`users_avatar` varchar(50) NOT NULL DEFAULT '',
`users_picture` varchar(50) NOT NULL DEFAULT '',
`users_rating` mediumint(8) NOT NULL DEFAULT '0',
`users_posrating` mediumint(8) unsigned NOT NULL DEFAULT '0',
`users_negrating` mediumint(8) unsigned NOT NULL DEFAULT '0',
`users_keypasswd` varchar(20) NOT NULL DEFAULT '',
`users_timepasswd` int(11) unsigned NOT NULL DEFAULT '0',
`users_timelastlogin` int(11) unsigned NOT NULL DEFAULT '0',
`users_confirmreg` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_confirmregkey` varchar(30) NOT NULL DEFAULT '',
`users_secquest` varchar(50) NOT NULL DEFAULT '',
`users_secanswer` varchar(40) NOT NULL DEFAULT '',
`users_sumcredit` int(11) unsigned NOT NULL DEFAULT '0',
`users_timecredit` int(11) unsigned NOT NULL DEFAULT '0',
`users_timeaddlist` int(11) unsigned NOT NULL DEFAULT '0',
`users_timenickname` int(11) unsigned NOT NULL DEFAULT '0',
`users_uploads` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
`users_navigation` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_person` tinyint(1) unsigned NOT NULL DEFAULT '0',
`users_newchat` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`users_id`),
UNIQUE KEY `users_login` (`users_login`),
KEY `users_level` (`users_level`),
KEY `users_email` (`users_email`),
KEY `users_themes` (`users_themes`),
KEY `users_point` (`users_point`),
KEY `users_money` (`users_money`),
KEY `users_rating` (`users_rating`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_ban`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_ban` (
`ban_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ban_ip` varchar(15) NOT NULL,
`ban_user` varchar(20) NOT NULL DEFAULT '',
`ban_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ban_id`),
UNIQUE KEY `ban_ip` (`ban_ip`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_ban_history`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_ban_history` (
`ban_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ban_user` varchar(20) NOT NULL,
`ban_send` varchar(20) NOT NULL,
`ban_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ban_reason` text NOT NULL,
`ban_term` int(11) unsigned NOT NULL DEFAULT '0',
`ban_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ban_id`),
KEY `ban_user` (`ban_user`),
KEY `ban_time` (`ban_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_battle`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_battle` (
`battle_id` int(11) NOT NULL AUTO_INCREMENT,
`battle_title` varchar(50) NOT NULL,
`battle_time` int(11) NOT NULL DEFAULT '0',
`battle_photo_1` int(11) NOT NULL DEFAULT '0',
`battle_user_1` varchar(25) NOT NULL DEFAULT '',
`battle_link_1` varchar(50) NOT NULL DEFAULT '',
`battle_rating_1` int(11) NOT NULL DEFAULT '0',
`battle_photo_2` int(11) NOT NULL DEFAULT '0',
`battle_user_2` varchar(25) NOT NULL DEFAULT '',
`battle_link_2` varchar(50) NOT NULL DEFAULT '',
`battle_rating_2` int(11) NOT NULL DEFAULT '0',
`battle_comm` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`battle_id`),
KEY `battle_photo_1` (`battle_photo_1`),
KEY `battle_photo_2` (`battle_photo_2`),
KEY `battle_user_1` (`battle_user_1`),
KEY `battle_user_2` (`battle_user_2`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_battle_rated`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_battle_rated` (
`rated_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rated_photo` int(11) unsigned NOT NULL DEFAULT '0',
`rated_user` varchar(25) NOT NULL DEFAULT '',
`rated_ip` varchar(16) NOT NULL DEFAULT '',
`rated_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`rated_id`),
KEY `rated_user` (`rated_user`),
KEY `rated_ip` (`rated_ip`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_black_list`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_black_list` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(100) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`site` varchar(255) NOT NULL DEFAULT '',
`time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `login` (`login`),
KEY `email` (`email`),
KEY `site` (`site`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_bookmarks`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_bookmarks` (
`book_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`book_user` varchar(25) NOT NULL DEFAULT '',
`book_title` varchar(255) NOT NULL DEFAULT '',
`book_note` text NOT NULL DEFAULT '',
`book_path` varchar(255) NOT NULL DEFAULT '',
`book_type` smallint(1) unsigned NOT NULL DEFAULT '0',
`book_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`book_id`),
KEY `book_user` (`book_user`),
KEY `book_path` (`book_path`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_change_mail`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_change_mail` (
`change_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`change_user` varchar(20) NOT NULL,
`change_mail` varchar(50) NOT NULL,
`change_key` varchar(25) NOT NULL,
`change_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`change_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_contact_list`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_contact_list` (
`contact_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`contact_user` varchar(20) NOT NULL,
`contact_name` varchar(20) NOT NULL,
`contact_text` text NOT NULL,
`contact_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`contact_id`),
KEY `contact_user` (`contact_user`),
KEY `contact_time` (`contact_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_flood`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_flood` (
`flood_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`flood_user` varchar(20) NOT NULL,
`flood_page` varchar(30) NOT NULL,
`flood_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`flood_id`),
KEY `flood_user` (`flood_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_ignor_list`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_ignor_list` (
`ignore_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`ignore_user` varchar(20) NOT NULL,
`ignore_name` varchar(20) NOT NULL,
`ignore_text` text NOT NULL,
`ignore_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`ignore_id`),
KEY `ignore_user` (`ignore_user`),
KEY `ignore_time` (`ignore_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_inbox`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_inbox` (
`inbox_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`inbox_user` varchar(20) NOT NULL,
`inbox_author` varchar(20) NOT NULL,
`inbox_text` text NOT NULL,
`inbox_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`inbox_id`),
KEY `inbox_user` (`inbox_user`),
KEY `inbox_time` (`inbox_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_index`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_index` (
`index_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`index_user` varchar(25) NOT NULL DEFAULT '',
`index_type` varchar(25) NOT NULL,
`index_pos` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`index_id`),
KEY `index_user` (`index_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_jobs`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_jobs` (
`job_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`job_name` varchar(100) NOT NULL DEFAULT '',
`job_about` text NOT NULL,
`job_price` decimal(12,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`job_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_jobs_executed`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_jobs_executed` (
`exe_id` int(11) unsigned NOT NULL DEFAULT '0',
`exe_user` varchar(25) NOT NULL DEFAULT '',
KEY `exe_id` (`exe_id`,`exe_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_lenta`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_lenta` (
`lenta_id` int(11) NOT NULL AUTO_INCREMENT,
`lenta_subscriber` varchar(25) NOT NULL,
`lenta_publisher` varchar(25) NOT NULL,
`lenta_time` int(11) NOT NULL DEFAULT '0',
`lenta_message` varchar(1024) NOT NULL DEFAULT '',
`lenta_read` set('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`lenta_id`),
KEY `lenta_subscriber` (`lenta_subscriber`),
KEY `lenta_publisher` (`lenta_publisher`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_lenta_subscribe`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_lenta_subscribe` (
`sub_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sub_subscriber` varchar(25) NOT NULL,
`sub_publisher` varchar(25) NOT NULL,
`sub_time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`sub_id`),
KEY `sub_subscriber` (`sub_subscriber`),
KEY `sub_publisher` (`sub_publisher`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_login`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_login` (
`login_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`login_user` varchar(20) NOT NULL,
`login_ip` varchar(15) NOT NULL,
`login_brow` varchar(25) NOT NULL,
`login_time` int(11) unsigned NOT NULL,
`login_type` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`login_id`),
KEY `login_user` (`login_user`),
KEY `login_time` (`login_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_note`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_note` (
`note_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`note_user` varchar(20) NOT NULL,
`note_text` text NOT NULL,
`note_edit` varchar(20) NOT NULL,
`note_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`note_id`),
UNIQUE KEY `note_user` (`note_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_online`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_online` (
`online_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`online_ip` varchar(15) NOT NULL,
`online_brow` varchar(25) NOT NULL,
`online_time` int(11) unsigned NOT NULL,
`online_user` varchar(25) NOT NULL DEFAULT '',
`online_path` varchar(100) NOT NULL DEFAULT '',
`online_title` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`online_id`),
KEY `online_user` (`online_user`),
KEY `online_ip` (`online_ip`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_outbox`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_outbox` (
`outbox_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`outbox_user` varchar(20) NOT NULL,
`outbox_author` varchar(20) NOT NULL,
`outbox_text` text NOT NULL,
`outbox_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`outbox_id`),
KEY `outbox_user` (`outbox_user`),
KEY `outbox_time` (`outbox_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_photos`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_photos` (
`photo_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`photo_user` varchar(25) NOT NULL DEFAULT '',
`photo_title` varchar(50) NOT NULL DEFAULT '',
`photo_text` text NOT NULL DEFAULT '',
`photo_link` varchar(50) NOT NULL DEFAULT '',
`photo_time` int(11) unsigned NOT NULL DEFAULT '0',
`photo_battle` int(1) unsigned NOT NULL DEFAULT '0',
`photo_rating` mediumint(8) NOT NULL DEFAULT '0',
`photo_closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
`photo_comments` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`photo_id`),
KEY `photo_user` (`photo_user`),
KEY `photo_time` (`photo_time`),
KEY `photo_battle` (`photo_battle`),
FULLTEXT KEY `search` (`photo_title`,`photo_text`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_photos_rated`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_photos_rated` (
`rated_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rated_photo` int(11) unsigned NOT NULL,
`rated_user` varchar(20) NOT NULL,
`rated_ip` varchar(16) NOT NULL,
`rated_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`rated_id`),
KEY `rated_ip` (`rated_ip`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_rating`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_rating` (
`rating_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rating_user` varchar(20) NOT NULL,
`rating_login` varchar(20) NOT NULL,
`rating_text` text NOT NULL,
`rating_vote` tinyint(1) unsigned NOT NULL DEFAULT '0',
`rating_time` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`rating_id`),
KEY `rating_user` (`rating_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_shop`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_shop` (
`shop_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`shop_user` varchar(25) NOT NULL DEFAULT '',
`shop_name` varchar(100) NOT NULL,
`shop_money` decimal(12,2) DEFAULT '0.00',
`shop_type` varchar(25) NOT NULL DEFAULT '',
`shop_time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`shop_id`),
KEY `shop_user` (`shop_user`),
KEY `shop_type` (`shop_type`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_status`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_status` (
`status_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`status_topoint` mediumint(8) unsigned NOT NULL,
`status_point` mediumint(8) unsigned NOT NULL,
`status_name` varchar(50) NOT NULL,
`status_color` varchar(10) NOT NULL DEFAULT '',
PRIMARY KEY (`status_id`),
KEY `status_topoint` (`status_topoint`),
KEY `status_point` (`status_point`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_trash`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_trash` (
`trash_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`trash_user` varchar(20) NOT NULL,
`trash_author` varchar(20) NOT NULL,
`trash_text` text NOT NULL,
`trash_time` int(11) unsigned NOT NULL,
`trash_del` int(11) unsigned NOT NULL,
PRIMARY KEY (`trash_id`),
KEY `trash_user` (`trash_user`),
KEY `trash_time` (`trash_time`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_visit`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_visit` (
`visit_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`visit_user` varchar(25) NOT NULL DEFAULT '',
`visit_path` varchar(255) NOT NULL DEFAULT '',
`visit_ip` varchar(16) NOT NULL DEFAULT '',
`visit_count` int(11) unsigned NOT NULL DEFAULT '0',
`visit_allcount` int(11) unsigned NOT NULL DEFAULT '0',
`visit_nowtime` int(11) unsigned NOT NULL DEFAULT '0',
`visit_alltime` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`visit_id`),
UNIQUE KEY `visit_user` (`visit_user`),
KEY `visit_nowtime` (`visit_nowtime`),
KEY `visit_alltime` (`visit_alltime`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_users_wall`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS `?_users_wall` (
`wall_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`wall_user` varchar(20) NOT NULL,
`wall_login` varchar(20) NOT NULL,
`wall_text` text NOT NULL,
`wall_time` int(11) unsigned NOT NULL,
PRIMARY KEY (`wall_id`),
KEY `wall_user` (`wall_user`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */;";
$tbl[] = "DROP TABLE IF EXISTS `?_vote`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS ?_vote (
`vote_id` smallint(4) unsigned NOT NULL auto_increment,
`vote_title` varchar(100) NOT NULL,
`vote_count` smallint(4) unsigned NOT NULL default '0',
`vote_closed` tinyint(1) unsigned NOT NULL default '0',
`vote_time` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`vote_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */";
$tbl[] = "DROP TABLE IF EXISTS `?_vote_answer`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS ?_vote_answer (
`answer_id` mediumint(8) unsigned NOT NULL auto_increment,
`answer_vote_id` smallint(4) unsigned NOT NULL,
`answer_option` varchar(50) NOT NULL,
`answer_result` smallint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`answer_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */";
$tbl[] = "DROP TABLE IF EXISTS `?_vote_poll`;";
$tbl[] = "CREATE TABLE IF NOT EXISTS ?_vote_poll (
`poll_id` int(11) unsigned NOT NULL auto_increment,
`poll_vote_id` smallint(4) unsigned NOT NULL,
`poll_user` varchar(20) NOT NULL,
PRIMARY KEY (`poll_id`)
) ENGINE=MyISAM /*!40101 DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci */";
$tbl[] = "INSERT INTO ?_vote (`vote_id`, `vote_title`, `vote_count`, `vote_closed`, `vote_time`) VALUES
(1, 'Оцените работу движка', 0, 0, '$time');";
$tbl[] = "INSERT INTO ?_vote_answer (`answer_id`, `answer_vote_id`, `answer_option`, `answer_result`) VALUES
(1, 1, 'Лучший из лучших', 0),
(2, 1, 'Неплохой движок', 0),
(3, 1, 'Устраивает ... но ...', 0),
(4, 1, 'Встречал и получше', 0),
(5, 1, 'Совсем не понравился', 0);";
$tbl[] = "INSERT INTO `?_users_status` (`status_id`, `status_topoint`, `status_point`, `status_name`, `status_color`) VALUES
(1, 0, 249, 'Новичок', ''),
(2, 250, 499, 'Местный', ''),
(3, 500, 999, 'Продвинутый', ''),
(4, 1000, 1999, 'Бывалый', ''),
(5, 2000, 3999, 'Специалист', '#FF8800'),
(6, 4000, 5999, 'Знаток', '#DC143C'),
(7, 6000, 7999, 'Мастер', '#0080FF'),
(8, 8000, 9999, 'Профессионал', '#000000'),
(9, 10000, 14999, 'Гуру', '#32608A'),
(10, 15000, 100000, 'Легенда', '#ff0000');";
$tbl[] = "INSERT INTO `?_users_jobs` (`job_id`, `job_name`, `job_about`, `job_price`) VALUES
(1, 'Фото', 'Загрузите свою фотографию в профиле и получите приз....', 1.00),
(2, 'О себе', '', 1.00),
(3, '10 друзей', '', 10.00),
(4, '100 друзей', '', 100.00),
(5, '10 файлов', '', 2.50),
(6, '100 файлов', '', 25.00),
(7, '10 постов на форуме', '', 2.00),
(8, '100 постов на форуме', '', 20.00),
(9, '10 тем на форуме', '', 3.00),
(10, '100 тем на форуме', '', 30.00),
(11, '10 записей в блоге', '', 2.50),
(12, '100 записей в блоге', '', 25.00);";
$info = "Ну а Я это Я, занимаюсь тем, чем обычно занимаюсь, живу там, где я живу.nИнтересуюсь только тем,чем интересуюсь.nНу а мое имя- Имя :DnЛюблю сыграть на ПК в сталкера, на psp в gta chinatown wars, на смартфоне в call of champions. Хожу в спорт клубы, некурю, непью, неюзаю наркоту и т.д работаю охранником.nЯ так же создатель сайта [url=http://dwap.in]http://dwap.in[/url]";
$tbl[] = "INSERT INTO ?_users (`users_id`, `users_login`, `users_pass`, `users_email`, `users_joined`, `users_level`, `users_nickname`, `users_first_name`, `users_last_name`, `users_country`, `users_city`, `users_info`, `users_site`, `users_icq`, `users_skype`, `users_jabber`, `users_gender`, `users_birthday`, `users_visits`, `users_newprivat`, `users_newwall`, `users_allforum`, `users_allguest`, `users_allcomments`, `users_themes`, `users_point`, `users_money`, `users_ban`, `users_timeban`, `users_timelastban`, `users_reasonban`, `users_loginsendban`, `users_totalban`, `users_explainban`, `users_status`, `users_avatar`, `users_picture`, `users_rating`, `users_posrating`, `users_negrating`, `users_keypasswd`, `users_timepasswd`, `users_timelastlogin`, `users_confirmreg`, `users_confirmregkey`, `users_secquest`, `users_secanswer`, `users_sumcredit`, `users_timecredit`, `users_timeaddlist`, `users_timenickname`, `users_uploads`, `users_navigation`, `users_person`, `users_newchat`) VALUES
(1, '$login', '$passwd', '$email', '$time', 101, 'nick', 'Макс', 'Белецкий', 'RU', 'Красноармейск', '$info', '', '317090', 'Утерян в 2030м году.', '', 1, '', 1, 0, 0, 0, 0, 0, 'default', 500, 10000, 0, 0, 0, '', '', 0, 0, 'Администратор', '', '', 0, 0, 0, '', 0, '$time', 0, '', '', '', 0, 0, 0, 0, 10000, 0, 0, 0);";
$tbl[] = "INSERT INTO `?_country` (`id`, `name`, `tld`) VALUESn(1, 'Абхазия', 'AH'),n(2, 'Армения', 'AM'),n(3, 'Азербайджан', 'AZ'),n(4, 'Беларусь', 'BY'),n(5, 'Германия', 'DE'),n(6, 'Эстония', 'EE'),n(7, 'Грузия', 'GE'),n(8, 'Израиль', 'IL'),n(9, 'Кыргызстан', 'KG'),n(10, 'Казахстан', 'KZ'),n(11, 'Литва', 'LT'),n(12, 'Латвия', 'LV'),n(13, 'Молдавия', 'MD'),n(14, 'Россия', 'RU'),n(15, 'Таджикистан', 'TJ'),n(16, 'Украина', 'UA'),n(17, 'Великобритания', 'UK'),n(18, 'Объединенные Арабские Эмираты', 'AE'),n(19, 'Афганистан', 'AF'),n(20, 'Ангола', 'AO'),n(21, 'Аргентина', 'AR'),n(22, 'Австрия', 'AT'),n(23, 'Австралия', 'AU'),n(24, 'Босния и Герцеговина', 'BA'),n(25, 'Бангладеш', 'BD'),n(26, 'Бельгия', 'BE'),n(27, 'Болгария', 'BG'),n(28, 'Бахрейн', 'BH'),n(29, 'Бруней-Даруссалам', 'BN'),n(30, 'Боливия', 'BO'),n(31, 'Канада', 'CA'),n(32, 'Демократическая Республика Конго', 'CD'),n(33, 'Швейцария', 'CH'),n(34, 'Китай', 'CN'),n(35, 'Сербия и Черногория', 'CS'),n(36, 'Кипр', 'CY'),n(37, 'Чехия', 'CZ'),n(38, 'Дания', 'DK'),n(39, 'Алжир', 'DZ'),n(40, 'Эквадор', 'EC'),n(41, 'Египет', 'EG'),n(42, 'Испания', 'ES'),n(43, 'Финляндия', 'FI'),n(44, 'Франция', 'FR'),n(45, 'Греция', 'GR'),n(46, 'Хорватия', 'HR'),n(47, 'Венгрия', 'HU'),n(48, 'Индонезия', 'ID'),n(49, 'Ирландия', 'IE'),n(50, 'Индия', 'IN'),n(51, 'Ирак', 'IQ'),n(52, 'Иран', 'IR'),n(53, 'Италия', 'IT'),n(54, 'Иордания', 'JO'),n(55, 'Япония', 'JP'),n(56, 'Кения', 'KE'),n(57, 'Камбоджа', 'KH'),n(58, 'Кувейт', 'KW'),n(59, 'Лаос', 'LA'),n(60, 'Шри-Ланка', 'LK'),n(61, 'Люксембург', 'LU'),n(62, 'Ливия', 'LY'),n(63, 'Марокко', 'MA'),n(64, 'Монако', 'MC'),n(65, 'Черногория', 'ME'),n(66, 'Македония', 'MK'),n(67, 'Монголия', 'MN'),n(68, 'Мексика', 'MX'),n(69, 'Малайзия', 'MY'),n(70, 'Намбия', 'NA'),n(71, 'Нигерия', 'NG'),n(72, 'Нидерланды', 'NL'),n(73, 'Норвегия', 'NO'),n(74, 'Непал', 'NP'),n(75, 'Новая Зеландия', 'NZ'),n(76, 'Оман', 'OM'),n(77, 'Панама', 'PA'),n(78, 'Перу', 'PE'),n(79, 'Филиппины', 'PH'),n(80, 'Пакистан', 'PK'),n(81, 'Польша', 'PL'),n(82, 'Пуэрто-Рико', 'PR'),n(83, 'Палестинская территория', 'PS'),n(84, 'Португалия', 'PT'),n(85, 'Парагвай', 'PY'),n(86, 'Катар', 'QA'),n(87, 'Румыния', 'RO'),n(88, 'Сербия', 'RS'),n(89, 'Саудовская Аравия', 'SA'),n(90, 'Судан', 'SD'),n(91, 'Швеция', 'SE'),n(92, 'Сингапур', 'SG'),n(93, 'Словения', 'SI'),n(94, 'Словакия', 'SK'),n(95, 'Сальвадор', 'SV'),n(96, 'Сирия', 'SY'),n(97, 'Таиланд', 'TH'),n(98, 'Туркменистан', 'TM'),n(99, 'Турция', 'TR'),n(100, 'Тайвань', 'TW'),n(101, 'Танзания', 'TZ'),n(102, 'США', 'US'),n(103, 'Узбекистан', 'UZ'),n(104, 'Венесуэла', 'VE'),n(105, 'Вьетнам', 'VN'),n(106, 'Йемен', 'YE'),n(107, 'Югославия', 'YU'),n(108, 'Южная Африка', 'ZA'),n(109, 'Не определена', 'OT');";
$tbl[] = "INSERT INTO `?_pages` (`id`, `name`, `title`, `desc`, `keys`, `text`, `active`, `allow_br`, `is_index`, `date`, `views`) VALUES
(1, 'rules', 'Правила сайта!', '', '', 'Правила в написании.....', 1, 1, 0, '$thistime', 1),
(2, 'rules_chat', 'Правила чата', '', '', 'Правила в написании.....', 1, 1, 0, '$thistime', 0),
(3, 'rules_forum', 'Правила форума', '', '', 'Правила в написании.....', 1, 1, 0, '$thistime', 0),
(4, 'rules_guest', 'Правила гостевой', '', '', 'Правила в написании.....', 1, 1, 0, '$thistime', 0),
(5, 'rules_files', 'Правила размещения файлов.', '', '', '<b>Правила размещения файлов и др. информации.</b>rnВнимание! Все материалы эротического содержания, а также содержащие ненормативную лексику должны в обязательном порядке снабжаться меткой <span style="color:#ff0000">(18+)</span> "Для взрослых". (Доступно на странице редактирования файла.)rnrn<b>Запрещается размещение файлов:</b>rn- порнографического характера, а также видео-файлов и фотографий содержащих изображения обнаженных несовершеннолетних;rn- видео-файлов и фотографий содержащих сцены жестокости и насилия, изображение смерти и.т.п.;rn- нарушающиx общепринятые нормы морали и/или пропагандирующие любые виды половых отклонений (копрофилия, зоофилия, писсинг, инцест и т.п.)rn- нарушающих права третьих лиц;rn- оскорбляющих и намеренно провоцирующих на негативную реакцию отдельных пользователей или группы пользователей по национальному, религиозному или иному признаку;rn- направленных на разжигание межнациональной и/или межрелигиозной вражды;rn- пропагандирующих нацистскую символику;rn- содержащих описание средств и способов суицида, любое подстрекательство к его совершению;rn- пропагандирующих преступную деятельность или содержащих советы, инструкции или руководства по совершению преступных действий;rn- размещение адресов, телефонов, фото и видео материалов и других личных данных третьих лиц без их согласия;rn- размещение материалов, которые содержат угрозы, дискредитируют, оскорбляют, порочат честь и достоинство или деловую репутацию или нарушают неприкосновенность частной жизни других пользователей или третьих лиц;rn- размещение в любом виде рекламной информации в медиафайлах, сообщениях, комментариях;rn- размещение каких-либо материалов с целью коммерческой деятельности;rn- размещение вредоносных файлов;rn- размещение файлов с неправильным описанием или названием, которое вводит пользователей в заблуждение или затрудняет поиск;rn- добавление в описание файла текста, не относящегося к самому файлу, в том числе различных призывов типа "Добавьте в закладки", "Добавьте в ленту" и т.п.;rn- размещение каких-либо материалов, нарушающих иные права и интересы граждан и юридических лиц или требования законодательства Российской Федерации.rnrn<b>Материалы для взрослых</b> (<span style="color:#ff0000">обязательна метка 18+</span>):rn- материалы, содержащие ненормативную лексику;rn- любые материалы, содержащие откровенные эротические сцены, имитацию либо процесс полового акта, даже без изображения обнаженных половых органов;rn- любые материалы, содержащие элементы БДСМ, даже без изображения обнаженных половых органов;rnБДСМ (англ. BDSM) — психосексуальная субкультура, основанная на эротическом обмене властью и иных формах сексуальных отношений, затрагивающих ролевые игры в господство и подчинение.rn- файлы с информацией устрашающего характера, содержащие неэстетичные сцены аварий и происшествий и т.п., способные травмировать неустойчивую психику.rnrn<b>Администрация Сайта оставляет за собой право:</b>rn- удалить Ваш аккаунт за нарушение данных правил;rn- без специального уведомления изменять (модерировать) или удалять любую публикуемую Вами информацию, нарушающую запреты, установленные данными правилами.rnrnВ данной теме коротко изложены только правила размещения файлов и др. информации. Полные правила Сайта читайте <a href="/rules.html">здесь</a>.', 1, 1, 0, '$thistime', 0),
(6, 'faq_users', 'Помощь (FAQ)', '', '', 'А:: А где помощь???rnБ:: Помощь в написании...rnrnА:: А где админ???rnБ:: Пишет помощь...', 1, 1, 0, '$thistime', 0),
(7, 'rules_soo', 'Правила Сообществ', '', '', 'Правила в написании.....', 1, 1, 0, '$thistime', 0),
(8, 'users_help', 'Помощь', '', '', 'Помощь в написании.....', 1, 1, 0, '$thistime', 0);";
$tbl[] = "INSERT INTO `?_present_files` (`id`, `cid`, `file`, `name`, `price`, `count`) VALUESn(1, 1, 'gift_small_otkrytka_ny.gif', 'Новогодняя открытка', 5.00, 0),n(2, 1, 'gift_small_otkrytka.gif', 'Поздравительная открытка', 5.00, 0),n(3, 1, 'gift_small_rose.gif', 'Роза', 10.00, 0),n(4, 1, 'gift_small_cake.gif', 'Торт', 10.00, 0),n(5, 1, 'gift_small_buket.gif', 'Букет', 10.00, 0),n(6, 1, 'gift_small_beer.gif', 'Пиво', 10.00, 0),n(7, 1, 'gift_small_shamp.gif', 'Шампанское', 10.00, 0),n(8, 1, 'gift_small_bears.gif', 'Мишки', 10.00, 0),n(9, 1, 'gift_small_bita.gif', 'Бита', 10.00, 0),n(10, 1, 'gift_small_tufli.gif', 'Красные туфельки', 10.00, 0),n(11, 1, 'gift_small_notebook.gif', 'Ноутбук', 10.00, 0),n(12, 1, 'gift_small_soska.gif', 'Соска', 10.00, 0),n(13, 1, 'gift_small_coffee.gif', 'Кофе', 10.00, 0),n(14, 1, 'gift_small_alarm.gif', 'Будильник', 10.00, 0),n(15, 1, 'gift_small_candy.gif', 'Конфеты', 10.00, 0),n(16, 1, 'gift_small_skalka.gif', 'Скалка', 10.00, 0),n(17, 1, 'gift_small_katana.gif', 'Катана', 10.00, 0),n(18, 1, 'gift_small_maksim.gif', 'Пулемёт', 10.00, 0),n(19, 1, 'gift_small_ball.gif', 'Мяч', 10.00, 0),n(20, 1, 'gift_small_gloves.gif', 'Перчатки', 10.00, 0),n(21, 1, 'gift_small_medal.gif', 'Медаль', 10.00, 0),n(22, 1, 'gift_small_pig.gif', 'Копилка полная монет', 10.00, 0),n(23, 1, 'gift_small_trusy.gif', 'Красные труселя', 10.00, 0),n(24, 1, 'gift_small_elka.gif', 'Ёлка', 10.00, 0),n(25, 1, 'gift_small_dedmoroz.gif', 'Дед Мороз', 10.00, 0),n(26, 1, 'gift_small_snegurka.gif', 'Снегурочка', 10.00, 0),n(27, 1, 'gift_small_flowers.gif', 'Букет ромашек', 10.00, 0),n(28, 1, 'gift_small_parfume.gif', 'Духи', 10.00, 0),n(29, 1, 'gift_small_bonsai.gif', 'Бонсай', 10.00, 0),n(30, 1, 'gift_small_wings.gif', 'Крылья', 10.00, 0),n(31, 1, 'gift_small_devil.gif', 'Чертенок', 10.00, 0),n(32, 1, 'gift_small_coctail.gif', 'Коктейль', 10.00, 0),n(33, 1, 'gift_small_guitar.gif', 'Электрогитара', 10.00, 0),n(34, 1, 'gift_small_mandarine.gif', 'Мандарины', 10.00, 0),n(35, 1, 'gift_small_snowman.gif', 'Снеговик', 10.00, 0),n(36, 1, 'gift_small_snowflake.gif', 'Снежинка', 10.00, 0),n(37, 1, 'gift_small_sleigh.gif', 'Мешок с подарками', 10.00, 0),n(38, 1, 'gift_small_hat.gif', 'Новогодняя шапка', 10.00, 0),n(39, 1, 'gift_small_carrot.gif', 'Морковка', 10.00, 0),n(40, 1, 'gift_small_candycane.gif', 'Карамелька', 10.00, 0),n(41, 1, 'gift_small_teddy.gif', 'Плюшевый мишка', 10.00, 0),n(42, 1, 'gift_small_kiss.gif', 'Поцелуй', 10.00, 0),n(43, 1, 'gift_small_pink.gif', 'Гвоздика', 10.00, 0),n(44, 1, 'gift_small_sword.gif', 'Щит и меч', 10.00, 0),n(45, 1, 'gift_small_breakfast.gif', 'Завтрак', 10.00, 0),n(46, 1, 'gift_small_mimoza.gif', 'Мимоза', 10.00, 0),n(47, 1, 'gift_small_candy2.gif', 'Леденец', 10.00, 0),n(48, 1, 'gift_small_dragon.gif', 'Дракон', 10.00, 0),n(49, 1, 'gift_small_presents.gif', 'Подарки', 10.00, 0),n(50, 1, 'gift_small_teddy2.gif', 'Мишка Тедди', 10.00, 0),n(51, 2, 'gift_small_rings.gif', 'Обручальные кольца', 30.00, 0),n(52, 2, 'gift_small_heart.gif', 'Сердце', 30.00, 0),n(53, 2, 'gift_small_tort.gif', 'Свадебный торт', 30.00, 0),n(54, 2, 'gift_small_fish.gif', 'Золотая рыбка', 30.00, 0),n(55, 2, 'gift_small_ring.gif', 'Кольцо с бриллиантом', 30.00, 0),n(56, 2, 'gift_small_case.gif', 'Млн. долларов США', 30.00, 0),n(57, 2, 'gift_small_kolie.gif', 'Колье с изумрудом', 30.00, 0),n(58, 2, 'gift_small_tank.gif', 'Танк', 30.00, 0),n(59, 2, 'gift_small_car.gif', 'Машина', 30.00, 0),n(60, 2, 'gift_small_lizard.gif', 'Брошь изумрудная', 30.00, 0),n(61, 2, 'gift_small_pearl.gif', 'Жемчужина', 30.00, 0),n(62, 2, 'gift_small_budda.gif', 'Статуэтка Будды', 30.00, 0),n(63, 2, 'gift_small_heart2.gif', 'Сердце', 30.00, 0),n(64, 2, 'gift_small_plane.gif', 'Самолет', 30.00, 0),n(65, 2, 'gift_small_diadem.gif', 'Диадема', 30.00, 0),n(66, 3, 'gift_small_yacht.gif', 'Шикарная яхта', 50.00, 0),n(67, 3, 'gift_small_throne.gif', 'Трон', 50.00, 0),n(68, 3, 'gift_small_crown.gif', 'Корона', 50.00, 0),n(69, 3, 'gift_small_diamond.gif', 'Крупный бриллиант', 50.00, 0),n(70, 3, 'gift_small_castle.gif', 'Замок в облаках', 50.00, 0),n(71, 4, 'gift_small_olen.gif', 'Олень', 10.00, 0),n(72, 4, 'gift_small_cat.gif', 'Котёнок', 10.00, 0),n(73, 4, 'gift_small_dog.gif', 'Щенок', 10.00, 0),n(74, 4, 'gift_small_fox.gif', 'Лисёнок', 10.00, 0),n(75, 4, 'gift_small_racoon.gif', 'Енот', 10.00, 0),n(76, 4, 'gift_small_tiger.gif', 'Тигрёнок', 10.00, 0),n(77, 4, 'gift_small_rabbit.gif', 'Кролик', 10.00, 0),n(78, 4, 'gift_small_beaver.gif', 'Бобр', 10.00, 0),n(79, 4, 'gift_small_hamster.gif', 'Хомяк', 10.00, 0),n(80, 4, 'gift_small_skunk.gif', 'Скунс', 10.00, 0),n(81, 4, 'gift_small_eagle.gif', 'Орёл', 10.00, 0),n(82, 4, 'gift_small_zebra.gif', 'Зебра', 10.00, 0),n(83, 4, 'gift_small_lion.gif', 'Лев', 10.00, 0),n(84, 4, 'gift_small_hippo.gif', 'Бегемот', 10.00, 0),n(85, 4, 'gift_small_giraffe.gif', 'Жираф', 10.00, 0),n(86, 4, 'gift_small_hedgehog.gif', 'Ёжик', 10.00, 0),n(87, 4, 'gift_small_hare.gif', 'Заяц', 10.00, 0),n(88, 4, 'gift_small_wolf.gif', 'Волчонок', 10.00, 0),n(89, 4, 'gift_small_pinguin.gif', 'Пингвин', 10.00, 0),n(90, 4, 'gift_small_bear.gif', 'Медвежонок', 10.00, 0);";
# Изменения в таблицах
$tbl[] = "ALTER TABLE ?_users ADD `users_allchat` INT( 11 ) NOT NULL DEFAULT '0' AFTER `users_newwall`;";
$tbl[] = "ALTER TABLE ?_users CHANGE `users_money` `users_money` DECIMAL(12,2) default '0.00';";
//$tbl[] = "ALTER TABLE ?_users CHANGE `users_ipbinding` `users_uploads` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'";
for ( $i = 0; $i < count( $tbl ); ++$i ) {
if ( empty($tbl[$i]) ) continue;
$tbl[$i] = str_replace('?_', $config['db_prefix'], $tbl[$i]);
if ( $manual === 0 ) {
$db->query( $tbl[$i] );
}
else
{
$query .= $tbl[$i]."nn";
}
}
return $query;
}
?>