Auto execute query

[SCuN]

Do I greet someone could write script which he made these query to cron of every hour ?

UPDATE search SET ipaddress = 0
UPDATE user SET ipaddress = 0
UPDATE post SET ipaddress = 0

thanks

[Dismounted]

Cron as in vBulletin Scheduled Task? Or proper crontab cron?

[Marco van Herwaarden]

What you are probably looking for is:

AdminCP -> vBulletin Options -> Message Posting and Editing Options ->
Log IP Addresses: Do not log IP

[SCuN]

Cron as in vBulletin Scheduled Task? Or proper crontab cron?

vBulletin Scheduled Task...

AdminCP -> vBulletin Options -> Message Posting and Editing Options ->
Log IP Addresses: Do not log IP

so marked have so but when someone registers his ip he is written down farther ... why I do not know...

[Dismounted]

This is basically the whole script:

PHP Code:

$vbulletin->db->query_write("UPDATE search SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE user SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE post SET ipaddress = 0"); 


[SCuN]

He Thanks very much

That is I have to create the file php with content

PHP Code:

$vbulletin->db->query_write("UPDATE search SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE user SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE post SET ipaddress = 0"); 


and to send him to /forum/includes/cron/ and I use from Scheduled Task
Apologize then that I give so stupid questions but I have vbulletin from 3 weeks

[Dismounted]

No, I believe you will need to add some standard cron PHP around it. Look in the files vBulletin comes with, and you will know what to add.

[SCuN]

ok thanks
I already know

PHP Code:

<?php
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($vbulletin->db))
{
    exit;
}

$vbulletin->db->query_write("UPDATE search SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE user SET ipaddress = 0");
$vbulletin->db->query_write("UPDATE post SET ipaddress = 0");

?>