Jump to content

Attn Admin: Mags flagged Preserved but no DL links

RetroDefense

By RetroDefense
in Database Discussions

 Share

Recommended Posts

  • 3 weeks later...
  • Retromags Curator
Phillyman Mentor

Phillyman

Posted
  • Retromags Curator
Posted

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
Phillyman Mentor

Phillyman

Posted
  • Retromags Curator
Posted

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
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Recent Achievements

    • Member for 7 Days
      yumikazama
      yumikazama earned a badge
      Member for 7 Days
    • Member for 1 Month
      yumikazama
      yumikazama earned a badge
      Member for 1 Month
    • Member for 1 Day
      yumikazama
      yumikazama earned a badge
      Member for 1 Day
    • Member for 5 Years
      yumikazama
      yumikazama earned a badge
      Member for 5 Years
    • Member for 1 Year
      yumikazama
      yumikazama earned a badge
      Member for 1 Year
×
×
  • 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!