outreach-cvs

[Martin V. <mar...@us...>]

Update of /cvsroot/outreach/opt/overview
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv19912/overview

Modified Files:
	user_todo.inc 
Log Message:
Fixed left join error wth MySQL 5


Index: user_todo.inc
===================================================================
RCS file: /cvsroot/outreach/opt/overview/user_todo.inc,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** user_todo.inc	8 Sep 2006 20:00:21 -0000	1.10
--- user_todo.inc	20 Apr 2007 18:37:05 -0000	1.11
***************
*** 154,158 ****
  {   // Just get requests which have tasks due this (or last) week involving this user
      $sql="select distinct(requests.id), title, priority, status, deadline, aproj, initial_estimate_seconds/3600
!           from requests, request2task, task, person_task left join projects on requests.aproj = projects.id
  	  where (projects.active != 0) and requests.id = request2task.request and request2task.task = task.id
            and person_task.taskID = task.id and person_task.personID = $person $scope_filter_sql order by priority asc";
--- 154,158 ----
  {   // Just get requests which have tasks due this (or last) week involving this user
      $sql="select distinct(requests.id), title, priority, status, deadline, aproj, initial_estimate_seconds/3600
!           from (requests, request2task, task, person_task) left join projects on requests.aproj = projects.id
  	  where (projects.active != 0) and requests.id = request2task.request and request2task.task = task.id
            and person_task.taskID = task.id and person_task.personID = $person $scope_filter_sql order by priority asc";