Community Support Forums

Re: Reset Download Count for Level 0

2011-12-18T14:15:05-05:00

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.

Statistics: Posted by colinp386 — December 18th, 2011, 2:15 pm

Re: Reset Download Count for Level 0

2011-12-18T11:06:03-05:00

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

Code:: wp_s2member_file_download_access_log wp_s2member_file_download_access_arc

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

Statistics: Posted by Jason Caldwell — December 18th, 2011, 11:06 am

Re: Reset Download Count for Level 0

2011-12-17T11:43:01-05:00

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.

Statistics: Posted by colinp386 — December 17th, 2011, 11:43 am

Re: Reset Download Count for Level 0

2011-12-17T00:52:41-05:00

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

Statistics: Posted by Cristián Lávaque — December 17th, 2011, 12:52 am

Re: Reset Download Count for Level 0

2011-12-16T12:22:32-05:00

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

Statistics: Posted by colinp386 — December 16th, 2011, 12:22 pm

Reset Download Count for Level 0

2011-12-14T22:48:28-05:00

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.

Statistics: Posted by colinp386 — December 14th, 2011, 10:48 pm