Fossil SCM

Two fixes about localtime: * The ci_edit page tells the user that it asks UTC time * The object_description gives links to localtime (if it's set in the config). Otherwise the links were not pointing at the concerning checkin.

viriketo 2011-09-06 07:33 UTC trunk
Commit 1765c18d94da3fe513aeeb7f1a9ef72ac8ed38c7
1 file changed +4 -4
+4 -4
--- src/info.c
+++ src/info.c
@@ -780,11 +780,11 @@
780780
char *zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", rid);
781781
782782
char *prevName = 0;
783783
784784
db_prepare(&q,
785
- "SELECT filename.name, datetime(event.mtime),"
785
+ "SELECT filename.name, datetime(event.mtime, 'localtime'),"
786786
" coalesce(event.ecomment,event.comment),"
787787
" coalesce(event.euser,event.user),"
788788
" b.uuid, mlink.mperm,"
789789
" coalesce((SELECT value FROM tagxref"
790790
" WHERE tagid=%d AND tagtype>0 AND rid=mlink.mid),'trunk')"
@@ -850,11 +850,11 @@
850850
}
851851
@ </ul></ul>
852852
free(prevName);
853853
db_finalize(&q);
854854
db_prepare(&q,
855
- "SELECT substr(tagname, 6, 10000), datetime(event.mtime),"
855
+ "SELECT substr(tagname, 6, 10000), datetime(event.mtime, 'localtime'),"
856856
" coalesce(event.euser, event.user)"
857857
" FROM tagxref, tag, event"
858858
" WHERE tagxref.rid=%d"
859859
" AND tag.tagid=tagxref.tagid"
860860
" AND tag.tagname LIKE 'wiki-%%'"
@@ -926,11 +926,11 @@
926926
cnt++;
927927
}
928928
db_finalize(&q);
929929
}
930930
db_prepare(&q,
931
- "SELECT target, filename, datetime(mtime), user, src"
931
+ "SELECT target, filename, datetime(mtime,'localtime'), user, src"
932932
" FROM attachment"
933933
" WHERE src=(SELECT uuid FROM blob WHERE rid=%d)"
934934
" ORDER BY mtime DESC /*sort*/",
935935
rid
936936
);
@@ -1798,11 +1798,11 @@
17981798
@ <tr><td align="right" valign="top"><b>Comment:</b></td>
17991799
@ <td valign="top">
18001800
@ <textarea name="c" rows="10" cols="80">%h(zNewComment)</textarea>
18011801
@ </td></tr>
18021802
1803
- @ <tr><td align="right" valign="top"><b>Check-in Time:</b></td>
1803
+ @ <tr><td align="right" valign="top"><b>Check-in UTC Time:</b></td>
18041804
@ <td valign="top">
18051805
@ <input type="text" name="dt" size="20" value="%h(zNewDate)" />
18061806
@ </td></tr>
18071807
18081808
@ <tr><td align="right" valign="top"><b>Background Color:</b></td>
18091809
--- src/info.c
+++ src/info.c
@@ -780,11 +780,11 @@
780 char *zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", rid);
781
782 char *prevName = 0;
783
784 db_prepare(&q,
785 "SELECT filename.name, datetime(event.mtime),"
786 " coalesce(event.ecomment,event.comment),"
787 " coalesce(event.euser,event.user),"
788 " b.uuid, mlink.mperm,"
789 " coalesce((SELECT value FROM tagxref"
790 " WHERE tagid=%d AND tagtype>0 AND rid=mlink.mid),'trunk')"
@@ -850,11 +850,11 @@
850 }
851 @ </ul></ul>
852 free(prevName);
853 db_finalize(&q);
854 db_prepare(&q,
855 "SELECT substr(tagname, 6, 10000), datetime(event.mtime),"
856 " coalesce(event.euser, event.user)"
857 " FROM tagxref, tag, event"
858 " WHERE tagxref.rid=%d"
859 " AND tag.tagid=tagxref.tagid"
860 " AND tag.tagname LIKE 'wiki-%%'"
@@ -926,11 +926,11 @@
926 cnt++;
927 }
928 db_finalize(&q);
929 }
930 db_prepare(&q,
931 "SELECT target, filename, datetime(mtime), user, src"
932 " FROM attachment"
933 " WHERE src=(SELECT uuid FROM blob WHERE rid=%d)"
934 " ORDER BY mtime DESC /*sort*/",
935 rid
936 );
@@ -1798,11 +1798,11 @@
1798 @ <tr><td align="right" valign="top"><b>Comment:</b></td>
1799 @ <td valign="top">
1800 @ <textarea name="c" rows="10" cols="80">%h(zNewComment)</textarea>
1801 @ </td></tr>
1802
1803 @ <tr><td align="right" valign="top"><b>Check-in Time:</b></td>
1804 @ <td valign="top">
1805 @ <input type="text" name="dt" size="20" value="%h(zNewDate)" />
1806 @ </td></tr>
1807
1808 @ <tr><td align="right" valign="top"><b>Background Color:</b></td>
1809
--- src/info.c
+++ src/info.c
@@ -780,11 +780,11 @@
780 char *zUuid = db_text(0, "SELECT uuid FROM blob WHERE rid=%d", rid);
781
782 char *prevName = 0;
783
784 db_prepare(&q,
785 "SELECT filename.name, datetime(event.mtime, 'localtime'),"
786 " coalesce(event.ecomment,event.comment),"
787 " coalesce(event.euser,event.user),"
788 " b.uuid, mlink.mperm,"
789 " coalesce((SELECT value FROM tagxref"
790 " WHERE tagid=%d AND tagtype>0 AND rid=mlink.mid),'trunk')"
@@ -850,11 +850,11 @@
850 }
851 @ </ul></ul>
852 free(prevName);
853 db_finalize(&q);
854 db_prepare(&q,
855 "SELECT substr(tagname, 6, 10000), datetime(event.mtime, 'localtime'),"
856 " coalesce(event.euser, event.user)"
857 " FROM tagxref, tag, event"
858 " WHERE tagxref.rid=%d"
859 " AND tag.tagid=tagxref.tagid"
860 " AND tag.tagname LIKE 'wiki-%%'"
@@ -926,11 +926,11 @@
926 cnt++;
927 }
928 db_finalize(&q);
929 }
930 db_prepare(&q,
931 "SELECT target, filename, datetime(mtime,'localtime'), user, src"
932 " FROM attachment"
933 " WHERE src=(SELECT uuid FROM blob WHERE rid=%d)"
934 " ORDER BY mtime DESC /*sort*/",
935 rid
936 );
@@ -1798,11 +1798,11 @@
1798 @ <tr><td align="right" valign="top"><b>Comment:</b></td>
1799 @ <td valign="top">
1800 @ <textarea name="c" rows="10" cols="80">%h(zNewComment)</textarea>
1801 @ </td></tr>
1802
1803 @ <tr><td align="right" valign="top"><b>Check-in UTC Time:</b></td>
1804 @ <td valign="top">
1805 @ <input type="text" name="dt" size="20" value="%h(zNewDate)" />
1806 @ </td></tr>
1807
1808 @ <tr><td align="right" valign="top"><b>Background Color:</b></td>
1809

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button