Current time: 12-01-2021, 09:38 AM Hello There, Guest! (LoginRegister)


Announcement
We have the biggest collection of MyBB Plugins here on the Net. We have currently 175+ MyBB Exclusive Plugins, 80+ MyBB Compatible MyCodes and 16+ MyBB 1.4.x Themes (Some are still under construction...) Thus, we provide you the largest MyBB Stuff on the net including tutorials. Stay with us, you will find out some more to come.
Now you can easily create your own buttons set for MyBB! Click here to have a look...
*** You cannot do your registration behind any Proxies anymore! ***
Welcome Guest[18.212.120.195], connected from Ashburn, Virginia United States
Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Release 1.4.x] Duplicate Posts Eraser 1.0
10-04-2009, 08:22 AM
Post: #1
Heart [Release 1.4.x] Duplicate Posts Eraser 1.0
//----------------
//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:
//----------

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

ghazal's signature *** Deleted by the administration ***
Visit this user's website Find all posts by this user
Quote this message in a reply
06-19-2011, 06:25 PM
Post: #2
RE: [Release 1.4.x] Duplicate Posts Eraser 1.0
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.

harrysx's signature
Visit this user's website Find all posts by this user
Quote this message in a reply
06-19-2011, 07:56 PM
Post: #3
RE: [Release 1.4.x] Duplicate Posts Eraser 1.0
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...

exdiogene's signature MyBBCodes.com administrator
Cool " It is not what you know that matters, it is what you do or do not do!"
Visit this user's website Find all posts by this user
Quote this message in a reply
0 member(s) viewed this thread in the last 365 days :
Post Reply 


Was This Thread Useful ?
Please Link To Us
URL
BBCode
HTML

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  [Release 1.4.x] View Thread Readers 1.0 exdiogene 26 14,637 08-17-2015 05:11 PM
Last Post: Technoman
  [Release 1.4.x] Alphabetic Thread Display exdiogene 4 30,906 03-11-2011 02:07 AM
Last Post: billy423uk
  [Release 1.4.x] Profile Notify exdiogene 1 3,830 03-25-2010 04:59 AM
Last Post: fl00r
  [Release 1.4.x] Profile Website URL exdiogene 0 2,209 03-20-2010 02:54 AM
Last Post: exdiogene
  [Release 1.4.x] PM Forwarder exdiogene 0 1,476 02-26-2010 02:01 PM
Last Post: exdiogene

Forum Jump:

 
New To Site ?
Some Useful Links
  • Help

  • You Might Need To Register

  • Forum Statistics

  • Mark All Forums Read

  • Forum Staff

  • Log Out
  • Contact Us

  • Mybbcodes

  • Return to Top

  • Return to Content

  • Lite (Archive) Mode

  • RSS Syndication
  • Powered By MyBB, © 2002-2021 MyBB Group.
    Golden Crown - Designed and Published by ghazal & exdiogene of MyBBCodes.
    Hosting provided by WWWHostingServer.com