Differences From:

File src/info.c part of check-in [66f4caa379] - Improvements to the WWW interface. by drh on 2007-07-23 19:52:51. [view]

To:

File src/info.c part of check-in [3dcaed8d86] - When accessing a remote repository, if there is a username/password specified as part of the URI, use these to login. by dan on 2007-07-28 07:09:25. Also file src/info.c part of check-in [3a25b68390] - Only request the password one time on a push or pull. by drh on 2007-07-30 16:35:16. [view]

@@ -104,11 +104,11 @@
     show_common_info(rid, "uuid:", 1);
   }
 }
 
-#if 0
+#if 1
 /*
-** WEB PAGE: vinfo
+** WEBPAGE: vinfo
 **
 ** Return information about a version.  The version number is contained
 ** in g.zExtra.
 */
@@ -124,12 +124,26 @@
     @ No such object: %h(g.argv[2])
     style_footer();
     return;
   }
+  db_row_to_table("SELECT "
+    "  blob.uuid               AS \"UUID\""
+    ", datetime(rcvfrom.mtime) AS \"Created\""
+    ", rcvfrom.uid             AS \"User Id\""
+    ", blob.size               AS \"Size\""
+    "FROM blob, rcvfrom "
+    "WHERE rid=%d", rid
+  );
+  style_footer();
+  return;
+
   db_prepare(&q,
-    "SELECT uuid, datetime(mtime,'unixepoch'), datetime(ctime,'unixepoch'),"
-    "         uid, size, cksum, branch, comment, type"
-    "  FROM record WHERE rid=%d", rid
+    "SELECT "
+      "uuid, "                                         /* 0 */
+      "datetime(mtime,'unixepoch'),"                   /* 1 */
+      "datetime(ctime,'unixepoch'),"                   /* 2 */
+      "uid, size, cksum, branch, comment, type"        /* 3..8 */
+    "FROM record WHERE rid=%d", rid
   );
   if( db_step(&q)==SQLITE_ROW ){
     const char *z;
     const char *zSignedBy = db_text("unknown",
@@ -257,9 +271,11 @@
     db_finalize(&q);
   }
   style_footer();
 }
+#endif
 
+#if 0
 /*
 ** WEB PAGE: diff
 **
 ** Display the difference between two files determined by the v1 and v2