Topic: delete post ratings by user

[instinct]

I've searched this forum and found that this is currently not possible without digging into the guts of the system and SQL, etc.

The problem starts with post authors being able to rate their own posts - authors create posts, then immediately vote 5 on it, so it skews the actual user ratings.

Now I'm stuck with trying to undo all the mess. I need a way to delete all comments by author and update the posts accordingly. Then if I had a way to prevent authors from voting on their own posts, this issue would stop completely.

[GaMerZ]

It is not possible at the moment. You can query the logs by post id and user id, re-calculate it base on the query and then update the post meta again.

[instinct]

thanks - I may have a go at it, but I'm no SQL wiz - can always do it manually I guess - it's only 50-100 posts, lol

It is not possible at the moment. You can query the logs by post id and user id, re-calculate it base on the query and then update the post meta again.

[littaudio]

For people interested in deleting more easily invalid ratings, here is a modified version of postratings-manager.php (V. 1.11), which allows to delete one particular rating (data & log) in one click.

Of course the average rating of the post concerned is automatically recalculated after deletion.

Enjoy !

Link 1 : http://dl.free.fr/vyF1XCv1T

or

Link 2 : http://www.litteratureaudio.com/postratings-manager.txt (in that case rename postratings-manager.txt in postratings-manager.php)

[GaMerZ]

Thanks for sharing, how about doing this for 1.50 beta? You can download it here http://downloads.wordpress.org/plugin/wp-postratings.zip

[littaudio]

Hello,

Thanks for the answer ! (and the plugin btw)

Answer to your question : that would be a pleasure, in a few days or weeks... (don't have the time right now, unfortunately)

But you know, if you look at the code, it should be easy & quick for you (you're a coder, and I'm really not ! and what's more it's your code, you don't have to guess the logic like me).

I've made five modifications, in fact based on the code that already existed : 1) lines 79-83 ; 2) lines 145-210 ; 3) line 355 ; 4) lines 397-403 ; 5) line 553.

NB. what I made is a "not-all-pretty-but-efficient" solution, it should be reviewed before "publication" I think.

[GaMerZ]

Thanks for the line modified, that would made it easier for me. I thought I would ask you as it might be easier for you to input the changes to the latest version then me as you know where the changes are but since you tell me the line modified, that is good enough for me =D

[littaudio]

You're welcome.

Just one more note to those interested in the adds I've made : to make the script work with your database, you've got to change its name lines 161, 167, 189 and 195 (I should have put `$wpdb->postmeta` instead of `wplitt_postmeta` each time).

Here are the new links :

Link 1 : http://dl.free.fr/vofu0yr97

or

Link 2 : http://www.litteratureaudio.com/postratings-manager.txt (in that case rename postratings-manager.txt in postratings-manager.php)

[GaMerZ]

Sure thing, I will take note of it, no worries, shall add it in when I have the time. lol

[Mainguy]

I think there is a mistake on line 27.

The code tries to load "postratings/postratings-manager_complet.php" which does not exist.

I believe it would be "wp-postratings/postratings-manager.php" I've tried it and it seems to work. But, the structure of the page is all messed.

I attached a screenshot of what it looks like.



[attachment deleted by admin]

[GaMerZ]

Do note that the "hack" is for postratings v1.11, and now it is postratings 1.40 so the "hack" will not work, you can't replace it line for line.

[littaudio]

You're right Mainguy, another little thing I forgot to change.

(I did this change because my "hacked" page was called postratings-manager_complet.php - I kept the original one unmodified)

Will do the change on my links and on V1.40 as soon as possible.

[littaudio]

the structure of the page is all messed.

I attached a screenshot of what it looks like.

I think it is so because the stars don't load... please check in your page source the URL of the images.

[miccom]

Your modification uses as image path to the stars:
/wp-content/plugins/postratings/

The real path is:
/wp-content/plugins/wp-postratings/

So the stars are not loaded.

[uncleslam]

Does anyone have an updated version of littaudio's script that works with version 1.5?

If I'm not mistaken, the one on here is only for version 1.11 correct?