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]

Originally Posted by Boofo

I was thinking more like a setting so you could run it at 180 days if you wanted to.

But, no biggie, I'll make a hack to do a setting for me. Good job, though.

If you do manage to make a jack which will allow you to run the scheduled task every 180 days I would be eternally grateful if you would either help me improve this modification or show me the code you create?

Thanks, Paul.

[Boofo]

I will do that, sir.

[Jase2]

adafsfs

[PaulSonny]

Originally Posted by Jase2

Just been testing this Paul, and received the following error:

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:
DELETE FROM visitormessage;

MySQL Error : Table 'user_vbulletin.visitormessage' doesn't exist
Error Number : 1146
Date : Monday, March 31st 2008 @ 05:22:20 PM
Script : http://www.techsupportteam.org/forum...cron&cronid=25
Referrer : http://www.techsupportteam.org/forum....php?do=modify
IP Address : 82.16.245.186
Username : Jason
Classname : vb_database
MySQL Version : 5.0.27-standard

It's saying it doesn't exist, when it quite clearly does. Any ideas?

Regards Jason

I think I know why, but to confirm my thoughts, do you use a Table Prefix?

Thanks, Paul.

[Jase2]

Yes, I do.

I thought that may be the problem too. I'll need to edit it right, and include my table prefix? Which code would I edit? But there again, it's added my table prefix above -- it's just saying it can find it.

EDIT: I see this in the .php file:

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

I believe I need to add my prefix at the beginning so it looks like this:

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

Correct?

Regards Jason

[Boofo]

Nope you need this:

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

[Jase2]

Did that! It now brings the following error:

Parse error: syntax error, unexpected T_STRING in /home/user/public_html/forum/includes/cron/visitormessagedelete.php on line 15

Regards Jason

[Boofo]

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

My bad.

[PaulSonny]

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

Yeah this should work, sorry about the table_prefix error, with me not using a table prefix myself I forgot.

Thanks, Paul.

[Jase2]

That produces the following: