Bravo List
Register
Go Back   > Bravo List > Source Code > Trackers > TBDev
Reply
  #1  
Old 18-07-18, 16:30
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Support
 
Join Date: Jul 2013
P2P
Posts: 288
Default Don't use
Code:
CREATE TABLE invite_codes (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender` int(10) unsigned NOT NULL DEFAULT '0',
  `receiver` varchar(32) NOT NULL DEFAULT '0',
  `code` varchar(32) NOT NULL DEFAULT '',
  `invite_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` enum('Pending','Confirmed') NOT NULL DEFAULT 'Pending',
  PRIMARY KEY (`id`),
  KEY `sender` (`id`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks` (
  `arg` varchar(20) collate utf8_unicode_ci NOT NULL,
  `value_s` text collate utf8_unicode_ci NOT NULL,
  `value_i` int(11) NOT NULL default '0',
  `value_u` int(10) unsigned NOT NULL default '0',
  `task` varchar(20) NOT NULL default '',
  `last_time` int(10) NOT NULL default '0',
  PRIMARY KEY  (`task`),
  KEY  (`arg`)
) ENGINE=MyISAM;

INSERT INTO `tasks` (`task`, `last_time`) VALUES 
('cleanup', 1189677270);
INSERT INTO `tasks` VALUES ('lastcleantime', '', 0, 0);
INSERT INTO `tasks` VALUES ('loadlimit', '2.6919-1275592591', 0, 0);
INSERT INTO `tasks` VALUES ('inactivemail', '0', 0, 0);
INSERT INTO `tasks` VALUES ('optimizedb', '', 0, 0);

DROP TABLE IF EXISTS `announce`;
CREATE TABLE `announce` (
`id` INT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`url` VARCHAR( 255 ) NOT NULL ,
`torrent` INT( 10 ) UNSIGNED NOT NULL ,
`seeders` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`leechers` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`times_completed` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`completed` int(10) UNSIGNED NOT NULL DEFAULT '0',
`online` ENUM( 'yes', 'no' ) NOT NULL DEFAULT 'yes',
INDEX ( `torrent` )
) ENGINE = MYISAM ;

CREATE TABLE attachments (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`topicid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`filename` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`size` bigint(20) unsigned NOT NULL default '0',
`owner` int(10) unsigned NOT NULL default '0',
`downloads` int(10) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`type` varchar(100) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `topicid` (`topicid`),
KEY `postid` (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `attachmentdownloads` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fileid` int(10) NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `userid` int(10) NOT NULL default '0',
  `date` int(11) NOT NULL default '0',
  `downloads` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `fileid_userid` (`fileid`,`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(15) NOT NULL default '',
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `addedby` int(10) unsigned NOT NULL DEFAULT '0',
  `bantime` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `first` int(11) DEFAULT NULL,
  `last` int(11) DEFAULT NULL,
`admin` int(10) unsigned NOT NULL default '0',  
  `lifted` bigint(30) NOT NULL default '0',
  `reason` varchar(255) NOT NULL default '',  
  PRIMARY KEY (`id`),
  KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE config (
  `mysql_host` varchar(255) NOT NULL default '',
  `mysql_db` varchar(255) NOT NULL default '',
  `mysql_user` varchar(255) NOT NULL default '',
  `mysql_pass` varchar(255) NOT NULL default '',
  `site_url` varchar(255) NOT NULL default '',
  `announce_url` varchar(255) NOT NULL default '',
  `site_online` varchar(255) NOT NULL default '',
  `members_only` varchar(255) NOT NULL default '',
  `site_mail` varchar(255) NOT NULL default '',
  `email_confirm` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `site_name` varchar(255) NOT NULL default '',
  `image_dic` varchar(255) NOT NULL default '',
  `torrent_dic` varchar(255) NOT NULL default '',
  `peer_limit` varchar(255) NOT NULL default '',
  `max_members` varchar(255) NOT NULL default '',
  `max_users_then_invite` int(10) UNSIGNED DEFAULT '5000' NOT NULL,
  `invites` int(10) UNSIGNED DEFAULT '2500' NOT NULL,
  `signup_timeout` varchar(255) NOT NULL default '',
  `min_votes` varchar(255) NOT NULL default '',
  `autoclean_interval` varchar(255) NOT NULL default '',
  `announce_interval` varchar(255) NOT NULL default '',
  `max_torrent_size` varchar(255) NOT NULL,
  `max_dead_torrent_time` varchar(255) NOT NULL default '',
  `posts_read_expiry` varchar(255) NOT NULL default '',
  `max_login_attempts` varchar(255) NOT NULL default '',
  `dictbreaker` varchar(255) NOT NULL default '',
  `delete_old_torrents` varchar(255) NOT NULL default '',
  `dead_torrents` varchar(255) NOT NULL default '',
  `site_reputation` enum('true','false') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `maxfilesize` varchar(255) NOT NULL default '',
  `attachment_dir` varchar(255) NOT NULL default '',
  `forum_width` varchar(255) NOT NULL default '',
  `maxsubjectlength` varchar(255) NOT NULL default '',
  `postsperpage` varchar(255) NOT NULL default '',
  `use_attachment_mod` varchar(255) NOT NULL default '',
  `use_poll_mod` varchar(255) NOT NULL default '',
  `forum_stats_mod` varchar(255) NOT NULL default '',
  `use_flood_mod` varchar(255) NOT NULL default '',
  `limmit` varchar(255) NOT NULL default '',
  `minutes` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`mysql_host`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci";

CREATE TABLE IF NOT EXISTS `adminpanel` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `title` varchar(50) default NULL,
  `url` varchar(50) default NULL,
  `desc` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2011 ;

-- 
-- Dumping data for table `adminpanel`
-- 

INSERT INTO `adminpanel` (`id`, `username`, `title`, `url`, `desc`) VALUES 
(1, 'system', 'Add user', 'admin/adduser.php', 'Create new account'),
(2, 'system', 'List Unconfirmed Users', 'admin/unconfirmed.php', 'View unconfirmed accounts'),
(3, 'system', 'Reset Users Password', 'admin/resetpassword.php', 'Rest lost Passwords'),
(4, 'system', 'Mass PM', 'admin/staffmessage.php', 'Send PM to all users'),
(6, 'system', 'List Unconnectable Users', 'admin/findnotconnectable.php', 'View All Unconnectable Users'),
(7, 'system', 'Traceroute', 'admin/traceroute.php', 'Trace single IP'),
(8, 'system', 'Warned users', 'admin/warnedusers.php', 'See all warned users'),
(9, 'system', 'Delete Account', 'admin/delaccounts.php', 'Delete Accounts'),
(10, 'system', 'FreeLeech', 'admin/freeleech.php', 'Set all torrents FREE or NORMAL');

CREATE TABLE IF NOT EXISTS `moderators` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `can_editposts`  enum("yes","no") NOT NULL default '',
  `can_deleteposts` char(3) NOT NULL default '',
 `can_openclosethreads` char(3) NOT NULL default '',
  `canmanagethreads` char(3) NOT NULL default '', 
  `viewips` char(3) NOT NULL default ''
  PRIMARY KEY  (`mid`),
  KEY `uid` (`uid`,`fid`)
) TYPE=MyISAM ;

CREATE TABLE `bonus` (
  `id` int(5) NOT NULL auto_increment,
  `bonusname` varchar(50) NOT NULL default '',
  `points` decimal(10,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',
  `pointspool` decimal(10,1) NOT NULL default '1.0',
  `enabled` enum('yes','no') NOT NULL default 'yes' COMMENT 'This will determined a switch if the bonus is enabled or not! enabled by default',
  `minpoints` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

INSERT INTO `bonus` (`id`, `bonusname`, `points`, `description`, `art`, `menge`) VALUES 
(1, '1.0 GB 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', 1073741824),
(2, '2.5 GB Uploaded', 500.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),
(3, '5 GB Uploaded', 800.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),
(4, '3 Invites', 100.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),
(5, 'Custom Title!', 250.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),
(6, 'VIP Status', 950.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),
(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);
 --------------------------------------------------------

-- 
-- Table structure for table `blocks`
-- 

CREATE TABLE IF NOT EXISTS `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',
  `blocktitle` varchar(255) not null default 'blockTitle',
  PRIMARY KEY  (`id`),
  KEY `ufriend` (`userid`,`blockid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `torrent` int(10) unsigned NOT NULL DEFAULT '0',
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `size` bigint(20) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `torrent` (`torrent`),
  FULLTEXT KEY `filename` (`filename`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `completed`;
CREATE TABLE `completed` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) NOT NULL default '0',
  `torrentid` int(10) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE `userid_torrentid` (`userid`, `torrentid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE categories (
  id int(10) unsigned NOT NULL auto_increment,
  name varchar(30) NOT NULL default '',
  image varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `sort_index` int(10) unsigned NOT NULL default '0',
  `image` varchar(255) NOT NULL default '',
  `cat_desc` varchar(30) NOT NULL default '',
  `minclassread` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `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',
  `editedby` int(10) unsigned NOT NULL default '0',
  `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `text` text NOT NULL,
  `news` int(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user` (`user`),
  KEY `torrent` (`torrent`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `countries`;
CREATE TABLE countries (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `flagpic` varchar(50) default NULL,
  `domain` char(3) default NULL,  
  PRIMARY KEY  (id)
) TYPE=MyISAM;

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)
) TYPE=MyISAM;

DROP TABLE IF EXISTS `languages`;
CREATE TABLE `languages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `languages` (`id`, `uri`, `name`) VALUES 
(1, 'english.php', 'English');

DROP TABLE IF EXISTS `shoutbox`;
CREATE TABLE `shoutbox` (
  `msgid` int(10) unsigned NOT NULL auto_increment,
  `user` varchar(50) NOT NULL default '0',
  `message` text,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `userid` int(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`msgid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `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',
  `subject` text NOT NULL DEFAULT '',
  `location` enum('in','out','both','draft','template') NOT NULL default 'in',
  PRIMARY KEY  (`id`),
  KEY `receiver` (`receiver`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `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',
  `title` varchar(255) NOT NULL default '',
  `body` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `added` (`added`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `news` (`id`, `userid`, `added`, `title`, `body`) VALUES 
(1, 1, '2011-07-27 09:29:22', 'Welcome', 'Welcome To Tv2');



CREATE TABLE IF NOT EXISTS `community_adminsessions` (
  `sid` varchar(32) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `loginkey` varchar(50) NOT NULL default '',
  `ip` varchar(40) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `lastactive` bigint(30) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `community_badwords` (
  `bid` int(10) unsigned NOT NULL auto_increment,
  `badword` varchar(100) NOT NULL default '',
  `replacement` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`bid`)
) TYPE=MyISAM ;

CREATE TABLE IF NOT EXISTS `community_banned` (
  `uid` int(10) unsigned NOT NULL default '0',
  `gid` int(10) unsigned NOT NULL default '0',
  `oldgroup` int(10) unsigned NOT NULL default '0',
  `admin` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `bantime` varchar(50) NOT NULL default '',
  `lifted` bigint(30) NOT NULL default '0',
  `reason` varchar(255) NOT NULL default '',
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `community_captcha` (
  `imagehash` varchar(32) NOT NULL default '',
  `imagestring` varchar(8) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  KEY `imagehash` (`imagehash`),
  KEY `dateline` (`dateline`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `awaitingactivation` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `code` varchar(100) NOT NULL default '',
  `type` char(1) NOT NULL default '',
  `oldgroup` bigint(30) NOT NULL default '0',
  `misc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM ;

CREATE TABLE IF NOT EXISTS `community_datacache` (
  `title` varchar(50) NOT NULL default '',
  `cache` mediumtext NOT NULL,
  PRIMARY KEY  (`title`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `community_events` (
  `eid` int(10) unsigned NOT NULL auto_increment,
  `subject` varchar(120) NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `date` varchar(50) NOT NULL default '',
  `description` text NOT NULL,
  `private` char(3) NOT NULL default '',
  PRIMARY KEY  (`eid`),
  KEY `private` (`private`)
) TYPE=MyISAM ;

-- use top 10 mod --
CREATE TABLE IF NOT EXISTS `community_favorites` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0',
  `type` char(1) NOT NULL default '',
  PRIMARY KEY  (`fid`),
  KEY `uid` (`uid`),
  KEY `tid` (`tid`,`type`)
) TYPE=MyISAM ;

CREATE TABLE IF NOT EXISTS `community_forumpermissions` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `fid` int(10) unsigned NOT NULL default '0',
  `gid` int(10) unsigned NOT NULL default '0',
  `canview` char(3) NOT NULL default '',
  `canviewthreads` char(3) NOT NULL default '',
  `candlattachments` char(3) NOT NULL default '',
  `canpostthreads` char(3) NOT NULL default '',
  `canpostreplys` char(3) NOT NULL default '',
  `canpostattachments` char(3) NOT NULL default '',
  `canratethreads` char(3) NOT NULL default '',
  `caneditposts` char(3) NOT NULL default '',
  `candeleteposts` char(3) NOT NULL default '',
  `candeletethreads` char(3) NOT NULL default '',
  `caneditattachments` char(3) NOT NULL default '',
  `canpostpolls` char(3) NOT NULL default '',
  `canvotepolls` char(3) NOT NULL default '',
  `cansearch` char(3) NOT NULL default '',
  PRIMARY KEY  (`pid`)
) TYPE=MyISAM ;

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)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `community_forums` (
  `fid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `linkto` varchar(180) NOT NULL default '',
  `type` char(1) NOT NULL default '',
  `pid` smallint(5) unsigned NOT NULL default '0',
  `parentlist` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `active` char(3) NOT NULL default '',
  `open` char(3) NOT NULL default '',
  `threads` int(10) unsigned NOT NULL default '0',
  `posts` int(10) unsigned NOT NULL default '0',
  `lastpost` int(10) unsigned NOT NULL default '0',
  `lastposter` varchar(120) NOT NULL default '',
  `lastposteruid` int(10) unsigned NOT NULL default '0',
  `lastposttid` int(10) NOT NULL default '0',
  `lastpostsubject` varchar(120) NOT NULL default '',
  `allowhtml` char(3) NOT NULL default '',
  `allowmycode` char(3) NOT NULL default '',
  `allowsmilies` char(3) NOT NULL default '',
  `allowimgcode` char(3) NOT NULL default '',
  `allowpicons` char(3) NOT NULL default '',
  `allowtratings` char(3) NOT NULL default '',
  `status` int(4) NOT NULL default '1',
  `usepostcounts` char(3) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `showinjump` char(3) NOT NULL default '',
  `modposts` char(3) NOT NULL default '',
  `modthreads` char(3) NOT NULL default '',
  `modattachments` char(3) NOT NULL default '',
  `style` smallint(5) unsigned NOT NULL default '0',
  `overridestyle` char(3) NOT NULL default '',
  `rulestype` smallint(1) NOT NULL default '0',
  `rulestitle` varchar(200) NOT NULL default '',
  `rules` text NOT NULL,
  `unapprovedthreads` int(10) unsigned NOT NULL default '0',
  `unapprovedposts` int(10) unsigned NOT NULL default '0',
  `defaultdatecut` smallint(4) unsigned NOT NULL default '0',
  `defaultsortby` varchar(10) NOT NULL default '',
  `defaultsortorder` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`fid`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

CREATE TABLE IF NOT EXISTS `community_forumsubscriptions` (
  `fsid` int(10) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fsid`)
) TYPE=MyISAM ;

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)
) TYPE=MyISAM;

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)
) TYPE=MyISAM;

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',
 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'TBNews', 
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `added` (`added`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `peers` (
  id int(10) unsigned NOT NULL auto_increment,
  torrent int(10) unsigned NOT NULL default '0',
  peer_id varchar(20) binary 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)
) TYPE=MyISAM;


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)
) TYPE=MyISAM;

CREATE TABLE `sitelog` (
  id int(10) unsigned NOT NULL auto_increment,
  added datetime default NULL,
  txt text,
  PRIMARY KEY  (id),
  KEY added (added)
) TYPE=MyISAM;

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)
) TYPE=MyISAM;

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)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `helpdocs` (
  `hid` smallint(5) unsigned NOT NULL auto_increment,
  `sid` smallint(5) unsigned NOT NULL default '0',
  `name` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `document` text NOT NULL,
  `usetranslation` char(3) NOT NULL default '',
  `enabled` char(3) NOT NULL default '',
  `disporder` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`hid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

CREATE TABLE IF NOT EXISTS `community_helpsections` (
  `sid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `description` text NOT NULL,
  `usetranslation` char(3) NOT NULL default '',
  `enabled` char(3) NOT NULL default '',
  `disporder` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

INSERT INTO `community_helpsections` (`sid`, `name`, `description`, `usetranslation`, `enabled`, `disporder`) VALUES 
(1, 'User Maintenance', 'Basic instructions for maintaining a forum account.', 'yes', 'yes', 1),
(2, 'Posting', 'Posting, replying, and basic usage of forum.', 'yes', 'yes', 2);

CREATE TABLE IF NOT EXISTS `badge_icons` (
  `iid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(120) NOT NULL default '',
  `path` varchar(220) NOT NULL default '',
  PRIMARY KEY  (`iid`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;

CREATE TABLE IF NOT EXISTS `mybblog` (
  `uid` int(10) unsigned NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `fid` smallint(5) unsigned NOT NULL default '0',
  `tid` int(10) unsigned NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `action` text NOT NULL,
  `data` text NOT NULL,
  `ipaddress` varchar(50) NOT NULL default '',
  KEY `tid` (`tid`)
) TYPE=MyISAM;

CREATE TABLE IF NOT EXISTS `mybb_modtools` (
  `tid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(200) NOT NULL default '',
  `description` text NOT NULL,
  `forums` text NOT NULL,
  `type` char(1) NOT NULL default '',
  `postoptions` text NOT NULL,
  `threadoptions` text NOT NULL,
  PRIMARY KEY  (`tid`)
) TYPE=MyISAM ;

CREATE TABLE IF NOT EXISTS `mybb_posts` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `replyto` int(10) unsigned NOT NULL default '0',
  `fid` smallint(5) unsigned NOT NULL default '0',
  `subject` varchar(120) NOT NULL default '',
  `icon` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(80) NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `message` text NOT NULL,
  `ipaddress` varchar(30) NOT NULL default '',
  `includesig` char(3) NOT NULL default '',
  `smilieoff` char(3) NOT NULL default '',
  `edituid` int(10) unsigned NOT NULL default '0',
  `edittime` int(10) NOT NULL default '0',
  `visible` int(1) NOT NULL default '0',
  `posthash` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`pid`),
  KEY `tid` (`tid`,`uid`),
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`),
  FULLTEXT KEY `message` (`message`)
) TYPE=MyISAM ;

CREATE TABLE IF NOT EXISTS `community_profilefields` (
  `fid` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `disporder` smallint(5) unsigned NOT NULL default '0',
  `type` text NOT NULL,
  `length` smallint(5) unsigned NOT NULL default '0',
  `maxlength` smallint(5) unsigned NOT NULL default '0',
  `required` char(3) NOT NULL default '',
  `editable` char(3) NOT NULL default '',
  `hidden` char(3) NOT NULL default '',
  PRIMARY KEY  (`fid`)
) TYPE=MyISAM ;

CREATE TABLE IF NOT EXISTS `reputation` (
  `rid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `adduid` int(10) unsigned NOT NULL default '0',
  `reputation` bigint(30) NOT NULL default '0',
  `dateline` bigint(30) NOT NULL default '0',
  `comments` text NOT NULL,
  PRIMARY KEY  (`rid`),
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`)
) TYPE=MyISAM ;

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) binary 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) binary 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',
  passkey varchar(32) NOT NULL default '',
  tzoffset tinyint(2) NOT NULL default '0',
  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)
) TYPE=MyISAM;


CREATE TABLE IF NOT EXISTS `sessions` (
  `sid` varchar(32) NOT NULL default '',
  `uid` int(10) unsigned NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '',
  `time` bigint(30) NOT NULL default '0',
  `location` varchar(150) NOT NULL default '',
  `useragent` varchar(100) NOT NULL default '',
  `anonymous` int(1) NOT NULL default '0',
  `nopermission` int(1) NOT NULL default '0',
  `location1` int(10) NOT NULL default '0',
  `location2` int(10) NOT NULL default '0',
  `loginattempts` tinyint(2) NOT NULL default '1',
  `failedlogin` bigint(30) NOT NULL default '0',
  PRIMARY KEY  (`sid`),
  KEY `location1` (`location1`),
  KEY `location2` (`location2`),
  KEY `time` (`time`),
  KEY `uid` (`uid`)
) TYPE=MyISAM;

INSERT INTO `stylesheets` (`id`, `uri`, `name`) VALUES 
(1, 'default', 'Default');

INSERT INTO categories VALUES (5,'Movies','cat_movies.gif');
INSERT INTO categories VALUES (6,'Music','cat_music.gif');
INSERT INTO categories VALUES (23,'Anime','cat_anime.gif');
INSERT INTO categories VALUES (22,'Apps/andriod','cat_apps.gif');
INSERT INTO categories VALUES (22,'Apps/ios','cat_apps.gif');

DROP TABLE IF EXISTS `teams`;
CREATE TABLE `teams` (
  `id` int(10) NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `owner` int(10) NOT NULL default '0',
  `info` text,
  `name` varchar(255) default NULL,
  `image` varchar(255) default NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `secret` varchar(20) binary NOT NULL default '' COLLATE latin1_bin,
  `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) binary NOT NULL default '' COLLATE latin1_bin,
  `privacy` enum('strong','normal','low') NOT NULL default 'normal',
  `stylesheet` int(10) default '1',
  `language` varchar(20) NOT NULL default '1',
  `info` text,
  `acceptpms` enum('yes','no') NOT NULL default 'yes',
  `ip` varchar(39) NOT NULL default '',
  `class` tinyint(3) unsigned NOT NULL default '1',
  `signup_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `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 '',
  `donated` int(5) unsigned NOT NULL default '0',
  `country` int(10) unsigned NOT NULL default '0',
  `notifs` varchar(100) NOT NULL default '',
  `enabled` varchar(10) NOT NULL default 'yes',
  `modcomment` text default NULL,
  `gender` varchar(6) NOT NULL default '',
  `client` varchar(25) NOT NULL default '',
  `age` int(3) NOT NULL default '0',
  `warned` char(3) NOT NULL default 'no',
  `signature` varchar(200) NOT NULL default '',
  `last_browse` int(11) NOT NULL default '0',
  `forumbanned` char(3) NOT NULL default 'no',
  `invited_by` int(10) NOT NULL default '0',
  `invitees` varchar(100) NOT NULL default '',
  `invites` smallint(5) NOT NULL default '0',
  `invitedate` datetime NOT NULL default '0000-00-00 00:00:00',
  `commentpm` enum('yes','no') NOT NULL default 'yes',
  `passkey` varchar(32) NOT NULL default '',
  `page` text,
  `team` int(10) unsigned NOT NULL default '0',
  `tzoffset` int(4) default 0,
  `hideshoutbox` enum('yes', 'no') NOT NULL DEFAULT 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `status_added` (`status`,`added`),
  KEY `ip` (`ip`),
  KEY `uploaded` (`uploaded`),
  KEY `downloaded` (`downloaded`),
  KEY `country` (`country`)
) ENGINE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;
Don't use yet did it on mobile have yet to sort out, work in process.
Reply With Quote
  #2  
