Psst.. new poll here.
[email protected] web/email now available. Want one? Go here.
Cannot use outlook/hotmail/live here to register as they blocking our mail servers. #microsoftdeez
Obey the Epel!
Paste
Pasted as SQL by iSage ( 15 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