Current time: 03-29-2024, 05:43 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[54.90.236.179], 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
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

Messages In This Thread
RE: [Release 1.4.x] Duplicate Posts Eraser 1.0 - exdiogene - 06-19-2011 07:56 PM

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  [Release 1.4.x] View Thread Readers 1.0 exdiogene 26 14,645 08-17-2015 05:11 PM
Last Post: Technoman
  [Release 1.4.x] Alphabetic Thread Display exdiogene 4 30,907 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-2024 MyBB Group.
    Golden Crown - Designed and Published by ghazal & exdiogene of MyBBCodes.
    Hosting provided by WWWHostingServer.com