Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Delete all PMs and Adminlog Details »
Delete all PMs and Adminlog
Mod Version: 1.00, by arena (Member) arena is offline
Developer Last Online: Jun 2011 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.4 Rating: (0 vote - 0 average) Installs: 6
Released: 26 Feb 2007 Last Update: Never Downloads: 2
Not Supported DB Changes  

Delete all PMs and Adminlog

Your database Run SQL query/queries on database

UPDATE `user` SET `pmtotal` = '0',`pmunread` = '0';
TRUNCATE TABLE `pm`;
TRUNCATE TABLE `pmtext`;
TRUNCATE TABLE `pmreceipt`;
TRUNCATE TABLE `adminlog`;

This action can not be un-done.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
End-User Options Self Delete: Allow users to self-delete their account calorie vBulletin 3.6 Add-ons 138 29 May 2015 01:50
Moderators Functions Hard Delete (physical delete) By User Group Jafo232 vBulletin 3.7 Add-ons 27 28 Oct 2013 20:08

Comments
  #2  
Old 26 Feb 2007, 20:47
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Should be in this forum
http://www.vbulletin.org/forum/forumdisplay.php?f=184
Reply With Quote
  #3  
Old 26 Feb 2007, 20:48
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
But running this query on deleting PM, It still shows x private messages they have
Looks very werid
Reply With Quote
  #4  
Old 26 Feb 2007, 21:13
Lionel Lionel is offline
 
Join Date: Dec 2001
Real name: Lionel
Originally Posted by Shazz View Post
But running this query on deleting PM, It still shows x private messages they have
Looks very werid
That's in user table. Don't empty your user table though.
Reply With Quote
  #5  
Old 26 Feb 2007, 21:40
A_V A_V is offline
 
Join Date: Nov 2006
This is not any mod, is in one "How-to"
Reply With Quote
  #6  
Old 26 Feb 2007, 21:57
stinger2's Avatar
stinger2 stinger2 is offline
 
Join Date: Jul 2005
i have asked this question about one year ago...and i posted the answer i got from vb.com in the above thread........

not to sound ungrateful.but why is it released as an add on???
Reply With Quote
  #7  
Old 26 Feb 2007, 22:16
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Already been stated in post 1.
Reply With Quote
  #8  
Old 28 Feb 2007, 19:49
BobbyBig BobbyBig is offline
 
Join Date: Mar 2006
Installed
Reply With Quote
  #9  
Old 01 Mar 2007, 21:04
SaN-DeeP's Avatar
SaN-DeeP SaN-DeeP is offline
 
Join Date: Jun 2002
How can i setup a scheduled task for same ?
(Clear all logs once per week and delete all pms which are 30+ days old)

I think you can bundle the same as a plugin ?

thanks
Reply With Quote
  #10  
Old 16 Jun 2007, 12:59
momo2 momo2 is offline
 
Join Date: Feb 2007
i tried to do this but, You are not authorized to execute SQL queries i get this, any ideas ?
Reply With Quote
  #11  
Old 16 Jun 2007, 13:45
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Originally Posted by momo2 View Post
i tried to do this but, You are not authorized to execute SQL queries i get this, any ideas ?
Go into your FTP > /includes/config.php


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Find // ****** USERS WITH QUERY RUNNING PERMISSIONS ******

Add your userid to that as you see there
Reply With Quote
  #12  
Old 16 Jun 2007, 13:46
Shazz's Avatar
Shazz Shazz is offline
 
Join Date: Jun 2006
Location: Utah
Real name: Shawn
Ever since I upgraded to 3.6.7 PL1 its now showing

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #13  
Old 19 Jun 2007, 20:10
momo2 momo2 is offline
 
Join Date: Feb 2007
Thanks, Shazz, I'll do it
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 21:03.

Layout Options | Width: Wide Color: