Index: src/rebuild.c ================================================================== --- src/rebuild.c +++ src/rebuild.c @@ -543,11 +543,11 @@ ** See also: deconstruct, reconstruct */ void rebuild_database(void){ int forceFlag; int randomizeFlag; - int errCnt; + int errCnt = 0; int omitVerify; int doClustering; const char *zPagesize; int newPagesize = 0; int activateWal; Index: src/statrep.c ================================================================== --- src/statrep.c +++ src/statrep.c @@ -406,20 +406,19 @@ all rows. */ stats_report_init_view(); stats_report_event_types_menu("byuser", NULL); @

Timeline Events @ (%s(stats_report_label_for_type())) by User

- if( PB("pie") ){ - db_multi_exec( - "CREATE TEMP TABLE piechart(amt,label);" - "INSERT INTO piechart SELECT count(*), user FROM v_reports" - " GROUP BY user ORDER BY count(*) DESC;" - ); - @ - piechart_render(800, 600, PIE_OTHER); - @ - return; + db_multi_exec( + "CREATE TEMP TABLE piechart(amt,label);" + "INSERT INTO piechart SELECT count(*), user FROM v_reports" + " GROUP BY user ORDER BY count(*) DESC;" + ); + if( db_int(0, "SELECT count(*) FROM piechart")>=2 ){ + @
+ piechart_render(700, 400, PIE_OTHER|PIE_PERCENT); + @
} @ @ @ @@ -479,11 +478,11 @@ "CREATE TEMP TABLE statrep(filename, cnt);" "INSERT INTO statrep(filename, cnt)" " SELECT filename.name, count(distinct mlink.mid)" " FROM filename, mlink" " WHERE filename.fnid=mlink.fnid" - " GROUP BY 1" + " GROUP BY 1;" ); db_prepare(&query, "SELECT filename, cnt FROM statrep ORDER BY cnt DESC, filename /*sort*/" ); mxEvent = db_int(1, "SELECT max(cnt) FROM statrep"); @@ -539,10 +538,23 @@ "COUNT(*) AS eventCount " "FROM v_reports " "GROUP BY dow ORDER BY dow"); @

Timeline Events @ (%s(stats_report_label_for_type())) by Day of the Week

+ db_multi_exec( + "CREATE TEMP TABLE piechart(amt,label);" + "INSERT INTO piechart SELECT count(*), cast(mtime %% 7 AS INT) FROM v_reports" + " GROUP BY 2 ORDER BY 2;" + "UPDATE piechart SET label = CASE label WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday'" + " WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday'" + " WHEN 5 THEN 'Saturday' ELSE 'Sunday' END;" + ); + if( db_int(0, "SELECT count(*) FROM piechart")>=2 ){ + @
+ piechart_render(700, 400, PIE_OTHER|PIE_PERCENT); + @
+ } @
User
@ @ @
DoWDay