Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Dump private messages and letters of visitors and reset the counters Details »
Dump private messages and letters of visitors and reset the counters
Mod Version: 1.00, by w-elbalad.com (Contributor) w-elbalad.com is offline
Developer Last Online: Nov 2015 I like it Show Printable Version Email this Page

vB Version: 4.0.x Rating: (1 vote - 5.00 average) Installs: 24
Released: 29 Jan 2010 Last Update: Never Downloads: 184
Not Supported DB Changes Re-usable Code Translations  


Given our need to unload the stored private messages we have for all groups with messages that the number of visitors and a large accumulated for a period of up to four years and more which is the span of the Forum and put pressure on the tables and a forum for memberships of close to 70 thousand member

Needed for the work of this product is very simple and effective

Away from the plant orders that make it difficult for some

Installation

Only the highest product you annex

And will delete all your messages (outgoing + incoming) and letters of visitors and reset counters

Then delete the product from the Control Panel Forum and keep with you for future use

Suitable for copying 3.6.x + 3.7.x + 3.8.x +4.0.x</SPAN>
Annexes 3 products
First dump private messages and visitor messages
The second dump Visitor Messages only
Third dump private messages only

The process of product 3azoob

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.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 29 Jan 2010, 15:31
movslow movslow is offline
 
Join Date: Aug 2008
What counters does it reset?
Reply With Quote
  #3  
Old 29 Jan 2010, 15:40
w-elbalad.com's Avatar
w-elbalad.com w-elbalad.com is offline
 
Join Date: Aug 2009
Real name: Mr ~ vAnDa
Originally Posted by movslow View Post
What counters does it reset?
this XXXXXXXX/private.php?do=showpm&pmid=290
and Notifications of messages
__________________
Reply With Quote
  #4  
Old 30 Jun 2010, 22:03
vBRiP vBRiP is offline
 
Join Date: Feb 2010
wow thanks, this is great, install
Reply With Quote
  #5  
Old 25 Nov 2010, 23:49
Binoy Binoy is offline
 
Join Date: Mar 2006
i installed the product.. but where in ACP can i find the options to run the product?
Reply With Quote
  #6  
Old 27 Nov 2010, 03:53
w-elbalad.com's Avatar
w-elbalad.com w-elbalad.com is offline
 
Join Date: Aug 2009
Real name: Mr ~ vAnDa
Originally Posted by Binoy View Post
i installed the product.. but where in ACP can i find the options to run the product?
Just install it
and product will delete msg
after u install it u can delete product
__________________
Reply With Quote
  #7  
Old 28 Nov 2010, 14:41
BiZiMDiYaR BiZiMDiYaR is offline
 
Join Date: Aug 2006
would deleting the PM's make much difference.. ? last I deleted them but I didn't see much difference... it think the PM's are quite small...
Reply With Quote
  #8  
Old 30 Nov 2011, 21:08
top dogs 360 top dogs 360 is offline
 
Join Date: Jul 2010
This is a quick fix then to clean out messages then remove and save for later use?
Reply With Quote
  #9  
Old 27 Apr 2012, 08:38
MikeF MikeF is offline
 
Join Date: Jan 2006
empty pm vis.xml doesn't have the table prefix for PM's I haven't checked the others yet. Could've just posted the SQL query Thank you though very much.
Reply With Quote
  #10  
Old 27 Apr 2012, 08:53
MikeF MikeF is offline
 
Join Date: Jan 2006
Thumbs up

Problem: Private messages do not get deleted when a table prefix is used for the database.
Solution: The code has been updated to include this data. I have performed this update without permission, so w-elbalad.com can do whatever he wants with it. Update the code in your XML file or download my new one.


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

Problem: I'd like to run it as a SQL Query from AdminCP
Solution:

Run each line separately. Remember, you can only run one line queries from AdminCP SQL. Replace prefix_ with your database prefix, or nothing at all, depending on if you are using one.

TRUNCATE `prefix_pm`;
TRUNCATE `prefix_pmtext`;
TRUNCATE `prefix_pmreceipt`;
TRUNCATE `prefix_visitormessage_hash`;
TRUNCATE `prefix_visitormessage`;
UPDATE `prefix_user` SET `pmtotal` = 0, `pmunread` = 0;
UPDATE `prefix_user` SET `vmunreadcount` = 0, `vmmoderatedcount` = 0;

Consider using phpMyAdmin or Navicat for Windows as it is much easier and you can run them all from there.

This is Mike Fara from Windows 7 Forums. I hope that this has resolved the issue for someone other than myself using a forum database prefix Take care, and thanks for the excellent script.
Attached Files
File Type: xml mike_empty-pmvm.xml (1.0 KB, 10 views)

Last edited by MikeF; 27 Apr 2012 at 09:30. Reason: The script is fixed for PMs when using a forum prefix.
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 09:23.

Layout Options | Width: Wide Color: