+- MyBB Codes (http://www.mybbcodes.com)
+-- Forum: Mods Database (/forumdisplay.php?fid=4)
+--- Forum: Premium Mods (/forumdisplay.php?fid=8)
+---- Forum: MODS DATABASE (/forumdisplay.php?fid=23)
+---- Thread: [Release 1.4.x] Duplicate Posts Eraser 1.0 (/showthread.php?tid=359)
[Release 1.4.x] Duplicate Posts Eraser 1.0 - ghazal - 10-04-2009 08:22 AM
//----------------
//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
RE: [Release 1.4.x] Duplicate Posts Eraser 1.0 - harrysx - 06-19-2011 06:25 PM
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.
RE: [Release 1.4.x] Duplicate Posts Eraser 1.0 - exdiogene - 06-19-2011 07:56 PM
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;After this, just go in your AdminCP tools section and do all the recounts.
RENAME TABLE mybb_posts TO old_posts;
RENAME TABLE single_posts TO mybb_posts;
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...