[omardealo]

Exactly , I do not want it running SQL QUERY all day , that's Will happen over load to Server
but I do not know much about the cron of vb ... can u help me for that (Is there any thread link talk about explanation run this code once every 24 hours or every hour)
and i Ask from you to consider on this topic, there is simple question but important for me
https://vborg.vbsupport.ru/showthread.php?t=296543

thnx u very much the code now Works well

PHP Code:

if ($vbulletin->options['user_contact_onoff'])
{  
$cutoff = TIMENOW - (60 * 60 * 24 * $vbulletin->options['user_contact_time']);
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "thread 
                                SET user_contact = 'anything' 
                                WHERE dateline <= $cutoff
                                AND
                                (user_contact != 'anything' OR user_contact IS NOT NULL)
                            ");
                            
}