Differences From:

File src/timeline.c part of check-in [66f4caa379] - Improvements to the WWW interface. by drh on 2007-07-23 19:52:51. [view]

To:

File src/timeline.c part of check-in [1a4dd313a8] - Show the user who make the change on the timeline, both on the www interface and in the cli. by drh on 2007-07-30 17:24:47. [view]

@@ -56,9 +56,9 @@
   char zPrevDate[20];
   style_header("Timeline");
   zPrevDate[0] = 0;
   db_prepare(&q,
-    "SELECT uuid, datetime(event.mtime,'localtime'), comment"
+    "SELECT uuid, datetime(event.mtime,'localtime'), comment, user"
     "  FROM event, blob"
     " WHERE event.type='ci' AND blob.rid=event.objid"
     " ORDER BY event.mtime DESC"
   );
@@ -79,9 +79,9 @@
     @ <tr><td valign="top">%s(&zDate[11])</td>
     @ <td width="20"></td>
     @ <td valign="top" align="left">
     hyperlink_to_uuid(db_column_text(&q,0));
-    @ %s(db_column_text(&q,2))</td>
+    @ %h(db_column_text(&q,2)) (by %h(db_column_text(&q,3)))</td>
   }
   db_finalize(&q);
   @ </table>
   style_footer();
@@ -127,12 +127,13 @@
 void timeline_cmd(void){
   Stmt q;
   db_must_be_within_tree();
   db_prepare(&q,
-    "SELECT uuid, datetime(event.mtime,'localtime'), comment"
+    "SELECT uuid, datetime(event.mtime,'localtime'),"
+    "       comment || ' (by ' || user || ')'"
     "  FROM event, blob"
     " WHERE event.type='ci' AND blob.rid=event.objid"
     " ORDER BY event.mtime DESC"
   );
   print_timeline(&q, 20);
   db_finalize(&q);
 }