· 10 years ago · Feb 27, 2016, 03:00 PM
1-- --------------------------------------------------------
2DROP TABLE IF EXISTS `addedrequests`;
3CREATE TABLE `addedrequests` (
4 `id` int(10) unsigned NOT NULL auto_increment,
5 `requestid` int(10) unsigned NOT NULL default '0',
6 `userid` int(10) unsigned NOT NULL default '0',
7 PRIMARY KEY (`id`),
8 KEY `pollid` (`id`),
9 KEY `userid` (`userid`),
10 KEY `requestid_userid` (`requestid`,`userid`)
11) TYPE=MyISAM;
12
13DROP TABLE IF EXISTS `requests`;
14CREATE TABLE `requests` (
15 `id` int(10) unsigned NOT NULL auto_increment,
16 `userid` int(10) unsigned NOT NULL default '0',
17 `request` varchar(225) default NULL,
18 `descr` text NOT NULL,
19 `added` datetime NOT NULL default '0000-00-00 00:00:00',
20 `hits` int(10) unsigned NOT NULL default '0',
21 `cat` int(10) unsigned NOT NULL default '0',
22 `filledby` int(10) unsigned NOT NULL default '0',
23 `filledurl` varchar(70) default NULL,
24 `filled` enum('yes','no') NOT NULL default 'no',
25 PRIMARY KEY (`id`),
26 KEY `userid` (`userid`),
27 KEY `id_added` (`id`,`added`)
28) TYPE=MyISAM;
29
30DROP TABLE IF EXISTS `offers`;
31CREATE TABLE `offers` (
32 `id` int(10) unsigned NOT NULL auto_increment,
33 `userid` int(10) unsigned NOT NULL default '0',
34 `name` varchar(225) default NULL,
35 `descr` text NOT NULL,
36 `added` datetime NOT NULL default '0000-00-00 00:00:00',
37 `yeah` int(10) unsigned NOT NULL default '0',
38 `against` int(10) unsigned NOT NULL default '0',
39 `category` int(11) NOT NULL default '0',
40 `comments` int(11) NOT NULL default '0',
41 `allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
42 PRIMARY KEY (`id`),
43 KEY `userid` (`userid`)
44) TYPE=MyISAM;
45
46DROP TABLE IF EXISTS `offervotes`;
47CREATE TABLE `offervotes` (
48 `id` int(10) unsigned NOT NULL auto_increment,
49 `offerid` int(10) unsigned NOT NULL default '0',
50 `userid` int(10) unsigned NOT NULL default '0',
51 `vote` enum('yeah','against') NOT NULL default 'yeah',
52 PRIMARY KEY (`id`),
53 KEY `userid` (`userid`)
54) TYPE=MyISAM;
55
56--
57-- Table structure for table `funds`
58--
59DROP TABLE IF EXISTS `funds`;
60CREATE TABLE `funds` (
61 `id` int(10) unsigned NOT NULL auto_increment,
62 `cash` decimal(8,2) NOT NULL default '0.00',
63 `user` int(10) unsigned NOT NULL default '0',
64 `added` datetime NOT NULL default '0000-00-00 00:00:00',
65 PRIMARY KEY (`id`)
66) TYPE=MyISAM;
67
68--
69-- Table structure for table `bannedemails`
70--
71
72DROP TABLE IF EXISTS `bannedemails`;
73CREATE TABLE `bannedemails` (
74 `id` int(10) NOT NULL AUTO_INCREMENT,
75 `value` mediumtext NOT NULL,
76 PRIMARY KEY (`id`)
77) TYPE=MyISAM AUTO_INCREMENT=2;
78
79--
80-- Dumping data for table `bannedemails`
81--
82
83INSERT INTO `bannedemails` (`id`, `value`) VALUES (1, '@test.com');
84
85--
86-- Table structure for table `pmboxes`
87--
88
89DROP TABLE IF EXISTS `pmboxes`;
90CREATE TABLE `pmboxes` (
91`id` INT NOT NULL AUTO_INCREMENT,
92`userid` INT NOT NULL ,
93`boxnumber` TINYINT DEFAULT '2' NOT NULL ,
94`name` VARCHAR( 15 ) NOT NULL ,
95PRIMARY KEY ( `id` )
96);
97
98--
99-- Table structure for table `iplog`
100--
101
102DROP TABLE IF EXISTS `iplog`;
103CREATE TABLE `iplog` (
104`id` int(100) unsigned NOT NULL auto_increment,
105`ip` varchar(15) default NULL,
106`userid` int(10) default NULL,
107`access` datetime NOT NULL default '0000-00-00 00:00:00',
108PRIMARY KEY (`id`),
109KEY `userid` (`userid`)
110) TYPE=MyISAM;
111
112--
113-- Table structure for table `anti_cheat`
114--
115
116DROP TABLE IF EXISTS `anti_cheat`;
117CREATE TABLE `anti_cheat` (
118 `user_id` bigint(20) NOT NULL default '0',
119 `torrent_id` bigint(20) NOT NULL default '0',
120 `uploaded` bigint(20) NOT NULL default '0',
121 `downloaded` bigint(20) NOT NULL default '0',
122 PRIMARY KEY (`user_id`),
123 UNIQUE KEY `usertorrent` (`user_id`,`torrent_id`),
124 KEY `torrent_id` (`torrent_id`)
125) TYPE=MyISAM;
126
127
128--
129-- Dumping data for table `anti_cheat`
130--
131
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `avps`
137--
138
139DROP TABLE IF EXISTS `avps`;
140CREATE TABLE `avps` (
141 `arg` varchar(20) NOT NULL default '',
142 `value_s` text NOT NULL,
143 `value_i` int(11) NOT NULL default '0',
144 `value_u` int(10) unsigned NOT NULL default '0',
145 PRIMARY KEY (`arg`)
146) TYPE=MyISAM;
147
148--
149-- Dumping data for table `avps`
150--
151
152INSERT INTO `avps` (`arg`, `value_s`, `value_i`, `value_u`) VALUES ('lastcleantime', '', 0, 1159575586),
153('last24', '', 4, 1135529148);
154
155-- --------------------------------------------------------
156
157--
158-- Table structure for table `banned_agent`
159--
160
161DROP TABLE IF EXISTS `banned_agent`;
162CREATE TABLE `banned_agent` (
163 `id` int(3) NOT NULL auto_increment,
164 `agent` varchar(255) NOT NULL default '',
165 PRIMARY KEY (`id`)
166) TYPE=MyISAM AUTO_INCREMENT=5;
167
168--
169-- Dumping data for table `banned_agent`
170--
171
172INSERT INTO `banned_agent` (`id`, `agent`) VALUES (1, 'Azureus 2.0'),
173(2, 'Azureus 2.1'),
174(3, 'RAZA'),
175(4, 'Python-urllib');
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `bans`
181--
182
183DROP TABLE IF EXISTS `bans`;
184CREATE TABLE `bans` (
185 `id` int(10) unsigned NOT NULL auto_increment,
186 `added` datetime NOT NULL default '0000-00-00 00:00:00',
187 `addedby` int(10) unsigned NOT NULL default '0',
188 `comment` varchar(255) NOT NULL default '',
189 `first` int(11) default NULL,
190 `last` int(11) default NULL,
191 PRIMARY KEY (`id`),
192 KEY `first_last` (`first`,`last`)
193) TYPE=MyISAM AUTO_INCREMENT=1;
194
195--
196-- Dumping data for table `bans`
197--
198
199
200-- --------------------------------------------------------
201
202--
203-- Table structure for table `bitbucket`
204--
205
206DROP TABLE IF EXISTS `bitbucket`;
207CREATE TABLE `bitbucket` (
208 `id` int(10) unsigned NOT NULL auto_increment,
209 `owner` int(10) default NULL,
210 `name` text ,
211 `added` datetime NOT NULL default '0000-00-00 00:00:00',
212 `public` enum('0','1') NOT NULL default '0',
213 PRIMARY KEY (`id`)
214) TYPE=MyISAM AUTO_INCREMENT=1;
215
216--
217-- Dumping data for table `bitbucket`
218--
219
220
221
222-- --------------------------------------------------------
223
224--
225-- Table structure for table `blocks`
226--
227
228DROP TABLE IF EXISTS `blocks`;
229CREATE TABLE `blocks` (
230 `id` int(10) unsigned NOT NULL auto_increment,
231 `userid` int(10) unsigned NOT NULL default '0',
232 `blockid` int(10) unsigned NOT NULL default '0',
233 PRIMARY KEY (`id`),
234 UNIQUE KEY `userfriend` (`userid`,`blockid`)
235) TYPE=MyISAM AUTO_INCREMENT=1;
236
237--
238-- Dumping data for table `blocks`
239--
240
241
242-- --------------------------------------------------------
243
244--
245-- Table structure for table `bonus`
246--
247
248DROP TABLE IF EXISTS `bonus`;
249CREATE TABLE `bonus` (
250 `id` int(5) NOT NULL auto_increment,
251 `bonusname` varchar(50) NOT NULL default '',
252 `points` decimal(5,1) NOT NULL default '0.0',
253 `description` text NOT NULL,
254 `art` varchar(10) NOT NULL default 'traffic',
255 `menge` bigint(20) unsigned NOT NULL default '0',
256 PRIMARY KEY (`id`)
257) TYPE=MyISAM AUTO_INCREMENT=8;
258
259--
260-- Dumping data for table `bonus`
261--
262
263INSERT INTO `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`) VALUES (1, '1.0GB Uploaded', 75.0, 'With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.', 'traffic', 1073741824),
264(2, '2.5GB Uploaded', 150.0, 'With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.', 'traffic', 2684354560),
265(3, '5GB Uploaded', 250.0, 'With enough bonus points acquired, you are able to exchange them for an Upload Credit. The points are then removed from your Bonus Bank and the credit is added to your total uploaded amount.', 'traffic', 5368709120),
266(4, '3 Invites', 20.0, 'With enough bonus points acquired, you are able to exchange them for a few invites. The points are then removed from your Bonus Bank and the invitations are added to your invites amount.', 'invite', 3),
267(5, 'Custom Title!', 50.0, 'For only 50.0 Karma Bonus Points you can buy yourself a custom title. the only restrictions are no foul or offensive language or userclass can be entered. The points are then removed from your Bonus Bank and your special title is changed to the title of your choice', 'title', 1),
268(6, 'VIP Status', 500.0, 'With enough bonus points acquired, you can buy yourself VIP status for one month. The points are then removed from your Bonus Bank and your status is changed.', 'class', 1),
269(7, 'Give A Karma Gift', 100.0, 'Well perhaps you don''t need the upload credit, but you know somebody that could use the Karma boost! You are now able to give your Karma credits as a gift! The points are then removed from your Bonus Bank and added to the account of a user of your choice!\r\n\r\nAnd they recieve a PM with all the info as well as who it came from...', 'gift_1', 1073741824);
270
271-- --------------------------------------------------------
272
273--
274-- Table structure for table `categories`
275--
276
277DROP TABLE IF EXISTS `categories`;
278CREATE TABLE `categories` (
279 `id` int(10) unsigned NOT NULL auto_increment,
280 `name` varchar(30) NOT NULL default '',
281 `image` varchar(255) NOT NULL default '',
282 `sort_index` int(10) unsigned NOT NULL default '0',
283 `cat_desc` varchar(30) NOT NULL default '',
284 PRIMARY KEY (`id`)
285) TYPE=MyISAM AUTO_INCREMENT=3;
286
287--
288-- Dumping data for table `categories`
289--
290
291INSERT INTO `categories` (`id`, `name`, `image`, `sort_index`, `cat_desc`) VALUES (1, 'Appz/PC ISO', 'cat_apps.gif', 0, ''),
292(2, 'Appz/misc', 'cat_apps.gif', 0, '');
293
294-- --------------------------------------------------------
295
296--
297-- Table structure for table `clients`
298--
299
300DROP TABLE IF EXISTS `clients`;
301CREATE TABLE `clients` (
302 `id` int(10) unsigned NOT NULL auto_increment,
303 `client` varchar(32) NOT NULL default '',
304 `agentString` varchar(64) NOT NULL default '',
305 `freq` int(10) unsigned NOT NULL default '0',
306 PRIMARY KEY (`id`)
307) TYPE=MyISAM AUTO_INCREMENT=31;
308
309--
310-- Dumping data for table `clients`
311--
312
313INSERT INTO `clients` (`id`, `client`, `agentString`, `freq`) VALUES (1, 'ABC', 'BitTorrent/ABC-', 0),
314(2, 'Azureus', 'Azureus', 0),
315(3, 'BitAnarch', 'Anarch', 0),
316(4, 'BitComet', 'Comet', 0),
317(5, 'BitSpirit', 'BitTorrent/BitSpirit', 0),
318(6, 'BitTorrent 3', 'BitTorrent/3.', 0),
319(7, 'BitTorrent++', '++', 0),
320(8, 'BitTornado', 'BitTorrent/T-', 0),
321(9, 'BTQueue', 'Queue', 0),
322(10, 'Burst', 'BitTorrent/brst', 0),
323(11, 'CTorrent', 'CTorrent', 0),
324(12, 'G3 Torrent', 'G3', 0),
325(13, 'Nova Torrent', 'Nova', 0),
326(14, 'PTC Bittorrent', 'PTC', 0),
327(15, 'Experimental', 'BitTorrent/S-', 0),
328(16, 'Shareaza', 'AZA', 0),
329(17, 'Torrentstorm', 'storm', 0),
330(18, 'TorrenTopia', 'Topia', 0),
331(19, 'TurbotBT', 'Turbo', 0),
332(20, 'UPnP BT Client', 'UPnP', 0),
333(21, 'eMule', 'ed2k_plugin v', 0),
334(22, 'BitTorrent Linux', 'Python-urllib/', 0),
335(27, 'BitTorrent Plus!', 'Plus!', 0),
336(24, 'eDonkey', 'MLdonkey', 0),
337(25, 'BTManager', 'BitTorrent/BTManager', 0),
338(26, 'Shareaza', 'Shareaza', 0),
339(28, 'eXeem', 'eXeem', 0),
340(29, 'XanTorrent', 'DansClient', 0),
341(30, 'BitTorrent 4', 'BitTorrent/4.', 0);
342
343-- --------------------------------------------------------
344
345--
346-- Table structure for table `clientselect`
347--
348
349DROP TABLE IF EXISTS `clientselect`;
350CREATE TABLE `clientselect` (
351 `id` int(10) unsigned NOT NULL auto_increment,
352 `name` varchar(80) default NULL,
353 PRIMARY KEY (`id`)
354) TYPE=MyISAM AUTO_INCREMENT=25;
355
356--
357-- Dumping data for table `clientselect`
358--
359
360INSERT INTO `clientselect` (`id`, `name`) VALUES (1, 'ABC'),
361(2, 'Azureus'),
362(3, 'BitAnarch'),
363(4, 'BitComet'),
364(5, 'BitSpirit'),
365(6, 'BitTorrent'),
366(7, 'BitTorrent++'),
367(8, 'BitTornado'),
368(9, 'BTQueue'),
369(10, 'Burst'),
370(11, 'CTorrent'),
371(12, 'G3 Torrent'),
372(13, 'Nova Torrent'),
373(14, 'PTC Bittorrent'),
374(15, 'Shadows Experimental'),
375(16, 'Shareaza'),
376(17, 'Torrentstorm'),
377(18, 'TorrenTopia'),
378(19, 'TurbotBT'),
379(20, 'UPnP BT Client'),
380(21, 'BitTorrent/3.4.2'),
381(22, 'uTorrent/1300'),
382(23, 'uTorrent/1600'),
383(24, 'Azureus 2.5.0.0;Windows XP;Java 1.5.0_06');
384
385-- --------------------------------------------------------
386
387--
388-- Table structure for table `comments`
389--
390
391DROP TABLE IF EXISTS `comments`;
392CREATE TABLE `comments` (
393 `id` int(10) unsigned NOT NULL auto_increment,
394 `user` int(10) unsigned NOT NULL default '0',
395 `torrent` int(10) unsigned NOT NULL default '0',
396 `added` datetime NOT NULL default '0000-00-00 00:00:00',
397 `text` text NOT NULL,
398 `ori_text` text NOT NULL,
399 `editedby` int(10) unsigned NOT NULL default '0',
400 `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
401 `request` int(11) NOT NULL default '0',
402 `offer` int(11) NOT NULL default '0',
403 PRIMARY KEY (`id`),
404 KEY `user` (`user`),
405 KEY `torrent` (`torrent`)
406) TYPE=MyISAM AUTO_INCREMENT=1;
407
408--
409-- Dumping data for table `comments`
410--
411
412
413-- --------------------------------------------------------
414
415--
416-- Table structure for table `countries`
417--
418
419DROP TABLE IF EXISTS `countries`;
420CREATE TABLE `countries` (
421 `id` int(10) unsigned NOT NULL auto_increment,
422 `name` varchar(50) default NULL,
423 `flagpic` varchar(50) default NULL,
424 PRIMARY KEY (`id`)
425) TYPE=MyISAM AUTO_INCREMENT=106;
426
427--
428-- Dumping data for table `countries`
429--
430
431INSERT INTO `countries` (`id`, `name`, `flagpic`) VALUES (1, 'Sweden', 'sweden.gif'),
432(2, 'United States of America', 'usa.gif'),
433(3, 'Russia', 'russia.gif'),
434(4, 'Finland', 'finland.gif'),
435(5, 'Canada', 'canada.gif'),
436(6, 'France', 'france.gif'),
437(7, 'Germany', 'germany.gif'),
438(8, 'China', 'china.gif'),
439(9, 'Italy', 'italy.gif'),
440(10, 'Denmark', 'denmark.gif'),
441(11, 'Norway', 'norway.gif'),
442(12, 'United Kingdom', 'uk.gif'),
443(13, 'Ireland', 'ireland.gif'),
444(14, 'Poland', 'poland.gif'),
445(15, 'Netherlands', 'netherlands.gif'),
446(16, 'Belgium', 'belgium.gif'),
447(17, 'Japan', 'japan.gif'),
448(18, 'Brazil', 'brazil.gif'),
449(19, 'Argentina', 'argentina.gif'),
450(20, 'Australia', 'australia.gif'),
451(21, 'New Zealand', 'newzealand.gif'),
452(23, 'Spain', 'spain.gif'),
453(24, 'Portugal', 'portugal.gif'),
454(25, 'Mexico', 'mexico.gif'),
455(26, 'Singapore', 'singapore.gif'),
456(70, 'India', 'india.gif'),
457(65, 'Albania', 'albania.gif'),
458(29, 'South Africa', 'southafrica.gif'),
459(30, 'South Korea', 'southkorea.gif'),
460(31, 'Jamaica', 'jamaica.gif'),
461(32, 'Luxembourg', 'luxembourg.gif'),
462(33, 'Hong Kong', 'hongkong.gif'),
463(34, 'Belize', 'belize.gif'),
464(35, 'Algeria', 'algeria.gif'),
465(36, 'Angola', 'angola.gif'),
466(37, 'Austria', 'austria.gif'),
467(38, 'Yugoslavia', 'yugoslavia.gif'),
468(39, 'Western Samoa', 'westernsamoa.gif'),
469(40, 'Malaysia', 'malaysia.gif'),
470(41, 'Dominican Republic', 'dominicanrep.gif'),
471(42, 'Greece', 'greece.gif'),
472(43, 'Guatemala', 'guatemala.gif'),
473(44, 'Israel', 'israel.gif'),
474(45, 'Pakistan', 'pakistan.gif'),
475(46, 'Czech Republic', 'czechrep.gif'),
476(47, 'Serbia', 'serbia.gif'),
477(48, 'Seychelles', 'seychelles.gif'),
478(49, 'Taiwan', 'taiwan.gif'),
479(50, 'Puerto Rico', 'puertorico.gif'),
480(51, 'Chile', 'chile.gif'),
481(52, 'Cuba', 'cuba.gif'),
482(53, 'Congo', 'congo.gif'),
483(54, 'Afghanistan', 'afghanistan.gif'),
484(55, 'Turkey', 'turkey.gif'),
485(56, 'Uzbekistan', 'uzbekistan.gif'),
486(57, 'Switzerland', 'switzerland.gif'),
487(58, 'Kiribati', 'kiribati.gif'),
488(59, 'Philippines', 'philippines.gif'),
489(60, 'Burkina Faso', 'burkinafaso.gif'),
490(61, 'Nigeria', 'nigeria.gif'),
491(62, 'Iceland', 'iceland.gif'),
492(63, 'Nauru', 'nauru.gif'),
493(64, 'Slovenia', 'slovenia.gif'),
494(66, 'Turkmenistan', 'turkmenistan.gif'),
495(67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif'),
496(68, 'Andorra', 'andorra.gif'),
497(69, 'Lithuania', 'lithuania.gif'),
498(71, 'Netherlands Antilles', 'nethantilles.gif'),
499(72, 'Ukraine', 'ukraine.gif'),
500(73, 'Venezuela', 'venezuela.gif'),
501(74, 'Hungary', 'hungary.gif'),
502(75, 'Romania', 'romania.gif'),
503(76, 'Vanuatu', 'vanuatu.gif'),
504(77, 'Vietnam', 'vietnam.gif'),
505(78, 'Trinidad & Tobago', 'trinidadandtobago.gif'),
506(79, 'Honduras', 'honduras.gif'),
507(80, 'Kyrgyzstan', 'kyrgyzstan.gif'),
508(81, 'Ecuador', 'ecuador.gif'),
509(82, 'Bahamas', 'bahamas.gif'),
510(83, 'Peru', 'peru.gif'),
511(84, 'Cambodia', 'cambodia.gif'),
512(85, 'Barbados', 'barbados.gif'),
513(86, 'Bangladesh', 'bangladesh.gif'),
514(87, 'Laos', 'laos.gif'),
515(88, 'Uruguay', 'uruguay.gif'),
516(89, 'Antigua Barbuda', 'antiguabarbuda.gif'),
517(90, 'Paraguay', 'paraguay.gif'),
518(93, 'Thailand', 'thailand.gif'),
519(92, 'Union of Soviet Socialist Republics', 'ussr.gif'),
520(94, 'Senegal', 'senegal.gif'),
521(95, 'Togo', 'togo.gif'),
522(96, 'North Korea', 'northkorea.gif'),
523(97, 'Croatia', 'croatia.gif'),
524(98, 'Estonia', 'estonia.gif'),
525(99, 'Colombia', 'colombia.gif'),
526(100, 'Lebanon', 'lebanon.gif'),
527(101, 'Latvia', 'latvia.gif'),
528(102, 'Costa Rica', 'costarica.gif'),
529(103, 'Egypt', 'egypt.gif'),
530(104, 'Bulgaria', 'bulgaria.gif'),
531(105, 'Isla de Muerte', 'jollyroger.gif');
532
533-- --------------------------------------------------------
534
535--
536-- Table structure for table `downloadspeed`
537--
538
539DROP TABLE IF EXISTS `downloadspeed`;
540CREATE TABLE `downloadspeed` (
541 `id` int(10) unsigned NOT NULL auto_increment,
542 `name` varchar(50) default NULL,
543 PRIMARY KEY (`id`)
544) TYPE=MyISAM AUTO_INCREMENT=106;
545
546--
547-- Dumping data for table `downloadspeed`
548--
549
550INSERT INTO `downloadspeed` (`id`, `name`) VALUES (1, '64kbps'),
551(2, '128kbps'),
552(3, '256kbps'),
553(4, '512kbps'),
554(5, '768kbps'),
555(6, '1Mbps'),
556(7, '1.5Mbps'),
557(8, '2Mbps'),
558(9, '3Mbps'),
559(10, '4Mbps'),
560(11, '5Mbps'),
561(12, '6Mbps'),
562(13, '7Mbps'),
563(14, '8Mbps'),
564(15, '9Mbps'),
565(16, '10Mbps'),
566(17, '48Mbps'),
567(18, '100Mbit');
568
569-- --------------------------------------------------------
570
571--
572-- Table structure for table `faq`
573--
574
575DROP TABLE IF EXISTS `faq`;
576CREATE TABLE `faq` (
577 `id` int(10) NOT NULL auto_increment,
578 `type` set('categ','item') NOT NULL default 'item',
579 `question` text NOT NULL,
580 `answer` text NOT NULL,
581 `flag` set('0','1','2','3') NOT NULL default '1',
582 `categ` int(10) NOT NULL default '0',
583 `order` int(10) NOT NULL default '0',
584 PRIMARY KEY (`id`)
585) TYPE=MyISAM AUTO_INCREMENT=67;
586
587--
588-- Dumping data for table `faq`
589--
590
591INSERT INTO `faq` (`id`, `type`, `question`, `answer`, `flag`, `categ`, `order`) VALUES
592(1, 'categ', 'Site information', '', '1', 0, 1),
593(2, 'categ', 'User information', '', '1', 0, 2),
594(3, 'categ', 'Stats', '', '1', 0, 3),
595(4, 'categ', 'Uploading', '', '1', 0, 4),
596(5, 'categ', 'Downloading', '', '1', 0, 5),
597(6, 'categ', 'How can I improve my download speed?', '', '1', 0, 6),
598(7, 'categ', 'My ISP uses a transparent proxy. What should I do?', '', '1', 0, 7),
599(8, 'categ', 'Why can''t I connect? Is the site blocking me?', '', '1', 0, 8),
600(9, 'categ', 'What if I can''t find the answer to my problem here?', '', '1', 0, 9),
601(10, 'item', 'What is this bittorrent all about anyway? How do I get the files?', 'Check out <a class=altlink href="http://www.btfaq.com/">Brian''s BitTorrent FAQ and Guide</a>', '1', 1, 1),
602(11, 'item', 'Where does the donated money go?', 'TS is situated on a dedicated server in the Netherlands. For the moment we have monthly running costs of approximately $ 213.\r\n', '1', 1, 2),
603(12, 'item', 'Where can I get a copy of the source code?', 'Snapshots are available on the <a href=http://www.templateshares.net class=altlink>TEMPLATESHARES</a>. Please note: We do not give any kind of support on the source code so please don''t bug us about it. If it works, great, if not too bad. Use this software at your own risk!', '1', 1, 3),
604(13, 'item', 'I registered an account but did not receive the confirmation e-mail!', 'You can use <a class=altlink href=delacct.php>this form</a> to delete the account so you can re-register.\r\nNote though that if you didn''t receive the email the first time it will probably not\r\nsucceed the second time either so you should really try another email address.', '1', 2, 1),
605(14, 'item', 'I''ve lost my user name or password! Can you send it to me?', 'Please use <a class=altlink href=recover.php>this form</a> to have the login details mailed back to you.', '1', 2, 2),
606(15, 'item', 'Can you rename my account?', 'We do not rename accounts. Please create a new one. (Use <a href=delacct.php class=altlink>this form</a> to\r\ndelete your present account.)', '1', 2, 3),
607(16, 'item', 'Can you delete my (confirmed) account?', 'You can do it yourself by using <a href=delacct.php class=altlink>this form</a>.', '2', 2, 4),
608(17, 'item', 'So, what''s MY ratio?', 'Click on your <a class=altlink href=usercp.php>profile</a>, then on your user name (at the top).<br>\r\n<br>\r\nIt''s important to distinguish between your overall ratio and the individual ratio on each torrent\r\nyou may be seeding or leeching. The overall ratio takes into account the total uploaded and downloaded\r\nfrom your account since you joined the site. The individual ratio takes into account those values for each torrent.<br>\r\n<br>\r\nYou may see two symbols instead of a number: "Inf.", which is just an abbreviation for Infinity, and\r\nmeans that you have downloaded 0 bytes while uploading a non-zero amount (ul/dl becomes infinity); "---",\r\nwhich should be read as "non-available", and shows up when you have both downloaded and uploaded 0 bytes\r\n(ul/dl = 0/0 which is an indeterminate amount).', '1', 2, 5),
609(18, 'item', 'Why is my IP displayed on my details page?', 'Only you and the site moderators can view your IP address and email. Regular users do not see that information.', '1', 2, 6),
610(19, 'item', 'Help! I cannot login!? (a.k.a. Login of Death)', 'This problem sometimes occurs with MSIE. Close all Internet Explorer windows and open Internet Options in the control panel. Click the Delete Cookies button. You should now be able to login.\r\n', '1', 2, 7),
611(20, 'item', 'My IP address is dynamic. How do I stay logged in?', 'You do not have to anymore. All you have to do is make sure you are logged in with your actual\r\nIP when starting a torrent session. After that, even if the IP changes mid-session,\r\nthe seeding or leeching will continue and the statistics will update without any problem.', '2', 2, 8),
612(21, 'item', 'Why is my port number reported as "---"? (And why should I care?)', 'The tracker has determined that you are firewalled or NATed and cannot accept incoming connections.\r\n<br>\r\n<br>\r\nThis means that other peers in the swarm will be unable to connect to you, only you to them. Even worse,\r\nif two peers are both in this state they will not be able to connect at all. This has obviously a\r\ndetrimental effect on the overall speed.\r\n<br>\r\n<br>\r\nThe way to solve the problem involves opening the ports used for incoming connections\r\n(the same range you defined in your client) on the firewall and/or configuring your\r\nNAT server to use a basic form of NAT\r\nfor that range instead of NAPT (the actual process differs widely between different router models.\r\nCheck your router documentation and/or support forum. You will also find lots of information on the\r\nsubject at <a class=altlink href="http://portforward.com/">PortForward</a>).', '1', 2, 9),
613(22, 'item', 'What are the different user classes?', '<table cellspacing=3 cellpadding=0>\r\n<tr>\r\n<td class=embedded width=100 bgcolor="#F5F4EA"> <b>User</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>The default class of new members.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b>Power User</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Can download DOX over 1MB and view NFO files.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><img src="pic/star.gif" alt="Star"></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Has donated money to Template Shares . </td>\r\n</tr>\r\n<tr>\r\n<td class=embedded valign=top bgcolor="#F5F4EA"> <b>VIP</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded valign=top>Same privileges as Power User and is considered an Elite Member of Template Shares. Immune to automatic demotion.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b>Other</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Customised title.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><font color="#4040c0">Uploader</font></b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Same as PU except with upload rights and immune to automatic demotion.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded valign=top bgcolor="#F5F4EA"> <b><font color="#A83838">Moderator</font></b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded valign=top>Can edit and delete any uploaded torrents. Can also moderate usercomments and disable accounts.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><font color="#A83838">Administrator</color></b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Can do just about anything.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><font color="#A83838">SysOp</color></b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Redbeard (site owner).</td>\r\n</tr>\r\n</table>', '1', 2, 10),
614(23, 'item', 'How does this promotion thing work anyway?', '<table cellspacing=3 cellpadding=0>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA" valign=top width=100> <b>Power User</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded valign=top>Must have been be a member for at least 4 weeks, have uploaded at least 25GB and\r\nhave a ratio at or above 1.05.<br>\r\nThe promotion is automatic when these conditions are met. Note that you will be automatically demoted from<br>\r\nthis status if your ratio drops below 0.95 at any time.</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><img src="pic/star.gif" alt="Star"></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Just donate, and send a message to <a class=altlink href=sendmessage.php?receiver=1>Admin</a></td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA" valign=top> <b>VIP</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded valign=top>Assigned by mods at their discretion to users they feel contribute something special to the site.<br>\r\n(Anyone begging for VIP status will be automatically disqualified.)</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b>Other</b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Conferred by mods at their discretion (not available to Users or Power Users).</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><font color="#4040c0">Uploader</font></b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>Appointed by Admins/SysOp (see the ''Uploading'' section for conditions).</td>\r\n</tr>\r\n<tr>\r\n<td class=embedded bgcolor="#F5F4EA"> <b><font color="#A83838">Moderator</font></b></td>\r\n<td class=embedded width=5> </td>\r\n<td class=embedded>You don''t ask us, we''ll ask you!</td>\r\n</tr>\r\n</table>', '1', 2, 11),
615(24, 'item', 'Hey! I''ve seen Power Users with less than 25GB uploaded!', 'The PU limit used to be 10GB and we didn''t demote anyone when we raised it to 25GB.', '1', 2, 12),
616(25, 'item', 'Why can''t my friend become a member?', 'There is a 75.000 users limit. When that number is reached we stop accepting new members. Accounts inactive for more than 42 days are automatically deleted, so keep trying. (There is no reservation or queuing system, don''t ask for that.)', '2', 2, 13),
617(26, 'item', 'How do I add an avatar to my profile?', 'First, find an image that you like, and that is within the\r\n<a class=altlink href=rules.php>rules</a>. Then you will have\r\nto find a place to host it, such as our own <a class=altlink href=bitbucket-upload.php>BitBucket</a>.\r\n(Other popular choices are <a class="altlink" href="http://photobucket.com/">Photobucket</a>,\r\n<a class="altlink" href="http://uploadit.org/">Upload-It!</a> or\r\n<a class="altlink" href="http://www.imageshack.us/">ImageShack</a>).\r\nAll that is left to do is copy the URL you were given when\r\nuploading it to the avatar field in your <a class="altlink" href="usercp.php">profile</a>.<br>\r\n<br>\r\nPlease do not make a post just to test your avatar. If everything is allright you''ll see it\r\nin your details page.', '1', 2, 14),
618(27, 'item', 'Most common reason for stats not updating', '<ul>\r\n<li>The user is cheating. (a.k.a. "Summary Ban")</li>\r\n<li>The server is overloaded and unresponsive. Just try to keep the session open until the server responds again. (Flooding the server with consecutive manual updates is not recommended.)</li>\r\n<li>You are using a faulty client. If you want to use an experimental or CVS version you do it at your own risk.</li>\r\n</ul>', '1', 3, 1),
619(28, 'item', 'Best practices', '<ul>\r\n<li>If a torrent you are currently leeching/seeding is not listed on your profile, just wait or force a manual update.</li>\r\n<li>Make sure you exit your client properly, so that the tracker receives "event=completed".</li>\r\n<li>If the tracker is down, do not stop seeding. As long as the tracker is back up before you exit the client the stats should update properly.</li>\r\n</ul>', '1', 3, 2),
620(29, 'item', 'May I use any bittorrent client?', 'Yes. The tracker now updates the stats correctly for all bittorrent clients. However, we still recommend\r\nthat you <b>avoid</b> the following clients:<br>\r\n<ul>\r\n<li>UTorrent</li>\r\n<li>Azerus</li>\r\n</ul>\r\nThese clients do not report correctly to the tracker when canceling/finishing a torrent session.\r\nIf you use them then a few MB may not be counted towards\r\nthe stats near the end, and torrents may still be listed in your profile for some time after you have closed the client.<br>\r\n<br>\r\nAlso, clients in alpha or beta version should be avoided.', '1', 3, 3),
621(30, 'item', 'Why is a torrent I''m leeching/seeding listed several times in my profile?', 'If for some reason (e.g. pc crash, or frozen client) your client exits improperly and you restart it,\r\nit will have a new peer_id, so it will show as a new torrent. The old one will never receive a "event=completed"\r\nor "event=stopped" and will be listed until some tracker timeout. Just ignore it, it will eventually go away.', '1', 3, 4),
622(31, 'item', 'I''ve finished or cancelled a torrent. Why is it still listed in my profile?', 'Some clients, notably TorrentStorm and Nova Torrent, do not report properly to the tracker when canceling or finishing a torrent.\r\nIn that case the tracker will keep waiting for some message - and thus listing the torrent as seeding or leeching - until some\r\ntimeout occurs. Just ignore it, it will eventually go away.', '1', 3, 5),
623(32, 'item', 'Why do I sometimes see torrents I''m not leeching in my profile!?', 'When a torrent is first started, the tracker uses the IP to identify the user. Therefore the torrent will\r\nbecome associated with the user <i>who last accessed the site</i> from that IP. If you share your IP in some\r\nway (you are behind NAT/ICS, or using a proxy), and some of the persons you share it with are also users,\r\nyou may occasionally see their torrents listed in your profile. (If they start a torrent session from that\r\nIP and you were the last one to visit the site the torrent will be associated with you). Note that now\r\ntorrents listed in your profile will always count towards your total stats.', '2', 3, 6),
624(33, 'item', 'Multiple IPs (Can I login from different computers?)', 'Yes, the tracker is now capable of following sessions from different IPs for the same user. A torrent is associated with the user when it starts, and only at that moment is the IP relevant. So if you want to seed/leech from computer A and computer B with the same account you should access the site from computer A, start the torrent there, and then repeat both steps from computer B (not limited to two computers or to a single torrent on each, this is just the simplest example). You do not need to login again when closing the torrent.\r\n', '2', 3, 7),
625(34, 'item', 'How does NAT/ICS change the picture?', 'This is a very particular case in that all computers in the LAN will appear to the outside world as having the same IP. We must distinguish\r\nbetween two cases:<br>\r\n<br>\r\n<b>1.</b> <i>You are the single Template Shares users in the LAN</i><br>\r\n<br>\r\nYou should use the same Template Shares account in all the computers.<br>\r\n<br>\r\nNote also that in the ICS case it is preferable to run the BT client on the ICS gateway. Clients running on the other computers\r\nwill be unconnectable (their ports will be listed as "---", as explained elsewhere in the FAQ) unless you specify\r\nthe appropriate services in your ICS configuration (a good explanation of how to do this for Windows XP can be found\r\n<a class=altlink href="redirect.php?url=http://www.microsoft.com/downloads/details.aspx?FamilyID=1dcff3ce-f50f-4a34-ae67-cac31ccd7bc9&displaylang=en">here</a>).\r\nIn the NAT case you should configure different ranges for clients on different computers and create appropriate NAT rules in the router. (Details vary widely from router to router and are outside the scope of this FAQ. Check your router documentation and/or support forum.)<br>\r\n<br>\r\n<br>\r\n<b>2.</b> <i>There are multiple Template Shares users in the LAN</i><br>\r\n<br>\r\nAt present there is no way of making this setup always work properly with Template Shares.\r\nEach torrent will be associated with the user who last accessed the site from within\r\nthe LAN before the torrent was started.\r\nUnless there is cooperation between the users mixing of statistics is possible.\r\n(User A accesses the site, downloads a .torrent file, but does not start the torrent immediately.\r\nMeanwhile, user B accesses the site. User A then starts the torrent. The torrent will count\r\ntowards user B''s statistics, not user A''s.)\r\n<br>\r\n<br>\r\nIt is your LAN, the responsibility is yours. Do not ask us to ban other users\r\nwith the same IP, we will not do that. (Why should we ban <i>him</i> instead of <i>you</i>?)', '1', 3, 8),
626(36, 'item', 'Why can''t I upload torrents?', 'Only specially authorized users (<font color="#4040c0"><b>Uploaders</b></font>) have permission to upload torrents.', '1', 4, 1),
627(37, 'item', 'What criteria must I meet before I can join the <font color="#4040c0">Uploader</font> team?', 'You must be able to provide releases that:\r\n<li>include a proper NFO</li>\r\n<li>are genuine scene releases. If it''s not on <a class=altlink href="redirect.php?url=http://www.nforce.nl">NFOrce</a> then forget it! (except music)</li>\r\n<li>are not older than seven (7) days</li>\r\n<li>have all files in original format (usually 14.3 MB RARs)</li>\r\n<li>you''ll be able to seed, or make sure are well-seeded, for at least 24 hours.</li>\r\n<li>you should have atleast 2MBit upload bandwith.</li>\r\n</ul>\r\nIf you think you can match these criteria do not hesitate to <a class=altlink href=staff.php>contact</a> one of the administrators.<br>\r\n<b>Remember!</b> Write your application carefully! Be sure to include your UL speed and what kind of stuff you''re planning to upload.<br>\r\nOnly well written letters with serious intent will be considered.', '1', 4, 2),
628(38, 'item', 'Can I upload your torrents to other trackers?', 'No. We are a closed, limited-membership community. Only registered users can use the TB tracker.\r\nPosting our torrents on other trackers is useless, since most people who attempt to download them will\r\nbe unable to connect with us. This generates a lot of frustration and bad-will against us at Template Shares,\r\nand will therefore not be tolerated.<br>\r\n<br>\r\nComplaints from other sites'' administrative staff about our torrents being posted on their sites will\r\nresult in the banning of the users responsible.<br>\r\n<br>\r\n(However, the files you download from us are yours to do as you please. You can always create another\r\ntorrent, pointing to some other tracker, and upload it to the site of your choice.)', '3', 4, 3),
629(39, 'item', 'How do I use the files I''ve downloaded?', 'Check out <a class=altlink href=videoformats.php>this guide</a>.', '1', 5, 1),
630(40, 'item', 'Downloaded a movie and don''t know what CAM/TS/TC/SCR means?', 'Check out <a class=altlink href=videoformats.php>this</a> guide.', '1', 5, 2),
631(41, 'item', 'Why did an active torrent suddenly disappear?', 'There may be three reasons for this:<br>\r\n(<b>1</b>) The torrent may have been out-of-sync with the site\r\n<a class=altlink href=rules.php>rules</a>.<br>\r\n(<b>2</b>) The uploader may have deleted it because it was a bad release.\r\nA replacement will probably be uploaded to take its place.<br>\r\n(<b>3</b>) Torrents are automatically deleted after 28 days.', '2', 5, 3),
632(42, 'item', 'How do I resume a broken download or reseed something?', 'Open the .torrent file. When your client asks you for a location, choose the location of the existing file(s) and it will resume/reseed the torrent.\r\n', '1', 5, 4),
633(43, 'item', 'Why do my downloads sometimes stall at 99%?', 'The more pieces you have, the harder it becomes to find peers who have pieces you are missing. That is why downloads sometimes slow down or even stall when there are just a few percent remaining. Just be patient and you will, sooner or later, get the remaining pieces.\r\n', '1', 5, 5),
634(44, 'item', 'What are these "a piece has failed an hash check" messages?', 'Bittorrent clients check the data they receive for integrity. When a piece fails this check it is\r\nautomatically re-downloaded. Occasional hash fails are a common occurrence, and you shouldn''t worry.<br>\r\n<br>\r\nSome clients have an (advanced) option/preference to ''kick/ban clients that send you bad data'' or\r\nsimilar. It should be turned on, since it makes sure that if a peer repeatedly sends you pieces that\r\nfail the hash check it will be ignored in the future.', '1', 5, 6),
635(45, 'item', 'The torrent is supposed to be 100MB. How come I downloaded 120MB?', 'See the hash fails topic. If your client receives bad data it will have to redownload it, therefore\r\nthe total downloaded may be larger than the torrent size. Make sure the "kick/ban" option is turned on\r\nto minimize the extra downloads.', '1', 5, 7),
636(46, 'item', 'Why do I get a "Not authorized (xx h) - READ THE FAQ" error?', 'From the time that each <b>new</b> torrent is uploaded to the tracker, there is a period of time that\r\nsome users must wait before they can download it.<br>\r\nThis delay in downloading will only affect users with a low ratio, and users with low upload amounts.<br>\r\n<br>\r\n<table cellspacing=3 cellpadding=0>\r\n <tr>\r\n <td class=embedded width="70">Ratio below</td>\r\n <td class=embedded width="40" bgcolor="#F5F4EA"><font color="#BB0000"><div align="center">0.50</div></font></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded width="110">and/or upload below</td>\r\n <td class=embedded width="40" bgcolor="#F5F4EA"><div align="center">5.0GB</div></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded width="50">delay of</td>\r\n <td class=embedded width="40" bgcolor="#F5F4EA"><div align="center">48h</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded>Ratio below</td>\r\n <td class=embedded bgcolor="#F5F4EA"><font color="#A10000"><div align="center">0.65</div></font></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded>and/or upload below</td>\r\n <td class=embedded bgcolor="#F5F4EA"><div align="center">6.5GB</div></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded>delay of</td>\r\n <td class=embedded bgcolor="#F5F4EA"><div align="center">24h</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded>Ratio below</td>\r\n <td class=embedded bgcolor="#F5F4EA"><font color="#880000"><div align="center">0.80</div></font></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded>and/or upload below</td>\r\n <td class=embedded bgcolor="#F5F4EA"><div align="center">8.0GB</div></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded>delay of</td>\r\n <td class=embedded bgcolor="#F5F4EA"><div align="center">12h</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded>Ratio below</td>\r\n <td class=embedded bgcolor="#F5F4EA"><font color="#6E0000"><div align="center">0.95</div></font></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded>and/or upload below</td>\r\n <td class=embedded bgcolor="#F5F4EA"><div align="center">9.5GB</div></td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded>delay of</td>\r\n <td class=embedded bgcolor="#F5F4EA"><div align="center">06h</div></td>\r\n </tr>\r\n</table>\r\n<br>\r\n"<b>And/or</b>" means any or both. Your delay will be the <b>largest</b> one for which you meet <b>at least</b> one condition.<br>\r\n<br>\r\nThis applies to new users as well, so opening a new account will not help. Note also that this\r\nworks at tracker level, you will be able to grab the .torrent file itself at any time.<br>\r\n<br>\r\n<!--The delay applies only to leeching, not to seeding. If you got the files from any other source and\r\nwish to seed them you may do so at any time irrespectively of your ratio or total uploaded.<br>-->\r\nN.B. Due to some users exploiting the ''no-delay-for-seeders'' policy we had to change it. The delay\r\nnow applies to both seeding and leeching. So if you are subject to a delay and get the files from\r\nsome other source you will not be able to seed them until the delay has elapsed.', '3', 5, 8),
637(47, 'item', 'Why do I get a "rejected by tracker - Port xxxx is blacklisted" error?', 'Your client is reporting to the tracker that it uses one of the default bittorrent ports\r\n(6881-6889) or any other common p2p port for incoming connections.<br>\r\n<br>\r\nTemplate Shares does not allow clients to use ports commonly associated with p2p protocols.\r\nThe reason for this is that it is a common practice for ISPs to throttle those ports\r\n(that is, limit the bandwidth, hence the speed). <br>\r\n<br>\r\nThe blocked ports list include, but is not neccessarily limited to, the following:<br>\r\n<br>\r\n<table cellspacing=3 cellpadding=0>\r\n <tr>\r\n <td class=embedded width="80">Direct Connect</td>\r\n <td class=embedded width="80" bgcolor="#F5F4EA"><div align="center">411 - 413</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded width="80">Kazaa</td>\r\n <td class=embedded width="80" bgcolor="#F5F4EA"><div align="center">1214</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded width="80">eDonkey</td>\r\n <td class=embedded width="80" bgcolor="#F5F4EA"><div align="center">4662</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded width="80">Gnutella</td>\r\n <td class=embedded width="80" bgcolor="#F5F4EA"><div align="center">6346 - 6347</div></td>\r\n </tr>\r\n <tr>\r\n <td class=embedded width="80">BitTorrent</td>\r\n <td class=embedded width="80" bgcolor="#F5F4EA"><div align="center">6881 - 6889</div></td>\r\n </tr>\r\n</table>\r\n<br>\r\nIn order to use use our tracker you must configure your client to use\r\nany port range that does not contain those ports (a range within the region 49152 through 65535 is preferable,\r\ncf. <a class=altlink href="http://www.iana.org/assignments/port-numbers">IANA</a>). Notice that some clients,\r\nlike Azureus 2.0.7.0 or higher, use a single port for all torrents, while most others use one port per open torrent. The size\r\nof the range you choose should take this into account (typically less than 10 ports wide. There\r\nis no benefit whatsoever in choosing a wide range, and there are possible security implications). <br>\r\n<br>\r\nThese ports are used for connections between peers, not client to tracker.\r\nTherefore this change will not interfere with your ability to use other trackers (in fact it\r\nshould <i>increase</i> your speed with torrents from any tracker, not just ours). Your client\r\nwill also still be able to connect to peers that are using the standard ports.\r\nIf your client does not allow custom ports to be used, you will have to switch to one that does.<br>\r\n<br>\r\nDo not ask us, or in the forums, which ports you should choose. The more random the choice is the harder\r\nit will be for ISPs to catch on to us and start limiting speeds on the ports we use.\r\nIf we simply define another range ISPs will start throttling that range also. <br>\r\n<br>\r\nFinally, remember to forward the chosen ports in your router and/or open them in your\r\nfirewall, should you have them.', '3', 5, 9),
638(48, 'item', 'What''s this "IOError - [Errno13] Permission denied" error?', 'If you just want to fix it reboot your computer, it should solve the problem.\r\nOtherwise read on.<br>\r\n<br>\r\nIOError means Input-Output Error, and that is a file system error, not a tracker one.\r\nIt shows up when your client is for some reason unable to open the partially downloaded\r\ntorrent files. The most common cause is two instances of the client to be running\r\nsimultaneously:\r\nthe last time the client was closed it somehow didn''t really close but kept running in the\r\nbackground, and is therefore still\r\nlocking the files, making it impossible for the new instance to open them.<br>\r\n<br>\r\nA more uncommon occurrence is a corrupted FAT. A crash may result in corruption\r\nthat makes the partially downloaded files unreadable, and the error ensues. Running\r\nscandisk should solve the problem. (Note that this may happen only if you''re running\r\nWindows 9x - which only support FAT - or NT/2000/XP with FAT formatted hard drives.\r\nNTFS is much more robust and should never permit this problem.)', '3', 5, 10),
639(49, 'item', 'What''s this "TTL" in the browse page?', 'The torrent''s Time To Live, in hours. It means the torrent will be deleted\r\nfrom the tracker after that many hours have elapsed (yes, even if it is still active).\r\nNote that this a maximum value, the torrent may be deleted at any time if it''s inactive.', '3', 5, 11),
640(50, 'item', 'Do not immediately jump on new torrents', 'The download speed mostly depends on the seeder-to-leecher ratio (SLR). Poor download speed is\r\nmainly a problem with new and very popular torrents where the SLR is low.<br>\r\n<br>\r\n(Proselytising sidenote: make sure you remember that you did not enjoy the low speed.\r\n<b>Seed</b> so that others will not endure the same.)<br>\r\n<br>\r\nThere are a couple of things that you can try on your end to improve your speed:<br>\r\n<br>In particular, do not do it if you have a slow connection. The best speeds will be found around the\r\nhalf-life of a torrent, when the SLR will be at its highest. (The downside is that you will not be able to seed\r\nso much. It''s up to you to balance the pros and cons of this.)', '1', 6, 1),
641(51, 'item', 'Limit your upload speed', 'The upload speed affects the download speed in essentially two ways:<br>\r\n<ul>\r\n <li>Bittorrent peers tend to favour those other peers that upload to them. This means that if A and B\r\n are leeching the same torrent and A is sending data to B at high speed then B will try to reciprocate.\r\n So due to this effect high upload speeds lead to high download speeds.</li>\r\n\r\n <li>Due to the way TCP works, when A is downloading something from B it has to keep telling B that\r\n it received the data sent to him. (These are called acknowledgements - ACKs -, a sort of "got it!" messages).\r\n If A fails to do this then B will stop sending data and wait. If A is uploading at full speed there may be no\r\n bandwidth left for the ACKs and they will be delayed. So due to this effect excessively high upload speeds lead\r\n to low download speeds.</li>\r\n</ul>\r\n\r\nThe full effect is a combination of the two. The upload should be kept as high as possible while allowing the\r\nACKs to get through without delay. <b>A good thumb rule is keeping the upload at about 80% of the theoretical\r\nupload speed.</b> You will have to fine tune yours to find out what works best for you. (Remember that keeping the\r\nupload high has the additional benefit of helping with your ratio.) <br>\r\n<br>\r\nIf you are running more than one instance of a client it is the overall upload speed that you must take into account.\r\nSome clients (e.g. Azureus) limit global upload speed, others (e.g. Shad0w''s) do it on a per torrent basis.\r\nKnow your client. The same applies if you are using your connection for anything else (e.g. browsing or ftp),\r\nalways think of the overall upload speed.', '1', 6, 2),
642(52, 'item', 'Limit the number of simultaneous connections', 'Some operating systems (like Windows 9x) do not deal well with a large number of connections, and may even crash.\r\nAlso some home routers (particularly when running NAT and/or firewall with stateful inspection services) tend to become\r\nslow or crash when having to deal with too many connections. There are no fixed values for this, you may try 60 or 100\r\nand experiment with the value. Note that these numbers are additive, if you have two instances of\r\na client running the numbers add up.', '1', 6, 3),
643(53, 'item', 'Limit the number of simultaneous uploads', 'Isn''t this the same as above? No. Connections limit the number of peers your client is talking to and/or\r\ndownloading from. Uploads limit the number of peers your client is actually uploading to. The ideal number is\r\ntypically much lower than the number of connections, and highly dependent on your (physical) connection.', '1', 6, 4),
644(54, 'item', 'Just give it some time', 'As explained above peers favour other peers that upload to them. When you start leeching a new torrent you have\r\nnothing to offer to other peers and they will tend to ignore you. This makes the starts slow, in particular if,\r\nby change, the peers you are connected to include few or no seeders. The download speed should increase as soon\r\nas you have some pieces to share.', '1', 6, 5),
645(55, 'item', 'Why is my browsing so slow while leeching?', 'Your download speed is always finite. If you are a peer in a fast torrent it will almost certainly saturate your\r\ndownload bandwidth, and your browsing will suffer. At the moment there is no client that allows you to limit the\r\ndownload speed, only the upload. You will have to use a third-party solution,\r\nsuch as <a class=altlink href="redirect.php?url=http://www.netlimiter.com/">NetLimiter</a>.<br>\r\n<br>\r\nBrowsing was used just as an example, the same would apply to gaming, IMing, etc...', '1', 6, 6),
646(56, 'item', 'What is a proxy?', 'Basically a middleman. When you are browsing a site through a proxy your requests are sent to the proxy and the proxy\r\nforwards them to the site instead of you connecting directly to the site. There are several classifications\r\n(the terminology is far from standard):<br>\r\n<br>\r\n\r\n\r\n<table cellspacing=3 cellpadding=0>\r\n <tr>\r\n <td class=embedded valign="top" bgcolor="#F5F4EA" width="100"> Transparent</td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded valign="top">A transparent proxy is one that needs no configuration on the clients. It works by automatically redirecting all port 80 traffic to the proxy. (Sometimes used as synonymous for non-anonymous.)</td>\r\n </tr>\r\n <tr>\r\n <td class=embedded valign="top" bgcolor="#F5F4EA"> Explicit/Voluntary</td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded valign="top">Clients must configure their browsers to use them.</td>\r\n </tr>\r\n <tr>\r\n <td class=embedded valign="top" bgcolor="#F5F4EA"> Anonymous</td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded valign="top">The proxy sends no client identification to the server. (HTTP_X_FORWARDED_FOR header is not sent; the server does not see your IP.)</td>\r\n </tr>\r\n <tr>\r\n <td class=embedded valign="top" bgcolor="#F5F4EA"> Highly Anonymous</td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded valign="top">The proxy sends no client nor proxy identification to the server. (HTTP_X_FORWARDED_FOR, HTTP_VIA and HTTP_PROXY_CONNECTION headers are not sent; the server doesn''t see your IP and doesn''t even know you''re using a proxy.)</td>\r\n </tr>\r\n <tr>\r\n <td class=embedded valign="top" bgcolor="#F5F4EA"> Public</td>\r\n <td class=embedded width="10"> </td>\r\n <td class=embedded valign="top">(Self explanatory)</td>\r\n </tr>\r\n</table>\r\n<br>\r\nA transparent proxy may or may not be anonymous, and there are several levels of anonymity.', '1', 7, 1),
647(57, 'item', 'How do I find out if I''m behind a (transparent/anonymous) proxy?', 'Try <a href=http://proxyjudge.org class="altlink">ProxyJudge</a>. It lists the HTTP headers that the server where it is running\r\nreceived from you. The relevant ones are HTTP_CLIENT_IP, HTTP_X_FORWARDED_FOR and REMOTE_ADDR.<br>\r\n<br>\r\n<br>\r\n<b>Why is my port listed as "---" even though I''m not NAT/Firewalled?</b><a name="prox3"></a><br>\r\n<br>\r\nThe Template Shares tracker is quite smart at finding your real IP, but it does need the proxy to send the HTTP header\r\nHTTP_X_FORWARDED_FOR. If your ISP''s proxy does not then what happens is that the tracker will interpret the proxy''s IP\r\naddress as the client''s IP address. So when you login and the tracker tries to connect to your client to see if you are\r\nNAT/firewalled it will actually try to connect to the proxy on the port your client reports to be using for\r\nincoming connections. Naturally the proxy will not be listening on that port, the connection will fail and the\r\ntracker will think you are NAT/firewalled.', '1', 7, 2),
648(58, 'item', 'Can I bypass my ISP''s proxy?', 'If your ISP only allows HTTP traffic through port 80 or blocks the usual proxy ports then you would need to use something\r\nlike <a href=http://www.socks.permeo.com>socks</a> and that is outside the scope of this FAQ.<br>\r\n<br>\r\nThe site accepts connections on port 81 besides the usual 80, and using them may be enough to fool some proxies. So the first\r\nthing to try should be connecting to www.templateshares.net:81. Note that even if this works your bt client will still try\r\nto connect to port 80 unless you edit the announce url in the .torrent file.<br>\r\n<br>\r\nOtherwise you may try the following:<br>\r\n<ul>\r\n <li>Choose any public <b>non-anonymous</b> proxy that does <b>not</b> use port 80\r\n (e.g. from <a href=http://tools.rosinstrument.com/proxy class="altlink">this</a>,\r\n <a href=http://www.proxy4free.com/index.html class="altlink">this</a> or\r\n <a href=http://www.samair.ru/proxy class="altlink">this</a> list).</li>\r\n\r\n <li>Configure your computer to use that proxy. For Windows XP, do <i>Start</i>, <i>Control Panel</i>, <i>Internet Options</i>,\r\n <i>Connections</i>, <i>LAN Settings</i>, <i>Use a Proxy server</i>, <i>Advanced</i> and type in the IP and port of your chosen\r\n proxy. Or from Internet Explorer use <i>Tools</i>, <i>Internet Options</i>, ...<br></li>\r\n\r\n <li>(Facultative) Visit <a href=http://proxyjudge.org class="altlink">ProxyJudge</a>. If you see an HTTP_X_FORWARDED_FOR in\r\n the list followed by your IP then everything should be ok, otherwise choose another proxy and try again.<br></li>\r\n\r\n <li>Visit Template Shares. Hopefully the tracker will now pickup your real IP (check your profile to make sure).</li>\r\n</ul>\r\n<br>\r\nNotice that now you will be doing all your browsing through a public proxy, which are typically quite slow.\r\nCommunications between peers do not use port 80 so their speed will not be affected by this, and should be better than when\r\nyou were "unconnectable".', '1', 7, 3),
649(59, 'item', 'How do I make my bittorrent client use a proxy?', 'Just configure Windows XP as above. When you configure a proxy for Internet Explorer you''re actually configuring a proxy for\r\nall HTTP traffic (thank Microsoft and their "IE as part of the OS policy" ). On the other hand if you use another\r\nbrowser (Opera/Mozilla/Firefox) and configure a proxy there you''ll be configuring a proxy just for that browser. We don''t\r\nknow of any BT client that allows a proxy to be specified explicitly.', '1', 7, 4),
650(60, 'item', 'Why can''t I signup from behind a proxy?', 'It is our policy not to allow new accounts to be opened from behind a proxy.', '1', 7, 5),
651(61, 'item', 'Does this apply to other torrent sites?', 'This section was written for Template Shares, a closed, port 80-81 tracker. Other trackers may be open or closed, and many listen\r\non e.g. ports 6868 or 6969. The above does <b>not</b> necessarily apply to other trackers.', '1', 7, 6),
652(62, 'item', 'Maybe my address is blacklisted?', 'The site blocks addresses listed in the (former) <a class=altlink href="http://methlabs.org/">PeerGuardian</a>\r\ndatabase, as well as addresses of banned users. This works at Apache/PHP level, it''s just a script that\r\nblocks <i>logins</i> from those addresses. It should not stop you from reaching the site. In particular\r\nit does not block lower level protocols, you should be able to ping/traceroute the server even if your\r\naddress is blacklisted. If you cannot then the reason for the problem lies elsewhere.<br>\r\n<br>\r\nIf somehow your address is indeed blocked in the PG database do not contact us about it, it is not our\r\npolicy to open <i>ad hoc</i> exceptions. You should clear your IP with the database maintainers instead.', '1', 8, 1),
653(63, 'item', 'Your ISP blocks the site''s address', '(In first place, it''s unlikely your ISP is doing so. DNS name resolution and/or network problems are the usual culprits.)\r\n<br>\r\nThere''s nothing we can do.\r\nYou should contact your ISP (or get a new one). Note that you can still visit the site via a proxy, follow the instructions\r\nin the relevant section. In this case it doesn''t matter if the proxy is anonymous or not, or which port it listens to.<br>\r\n<br>\r\nNotice that you will always be listed as an "unconnectable" client because the tracker will be unable to\r\ncheck that you''re capable of accepting incoming connections.', '1', 8, 2),
654(64, 'item', 'Alternate port (81)', 'Some of our torrents use ports other than the usual HTTP port 80. This may cause problems for some users,\r\nfor instance those behind some firewall or proxy configurations.\r\n\r\nYou can easily solve this by editing the .torrent file yourself with any torrent editor, e.g.\r\n<a href="http://sourceforge.net/projects/burst/" class="altlink">MakeTorrent</a>,\r\nand replacing the announce url templateshares.net:81 with templateshares.net:80 or just templateshares.net.<br>\r\n<br>\r\nEditing the .torrent with Notepad is not recommended. It may look like a text file, but it is in fact\r\na bencoded file. If for some reason you must use a plain text editor, change the announce url to\r\ntemplateshares.net:80, not templateshares.net. (If you''re thinking about changing the number before the\r\nannounce url instead, you know too much to be reading this.)', '2', 8, 3),
655(65, 'item', 'You can try these:', 'Post in the <a class="altlink" href="forums">Forums</a>, by all means. You''ll find they\r\nare usually a friendly and helpful place,\r\nprovided you follow a few basic guidelines:\r\n<ul>\r\n<li>Make sure your problem is not really in this FAQ. There''s no point in posting just to be sent\r\nback here.\r\n<li>Before posting read the sticky topics (the ones at the top). Many times new information that\r\nstill hasn''t been incorporated in the FAQ can be found there.</li>\r\n<li>Help us in helping you. Do not just say "it doesn''t work!". Provide details so that we don''t\r\nhave to guess or waste time asking. What client do you use? What''s your OS? What''s your network setup? What''s the exact\r\nerror message you get, if any? What are the torrents you are having problems with? The more\r\nyou tell the easiest it will be for us, and the more probable your post will get a reply.</li>\r\n<li>And needless to say: be polite. Demanding help rarely works, asking for it usually does\r\nthe trick.', '1', 9, 1),
656(66, 'item', 'Why do I get a "Not authorized (You are downloading your maximum number of allowed torrents - x)" error ?', 'This is part of the "Slot System". The slot system is being used to limit the concurrent downloads for users that have ratio below 0.95 and uploaded < 9.5 gb<br><br>\r\nIn detail: <br><br>\r\nUsers with ratio < 0.5 / Uploaded < 5 gb have only 1 download slot available <br>\r\nUsers with ratio < 0.65 / Uploaded < 6.5 gb have only 2 download slots available <br>\r\nUsers with ratio < 0.8 / Uploaded < 8 gb have only 3 download slots available <br>\r\nUsers with ratio < 0.95 / Uploaded < 9.5 gb have only 4 download slots available <br>\r\nUsers with ratio > 0.95 / Uploaded > 9.5 gb have unlimited download slots <br><br>\r\nIn all cases the seeding slots are unlimited. However if you have already filled all your available download slots and try to start seeding you will receive the same error. In this case you must free at least one download slot in order to start all your seeds and then start the download. If all your download slots are filled the system will deny any connection before validating if you want to download or seed. So first start your seeds and after that your downloads. <br>\r\n<br><br>\r\nIn any time, you can check your available slots in the member bar on top of the page <br><br>\r\nYou should also know that the slots for every user are calculated every 30min. Which means that if you cross a ratio barrier for more or less slots the tracker will need up to 30 min to be informed of this change, inspite of the maximum slots that you can see on your member bar.<br>', '3', 5, 12),
657(67, 'item', 'What is the passkey System? How does it work? ', 'The passkey system has been implemented in order to substitute the ip checking system. This means that the tracker doesnt check anymore your logged ip in order to verify if you are logged in or registered with the tracker. Every user has a personal passkey, a random key generated by the system. When a user tries to download a torrent, its personal passkey is imprinted in the tracker url of the torrent, allowing to the tracker to identify any source connected on it. In this way, you can seed a torrent for example, at home and at your office simultaneously without any problem with the 2 different ips. Per torrent 3 simultaneous connections are permitted per user, and in case of leeching only 1 (That means you can leech a torrent from one location only at a time.', '3', 5, 13),
658(68, 'item', 'Why do i get a "Unknown Passkey" error? ', 'You will get this error, firstly if you are not registered on our tracker, or if you havent downloaded the torrent to use from our webpage, when you were logged in. In this case, just register or log in and redownload the torrent.\r\n\r\nThere is a chance to get this error also, at the first time you download anything as a new user, or at the first download after you reset your passkey. The reason is simply that the tracker reviews the changes in the passkeys every few minutes and not instantly. For that reason just leave the torrent running for a few minutes, and you will get eventually an OK message from the tracker.', '3', 5, 14),
659(69, 'item', 'When do i need to reset my passkey? ', '<ul><li> If your passkey has been leeched and other user(s) uses it to download torrents using your account. In this case, you will see torrents stated in your account that you are not leeching or seeding .</li>\r\n<li> When your clients hangs up or your connection is terminated without pressing the stop button of your client. In this case, in your account you will see that you are still leeching/seeding the torrents even that your client has been closed. Normally these "ghost peers" will be cleaned automatically within 30 minutes, but if you want to resume your downloads and the tracker denied that due to the fact that you "already are downloading the same torrents - Connection limit error" then you should reset your passkey and redownload the torrent, then resume it. </li></ul>', '3', 5, 15),
660(70, 'item', 'What is DHT and Why must i turn it off?', 'DHT must be disabled in your client, DHT can cause your stats to be recorded incorrectly and could be seen as cheating also disable PEX (peer exchange) Anyone using this will be banned for cheating the system. Check your snatchlist regularly to ensure stats are being recorded correctly, allow 30mins for the tracker to update your stats. ', '3', 5, 16);
661
662-- --------------------------------------------------------
663
664--
665-- Table structure for table `files`
666--
667
668DROP TABLE IF EXISTS `files`;
669CREATE TABLE `files` (
670 `id` int(10) unsigned NOT NULL auto_increment,
671 `torrent` int(10) unsigned NOT NULL default '0',
672 `filename` varchar(255) NOT NULL default '',
673 `size` bigint(20) unsigned NOT NULL default '0',
674 PRIMARY KEY (`id`),
675 KEY `torrent` (`torrent`)
676) TYPE=MyISAM AUTO_INCREMENT=1;
677
678--
679-- Dumping data for table `files`
680--
681
682
683-- --------------------------------------------------------
684
685--
686-- Table structure for table `forums`
687--
688
689DROP TABLE IF EXISTS `forums`;
690CREATE TABLE `forums` (
691 `sort` tinyint(3) unsigned NOT NULL default '0',
692 `id` int(10) unsigned NOT NULL auto_increment,
693 `name` varchar(60) NOT NULL default '',
694 `description` varchar(200) default NULL,
695 `minclassread` tinyint(3) unsigned NOT NULL default '0',
696 `minclasswrite` tinyint(3) unsigned NOT NULL default '0',
697 `postcount` int(10) unsigned NOT NULL default '0',
698 `topiccount` int(10) unsigned NOT NULL default '0',
699 `minclasscreate` tinyint(3) unsigned NOT NULL default '0',
700 `forid` tinyint(4) default '0',
701 PRIMARY KEY (`id`)
702) TYPE=MyISAM AUTO_INCREMENT=1;
703
704--
705-- Dumping data for table `forums`
706--
707
708INSERT INTO `forums` (`sort`, `id`, `name`, `description`, `minclassread`, `minclasswrite`, `postcount`, `topiccount`, `minclasscreate`, `forid`) VALUES (2, 1, 'General chat & discussion', 'Talk about anything here...', 0, 0, 0, 0, 0, 1),
709(1, 2, 'Announcements & News ', 'News and upcoming events', 0, 0, 0, 0, 0, 2),
710(3, 3, 'General Support & Help', 'Got any questions? Need help? Ask here!', 0, 0, 0, 0, 0, 1),
711(4, 4, 'Request to be Uploader', 'Uploader Requests', 4, 4, 0, 0, 4, 3);
712
713-- --------------------------------------------------------
714
715DROP TABLE IF EXISTS `overforums`;
716CREATE TABLE `overforums` (
717 `id` int(10) unsigned NOT NULL auto_increment,
718 `name` varchar(60) NOT NULL default '',
719 `description` varchar(200) default NULL,
720 `minclassview` tinyint(3) unsigned NOT NULL default '0',
721 `forid` tinyint(3) unsigned NOT NULL default '1',
722 `sort` tinyint(3) unsigned NOT NULL default '0',
723 PRIMARY KEY (`id`)
724) TYPE=MyISAM AUTO_INCREMENT=1;
725
726--
727-- Dumping data for table `overforums`
728--
729
730INSERT INTO `overforums` (`id`, `name`, `description`, `minclassview`, `forid`, `sort`) VALUES (1, 'General', '', 0, 1, 1),
731(2, 'Guidelines', '', 0, 1, 0),
732(3, 'Staff Forums', '', 4, 0, 3);
733
734
735
736-- --------------------------------------------------------
737
738--
739-- Table structure for table `friends`
740--
741
742DROP TABLE IF EXISTS `friends`;
743CREATE TABLE `friends` (
744 `id` int(10) unsigned NOT NULL auto_increment,
745 `userid` int(10) unsigned NOT NULL default '0',
746 `friendid` int(10) unsigned NOT NULL default '0',
747 PRIMARY KEY (`id`),
748 UNIQUE KEY `userfriend` (`userid`,`friendid`)
749) TYPE=MyISAM AUTO_INCREMENT=1;
750
751--
752-- Dumping data for table `friends`
753--
754
755
756-- --------------------------------------------------------
757
758--
759-- Table structure for table `invites`
760--
761
762DROP TABLE IF EXISTS `invites`;
763CREATE TABLE `invites` (
764 `id` int(10) unsigned NOT NULL auto_increment,
765 `inviter` int(10) unsigned NOT NULL default '0',
766 `invitee` varchar(80) NOT NULL default '',
767 `hash` varchar(32) NOT NULL default '',
768 `time_invited` datetime NOT NULL default '0000-00-00 00:00:00',
769 PRIMARY KEY (`id`),
770 KEY `inviter` (`id`)
771) TYPE=MyISAM AUTO_INCREMENT=1;
772
773--
774-- Dumping data for table `invites`
775--
776
777
778-- --------------------------------------------------------
779
780--
781-- Table structure for table `ips`
782--
783
784DROP TABLE IF EXISTS `ips`;
785CREATE TABLE `ips` (
786 `id` int(10) unsigned NOT NULL auto_increment,
787 `userid` int(10) unsigned NOT NULL,
788 `ip` varchar(15) NOT NULL default '',
789 PRIMARY KEY (`id`)
790) TYPE=MyISAM AUTO_INCREMENT=1;
791
792--
793-- Dumping data for table `ips`
794--
795
796
797-- --------------------------------------------------------
798
799--
800-- Table structure for table `leecherspmlog`
801--
802
803DROP TABLE IF EXISTS `leecherspmlog`;
804CREATE TABLE `leecherspmlog` (
805 `id` int(10) unsigned NOT NULL auto_increment,
806 `user` int(10) unsigned NOT NULL default '0',
807 `date` datetime default NULL,
808 PRIMARY KEY (`id`)
809) TYPE=MyISAM AUTO_INCREMENT=1;
810
811--
812-- Dumping data for table `leecherspmlog`
813--
814
815
816-- --------------------------------------------------------
817
818--
819-- Table structure for table `loginattempts`
820--
821
822DROP TABLE IF EXISTS `loginattempts`;
823CREATE TABLE `loginattempts` (
824 `id` int(10) unsigned NOT NULL auto_increment,
825 `ip` varchar(15) NOT NULL default '',
826 `added` datetime NOT NULL default '0000-00-00 00:00:00',
827 `banned` enum('yes','no') NOT NULL default 'no',
828 `attempts` int(10) NOT NULL default '0',
829 `type` enum('login','recover') NOT NULL default 'login',
830 PRIMARY KEY (`id`)
831) TYPE=MyISAM AUTO_INCREMENT=1;
832
833--
834-- Dumping data for table `loginattempts`
835--
836
837
838-- --------------------------------------------------------
839
840--
841-- Table structure for table `messages`
842--
843DROP TABLE IF EXISTS `messages`;
844CREATE TABLE `messages` (
845 `id` int(10) unsigned NOT NULL auto_increment,
846 `sender` int(10) unsigned NOT NULL default '0',
847 `receiver` int(10) unsigned NOT NULL default '0',
848 `added` datetime default NULL,
849 `subject` varchar(30) NOT NULL default 'No Subject',
850 `msg` text,
851 `unread` enum('yes','no') NOT NULL default 'yes',
852 `poster` bigint(20) unsigned NOT NULL default '0',
853 `location` smallint(6) NOT NULL default '1',
854 `saved` enum('no','yes') NOT NULL default 'no',
855 PRIMARY KEY (`id`),
856 KEY `receiver` (`receiver`)
857) TYPE=MyISAM AUTO_INCREMENT=1 ;
858
859
860--
861-- Dumping data for table `messages`
862--
863
864-- --------------------------------------------------------
865
866--
867-- Table structure for table `news`
868--
869
870DROP TABLE IF EXISTS `news`;
871CREATE TABLE `news` (
872 `id` int(10) unsigned NOT NULL auto_increment,
873 `userid` int(11) NOT NULL default '0',
874 `added` datetime NOT NULL default '0000-00-00 00:00:00',
875 `body` text NOT NULL,
876 `title` varchar(100) NOT NULL default 'Title',
877 `cat` varchar(25) NOT NULL default '',
878 PRIMARY KEY (`id`),
879 KEY `added` (`added`)
880) TYPE=MyISAM AUTO_INCREMENT=1;
881DROP TABLE IF EXISTS `newscats`;
882CREATE TABLE `newscats` (
883 `id` int(10) NOT NULL auto_increment,
884 `name` varchar(50) NOT NULL default '',
885 `img` varchar(20) NOT NULL default '',
886 PRIMARY KEY (`id`)
887) TYPE=MyISAM AUTO_INCREMENT=1;
888
889
890
891-- --------------------------------------------------------
892
893--
894-- Table structure for table `notconnectablepmlog`
895--
896
897DROP TABLE IF EXISTS `notconnectablepmlog`;
898CREATE TABLE `notconnectablepmlog` (
899 `id` int(10) unsigned NOT NULL auto_increment,
900 `user` int(10) unsigned NOT NULL default '0',
901 `date` datetime default NULL,
902 PRIMARY KEY (`id`)
903) TYPE=MyISAM AUTO_INCREMENT=1;
904
905--
906-- Dumping data for table `notconnectablepmlog`
907--
908
909
910-- --------------------------------------------------------
911
912--
913-- Table structure for table `peers`
914--
915
916DROP TABLE IF EXISTS `peers`;
917CREATE TABLE `peers` (
918 `id` int(10) unsigned NOT NULL auto_increment,
919 `torrent` int(10) unsigned NOT NULL default '0',
920 `peer_id` varchar(20) NOT NULL default '',
921 `ip` varchar(64) NOT NULL default '',
922 `port` smallint(5) unsigned NOT NULL default '0',
923 `uploaded` bigint(20) unsigned NOT NULL default '0',
924 `downloaded` bigint(20) unsigned NOT NULL default '0',
925 `to_go` bigint(20) unsigned NOT NULL default '0',
926 `seeder` enum('yes','no') NOT NULL default 'no',
927 `started` datetime NOT NULL default '0000-00-00 00:00:00',
928 `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
929 `prev_action` datetime NOT NULL default '0000-00-00 00:00:00',
930 `connectable` enum('yes','no') NOT NULL default 'yes',
931 `userid` int(10) unsigned NOT NULL default '0',
932 `agent` varchar(60) NOT NULL default '',
933 `finishedat` int(10) unsigned NOT NULL default '0',
934 `downloadoffset` bigint(20) unsigned NOT NULL default '0',
935 `uploadoffset` bigint(20) unsigned NOT NULL default '0',
936 `passkey` varchar(32) NOT NULL default '',
937 PRIMARY KEY (`id`),
938 UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
939 KEY `torrent` (`torrent`),
940 KEY `torrent_seeder` (`torrent`,`seeder`),
941 KEY `last_action` (`last_action`),
942 KEY `connectable` (`connectable`),
943 KEY `userid` (`userid`)
944) TYPE=MyISAM AUTO_INCREMENT=1;
945
946--
947-- Dumping data for table `peers`
948--
949
950
951-- --------------------------------------------------------
952
953--
954-- Table structure for table `pollanswers`
955--
956
957DROP TABLE IF EXISTS `pollanswers`;
958CREATE TABLE `pollanswers` (
959 `id` int(10) unsigned NOT NULL auto_increment,
960 `pollid` int(10) unsigned NOT NULL default '0',
961 `userid` int(10) unsigned NOT NULL default '0',
962 `selection` tinyint(3) unsigned NOT NULL default '0',
963 PRIMARY KEY (`id`),
964 KEY `pollid` (`pollid`),
965 KEY `selection` (`selection`),
966 KEY `userid` (`userid`)
967) TYPE=MyISAM AUTO_INCREMENT=1;
968
969--
970-- Dumping data for table `pollanswers`
971--
972
973
974-- --------------------------------------------------------
975
976--
977-- Table structure for table `polls`
978--
979
980DROP TABLE IF EXISTS `polls`;
981CREATE TABLE `polls` (
982 `id` int(10) unsigned NOT NULL auto_increment,
983 `added` datetime NOT NULL default '0000-00-00 00:00:00',
984 `question` varchar(255) NOT NULL default '',
985 `option0` varchar(40) NOT NULL default '',
986 `option1` varchar(40) NOT NULL default '',
987 `option2` varchar(40) NOT NULL default '',
988 `option3` varchar(40) NOT NULL default '',
989 `option4` varchar(40) NOT NULL default '',
990 `option5` varchar(40) NOT NULL default '',
991 `option6` varchar(40) NOT NULL default '',
992 `option7` varchar(40) NOT NULL default '',
993 `option8` varchar(40) NOT NULL default '',
994 `option9` varchar(40) NOT NULL default '',
995 `option10` varchar(40) NOT NULL default '',
996 `option11` varchar(40) NOT NULL default '',
997 `option12` varchar(40) NOT NULL default '',
998 `option13` varchar(40) NOT NULL default '',
999 `option14` varchar(40) NOT NULL default '',
1000 `option15` varchar(40) NOT NULL default '',
1001 `option16` varchar(40) NOT NULL default '',
1002 `option17` varchar(40) NOT NULL default '',
1003 `option18` varchar(40) NOT NULL default '',
1004 `option19` varchar(40) NOT NULL default '',
1005 `sort` enum('yes','no') NOT NULL default 'yes',
1006 PRIMARY KEY (`id`)
1007) TYPE=MyISAM AUTO_INCREMENT=1;
1008
1009--
1010-- Dumping data for table `polls`
1011--
1012
1013
1014
1015-- --------------------------------------------------------
1016
1017--
1018-- Table structure for table `posts`
1019--
1020
1021DROP TABLE IF EXISTS `posts`;
1022CREATE TABLE `posts` (
1023 `id` int(10) unsigned NOT NULL auto_increment,
1024 `topicid` int(10) unsigned NOT NULL default '0',
1025 `userid` int(10) unsigned NOT NULL default '0',
1026 `added` datetime default NULL,
1027 `body` text ,
1028 `editedby` int(10) unsigned NOT NULL default '0',
1029 `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
1030 `subject` text ,
1031 PRIMARY KEY (`id`),
1032 KEY `topicid` (`topicid`),
1033 KEY `userid` (`userid`),
1034 FULLTEXT KEY `body` (`body`)
1035) TYPE=MyISAM AUTO_INCREMENT=1;
1036
1037--
1038-- Dumping data for table `posts`
1039--
1040
1041
1042-- --------------------------------------------------------
1043
1044--
1045-- Table structure for table `ratings`
1046--
1047
1048DROP TABLE IF EXISTS `ratings`;
1049CREATE TABLE `ratings` (
1050 `torrent` int(10) unsigned NOT NULL default '0',
1051 `topic` int(10) unsigned NOT NULL default '0',
1052 `user` int(10) unsigned NOT NULL default '0',
1053 `rating` tinyint(3) unsigned NOT NULL default '0',
1054 `added` datetime NOT NULL default '0000-00-00 00:00:00'
1055) TYPE=MyISAM;
1056
1057--
1058-- Dumping data for table `ratings`
1059--
1060
1061
1062-- --------------------------------------------------------
1063
1064--
1065-- Table structure for table `readposts`
1066--
1067
1068DROP TABLE IF EXISTS `readposts`;
1069CREATE TABLE `readposts` (
1070 `id` int(10) unsigned NOT NULL auto_increment,
1071 `userid` int(10) unsigned NOT NULL default '0',
1072 `topicid` int(10) unsigned NOT NULL default '0',
1073 `lastpostread` int(10) unsigned NOT NULL default '0',
1074 PRIMARY KEY (`id`),
1075 KEY `userid` (`id`),
1076 KEY `topicid` (`topicid`)
1077) TYPE=MyISAM AUTO_INCREMENT=1;
1078
1079--
1080-- Dumping data for table `readposts`
1081--
1082
1083
1084-- --------------------------------------------------------
1085
1086--
1087-- Table structure for table `regimages`
1088--
1089
1090DROP TABLE IF EXISTS `regimages`;
1091CREATE TABLE `regimages` (
1092 `id` int(10) unsigned NOT NULL auto_increment,
1093 `imagehash` varchar(32) NOT NULL default '',
1094 `imagestring` varchar(8) NOT NULL default '',
1095 `dateline` bigint(30) NOT NULL default '0',
1096 `added` datetime NOT NULL default '0000-00-00 00:00:00',
1097 PRIMARY KEY (`id`)
1098) TYPE=MyISAM AUTO_INCREMENT=1;
1099
1100--
1101-- Dumping data for table `regimages`
1102--
1103
1104
1105-- --------------------------------------------------------
1106
1107--
1108-- Table structure for table `reports`
1109--
1110
1111DROP TABLE IF EXISTS `reports`;
1112CREATE TABLE `reports` (
1113 `id` int(10) unsigned NOT NULL auto_increment,
1114 `addedby` int(10) unsigned NOT NULL default '0',
1115 `added` datetime NOT NULL default '0000-00-00 00:00:00',
1116 `votedfor` int(10) unsigned NOT NULL default '0',
1117 `votedfor_xtra` int(10) unsigned NOT NULL default '0',
1118 `type` enum('torrent','user','forum','comment') NOT NULL default 'torrent',
1119 `reason` varchar(255) NOT NULL default '',
1120 `dealtby` int(10) unsigned NOT NULL default '0',
1121 `dealtwith` tinyint(1) NOT NULL default '0',
1122 PRIMARY KEY (`id`)
1123) TYPE=MyISAM AUTO_INCREMENT=1;
1124
1125--
1126-- Dumping data for table `reports`
1127--
1128
1129
1130-- --------------------------------------------------------
1131
1132--
1133-- Table structure for table `rules`
1134--
1135
1136DROP TABLE IF EXISTS `rules`;
1137CREATE TABLE `rules` (
1138 `id` int(11) NOT NULL auto_increment,
1139 `title` varchar(255) NOT NULL default '',
1140 `text` text NOT NULL,
1141 `public` enum('yes','no') NOT NULL default 'yes',
1142 `class` int(11) NOT NULL default '0',
1143 PRIMARY KEY (`id`)
1144) TYPE=MyISAM AUTO_INCREMENT=9;
1145
1146--
1147-- Dumping data for table `rules`
1148--
1149
1150INSERT INTO `rules` (`id`, `title`, `text`, `public`, `class`) VALUES
1151(1, '<h2>General rules - <font color=#004E98>Breaking these rules can and will get you banned!</font></h2>', '[*]Do not defy the moderators expressed wishes!\r\n[*]Do not upload our torrents to other trackers! (See the [url=faq.php#4][b]FAQ[/b][/url] for details.)\r\n[*]You will only get [b]one[/b] warning! After that it''s bye bye Kansas!!', 'yes', 5),
1152(2, '<h2>Downloading rules - <font color=#004E98>By not following these rules you will lose download privileges!</font></h2>', '[*]Access to the newest torrents is conditional on a good ratio! (See the [url=faq.php#5][b]FAQ[/b][/url] for details.)\r\n[*]Low ratios may result in severe consequences, including banning in extreme cases!', 'yes', 0),
1153(3, '<h2>General Forum Guidelines - <font color=#004E98>Please follow these guidelines or else you might end up with a warning!</font></h2>', '[*]No aggressive behaviour or flaming in the forums.\r\n[*]No trashing of other peoples topics (i.e. SPAM).\r\n[*]No language other than English in the forums.\r\n[*]No systematic foul language (and none at all on titles).\r\n[*]No links to warez or crack sites in the forums.\r\n[*]No requesting or posting of serials, CD keys, passwords or cracks in the forums.\r\n[*]No requesting if there has been no "[url=http://www.nforce.nl]scene[/url]" release in the last 7 days.\r\n[*]No bumping... (All bumped threads will be deleted.)\r\n[*]No images larger than 800x600, and preferably web-optimised.\r\n[*]No double posting. If you wish to post again, and yours is the last post in the thread please use the EDIT function, instead of posting a double.\r\n[*]Please ensure all questions are posted in the correct section! (Game questions in the Games section, Apps questions in the Apps section)\r\n[*]Last, please read the [url=faq.php][b]FAQ[/b][/url] before asking any questions!\r\n', 'yes', 0),
1154(4, '<h2>Avatar Guidelines - <font color=#004E98>Please try to follow these guidelines</font></h2>', '[*]The allowed formats are .gif, .jpg and .png.\r\n[*]Be considerate. Resize your images to a width of 150 px and a size of no more than 150 KB. (Browsers will rescale them anyway: smaller images will be expanded and will not look good; larger images will just waste bandwidth and CPU cycles.) For now this is just a guideline but it will be automatically enforced in the near future.\r\n[*]Do not use potentially offensive material involving porn, religious material, animal / human cruelty or ideologically charged images. Mods have wide discretion on what is acceptable. If in doubt PM one.', 'yes', 0),
1155(5, '<h2>Uploading rules - <font color=#004E98>Torrents violating these rules may be deleted without notice</font></h2>', '[*]All uploads must include a proper NFO.\r\n[*]Only scene releases. If it''s not on [url=http://www.nforce.nl][b]NFOrce[/b][/url] or [url=http://www.grokmusiq.com][b]grokMusiQ[/b][/url] then forget it!\r\n[*]The stuff must not be older than seven (7) days.\r\n[*]All files must be in original format (usually 14.3 MB RARs).\r\n[*]Pre-release stuff should be labeled with an *ALPHA* or *BETA* tag.\r\n[*]Make sure not to include any serial numbers, CD keys or similar in the description (you do [b]not[/b] need to edit the NFO!).\r\n[*]Make sure your torrents are well-seeded for at least 24 hours.\r\n[*]Do not include the release date in the torrent name.\r\n[*]Stay active! You risk being demoted if you have no active torrents.\r\n\r\nIf you have something interesting that somehow violate these rules (e.g. not ISO format), ask a mod and we might make an exception.', 'yes', 0),
1156(6, '<h2>Moderating Rules - <font color=#004E98>Use your better judgement!</font></h2>', '[*]The most important rule: Use your better judgment!\r\n[*]Don''t be afraid to say [b]NO[/b]! (a.k.a. "Helshad''s rule".)\r\n[*]Don''t defy another mod in public, instead send a PM or through IM.\r\n[*]Be tolerant! Give the user(s) a chance to reform.\r\n[*]Don''t act prematurely, let the users make their mistakes and THEN correct them.\r\n[*]Try correcting any "off topics" rather then closing a thread.\r\n[*]Move topics rather than locking them.\r\n[*]Be tolerant when moderating the Chit-chat section (give them some slack).\r\n[*]If you lock a topic, give a brief explanation as to why you''re locking it.\r\n[*]Before you disable a user account, send him/her a PM and if they reply, put them on a 2 week trial.\r\n[*]Don''t disable a user account until he or she has been a member for at least 4 weeks.\r\n[*][b]Always[/b] state a reason (in the user comment box) as to why the user is being banned / warned.', 'no', 4),
1157(7, '<h2>Moderating rules - <font color=#004E98>Whom to promote and why</font></h2>', '[*][b] Power User [/b] - Automatically given to (and revoked from) users who have been members for at least 4 weeks, have uploaded at least 25 GB and have a share ratio above 1.05. Moderator changes of status last only until the next execution of the script.\r\n[*][img]/pic/star.gif[/img]- This status is given ONLY by General SysOp since he is the only one who can verify that they actually donated something.\r\n[*][b] VIP [/b] - Conferred to users you feel contribute something special to the site. (Anyone begging for VIP status will be automatically disqualified)\r\n[*][b] Other [/b] - Customised title given to special users only (Not available to Users or Power Users).\r\n[*][b][color=#4040c0] Uploader [/color][/b] - Appointed by Admins/SysOp. Send a PM to some Admin or SysOp if you think you''ve got a good candidate.\r\n[*][b][color=#A83838] Modetator [/color][/b] - Appointed by SysOp only. Send a PM to some SysOp if you think you''ve got a good candidate.', 'no', 4),
1158(8, '<h2>Moderating options - <font color=#004E98>What are my privileges as a mod?</font></h2>', '[*]You can delete and edit forum posts.\r\n[*]You can delete and edit torrents.\r\n[*]You can delete and change users avatars.\r\n[*]You can disable user accounts.\r\n[*]You can edit the title of VIP''s.\r\n[*]You can see the complete info of all users.\r\n[*]You can add comments to users (for other mods and admins to read).\r\n[*]You can stop reading now ''cuz you already knew about these options.\r\n[*]Lastly, check out the [url=staff.php][b]Staff[/b][/url] page (top right corner).', 'no', 4);
1159
1160-- --------------------------------------------------------
1161
1162--
1163-- Table structure for table `shoutbox`
1164--
1165
1166DROP TABLE IF EXISTS `shoutbox`;
1167CREATE TABLE `shoutbox` (
1168 `id` smallint(6) NOT NULL auto_increment,
1169 `userid` smallint(6) NOT NULL default '0',
1170 `username` varchar(25) NOT NULL default '',
1171 `date` int(11) NOT NULL default '0',
1172 `text` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1173 PRIMARY KEY (`id`)
1174) TYPE=MyISAM AUTO_INCREMENT=1;
1175
1176--
1177-- Dumping data for table `shoutbox`
1178--
1179
1180
1181
1182-- --------------------------------------------------------
1183
1184--
1185-- Table structure for table `sitelog`
1186--
1187
1188DROP TABLE IF EXISTS `sitelog`;
1189CREATE TABLE `sitelog` (
1190 `id` int(10) unsigned NOT NULL auto_increment,
1191 `added` datetime default NULL,
1192 `txt` text ,
1193 PRIMARY KEY (`id`),
1194 KEY `added` (`added`)
1195) TYPE=MyISAM AUTO_INCREMENT=1;
1196
1197--
1198-- Dumping data for table `sitelog`
1199--
1200
1201
1202-- --------------------------------------------------------
1203
1204--
1205-- Table structure for table `snatched`
1206--
1207
1208DROP TABLE IF EXISTS `snatched`;
1209CREATE TABLE `snatched` (
1210 `id` int(11) NOT NULL auto_increment,
1211 `torrentid` int(11) default '0',
1212 `userid` int(11) default '0',
1213 `torrent` int(10) unsigned NOT NULL default '0',
1214 `torrent_name` varchar(255) NOT NULL default '',
1215 `torrent_category` int(10) unsigned NOT NULL default '0',
1216 `port` smallint(5) unsigned NOT NULL default '0',
1217 `uploaded` bigint(20) unsigned NOT NULL default '0',
1218 `downloaded` bigint(20) unsigned NOT NULL default '0',
1219 `to_go` bigint(20) unsigned NOT NULL default '0',
1220 `seeder` enum('yes','no') NOT NULL default 'no',
1221 `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
1222 `startdat` datetime NOT NULL default '0000-00-00 00:00:00',
1223 `completedat` datetime NOT NULL default '0000-00-00 00:00:00',
1224 `connectable` enum('yes','no') NOT NULL default 'yes',
1225 `agent` varchar(60) NOT NULL default '',
1226 `finished` enum('yes','no') NOT NULL default 'no',
1227 PRIMARY KEY (`id`),
1228 KEY `finished` (`torrentid`),
1229 KEY `torrentid` (`userid`)
1230) TYPE=MyISAM AUTO_INCREMENT=1;
1231--
1232-- Dumping data for table `snatched`
1233--
1234
1235
1236-- --------------------------------------------------------
1237
1238--
1239-- Table structure for table `staffmessages`
1240--
1241
1242DROP TABLE IF EXISTS `staffmessages`;
1243CREATE TABLE `staffmessages` (
1244 `id` int(10) unsigned NOT NULL auto_increment,
1245 `sender` int(10) unsigned NOT NULL default '0',
1246 `added` datetime default NULL,
1247 `msg` text ,
1248 `subject` varchar(100) NOT NULL default '',
1249 `answeredby` int(10) unsigned NOT NULL default '0',
1250 `answered` tinyint(1) NOT NULL default '0',
1251 `answer` text ,
1252 PRIMARY KEY (`id`)
1253) TYPE=MyISAM AUTO_INCREMENT=1;
1254
1255--
1256-- Dumping data for table `staffmessages`
1257--
1258
1259
1260-- --------------------------------------------------------
1261
1262--
1263-- Table structure for table `stats`
1264--
1265
1266DROP TABLE IF EXISTS `stats`;
1267CREATE TABLE `stats` (
1268 `recordonline24` varchar(255) NOT NULL default '0'
1269) TYPE=MyISAM;
1270
1271--
1272-- Dumping data for table `stats`
1273--
1274
1275-- --------------------------------------------------------
1276
1277--
1278-- Table structure for table `thanks`
1279--
1280
1281DROP TABLE IF EXISTS `thanks`;
1282CREATE TABLE `thanks` (
1283 `torrentid` int(11) NOT NULL default '0',
1284 `userid` int(11) NOT NULL default '0',
1285 `id` int(11) NOT NULL auto_increment,
1286 PRIMARY KEY (`id`)
1287) TYPE=MyISAM;
1288
1289--
1290-- Dumping data for table `thanks`
1291--
1292
1293
1294-- --------------------------------------------------------
1295
1296--
1297-- Table structure for table `topics`
1298--
1299
1300DROP TABLE IF EXISTS `topics`;
1301CREATE TABLE `topics` (
1302 `id` int(10) unsigned NOT NULL auto_increment,
1303 `userid` int(10) unsigned NOT NULL default '0',
1304 `subject` varchar(40) default NULL,
1305 `locked` enum('yes','no') NOT NULL default 'no',
1306 `forumid` int(10) unsigned NOT NULL default '0',
1307 `lastpost` int(10) unsigned NOT NULL default '0',
1308 `sticky` enum('yes','no') NOT NULL default 'no',
1309 `views` int(10) unsigned NOT NULL default '0',
1310 `iconid` VARCHAR( 10 ) NOT NULL default '0',
1311 PRIMARY KEY (`id`),
1312 KEY `userid` (`userid`),
1313 KEY `subject` (`subject`),
1314 KEY `lastpost` (`lastpost`)
1315) TYPE=MyISAM AUTO_INCREMENT=1;
1316
1317--
1318-- Dumping data for table `topics`
1319--
1320
1321
1322-- --------------------------------------------------------
1323
1324--
1325-- Table structure for table `torrents`
1326--
1327
1328DROP TABLE IF EXISTS `torrents`;
1329CREATE TABLE `torrents` (
1330 `id` int(10) unsigned NOT NULL auto_increment,
1331 `info_hash` varchar(20) NOT NULL default '',
1332 `name` varchar(255) NOT NULL default '',
1333 `filename` varchar(255) NOT NULL default '',
1334 `save_as` varchar(255) NOT NULL default '',
1335 `search_text` text NOT NULL,
1336 `descr` text NOT NULL,
1337 `ori_descr` text NOT NULL,
1338 `category` int(10) unsigned NOT NULL default '0',
1339 `size` bigint(20) unsigned NOT NULL default '0',
1340 `added` datetime NOT NULL default '0000-00-00 00:00:00',
1341 `type` enum('single','multi') NOT NULL default 'single',
1342 `numfiles` int(10) unsigned NOT NULL default '0',
1343 `comments` int(10) unsigned NOT NULL default '0',
1344 `views` int(10) unsigned NOT NULL default '0',
1345 `hits` int(10) unsigned NOT NULL default '0',
1346 `times_completed` int(10) unsigned NOT NULL default '0',
1347 `leechers` int(10) unsigned NOT NULL default '0',
1348 `seeders` int(10) unsigned NOT NULL default '0',
1349 `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
1350 `visible` enum('yes','no') NOT NULL default 'yes',
1351 `banned` enum('yes','no') NOT NULL default 'no',
1352 `owner` int(10) unsigned NOT NULL default '0',
1353 `numratings` int(10) unsigned NOT NULL default '0',
1354 `ratingsum` int(10) unsigned NOT NULL default '0',
1355 `nfo` text NOT NULL,
1356 `free` enum('yes','no') default 'no',
1357 `doubleupload` enum('yes','no') default 'no',
1358 `seen` blob NOT NULL,
1359 `anonymous` enum('yes','no') NOT NULL default 'no',
1360 `sticky` enum('yes','no') NOT NULL default 'no',
1361 `tube` varchar(80) NOT NULL default '',
1362 `imageurl` text,
1363 PRIMARY KEY (`id`),
1364 UNIQUE KEY `info_hash` (`info_hash`),
1365 KEY `owner` (`owner`),
1366 KEY `visible` (`visible`),
1367 KEY `category_visible` (`category`,`visible`),
1368 FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)
1369) TYPE=MyISAM;
1370
1371--
1372-- Dumping data for table `torrents`
1373--
1374
1375
1376-- --------------------------------------------------------
1377
1378--
1379-- Table structure for table `uploadspeed`
1380--
1381
1382DROP TABLE IF EXISTS `uploadspeed`;
1383CREATE TABLE `uploadspeed` (
1384 `id` int(10) unsigned NOT NULL auto_increment,
1385 `name` varchar(50) default NULL,
1386 PRIMARY KEY (`id`)
1387) TYPE=MyISAM AUTO_INCREMENT=19;
1388
1389--
1390-- Dumping data for table `uploadspeed`
1391--
1392
1393INSERT INTO `uploadspeed` (`id`, `name`) VALUES (1, '64kbps'),
1394(2, '128kbps'),
1395(3, '256kbps'),
1396(4, '512kbps'),
1397(5, '768kbps'),
1398(6, '1Mbps'),
1399(7, '1.5Mbps'),
1400(8, '2Mbps'),
1401(9, '3Mbps'),
1402(10, '4Mbps'),
1403(11, '5Mbps'),
1404(12, '6Mbps'),
1405(13, '7Mbps'),
1406(14, '8Mbps'),
1407(15, '9Mbps'),
1408(16, '10Mbps'),
1409(17, '48Mbps'),
1410(18, '100Mbit');
1411
1412-- --------------------------------------------------------
1413
1414--
1415-- Table structure for table `users`
1416--
1417
1418DROP TABLE IF EXISTS `users`;
1419CREATE TABLE `users` (
1420 `id` int(10) unsigned NOT NULL auto_increment,
1421 `username` varchar(40) NOT NULL default '',
1422 `old_password` varchar(40) NOT NULL default '',
1423 `passhash` varchar(32) NOT NULL default '',
1424 `secret` varchar(20) NOT NULL default '',
1425 `email` varchar(80) NOT NULL default '',
1426 `status` enum('pending','confirmed') NOT NULL default 'pending',
1427 `added` datetime NOT NULL default '0000-00-00 00:00:00',
1428 `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
1429 `last_access` datetime NOT NULL default '0000-00-00 00:00:00',
1430 `forum_access` datetime NOT NULL default '0000-00-00 00:00:00',
1431 `last_staffmsg` datetime NOT NULL default '0000-00-00 00:00:00',
1432 `last_pm` datetime NOT NULL default '0000-00-00 00:00:00',
1433 `last_comment` datetime NOT NULL default '0000-00-00 00:00:00',
1434 `last_post` datetime NOT NULL default '0000-00-00 00:00:00',
1435 `last_shout` datetime NOT NULL default '0000-00-00 00:00:00',
1436 `editsecret` varchar(20) NOT NULL default '',
1437 `privacy` enum('strong','normal','low') NOT NULL default 'normal',
1438 `stylesheet` int(10) default '1',
1439 `info` text ,
1440 `acceptpms` enum('yes','friends','no') NOT NULL default 'yes',
1441 `commentpm` enum('yes','no') NOT NULL default 'yes',
1442 `ip` varchar(15) NOT NULL default '',
1443 `class` tinyint(3) unsigned NOT NULL default '0',
1444 `avatar` varchar(100) NOT NULL default '',
1445 `uploaded` bigint(20) unsigned NOT NULL default '0',
1446 `downloaded` bigint(20) unsigned NOT NULL default '0',
1447 `title` varchar(30) NOT NULL default '',
1448 `country` int(10) unsigned NOT NULL default '0',
1449 `notifs` varchar(100) NOT NULL default '',
1450 `modcomment` text NOT NULL,
1451 `enabled` enum('yes','no') NOT NULL default 'yes',
1452 `avatars` enum('yes','no') NOT NULL default 'yes',
1453 `donor` enum('yes','no') NOT NULL default 'no',
1454 `donated` decimal(8,2) NOT NULL default '0.00',
1455 `donoruntil` datetime NOT NULL default '0000-00-00 00:00:00',
1456 `total_donated` decimal(8,2) NOT NULL default '0.00',
1457 `warned` enum('yes','no') NOT NULL default 'no',
1458 `warneduntil` datetime NOT NULL default '0000-00-00 00:00:00',
1459 `torrentsperpage` int(3) unsigned NOT NULL default '0',
1460 `topicsperpage` int(3) unsigned NOT NULL default '0',
1461 `postsperpage` int(3) unsigned NOT NULL default '0',
1462 `deletepms` enum('yes','no') NOT NULL default 'yes',
1463 `savepms` enum('yes','no') NOT NULL default 'no',
1464 `support` enum('yes','no') NOT NULL default 'no',
1465 `supportfor` text NOT NULL default '',
1466 `supportlang` varchar(50) NOT NULL,
1467 `passkey` varchar(32) NOT NULL default '',
1468 `permban` enum('yes','no') NOT NULL default 'no',
1469 `last_browse` int(11) NOT NULL default '0',
1470 `uploadpos` enum('yes','no') NOT NULL default 'yes',
1471 `forumpost` enum('yes','no') NOT NULL default 'yes',
1472 `downloadpos` enum('yes','no') NOT NULL default 'yes',
1473 `clientselect` int(10) unsigned default '0',
1474 `signatures` enum('yes','no') NOT NULL default 'yes',
1475 `signature` varchar(225) NOT NULL default '',
1476 `tzoffset` int(10) NOT NULL default '0',
1477 `dst` enum('yes','no') NOT NULL default 'no',
1478 `cheat` smallint(6) NOT NULL default '0',
1479 `download` int(10) unsigned NOT NULL default '0',
1480 `upload` int(10) unsigned NOT NULL default '0',
1481 `invites` int(10) NOT NULL default '4',
1482 `invited_by` int(10) NOT NULL default '0',
1483 `gender` enum('Male','Female','N/A') NOT NULL default 'N/A',
1484 `vip_added` enum('yes','no') NOT NULL default 'no',
1485 `vip_until` datetime NOT NULL default '0000-00-00 00:00:00',
1486 `seedbonus` decimal(5,1) NOT NULL default '0.0',
1487 `bonuscomment` text NOT NULL,
1488 `parked` enum('yes','no') NOT NULL default 'no',
1489 `leechwarn` enum('yes','no') NOT NULL default 'no',
1490 `leechwarnuntil` datetime NOT NULL default '0000-00-00 00:00:00',
1491 `lastwarned` datetime NOT NULL default '0000-00-00 00:00:00',
1492 `timeswarned` int(10) NOT NULL default '0',
1493 `warnedby` varchar(40) NOT NULL default '',
1494 `page` text NOT NULL,
1495 `passhint` text,
1496 `hintanswer` text,
1497 `birthday` text,
1498 `skin` text,
1499 `subscription_pm` enum('yes','no') NOT NULL default 'no',
1500 `icq` VARCHAR( 255 ) NOT NULL,
1501 `msn` VARCHAR( 255 ) NOT NULL,
1502 `aim` VARCHAR( 255 ) NOT NULL,
1503 `yahoo` VARCHAR( 255 ) NOT NULL,
1504 `skype` VARCHAR( 255 ) NOT NULL,
1505 `pmbox` enum('yes','no') NOT NULL default 'yes',
1506 PRIMARY KEY (`id`),
1507 UNIQUE KEY `username` (`username`),
1508 KEY `status_added` (`status`,`added`),
1509 KEY `ip` (`ip`),
1510 KEY `uploaded` (`uploaded`),
1511 KEY `downloaded` (`downloaded`),
1512 KEY `country` (`country`),
1513 KEY `last_access` (`last_access`),
1514 KEY `enabled` (`enabled`),
1515 KEY `warned` (`warned`),
1516 KEY `cheat` (`cheat`)
1517) TYPE=MyISAM AUTO_INCREMENT=1;
1518DROP TABLE IF EXISTS `usergroups`;
1519CREATE TABLE IF NOT EXISTS `usergroups` (
1520 `id` int(10) NOT NULL AUTO_INCREMENT,
1521 `title` text NOT NULL,
1522 `description` text NOT NULL,
1523 `isbanned` enum('yes','no') NOT NULL DEFAULT 'no',
1524 `canpm` enum('yes','no') NOT NULL DEFAULT 'yes',
1525 `candwd` enum('yes','no') NOT NULL DEFAULT 'yes',
1526 `canup` enum('yes','no') NOT NULL DEFAULT 'no',
1527 `canreq` enum('yes','no') NOT NULL DEFAULT 'yes',
1528 `canof` enum('yes','no') NOT NULL DEFAULT 'yes',
1529 `canpc` enum('yes','no') NOT NULL DEFAULT 'yes',
1530 `canvo` enum('yes','no') NOT NULL DEFAULT 'yes',
1531 `canth` enum('yes','no') NOT NULL DEFAULT 'yes',
1532 `canka` enum('yes','no') NOT NULL DEFAULT 'yes',
1533 `canrp` enum('yes','no') NOT NULL DEFAULT 'no',
1534 `canusercp` enum('yes','no') NOT NULL DEFAULT 'yes',
1535 `canviewotherprofile` enum('yes','no') NOT NULL DEFAULT 'yes',
1536 `canchat` enum('yes','no') NOT NULL DEFAULT 'yes',
1537 `canmemberlist` enum('yes','no') NOT NULL DEFAULT 'yes',
1538 `canfriendslist` enum('yes','no') NOT NULL DEFAULT 'yes',
1539 `cantopten` enum('yes','no') NOT NULL DEFAULT 'yes',
1540 `cansettingspanel` enum('yes','no') NOT NULL DEFAULT 'no',
1541 `canstaffpanel` enum('yes','no') NOT NULL DEFAULT 'no',
1542 `showonstaff` enum('yes','no') NOT NULL DEFAULT 'no',
1543 `usernamestyle` varchar(255) NOT NULL DEFAULT '{u}',
1544 `pmquote` int(11) NOT NULL,
1545 `iscustom` enum('yes','no') NOT NULL DEFAULT 'yes',
1546 `minclasstopr` varchar(200) NOT NULL,
1547 `minclasstoedit` varchar(200) NOT NULL,
1548 `maxclasstopr` varchar(200) NOT NULL,
1549 `maxclasstoedit` varchar(200) NOT NULL,
1550 `candeletetorrent` enum('yes','no') NOT NULL DEFAULT 'no',
1551 `hasfreeleech` enum('yes','no') NOT NULL DEFAULT 'no',
1552 `antifloodcheck` enum('yes','no') NOT NULL DEFAULT 'yes',
1553 `antifloodtime` text NOT NULL,
1554 `args` text,
1555 PRIMARY KEY (`id`)
1556) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
1557
1558--
1559-- Salvarea datelor din tabel `usergroups`
1560--
1561
1562INSERT INTO `usergroups` (`id`, `title`, `description`, `isbanned`, `canpm`, `candwd`, `canup`, `canreq`, `canof`, `canpc`, `canvo`, `canth`, `canka`, `canrp`, `canusercp`, `canviewotherprofile`, `canchat`, `canmemberlist`, `canfriendslist`, `cantopten`, `cansettingspanel`, `canstaffpanel`, `showonstaff`, `usernamestyle`, `pmquote`, `iscustom`, `minclasstopr`, `minclasstoedit`, `maxclasstopr`, `maxclasstoedit`, `candeletetorrent`, `hasfreeleech`, `antifloodcheck`, `antifloodtime`, `args`) VALUES
1563(6, 'SysOp', 'Has the full power.', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', '<span style="color: #2587A7;"><strong>{u} </strong></span>', 1000, 'no', '7', '7', '7', '7', 'yes', 'yes', 'no', '0', 'a:1:{s:15:"canpostintopics";s:2:"no";}'),
1564(0, 'User', 'Simple User', 'no', 'yes', 'yes', 'no', 'no', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', '{u}', 23, 'no', '4', '4', '7', '7', 'no', 'no', 'yes', '60', 'a:1:{s:15:"canpostintopics";s:3:"yes";}'),
1565(1, 'Power User', 'The Class above user', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', '<span style="color: #f9a200;"><strong>{u}</strong></span>', 50, 'no', '4', '4', '7', '7', 'no', 'no', 'yes', '30', NULL),
1566(2, 'Vip', 'If a user donated to the tracker, he is vip', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', '<span style="color: #009F00;"><strong>{u} </strong></span>', 900, 'no', '4', '4', '7', '7', 'no', 'no', 'yes', '25', NULL),
1567(3, 'Uploader', 'User with upload privileges.', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no', '<span style="color:#6464FF;"><strong>{u} </strong></span>', 200, 'no', '4', '4', '7', '7', 'no', 'no', 'yes', '25', NULL),
1568(4, 'Moderator', 'Can delete torrents,forum posts, etc...', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', '<span style="color: #ff5151;"><strong>{u}</strong></span>', 250, 'no', '5', '5', '7', '7', 'yes', 'yes', 'no', '0', 'a:1:{s:15:"canpostintopics";s:2:"no";}'),
1569(5, 'Administrator', 'Almost full power :)', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', '<span style="color: #CC00FF;"><strong><em>{u} </em></strong></span>', 500, 'no', '6', '6', '7', '7', 'yes', 'yes', 'no', '0', 'a:1:{s:15:"canpostintopics";s:2:"no";}'),
1570(7, 'Staff Leader', 'The user with the supreme power :D :P', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', '<span style="color: darkred;"><strong><em>{u} </em></strong></span>', 1000000000, 'no', '7', '7', '7', '7', 'yes', 'yes', 'no', '0', 'a:1:{s:15:"canpostintopics";s:3:"yes";}');
1571UPDATE usergroups SET id=0 WHERE title='User' LIMIT 1;
1572ALTER TABLE `topics` ADD `numratings` int(10) unsigned NOT NULL default '0';
1573ALTER TABLE `topics` ADD `ratingsum` int(10) unsigned NOT NULL default '0';
1574DROP TABLE IF EXISTS `subscriptions`;
1575CREATE TABLE `subscriptions` (
1576 `id` int(10) unsigned NOT NULL auto_increment,
1577 `userid` int(10) unsigned NOT NULL default '0',
1578 `topicid` int(10) unsigned NOT NULL default '0',
1579 PRIMARY KEY (`id`)
1580);
1581DROP TABLE IF EXISTS `searchcloud`;
1582CREATE TABLE `searchcloud` (
1583`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
1584`searchedfor` VARCHAR( 50 ) NOT NULL ,
1585`howmuch` INT( 10 ) NOT NULL ,
1586PRIMARY KEY ( `id` )
1587) TYPE = MYISAM;
1588DROP TABLE IF EXISTS `subs`;
1589CREATE TABLE `subs` (
1590 `id` int(10) unsigned NOT NULL auto_increment,
1591 `title` varchar(255) NOT NULL default '',
1592 `filename` varchar(255) NOT NULL default '',
1593 `cd` int(10) unsigned NOT NULL default '0',
1594 `frame` varchar(255) NOT NULL default '',
1595 `comment` text NOT NULL,
1596 `added` datetime default NULL,
1597 `size` int(10) unsigned NOT NULL default '0',
1598 `uppedby` int(10) unsigned NOT NULL default '0',
1599 `url` varchar(255) NOT NULL default '',
1600 `hits` int(10) unsigned NOT NULL default '0',
1601 PRIMARY KEY (`id`)
1602) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1603DROP TABLE IF EXISTS `options`;
1604CREATE TABLE IF NOT EXISTS `options` (
1605 `option_name` varchar(64) NOT NULL default '',
1606 `option_value` longtext NOT NULL,
1607 PRIMARY KEY (`option_name`),
1608 KEY `option_name` (`option_name`)
1609) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=165 ;
1610DROP TABLE IF EXISTS `transferlog`;
1611CREATE TABLE `transferlog` (
1612`added` datetime NOT NULL,
1613`fromid` int(10) NOT NULL,
1614`toid` int(10) NOT NULL,
1615`amountmb` int(10) NOT NULL,
1616`comment` varchar(185) default 'No Comment'
1617) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1618
1619DROP TABLE IF EXISTS `stafftools`;
1620CREATE TABLE `stafftools` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` text NOT NULL,`file` text NOT NULL,`desc` text NOT NULL,`usergroups` text NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
1621
1622INSERT INTO `stafftools` VALUES('1', 'Manage tracker categories', 'category.php', 'Here you can manage all tracker categories', '[6],[7]');
1623INSERT INTO `stafftools` VALUES('2', 'Manage Tracker Countries', 'country.php', 'Here you can manage all tracker countries', '[6],[7]');
1624INSERT INTO `stafftools` VALUES('3', 'Manage Tracker Forums', 'forummanage.php', 'Edit/Delete forum', '[6],[7]');
1625INSERT INTO `stafftools` VALUES('4', 'Mysql Stats', 'mysql_stats.php', 'See MySql stats', '[6],[7]');
1626INSERT INTO `stafftools` VALUES('5', 'Mass Mailer', 'massmail.php', 'Send e-mail to all users on the tracker', '[6],[7]');
1627INSERT INTO `stafftools` VALUES('6', 'Do Cleanup', 'docleanup.php', 'Do cleanup functions', '[6],[7]');
1628INSERT INTO `stafftools` VALUES('7', 'FAQ Manage', 'faqmanage.php', 'Edit/Add/Delete FAQ Page', '[6],[7]');
1629INSERT INTO `stafftools` VALUES('8', 'RULES Manage', 'modrules.php', 'Edit/Add/Delete RULES Page', '[6],[7]');
1630INSERT INTO `stafftools` VALUES('9', 'View Log', 'log.php', 'Show Logs', '[6],[7]');
1631INSERT INTO `stafftools` VALUES('10', 'Add Bonus Points', 'amountbonus.php', 'Add Bonus Points to ALL Users or one user.', '[6],[7]');
1632INSERT INTO `stafftools` VALUES('11', 'Ban System', 'bans.php', 'Ban / Unban IP', '[6],[7]');
1633INSERT INTO `stafftools` VALUES('12', 'Change Email', 'changemail.php', 'Change User Email Address', '[6],[7]');
1634INSERT INTO `stafftools` VALUES('13', 'Change Username', 'changeusername.php', 'Change UserName', '[6],[7]');
1635INSERT INTO `stafftools` VALUES('14', 'View Reports', 'reports.php', 'View all reports', '[6],[7]');
1636INSERT INTO `stafftools` VALUES('15', 'Spam', 'spam.php', 'Check Spam Pms', '[6],[7]');
1637INSERT INTO `stafftools` VALUES('16', 'Failed Logins', 'maxlogin.php', 'Show Failed Login Attempts', '[6],[7]');
1638INSERT INTO `stafftools` VALUES('17', 'Ban Agent', 'agentban.php', 'User Agent Ban', '[6],[7]');
1639INSERT INTO `stafftools` VALUES('18', 'Delete account', 'delacctadmin.php', 'Delete User Account', '[6],[7]');
1640INSERT INTO `stafftools` VALUES('19', 'Bitbucket', 'bitbucketlog.php', 'Bitbucket Log', '[6],[7]');
1641INSERT INTO `stafftools` VALUES('20', 'Ban email address', 'bannedemails.php', 'Ban EMAILs stop registration.', '[6],[7]');
1642INSERT INTO `stafftools` VALUES('21', 'Optimize & Repair', 'optimize.php', 'Optimize & Repair tables.', '[6],[7]');
1643INSERT INTO `stafftools` VALUES('22', 'Traceroute', 'traceroute.php', 'Trace single IP', '[6],[7]');
1644INSERT INTO `stafftools` VALUES('23', 'Poll overview', 'polloverview.php', 'View poll votes', '[6],[7]');
1645INSERT INTO `stafftools` VALUES('24', 'Pending users confirmation', 'pusers.php', 'Here you can confirm unconfirmed accounts', '[5],[6],[7]');
1646INSERT INTO `stafftools` VALUES('25', 'Reset themes', 'resetheme.php', 'Set all user defined themes to default', '[6],[7]');
1647INSERT INTO `stafftools` VALUES('26', 'Add User', 'adduser.php', 'Create new user account', '[5],[6],[7]');
1648INSERT INTO `stafftools` VALUES('27', 'List Unconfirmed Users', 'unco.php', 'View unconfirmed accounts', '[5],[6],[7]');
1649INSERT INTO `stafftools` VALUES('28', 'Reset users password', 'reset.php', 'Rest lost Passwords', '[5],[6],[7]');
1650INSERT INTO `stafftools` VALUES('29', 'Mass PM', 'staffmess.php', 'Send PM to all users', '[5],[6],[7]');
1651INSERT INTO `stafftools` VALUES('30', 'Find not connectable users', 'notconnectable.php', 'View All Unconnectable Users', '[4],[5],[6],[7]');
1652INSERT INTO `stafftools` VALUES('31', 'Warned users', 'warned.php', 'See all warned users on tracker', '[5],[6],[7]');
1653INSERT INTO `stafftools` VALUES('32', 'Free Leech', 'freeleech.php', 'Set ALL Torrents FREE or NORMAL with one click', '[5],[6],[7]');
1654INSERT INTO `stafftools` VALUES('33', 'Reports', 'reports.php', 'Show Reports (forum,comment,torrent)', '[5],[6],[7]');
1655INSERT INTO `stafftools` VALUES('34', 'Tracker Statistics', 'statistics.php', 'View detailed and many statistics about your site', '[4],[5],[6],[7]');
1656INSERT INTO `stafftools` VALUES('35', 'Mass Re-seed', 'mass_reseed.php', 'Request an mass reseed.', '[4],[5],[6],[7]');
1657INSERT INTO `stafftools` VALUES('36', 'Leechers', 'leechers.php', 'Show users with ratio under 0.40', '[4],[5],[6],[7]');
1658INSERT INTO `stafftools` VALUES('37', 'Uploader Info Panel', 'uploaderinfopanel.php', 'Addon to monitor uploades activity', '[4],[5],[6],[7]');
1659INSERT INTO `stafftools` VALUES('38', 'Ratio 100', 'ratio100.php', 'Show users with ratio above 100', '[4],[5],[6],[7]');
1660INSERT INTO `stafftools` VALUES('39', 'Abnormal Upload Speed Detector', 'cheaters.php', 'See cheaters', '[4],[5],[6],[7]');
1661INSERT INTO `stafftools` VALUES('40', 'Duplicate IP Check', 'ipcheck.php', 'Check for Duplicate IP Users', '[4],[5],[6],[7]');
1662INSERT INTO `stafftools` VALUES('41', 'Show All Clients', 'allagents.php', 'Show All Clients (currently downloading/uploading/seeding)', '[4],[5],[6],[7]');
1663INSERT INTO `stafftools` VALUES('42', 'Show Users', 'userslist.php', 'List Registered Users.', '[4],[5],[6],[7]');
1664INSERT INTO `stafftools` VALUES('43', 'Staff BOX', 'staffbox.php', 'Staffbox (Staff Contacts)', '[4],[5],[6],[7]');
1665INSERT INTO `stafftools` VALUES('44', 'Make Poll', 'makepoll.php', 'Make a new poll', '[4],[5],[6],[7]');
1666INSERT INTO `stafftools` VALUES('45', 'Uploaders', 'uploaders.php', 'Uploaders', '[4],[5],[6],[7]');
1667INSERT INTO `stafftools` VALUES('46', 'List Polls', 'polloverview.php', 'List Polls', '[4],[5],[6],[7]');
1668INSERT INTO `stafftools` VALUES('47', 'Stats', 'stats.php', 'Tracker Stats', '[4],[5],[6],[7]');
1669INSERT INTO `stafftools` VALUES('48', 'Ip Test', 'testip.php', 'IP Test', '[4],[5],[6],[7]');
1670INSERT INTO `stafftools` VALUES('49', 'Ip to country', 'iptocountry.php', 'Determine from which country a user is using an ip', '[4],[5],[6],[7]');
1671INSERT INTO `stafftools` VALUES('50', 'Ip to country', 'iptocountry.php', 'Determine from which country a user is using an ip', '[4],[5],[6],[7]');
1672INSERT INTO `stafftools` VALUES('51', 'Ip to country', 'iptocountry.php', 'Determine from which country a user is using an ip', '[4],[5],[6],[7]');
1673INSERT INTO `stafftools` VALUES('52', 'Database Tools', 'database.php', 'Here you can repair, backup and do many things with your mysql database.', '[7]');
1674
1675DROP TABLE IF EXISTS `peerguardian`;
1676CREATE TABLE `peerguardian` (
1677 `first` text NOT NULL,
1678 `last` text NOT NULL,
1679 `comment` text NOT NULL
1680) TYPE=MyISAM AUTO_INCREMENT=1;