[omardealo]

HELLO ...

i make new filed in table thread .. and i want SET or UPDATE data of this filed After some days

LIKE THIS :

PHP Code:

if (today's date (TIMENOW) - creation of Thread (dateline) >= 30 days)
{
SET or UPDATE thisfiled in thread table to (new data)
} 


Do I need to use SQL QUERY OR there is a simple code for that
and what's name of hook to this plugin ...

i use this code but not work ... in global_start hook

PHP Code:

$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . " thread 
                                SET user_contact = 'anything' 
                                WHERE
dateline <= ' . intval(TIMENOW - (60 * 60 * 24 * ".$vbulletin->options['user_contact_time'].")).'
                            "); 


I have another question here about same filed
https://vborg.vbsupport.ru/showthread.php?t=296543


Thank you !