delete old visitor messages

[VeeDubZ]

there is the "Delete All Visitor Messages Every 30 Days"

but it would be better if you could just delete the visitor messages that are older than a certain date or a certain number of days old.

[Jase2]

That would be too complicated. This is a simple cron job that will automatically delete all visitor messages. Alternatively, you can disable the cron job, then click "Run Now" whenever you wish and boom all visitor messages are gone.

Regards Jason

[VeeDubZ]

i mean that i dont want to delete all of the visitor messages just ones that are over a certain age

[Jase2]

Then I suggest you code it yourself. You're trying to make something so simple, complicated.

[VeeDubZ]

I'm pretty sure if i delete all the comments then people will get annoyed with me as they may not have read them or they could be an ongoing conversation or such.

i would like to delete all messages that are over a certain age to avoid the above issues.

coding it myself is not an option as ive no coding knowlege in this area

[Jase2]

It is run of the vB cron system. It can only go as high as that does.

[MoT3rror]

[sql]DELETE FROM visitormessage WHERE dateline < $unixtime_minus_30days[/sql]

Example: $unixtime_minus_30days code

PHP Code:

$unixtime_minus_30days = mktime(date('H'), date('i'), date('s'), date("m"), date('d')-30, date('Y')); 


There is more ways you can get the 30 days ago in UNIX time so this cannot be the best way to do it.