diff options
author | Thomas Penteker <tek@serverop.de> | 2013-03-15 23:00:08 +0100 |
---|---|---|
committer | Thomas Penteker <tek@serverop.de> | 2013-03-15 23:00:08 +0100 |
commit | 15af7f1a0f9fd798cc7b55744f1fc177f480876d (patch) | |
tree | 96ec04ad4867fb48febf024822514a2938410bbb | |
parent | 81b8c33280c6b7496838a8e8bdc408f899a5d3a3 (diff) | |
download | webtools-15af7f1a0f9fd798cc7b55744f1fc177f480876d.tar.gz webtools-15af7f1a0f9fd798cc7b55744f1fc177f480876d.tar.xz |
tlcacher.php: use realname instead of nicknames in flyspray events
-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']; |