-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- : localhost
--  :  14 2014 ., 12:35
--  : 5.0.45
--  PHP: 5.2.4
-- 
-- : `stalker`
-- 

-- --------------------------------------------------------

-- 
--   `fight`
-- 

DROP TABLE IF EXISTS `fight`;
CREATE TABLE IF NOT EXISTS `fight` (
  `id` int(11) NOT NULL auto_increment,
  `akom` text,
  `bkom` text,
  `up_a` int(11) default NULL,
  `up_b` int(11) default NULL,
  `count_a` smallint(5) unsigned default '0',
  `count_b` smallint(5) unsigned default '0',
  `start` int(11) default NULL,
  `stop` int(11) default '0',
  `locat` int(11) default NULL,
  `coord` varchar(8) NOT NULL,
  `fighttype` enum('p','m') default NULL,
  `exp_com_a` int(11) NOT NULL,
  `exp_com_b` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 AUTO_INCREMENT=201 ;

-- 
--    `fight`
-- 

INSERT INTO `fight` (`id`, `akom`, `bkom`, `up_a`, `up_b`, `count_a`, `count_b`, `start`, `stop`, `locat`, `coord`, `fighttype`, `exp_com_a`, `exp_com_b`) VALUES (1, '9,10', '1', 0, 0, 0, 0, 1369995532, 1370093227, 5, '4-1', 'm', 0, 0),
(3, '12,13,14,15,16,17', '1', 0, 0, 0, 0, 1370093291, 1370093307, 5, '4-1', 'm', 0, 0),
(4, '18,19,20,21,22,23', '1', 0, 0, 0, 0, 1370093318, 1370093445, 5, '4-1', 'm', 0, 0),
(6, '31,32,33,34', '1', 0, 0, 0, 0, 1370093547, 1370093551, 5, '4-1', 'm', 0, 0),
(8, '40,41,42,43,44,45,46', '1', 0, 0, 0, 0, 1370093669, 1370093671, 5, '4-1', 'm', 0, 0),
(9, '47,48,49,50,51,52', '1', 0, 0, 0, 0, 1370093675, 1370093896, 5, '4-1', 'm', 0, 0),
(10, '53,54,55,56,57,58', '1', 0, 0, 0, 0, 1370094207, 1370094536, 5, '4-1', 'm', 0, 0),
(11, '59,60,61,62', '1', 0, 0, 0, 0, 1370095789, 1370095965, 5, '4-1', 'm', 0, 0),
(12, '63,64,65,66,67', '1', 0, 0, 0, 0, 1370095970, 1370095975, 5, '4-1', 'm', 0, 0),
(13, '68,69,70', '1', 0, 0, 0, 0, 1370095978, 1370095980, 5, '4-1', 'm', 0, 0),
(14, '71,72,73', '1', 0, 0, 0, 0, 1370095983, 1370095998, 5, '4-1', 'm', 0, 0),
(15, '74,75,76,77,78,79', '1', 0, 0, 0, 0, 1370096005, 1370096019, 5, '4-1', 'm', 0, 0),
(16, '80,81,82,83', '1', 0, 0, 0, 0, 1370096023, 1370096035, 5, '4-1', 'm', 0, 0),
(17, '84,85,86,87,88,89', '1', 0, 0, 0, 0, 1370096052, 1370096104, 5, '4-1', 'm', 0, 0),
(18, '90,91,92,93,94,95', '1', 0, 0, 0, 0, 1370098830, 1370098861, 5, '4-1', 'm', 0, 0),
(19, '96,97,98,99,100,101,102', '1', 0, 0, 0, 0, 1370098959, 1370098999, 5, '5-1', 'm', 0, 0),
(20, '103,104,105,106', '1', 0, 0, 0, 0, 1370099019, 1370099020, 5, '3-1', 'm', 0, 0),
(21, '107,108,109', '1', 0, 0, 0, 0, 1370099671, 1370099773, 5, '3-1', 'm', 0, 0),
(22, '110,111,112,113', '1', 0, 0, 0, 0, 1370099782, 1370099784, 5, '4-1', 'm', 0, 0),
(23, '114,115,116,117,118,119', '1', 0, 0, 0, 0, 1370099797, 1370099981, 5, '5-1', 'm', 0, 0),
(24, '120,121,122', '1', 0, 0, 0, 0, 1370100484, 1370101530, 5, '3-1', 'm', 0, 0),
(25, '123,124,125', '1', 0, 0, 0, 0, 1370101551, 1370101592, 5, '4-1', 'm', 0, 300),
(26, '126,127,128,129', '1', 0, 0, 0, 0, 1370101646, 1370101656, 5, '5-1', 'm', 0, 75),
(27, '130,131,132,133,134,135', '1', 0, 0, 0, 0, 1370102214, 1370102519, 5, '3-1', 'm', 0, 0),
(28, '136,137,138,139,140,141', '1', 0, 0, 0, 0, 1370102619, 1370102657, 5, '4-1', 'm', 0, 92),
(29, '142,143,144,145,146', '1', 0, 0, 0, 0, 1370102668, 1370102727, 5, '5-1', 'm', 0, 71),
(30, '147,148,149,150,151,152,153', '1', 0, 0, 0, 0, 1370103699, 1370104002, 5, '3-1', 'm', 0, 70),
(31, '154,155,156,157,158,159,160', '1', 0, 0, 0, 0, 1370104044, 1370104046, 5, '4-1', 'm', 0, 0),
(32, '161,162,163,164', '1', 0, 0, 0, 0, 1370104066, 1370104338, 5, '5-1', 'm', 0, 400),
(33, '165,166,167,168,169', '1', 0, 0, 0, 0, 1370104693, 1370104892, 5, '3-1', 'm', 0, 500),
(34, '170,171,172', '1', 0, 0, 0, 0, 1370105392, 1370105483, 5, '4-1', 'm', 0, 300),
(35, '173,174,175', '1', 0, 0, 0, 0, 1370105663, 1370105960, 5, '5-1', 'm', 0, 300),
(36, '176,177,178,179', '1', 0, 0, 0, 0, 1370106692, 1370106785, 5, '3-1', 'm', 0, 400),
(37, '180,181,182,183,184', '1', 0, 0, 0, 0, 1370106795, 1370106890, 5, '4-1', 'm', 0, 500),
(38, '185,186,187,188,189,190,191,192,193,194,195,196', '1', 0, 0, 0, 0, 1370107820, 1370107925, 5, '3-1', 'm', 0, 423),
(39, '197,198,199,200,201,202,203,204,205,206,207,208,209,210', '1', 0, 0, 0, 0, 1370108014, 1370108019, 5, '5-1', 'm', 0, 0),
(40, '211,212,213,214,215,216', '1', 0, 0, 0, 0, 1370108032, 1370108136, 5, '4-1', 'm', 0, 600),
(41, '217,218,219,220,221,222,223,224,225,226,227,228', '1', 0, 0, 0, 0, 1370108829, 1370109061, 5, '3-1', 'm', 0, 270),
(42, '229,230,231,232,233,234,235,236,237,238,239,240,241,242,243', '1', 0, 0, 0, 0, 1370109157, 1370109189, 5, '4-1', 'm', 0, 414),
(43, '244,245,246,247,248,249,250,251,252,253,254,255,256,257,258', '1', 0, 0, 0, 0, 1370109207, 1370109238, 5, '5-1', 'm', 0, 374),
(44, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15', '1', 0, 0, 0, 0, 1370165641, 1370165650, 5, '5-1', 'm', 0, 35),
(45, '16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33', '1', 0, 0, 0, 0, 1370165721, 1370165849, 5, '4-1', 'm', 0, 290),
(46, '34,35,36,37,38,39,40,41,42,43,44,45,46,47,48', '1', 0, 0, 0, 0, 1370169494, 1370169504, 5, '4-1', 'm', 0, 0),
(47, '49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66', '1', 0, 0, 0, 0, 1370169551, 1370169586, 5, '5-1', 'm', 0, 0),
(48, '67,68,69,70,71,72,73,74,75,76,77,78', '1', 0, 0, 0, 0, 1370199783, 1370199857, 5, '3-1', 'm', 0, 482),
(49, '79,80,81,82,83,84,85,86,87', '1', 0, 0, 0, 0, 1370200090, 1370200091, 5, '4-1', 'm', 0, 0),
(50, '88,89,90,91,92,93,94,95,96,97,98,99', '1', 0, 0, 0, 0, 1370200104, 1370200221, 5, '5-1', 'm', 0, 426),
(51, '100,101,102,103,104,105,106,107,108,109,110,111', '1', 0, 0, 0, 0, 1370200741, 1370200952, 5, '3-1', 'm', 0, 706),
(52, '112,113,114,115,116,117,118,119,120,121,122,123', '1', 0, 0, 0, 0, 1370200967, 1370201111, 5, '4-1', 'm', 0, 602),
(53, '124,125,126,127,128,129,130,131,132,133,134,135', '1', 0, 0, 0, 0, 1370202605, 1370203337, 5, '3-1', 'm', 0, 1200),
(54, '136,137,138,139,140,141,142,143,144,145,146,147', '1', 0, 0, 0, 0, 1370203500, 1370203802, 5, '4-1', 'm', 0, 1200),
(55, '148,149,150,151,152,153,154,155,156,157,158,159', '1', 0, 0, 0, 0, 1370205032, 1370205203, 5, '4-1', 'm', 0, 1200),
(56, '160,161,162,163,164,165,166,167,168,169,170,171', '1', 0, 0, 0, 0, 1370205370, 1370205565, 5, '5-1', 'm', 0, 1200),
(57, '172,173,174,175,176,177,178,179,180,181,182,183', '1', 0, 0, 0, 0, 1370206182, 1370206461, 5, '3-1', 'm', 0, 1200),
(58, '184,185,186,187,188,189,190,191,192,193,194,195', '1', 0, 0, 0, 0, 1370206546, 1370206688, 5, '4-1', 'm', 0, 788),
(59, '196,197,198,199,200,201,202,203,204,205,206,207', '1', 0, 0, 0, 0, 1370206949, 1370207147, 5, '5-1', 'm', 0, 400),
(60, '208,209,210,211,212,213,214,215,216,217,218,219', '1', 0, 0, 0, 0, 1370250885, 1370250939, 5, '5-1', 'm', 0, 200),
(61, '220,221,222,223,224,225,226,227,228,229,230,231', '1', 0, 0, 0, 0, 1370251366, 1370251409, 5, '3-1', 'm', 0, 0),
(62, '232,233,234,235,236,237,238,239,240,241,242,243', '1', 0, 0, 0, 0, 1370251437, 1370251530, 5, '4-1', 'm', 0, 1200),
(63, '244,245,246,247,248,249,250,251,252,253,254,255', '1', 0, 0, 0, 0, 1370251939, 1370251992, 5, '5-1', 'm', 0, 528),
(64, '256,257,258,259', '1', 0, 0, 0, 0, 1370252157, 1370252236, 5, '3-1', 'm', 0, 400),
(65, '260,261,262,263,264,265,266', '1', 0, 0, 0, 0, 1370252714, 1370252793, 5, '4-1', 'm', 0, 700),
(66, '267,268,269,270,271,272,273,274', '1', 0, 0, 0, 0, 1370252963, 1370253120, 5, '5-1', 'm', 0, 800),
(67, '275,276,277,278,279,280,281,282,283,284,285,286', '1', 0, 0, 0, 0, 1370253214, 1370253324, 5, '3-1', 'm', 0, 1200),
(68, '287,288,289,290', '1', 0, 0, 0, 0, 1370253458, 1370253505, 5, '4-1', 'm', 0, 400),
(69, '291,292,293,294,295,296', '1', 0, 0, 0, 0, 1370267080, 1370267169, 5, '3-1', 'm', 0, 600),
(70, '297,298,299', '1', 0, 0, 0, 0, 1370267200, 1370267211, 5, '4-1', 'm', 0, 300),
(71, '300,301,302,303,304,305,306,307', '1', 0, 0, 0, 0, 1370267221, 1370267246, 5, '5-1', 'm', 0, 800),
(72, '308,309,310,311,312,313', '1', 0, 0, 0, 0, 1370267946, 1370267962, 5, '3-1', 'm', 0, 0),
(73, '314,315,316,317,318,319,320,321', '1', 0, 0, 0, 0, 1370267991, 1370267993, 5, '4-1', 'm', 0, 0),
(74, '322,323,324,325,326,327', '1', 0, 0, 0, 0, 1370268003, 1370268046, 5, '5-1', 'm', 0, 600),
(75, '328,329,330,331,332,333', '1', 0, 0, 0, 0, 1370269858, 1370269910, 5, '3-1', 'm', 0, 600),
(76, '334,335,336,337,338,339', '1', 0, 0, 0, 0, 1370275957, 1370276013, 5, '3-1', 'm', 0, 600),
(77, '340,341,342,343,344,345', '1', 0, 0, 0, 0, 1370276036, 1370276086, 5, '4-1', 'm', 0, 600),
(78, '346,347,348,349,350,351,352,353,354,355,356,357', '1', 0, 0, 0, 0, 1370286442, 1370286677, 5, '4-1', 'm', 0, 1200),
(79, '358,359,360,361,362,363,364,365,366,367,368,369', '1', 0, 0, 0, 0, 1370288091, 1370288164, 5, '3-1', 'm', 0, 1200),
(80, '370,371,372,373,374,375,376,377,378,379,380,381', '1', 0, 0, 0, 0, 1370289173, 1370289197, 5, '3-1', 'm', 0, 99),
(81, '382,383,384', '262', 0, 0, 0, 0, 1370290364, 1370290390, 5, '3-1', 'm', 0, 0),
(82, '385,386,387,388,389,390', '262', 0, 0, 0, 0, 1370292115, 1370292145, 5, '3-1', 'm', 0, 52),
(83, '391,392,393', '262', 0, 0, 0, 0, 1370292218, 1370292299, 5, '4-1', 'm', 0, 300),
(84, '394,395,396,397,398,399', '262', 0, 0, 0, 0, 1370292569, 1370292595, 5, '5-1', 'm', 0, 0),
(85, '400,401,402', '262', 0, 0, 0, 0, 1370292860, 1370292924, 5, '3-1', 'm', 0, 136),
(86, '403,404,405,406,407,408,409,410,411,412,413,414', '1', 0, 0, 0, 0, 1370335187, 1370335252, 5, '3-1', 'm', 0, 65),
(87, '415,416,417,418,419,420,421,422,423', '1', 0, 0, 0, 0, 1370335357, 1370335420, 5, '4-1', 'm', 0, 900),
(88, '424,425,426,427,428,429,430,431,432,433,434,435', '1', 0, 0, 0, 0, 1370335675, 1370335692, 5, '5-1', 'm', 0, 0),
(89, '436,437,438,439,440,441,442,443,444,445,446,447', '1', 0, 0, 0, 0, 1370340773, 1370340829, 5, '3-1', 'm', 0, 1200),
(90, '448,449,450,451,452,453,454,455,456,457,458,459', '1', 0, 0, 0, 0, 1370342775, 1370342825, 5, '3-1', 'm', 0, 1200),
(91, '460,461,462,463,464,465,466,467,468,469,470,471', '1', 0, 0, 0, 0, 1370342845, 1370342929, 5, '4-1', 'm', 0, 1200),
(92, '472,473,474,475,476,477,478,479,480,481,482,483', '1', 0, 0, 0, 0, 1370343070, 1370343098, 5, '5-1', 'm', 0, 1200),
(93, '484,485,486,487,488,489,490,491,492,493,494,495', '1', 0, 0, 0, 0, 1371718307, 1371718379, 5, '3-1', 'm', 0, 1200),
(94, '496,497,498,499,500,501,502,503,504,505,506,507', '1', 0, 0, 0, 0, 1371804658, 1371804762, 5, '4-1', 'm', 0, 1200),
(95, '508,509,510,511,512,513,514,515,516,517,518,519', '1', 0, 0, 0, 0, 1371805452, 1371805505, 5, '4-1', 'm', 0, 1200),
(96, '520,521,522,523,524,525,526,527,528,529,530,531', '1', 0, 0, 0, 0, 1371806194, 1371806246, 5, '4-1', 'm', 0, 180),
(97, '532,533,534,535,536,537,538,539,540,541,542,543', '1', 0, 0, 0, 0, 1371812291, 1371812305, 5, '3-1', 'm', 0, 100),
(98, '544,545,546,547,548,549,550,551,552,553,554,555', '1', 0, 0, 0, 0, 1371813507, 1371813578, 5, '3-1', 'm', 0, 1200),
(99, '1,2,3,4,5,6,7,8,9,10,11,12', '1', 0, 0, 0, 0, 1371815005, 1371815175, 5, '4-1', 'm', 0, 1200),
(100, '13,14,15,16,17,18,19,20,21,22,23,24', '1', 0, 0, 0, 0, 1371816251, 1371816297, 5, '4-1', 'm', 0, 500),
(101, '25,26,27,28,29,30,31,32,33,34,35,36', '1', 0, 0, 0, 0, 1371816962, 1371816985, 5, '4-1', 'm', 0, 156),
(102, '37,38,39,40,41,42,43,44,45,46,47,48', '1', 0, 0, 0, 0, 1371828468, 1371828507, 5, '3-1', 'm', 0, 1200),
(103, '49,50,51,52,53,54,55,56,57,58,59,60', '1', 0, 0, 0, 0, 1371829208, 1371829241, 5, '3-1', 'm', 0, 1200),
(104, '61,62,63,64,65,66,67,68,69,70,71,72', '1', 0, 0, 0, 0, 1371836441, 1371836489, 5, '3-1', 'm', 0, 1200),
(105, '73,74,75,76,77', '1', 0, 0, 0, 0, 1371838245, 1371838289, 11, '3-3', 'm', 0, 1250),
(106, '78,79,80,81,82,83,84,85,86,87,88,89', '1', 0, 0, 0, 0, 1371838479, 1371838522, 5, '4-1', 'm', 0, 1200),
(107, '90,91,92,93,94,95,96,97,98,99', '1', 0, 0, 0, 0, 1371838938, 1371839007, 11, '4-3', 'm', 0, 1050),
(108, '100,101,102,103,104,105,106,107,108,109,110,111', '1', 0, 0, 0, 0, 1371839128, 1371839200, 5, '5-1', 'm', 0, 1200),
(109, '112,113,114,115,116,117,118,119,120,121,122,123', '1', 0, 0, 0, 0, 1371840298, 1371840327, 5, '4-1', 'm', 0, 1200),
(110, '124,125,126,127,128,129,130,131,132,133,134,135', '1', 0, 0, 0, 0, 1371840361, 1371840445, 11, '3-3', 'm', 0, 3000),
(111, '136', '1', 0, 0, 0, 0, 1371842242, 1371842242, 11, '2-3', 'm', 0, 250),
(112, '137,138,139,140', '1', 0, 0, 0, 0, 1371842324, 1371842338, 5, '3-1', 'm', 0, 400),
(113, '141,142,143,144,145', '1', 0, 0, 0, 0, 1371842727, 1371842925, 11, '2-3', 'm', 0, 130),
(114, '146,147,148,149', '1', 0, 0, 0, 0, 1371842933, 1371842934, 11, '2-3', 'm', 0, 0),
(115, '150,151,152,153', '1', 0, 0, 0, 0, 1371843095, 1371843120, 11, '2-3', 'm', 0, 250),
(116, '154,155,156,157', '1', 0, 0, 0, 0, 1371843133, 1371843136, 11, '2-3', 'm', 0, 0),
(117, '158,159,160', '1', 0, 0, 0, 0, 1371843460, 1371843502, 11, '2-3', 'm', 0, 750),
(118, '161,162,163,164', '1', 0, 0, 0, 0, 1371843502, 1371843555, 11, '2-3', 'm', 0, 190),
(119, '165,166,167,168', '1', 0, 0, 0, 0, 1371843557, 1371843558, 11, '2-3', 'm', 0, 0),
(120, '169,170,171,172,173,174,175,176,177,178,179,180', '1', 0, 0, 0, 0, 1371844163, 1371844229, 11, '5-3', 'm', 0, 1200),
(121, '181,182,183,184,185,186,187,188,189,190,191,192', '1', 0, 0, 0, 0, 1371844837, 1371844871, 11, '5-3', 'm', 0, 1200),
(122, '193,194,195,196,197,198,199', '259', 0, 0, 0, 0, 1371845852, 1371845927, 5, '4-1', 'm', 0, 446),
(123, '200,201,202,203,204,205,206,207,208,209,210,211', '1', 0, 0, 0, 0, 1371845889, 1371845914, 5, '4-1', 'm', 0, 600),
(124, '212,213,214,215,216,217,218,219,220,221,222,223', '1', 0, 0, 0, 0, 1371846811, 1371846817, 5, '4-1', 'm', 0, 100),
(125, '224,225,226', '259', 0, 0, 0, 0, 1371847027, 1371847375, 11, '5-3', 'm', 0, 300),
(126, '1,2,3,4,5,6,7,8,9,10', '1', 0, 0, 0, 0, 1371904584, 1371904590, 11, '2-3', 'm', 0, 121),
(127, '11,12,13,14,15,16,17,18,19,20', '1', 0, 0, 0, 0, 1371904815, 1371904863, 5, '4-1', 'm', 0, 1000),
(128, '21,22,23,24', '259', 0, 0, 0, 0, 1371908297, 1371908804, 11, '4-3', 'm', 0, 700),
(129, '25,26,27,28,29,30', '1,259', 0, 0, 0, 0, 1371909333, 1371909381, 5, '4-1', 'm', 0, 600),
(130, '31,32', '259', 0, 0, 0, 0, 1371909644, 1371909653, 11, '4-3', 'm', 0, 350),
(131, '33,34,35,36,37,38', '1,259', 0, 0, 0, 0, 1371910796, 1371910852, 11, '2-3', 'm', 0, 176),
(132, '39,40,41,42,43,44,45,46,47,48,49,50', '1', 0, 0, 0, 0, 1371911016, 1371911059, 5, '3-1', 'm', 0, 1200),
(133, '51,52,53,54,55,56,57,58,59,60', '1', 0, 0, 0, 0, 1371913553, 1371913581, 5, '3-1', 'm', 0, 1000),
(134, '61,62,63,64,65,66,67,68,69,70', '1', 0, 0, 0, 0, 1371913606, 1371913630, 11, '5-3', 'm', 0, 1000),
(135, '71,72,73,74,75,76', '1', 0, 0, 0, 0, 1371979961, 1371979981, 11, '5-3', 'm', 0, 600),
(136, '77,78,79,80,81,82,83,84,85,86,87,88', '1', 0, 0, 0, 0, 1371979999, 1371980051, 5, '3-1', 'm', 0, 1200),
(137, '89,90,91,92,93,94,95,96,97', '1', 0, 0, 0, 0, 1371980366, 1371980398, 12, '4-2', 'm', 0, 179),
(138, '98,99,100,101,102,103,104,105,106,107,108,109', '1', 0, 0, 0, 0, 1371981934, 1371982011, 12, '3-2', 'm', 0, 1200),
(139, '110,111,112,113,114,115,116,117,118', '1', 0, 0, 0, 0, 1371982110, 1371982172, 11, '5-3', 'm', 0, 900),
(140, '119,120,121,122,123,124,125,126,127,128,129,130', '1', 0, 0, 0, 0, 1371982543, 1371982708, 5, '4-1', 'm', 0, 675),
(141, '131,132,133,134,135,136,137,138,139,140,141,142', '1', 0, 0, 0, 0, 1371983067, 1371983109, 11, '5-3', 'm', 0, 146),
(142, '143,144,145,146,147,148,149,150,151,152,153,154', '1', 0, 0, 0, 0, 1371983470, 1371983564, 5, '4-1', 'm', 0, 1173),
(143, '155,156,157,158,159,160,161,162,163,164,165,166', '1', 0, 0, 0, 0, 1371983846, 1371983872, 11, '5-3', 'm', 0, 400),
(144, '167,168,169,170,171,172,173,174,175,176,177,178', '1', 0, 0, 0, 0, 1371984017, 1371984036, 13, '6-2', 'm', 0, 377),
(145, '179,180,181,182,183,184,185,186,187,188,189,190', '1', 0, 0, 0, 0, 1371984535, 1371984563, 5, '3-1', 'm', 0, 600),
(146, '191,192,193,194,195,196,197,198,199,200,201,202', '1', 0, 0, 0, 0, 1371984729, 1371984745, 13, '6-2', 'm', 0, 600),
(147, '203,204,205,206,207,208,209,210,211,212,213,214', '1', 0, 0, 0, 0, 1371984882, 1371984893, 11, '5-3', 'm', 0, 546),
(148, '215,216,217,218,219,220,221,222,223,224,225,226', '1', 0, 0, 0, 0, 1372001328, 1372001361, 5, '4-1', 'm', 0, 477),
(149, '227,228,229,230,231,232,233,234,235,236,237,238', '1', 0, 0, 0, 0, 1372001512, 1372001545, 11, '5-3', 'm', 0, 1200),
(150, '239,240,241,242,243,244,245,246,247,248,249,250', '1', 0, 0, 0, 0, 1372003940, 1372003956, 5, '3-1', 'm', 0, 500),
(151, '251,252,253,254,255,256,257,258,259,260,261,262', '1', 0, 0, 0, 0, 1372004090, 1372004129, 11, '5-3', 'm', 0, 1200),
(152, '263,264,265,266,267,268,269,270,271,272,273,274', '1', 0, 0, 0, 0, 1372004146, 1372004184, 12, '3-2', 'm', 0, 1200),
(153, '275,276,277,278,279,280,281,282,283,284,285,286', '1', 0, 0, 0, 0, 1372004388, 1372004425, 13, '6-2', 'm', 0, 1200),
(154, '287,288,289,290,291,292,293,294,295,296,297,298', '1', 0, 0, 0, 0, 1372004603, 1372004631, 5, '3-1', 'm', 0, 1200),
(155, '299,300,301,302,303,304', '1', 0, 0, 0, 0, 1372010035, 1372010064, 20, '3-3', 'm', 0, 290),
(156, '305,306,307,308,309,310,311,312,313,314,315,316', '1', 0, 0, 0, 0, 1372010270, 1372010313, 14, '4-5', 'm', 0, 1200),
(157, '317,318,319,320,321,322,323,324', '1', 0, 0, 0, 0, 1372010362, 1372010421, 16, '1-1', 'm', 0, 2000),
(158, '325,326,327,328,329,330,331,332,333,334,335,336', '1', 0, 0, 0, 0, 1372010483, 1372011679, 12, '3-2', 'm', 0, 1200),
(159, '337,338,339,340,341,342,343,344,345,346,347,348', '1', 0, 0, 0, 0, 1372011957, 1372012001, 5, '3-1', 'm', 0, 1200),
(160, '349,350,351,352,353,354,355,356,357,358', '1', 0, 0, 0, 0, 1372012117, 1372012227, 11, '2-3', 'm', 0, 2500),
(161, '359,360,361,362,363,364,365,366', '1', 0, 0, 0, 0, 1372012265, 1372012317, 13, '7-5', 'm', 0, 2000),
(162, '367,368,369,370', '1', 0, 0, 0, 0, 1372012456, 1372012569, 14, '4-1', 'm', 0, 1000),
(163, '371,372,373,374,375,376,377,378,379,380,381,382', '1', 0, 0, 0, 0, 1372018063, 1372018103, 5, '4-1', 'm', 0, 1200),
(164, '383,384,385,386,387,388,389,390', '1', 0, 0, 0, 0, 1372018115, 1372018142, 11, '4-3', 'm', 0, 1400),
(165, '391,392,393,394,395,396,397,398', '1', 0, 0, 0, 0, 1372018159, 1372018194, 12, '4-2', 'm', 0, 2000),
(166, '399,400,401,402,403,404,405,406,407,408', '1', 0, 0, 0, 0, 1372018253, 1372018306, 16, '2-3', 'm', 0, 2500),
(167, '409,410,411,412,413,414,415,416,417,418,419,420', '1', 0, 0, 0, 0, 1372018366, 1372018442, 14, '4-5', 'm', 0, 1200),
(168, '421,422,423,424,425,426,427,428,429,430', '1', 0, 0, 0, 0, 1372018991, 1372019569, 20, '3-3', 'm', 0, 2500),
(169, '431,432,433,434,435,436,437,438,439,440,441,442', '1', 0, 0, 0, 0, 1372019965, 1372019986, 5, '3-1', 'm', 0, 1200),
(170, '443,444,445,446,447,448,449,450,451,452,453,454', '1', 0, 0, 0, 0, 1372020088, 1372020133, 11, '2-3', 'm', 0, 3000),
(171, '455,456,457,458,459,460,461,462,463,464', '1', 0, 0, 0, 0, 1372020170, 1372020210, 21, '3-2', 'm', 0, 2500),
(172, '1,2,3,4,5,6,7,8,9,10', '1', 0, 0, 0, 0, 1372020324, 1372020368, 20, '3-3', 'm', 0, 2500),
(173, '11,12,13,14,15,16,17,18,19,20', '1', 0, 0, 0, 0, 1372020863, 1372020909, 15, '2-1', 'm', 0, 2500),
(174, '21,22,23,24,25,26,27,28', '1', 0, 0, 0, 0, 1372020982, 1372021005, 16, '1-1', 'm', 0, 2000),
(175, '29,30,31,32,33,34,35,36', '1', 0, 0, 0, 0, 1372021032, 1372021047, 12, '4-2', 'm', 0, 2000),
(176, '37,38,39,40,41,42,43,44,45,46', '1', 0, 0, 0, 0, 1372021309, 1372021325, 11, '2-3', 'm', 0, 2500),
(177, '47,48,49,50,51,52,53,54,55,56', '259', 0, 0, 0, 0, 1372064793, 1372064817, 5, '3-1', 'm', 0, 474),
(178, '57,58,59,60,61,62,63,64,65,66,67,68', '259', 0, 0, 0, 0, 1372064973, 1372064988, 11, '5-3', 'm', 0, 400),
(179, '69,70,71,72,73,74,75,76,77,78', '259', 0, 0, 0, 0, 1372065853, 1372065881, 14, '4-5', 'm', 0, 1000),
(180, '79,80,81,82,83,84,85,86,87,88,89,90', '259', 0, 0, 0, 0, 1372065940, 1372065956, 15, '2-1', 'm', 0, 190),
(181, '1,2,3,4,5,6,7,8,9,10,11,12', '1', 0, 0, 0, 0, 1372077754, 1372077931, 5, '3-1', 'm', 0, 400),
(182, '1,2,3,4,5,6,7,8,9,10,11,12', '1', 0, 0, 0, 0, 1372078075, 1372078139, 11, '5-3', 'm', 0, 1200),
(183, '1,2,3,4,5,6,7,8,9,10,11,12', '1', 0, 0, 0, 0, 1372078584, 1372078623, 20, '3-3', 'm', 0, 3000),
(184, '13,14,15,16,17,18,19,20,21,22', '1', 0, 0, 0, 0, 1372078671, 1372078702, 21, '3-2', 'm', 0, 2500),
(185, '23,24,25,26,27,28,29,30,31,32', '1', 0, 0, 0, 0, 1372078739, 1372078771, 11, '2-3', 'm', 0, 2500),
(186, '33,34,35,36,37,38', '259', 0, 0, 0, 0, 1372083505, 1372083572, 5, '3-1', 'm', 0, 600),
(187, '39,40,41,42,43,44,45,46,47,48,49,50', '259', 0, 0, 0, 0, 1372083687, 1372083720, 12, '3-2', 'm', 0, 1200),
(188, '51,52,53,54,55,56,57,58,59,60,61,62', '259', 0, 0, 0, 0, 1372083813, 1372083869, 14, '4-1', 'm', 0, 3000),
(189, '63,64,65,66,67,68,69,70', '259', 0, 0, 0, 0, 1372084171, 1372084212, 20, '3-3', 'm', 0, 2000),
(190, '1,2,3,4,5,6,7,8,9,10,11,12', '1', 0, 0, 0, 0, 1372411921, 1372412042, 5, '3-1', 'm', 0, 1200),
(191, '13,14,15,16,17,18,19,20,21,22,23,24', '1', 0, 0, 0, 0, 1372412172, 1372412200, 11, '5-3', 'm', 0, 1200),
(192, '25,26,27,28,29,30,31,32,33,34,35,36', '1', 0, 0, 0, 0, 1372412296, 1372412312, 13, '6-2', 'm', 0, 1200),
(193, '37,38,39,40,41,42,43,44,45,46', '1', 0, 0, 0, 0, 1372412547, 1372412563, 14, '5-1', 'm', 0, 1750),
(194, '47,48,49,50,51,52,53,54', '1', 0, 0, 0, 0, 1372412798, 1372412841, 16, '1-1', 'm', 0, 2000),
(195, '55,56,57,58,59,60,61,62', '1', 0, 0, 0, 0, 1372412961, 1372413122, 12, '4-2', 'm', 0, 2000),
(196, '1,2,3,4,5,6,7,8,9,10', '1', 0, 0, 0, 0, 1372587631, 1372587664, 20, '3-3', 'm', 0, 2500),
(197, '11,12,13,14,15,16,17,18,19,20', '1', 0, 0, 0, 0, 1372587711, 1372587737, 13, '1-5', 'm', 0, 1750),
(198, '21,22,23,24,25,26,27,28,29,30', '1', 0, 0, 0, 0, 1372587760, 1372587781, 11, '2-3', 'm', 0, 2500),
(199, '31,32,33,34,35,36,37,38', '1', 0, 0, 0, 0, 1372588016, 1372588039, 12, '4-2', 'm', 0, 2000),
(200, '39,40,41,42,43,44,45,46,47,48,49,50', '1', 0, 0, 0, 0, 1372588101, 1372588115, 14, '4-5', 'm', 0, 1200);

-- --------------------------------------------------------

-- 
--   `jump`
-- 

DROP TABLE IF EXISTS `jump`;
CREATE TABLE IF NOT EXISTS `jump` (
  `id` int(11) NOT NULL auto_increment,
  `in_card` int(11) NOT NULL,
  `card` int(11) NOT NULL,
  `in_koord` varchar(8) NOT NULL,
  `koord` varchar(8) NOT NULL,
  `ukey` varchar(255) NOT NULL,
  `in_title` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;

-- 
--    `jump`
-- 

INSERT INTO `jump` (`id`, `in_card`, `card`, `in_koord`, `koord`, `ukey`, `in_title`, `title`) VALUES (4, 1, 4, '3-10', '2-3', '08fd044006c7dfd2ef4d9a7e11abac41', ',  ', ',  '),
(3, 4, 1, '2-3', '3-10', '08fd044006c7dfd2ef4d9a7e11abac41', ',  ', ',  '),
(5, 5, 1, '3-3', '3-1', '8addf4e89618fe7b19b4b262a8f5fdbb', ',    [1]', ',  '),
(6, 1, 5, '3-1', '3-3', '8addf4e89618fe7b19b4b262a8f5fdbb', ',  ', ',    [1]'),
(7, 6, 1, '2-4', '5-8', 'd83d6752ba2005ba111645ea6b427a8a', ',  ,  1', ',  '),
(8, 1, 6, '5-8', '2-4', 'd83d6752ba2005ba111645ea6b427a8a', ',  ', ',  ,  1'),
(9, 8, 7, '3-4', '1-6', '71e283468977d987d6d6cd82c8a468a7', ',  ,  ', ',  '),
(10, 7, 8, '1-6', '3-4', '71e283468977d987d6d6cd82c8a468a7', ',  ', ',  ,  '),
(11, 7, 9, '6-6', '1-4', '9dc96973b4d0e6dfaa6148d9ae24d330', ',  ', ',  ,   '),
(12, 9, 7, '1-4', '6-6', '9dc96973b4d0e6dfaa6148d9ae24d330', ',  ,   ', ',  '),
(13, 5, 11, '1-2', '5-2', '0b725d08c052dc1edb8c5c2ceb6ff715', ',    ', ',   '),
(14, 11, 5, '5-2', '1-2', '0b725d08c052dc1edb8c5c2ceb6ff715', ',   ', ',    '),
(15, 11, 12, '2-1', '4-5', 'ba6918c8e9f1c13c6d9a85d9afe5d27d', ',   ', ', '),
(16, 12, 11, '4-5', '2-1', 'ba6918c8e9f1c13c6d9a85d9afe5d27d', ', ', ',   '),
(17, 13, 11, '7-3', '1-2', '54aaee1f7ab67d748bc89d3c5ea2b352', ', ', ',   '),
(18, 11, 13, '1-2', '7-3', '54aaee1f7ab67d748bc89d3c5ea2b352', ',   ', ', '),
(19, 14, 13, '5-3', '1-3', '2c1f1cb85dcc4a4f5594dcf67e11ff28', ',  ', ', '),
(20, 13, 14, '1-3', '5-3', '2c1f1cb85dcc4a4f5594dcf67e11ff28', ', ', ',  '),
(21, 15, 14, '5-2', '1-3', '7cbe20361a27e4cb59a5254b22208a30', ',   ', ',  '),
(22, 14, 15, '1-3', '5-2', '7cbe20361a27e4cb59a5254b22208a30', ',  ', ',   '),
(23, 15, 7, '3-3', '3-1', 'c39fff0f91e3e7d759d69befc8a79f9a', ',   ', ',  '),
(24, 7, 15, '3-1', '3-3', 'c39fff0f91e3e7d759d69befc8a79f9a', ',  ', ',   '),
(25, 16, 12, '3-2', '1-3', '947cf74c1c0b9fa39cbd4fed02a869f7', ',    ', ', '),
(26, 12, 16, '1-3', '3-2', '947cf74c1c0b9fa39cbd4fed02a869f7', ', ', ',    '),
(27, 14, 16, '3-1', '1-3', '0ad69fbd1a200da6a9b2c164014eb871', ',  ', ',    '),
(28, 16, 14, '1-3', '3-1', '0ad69fbd1a200da6a9b2c164014eb871', ',    ', ',  '),
(29, 17, 13, '7-4', '4-5', 'e28a83769b379a8a5da1fb4947bb64f5', ', ', ', '),
(30, 13, 17, '4-5', '7-4', 'e28a83769b379a8a5da1fb4947bb64f5', ', ', ', '),
(31, 17, 14, '1-1', '3-5', '05e14d9ab0e0f72993fdb94baea1248f', ', ', ',  '),
(32, 14, 17, '3-5', '1-1', '05e14d9ab0e0f72993fdb94baea1248f', ',  ', ', '),
(33, 18, 17, '2-4', '3-4', '50e8a8e3a5ce94889e313a8aaa48a16c', ', , ', ', '),
(34, 17, 18, '3-4', '2-4', '50e8a8e3a5ce94889e313a8aaa48a16c', ', ', ', , '),
(35, 19, 17, '2-4', '2-6', 'dd2ec7ebca8a5ac499432970d1429c03', ', , ', ', '),
(36, 17, 19, '2-6', '2-4', 'dd2ec7ebca8a5ac499432970d1429c03', ', ', ', , '),
(37, 20, 17, '3-1', '1-5', '3dc30c15ab0cdc04a714010c631e8868', ',   ', ', '),
(38, 17, 20, '1-5', '3-1', '3dc30c15ab0cdc04a714010c631e8868', ', ', ',   '),
(39, 21, 20, '1-4', '3-3', 'c551952816ddf4acea3fed30683502e7', ',   ', ',   '),
(40, 20, 21, '3-3', '1-4', 'c551952816ddf4acea3fed30683502e7', ',   ', ',   '),
(41, 21, 11, '5-3', '1-3', '500c315d501bc3b72e963015fa62dfd8', ',   ', ',   '),
(42, 11, 21, '1-3', '5-3', '500c315d501bc3b72e963015fa62dfd8', ',   ', ',   '),
(43, 22, 7, '1-2', '6-3', '7b9d67d5ada75326f2de68843255703d', ',    ', ',  '),
(44, 7, 22, '6-3', '1-2', '7b9d67d5ada75326f2de68843255703d', ',  ', ',    '),
(45, 23, 22, '1-1', '3-4', 'dd58aee1ec538e98b58bb131fe4f1abf', ', ', ',    '),
(46, 22, 23, '3-4', '1-1', 'dd58aee1ec538e98b58bb131fe4f1abf', ',    ', ', '),
(47, 23, 20, '5-1', '1-3', '83aa3809bd2bb300085703a24b1c1303', ', ', ',   '),
(48, 20, 23, '1-3', '5-1', '83aa3809bd2bb300085703a24b1c1303', ',   ', ', ');

-- --------------------------------------------------------

-- 
--   `location`
-- 

DROP TABLE IF EXISTS `location`;
CREATE TABLE IF NOT EXISTS `location` (
  `id` int(11) NOT NULL auto_increment,
  `s` varchar(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  `fraktion` varchar(64) default NULL,
  `emission` enum('0','1') default '0',
  `active` enum('0','1') NOT NULL default '0',
  `card` text,
  `monstr` text,
  `anomal` text,
  `artefact` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

-- 
--    `location`
-- 

INSERT INTO `location` (`id`, `s`, `name`, `fraktion`, `emission`, `active`, `card`, `monstr`, `anomal`, `artefact`) VALUES (1, '5-10', ',  ', '', '1', '0', '2-1#zabor2:2-3#zabor2:2-5#zabor2:2-7#zabor2:4-7#zabor2:4-5#zabor2:4-3#zabor2:4-1#zabor2:1-2#izba:1-3#zabor:1-4#izba:1-5#zabor:1-6#izba:1-7#zabor:1-8#izba:1-9#zabor:2-9#zabor2:4-9#zabor2:5-6#izba:5-4#izba:5-2#izba:5-3#zabor:5-5#zabor:5-7#zabor:5-9#zabor:1-1#zabor:5-1#zabor:3-2#yestrava:3-3#yestrava:3-4#yestrava:3-5#yestrava:3-6#yestrava:3-7#yestrava:3-8#yestrava:3-9#yestrava:3-10#yesdoor:2-6#yestrava:4-6#yestrava:2-8#yestrava:4-8#yestrava:2-4#yestrava:4-4#yestrava:2-2#yestrava:4-2#yestrava:1-10#izba:5-10#izba:3-1#yesdoor:5-8#dooryesdom1:', '', '', ''),
(4, '3-3', ',  ', NULL, '', '', '2-1#yestorg:2-3#yesdoor:1-2#yesshag:3-2#yesshag:1-1#blok:3-1#blok:1-3#yesshag:3-3#yesshag:2-2#yesshag:', '', NULL, NULL),
(5, '5-3', ',    ', NULL, '1', '0', '1-2#yesdoor:2-2#yesshag:3-2#yesshag:4-2#yesshag:5-2#yesshag:1-1#yestrava:2-1#yestrava:3-1#yestrava:4-1#yestrava:5-1#yestrava:1-3#yestrava:2-3#yestrava:3-3#yesdoor:4-3#yestrava:5-3#yestrava:', '3-1#pes:4-1#pes:5-1#pes:', '1-1#50jar:2-1#50nuc:', '2-1#Krovkamnya:1-1#Lomotmyasa:'),
(6, '4-4', ',  ,  1', NULL, '', '', '2-4#yesdoor:1-4#yesshag:3-4#yesshag:4-4#yesshag:2-3#yesshag:1-3#yesshag:3-3#yesshag:4-2#stena2:3-2#stena6:1-1#yesmedik:4-1#yestexnic:1-2#stena2:2-2#yesshag:2-1#yesshag:3-1#yesshag:4-3#yesshag:', NULL, '', NULL),
(7, '6-8', ',  ', NULL, '1', '', '3-1#yesdoor:2-1#stena2:1-1#stena2:4-1#stena2:5-1#stena2:6-1#stena2:6-6#dooryesdom1:1-6#dooryesdom1:1-5#stena2:2-5#stena2:3-5#stena2:5-5#stena2:6-5#stena2:1-2#stena1:1-3#stena1:1-4#stena1:6-2#stena1:6-3#yesdoor:6-4#stena1:1-8#stena2:2-8#stena2:3-8#stena2:4-8#stena2:5-8#stena2:6-8#stena2:6-7#stena1:1-7#stena1:2-2#yestrava:3-2#yestrava:4-2#yestrava:5-2#yestrava:2-3#yestrava:2-4#yestrava:4-5#yestrava:3-4#yestrava:4-4#yestrava:5-4#yestrava:5-3#yestrava:3-3#yestrava:4-3#yestrava:2-6#yestrava:3-6#yestrava:4-6#yestrava:5-6#yestrava:2-7#yestrava:3-7#yestrava:4-7#yestrava:5-7#yestrava:', NULL, '', NULL),
(8, '3-5', ',  ,  ', NULL, '', '', '3-4#yesdoor:3-5#yesshag:2-5#yestorg:1-5#yesshag:1-4#yesshag:2-4#yesshag:1-3#yestexnic:2-3#yesshag:3-3#yesshag:3-2#yesshag:2-2#yesshag:1-2#yesshag:1-1#yesshag:2-1#yesshag:3-1#yesshag:', NULL, NULL, NULL),
(9, '3-5', ',  ,  ', NULL, '', '', '1-4#yesdoor:1-1#yesshag:2-1#yesshag:3-1#yesshag:1-2#yesshag:2-2#yesshag:3-2#yesshag:1-3#yesshag:2-3#yesshag:3-3#yesshag:2-4#yesshag:3-4#yesshag:1-5#yesshag:2-5#yesshag:3-5#yesshag:', NULL, NULL, NULL),
(12, '7-5', ', ', NULL, '1', '1', '4-5#yesdoor:3-5#zabor:2-5#zabor:1-5#zabor:5-5#zabor:6-5#zabor:7-5#zabor:1-4#blok:2-4#blok:1-1#blok:2-1#blok:2-2#blok:1-2#blok:5-3#blok:5-2#yesdoor:5-1#blok:6-1#blok:7-1#blok:6-2#blok:7-2#blok:6-3#blok:7-3#blok:1-3#yesdoor:2-3#yestrava:3-3#yestrava:3-4#yestrava:4-4#yestrava:5-4#yestrava:6-4#yestrava:7-4#yesdoor:4-3#yestrava:3-2#yestrava:4-2#yestrava:3-1#stena2:4-1#stena2:', '3-2#pes:4-2#kab:', '3-4#50psi:', '3-4#Lunnyisvet:'),
(11, '5-3', ',   ', NULL, '1', '1', '1-2#yesdoor:2-2#yesshag:3-2#yesshag:4-2#yesshag:5-2#yesdoor:1-1#yestrava:2-1#yesdoor:3-1#yestrava:4-1#yestrava:5-1#yestrava:5-3#yestrava:4-3#yestrava:3-3#yestrava:2-3#yestrava:1-3#yesdoor:', '3-3#kab:4-3#plo:5-3#pes:2-3#pso:', '5-1#50nuc:4-1#50nuc:3-1#50nuc:2-1#50nuc:1-1#50nuc:', '4-1#Vyvert:'),
(13, '7-5', ', ', NULL, '1', '', '7-3#yesdoor:6-3#yesshag:5-3#yesshag:4-3#yesshag:3-3#yesshag:2-3#yesshag:1-3#yesdoor:3-2#stena1:3-1#stena3:4-1#stena2:5-1#stena4:5-2#stena1:4-2#yesshag:6-1#yestrava:7-1#yestrava:6-2#yestrava:7-2#yestrava:7-4#yestrava:7-5#yestrava:6-4#yestrava:6-5#yestrava:5-5#yestrava:5-4#yestrava:4-4#yestrava:4-5#yesdoor:1-2#yestrava:2-2#yestrava:2-1#yestrava:1-1#yestrava:1-4#yestrava:2-4#yestrava:3-4#yestrava:3-5#yestrava:2-5#yestrava:1-5#yestrava:', '6-2#pes:1-1#pso:1-5#plo:7-5#kab:', '1-4#50nuc:2-4#50nuc:3-4#50nuc:4-4#50nuc:5-4#50nuc:6-4#50nuc:7-4#50nuc:7-2#50jar:2-2#50jar:', '2-4#Plamya:'),
(14, '5-5', ',  ', NULL, '1', '1', '5-3#yesdoor:3-5#yesdoor:3-1#yesdoor:1-3#yesdoor:2-3#yesshag:3-3#yesshag:4-3#yesshag:1-1#blok:1-2#blok:1-4#blok:1-5#blok:2-4#yestrava:3-4#yestrava:4-4#yestrava:5-4#yestrava:2-5#yestrava:4-5#yestrava:5-5#yestrava:2-1#yestrava:2-2#yestrava:3-2#yestrava:4-2#yestrava:5-2#yestrava:4-1#yestrava:5-1#yestrava:', '4-1#kab:5-1#plo:4-5#pes:', '5-5#100jar:', '5-5#Kristall:'),
(15, '5-3', ',   ', NULL, '1', '', '5-2#yesdoor:4-2#yesshag:3-2#yesshag:2-2#yesshag:1-2#yesdoor:1-3#yestrava:2-3#yestrava:3-3#yesdoor:4-3#yestrava:5-3#yestrava:1-1#yestrava:2-1#yestrava:3-1#yestrava:4-1#yestrava:5-1#yestrava:', '1-1#pes:2-1#pso:', '3-1#150nuc:', '3-1#Kristall:'),
(16, '3-3', ',    ', NULL, '1', '1', '3-2#yesdoor:1-3#yesdoor:1-1#yestrava:2-1#yestrava:3-1#yestrava:2-2#yestrava:1-2#yestrava:2-3#yestrava:3-3#yestrava:', '1-1#kab:2-3#pso:', '1-2#50nuc:', '1-2#Krovkamnya:'),
(17, '7-7', ', ', NULL, '1', '1', '1-1#yesdoor:2-1#blok:2-2#blok:2-3#blok:3-1#blok:3-2#blok:3-3#blok:2-4#blok:3-4#yesdoor:1-6#blok:1-7#blok:2-6#yesdoor:2-7#blok:3-6#blok:3-7#blok:4-6#blok:4-7#blok:5-6#blok:5-7#blok:6-7#blok:6-6#blok:6-5#blok:6-4#blok:5-4#blok:5-5#blok:5-3#blok:6-3#blok:7-2#yestrava:7-7#yestrava:7-6#yestrava:7-5#yestrava:7-4#yesdoor:7-3#yestrava:7-1#yestrava:4-1#yestrava:5-1#yestrava:6-1#yestrava:6-2#yestrava:4-2#yestrava:5-2#yestrava:4-3#yestrava:4-4#yestrava:4-5#yestrava:3-5#yestrava:2-5#yestrava:1-5#yesdoor:1-4#yestrava:1-3#yestrava:1-2#yestrava:', '2-6#plo:', '7-1#100jar:', '7-1#Maminybusy:'),
(18, '2-4', ', , ', NULL, '', '', '1-1#yesshag:2-1#yesshag:1-2#yesshag:2-2#yesshag:2-3#yesshag:1-3#yesshag:2-4#yesdoor:1-4#yesshag:', NULL, '1-4#200nuc:', '1-4#Kristall:'),
(19, '6-5', ', , ', NULL, '', '1', '1-4#yesshag:1-5#yesshag:2-4#yesdoor:2-5#yesshag:3-4#yesshag:3-5#yesshag:4-4#yesshag:4-5#yesshag:5-4#yesshag:5-5#yesshag:6-5#yesshag:6-4#yesshag:6-3#yesshag:5-3#yesshag:5-2#yesshag:6-2#yesshag:6-1#yesshag:5-1#yesshag:', '6-5#plo:6-2#plo:3-5#pes:', '2-5#100jar:', '2-5#Ogennyishar:'),
(20, '3-4', ',   ', NULL, '1', '1', '3-1#yesdoor:2-1#yestrava:1-1#yestrava:1-2#yestrava:2-2#yestrava:3-2#yestrava:1-3#yesdoor:2-3#yestrava:3-3#yesdoor:1-4#yestrava:2-4#yestrava:3-4#yestrava:', '3-3#pso:3-4#kab:1-4#pes:', '2-4#75nuc:', '2-4#Krovkamnya:'),
(21, '5-5', ',   ', NULL, '1', '1', '1-1#yestrava:2-1#yestrava:3-1#yestrava:4-1#yestrava:5-1#yestrava:1-2#yestrava:2-2#yestrava:3-2#yestrava:4-2#yestrava:5-2#yestrava:1-3#yestrava:2-3#yestrava:3-3#yestrava:4-3#yestrava:5-3#yesdoor:1-4#yesdoor:2-4#yestrava:3-4#yestrava:4-4#yestrava:5-4#yestrava:1-5#yestrava:2-5#yestrava:3-5#yestrava:4-5#yestrava:5-5#yestrava:', '3-5#kab:4-5#plo:2-2#pes:3-2#pso:', '5-5#50nuc:2-5#50jar:', '2-5#Vyvert:5-5#Lomotmyasa:'),
(22, '3-5', ',    ', NULL, '', '', '3-4#yesdoor:1-1#yestrava:2-1#yestrava:3-1#yestrava:1-2#yesdoor:2-2#yestrava:3-2#yestrava:1-3#yestrava:2-3#yestrava:3-3#yestrava:1-4#yestrava:2-4#yestrava:1-5#yestrava:2-5#yestrava:3-5#yestrava:', NULL, '1-1#50nuc:2-1#75nuc:3-1#50nuc:2-2#50nuc:3-2#50nuc:3-3#50nuc:2-3#75nuc:1-3#75nuc:1-4#50nuc:2-4#50nuc:3-4#50nuc:3-5#50nuc:2-5#50nuc:1-5#50nuc:', '2-4#Plamya:2-2#Kristall:3-1#Krovkamnya:'),
(23, '5-1', ', ', NULL, '', '', '1-1#yesdoor:2-1#yesshag:3-1#yesshag:4-1#yesshag:5-1#yesdoor:', NULL, '5-1#50ele:4-1#50ele:3-1#50ele:2-1#50ele:1-1#50ele:', '3-1#Bengalskiiogon:');

-- --------------------------------------------------------

-- 
--   `logs`
-- 

DROP TABLE IF EXISTS `logs`;
CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(11) NOT NULL auto_increment,
  `locid` int(11) NOT NULL,
  `coord` varchar(16) NOT NULL,
  `freq` varchar(32) NOT NULL,
  `time` int(11) default NULL,
  `post` varchar(2048) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=268 DEFAULT CHARSET=utf8 AUTO_INCREMENT=268 ;

-- 
--    `logs`
-- 

INSERT INTO `logs` (`id`, `locid`, `coord`, `freq`, `time`, `post`) VALUES (1, 20, '3-3', '20#3-3', 1372587638, ' 7  5-45 (Union)'),
(2, 20, '3-3', '20#3-3', 1372587638, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     191'),
(3, 20, '3-3', '20#3-3', 1372587639, '  [1] !'),
(4, 20, '3-3', '20#3-3', 1372587639, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(5, 20, '3-3', '20#3-3', 1372587639, ' 7  5-45 (Union)'),
(6, 20, '3-3', '20#3-3', 1372587639, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     59'),
(7, 20, '3-3', '20#3-3', 1372587640, ' 7  5-45 (Union)'),
(8, 20, '3-3', '20#3-3', 1372587640, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     206'),
(9, 20, '3-3', '20#3-3', 1372587641, '  [2] !'),
(10, 20, '3-3', '20#3-3', 1372587641, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(11, 20, '3-3', '20#3-3', 1372587641, ' 7  5-45 (Union)'),
(12, 20, '3-3', '20#3-3', 1372587641, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     44'),
(13, 20, '3-3', '20#3-3', 1372587642, ' 7  5-45 (Union)'),
(14, 20, '3-3', '20#3-3', 1372587642, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     191'),
(15, 20, '3-3', '20#3-3', 1372587644, '  [3] !'),
(16, 20, '3-3', '20#3-3', 1372587644, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(17, 20, '3-3', '20#3-3', 1372587644, ' 7  5-45 (Union)'),
(18, 20, '3-3', '20#3-3', 1372587644, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     59'),
(19, 20, '3-3', '20#3-3', 1372587645, ' 7  5-45 (Union)'),
(20, 20, '3-3', '20#3-3', 1372587645, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     195'),
(21, 20, '3-3', '20#3-3', 1372587646, '  [4] !'),
(22, 20, '3-3', '20#3-3', 1372587646, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(23, 20, '3-3', '20#3-3', 1372587646, ' 7  5-45 (Union)'),
(24, 20, '3-3', '20#3-3', 1372587646, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     55'),
(25, 20, '3-3', '20#3-3', 1372587648, ' 7  5-45 (Union)'),
(26, 20, '3-3', '20#3-3', 1372587648, '<a href="?l=uinf&id=1">Union</a>   [5],  -74/2,     209'),
(27, 20, '3-3', '20#3-3', 1372587650, '  [5] !'),
(28, 20, '3-3', '20#3-3', 1372587650, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(29, 20, '3-3', '20#3-3', 1372587650, ' 7  5-45 (Union)'),
(30, 20, '3-3', '20#3-3', 1372587650, '<a href="?l=uinf&id=1">Union</a>   [5],  -74/2,     41'),
(31, 20, '3-3', '20#3-3', 1372587651, ' 7  5-45 (Union)'),
(32, 20, '3-3', '20#3-3', 1372587651, '<a href="?l=uinf&id=1">Union</a>   [6],  -74/2,     173'),
(33, 20, '3-3', '20#3-3', 1372587652, '  [6] !'),
(34, 20, '3-3', '20#3-3', 1372587652, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(35, 20, '3-3', '20#3-3', 1372587652, ' 7  5-45 (Union)'),
(36, 20, '3-3', '20#3-3', 1372587652, '<a href="?l=uinf&id=1">Union</a>   [6],  -74/2,     77'),
(37, 20, '3-3', '20#3-3', 1372587654, ' 7  5-45 (Union)'),
(38, 20, '3-3', '20#3-3', 1372587654, '<a href="?l=uinf&id=1">Union</a>   [7],  -74/2,     198'),
(39, 20, '3-3', '20#3-3', 1372587656, '  [7] !'),
(40, 20, '3-3', '20#3-3', 1372587656, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(41, 20, '3-3', '20#3-3', 1372587656, ' 7  5-45 (Union)'),
(42, 20, '3-3', '20#3-3', 1372587656, '<a href="?l=uinf&id=1">Union</a>   [7],  -74/2,     52'),
(43, 20, '3-3', '20#3-3', 1372587657, ' 7  5-45 (Union)'),
(44, 20, '3-3', '20#3-3', 1372587657, '<a href="?l=uinf&id=1">Union</a>   [8],  -74/2,     198'),
(45, 20, '3-3', '20#3-3', 1372587659, '  [8] !'),
(46, 20, '3-3', '20#3-3', 1372587659, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(47, 20, '3-3', '20#3-3', 1372587659, ' 7  5-45 (Union)'),
(48, 20, '3-3', '20#3-3', 1372587659, '<a href="?l=uinf&id=1">Union</a>   [8],  -74/2,     52'),
(49, 20, '3-3', '20#3-3', 1372587660, ' 7  5-45 (Union)'),
(50, 20, '3-3', '20#3-3', 1372587660, '<a href="?l=uinf&id=1">Union</a>   [9],  -74/2,     195'),
(51, 20, '3-3', '20#3-3', 1372587661, '  [9] !'),
(52, 20, '3-3', '20#3-3', 1372587661, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(53, 20, '3-3', '20#3-3', 1372587661, ' 7  5-45 (Union)'),
(54, 20, '3-3', '20#3-3', 1372587661, '<a href="?l=uinf&id=1">Union</a>   [9],  -74/2,     55'),
(55, 20, '3-3', '20#3-3', 1372587663, ' 7  5-45 (Union)'),
(56, 20, '3-3', '20#3-3', 1372587663, '<a href="?l=uinf&id=1">Union</a>   [10],  -74/2,     202'),
(57, 20, '3-3', '20#3-3', 1372587664, '  [10] !'),
(58, 20, '3-3', '20#3-3', 1372587664, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(59, 20, '3-3', '20#3-3', 1372587664, ' 7  5-45 (Union)'),
(60, 20, '3-3', '20#3-3', 1372587664, '<a href="?l=uinf&id=1">Union</a>   [10],  -74/2,     48'),
(61, 20, '3-3', '20#3-3', 1372587664, '    2452 '),
(62, 13, '1-5', '13#1-5', 1372587714, '  [1] !'),
(63, 13, '1-5', '13#1-5', 1372587714, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(64, 13, '1-5', '13#1-5', 1372587714, ' 7  5-45 (Union)'),
(65, 13, '1-5', '13#1-5', 1372587714, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     175'),
(66, 13, '1-5', '13#1-5', 1372587716, '  [2] !'),
(67, 13, '1-5', '13#1-5', 1372587716, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(68, 13, '1-5', '13#1-5', 1372587716, ' 7  5-45 (Union)'),
(69, 13, '1-5', '13#1-5', 1372587716, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     175'),
(70, 13, '1-5', '13#1-5', 1372587717, ' 7  5-45 (Union)'),
(71, 13, '1-5', '13#1-5', 1372587717, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     161'),
(72, 13, '1-5', '13#1-5', 1372587718, '  [3] !'),
(73, 13, '1-5', '13#1-5', 1372587718, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(74, 13, '1-5', '13#1-5', 1372587718, ' 7  5-45 (Union)'),
(75, 13, '1-5', '13#1-5', 1372587718, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     14'),
(76, 13, '1-5', '13#1-5', 1372587719, ' 7  5-45 (Union)'),
(77, 13, '1-5', '13#1-5', 1372587719, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     172'),
(78, 13, '1-5', '13#1-5', 1372587720, '  [4] !'),
(79, 13, '1-5', '13#1-5', 1372587720, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(80, 13, '1-5', '13#1-5', 1372587720, ' 7  5-45 (Union)'),
(81, 13, '1-5', '13#1-5', 1372587720, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     3'),
(82, 13, '1-5', '13#1-5', 1372587721, ' 7  5-45 (Union)'),
(83, 13, '1-5', '13#1-5', 1372587721, '<a href="?l=uinf&id=1">Union</a>   [5],  -74/2,     150'),
(84, 13, '1-5', '13#1-5', 1372587723, ' 1  9-19 (Union)'),
(85, 13, '1-5', '13#1-5', 1372587723, '<a href="?l=uinf&id=1">Union</a>   [5],  ,     20'),
(86, 13, '1-5', '13#1-5', 1372587725, '  [5] !'),
(87, 13, '1-5', '13#1-5', 1372587725, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(88, 13, '1-5', '13#1-5', 1372587725, ' 1  9-19 (Union)'),
(89, 13, '1-5', '13#1-5', 1372587725, '<a href="?l=uinf&id=1">Union</a>   [5],  ,     5'),
(90, 13, '1-5', '13#1-5', 1372587726, '  [6] !'),
(91, 13, '1-5', '13#1-5', 1372587726, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(92, 13, '1-5', '13#1-5', 1372587726, ' 7  5-45 (Union)'),
(93, 13, '1-5', '13#1-5', 1372587726, '<a href="?l=uinf&id=1">Union</a>   [6],  -74/2,     175'),
(94, 13, '1-5', '13#1-5', 1372587727, ' 7  5-45 (Union)'),
(95, 13, '1-5', '13#1-5', 1372587727, '<a href="?l=uinf&id=1">Union</a>   [7],  -74/2,     161'),
(96, 13, '1-5', '13#1-5', 1372587729, '  [7] !'),
(97, 13, '1-5', '13#1-5', 1372587729, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(98, 13, '1-5', '13#1-5', 1372587729, ' 1  9-19 (Union)'),
(99, 13, '1-5', '13#1-5', 1372587729, '<a href="?l=uinf&id=1">Union</a>   [7],  ,     14'),
(100, 13, '1-5', '13#1-5', 1372587731, '  [8] !'),
(101, 13, '1-5', '13#1-5', 1372587731, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(102, 13, '1-5', '13#1-5', 1372587731, ' 7  5-45 (Union)'),
(103, 13, '1-5', '13#1-5', 1372587731, '<a href="?l=uinf&id=1">Union</a>   [8],  -74/2,     175'),
(104, 13, '1-5', '13#1-5', 1372587732, '  [9] !'),
(105, 13, '1-5', '13#1-5', 1372587732, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(106, 13, '1-5', '13#1-5', 1372587732, ' 7  5-45 (Union)'),
(107, 13, '1-5', '13#1-5', 1372587732, '<a href="?l=uinf&id=1">Union</a>   [9],  -74/2,     175'),
(108, 13, '1-5', '13#1-5', 1372587733, ' 7  5-45 (Union)'),
(109, 13, '1-5', '13#1-5', 1372587733, '<a href="?l=uinf&id=1">Union</a>   [10],  -74/2,     157'),
(110, 13, '1-5', '13#1-5', 1372587735, ' 1  9-19 (Union)'),
(111, 13, '1-5', '13#1-5', 1372587735, '<a href="?l=uinf&id=1">Union</a>   [10],  ,     15'),
(112, 13, '1-5', '13#1-5', 1372587737, '  [10] !'),
(113, 13, '1-5', '13#1-5', 1372587737, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(114, 13, '1-5', '13#1-5', 1372587737, ' 1  9-19 (Union)'),
(115, 13, '1-5', '13#1-5', 1372587737, '<a href="?l=uinf&id=1">Union</a>   [10],  ,     3'),
(116, 13, '1-5', '13#1-5', 1372587737, '    1747 '),
(117, 11, '2-3', '11#2-3', 1372587763, ' 7  5-45 (Union)'),
(118, 11, '2-3', '11#2-3', 1372587763, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     111'),
(119, 11, '2-3', '11#2-3', 1372587763, '  [1] !'),
(120, 11, '2-3', '11#2-3', 1372587763, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(121, 11, '2-3', '11#2-3', 1372587763, ' 7  5-45 (Union)'),
(122, 11, '2-3', '11#2-3', 1372587763, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     139'),
(123, 11, '2-3', '11#2-3', 1372587764, ' 7  5-45 (Union)'),
(124, 11, '2-3', '11#2-3', 1372587764, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     198'),
(125, 11, '2-3', '11#2-3', 1372587765, '  [2] !'),
(126, 11, '2-3', '11#2-3', 1372587765, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(127, 11, '2-3', '11#2-3', 1372587765, ' 7  5-45 (Union)'),
(128, 11, '2-3', '11#2-3', 1372587765, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     52'),
(129, 11, '2-3', '11#2-3', 1372587766, ' 7  5-45 (Union)'),
(130, 11, '2-3', '11#2-3', 1372587766, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     111'),
(131, 11, '2-3', '11#2-3', 1372587767, '  [3] !'),
(132, 11, '2-3', '11#2-3', 1372587767, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(133, 11, '2-3', '11#2-3', 1372587767, ' 7  5-45 (Union)'),
(134, 11, '2-3', '11#2-3', 1372587767, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     139'),
(135, 11, '2-3', '11#2-3', 1372587768, ' 7  5-45 (Union)'),
(136, 11, '2-3', '11#2-3', 1372587768, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     136'),
(137, 11, '2-3', '11#2-3', 1372587768, '  [4] !'),
(138, 11, '2-3', '11#2-3', 1372587768, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(139, 11, '2-3', '11#2-3', 1372587768, ' 7  5-45 (Union)'),
(140, 11, '2-3', '11#2-3', 1372587768, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     114'),
(141, 11, '2-3', '11#2-3', 1372587769, ' 7  5-45 (Union)'),
(142, 11, '2-3', '11#2-3', 1372587769, '<a href="?l=uinf&id=1">Union</a>   [5],  -74/2,     111'),
(143, 11, '2-3', '11#2-3', 1372587770, '  [5] !'),
(144, 11, '2-3', '11#2-3', 1372587770, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(145, 11, '2-3', '11#2-3', 1372587770, ' 7  5-45 (Union)'),
(146, 11, '2-3', '11#2-3', 1372587770, '<a href="?l=uinf&id=1">Union</a>   [5],  -74/2,     139'),
(147, 11, '2-3', '11#2-3', 1372587771, ' 7  5-45 (Union)'),
(148, 11, '2-3', '11#2-3', 1372587771, '<a href="?l=uinf&id=1">Union</a>   [6],  -74/2,     166'),
(149, 11, '2-3', '11#2-3', 1372587772, '  [6] !'),
(150, 11, '2-3', '11#2-3', 1372587772, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(151, 11, '2-3', '11#2-3', 1372587772, ' 7  5-45 (Union)'),
(152, 11, '2-3', '11#2-3', 1372587772, '<a href="?l=uinf&id=1">Union</a>   [6],  -74/2,     84'),
(153, 11, '2-3', '11#2-3', 1372587773, ' 7  5-45 (Union)'),
(154, 11, '2-3', '11#2-3', 1372587773, '<a href="?l=uinf&id=1">Union</a>   [7],  -74/2,     107'),
(155, 11, '2-3', '11#2-3', 1372587774, '  [7] !'),
(156, 11, '2-3', '11#2-3', 1372587774, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(157, 11, '2-3', '11#2-3', 1372587774, ' 7  5-45 (Union)'),
(158, 11, '2-3', '11#2-3', 1372587774, '<a href="?l=uinf&id=1">Union</a>   [7],  -74/2,     143'),
(159, 11, '2-3', '11#2-3', 1372587775, ' 7  5-45 (Union)'),
(160, 11, '2-3', '11#2-3', 1372587775, '<a href="?l=uinf&id=1">Union</a>   [8],  -74/2,     115'),
(161, 11, '2-3', '11#2-3', 1372587776, '  [8] !'),
(162, 11, '2-3', '11#2-3', 1372587776, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(163, 11, '2-3', '11#2-3', 1372587776, ' 7  5-45 (Union)'),
(164, 11, '2-3', '11#2-3', 1372587776, '<a href="?l=uinf&id=1">Union</a>   [8],  -74/2,     135'),
(165, 11, '2-3', '11#2-3', 1372587776, ' 7  5-45 (Union)'),
(166, 11, '2-3', '11#2-3', 1372587776, '<a href="?l=uinf&id=1">Union</a>   [9],  -74/2,     162'),
(167, 11, '2-3', '11#2-3', 1372587777, '  [9] !'),
(168, 11, '2-3', '11#2-3', 1372587777, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(169, 11, '2-3', '11#2-3', 1372587777, ' 7  5-45 (Union)'),
(170, 11, '2-3', '11#2-3', 1372587777, '<a href="?l=uinf&id=1">Union</a>   [9],  -74/2,     88'),
(171, 11, '2-3', '11#2-3', 1372587778, ' 7  5-45 (Union)'),
(172, 11, '2-3', '11#2-3', 1372587778, '<a href="?l=uinf&id=1">Union</a>   [10],  -74/2,     187'),
(173, 11, '2-3', '11#2-3', 1372587781, '  [10] !'),
(174, 11, '2-3', '11#2-3', 1372587781, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(175, 11, '2-3', '11#2-3', 1372587781, ' 7  5-45 (Union)'),
(176, 11, '2-3', '11#2-3', 1372587781, '<a href="?l=uinf&id=1">Union</a>   [10],  -74/2,     63'),
(177, 11, '2-3', '11#2-3', 1372587781, '    2437 '),
(178, 12, '4-2', '12#4-2', 1372588019, ' 11  5-45 (Union)'),
(179, 12, '4-2', '12#4-2', 1372588019, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     194'),
(180, 12, '4-2', '12#4-2', 1372588026, '  [1] !'),
(181, 12, '4-2', '12#4-2', 1372588026, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(182, 12, '4-2', '12#4-2', 1372588026, ' 11  5-45 (Union)'),
(183, 12, '4-2', '12#4-2', 1372588026, '<a href="?l=uinf&id=1">Union</a>   [1],  -74/2,     56'),
(184, 12, '4-2', '12#4-2', 1372588027, ' 11  5-45 (Union)'),
(185, 12, '4-2', '12#4-2', 1372588027, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     183'),
(186, 12, '4-2', '12#4-2', 1372588029, '  [2] !'),
(187, 12, '4-2', '12#4-2', 1372588029, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(188, 12, '4-2', '12#4-2', 1372588029, ' 11  5-45 (Union)'),
(189, 12, '4-2', '12#4-2', 1372588029, '<a href="?l=uinf&id=1">Union</a>   [2],  -74/2,     67'),
(190, 12, '4-2', '12#4-2', 1372588031, '  [3] !'),
(191, 12, '4-2', '12#4-2', 1372588031, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(192, 12, '4-2', '12#4-2', 1372588031, ' 11  5-45 (Union)'),
(193, 12, '4-2', '12#4-2', 1372588031, '<a href="?l=uinf&id=1">Union</a>   [3],  -74/2,     250'),
(194, 12, '4-2', '12#4-2', 1372588032, ' 11  5-45 (Union)'),
(195, 12, '4-2', '12#4-2', 1372588032, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     171'),
(196, 12, '4-2', '12#4-2', 1372588033, '  [4] !'),
(197, 12, '4-2', '12#4-2', 1372588033, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(198, 12, '4-2', '12#4-2', 1372588033, ' 11  5-45 (Union)'),
(199, 12, '4-2', '12#4-2', 1372588033, '<a href="?l=uinf&id=1">Union</a>   [4],  -74/2,     79'),
(200, 12, '4-2', '12#4-2', 1372588034, '  [5] !'),
(201, 12, '4-2', '12#4-2', 1372588034, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(202, 12, '4-2', '12#4-2', 1372588034, ' 11  5-45 (Union)'),
(203, 12, '4-2', '12#4-2', 1372588034, '<a href="?l=uinf&id=1">Union</a>   [5],  -74/2,     250'),
(204, 12, '4-2', '12#4-2', 1372588035, '  [6] !'),
(205, 12, '4-2', '12#4-2', 1372588035, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(206, 12, '4-2', '12#4-2', 1372588035, ' 11  5-45 (Union)'),
(207, 12, '4-2', '12#4-2', 1372588035, '<a href="?l=uinf&id=1">Union</a>   [6],  -74/2,     250'),
(208, 12, '4-2', '12#4-2', 1372588036, '  [7] !'),
(209, 12, '4-2', '12#4-2', 1372588036, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(210, 12, '4-2', '12#4-2', 1372588036, ' 11  5-45 (Union)'),
(211, 12, '4-2', '12#4-2', 1372588036, '<a href="?l=uinf&id=1">Union</a>   [7],  -74/2,     250'),
(212, 12, '4-2', '12#4-2', 1372588037, ' 11  5-45 (Union)'),
(213, 12, '4-2', '12#4-2', 1372588037, '<a href="?l=uinf&id=1">Union</a>   [8],  -74/2,     223'),
(214, 12, '4-2', '12#4-2', 1372588039, '  [8] !'),
(215, 12, '4-2', '12#4-2', 1372588039, '<a href="?l=uinf&id=1">Union</a>  1 .   '),
(216, 12, '4-2', '12#4-2', 1372588039, ' 2  9-19 (Union)'),
(217, 12, '4-2', '12#4-2', 1372588039, '<a href="?l=uinf&id=1">Union</a>   [8],  ,     27'),
(218, 12, '4-2', '12#4-2', 1372588039, '    1973 '),
(219, 14, '4-5', '14#4-5', 1372588104, '   [1] !'),
(220, 14, '4-5', '14#4-5', 1372588104, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(221, 14, '4-5', '14#4-5', 1372588104, ' 11  5-45 (Union)'),
(222, 14, '4-5', '14#4-5', 1372588104, '<a href="?l=uinf&id=1">Union</a>    [1],  -74/2,     100'),
(223, 14, '4-5', '14#4-5', 1372588105, '   [2] !'),
(224, 14, '4-5', '14#4-5', 1372588105, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(225, 14, '4-5', '14#4-5', 1372588105, ' 11  5-45 (Union)'),
(226, 14, '4-5', '14#4-5', 1372588105, '<a href="?l=uinf&id=1">Union</a>    [2],  -74/2,     100'),
(227, 14, '4-5', '14#4-5', 1372588107, '   [3] !'),
(228, 14, '4-5', '14#4-5', 1372588107, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(229, 14, '4-5', '14#4-5', 1372588107, ' 11  5-45 (Union)'),
(230, 14, '4-5', '14#4-5', 1372588107, '<a href="?l=uinf&id=1">Union</a>    [3],  -74/2,     100'),
(231, 14, '4-5', '14#4-5', 1372588108, '   [4] !'),
(232, 14, '4-5', '14#4-5', 1372588108, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(233, 14, '4-5', '14#4-5', 1372588108, ' 11  5-45 (Union)'),
(234, 14, '4-5', '14#4-5', 1372588108, '<a href="?l=uinf&id=1">Union</a>    [4],  -74/2,     100'),
(235, 14, '4-5', '14#4-5', 1372588109, '   [5] !'),
(236, 14, '4-5', '14#4-5', 1372588109, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(237, 14, '4-5', '14#4-5', 1372588109, ' 11  5-45 (Union)'),
(238, 14, '4-5', '14#4-5', 1372588109, '<a href="?l=uinf&id=1">Union</a>    [5],  -74/2,     100'),
(239, 14, '4-5', '14#4-5', 1372588109, '   [6] !'),
(240, 14, '4-5', '14#4-5', 1372588109, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(241, 14, '4-5', '14#4-5', 1372588109, ' 11  5-45 (Union)'),
(242, 14, '4-5', '14#4-5', 1372588109, '<a href="?l=uinf&id=1">Union</a>    [6],  -74/2,     100'),
(243, 14, '4-5', '14#4-5', 1372588110, '   [7] !'),
(244, 14, '4-5', '14#4-5', 1372588110, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(245, 14, '4-5', '14#4-5', 1372588110, ' 11  5-45 (Union)'),
(246, 14, '4-5', '14#4-5', 1372588110, '<a href="?l=uinf&id=1">Union</a>    [7],  -74/2,     100'),
(247, 14, '4-5', '14#4-5', 1372588111, '   [8] !'),
(248, 14, '4-5', '14#4-5', 1372588111, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(249, 14, '4-5', '14#4-5', 1372588111, ' 11  5-45 (Union)'),
(250, 14, '4-5', '14#4-5', 1372588111, '<a href="?l=uinf&id=1">Union</a>    [8],  -74/2,     100'),
(251, 14, '4-5', '14#4-5', 1372588113, '   [9] !'),
(252, 14, '4-5', '14#4-5', 1372588113, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(253, 14, '4-5', '14#4-5', 1372588113, ' 11  5-45 (Union)'),
(254, 14, '4-5', '14#4-5', 1372588113, '<a href="?l=uinf&id=1">Union</a>    [9],  -74/2,     100'),
(255, 14, '4-5', '14#4-5', 1372588113, '   [10] !'),
(256, 14, '4-5', '14#4-5', 1372588113, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(257, 14, '4-5', '14#4-5', 1372588113, ' 11  5-45 (Union)'),
(258, 14, '4-5', '14#4-5', 1372588113, '<a href="?l=uinf&id=1">Union</a>    [10],  -74/2,     100'),
(259, 14, '4-5', '14#4-5', 1372588114, '   [11] !'),
(260, 14, '4-5', '14#4-5', 1372588114, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(261, 14, '4-5', '14#4-5', 1372588114, ' 11  5-45 (Union)'),
(262, 14, '4-5', '14#4-5', 1372588114, '<a href="?l=uinf&id=1">Union</a>    [11],  -74/2,     100'),
(263, 14, '4-5', '14#4-5', 1372588115, '   [12] !'),
(264, 14, '4-5', '14#4-5', 1372588115, '<a href="?l=uinf&id=1">Union</a>  1 .    '),
(265, 14, '4-5', '14#4-5', 1372588115, ' 11  5-45 (Union)'),
(266, 14, '4-5', '14#4-5', 1372588115, '<a href="?l=uinf&id=1">Union</a>    [12],  -74/2,     100'),
(267, 14, '4-5', '14#4-5', 1372588115, '    1100 ');

-- --------------------------------------------------------

-- 
--   `mail`
-- 

DROP TABLE IF EXISTS `mail`;
CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) default NULL,
  `user_login` varchar(32) default NULL,
  `id_kont` int(11) default NULL,
  `kont_login` varchar(32) NOT NULL,
  `time` int(11) default NULL,
  `msg` varchar(1024) default NULL,
  `read` set('0','1') default '0',
  PRIMARY KEY  (`id`),
  KEY `id_user` (`id_user`,`id_kont`),
  KEY `read` (`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
--    `mail`
-- 


-- --------------------------------------------------------

-- 
--   `monstr`
-- 

DROP TABLE IF EXISTS `monstr`;
CREATE TABLE IF NOT EXISTS `monstr` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(32) default NULL,
  `p` enum('u','m') NOT NULL default 'u',
  `pol` smallint(1) NOT NULL default '1',
  `pass` varchar(64) default NULL,
  `inkey` varchar(256) default NULL,
  `datereg` int(11) default NULL,
  `mails` varchar(64) default NULL,
  `accept` smallint(2) default '0',
  `uptime` int(11) NOT NULL,
  `r_key` varchar(256) default NULL,
  `ava` varchar(16) default '1.png',
  `locatid` int(11) default '1',
  `coord` varchar(8) NOT NULL,
  `level` smallint(6) default '0',
  `exp` int(11) NOT NULL,
  `kredits` float default '0',
  `energy` int(11) NOT NULL,
  `live` int(11) NOT NULL,
  `fight` int(11) default NULL,
  `fight_com` varchar(1) NOT NULL,
  `upfight` int(11) NOT NULL,
  `massa` float NOT NULL,
  `maxmassa` float NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;

-- 
--    `monstr`
-- 

INSERT INTO `monstr` (`id`, `login`, `p`, `pol`, `pass`, `inkey`, `datereg`, `mails`, `accept`, `uptime`, `r_key`, `ava`, `locatid`, `coord`, `level`, `exp`, `kredits`, `energy`, `live`, `fight`, `fight_com`, `upfight`, `massa`, `maxmassa`) VALUES (1, ' [1]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587639, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(2, ' [2]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587641, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(3, ' [3]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587644, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(4, ' [4]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587646, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(5, ' [5]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587650, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(6, ' [6]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587652, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(7, ' [7]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587656, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(8, ' [8]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587659, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(9, ' [9]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587661, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(10, ' [10]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587664, NULL, 'pso.gif', 20, '3-3', 3, 53, 0, 248, 0, 196, 'a', 0, 0, 0),
(11, ' [1]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587714, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 174, 0, 197, 'a', 0, 0, 0),
(12, ' [2]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587716, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 174, 0, 197, 'a', 0, 0, 0),
(13, ' [3]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587718, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 173, 0, 197, 'a', 0, 0, 0),
(14, ' [4]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587720, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 173, 0, 197, 'a', 0, 0, 0),
(15, ' [5]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587725, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 172, 0, 197, 'a', 0, 0, 0),
(16, ' [6]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587726, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 174, 0, 197, 'a', 0, 0, 0),
(17, ' [7]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587729, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 173, 0, 197, 'a', 0, 0, 0),
(18, ' [8]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587731, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 174, 0, 197, 'a', 0, 0, 0),
(19, ' [9]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587732, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 174, 0, 197, 'a', 0, 0, 0),
(20, ' [10]', 'm', 0, 'plo.at', '', NULL, NULL, 0, 1372587737, NULL, 'plo.gif', 13, '1-5', 2, 52, 0, 172, 0, 197, 'a', 0, 0, 0),
(21, ' [1]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587763, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(22, ' [2]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587765, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(23, ' [3]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587767, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(24, ' [4]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587768, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(25, ' [5]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587770, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(26, ' [6]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587772, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(27, ' [7]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587774, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(28, ' [8]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587776, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(29, ' [9]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587777, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(30, ' [10]', 'm', 0, 'pso.at', '', NULL, NULL, 0, 1372587781, NULL, 'pso.gif', 11, '2-3', 3, 53, 0, 248, 0, 198, 'a', 0, 0, 0),
(31, ' [1]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588026, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 248, 0, 199, 'a', 0, 0, 0),
(32, ' [2]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588029, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 248, 0, 199, 'a', 0, 0, 0),
(33, ' [3]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588031, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 249, 0, 199, 'a', 0, 0, 0),
(34, ' [4]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588033, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 248, 0, 199, 'a', 0, 0, 0),
(35, ' [5]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588034, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 249, 0, 199, 'a', 0, 0, 0),
(36, ' [6]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588035, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 249, 0, 199, 'a', 0, 0, 0),
(37, ' [7]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588036, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 249, 0, 199, 'a', 0, 0, 0),
(38, ' [8]', 'm', 1, 'kab.at', '', NULL, NULL, 0, 1372588039, NULL, 'kab.gif', 12, '4-2', 2, 51, 0, 248, 0, 199, 'a', 0, 0, 0),
(39, '  [1]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588104, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(40, '  [2]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588105, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(41, '  [3]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588107, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(42, '  [4]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588108, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(43, '  [5]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588109, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(44, '  [6]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588109, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(45, '  [7]', 'm', 0, 'pes.at', '', NULL, NULL, 0, 1372588110, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(46, '  [8]', 'm', 0, 'pes.at', '', NULL, NULL, 0, 1372588111, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(47, '  [9]', 'm', 0, 'pes.at', '', NULL, NULL, 0, 1372588113, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(48, '  [10]', 'm', 0, 'pes.at', '', NULL, NULL, 0, 1372588113, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(49, '  [11]', 'm', 1, 'pes.at', '', NULL, NULL, 0, 1372588114, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0),
(50, '  [12]', 'm', 0, 'pes.at', '', NULL, NULL, 0, 1372588115, NULL, 'pes.jpg', 14, '4-5', 1, 39, 0, 99, 0, 200, 'a', 0, 0, 0);

-- --------------------------------------------------------

-- 
--   `protect_all_visits`
-- 

DROP TABLE IF EXISTS `protect_all_visits`;
CREATE TABLE IF NOT EXISTS `protect_all_visits` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL,
  `date` int(11) NOT NULL,
  `count` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=3468 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3468 ;

-- 
--    `protect_all_visits`
-- 

INSERT INTO `protect_all_visits` (`id`, `ip`, `date`, `count`) VALUES (3467, '127.0.0.1', 1372244595, 0);

-- --------------------------------------------------------

-- 
--   `protect_black_list_ip`
-- 

DROP TABLE IF EXISTS `protect_black_list_ip`;
CREATE TABLE IF NOT EXISTS `protect_black_list_ip` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(15) default NULL,
  `addtime` int(11) NOT NULL,
  `ban_time` int(11) NOT NULL,
  `client` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
--    `protect_black_list_ip`
-- 


-- --------------------------------------------------------

-- 
--   `protect_exceptions`
-- 

DROP TABLE IF EXISTS `protect_exceptions`;
CREATE TABLE IF NOT EXISTS `protect_exceptions` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(15) default NULL,
  `addtime` int(11) default NULL,
  `id_add` int(11) default NULL,
  `nick_add` varchar(32) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
--    `protect_exceptions`
-- 


-- --------------------------------------------------------

-- 
--   `rukzak`
-- 

DROP TABLE IF EXISTS `rukzak`;
CREATE TABLE IF NOT EXISTS `rukzak` (
  `id` int(11) NOT NULL auto_increment,
  `uid` int(11) default NULL,
  `card_id` int(11) NOT NULL,
  `coord` varchar(8) NOT NULL,
  `name` varchar(64) default NULL,
  `type` varchar(32) default NULL,
  `incode` varchar(32) default NULL,
  `ico` varchar(16) default NULL,
  `massa` float default NULL,
  `price` float default NULL,
  `kol` smallint(6) default NULL,
  `type_name` varchar(64) default NULL,
  `slot` varchar(2) NOT NULL,
  `minlev` smallint(6) default NULL,
  `skor` smallint(6) default NULL,
  `povrej` smallint(6) default NULL,
  `tochn` smallint(6) default NULL,
  `dolgov` smallint(6) unsigned default NULL,
  `maxdolg` smallint(6) unsigned default NULL,
  `bron` smallint(6) default NULL,
  `antirad` smallint(6) default NULL,
  `antihim` smallint(6) default NULL,
  `antipsi` smallint(6) default NULL,
  `antitermo` smallint(6) default NULL,
  `plener` smallint(6) default NULL,
  `pllive` smallint(6) default NULL,
  `patron` varchar(16) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=302 DEFAULT CHARSET=utf8 AUTO_INCREMENT=302 ;

-- 
--    `rukzak`
-- 

INSERT INTO `rukzak` (`id`, `uid`, `card_id`, `coord`, `name`, `type`, `incode`, `ico`, `massa`, `price`, `kol`, `type_name`, `slot`, `minlev`, `skor`, `povrej`, `tochn`, `dolgov`, `maxdolg`, `bron`, `antirad`, `antihim`, `antipsi`, `antitermo`, `plener`, `pllive`, `patron`) VALUES (105, 262, 0, '', ' ', 'shmot', 'kurtstalk', '7.png', 0.75, 1200, 1, '', '3', 1, 0, 0, 0, 18, 20, 15, 5, 5, 0, 0, 0, 0, 'Patron9_18'),
(106, 262, 0, '', '', 'loruz', 'pmm', '5.png', 0.7, 600, 1, ' ', '2', 1, 1, 1, 60, 18, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron9_18'),
(107, 262, 0, '', ' 9-18', 'patron', 'Patron9_18', '34.png', 0.009, 0.25, 86, '', '', 0, 0, 15, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(167, 259, 0, '', '', 'oruz', 'obrez', '6.png', 1.2, 3948.75, 1, '', '5', 1, 3, 8, 60, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(168, 259, 0, '', '', 'loruz', 'pmm', '5.png', 0.7, 900, 1, ' ', '2', 1, 1, 2, 60, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron9_18'),
(170, 259, 0, '', ' 12 ', 'patron', 'Patron12', '38.png', 0.03, 0.5, 114, '', '', 1, 0, 50, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(210, 1, 0, '', '', 'medikal', 'Aptechka', '29.jpg', 0.05, 750, 6, '', '', 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 250, ''),
(211, 1, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '6', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(219, 1, 0, '', '', 'arts', 'Vyvert', '40.gif', -10, 12000, 1, '', '10', 5, 0, 0, 0, 1, 1, 5, 5, 0, 5, 1, 3, 3, ''),
(223, 1, 0, '', '', 'loruz', 'fora', '9.png', 0.75, 3988.66, 1, ' ', '2', 1, 2, 4, 65, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron9_19'),
(224, 1, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '7', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(232, 1, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '8', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(234, 1, 0, '', '', 'shmot', 'Zarya', '14.png', 3.5, 165739, 1, '', '3', 1, 0, 0, 0, 20, 20, 30, 13, 10, 1, 7, 0, 0, 'Patron9_18'),
(236, 1, 0, '', '', 'eda', 'zavtrtyr', '4.png', 0.6, 120, 14, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 10, ''),
(237, 1, 0, '', '', 'eda', 'hleb', '3.gif', 0.3, 40, 5, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 5, ''),
(238, 1, 0, '', '', 'eda', 'kolbasa', '2.png', 0.4, 75, 4, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 7, ''),
(239, 1, 0, '', ' 9-19', 'patron', 'Patron9_19', '35.png', 0.01, 0.3, 166, '', '', 0, 0, 25, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Patron9_18'),
(248, 1, 0, '', '-74/2', 'oruz', 'AKM742U', '13.png', 3.5, 33942.8, 1, '', '5', 5, 11, 2, 60, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron5_45'),
(257, 259, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '6', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(263, 1, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '9', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(270, 259, 0, '', '', 'arts', 'Vyvert', '40.gif', -10, 12000, 1, '', '7', 5, 0, 0, 0, 1, 1, 5, 5, 0, 5, 1, 3, 3, ''),
(274, 259, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '9', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(275, 259, 0, '', '', 'shmot', 'Zarya', '14.png', 3.5, 7000, 1, '', '3', 1, 0, 0, 0, 20, 20, 25, 10, 10, 0, 5, 0, 0, 'Patron9_18'),
(276, 259, 0, '', '', 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', '10', 1, 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(277, 259, 0, '', ' ', 'arts', 'Bengalskiiogon', '41.gif', 0.5, 10000, 1, '', '8', 1, 1, 5, 10, 1, 1, 5, 5, 0, 0, 250, 5, 0, ''),
(279, 259, 0, '', '', 'medikal', 'Aptechka', '29.jpg', 0.05, 750, 3, '', '', 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 250, ''),
(288, 1, 0, '', ' 5-45', 'patron', 'Patron5_45', '55.png', 0.015, 1.5, 1383, '', '', 3, 0, 50, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, '');

-- --------------------------------------------------------

-- 
--   `searsart`
-- 

DROP TABLE IF EXISTS `searsart`;
CREATE TABLE IF NOT EXISTS `searsart` (
  `id` int(11) NOT NULL auto_increment,
  `time` int(11) NOT NULL,
  `locid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `incode` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;

-- 
--    `searsart`
-- 

INSERT INTO `searsart` (`id`, `time`, `locid`, `uid`, `incode`) VALUES (1, 1371827515, 5, 1, 'Krovkamnya'),
(2, 1371827844, 5, 1, 'Krovkamnya'),
(3, 1371827858, 5, 1, 'Krovkamnya'),
(4, 1371827861, 5, 1, 'Krovkamnya'),
(5, 1371828246, 5, 1, ''),
(6, 1371828252, 5, 1, ''),
(7, 1371828405, 5, 1, ''),
(8, 1371828410, 5, 1, ''),
(9, 1371828436, 5, 1, ''),
(10, 1371828439, 5, 1, ''),
(11, 1371829192, 5, 1, ''),
(12, 1371829202, 5, 1, ''),
(13, 1371836426, 5, 1, 'Krovkamnya'),
(14, 1371838542, 5, 1, 'Krovkamnya'),
(15, 1371839222, 5, 1, ''),
(16, 1371840337, 5, 1, ''),
(17, 1371846115, 5, 259, 'Krovkamnya'),
(18, 1371847397, 5, 259, ''),
(19, 1371847426, 5, 259, ''),
(20, 1371847483, 5, 259, ''),
(21, 1371847976, 5, 259, ''),
(22, 1371848013, 5, 259, ''),
(23, 1371848017, 5, 259, ''),
(24, 1371904539, 5, 1, 'Krovkamnya'),
(25, 1371909227, 5, 259, 'Lomotmyasa'),
(26, 1371913653, 5, 1, 'Lomotmyasa'),
(27, 1371984185, 5, 1, 'Lomotmyasa'),
(28, 1372001311, 5, 1, 'Krovkamnya'),
(29, 1372003922, 5, 1, 'Krovkamnya'),
(30, 1372010232, 14, 1, 'Kristall'),
(31, 1372010456, 16, 1, 'Krovkamnya'),
(32, 1372011938, 5, 1, 'Lomotmyasa'),
(33, 1372012040, 11, 1, 'Vyvert'),
(34, 1372017908, 22, 1, 'Kristall'),
(35, 1372017932, 23, 1, 'Bengalskiiogon'),
(36, 1372018035, 5, 1, 'Krovkamnya'),
(37, 1372018241, 16, 1, 'Krovkamnya'),
(38, 1372018357, 14, 1, 'Kristall'),
(39, 1372018539, 18, 1, 'Kristall'),
(40, 1372019999, 5, 1, 'Krovkamnya'),
(41, 1372020022, 11, 1, 'Vyvert'),
(42, 1372020292, 21, 1, 'Vyvert'),
(43, 1372020423, 20, 1, 'Krovkamnya'),
(44, 1372020446, 23, 1, 'Bengalskiiogon'),
(45, 1372020471, 22, 1, 'Plamya'),
(46, 1372020948, 15, 1, 'Kristall'),
(47, 1372020966, 16, 1, 'Krovkamnya'),
(48, 1372021061, 12, 1, 'Lunnyisvet'),
(49, 1372065741, 14, 259, 'Kristall'),
(50, 1372078517, 22, 1, 'Kristall'),
(51, 1372078539, 23, 1, 'Bengalskiiogon'),
(52, 1372078566, 20, 1, 'Krovkamnya'),
(53, 1372078641, 21, 1, 'Vyvert'),
(54, 1372083584, 5, 259, 'Lomotmyasa'),
(55, 1372083612, 11, 259, 'Vyvert'),
(56, 1372083659, 12, 259, 'Lunnyisvet'),
(57, 1372083777, 16, 259, 'Krovkamnya'),
(58, 1372083906, 14, 259, 'Kristall'),
(59, 1372084114, 22, 259, 'Kristall'),
(60, 1372084130, 23, 259, 'Bengalskiiogon'),
(61, 1372412270, 11, 1, 'Vyvert'),
(62, 1372412363, 13, 1, 'Plamya'),
(63, 1372412522, 14, 1, 'Kristall'),
(64, 1372412901, 16, 1, 'Krovkamnya'),
(65, 1372412950, 12, 1, 'Lunnyisvet'),
(66, 1372587599, 22, 1, 'Kristall'),
(67, 1372587613, 23, 1, 'Bengalskiiogon'),
(68, 1372587627, 20, 1, 'Krovkamnya'),
(69, 1372587804, 11, 1, 'Vyvert'),
(70, 1372587817, 5, 1, 'Lomotmyasa'),
(71, 1372588049, 12, 1, 'Lunnyisvet'),
(72, 1372588080, 16, 1, 'Krovkamnya'),
(73, 1372588125, 14, 1, 'Kristall'),
(74, 1372588151, 15, 1, 'Kristall');

-- --------------------------------------------------------

-- 
--   `torgs`
-- 

DROP TABLE IF EXISTS `torgs`;
CREATE TABLE IF NOT EXISTS `torgs` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `ico` varchar(128) NOT NULL,
  `id_card` int(11) NOT NULL,
  `coord` varchar(8) NOT NULL,
  `tovars` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
--    `torgs`
-- 

INSERT INTO `torgs` (`id`, `name`, `ico`, `id_card`, `coord`, `tovars`) VALUES (1, '', '1.png', 4, '2-1', 'hleb3eda3.gif0.340kolbasa2eda2.png0.475zavtrtyr4eda4.png0.6120pmm5oruz5.png0.7500obrez6oruz6.png1.2650Gadyuka20oruz20.png2.73500kurtstalk7 shmot7.png0.751200Aptechka29medikal29.jpg0.05750Patron9_1834 9-18patron34.png0.0090.25Patron1238 12 patron38.png0.030.5Patron9_1935 9-19patron35.png0.010.3'),
(2, '', '2.png', 8, '2-5', 'kolbasa2eda2.png0.475hleb3eda3.gif0.340zavtrtyr4eda4.png0.6120Aptechka29medikal29.jpg0.05750pmm5loruz5.png0.7500 Patron5_4555 5-45patron55.png0.051.5Patron9_1935 9-19patron35.png0.010.3Patron9_1834 9-18patron34.png0.0090.25Zarya14shmot14.png3.57000toz3410-34oruz10.png1.5900Patron1238 12 patron38.png0.030.5Cheizer1311-13oruz11.png2.36000fora9loruz9.png0.75750 AKM742U13-74/2өoruz13.png3.512000');

-- --------------------------------------------------------

-- 
--   `tovar`
-- 

DROP TABLE IF EXISTS `tovar`;
CREATE TABLE IF NOT EXISTS `tovar` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL,
  `minlev` smallint(6) NOT NULL,
  `type` varchar(32) NOT NULL,
  `incode` varchar(32) NOT NULL,
  `ico` varchar(16) NOT NULL,
  `massa` float default NULL,
  `price` float default NULL,
  `kol` smallint(6) NOT NULL,
  `type_name` varchar(64) NOT NULL,
  `skor` smallint(6) NOT NULL,
  `povrej` smallint(6) NOT NULL,
  `tochn` smallint(6) NOT NULL,
  `dolgov` smallint(6) unsigned default NULL,
  `maxdolg` smallint(6) unsigned default NULL,
  `bron` smallint(6) NOT NULL,
  `antirad` smallint(6) NOT NULL,
  `antihim` smallint(6) NOT NULL,
  `antipsi` smallint(6) NOT NULL,
  `antitermo` smallint(6) NOT NULL,
  `plener` smallint(6) NOT NULL,
  `pllive` smallint(6) NOT NULL,
  `patron` varchar(16) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

-- 
--    `tovar`
-- 

INSERT INTO `tovar` (`id`, `name`, `minlev`, `type`, `incode`, `ico`, `massa`, `price`, `kol`, `type_name`, `skor`, `povrej`, `tochn`, `dolgov`, `maxdolg`, `bron`, `antirad`, `antihim`, `antipsi`, `antitermo`, `plener`, `pllive`, `patron`) VALUES (1, '', 0, 'eda', 'vodka', '1.png', 0.5, 200, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(2, '', 0, 'eda', 'kolbasa', '2.png', 0.4, 75, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 7, ''),
(3, '', 0, 'eda', 'hleb', '3.gif', 0.3, 40, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 5, ''),
(4, '', 0, 'eda', 'zavtrtyr', '4.png', 0.6, 120, 1, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 10, ''),
(5, '', 1, 'loruz', 'pmm', '5.png', 0.7, 500, 1, ' ', 1, 1, 50, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron9_18'),
(6, '', 1, 'oruz', 'obrez', '6.png', 1.2, 650, 1, '', 2, 5, 40, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(7, ' ', 1, 'shmot', 'kurtstalk', '7.png', 0.75, 1200, 1, '', 0, 0, 0, 20, 20, 15, 5, 5, 0, 0, 0, 0, 'Patron9_18'),
(8, ' ', 0, 'shmot', 'bandplash', '8.png', 1.2, 1500, 1, '', 0, 0, 0, 25, 25, 17, 10, 7, 5, 5, 0, 0, ''),
(9, '', 1, 'loruz', 'fora', '9.png', 0.75, 750, 1, ' ', 1, 2, 55, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron9_19'),
(10, '-34', 1, 'oruz', 'toz34', '10.png', 1.5, 900, 1, '', 2, 7, 50, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(11, '-13', 3, 'oruz', 'Cheizer13', '11.png', 2.3, 6000, 1, '', 2, 5, 40, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(12, '-14', 3, 'oruz', 'SPPS14', '12.png', 2.7, 9000, 1, '', 2, 7, 42, 25, 25, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(13, '-74/2', 5, 'oruz', 'AKM742U', '13.png', 3.5, 12000, 1, '', 7, 1, 50, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron5_45'),
(14, '', 1, 'shmot', 'Zarya', '14.png', 3.5, 7000, 1, '', 0, 0, 0, 20, 20, 25, 10, 10, 0, 5, 0, 0, 'Patron9_18'),
(30, '', 1, 'scan', '1Otklik', '30.png', 0.1, 200, 1, '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(16, ' ', 1, 'shmot', 'Vetersvobody', '16.png', 5, 7500, 1, '', 0, 0, 0, 35, 35, 45, 20, 10, 0, 10, 1, 1, ''),
(17, '', 5, 'loruz', 'HPSA', '17.png', 0.8, 1000, 1, ' ', 2, 2, 60, 30, 30, 0, 0, 0, 0, 0, 0, 0, 'Patron45'),
(18, '', 5, 'loruz', 'Marta', '18.png', 0.8, 1050, 1, ' ', 2, 5, 60, 30, 30, 0, 0, 0, 0, 0, 0, 0, 'Patron9_19'),
(19, '-9', 5, 'loruz', 'VolkerP9m', '19.png', 0.65, 1200, 1, ' ', 2, 5, 55, 35, 35, 0, 0, 0, 0, 0, 0, 0, 'Patron45'),
(20, '', 1, 'oruz', 'Gadyuka', '20.png', 2.7, 3500, 1, '', 5, 0, 30, 20, 20, 0, 0, 0, 0, 0, 0, 0, 'Patron9_19'),
(21, '-74', 3, 'oruz', 'AKM74', '21.png', 3.7, 18000, 1, '', 7, 3, 55, 25, 25, 0, 0, 0, 0, 0, 0, 0, 'Patron5_45'),
(22, '-86', 5, 'oruz', 'IL86', '22.png', 4.2, 28000, 1, '', 7, 4, 70, 25, 25, 0, 0, 0, 0, 0, 0, 0, 'Patron5_56'),
(23, '', 3, 'oruz', 'Abakan', '23.png', 3.7, 25000, 1, '', 8, 5, 70, 30, 30, 0, 0, 0, 0, 0, 0, 0, 'Patron5_45'),
(24, '', 3, 'oruz', 'Otboinik', '24.png', 5, 12000, 1, '', 3, 5, 35, 30, 30, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(31, '', 5, 'scan', 'Medved', '31.png', 0.25, 600, 1, '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(27, '', 5, 'shmot', 'Seva', '27.png', 9, 9000, 1, '', 0, 0, 0, 35, 35, 50, 50, 50, 50, 50, 1, 1, ''),
(29, '', 1, 'medikal', 'Aptechka', '29.jpg', 0.05, 750, 1, '', 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 250, ''),
(32, ' ', 1, 'medikal', 'Voenaptechka', '32.gif', 0.03, 1200, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 40, 500, 'Patron9_18'),
(33, ' ', 1, 'medikal', 'Nauchaptechka', '33.gif', 0.4, 1500, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 50, 750, 'Patron9_18'),
(34, ' 9-18', 0, 'patron', 'Patron9_18', '34.png', 0.009, 0.25, 1, '', 0, 15, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(35, ' 9-19', 0, 'patron', 'Patron9_19', '35.png', 0.01, 0.3, 1, '', 0, 25, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Patron9_18'),
(36, '', 0, 'granat', 'RGD', '36.png', 0.4, 1200, 1, '', 1, 1200, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(37, '-1', 0, 'granat', 'F1G', '37.png', 0.5, 3000, 1, '', 1, 3000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(38, ' 12 ', 1, 'patron', 'Patron12', '38.png', 0.03, 0.5, 1, '', 0, 50, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 'Patron12'),
(39, '  ', 1, 'chtm', 'hvostpes', '39.png', 0.15, 100, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 'Patron9_18'),
(40, '', 5, 'arts', 'Vyvert', '40.gif', -10, 12000, 1, '', 0, 0, 0, 1, 1, 5, 5, 0, 5, 1, 3, 3, ''),
(41, ' ', 1, 'arts', 'Bengalskiiogon', '41.gif', 0.5, 10000, 1, '', 1, 5, 10, 1, 1, 5, 5, 0, 0, 250, 5, 0, ''),
(42, '', 3, 'arts', 'Glaz', '42.png', 0.5, 16000, 1, '', 0, 0, 0, 1, 1, 10, 10, 10, 10, 10, 10, 10, ''),
(43, '', 3, 'arts', 'Dusha', '43.png', 0.5, 8000, 1, '', 1, 5, 25, 1, 1, 5, 0, 0, 10, 0, 1, 1, ''),
(44, '', 1, 'arts', 'Kristall', '44.gif', 0.5, 12000, 1, '', 0, 0, 0, 1, 1, 25, 10, 10, 0, 0, 0, 0, ''),
(45, ' ', 1, 'arts', 'Krovkamnya', '45.png', 0.5, 3000, 1, '', 0, 0, 0, 1, 1, 0, 0, 10, 0, 0, 1, 0, ''),
(46, ' ', 0, 'arts', 'Lomotmyasa', '46.gif', 0.5, 3000, 1, '', 0, 0, 0, 1, 1, 0, 0, 11, 0, 0, 0, 0, ''),
(47, ' ', 1, 'arts', 'Lunnyisvet', '47.gif', 0.5, 5000, 1, '', 0, 0, 0, 1, 1, 5, 5, 5, 5, 5, 1, 1, ''),
(48, ' ', 1, 'arts', 'Maminybusy', '48.png', 0.5, 5000, 1, '', 0, 0, 0, 1, 1, 0, 10, 0, 0, 0, 1, 5, ''),
(49, ' ', 3, 'arts', 'Ogennyishar', '49.gif', 0.5, 6000, 1, '', 1, 0, 25, 1, 1, 5, 0, 0, 0, 500, 10, 10, ''),
(50, '', 1, 'arts', 'Plamya', '50.png', 0.5, 6000, 1, '', 0, 0, 0, 1, 1, 0, 5, 5, 10, 25, 1, 1, ''),
(51, ' ', 0, 'chtm', 'Kopytokabana', '51.jpg', 0.3, 200, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(52, ' ', 0, 'chtm', 'Glazploti', '52.jpg', 0.25, 150, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(53, ' ', 3, 'chtm', 'Hvostpsevdosobaki', '53.gif', 0.15, 250, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(54, ' ', 1, 'chtm', 'Rukasnorka', '54.jpg', 0.3, 350, 1, '', 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(55, ' 5-45', 3, 'patron', 'Patron5_45', '55.png', 0.015, 1.5, 1, '', 0, 50, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(56, ' 5-56', 3, 'patron', 'Patron5_56', '56.gif', 0.017, 2.5, 1, '', 0, 65, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(57, ' .45', 3, 'patron', 'Patron45', '57.gif', 0.011, 1.25, 1, '', 0, 35, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(58, ' 9-39', 5, 'patron', 'Patron9_39', '58.gif', 0.02, 3, 1, '', 0, 75, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(59, '  ', 7, 'patron', 'batgauss', '59.gif', 0.25, 600, 1, '', 0, 25000, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, '');

-- --------------------------------------------------------

-- 
--   `user`
-- 

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(32) default NULL,
  `ref` int(11) default '0',
  `fraktion` varchar(64) NOT NULL,
  `rang` smallint(6) NOT NULL default '0',
  `emission` enum('0','1') NOT NULL default '0',
  `p` enum('u','m') NOT NULL default 'u',
  `pol` smallint(1) NOT NULL default '1',
  `pass` varchar(64) default NULL,
  `tm` smallint(4) NOT NULL,
  `pstr` smallint(6) default '7',
  `inkey` varchar(256) default NULL,
  `datereg` int(11) default NULL,
  `mails` varchar(64) default NULL,
  `accept` smallint(2) default '0',
  `uptime` int(11) NOT NULL,
  `r_key` varchar(256) default NULL,
  `ava` varchar(16) default '1.png',
  `locatid` int(11) default '1',
  `coord` varchar(8) NOT NULL,
  `level` smallint(6) default '0',
  `exp` int(11) NOT NULL,
  `kredits` float default '0',
  `energy` int(11) NOT NULL,
  `live` int(11) NOT NULL,
  `fight` int(11) default NULL,
  `fight_com` varchar(1) NOT NULL,
  `upfight` int(11) NOT NULL,
  `massa` float NOT NULL,
  `maxmassa` float NOT NULL,
  `resp` varchar(16) NOT NULL,
  `freq` varchar(16) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=264 DEFAULT CHARSET=utf8 AUTO_INCREMENT=264 ;

-- 
--    `user`
-- 

INSERT INTO `user` (`id`, `login`, `ref`, `fraktion`, `rang`, `emission`, `p`, `pol`, `pass`, `tm`, `pstr`, `inkey`, `datereg`, `mails`, `accept`, `uptime`, `r_key`, `ava`, `locatid`, `coord`, `level`, `exp`, `kredits`, `energy`, `live`, `fight`, `fight_com`, `upfight`, `massa`, `maxmassa`, `resp`, `freq`) VALUES (1, 'Union', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 6, 7, '2e25b1c93dff2e1f38cbc8e3f9022b0d', 1369478450, 'test@mail.ru', 77, 1372588522, '', '1.png', 8, '2-3', 5, 84114, 70785.9, 188, 37, 0, 'b', 1372588115, 33.955, 55, '6#2-3', ''),
(2, '', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 0, 0, '1a0b69ae07fd5db62b80a7dca491c3e3', 1369505595, NULL, 0, 1369505595, '', '', 1, '', NULL, 0, NULL, 0, 0, 0, '', 1370094095, 0, 0, '', ''),
(3, 'test', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 0, 0, 'c690cd21f3de34a6e312dab6ba94a9f8', 1369505669, NULL, 0, 1369505669, '', '', 1, '', NULL, 0, NULL, 0, 0, 0, '', 1370094095, 0, 0, '', ''),
(4, '', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 0, 0, '564e609418c9b04921362e0b492b3a77', 1369660728, NULL, 0, 1369660749, '', '', 1, '3-2', 0, 0, 0, -5, 0, 0, '', 1370094095, 0, 0, '', ''),
(259, 'Strelok', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 6, 10, 'fa99c9aa58c62ca7bd2e255c07339c52', 1370270815, 'test@.', 0, 1372512682, '', '1.png', 6, '2-3', 3, 9196, 5066.5, 256, 259, 0, 'b', 1372084212, 0.97, 55, '6#2-3', ''),
(261, '', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 0, 10, '8f605788ac81b2e0e59d17255bebec0f', 1370287301, 'test@mail.ru', 0, 1370287588, '', '1.png', 4, '2-1', 0, 0, 1000, 81, 100, NULL, '', 0, 0, 55, '6#2-3', ''),
(262, '', 1, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 0, 7, '3263a3a28a00373a2802c83e2550156e', 1370289849, NULL, 0, 1370293321, '', '1.png', 1, '1-4', 1, 297, 135, 230, 253, 0, 'b', 1370292924, 0, 55, '6#2-3', ''),
(263, '', 0, '', 0, '0', 'u', 1, 'e10adc3949ba59abbe56e057f20f883e', 0, 7, '012d930d7cc444a180815f376371cb47', 1372239506, NULL, 0, 1372244335, '', '1.png', 6, '2-1', 0, 0, 1000, 249, 250, NULL, '', 0, 0, 55, '6#2-3', '');
        