MyBB Codes

//----------------
//PLUGIN OVERVIEW:
//----------------

Name: Duplicate Posts Eraser
Author: ghazal
Description: This plugin will find and erase duplicate posts from the database.
Website: http://www.mybbcodes.com
Version: 1.0
Compatibility: 1.4.x,1.6.x,1.8.x,2.0.x
Files To Upload: One
Files To Edits: None
Author is Responsible For Any Damage: NO
Author Provide Support For This Product: YES
License: Inside the License Folder
Copyrighted: All codes within the product is strongly copyrighted.


//-----------------------
//INSTALLATION PROCEDURE:
//-----------------------

1. Upload file in ./inc/plugins folder
2. Activate Plugin
3. Adjust settings to suit your needs


//----------
// DOWNLOAD:
//----------
[attachment=309]

//--------
//SUPPORT:
//--------

I can be reached at http://www.mybbcodes.com with username ghazal

---
I guess that's it... Enjoy
Thank You
ghazal

This doesn't actually find and erase duplicate posts?... all it does is prevent new posts that are duplicates from being submitted?

Purchased subscription for this mod thinking it would remove a lot of duplicates after using the merge system... waste of money.

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...