<?
$a[1]="CREATE TABLE IF NOT EXISTS `bandbook` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`bandid` text NOT NULL,
`text` text NOT NULL,
`login` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[2]="CREATE TABLE IF NOT EXISTS `bands` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text,
`boss` text,
`members` text,
`blvl` int(3) NOT NULL DEFAULT '1',
`cars` text,
`guns` text,
`money` int(11) NOT NULL DEFAULT '0',
`gold` int(11) NOT NULL DEFAULT '0',
`euro` int(10) NOT NULL DEFAULT '0',
`kazna` int(1) NOT NULL,
`osobnyak` int(1) NOT NULL DEFAULT '0',
`antikiller` int(20) NOT NULL DEFAULT '0',
`secur` int(20) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`antiwar` int(30) NOT NULL DEFAULT '0',
`sila` int(3) NOT NULL DEFAULT '0',
`obwak` int(3) NOT NULL DEFAULT '0',
`logovo` int(3) NOT NULL DEFAULT '0',
`control` int(3) NOT NULL DEFAULT '0',
`usil` int(11) NOT NULL DEFAULT '0',
`usil2` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[3]="CREATE TABLE IF NOT EXISTS `bandwar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`band1` text NOT NULL,
`band2` text NOT NULL,
`ball1` int(11) NOT NULL,
`ball2` int(11) NOT NULL,
`time` int(30) NOT NULL,
`active` int(1) NOT NULL DEFAULT '1',
`win` text NOT NULL,
`stavka` int(10) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[4]="CREATE TABLE IF NOT EXISTS `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`time` text NOT NULL,
`text` text NOT NULL,
`kom` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[5]="CREATE TABLE IF NOT EXISTS `chat2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`private` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[6]="CREATE TABLE IF NOT EXISTS `clicks` (
`dbid` int(10) unsigned NOT NULL DEFAULT '0',
`ip` varchar(15) NOT NULL DEFAULT '',
`time` int(10) unsigned NOT NULL DEFAULT '0',
`browser` blob NOT NULL,
PRIMARY KEY (`dbid`,`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$a[8]="CREATE TABLE IF NOT EXISTS `events` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`info` text NOT NULL,
`prize` text NOT NULL,
`time` text NOT NULL,
`win` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;";
$a[9]="CREATE TABLE IF NOT EXISTS `fights` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`last` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;";
$a[10]="CREATE TABLE IF NOT EXISTS `forsage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`users` text NOT NULL,
`stage` int(2) NOT NULL DEFAULT '1',
`win` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;";
$a[11]="CREATE TABLE IF NOT EXISTS `forsage_cars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`gonka` int(11) NOT NULL DEFAULT '0',
`car` text NOT NULL,
`mods` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[13]="CREATE TABLE IF NOT EXISTS `gorod_conf` (
`open` varchar(2) NOT NULL,
`kopi` int(11) NOT NULL,
`kopi_v` varchar(32) NOT NULL,
`kopi_k` varchar(32) NOT NULL,
`kopi_time` int(11) NOT NULL,
`luna` int(11) DEFAULT '0',
`login` text NOT NULL,
`gold` int(11) NOT NULL DEFAULT '0',
`cena` int(11) NOT NULL DEFAULT '10',
`kr_time` int(15) NOT NULL,
`kolvo` int(3) NOT NULL DEFAULT '0',
`time_do` int(20) NOT NULL DEFAULT '0',
`time_p` int(30) NOT NULL DEFAULT '0',
`time_o` int(30) NOT NULL DEFAULT '0',
`gold_o` int(4) NOT NULL DEFAULT '0',
`tema` int(3) NOT NULL DEFAULT '2'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$b[1]="INSERT INTO `gorod_conf` (`open`, `kopi`, `kopi_v`, `kopi_k`, `kopi_time`, `luna`, `login`, `gold`, `cena`, `kr_time`, `kolvo`, `time_do`, `time_p`, `time_o`, `gold_o`, `tema`) VALUES
('1', 0, '', '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 2);";
$a[14]="CREATE TABLE IF NOT EXISTS `gorod_tbega` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`bet` smallint(6) NOT NULL,
`last` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[15]="CREATE TABLE IF NOT EXISTS `kasino` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`combo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[16]="CREATE TABLE IF NOT EXISTS `krisha` (
`id` int(2) NOT NULL AUTO_INCREMENT,
`city` int(2) NOT NULL DEFAULT '0',
`house` text NOT NULL,
`money` int(2) NOT NULL DEFAULT '0',
`band` text NOT NULL,
`secur` int(10) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[17]="CREATE TABLE IF NOT EXISTS `krisha2` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`city` int(1) NOT NULL DEFAULT '0',
`band` text NOT NULL,
`time` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;";
$b[2]="INSERT INTO `krisha2` (`id`, `city`, `band`, `time`) VALUES
(1, 1, '', 0),
(2, 2, '', 0),
(3, 3, '', 0);";
$a[18]="CREATE TABLE IF NOT EXISTS `lostpass` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`userid` int(10) NOT NULL DEFAULT '0',
`code` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[19]="CREATE TABLE IF NOT EXISTS `mafia` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`time` int(30) NOT NULL DEFAULT '0',
`active` int(1) NOT NULL DEFAULT '0',
`time_ot` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[20]="CREATE TABLE IF NOT EXISTS `mail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(11) NOT NULL DEFAULT '0',
`komu` text NOT NULL,
`text` text NOT NULL,
`type` int(1) NOT NULL DEFAULT '0',
`time` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[23]="CREATE TABLE IF NOT EXISTS `news` (
`dbid` int(3) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`text` text NOT NULL,
`date` char(30) DEFAULT NULL,
PRIMARY KEY (`dbid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[24]="CREATE TABLE IF NOT EXISTS `pay` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`pays` text NOT NULL,
`mail` text NOT NULL,
`kol` int(5) NOT NULL DEFAULT '0',
`sost` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[27]="CREATE TABLE IF NOT EXISTS `refers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`refer` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
$a[28]="CREATE TABLE IF NOT EXISTS `sklad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(11) NOT NULL DEFAULT '0',
`komu` int(11) NOT NULL DEFAULT '0',
`chto` text NOT NULL,
`type` int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;";
$a[29]="CREATE TABLE IF NOT EXISTS `tickets` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`userid` int(10) NOT NULL,
`tema` text NOT NULL,
`text` text NOT NULL,
`date` text NOT NULL,
`status` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[30]="CREATE TABLE IF NOT EXISTS `tickets2` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`ticketid` int(10) NOT NULL,
`login` text NOT NULL,
`text` text NOT NULL,
`date` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;";
$a[33]="CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` text NOT NULL,
`pass` text NOT NULL,
`lvl` int(50) NOT NULL DEFAULT '0',
`mobile` text,
`email` text,
`about` text,
`reenergy` int(30) DEFAULT '0',
`reg_data` text,
`money` int(11) NOT NULL DEFAULT '0',
`gold` int(11) NOT NULL DEFAULT '0',
`level` int(4) NOT NULL DEFAULT '0',
`school` enum('0','1','2','3') NOT NULL DEFAULT '0',
`antikiller` int(3) NOT NULL DEFAULT '0',
`police` int(3) NOT NULL DEFAULT '0',
`health` int(4) NOT NULL DEFAULT '0',
`band` text NOT NULL,
`last` text NOT NULL,
`cars` text NOT NULL,
`guns` text NOT NULL,
`nums` int(11) NOT NULL DEFAULT '0',
`voodoo` int(1) NOT NULL DEFAULT '0',
`energy` int(3) NOT NULL DEFAULT '0',
`secur` int(3) NOT NULL DEFAULT '0',
`city` int(3) NOT NULL DEFAULT '0',
`admin` int(6) NOT NULL DEFAULT '0',
`ban` int(15) NOT NULL DEFAULT '0',
`zav` int(25) NOT NULL DEFAULT '0',
`lsd` int(25) NOT NULL DEFAULT '0',
`redaktor` int(2) NOT NULL DEFAULT '0',
`policeman` int(2) NOT NULL DEFAULT '0',
`gorod_firm` varchar(50) NOT NULL,
`gorod_kopi` bigint(20) NOT NULL,
`pol` enum('0','1') NOT NULL DEFAULT '1',
`referer` int(10) NOT NULL DEFAULT '1',
`mafia` int(5) NOT NULL DEFAULT '0',
`lox` enum('0','1') NOT NULL DEFAULT '0',
`tattoo` int(3) NOT NULL DEFAULT '0',
`school_time` int(15) NOT NULL DEFAULT '0',
`dieta` int(15) NOT NULL DEFAULT '0',
`zav2` int(20) NOT NULL DEFAULT '0',
`maska` int(20) NOT NULL DEFAULT '0',
`kup_time` int(11) NOT NULL DEFAULT '0',
`f_time` int(11) NOT NULL DEFAULT '0',
`dolg` int(10) NOT NULL DEFAULT '0',
`dolg_time` int(30) NOT NULL DEFAULT '0',
`dolg_d` int(11) NOT NULL DEFAULT '0',
`dj` int(1) NOT NULL DEFAULT '0',
`verify` int(2) NOT NULL DEFAULT '0',
`ban_do` int(20) NOT NULL DEFAULT '0',
`prichina` text NOT NULL,
`ip` text NOT NULL,
`browser` text NOT NULL,
`euro` int(10) NOT NULL DEFAULT '0',
`kvest` int(10) NOT NULL DEFAULT '1',
`click` int(30) NOT NULL DEFAULT '0',
`click2` int(30) NOT NULL DEFAULT '0',
`obmen` int(30) NOT NULL DEFAULT '0',
`nalog` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;";
$b[3]="INSERT INTO `users` (`id`, `login`, `pass`, `lvl`, `mobile`, `email`, `about`, `reenergy`, `reg_data`, `money`, `gold`, `level`, `school`, `antikiller`, `police`, `health`, `band`, `last`, `cars`, `guns`, `nums`, `voodoo`, `energy`, `secur`, `city`, `admin`, `ban`, `zav`, `lsd`, `redaktor`, `policeman`, `gorod_firm`, `gorod_kopi`, `pol`, `referer`, `mafia`, `lox`, `tattoo`, `school_time`, `dieta`, `zav2`, `maska`, `kup_time`, `f_time`, `dolg`, `dolg_time`, `dolg_d`, `dj`, `verify`, `ban_do`, `prichina`, `ip`, `browser`, `euro`, `kvest`, `click`, `click2`, `obmen`, `nalog`) VALUES
(1, 'admin', '827ccb0eea8a706c4c34a16891f84e7b', 0, '', '[email protected]', '', 1354634740, '0:5.12.12', 100000, 1000, 1000, '0', 0, 0, 1000, '', '1354634555', '', '', 0, 0, 100, 5, 3, 7, 0, 0, 0, 0, 0, '', 0, '1', 0, 0, '0', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 1, 1354634558, 1354634558, 0, 1354721140);";
$a[34]="CREATE TABLE IF NOT EXISTS `user_home` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL DEFAULT '0',
`cars` text,
`guns` text,
`money` int(11) NOT NULL DEFAULT '0',
`biznes` int(3) NOT NULL DEFAULT '0',
`eurobiznes` int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;";
?>