Change Vote

[Sir_Sixx]

Hi,

One of my users has voted on a picture and now wants to change his vote. Is this possible?

Cheers

Sir Sixx

[Joachim Müller]

with means of coppermine gui tools: no. But you're free to use a tool like phpMyAdmin and modify the rating entry in the db with it. But what's the point in changing one lousy vote? Live's a bitch after all...

GauGau

[Sir_Sixx]

The guy really wants to change his vote.

I have looked at the mysql database and i have no idea what i would need to change.


Any help please?

[Joachim Müller]

two steps to be taken, use phpMyAdmin for this:

• browse cpg11d_pictures to find out the pic_id
• look up the pic_id in the table cpg11d_votes. If you're lucky, then there's only one vote for the pic (sort by pic_id first) - delete the db_entry.

If there are multiple votes on the pic, life becomes complicated - maybe you can find out what vote relates to your user by looking at the date (in unix format)[/list:u]GauGau