Advanced Search

Set old tasks to due today ...

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

Expand | Embed | Plain Text

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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.