Bulk Edit Download Limit & Expiry

Viewing 1 replies (of 1 total)
  • Thread Starter mass501

    (@mass501)

    10 years, 4 months ago

    Solved it myself,

    if you’re looking for a solution here’s the MySQL query:

    UPDATE wp_postmeta SET meta_value = “10” WHERE meta_key = “_download_limit” and post_id IN ( SELECT * from (SELECT post_id FROM wp_postmeta WHERE meta_key = “_downloadable” AND meta_value=”yes”) T)

    needless to say, backup your DB before running any queries….

Viewing 1 replies (of 1 total)
  • The topic ‘Bulk Edit Download Limit & Expiry’ is closed to new replies.