Miscellaneous Hacks - PS - Delete All Visitor Messages Every 30 Days

vBulletin 3.7 Version

This is my third modification.

Any questions asked by members who have not marked this as installed will be considered low priority.

About This Hack: This has been requested from a vBulletin.org member. This will delete all Visitor Messages every 30 days. (1st of Every Month)

Installation Information: 1 Additional File, 1 Scheduled Task.

To install just unzip the download below and import into vB using the ACP Product Manager, further and full instructions are included.

If you wish to make the Scheduled Task run more often you can edit the Scheduled Task.

Go to Admin CP >> Scheduled Tasks >> Scheduled Task Manager >> Visitor Message Del >> Then Edit To Your Choice, for example if you choose Day of Week as Sunday, this will run every Sunday.

Please post your comments or suggestions for this hack. I read ALL posts.

Please remember to click Mark As Installed if you use this modification.

If you use this plug-in, and find it useful, please support us by nominating us for Mod Of The Month (MOTM) in the top right corner of this thread, or feel free to donate.

You will get an email when a new version is released.

History:

Version 1.00:

Initial version for vBulletin 3.7.

[PaulSonny]

$db->query_write("DELETE FROM " . TABLE_PREFIX . "visitormessage");

Try that for me please.

Thanks, Paul.

[Jase2]

Another error:

Fatal error: Call to a member function on a non-object in /home/user/public_html/forum/includes/cron/visitormessagedelete.php on line 15

Regards Jason

[PaulSonny]

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "visitormessage");

Been given help with this one so hopefully should work.

Thanks, Paul.

[Boofo]

Shouldn't there be a * in there?

[PaulSonny]

I thought the same, but according to this SQL article i'm reading apparently not, but it wouldnt hurt to try and put one in.

Thanks, Paul.

[Hornstar]

I have not started to use vb 3.7 just yet, however looking at some good hacks to install for when I do. Just wondering if there is an underlying reason that one would want to use this hack.

Thanks.

[PaulSonny]

Originally Posted by hornstar1337

I have not started to use vb 3.7 just yet, however looking at some good hacks to install for when I do. Just wondering if there is an underlying reason that one would want to use this hack.

Thanks.

This was a special request for a user, but I suppose the underlying reason is to keep your database size down.

thanks, Paul.

[christian8a]

Originally Posted by hornstar1337

I have not started to use vb 3.7 just yet, however looking at some good hacks to install for when I do. Just wondering if there is an underlying reason that one would want to use this hack.

Thanks.

Yea, that would be probably the last thing my members would like me to do, imagine, they will all be pissed at me :erm:

[Jase2]

Think of the space you could free...

I'm going to be disabling it, then running it every so often. I'll always let me members know, however. This just makes it easier for you just to click and boom -- all vm's are gone!

Regards Jason

[Jase2]

Paul, I got it working -- I used the following:

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "visitormessage");

Sorry for the confusion, it was very late last night

Regards Jason