Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so dont bother with any of their useless mail servers here and just use oauth login instead. Thank the nice Russians for causing that. :)
Paste
Pasted as SQL by iSage ( 17 years ago )
mysql> describe ibf_members;
+-------------------------+------------------+------+-----+--------------------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+------------------+------+-----+--------------------------------------+-------+
| id | mediumint(8) | NO | PRI | 0 | |
| can_leech | tinyint(4) | NO | | 1 | |
| wait_time | int(11) | NO | | 0 | |
| peers_limit | int(11) | NO | | 0 | |
| torrents_limit | int(11) | NO | | 0 | |
| torrent_pass_version | int(11) | NO | | 0 | |
| uploaded | bigint(20) | NO | | 0 | |
| downloaded | bigint(20) | NO | | 0 | |
+-------------------------+------------------+------+-----+--------------------------------------+-------+
mysql> describe ibf_aumi_bt;
+---------------+-----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-----------------------+------+-----+---------------------+----------------+
| bt_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| bt_name | varchar(255) | NO | | NULL | |
| bt_cat | int(10) unsigned | NO | | 0 | |
| bt_desc | text | NO | | NULL | |
| bt_file | varchar(255) | NO | | NULL | |
| bt_rate_value | int(10) unsigned | NO | | 0 | |
| bt_rate_num | int(10) unsigned | NO | | 0 | |
| bt_user_id | mediumint(8) unsigned | NO | | 0 | |
| bt_size | bigint(20) unsigned | NO | | 0 | |
| bt_num_files | int(10) unsigned | NO | | 0 | |
| bt_date | datetime | NO | | 0000-00-00 00:00:00 | |
| bt_views | mediumint(8) unsigned | NO | | 0 | |
| bt_hits | mediumint(8) unsigned | NO | | 0 | |
| info_hash | blob | NO | UNI | NULL | |
| bt_thx | int(10) unsigned | NO | | 0 | |
| seeders | int(11) | NO | | 0 | |
| leechers | int(11) | NO | | 0 | |
| completed | int(11) | NO | | 0 | |
| flags | int(11) | NO | | 0 | |
| mtime | int(11) | NO | | 0 | |
| ctime | int(11) | NO | | 0 | |
+---------------+-----------------------+------+-----+---------------------+----------------+
mysql> describe ibf_aumi_bt_settings;
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(255) | NO | | NULL | |
| value | varchar(255) | NO | | NULL | |
+-------+------------------+------+-----+---------+----------------+
mysql> select * from ibf_aumi_bt_settings;
+----+--------------------------+-----------------------------+
| id | name | value |
+----+--------------------------+-----------------------------+
| 1 | enabled | 1 |
| 2 | torrent_pass_private_key | XXXXXXXXXXXXXXXXXXXXXXXXXXX |
+----+--------------------------+-----------------------------+
mysql> describe xbt_announce_log;
+------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ipa | int(10) unsigned | NO | | NULL | |
| port | int(11) | NO | | NULL | |
| event | int(11) | NO | | NULL | |
| info_hash | blob | NO | | NULL | |
| peer_id | blob | NO | | NULL | |
| downloaded | bigint(20) unsigned | NO | | NULL | |
| left0 | bigint(20) unsigned | NO | | NULL | |
| uploaded | bigint(20) unsigned | NO | | NULL | |
| uid | int(11) | NO | | NULL | |
| mtime | int(11) | NO | | NULL | |
+------------+---------------------+------+-----+---------+----------------+
mysql> describe xbt_deny_from_hosts;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| begin | int(11) | NO | | NULL | |
| end | int(11) | NO | | NULL | |
+-------+---------+------+-----+---------+-------+
mysql> describe xbt_files_users;
+------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| fid | int(11) | NO | PRI | NULL | |
| uid | int(11) | NO | PRI | NULL | |
| active | tinyint(4) | NO | | NULL | |
| announced | int(11) | NO | | NULL | |
| completed | int(11) | NO | | NULL | |
| downloaded | bigint(20) unsigned | NO | | NULL | |
| left | bigint(20) unsigned | NO | | NULL | |
| uploaded | bigint(20) unsigned | NO | | NULL | |
| mtime | int(11) | NO | | NULL | |
+------------+---------------------+------+-----+---------+-------+
mysql> describe xbt_scrape_log;
+-----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| ipa | int(11) | NO | | NULL | |
| info_hash | blob | YES | | NULL | |
| uid | int(11) | NO | | NULL | |
| mtime | int(11) | NO | | NULL | |
+-----------+---------+------+-----+---------+----------------+
fenrirko Tracker # cat xbt_tracker.conf
mysql_host = localhost
mysql_user = user
mysql_password = pass
mysql_database = db
debug = 0
column_users_uid = id
column_files_fid = bt_id
table_files = ibf_aumi_bt
table_users = ibf_members
table_config = ibf_aumi_bt_settings
anonymous_announce = 0
anonymous_connect = 0
anonymous_scrape = 0
auto_register = 0
daemon = 1
Revise this Paste
Parent: 7280