vb.org Archive - Mass Delete Old Private messages

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Mass Delete Old Private messages (https://vborg.vbsupport.ru/showthread.php?t=140336)

djbaxter

02-24-2007 02:08 PM

Mass Delete Old Private messages

First, my apologies in advance if I'm posting this in the wrong place.

I'd like to adapt Amy's Mass Delete Old Private Messages script for vB 2.x to work with version 3.60.

The existing version shows:

Code:

<?php 



require ("global.php"); 

$time = time() - (60 * 24 * 60 * 60); 



$a = $DB_site->query("DELETE FROM privatemessage WHERE dateline < $time"); 



?>

In 3.64, I see three variables for private messages:

pm
pmreceipt
pmtext

Can I just duplicate the a$ query above to prune each of those variables? That is:

Code:

<?php 



require ("global.php"); 

$time = time() - (60 * 24 * 60 * 60); 



$a = $DB_site->query("DELETE FROM pm WHERE dateline < $time"); 

$a = $DB_site->query("DELETE FROM pmreceipt WHERE dateline < $time"); 

$a = $DB_site->query("DELETE FROM pmtext WHERE dateline < $time"); 



?>

Zia	02-24-2007 03:05 PM

gez yet not finished..

a wrong place too

djbaxter

02-24-2007 03:10 PM

I'm aware of that - see above. Moderators, please move this to the apropriate forum.

a1whs.com

02-27-2007 03:19 AM

Hi,
I am confused a bit , does vb new vesion not come with the feature of mass delete where you check on box and all messages get checked and you delete them all ? Or are you trying to build cron to delete old messages?

djbaxter

02-27-2007 01:01 PM

Quote:

Originally Posted by a1whs.com (Post 1191643)

Or are you trying to build cron to delete old messages?

Yes. I want to delete/prune all messages older than a certain date.

Discussion continuing at https://vborg.vbsupport.ru/showthrea...81#post1191881

All times are GMT. The time now is 11:37 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01058 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: