FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » Deleting Moderation Queue
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Deleting Moderation Queue [message #36111] Mon, 05 March 2007 14:08 Go to next message
appscontent   United States
Messages: 33
Registered: November 2006
Karma: 0
Member
I have 13,000+ messages that I converted from one of my mail lists. These messages are now queued up the Moderation Queue awaiting approval.

Is there a feature to allow me to do a mass delete of all 13,000 items? If not, could someone show me what the SQL is to delete these items? I am not too SQL literate, sorry ...

Report message to a moderator

Re: Deleting Moderation Queue [message #36119 is a reply to message #36111] Tue, 06 March 2007 00:05 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
delete from fud26_msg where apr=0;

The above query will remove all non-approved messages in FUDforum.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: find user stats
Next Topic: FudAPI Examples
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 05:16:16 GMT 2024

Total time taken to generate the page: 0.02641 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software