Set old tasks to due today ...

/ Published in: PHP
Save to your folder(s)

Copy this code and paste it in your HTML
  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


RSS Icon Subscribe to comments

You need to login to post a comment.