[Release 1.4.x] Duplicate Posts Eraser 1.0

[exdiogene]

In fact it will find any duplicate for any newly created post and erase the post if any duplicate entry exists!

What you need to do is just entering 3 commands like theese in your phpMyAdmin :

Quote:[Highlight]CREATE TABLE single_posts as SELECT * FROM mybb_posts WHERE 1 GROUP BY message;

RENAME TABLE mybb_posts TO old_posts;

RENAME TABLE single_posts TO mybb_posts;

After this, just go in your AdminCP tools section and do all the recounts.

After checking that eveything is OK, you can finally delete the table "old_posts".

P.S. Do not forget to backup your database before doing any of these operations as a safety measure, just in case. Better be cautious than sorry...