UBB.Developers Forums UBB.threads 7 Development How Do I? ....expire private messages in UBBThreads6.5 ?

Is there an admin script for this? Or do I have to take the old, 6.44 one?

Dont' think it's a function anymore. So you'd have to do a query or hack the old script.

You could write a query and save it in your SQL Commands selection that deletes everything NOW minus whatever time you set.

Strange, isn't it? Do you think I should open a support ticket and issue a bug report at Infopop?

I don't see what the bug would be. It was a feature that was removed, but can easily be accomplished by one SQL command.

Infopop removed the "catchall" feature and implemented a "quota" feature that forces forum members to police themselves. All in all I think it is a better idea, I just think they should have fleshed out the Private Message area better, showing what the limits are, how close you are to your limit, etc.

>I don't see what the bug would be.
The bug is that they forgot to include the script from the last version.
Usually, the newer version has more features and options instead of less.

Its a shame this was taken out, but i guess once its cleared down it works well...

So heres the code..

$query = "
SELECT COUNT(*) FROM {$config['tbprefix']}Messages
WHERE M_Sent <= $purge
";
$sth = $dbh -> do_query($query);
list($deleted) = $dbh ->fetch_array($sth);
if ($deleted < 1) { $deleted = 0; }

$query = "
DELETE FROM {$config['tbprefix']}Messages
WHERE M_Sent <= $purge
";
$dbh -> do_query($query);


So if I wanted to delete a load of messages older than 90 days what would the syntax be?

Whos the SQL experts thank you

DELETE FROM `w3t_Messages`
WHERE `M_Sent` < (UNIX_TIMESTAMP( NOW() ) - 90 * 24 * 60 * 60)

Cheers! A star.

[]Anno said:
DELETE FROM `w3t_Messages`
WHERE `M_Sent` < (UNIX_TIMESTAMP( NOW() ) - 90 * 24 * 60 * 60) [/]

Do we just change the "90" to change the number of days?

yes