DROP TABLE IF EXISTS `categorys`;
CREATE TABLE `categorys` (
`id` int(9) NOT NULL auto_increment,
`parent` int(9) NOT NULL default '0',
`name` varchar(150) NOT NULL default '',
`desc` mediumtext NOT NULL,
`adult` int(1) NOT NULL default '0',
`position` int(9) NOT NULL default '0',
`acc_ext` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=cp1251;
INSERT INTO `categorys` VALUES (1, 0, 'MEЛОДИИ', 'Любые мелодии ,всех форматов', 0, 1, 'mmf| mid| amr| mp3| wav| aac|');
INSERT INTO `categorys` VALUES (59, 45, 'Sis игры', '', 0, 4, '');
INSERT INTO `categorys` VALUES (2, 1, 'MP3', '', 0, 1, '');
INSERT INTO `categorys` VALUES (3, 1, 'MMF', '', 0, 2, '');
INSERT INTO `categorys` VALUES (4, 1, 'MID', '', 0, 3, '');
INSERT INTO `categorys` VALUES (5, 1, 'AMR', '', 0, 4, '');
INSERT INTO `categorys` VALUES (6, 1, 'WAV', '', 0, 5, '');
INSERT INTO `categorys` VALUES (7, 1, 'AAC', '', 0, 6, '');
INSERT INTO `categorys` VALUES (48, 43, 'Jpg', '', 0, 2, '');
INSERT INTO `categorys` VALUES (49, 43, 'Jpe', '', 0, 3, '');
INSERT INTO `categorys` VALUES (50, 43, 'Png', '', 0, 4, '');
INSERT INTO `categorys` VALUES (51, 43, 'Jpeg', '', 0, 5, '');
INSERT INTO `categorys` VALUES (52, 46, 'Rar', '', 0, 1, '');
INSERT INTO `categorys` VALUES (53, 46, 'Zip', '', 0, 2, '');
INSERT INTO `categorys` VALUES (54, 46, 'Ext', '', 0, 3, '');
INSERT INTO `categorys` VALUES (55, 46, 'Gz', '', 0, 4, '');
INSERT INTO `categorys` VALUES (56, 45, 'Jad', '', 0, 1, '');
INSERT INTO `categorys` VALUES (57, 45, 'Jar', '', 0, 2, '');
INSERT INTO `categorys` VALUES (58, 45, 'Sis проги', '', 0, 3, '');
INSERT INTO `categorys` VALUES (61, 39, 'Видео', '', 0, 2, '');
INSERT INTO `categorys` VALUES (60, 45, 'Jar Проги', '', 0, 5, '');
INSERT INTO `categorys` VALUES (46, 0, 'АРХИВЫ,СКРИПТЫ', 'Любые архивы,php скрипты в ziр формате', 0, 8, '|rar|zip|ext|gz');
INSERT INTO `categorys` VALUES (39, 0, 'ПОРНО КАРТИНКИ,ВИДЕО', 'Картинки для взрослых и видео', 0, 7, '"/tmp/upload/4a984ac15686ea65d92166b87325b9489bf29d78dca9f1e51a6ad46a12cc75711/chatrix_50899.jpeg"');
INSERT INTO `categorys` VALUES (40, 39, 'XXX-Картинки', '', 1, 1, '');
INSERT INTO `categorys` VALUES (44, 43, 'Gif', '', 0, 1, '');
INSERT INTO `categorys` VALUES (45, 0, 'ИГРЫ,ПРОГРАМКИ', 'Игри и проги jаr,jаd,sis', 0, 6, 'jad|jar|sis');
INSERT INTO `categorys` VALUES (43, 0, 'КАРТИНКИ', 'Картинки,фотки.', 0, 5, 'jpeg|jpe|png|gif|jpg|');
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
`id` int(9) NOT NULL auto_increment,
`fid` int(9) NOT NULL default '0',
`author` varchar(150) NOT NULL default '',
`text` mediumtext NOT NULL,
`time` int(20) NOT NULL default '0',
`ip` varchar(150) NOT NULL default '',
`soft` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
`id` int(9) NOT NULL auto_increment,
`cat` int(9) NOT NULL default '0',
`refcat` int(9) NOT NULL default '0',
`filename` varchar(150) NOT NULL default '',
`desc` mediumtext NOT NULL,
`screen` varchar(150) NOT NULL default '',
`jad` varchar(150) NOT NULL default '',
`downloads` int(9) NOT NULL default '0',
`last_download` int(20) NOT NULL default '0',
`abuse` int(4) NOT NULL default '0',
`uploaded` int(20) NOT NULL default '0',
`author` varchar(100) NOT NULL default '0',
`ip` varchar(150) NOT NULL default '',
`soft` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=cp1251;
INSERT INTO `files` VALUES (11, 44, 43, 'files/43/44/voltage.gif', 'Jt', 'files/43/44/voltage_small31298.gif', '', 2, 1227278641, 1, 1227213824, '1|Admin', '91.203.96.63', 'Nokia6233');
INSERT INTO `files` VALUES (12, 44, 43, 'files/43/44/14j.gif', 'Хх', 'files/43/44/14j_small18023.gif', '', 3, 1227278630, 0, 1227257608, '1|Admin', '91.203.96.31', 'Nokia6233');
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(9) NOT NULL auto_increment,
`login` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`sex` int(1) NOT NULL default '0',
`city` varchar(100) NOT NULL default '',
`age` int(2) NOT NULL default '0',
`email` varchar(100) NOT NULL default '',
`icq` varchar(20) NOT NULL default '',
`upl_files` int(10) NOT NULL default '0',
`upl_files_size` int(30) NOT NULL default '0',
`dwl_files` int(10) NOT NULL default '0',
`dwl_files_size` int(30) NOT NULL default '0',
`dwl_filelist` text NOT NULL,
`comments` int(5) NOT NULL default '0',
`reg_date` int(20) NOT NULL default '0',
`level` int(2) NOT NULL default '0',
`session` varchar(50) NOT NULL default '',
`last` int(20) NOT NULL default '0',
`ver` varchar(10) NOT NULL default '',
`ip` varchar(15) NOT NULL default '',
`soft` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=cp1251 PACK_KEYS=0;
INSERT INTO `users` VALUES (1, 'Admin', '10101590', 'Костян', 1, 'Кривой Рог', 16, '[email protected]', '555555', 2, 36725, 0, 0, '', 0, 1213175588, 2, '', 1227258904, 'html', '91.203.96.31', 'Nokia6233');
INSERT INTO `users` VALUES (2, 'Stein', 'stein', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216276229, 0, 'iQOBgthFLM', 1216277376, 'html', '195.189.142.134', 'SonyEricssonK550i//R6B');
INSERT INTO `users` VALUES (3, 'A', 'aaa', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216303095, 0, 'gEpyvA1SXh', 1216303155, 'html', '195.189.142.82', 'Nokia6131/2.0');
INSERT INTO `users` VALUES (4, 'Bav2', '323232', 'Алексей', 1, 'Санкт-Петербург', 29, '[email protected]', '', 0, 0, 2, 473948, ':1:|:3:', 0, 1216304081, 0, 'Cj0zeqtbdH', 1216306779, 'html', '195.189.143.54', 'Nokia7260');
INSERT INTO `users` VALUES (5, '580982', '580982', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216305458, 0, 'sqB1Pl2HDp', 1216305544, 'html', '83.149.49.220', 'SonyEricssonW300i/R4EA');
INSERT INTO `users` VALUES (6, 'Zebra', '68903', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216305780, 0, 'QISV8YeETn', 1217009481, 'html', '91.145.223.54', 'Mozilla/5.0');
INSERT INTO `users` VALUES (7, 'kamaz540', '78363691720', 'Андрей', 1, 'Йошкар Ола', 20, '[email protected]', '498498635', 0, 0, 1, 27729, ':7:', 0, 1216305823, 0, '5qjRMdGDxl', 1216495347, 'html', '82.208.77.226', 'SonyEricssonK310i/R4DA');
INSERT INTO `users` VALUES (8, 'Ник', '1945', 'Игорь', 1, 'Россия', 53, '[email protected]', '', 0, 0, 0, 0, '', 0, 1216307574, 0, 'Sn6DjlsKiY', 1220142545, 'html', '217.148.51.192', 'Mozilla/5.0');
INSERT INTO `users` VALUES (9, 'trademark', '0000', 'дабл', 1, 'K?nig city', 21, '[email protected]', '', 0, 0, 0, 0, '', 0, 1216309868, 0, 'ZcV5k39i0P', 1216317377, 'html', '195.189.142.241', 'Opera/8.01');
INSERT INTO `users` VALUES (10, 'Shwartz', '1', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216310151, 0, 'MpDKXqxzAl', 1216613017, 'html', '217.74.162.146', 'Nokia5310XpressMusic/2');
INSERT INTO `users` VALUES (11, 'Пришелец', '3224', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216312977, 0, 'xA5z9mNJ6F', 1216312977, 'html', '213.87.76.173', '');
INSERT INTO `users` VALUES (12, 'Пришелец 2', '3224', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216313196, 0, 'bdG5rC3epP', 1216502638, 'html', '213.87.76.129', 'SAMSUNG-SGH-D900i/1.0');
INSERT INTO `users` VALUES (13, 'Дазл', '198727', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216314940, 0, '0JUurzb7k1', 1216315010, 'html', '91.203.96.13', 'SonyEricssonK550i//R6B');
INSERT INTO `users` VALUES (14, 'PEKO', '446299', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216314999, 0, 'sHyjRI82ab', 1216315093, 'html', '78.24.57.85', 'SEC-SGHX630/1.0');
INSERT INTO `users` VALUES (15, 'Fufai', '71050', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216320538, 0, 'm39gFRfxyk', 1219826948, 'html', '217.66.145.213', 'Nokia6111/2.0');
INSERT INTO `users` VALUES (16, 'Борода', '555666', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216321687, 0, 'bL7k0hYCp6', 1216322276, 'html', '195.189.142.44', 'NokiaN91-1');
INSERT INTO `users` VALUES (17, '9613687102', '174431', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216326949, 0, 'sN8cPvy4mq', 1218264796, 'html', '195.189.143.57', 'SonyEricssonK550i');
INSERT INTO `users` VALUES (18, 'Сашка87', '1003', 'Саша', 1, 'Беларусь', 21, '[email protected]', '', 0, 0, 0, 0, '', 0, 1216330338, 0, '0cktR6vKBZ', 1216501406, 'html', '195.189.142.243', 'Nokia6300/2.0');
INSERT INTO `users` VALUES (19, 'Aler', '888777', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216335077, 0, 'mA4JMLD5in', 1216335092, 'html', '90.138.155.44', 'SonyEricssonK610i/R1ED');
INSERT INTO `users` VALUES (20, 'Stils', '1987', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216337614, 0, 'Vqc3yK7LEj', 1216337673, 'html', '83.149.21.158', 'SonyEricssonK510i/R4EA');
INSERT INTO `users` VALUES (21, 'Leon7777', '10101966', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216338370, 0, 'bLFgB0tKnv', 1216338542, 'html', '193.239.129.206', 'SonyEricssonK550i/R1KG');
INSERT INTO `users` VALUES (22, 'Sedoia', '222222', 'Никола', 2, 'Амстердам', 21, '[email protected]', 'Ждём сообщений', 1, 259630, 0, 0, '', 0, 1216340155, 0, 'Sa98stYjh7', 1216384559, 'html', '89.20.97.87', 'SonyEricssonW810i/R4EA');
INSERT INTO `users` VALUES (23, 'avtoel', '1005', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216342403, 0, 'sE47Z0bOum', 1216342567, 'html', '83.149.0.228', 'MOT-K1/08.03.08R');
INSERT INTO `users` VALUES (24, 'Naik', '6791b', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216347646, 0, '', 1216347665, 'html', '91.203.96.13', 'NokiaN72');
INSERT INTO `users` VALUES (25, 'XxdenxX', 'ttttttt', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216357535, 0, 'gDehE7rpvb', 1216357859, 'html', '85.115.224.9', 'MOT-A1200r/1.0');
INSERT INTO `users` VALUES (26, 'duos', '0505', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216359501, 0, 'AmipDkd0Cn', 1216359654, 'html', '195.189.143.47', 'Opera/8.01');
INSERT INTO `users` VALUES (27, 'mister', 'vitalij', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216365042, 0, '2FVbsQ795N', 1216365344, 'html', '83.178.86.125', 'Mozilla/4.0');
INSERT INTO `users` VALUES (28, 'alexkaluga', '733080', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216365781, 0, 'lQtVTH82kx', 1216365896, 'html', '213.87.86.55', 'Mozilla/4.0');
INSERT INTO `users` VALUES (29, 'dawa', 'janysenka', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216365915, 0, 'u0Tld842rb', 1216425917, 'html', '91.145.216.127', 'NokiaN73-1/4.0812.4.2.');
INSERT INTO `users` VALUES (30, 'serqo26', '123456', '', 0, '', 0, '', '', 0, 0, 2, 871711, ':1:|:5:', 0, 1216367822, 0, '', 1216368493, 'html', '83.149.21.167', 'NokiaN70-1/5.0705.3.0.');
INSERT INTO `users` VALUES (32, 'Kav355', '193755', 'dead body', 1, 'Лучший :)', 0, '[email protected]', '478896687', 0, 0, 0, 0, '', 0, 1216370082, 0, 'Uth0xkmcg3', 1216432781, 'html', '217.148.51.6', 'NokiaN72/2.0635.2.0.2');
INSERT INTO `users` VALUES (31, 'Kelemet', '343434', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216368288, 0, '1dQFxgjRtp', 1216368385, 'html', '91.203.96.26', 'NokiaN72');
INSERT INTO `users` VALUES (33, 'den742', 'dadaja', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216376562, 0, 'ZIE0RnjN4P', 1216540611, 'html', '81.18.116.66', 'Nokia6233/2.0');
INSERT INTO `users` VALUES (34, 'Бомж', 'spise', '', 0, '', 0, '', '', 0, 0, 1, 9320, ':3:', 0, 1216381203, 0, 'ghJK0CFMTH', 1216382481, 'html', '130.244.196.90', 'Nokia6233/2.0');
INSERT INTO `users` VALUES (35, 'Bagroff', '030987', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216391732, 0, 'xlOJ1PhbFL', 1216391781, 'html', '195.189.142.41', 'Nokia6680');
INSERT INTO `users` VALUES (36, 'kuvik', '21278', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216392517, 0, 'QCZqc9raS1', 1216392780, 'html', '79.124.173.6', 'Nokia6230i/2.0');
INSERT INTO `users` VALUES (37, 'ЭРАГОРН', '2008', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216397361, 0, '4fOVGrSqAh', 1218218699, 'html', '91.203.96.32', 'Opera/9.50');
INSERT INTO `users` VALUES (38, '22222299', '99999922', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216418930, 0, '4yXsc1vrH8', 1216419098, 'html', '79.124.211.136', 'SonyEricssonK800i/R8BF');
INSERT INTO `users` VALUES (39, 'Prelest', '1989', '', 0, '', 0, '', '', 0, 0, 1, 259630, ':6:', 0, 1216428489, 0, 'al7tPjqhTV', 1216704811, 'html', '195.189.142.213', 'Nokia7500/2.0');
INSERT INTO `users` VALUES (40, 'Anasteishen', '7777', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216434233, 0, 'QFSnqdusMI', 1216434315, 'html', '195.189.143.56', 'Nokia6131');
INSERT INTO `users` VALUES (41, 'Maks', '0890', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216463004, 0, 'snMk96QDOv', 1216463131, 'html', '213.87.86.102', 'SIE-CF75/22');
INSERT INTO `users` VALUES (42, 'Luceus', '54823452', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216463755, 0, 'X3FgcnKxJs', 1216463755, 'html', '217.8.236.147', '');
INSERT INTO `users` VALUES (43, 'ZLODEI', '1812', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216467650, 0, 'H0xGt4ZAUq', 1216468381, 'html', '195.189.142.240', 'SonyEricssonK850i/R1CA');
INSERT INTO `users` VALUES (44, 'Ajk', 'Roman', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216477911, 0, '31CKbeIlST', 1216478236, 'html', '217.8.236.151', 'SAMSUNG-SGH-D500/1.0');
INSERT INTO `users` VALUES (45, 'Бодян!!!', '1111', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216481790, 0, '', 1216481862, 'html', '195.189.142.52', 'Nokia6131');
INSERT INTO `users` VALUES (46, 'JBUA', '5231', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216489553, 0, '4tgOATI8yq', 1216489589, 'html', '195.189.142.220', 'NokiaN70-1/5.0705.3.0.');
INSERT INTO `users` VALUES (47, 'tomazo', 'tomazzo', '', 1, 'klaipeda', 20, '[email protected]', '', 0, 0, 0, 0, '', 0, 1216491958, 0, 'DBp32Kkuxr', 1216493368, 'html', '213.226.131.133', 'Mozilla/4.0');
INSERT INTO `users` VALUES (48, 'XSandr', 'Larisa', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216506652, 0, 'E9DmykanIB', 1216533982, 'html', '81.30.51.61', 'Nokia6131/2.0');
INSERT INTO `users` VALUES (49, 'Mayk', 'Roliki', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216530609, 0, 'Ppr1mGN7e6', 1216530661, 'html', '89.188.224.138', 'SonyEricssonW200i/R4GB');
INSERT INTO `users` VALUES (50, 'станислафф', '458745', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216540486, 0, 'hnv2HA86tR', 1216540950, 'html', '83.149.3.71', 'Mozilla/4.0');
INSERT INTO `users` VALUES (51, 'Местный', '27160', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216551426, 0, 'gNZXMQ7K1L', 1216551546, 'html', '91.203.96.15', 'Opera/9.50');
INSERT INTO `users` VALUES (52, 'Кум', '222221983', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216558447, 0, '5v9UB3c2Sg', 1216558546, 'html', '212.58.182.218', 'SonyEricssonK700i/R2CA');
INSERT INTO `users` VALUES (53, '@Alex', '7777', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216560607, 0, 'r9qdLglT64', 1216560757, 'html', '217.8.236.131', 'Nokia6270/2.0');
INSERT INTO `users` VALUES (54, 'emily rose', '19890406', 'Анжела', 2, 'Кумер', 18, '[email protected]', '491937345', 0, 0, 1, 259630, ':6:', 0, 1216565334, 0, '3OD8V1vBJb', 1216566755, 'html', '195.189.142.248', 'SAMSUNG-SGH-E740');
INSERT INTO `users` VALUES (55, 'Stas', '55555', '', 0, '', 0, '', '', 0, 0, 1, 259630, ':6:', 0, 1216567433, 0, 'dZmvSf9Uct', 1216730311, 'html', '130.244.196.90', 'SonyEricssonW610i//R6B');
INSERT INTO `users` VALUES (56, 'ELECTRONIKKK', '32546', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216573792, 0, 'FZfQzi8Vrk', 1216573804, 'html', '93.93.136.237', 'Mozilla/5.0');
INSERT INTO `users` VALUES (57, 'filosof', '123456', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1216583135, 0, 'GbX0B6tiJu', 1216583162, 'html', '217.118.83.1', 'Mozilla/4.0');
INSERT INTO `users` VALUES (58, 'Тарантелла', '5555555', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1218044339, 0, '530abBijy1', 1218044525, 'html', '91.145.238.141', 'Nokia6233/2.0');
INSERT INTO `users` VALUES (59, 'kymecbleed', '8-4342409bleed', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1218066771, 0, 'VBDSrLdyQn', 1218066873, 'html', '81.23.24.104', 'Mozilla/4.0');
INSERT INTO `users` VALUES (60, 'Jetdi', '150275', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1218111548, 0, 'xaBerN5jgZ', 1218220032, 'html', '213.87.76.138', 'SonyEricssonK610i/R1JG');
INSERT INTO `users` VALUES (61, '494662211', '19872610', '', 0, '', 0, '', '', 0, 0, 0, 0, '', 0, 1218146690, 0, 'A5R4HqatQO', 1218146894, 'html', '83.149.21.147', 'Mozilla/4.0');