[Release 1.4.x] Duplicate Posts Eraser 1.0

[ghazal]

Post HTML Suite Plugin's DEMO

*** If you are looking for an affordable hosting with great support quality, click here! ***

//----------------
//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:
//----------

  Duplicate Post Eraser[1].zip (Size: 39.2 KB / Downloads: 26)
Downloaded by :Federico, xUser, bold_handsome, tazman, exdiogene, abcx, nashr_hp, dunlop03, Technoman, FBI, brags, mahigrafix, harrysx, H0AX, Sparkasse, asgard, joecool

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

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

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

[harrysx]

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.

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