Fossil

Check-in [1a4dd313]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Show the user who make the change on the timeline, both on the www interface and in the cli.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:1a4dd313a8300cbbd693e85fe4ea7df383f47d60
User & Date: drh 2007-07-30 17:24:47
Context
2007-07-30
17:43
Fix a bug in login. check-in: 947842fb user: drh tags: trunk
17:24
Show the user who make the change on the timeline, both on the www interface and in the cli. check-in: 1a4dd313 user: drh tags: trunk
17:05
Fix a bug in the logic for finding a pivot during a merge. check-in: 5602bbba user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/timeline.c.

53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
..
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
...
124
125
126
127
128
129
130
131

132
133
134
135
136
137
138
*/
void page_timeline(void){
  Stmt q;
  char zPrevDate[20];
  style_header("Timeline");
  zPrevDate[0] = 0;
  db_prepare(&q,
    "SELECT uuid, datetime(event.mtime,'localtime'), comment"
    "  FROM event, blob"
    " WHERE event.type='ci' AND blob.rid=event.objid"
    " ORDER BY event.mtime DESC"
  );
  @ <table cellspacing=0 border=0 cellpadding=0>
  while( db_step(&q)==SQLITE_ROW ){
    const char *zDate = db_column_text(&q, 1);
................................................................................
      @ </td></tr></table>
      @ </td></tr>
    }
    @ <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>
  }
  db_finalize(&q);
  @ </table>
  style_footer();
}
/*
** The input query q selects various records.  Print a human-readable
................................................................................
** intended as a convenient shortcut for the common case of seeing
** recent changes.
*/
void timeline_cmd(void){
  Stmt q;
  db_must_be_within_tree();
  db_prepare(&q,
    "SELECT uuid, datetime(event.mtime,'localtime'), comment"

    "  FROM event, blob"
    " WHERE event.type='ci' AND blob.rid=event.objid"
    " ORDER BY event.mtime DESC"
  );
  print_timeline(&q, 20);
  db_finalize(&q);
}







|







 







|







 







|
>







53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
..
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
...
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
*/
void page_timeline(void){
  Stmt q;
  char zPrevDate[20];
  style_header("Timeline");
  zPrevDate[0] = 0;
  db_prepare(&q,
    "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>
  while( db_step(&q)==SQLITE_ROW ){
    const char *zDate = db_column_text(&q, 1);
................................................................................
      @ </td></tr></table>
      @ </td></tr>
    }
    @ <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));
    @ %h(db_column_text(&q,2)) (by %h(db_column_text(&q,3)))</td>
  }
  db_finalize(&q);
  @ </table>
  style_footer();
}
/*
** The input query q selects various records.  Print a human-readable
................................................................................
** intended as a convenient shortcut for the common case of seeing
** recent changes.
*/
void timeline_cmd(void){
  Stmt q;
  db_must_be_within_tree();
  db_prepare(&q,
    "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);
}