diff options
| -rwxr-xr-x | timeline/tlcacher.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/timeline/tlcacher.php b/timeline/tlcacher.php index 5e1da43..5165dc4 100755 --- a/timeline/tlcacher.php +++ b/timeline/tlcacher.php @@ -94,7 +94,7 @@ $db =& DB::connect($dsn); if (DB::isError($db)) die("Cannot connect to M database"); $db->setFetchMode(DB_FETCHMODE_ASSOC); -$sql = "select history_id, event_date, event_type, user_name, flyspray_history.task_id, item_summary, closure_comment +$sql = "select history_id, event_date, event_type, flyspray_history.task_id, item_summary, closure_comment, real_name from flyspray_history join flyspray_users on flyspray_users.user_id = flyspray_history.user_id join flyspray_tasks on flyspray_tasks.task_id = flyspray_history.task_id @@ -106,7 +106,7 @@ if (DB::isError($res)) die("Query error"); while ($row =& $res->fetchRow()) { // $etype = $fs_events[$row['event_type']]; $etype = $row['event_type']; - $euser = $row['user_name']; + $euser = $row['real_name']; $etid = $row['task_id']; $edate = $row['event_date']; $cache_id = $row['history_id']; |