nZEDb/nZEDb — pull request #650 by kaibosh (2013-06-17 08:11:56+00:00)
Title: Update monitor.php

NOTE: This code is NON-FUNCTIONAL! (the loading/testing of the asstag variable is not correct) -- It serves as an example only.

I don't have a valid amazon associate tag and probably won't ever get one. Idea is, that if the Associate Tag field is blank, then the amazon PP for Console/Book/Audio can just be deactivated.

Putting yet another select in monitor.php is relatively expensive, so not sure if this is the best implementation method anyway.

Currently I comment the amazon PP section in monitor.php and cron these commands to clear the In-Process PP counters:
mysql -u nzedb -pPSW nzedb -e "update releases set musicinfoID = '-2' where musicinfoID IS NULL and categoryID BETWEEN 3000 AND 3999 and nzbstatus = 1;"
mysql -u nzedb -pPSW nzedb -e "update releases set bookinfoID = '-2' where bookinfoID IS NULL and nzbstatus = 1 and categoryID = 8010;"
mysql -u nzedb -pPSW nzedb -e "update releases set consoleinfoID = '-2' where consoleinfoID IS NULL and categoryID BETWEEN 1000 AND 1999 and nzbstatus = 1;"