Old 18-07-18, 16:55
Napon's Avatar
Napon Napon is offline
Senior Member
 
Join Date: Feb 2016
P2P
Posts: 313
Default
Lol tt code are you going to use tt ex torrants mod lol as you know its never going to work.. only if you know what your doing lol
Reply With Quote
  #3  
Old 18-07-18, 17:17
BamBam0077's Avatar
BamBam0077 BamBam0077 is offline
Support
 
Join Date: Jul 2013
P2P
Posts: 288
Default
Lol, torrent trader,ts,freetsp,tbdev,mybb,u232 if you wanted to a hit of that here some good old your gonna need it to smoke my arse about programming or hip-hop you grass hopper

Bump:
Code:
DROP TABLE IF EXISTS `{PREFIX}pref`;
CREATE TABLE IF NOT EXISTS `{PREFIX}pref` (
  `pref_target` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `pref_name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `pref_value` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `{PREFIX}pref` (`pref_target`, `pref_name`, `pref_value`) VALUES
('time', 'adjust', ''),
('time', 'date', ''),
('time', 'joined', 'j-F y'),
('time', 'long', 'F j Y, H:i'),
('time', 'offset', '0.0'),
('time', 'short', 'd m Y - H:i'),
('time', 'tiny', ''),
('time', 'use_relative', '1'),
('time', 'use_relative_format', '{--}, H:i');
Should cover:
[code]
$TBDEV['time_adjust'] = 0;
$TBDEV['time_offset'] = '0';
$TBDEV['time_use_relative'] = 1;
$TBDEV['time_use_relative_format'] = '{--}, h:i A';
$TBDEV['time_joined'] = 'j-F y';
$TBDEV['time_short'] = 'jS F Y - h:i A';
$TBDEV['time_long'] = 'M j Y, h:i A';
$TBDEV['time_tiny'] = '';
$TBDEV['time_date'] = '';
[CODE]

You need to patch up where I made mistakes I would check but my laptop is outta action. my tbdev dbconn SQL backend I have to put it together will in the next few days or so as I need it to move forward!

Code:
<?php
/*********************************\ 
  DO NOT EDIT THIS FILE, PLEASE USE
  THE SETTINGS PANEL!!
\*********************************/
if(!defined('IN_INSTALL')){
  die('Hacking attempt!');
}
error_reporting(E_ALL);
date_default_timezone_set('Europe/London');
const REQUIRED_PHP = 50300, REQUIRED_PHP_VERSION = '5.3.0';

if (PHP_VERSION_ID < REQUIRED_PHP) {

die('PHP '.REQUIRED_PHP_VERSION.' or higher is required.');
}

define('SQL_DEBUG', 1);
define('TIME_NOW', time());
define('EMAIL_CONFIRM', true);
define('XBT_TRACKER', false);

// Cookie setup
$TBDEV['cookie_prefix']  = 'alpha_'; // This allows you to have multiple trackers, eg for demos, testing etc.
$TBDEV['cookie_path']    = ''; // ATTENTION: You should never need this unless the above applies eg: /tbdev
$TBDEV['cookie_domain']  = ''; // set to eg: .somedomain.com or is subdomain set to: .sub.somedomain.com

$cryptdb = mysqli_connect("localhost", "root", "");
if (!$cryptdb) { 
die("Could not connect: " . mysqli_error());
} 
return $cryptdb;

// start here!
// select * from config.sql
$sql = 'SELECT * FROM config';
// sql query to run above sql request
$result = sql_query($cryptdb, $sql);
// while $result -> $config
while($info = mysqli_fetch_assoc($result)){ 

$TBDEV['time_adjust'] =  $info["time_adjust"];
$TBDEV['time_offset'] = $info["time_offset"]; 
$TBDEV['time_use_relative'] = $info["time_use_relative"];
$TBDEV['time_use_relative_format'] = $info["time_use_relative_format"];
$TBDEV['time_joined'] = $info["time_joined"];
$TBDEV['time_short'] = $info["time_short"];
$TBDEV['time_long'] = $info["time_long"];
$TBDEV['time_tiny'] = $info["time_tiny"];
$TBDEV['time_date'] = $info["time_date"];

// DB setup
$TBDEV['mysql_host'] = $info["mysql_host"];
$TBDEV['mysql_user'] = $info["mysql_user"];
$TBDEV['mysql_pass'] = $info["mysql_pass"];
$TBDEV['mysql_db']   = $info["mysql_db"];

// Settings 
$TBDEV['site_online'] = $info["site_online"];
$TBDEV['maxusers'] = $info["maxusers"]; 
$TBDEV['domain'] = $info["domain"];
$TBDEV['site_name'] = $info["site_name"];
$TBDEV['site_email']  = $info["site_email"];
$TBDEV['language'] = $info["language"];
$TBDEV['char_set'] = $info["char_set"];
$TBDEV['announce_interval'] = $info["announce_interval"];
$TBDEV['tracker_post_key'] = $info["tracker_post_key"];
$TBDEV['max_torrent_size'] = $info["max_torrent_size"];
$TBDEV['max_dead_torrent_time'] = $info["max_dead_torrent_time"];
$TBDEV['signup_timeout'] = $info["signup_timeout"];
$TBDEV['pic_base_url'] = $info["pic_base_url"];
$TBDEV['stylesheet'] = $info["stylesheet"];
$TBDEV['readpost_expiry'] = $info["readpost_expiry"];
$TBDEV['autoclean_interval'] = $info["autoclean_interval"];
$TBDEV['announce_url'] = $info["announce_url"];
$TBDEV['msg_alert'] = $info["msg_alert"];
$TBDEV['minvotes'] = $info["minvotes"];
$TBDEV['av_img_height'] = $info["av_img_height"];
$TBDEV['av_img_width'] = $info["av_img_width"];
}

define('DIR_PATH', dirname($_SERVER['SCRIPT_FILENAME']).'/');
$TBDEV['sql_error_log'] = DIR_PATH.'/libs/logs/'.date("M_D_Y").'sql_err.log';

$TBDEV['allowed_ext'] = array('image/gif', 'image/png', 'image/jpeg');
// DB setup
$TBDEV['mysql_host'] = "localhost";
$TBDEV['mysql_user'] = "root";
$TBDEV['mysql_pass'] = "";
$TBDEV['mysql_db']   = "tbdev";


                              
$TBDEV['site_online'] = 1;
$TBDEV['tracker_post_key'] = 'changethisorelse';
$TBDEV['max_torrent_size'] = 1000000;
$TBDEV['announce_interval'] = 60 * 30;
$TBDEV['signup_timeout'] = 86400 * 3;
$TBDEV['minvotes'] = 1;
$TBDEV['max_dead_torrent_time'] = 6 * 3600;

// Max users on site
$TBDEV['maxusers'] = 5000; // LoL Who we kiddin' here?


if ( strtoupper( substr(PHP_OS, 0, 3) ) == 'WIN' )
  {
    $file_path = str_replace( "\\", "/", dirname(__FILE__) );
    $file_path = str_replace( "/include", "", $file_path );
  }
  else
  {
    $file_path = dirname(__FILE__);
    $file_path = str_replace( "/include", "", $file_path );
  }
  
define('ROOT_PATH', $file_path);
$TBDEV['torrent_dir'] = ROOT_PATH . '/torrents'; # must be writable for httpd user   

# the first one will be displayed on the pages
$TBDEV['announce_urls'] = array();
$TBDEV['announce_urls'][] = "http://localhost/announce.php";
//$TBDEV['announce_urls'] = "http://localhost:2710/announce";
//$TBDEV['announce_urls'] = "http://domain.com:83/announce.php";

if ($_SERVER["HTTP_HOST"] == "")
  $_SERVER["HTTP_HOST"] = $_SERVER["SERVER_NAME"];
  
$TBDEV['baseurl'] = "http://" . $_SERVER["HTTP_HOST"]."/";

/*
## DO NOT UNCOMMENT THIS: IT'S FOR LATER USE!
$host = getenv( 'SERVER_NAME' );
$script = getenv( 'SCRIPT_NAME' );
$script = str_replace( "\\", "/", $script );

  if( $host AND $script )
  {
    $script = str_replace( '/index.php', '', $script );

    $TBDEV['baseurl'] = "http://{$host}{$script}";
  }
*/

//set this to true to make this a tracker that only registered users may use
//$TBDEV['membersonly'] = 1; //deprecated no longer needed

//maximum number of peers (seeders+leechers) allowed before torrents starts to be deleted to make room...
//set this to something high if you don't require this feature
//$TBDEV['peerlimit'] = 50000; //deprecated. no longer used.

// Email for sender/return path.
$TBDEV['site_email'] = "coldfusion@localhost";

$TBDEV['site_name'] = "TBDEV.NET";

$TBDEV['language'] = 'en';
//charset
$TBDEV['char_set'] = 'UTF-8'; //also to be used site wide in meta tags
if (ini_get('default_charset') != $TBDEV['char_set']) {
ini_set('default_charset',$TBDEV['char_set']);
}
$TBDEV['msg_alert'] = 0; // saves a query when off

$TBDEV['autoclean_interval'] = 900;
$TBDEV['pic_base_url'] = "./pic/";
$TBDEV['stylesheet'] = "./1.css";
$TBDEV['readpost_expiry'] = 14*86400; // 14 days
//set this to size of user avatars
$TBDEV['av_img_height'] = 100;
$TBDEV['av_img_width'] = 100;
$TBDEV['allowed_ext'] = array('image/gif', 'image/png', 'image/jpeg');
// Set this to the line break character sequence of your system
//$TBDEV['linebreak'] = "\r\n"; // not used at present.

define ('UC_USER', 0);
define ('UC_POWER_USER', 1);
define ('UC_VIP', 2);
define ('UC_UPLOADER', 3);
define ('UC_MODERATOR', 4);
define ('UC_ADMINISTRATOR', 5);
define ('UC_SYSOP', 6);

//Do not modify -- versioning system
//This will help identify code for support issues at tbdev.net
define ('TBVERSION','TBDev_2009_svn');

?>
Edit before you just use it you will need the config.sql which is somewhere in the first post just alter it and if your not sure what to do just wait for me I'll get us there
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 22:39. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2018, vBulletin Solutions Inc.