following every link???  holy stupidity Batman!

why not just use an RSS feed???

go to you db in phymyadmin or other…  the sfmembers table… find the user(s) in question and look in the thanked column… that will be the thanks they have given…  think you should be able to clear it out…  at least that will do their thanked stuff… but dont think it will clear out the thanks the users received…  you would have to write a script to remove it from users thanks column in same db table, I believe…

My guess: they have a rudimentary script that was taking ALL the content of the members area, which included the forums, and did so just by following every link given… which, unfortunately, included the “Thanks” button.

I took one of the users and cleared his “thanks” field in phpmyadmin to 0 (from 9500+ before)… unfortunately, his “thanks” on every post still remains. (Ie – every post still displays “The following users thanked this post: JoeBlowX”.)

Also, the other user had hacked into my site – his account was deleted, but all of his “thanks” on posts remain. (In other words – he no longer has an account, but every post still shows “Thanked by this user”.)

It appears the data I need to delete to get rid of their public display of thanks is somewhere in the plugin tables itself? Not sure where to look or how to delete it safely though. I always get nervous mucking around in phpmyadmin.

Thank you for your help so far!

Clay, as I mentioned, users will still get thanks even though you cleared that out.

Also, each post retains the thanks record. In the db, look at the sfposts table, the thanks column. You would need to weed out all the thanks for each post. As mentioned this would need a small php script to weed them out.

Do you know php? Each of those entries in thanks is a serialized array. So you would need to unserialize and remove the specific element from the array, the reserialize and save it back.

(Sorry for disappearing from this thread!)

Unfortunately I don’t know PHP. I’d be more than happy to pay for a small script that would remove these users’ “thanks” from each post… especially considering I know it’ll happen again in the near future (since it happened twice within a month of installing the plugin) and it’d be nice to be able to wipe out a specific user’s “thanks” from every post again!

I know it’d be silly to ask if you developers could write the script (it’s amazing enough you’re providing such thorough support in here, along with developing the plug-in!) so do you know of any good leads for someone who could handle this?

Thanks!

I can send BrandonC your way… he does a lot of the custom work for us and is quite reasonable…

In the meantime, I understand your issue and the use case… I have opened a ticket for us to consider a way to do this from within the admin in a future release of the thanks plugin…