//Set users torrent to HnR if not seeded to 1:1 ratio or for a 72 hour period $DB->query("UPDATE transfer_history SET hnr='1', hnrsettime='".sqltime()."' WHERE (seedtime < 259200 OR uploaded/downloaded < 1) AND seeding = 0"); //Remove HnR if seedtime = 72 hours or torrent ratio = 1:1 within 1 week from getting set to HnR $DB->query("UPDATE transfer_history SET hnr='0', hnrsettime='0000-00-00 00:00:00' WHERE (seedtime >= '259200' OR uploaded/downloaded >= '1') AND UNIX_TIMESTAMP()-UNIX_TIMESTAMP(hnrsettime) >= '604800' AND hnr = '1'");