605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
|
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
|
-
+
|
db_multi_exec("%s", zDistinctRenameQuery/*safe-for-%s*/);
style_submenu_element("All", "%R/test-rename-list?all");
}
nRename = db_int(0, "SELECT count(*) FROM renames;");
nCheckin = db_int(0, "SELECT count(DISTINCT checkin) FROM renames;");
db_prepare(&q, "SELECT date, old_name, new_name, checkin FROM renames"
" ORDER BY date DESC, old_name ASC");
@ <h1>%d(nRename) rename operations in %d(nCheckin) check-ins</h1>
@ <h1>%d(nRename) file name changes in %d(nCheckin) check-ins</h1>
@ <table class='sortable' data-column-types='tttt' data-init-sort='1'\
@ border="1" cellpadding="2" cellspacing="0">
@ <thead><tr><th>Date & Time</th>
@ <th>Old Name</th>
@ <th>New Name</th>
@ <th>Check-in</th></tr></thead><tbody>
while( db_step(&q)==SQLITE_ROW ){
|