View file gta/mysql/mysql.php

<?

$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 ;";

?>