Support Forum
Support Forum
Offline
Hey guys,
I've been running SP5 on my WL Member-powered site for almost two months now and it's been fantastic! Thank you for all you've done with it.
I'm using the "thanks" plugin and have run into a specific problem two times: people who run scripts that download every post in the forums (by simply following every link)... which means their scripts are also "clicking" the "Thanks" button on every single post.
So every single forum post (all 10k+) are "thanked" by these two users.
Is there any easy way to simply wipe out all the "thanks" given by these two users, without affecting everyone else?
Thank you guys for any help you can provide!
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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!
Offline
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.
Visit Cruise Talk Central and Mr Papa's World
Offline
(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!
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)