2012-08-12, 06:10 AM
2012-08-12, 07:16 AM
The ratings are stored in the table
In theory you have to delete entries from table
In practice my SQL is a bit rusty, so I'm sure someone here can translate this into a working syntax.
From that point I believe you still need to update counter fields in
I hope someone can help me completing this for you. Cheers!
mybb_threadratings
but you need the table mybb_threads
to filter what ratings will be deleted.In theory you have to delete entries from table
mybb_threadratings
where its field tid
match the field tid
of the table mybb_threads
IF fid
of said mybb_threads
is equal to the forum ID you need.In practice my SQL is a bit rusty, so I'm sure someone here can translate this into a working syntax.
From that point I believe you still need to update counter fields in
mybb_threads
(numratings
and `totalratings), I don't know if this will be automatic.I hope someone can help me completing this for you. Cheers!