He didn’t have the purge stuff in there yet, so I just edited it out of the top of my head. Be sure to test with the select section only first.
Update is defintive, so if something is wrong it might mess up your DB.
Change the password for the spotweb user in the script to the password you used during installation.
Edit: Decided I like this way better, because it can’t overlap with retrieve.php, so cleaned it up for myself. Create a new file in the same directory as retrieve.php and paste the hastebin. You still need to change the password (5 places) and schedule this instead of retrieve.php.
http://www.hastebin.com/feyisokize.coffee
It was probably possible to use a loop and use variables for the replace, but for me it wasn’t worth the trouble figuring out.
Starting to check if there are QoQ spots with NLSubs in title.
Found 1 QoQ spots with NLSubs in title (query time 0.048 seconds)
Removed NLSubs from 1 QoQ spots with NLSubs in title (query time 0.05 seconds)
Starting to check if there are QoQ spots with (2015) in title.
Found 2 QoQ spots with (2015) in title (query time 0.047 seconds)
Removed (2015) from 2 QoQ spots with NLSubs in title (query time 0.049 seconds)
Starting to check if there are QoQ spots with (2016) in title.
Found 3 QoQ spots with (2016) in title (query time 0.047 seconds)
Removed (2016) from 3 QoQ spots with NLSubs in title (query time 0.05 seconds)