SHA1 Hash:	1a4dd313a8300cbbd693e85fe4ea7df383f47d60
Date:	2007-07-30 17:24:47
User:	drh
Comment:	Show the user who make the change on the timeline, both on the www interface and in the cli.
Timelines:	ancestors | descendants | both | trunk
Other Links:	files | ZIP archive | manifest

• branch=trunk inherited from [a28c83647d]
• sym-trunk inherited from [a28c83647d]

Modified src/timeline.c from [cd16841a59] to [b52c0c0c75].

@@ -55,11 +55,11 @@
   Stmt q;
   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"
   );
   @ <table cellspacing=0 border=0 cellpadding=0>
@@ -78,11 +78,11 @@
     }
     @ <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();
 }
@@ -126,13 +126,14 @@
 */
 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);
 }