Differences From Artifact [6bc3e612fb]:

• File src/moderate.c — part of check-in [1aa8067704] at 2014-12-10 14:16:18 on branch trunk — Update the built-in SQLite to the 3.8.8 alpha that includes the enhanced sqlite3_table_column_metadata() interface. Use that new interface to build new utility methods db_table_exists() and db_table_has_column() that work more efficiently than the older technique of querying the sqlite_master table. (user: drh size: 4630) [more...]

To Artifact [a96d77136a]:

• File src/moderate.c — part of check-in [f4e299d0e5] at 2015-02-09 04:10:52 on branch trunk — On timelines, to show the "selected" entry, give the row some vertical space between the previous and following rows, a yellow background, a gray border, and a shadow-box (all adjustable via CSS). For the c=TIME "circa" query parameter, highlight the nearest entry. (user: drh size: 4633)

152
153
154
155
156
157
158
159

160
161
162
163

152
153
154
155
156
157
158

159
160
161
162
163

-
+

  if( moderation_table_exists() ){
    blob_init(&sql, timeline_query_for_www(), -1);
    blob_append_sql(&sql,
        " AND event.objid IN (SELECT objid FROM modreq)"
        " ORDER BY event.mtime DESC"
    );
    db_prepare(&q, "%s", blob_sql_text(&sql));
    www_print_timeline(&q, 0, 0, 0, 0);
    www_print_timeline(&q, 0, 0, 0, 0, 0);
    db_finalize(&q);
  }
  style_footer();
}