search

isohuntto / openbay

Other
3.53k stars 903 forks source link

Automatic update function over RSS #141

Open nicoboss opened 9 years ago

nicoboss commented 9 years ago

https://github.com/nicoboss/KickassCopy/tree/master/DB%20%20RSS-Feed%20updater

Today I finally released the first 100% automatic update function over RSS for the OpenBay project. The php script is based on http://www.gaijin.at/scrphprssreader.php but supports only RSS now but I’ll add Atom and RDF soon. It should work on every DB dump in the OpenBay scheme but I’ve only tested it on the all in one (https://github.com/isohuntto/openbay-db-dump/issues/12) and the kickass dump (https://github.com/isohuntto/openbay-db-dump/issues/7). And sorry that the commands are in German. I’ll translate it to English as soon as I’ve finished the Atom and RDF thing.

How to install:

  1. Download the “DB RSS-Feed updater” Folder of the link on the top
  2. Open the php file and fill in your SQL login data and the RSS site you would like to use. In case of default use https://kickass.so/new/rss/. For Some feeds I recommend to the command to relieve the RSS and your server.
  3. Upload the php and css file to your server on some place that wasn’t blocked by .htaccess.
  4. Start the php script or put it into planed task (don’t forget to remove the meta reload) if your server supports this. This depends a lot on your server and if it supports meta refresh in a background task. As an alternative there are also other time based reload commands in JavaScript or php.

Notice that if your server isn’t 24/7 h on then you won’t get the new torrent that would be released if it is OFF. Please report bugs in my repository. If you have any questions feel free to ask.

TPBT-OFFICIAL commented 9 years ago

Tested seems to be working completly fine :) Tested at https://tpbt.org

ALSO check this :) https://tpbt.org/blog/dynamic-content

TPBT-OFFICIAL commented 9 years ago

There seems to be just a little problem.... its not a like a big problem but it may affect some people... every torrent goes to the category "other" Also since i didn't know how to keep it always taking torrents i just got a windows vps i had and opened firefox and put auto refresh :P

nicoboss commented 9 years ago

I fixed the no category_id bug. Thanks @TPBT-OFFICIAL for reporting this. I had forgotten to implement the conversion from the category name into the category id. The category name will be written into tags. The solution over VPS is might not the best solution because of wasting of resources but it works :D

TPBT-OFFICIAL commented 9 years ago

The vps is just my virtual place really its where i have most of the things having a firefox tab opened auto refreshing doesn't use that much resources anyway :P

I also updated the script for my website it seems to be working flawlessly now :)

mywish1 commented 9 years ago

@nicoboss can you help me i need your help how to install this script and how dump database over my the piratebay website please help me if possible give me your skype id thanks @TPBT-OFFICIAL he is also very nice person i specially thanks to tpbt-official

nicoboss commented 9 years ago

I found another bug in my script. Addslashes doesn't use the \" before and after the string. Sorry for that. To remove the useless quotes from the wrong created names you can use the following SQL script: UPDATE torrent.torrents SET name = TRIM(BOTH '"' FROM name) WHERE created_at >'2015-17-01'; Please update my script to the latest version to avoid this bug.

@mywish1 My Skype name is Nico Rezack. You can chat and talk with me but you might have to wait sometimes for me because I have to do a lot of other things. I also allow the other members of this project to add me on Skype. My English isn’t perfect because my mother tongue is German but it’ll be enough to communicate.

TPBT-OFFICIAL commented 9 years ago

@nicoboss The script has been updated now on my website! I'll also add you on skype. :)

TPBT-OFFICIAL commented 9 years ago

@nicoboss After i updated the script the torrents don't update anymore, why is that?

mywish1 commented 9 years ago

@nicoboss i added you at skype i m waiting for you and i need some help in sphinx to config it i already installed sphinx in my server but there is some issue @TPBT-OFFICIAL that guy helping me he is really really nice person i really impressed with his style of help and still need more help to setup my piratebay site alive thanks

nicoboss commented 9 years ago

@TPBT-OFFICIAL I tested the new version on two servers and didn't have any problems. Are you sure that you filled in your correct MySQL login data? And is there any error?

ghost commented 9 years ago

tested also, and working nice. I've added you in skype nicoboss to ask a few questions. thank you so far for the great contribution !