Jump to content

Attn Admin: Mags flagged Preserved but no DL links


RetroDefense

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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Recent Achievements

    • apierret earned a badge
      Member for 1 Month
    • yonew84673 earned a badge
      Member for 7 Days
    • cifa earned a badge
      Member for 1 Month
    • cifa earned a badge
      Member for 7 Days
    • cifa earned a badge
      Member for 1 Day
×
×
  • Create New...
Affiliate Disclaimer: Retromags may earn a commission on purchases made through our affiliate links on Retromags.com and social media channels. As an Amazon & Ebay Associate, Retromags earns from qualifying purchases. Thank you for your continued support!