Posted By

yisreldov on 05/04/10


Tagged


Versions (?)

Set old tasks to due today ...


 / Published in: PHP
 

  1. update flyspray_tasks, flyspray_assigned set flyspray_tasks.due_date = UNIX_TIMESTAMP(NOW()) where flyspray_tasks.task_id = flyspray_assigned.task_id and flyspray_assigned.user_id = 2 and due_date < UNIX_TIMESTAMP(NOW()) and is_closed=0

Report this snippet  

You need to login to post a comment.