Sign in to follow this  
RetroDefense

Attn Admin: Mags flagged Preserved but no DL links

Recommended Posts

While indexing some VideoGames: The Ultimate Gaming Magazine recently I noticed a couple flagged "Preserved" but with no download links. Could an admin take a look? Issues 72 and 74. Thanks!

Share this post


Link to post
Share on other sites

I discovered Fiverr.com the other day. I have a gig posted for this issue. I am trying to automate a few things around here, one of those items is when all 4 download fields are empty, set the status to Missing......if any of the four links are populated, set it to Preserved. :)

Share this post


Link to post
Share on other sites

Ok, I ran a manual SQL query on the database that basically said....

If status is currently Preserved, and all four download links are blank, set the status to Missing.

That should skip anything that is flagged as the other statuses, looks like it fixed 98 issues.

EDIT: Also ran the reverse and it found one magazine that had download links, but was still flagged as missing.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this