{"action":"created","issue":{"url":"https://api.github.com/repos/isohuntto/openbay-db-dump/issues/10","labels_url":"https://api.github.com/repos/isohuntto/openbay-db-dump/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/isohuntto/openbay-db-dump/issues/10/comments","events_url":"https://api.github.com/repos/isohuntto/openbay-db-dump/issues/10/events","html_url":"https://github.com/isohuntto/openbay-db-dump/issues/10","id":54006900,"number":10,"title":"TorrentProject.se DB dump for the Open Bay Project","user":{"login":"nicoboss","id":623410,"avatar_url":"https://avatars.githubusercontent.com/u/623410?v=3","gravatar_id":"","url":"https://api.github.com/users/nicoboss","html_url":"https://github.com/nicoboss","followers_url":"https://api.github.com/users/nicoboss/followers","following_url":"https://api.github.com/users/nicoboss/following{/other_user}","gists_url":"https://api.github.com/users/nicoboss/gists{/gist_id}","starred_url":"https://api.github.com/users/nicoboss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nicoboss/subscriptions","organizations_url":"https://api.github.com/users/nicoboss/orgs","repos_url":"https://api.github.com/users/nicoboss/repos","events_url":"https://api.github.com/users/nicoboss/events{/privacy}","received_events_url":"https://api.github.com/users/nicoboss/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-11T22:04:00Z","updated_at":"2015-01-12T16:23:27Z","closed_at":null,"body":"**http://torcache.net/torrent/EACEF60FE77A771ACBC28E6D65A593BDB800EA28.torrent**\r\nhttps://mega.co.nz/#!J5sm3YAS!_QId1T0SCZlGMkMGNNVa9vDmOtVgiZn4fmi350fFH_o\r\nhttps://drive.google.com/file/d/0B13QNh6ZKU3TaGcwcWxqU0V5blk/view?usp=sharing\r\nhttps://www.dropbox.com/s/urhx0lkn2bo1fzr/TorrentProject_DB_Dump_January_2015_V1.7z?dl=0\r\nhttp://www.nicobosshard.ch/Documents/TorrentProject_DB_Dump_January_2015_V1.7z\r\n\r\nToday I released a new DB for the Open Bay Project! This one is form the famous http://torrentproject.se/ site and was made by using the official dailydump. It contains 5685235 hashes. It’s a wonderful DB and the best thing is, that it’s very easy to update. This dump that contains a little more torrents than the one from kickass but less additional information. This program will also work for other sites that contain an api export function like https://kickass.so/ but don’t forget that HTML dumps contain much more additional information. Thanks @ekoice for your idea to use the api and emphasize the importance of a simple update process.\r\nNow we have 4 DB Dumps:\r\n- The Offical CSV Release from the IsoHunt team\r\n- The Defult OPB Dump from @TPBT-OFFICIAL that has a lot of additional Information but contains only half the amount of hashes than the CSV release\r\n- The Kickass one from me\r\n- The TorrentProject one from me\r\n\r\n**How to import this DB:**\r\n1.\tDownload and extract the DB\r\n2.\tImport the 2 sql Files with LOAD DATA INFILE or with a graphical Interface like PHPMyAdmin.\r\n\r\n**How to update this DB in 2 Steps:**\r\n1.\tDownload and extract or clone https://github.com/nicoboss/KickassCopy and go into the UpdateTorrentProject folder and open the update.bat (Windows x64 only) file and wait some minutes. You can also use the UpdateTorrentProject in the Torrent file but it might be outdated but it would also work.\r\n2.\tCopy the dailydump.csv to your /mysql/data/…/ folder and customize and execute the following SQL script. The scheme for the torrentproject.dailydump can you find also in the torrent file and the db.torrent is your final DB.\r\n\r\nLOAD DATA INFILE 'dailydump.csv' INTO TABLE torrentproject.dailydump_V3 FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\n';\r\n\r\nINSERT IGNORE INTO db.torrent (name, hash, tags) SELECT name, hash, tags FROM torrentproject.dailydump;\r\n\r\nTRUNCATE TABLE torrentproject.dailydump;\r\n\r\nUPDATE db.torrent SET description='' WHERE description is NULL;\r\nUPDATE db.torrent SET category_id=2 WHERE tags like 'Applications%';\r\nUPDATE db.torrent SET category_id=3 WHERE tags like 'Games%' or tags like 'Mobile%';\r\nUPDATE db.torrent SET category_id=4 WHERE tags like 'Adult%';\r\nUPDATE db.torrent SET category_id=5 WHERE tags like 'Video%';\r\nUPDATE db.torrent SET category_id=6 WHERE tags like 'Audio%';\r\nUPDATE db.torrent SET category_id=7 WHERE tags like 'Images%';\r\nUPDATE db.torrent SET category_id=7 WHERE tags='';\r\nUPDATE db.torrent SET category_id=8 WHERE tags='Video Tv';\r\nUPDATE db.torrent SET category_id=9 WHERE tags like 'Ebooks%';"},"comment":{"url":"https://api.github.com/repos/isohuntto/openbay-db-dump/issues/comments/69596622","html_url":"https://github.com/isohuntto/openbay-db-dump/issues/10#issuecomment-69596622","issue_url":"https://api.github.com/repos/isohuntto/openbay-db-dump/issues/10","id":69596622,"user":{"login":"ekoice","id":2579415,"avatar_url":"https://avatars.githubusercontent.com/u/2579415?v=3","gravatar_id":"","url":"https://api.github.com/users/ekoice","html_url":"https://github.com/ekoice","followers_url":"https://api.github.com/users/ekoice/followers","following_url":"https://api.github.com/users/ekoice/following{/other_user}","gists_url":"https://api.github.com/users/ekoice/gists{/gist_id}","starred_url":"https://api.github.com/users/ekoice/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ekoice/subscriptions","organizations_url":"https://api.github.com/users/ekoice/orgs","repos_url":"https://api.github.com/users/ekoice/repos","events_url":"https://api.github.com/users/ekoice/events{/privacy}","received_events_url":"https://api.github.com/users/ekoice/received_events","type":"User","site_admin":false},"created_at":"2015-01-12T16:23:27Z","updated_at":"2015-01-12T16:23:27Z","body":"this db is good, too bad havent torrent age, seeders, leechers, files count...\r\ngood work indeed..."}}