Community Support Forums

I am looking to reset the Download count for ALL my Users on Level 0 (Free)

Here's why, I had Level 0 set for 100 downloads for 30 days while in Beta Test.
Now I am ready to roll the system out for prime time, and I want to change the download restriction to 10 downloads over 365 days.

So as not to upset those that have already gone over the new 10 free limit I want to reset all my Level 0 users, change the download limit to 10 then they will all be happy.

I have over 3,000 beta testers so its quite a number to reset.
I have full access to the db so its its easier to do via a SQL query that's fine.
Seems like the data is in s2member_file_download_access_log ?? but I can't seem to find it.

I guess I can kludge it by making a new level say 5 move them to that, which I think resets the count, then move them back to level 0 again.

Any suggestions welcome.

Having dug into the db a bit more it seems like I would need to move the data from the array wp_usermeta.meta_value WHERE the meta_key = wp_s2member_file_download_access_log and append it to the array where the meta_key is wp_s2member_file_download_access_arc

Also the count at the beginning of the array needs to be updated.

However others must have had to do this, or want to. So there has to be a function to do this.
Also my SQL abilities are a limited so it would take me some time to figure this out.

Anyone any suggestions??

Thanks

Hi Collin. I'll check with Jason what would be the simplest approach for this.

Cristián, that would be great, as we can't effectively launch our site until this is resolved. So it's very important to me.
I'm open to any method of doing this.

Thanks for the heads up.
You can delete the meta keys in your DB:

Code: Select all

wp_s2member_file_download_access_log
wp_s2member_file_download_access_arc

for each Level #0 Subscriber. That resets the counters.

Sure I can do that, I was hoping there was a quick way to move the current download files from _log to _arc

But its not a huge issue I guess I don't have to loose all the download file data during my rollout phase.