Jump to content

Attn Admin: Mags flagged Preserved but no DL links


RetroDefense
 Share

Recommended Posts

  • 3 weeks later...
  • Retromags Curator

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. :)

Link to comment
Share on other sites

  • Retromags Curator

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recent Achievements

    • that70sdude earned a badge
      Dedicated
    • veriix earned a badge
      Member for 3 Months
    • bogartloo earned a badge
      Member for 7 Days
    • bogartloo earned a badge
      Member for 1 Day
    • SteelerFan74 earned a badge
      Member for 7 Days
×
×
  • Create New...