NZBClubScraper

********************* NOTICE **************************
This app is in the beta stage. It's purpose, is to simplify the searching and downloading of NZB's from NZBClub. It may crash. It may hang. This will likely get better, as I use it and need more features, or find bugs. Feel free to help out, and let me know what the problems are and/or features you'd like to see.

***************** DESCRIPTION **********************
The app was built initial just to download nzb's to the phone easier (which it still does), but has become centered around a script that I have running on my home PC, that keeps an sqlite database of the shows that my wife and I watch. It keeps track of what episode we are on, and alerts us when a new episode becomes available on nzbclub. The app allows us to send a request to the PC directly from the app to download the nzb to the PC in a hot folder, which automatically downloads the nzb's content. The phone communicates with the script for a number of tasks, such as downloading items, getting a list of monitored shows, addition and removal of monitored shows, and soon the ability to receive new show notifications on the phone, and update them with touch of a button.

********************* NOTICE *********************
This application is a tad bit crippled without the database, and script that uses it. You'll likely need to be a linux machine for this portion, and will need to edit the $my_username and $my_password variables: http://www.codefaction.net/nzbget.txt

The database is basically an sqlite db with a very simple structure, having 3 tables.
-show
-tracking
-exclusion

Here is the show schema:
CREATE TABLE show (
showid INTEGER PRIMARY KEY AUTOINCREMENT,
showname TEXT
);

Here is the tracking schema:
CREATE TABLE tracking (
trackid INTEGER PRIMARY KEY AUTOINCREMENT,
semoniker TEXT,
showidfk INTEGER, finale TEXT,
FOREIGN KEY(showidfk) REFERENCES show(showid)
);

And the exclusion schema:
CREATE TABLE exclusion (exclusionid INTEGER PRIMARY KEY AUTOINCREMENT, exclusionpath TEXT);

If this is all a bit much, you may want to stick with just downloading the nzb to your phone and uploading it to your nzb client via the web for now.