How to schedule a sql query
 

Hi im wanting to run a shedule task to reset the counts in a table my database to zero

I just need a but of help for what code to use in the php cron file

the query i am using is

UPDATE user SET mydbtabename = '0'

obviously replacing mydbtabename with the real name.

how do i put it into code

eg.

$vbulletin->db->query_write ???????????????????????

I think you want this:

thankyou