Artifact c37c0636402f5ccdc46db32c7aaed2119a9b97c2
Ticket change
[c37c063640]
- Ticket 70dd027135 "View Ticket" needs creator status still Open with 1 other change
by
kkinnell on
2008-11-25 18:09:41.
D 2008-11-25T18:09:41
J comment When\sviewing\sa\sticket,\sit\swould\sbe\shelpful\sto\sknow\swho\sopened\sthe\sticket,\ssimilar\sto\sthe\sway\syou\scan\ssee\swho\sadded\sadditional\scomments.\r\n\r\n<hr><i>drh\sadded\son\s2008-11-23\s12:00:39:</i><br>\r\nThe\s"Contact"\sfield\scontains\sthat\sinformation,\sif\sI\sunderstand\syou\scorrectly.\r\nBut\sthe\sinformation\sis\san\semail\saddress.\sMany\speople\sprefer\sto\skeep\stheir\r\nemail\saddresses\sprivate\s(to\sminimize\sspam,\sI\ssuppose)\sand\sso\sthat\sContact\sfield\r\nis\snot\sshown\sunless\syou\sare\slogged\sin\sas\sa\suser\sthat\shas\sthe\s"e"\sprivilege.\r\n\r\nTo\shelp\sprevent\sexposure\sof\semail\saddresses,\sSQLite\sdoes\snot\sstore\sthe\semail\r\naddress\sin\sthe\sartifacts\sthat\scomprise\sthe\sticket.\s\sInstead,\sit\sstores\sa\r\nSHA1\shash\sof\sthe\semail\saddress.\s\sA\sseparate\sdatabase\stable\s(the\sCONCEALED\stable)\r\nstores\sa\stranslation\sfrom\sSHA1\shash\sback\sto\semail\saddress.\s\sThe\sCONCEALED\stable\r\nis\snot\stransferred\son\sa\s"clone"\sor\s"sync".\s\sYou\scan\sget\sa\scopy\sof\sthe\sCONCEALED\r\ntable\sby\sdoing:\r\n\r\n\s\s\s\sfossil\sconfig\spull\semail\r\n\r\nBut\sthat\swill\sonly\swork\sif\sthe\sperson\sdoing\sthe\spulling\shas\sthe\s"e"\sprivilege\r\nset.\r\n\r\n<hr><i>anonymous\sadded\son\s2008-11-24\s14:58:24:</i><br>\r\nI\swas\sactually\sreferring\sto\sthe\slogged\sin\sname\sof\sthe\suser\swho\sreported,\snot\sthe\semail\saddress.\s\sI\sagree\sthat\sthat\sshould\snot\sbe\sdisplayed.\r\n\r\nFor\sexample,\sthis\sticket\sshould\ssay\s"anonymous"\ssince\sI\sdo\snot\shave\sa\slogin\son\sthis\ssystem.\r\n\r\nThe\sreason\sI\srequested\sthis:\s\sin\smy\scompany,\sonly\sthe\sperson\swho\sopened\sa\sbug\smay\sclose\sit,\sthe\sperson\swho\sfixed\sit\smarks\sit\s"fixed".\s\sIt\sis\shelpful\sto\sknow\sat\sa\sglance\swho\sopened\sa\sticket.\r\n\r\n<hr><i>eric\sadded\son\s2008-11-24\s15:36:00:</i><br>\r\nThe\suserid\sis\savailable\sin\sthe\sticket\shistory\spage,\sdo\syou\sneed\smore\sthan\sthat?\r\n\r\n<hr><i>anonymous\sadded\son\s2008-11-24\s20:56:32:</i><br>\r\nYes,\sit\swould\sbe\snice\sto\shave\sit\son\sthe\s"View\sTicket"\spage\s(tktview).\r\n\r\n<hr><i>kkinnell\sadded\son\s2008-11-25\s18:06:41:</i><br>\r\nYou\scan\sdeal\swith\sthis\sby\schanging\syour\sNew\sTicket\sHTML.\r\n\r\nSetup->Tickets->New\sTicket\sPage\r\n\r\nThe\stext\sedit\shas\sa\scopy\sof\sthe\shtml+th1\scode\sfor\sdoing\snew\stickets,\r\nat\sthe\svery\stop\sis\r\n\r\n<nowiki><pre>\r\n<th1>\r\n\s\sif\s{[info\sexists\ssubmit]}\s{\r\n\s\s\s\s\sset\sstatus\sOpen\r\n\s\s\s\s\ssubmit_ticket\r\n\s\s}\r\n</th1>\r\n</pre></nowiki>\r\n\r\nIf\syou\schange\sthat\sto\r\n\r\n<nowiki><pre>\r\n<th1>\r\n\s\sif\s{![info\sexists\susername]}\s{set\susername\s$login}\r\n\s\sset\spstr\s"[htmlize\s$login]"\r\n\s\sif\s{$username\sne\s$login}\s{\r\n\s\s\s\s\s\sset\spstr\s"$pstr\sclaiming\sto\sbe\s[htmlize\s$username]"\r\n\s\s}\r\n\s\sset\spstr\s"$pstr\sposted\son\s[date]"\r\n\s\sif\s{[info\sexists\ssubmit]}\s{\r\n\s\s\s\s\sset\sstatus\sOpen\r\n\s\s\s\s\sset\scomment\s"$pstr<br><br>$comment"\r\n\s\s\s\s\ssubmit_ticket\r\n\s\s}\r\n</th1>\r\n</pre></nowiki>\r\n\r\nYou'll\sget\s'so\s&\sso\sposted\son\ssomewhen'\sat\sthe\svery\stop\sof\sthe\r\nfirst\scomment\sin\sa\sticket.\r\n\r\nCaveat:\sI\shaven't\stested\sthis\squite\sas\sextensively\sas\sI\smight...\r\n\r\nTh1\sisn't\sdocumented\smuch—yet—but\sit's\sbasically\sspecialized\sTcl.\s\sYou\scan\sdo\squite\sa\sbit\sof\scustomization\swith\sit,\sincluding\schanging\ssqlite\stables\sto\ssuit\syou.
K 70dd0271356813e9c17c8c84d0957f6a5e1f4ae3
U kkinnell
Z 68bcb167079d53124553c4b1377bedc0