xbt_tracker

[iseeyoucopy]

Check if in your database you have these tables

Code Select Expand

INSERT INTO `xbt_client_whitelist` (`id`, `peer_id`, `vstring`) VALUES
(1, '-', 'all');

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

--
-- Table structure for table `xbt_config`
--

CREATE TABLE `xbt_config` (
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `xbt_config`
--

INSERT INTO `xbt_config` (`name`, `value`) VALUES
('torrent_pass_private_key', 'MG58LNj5LHHz49A9PKhAkxIH8Aa');

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

--
-- Table structure for table `xbt_deny_from_hosts`
--

CREATE TABLE `xbt_deny_from_hosts` (
  `begin` int(11) NOT NULL DEFAULT 0,
  `end` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `xbt_files`
--

CREATE TABLE `xbt_files` (
  `fid` int(11) NOT NULL,
  `info_hash` blob NOT NULL DEFAULT '',
  `leechers` int(11) NOT NULL DEFAULT 0,
  `seeders` int(11) NOT NULL DEFAULT 0,
  `completed` int(11) NOT NULL DEFAULT 0,
  `announced_http` int(11) NOT NULL DEFAULT 0,
  `announced_http_compact` int(11) NOT NULL DEFAULT 0,
  `announced_http_no_peer_id` int(11) NOT NULL DEFAULT 0,
  `announced_udp` int(11) NOT NULL DEFAULT 0,
  `scraped_http` int(11) NOT NULL DEFAULT 0,
  `scraped_udp` int(11) NOT NULL DEFAULT 0,
  `started` int(11) NOT NULL DEFAULT 0,
  `stopped` int(11) NOT NULL DEFAULT 0,
  `flags` int(11) NOT NULL DEFAULT 0,
  `mtime` int(11) NOT NULL DEFAULT 0,
  `ctime` int(11) NOT NULL DEFAULT 0,
  `balance` int(11) NOT NULL DEFAULT 0,
  `freetorrent` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `xbt_files_users`
--

CREATE TABLE `xbt_files_users` (
  `fid` int(11) NOT NULL DEFAULT 0,
  `uid` int(11) NOT NULL DEFAULT 0,
  `active` tinyint(4) NOT NULL DEFAULT 0,
  `announced` int(11) NOT NULL DEFAULT 0,
  `completed` int(11) NOT NULL DEFAULT 0,
  `downloaded` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `left` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `uploaded` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `mtime` int(11) NOT NULL DEFAULT 0,
  `leechtime` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `seedtime` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `upspeed` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `downspeed` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `peer_id` char(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `completedtime` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `ipa` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `connectable` tinyint(4) NOT NULL DEFAULT 1,
  `mark_of_cain` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  `hit_and_run` int(11) NOT NULL DEFAULT 0,
  `started` int(11) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `xbt_peers`
--

CREATE TABLE `xbt_peers` (
  `tid` int(11) NOT NULL DEFAULT 0,
  `uid` int(11) NOT NULL DEFAULT 0,
  `active` tinyint(4) NOT NULL DEFAULT 0,
  `completed` int(11) NOT NULL DEFAULT 0,
  `downloaded` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `left` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `uploaded` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `mtime` int(11) NOT NULL DEFAULT 0,
  `announced` int(11) NOT NULL DEFAULT 0,
  `leechtime` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `seedtime` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `upspeed` int(11) NOT NULL DEFAULT 0,
  `downspeed` int(11) NOT NULL DEFAULT 0,
  `peer_id` binary(20) DEFAULT NULL,
  `completedtime` int(11) NOT NULL DEFAULT 0,
  `ipa` int(11) NOT NULL DEFAULT 0,
  `connectable` tinyint(4) NOT NULL DEFAULT 0,
  `mark_of_cain` enum('yes','no') CHARACTER SET utf8mb4 NOT NULL DEFAULT 'no',
  `hit_and_run` int(11) NOT NULL DEFAULT 0,
  `started` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `xbt_scrape_log`
--

CREATE TABLE `xbt_scrape_log` (
  `id` int(11) NOT NULL,
  `ipa` int(11) NOT NULL DEFAULT 0,
  `info_hash` blob DEFAULT NULL,
  `uid` int(11) NOT NULL DEFAULT 0,
  `mtime` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[jh0ng]

root@vps270923:/var/www/html/XBT# ./xbt_tracker
Unknown column 'tid' in 'field list'
select tid, uid, active, completed, downloaded, `left`, uploaded from xbt_files_users where 0

anyone to fixed? thank you so much