Fossil SCM

Add explanatory text to the top of the rcvfromlist webpage. The info page for the root check-in now knows how to redirect to vinfo.

drh 2009-01-25 19:47 trunk
Commit 9c89b0e0f1ce9294a814915ef5359ef068bb9ee0
Parent 766bec08cebeb85…
2 files changed +3 +15 -5
~ src/info.c ~ src/shun.c
M src/info.c
+3
--- src/info.c
+++ src/info.c
@@ -1154,10 +1154,13 @@
11541154
 " WHERE rid=%d AND tagname LIKE 'tkt-%%'", rid) ){
11551155
 tinfo_page();
11561156
 }else
11571157
 if( db_exists("SELECT 1 FROM plink WHERE cid=%d", rid) ){
11581158
 vinfo_page();
1159
+ }else
1160
+ if( db_exists("SELECT 1 FROM plink WHERE pid=%d", rid) ){
1161
+ vinfo_page();
11591162
 }else
11601163
 {
11611164
 artifact_page();
11621165
 }
11631166
 }
11641167
--- src/info.c
+++ src/info.c
@@ -1154,10 +1154,13 @@
1154 " WHERE rid=%d AND tagname LIKE 'tkt-%%'", rid) ){
1155 tinfo_page();
1156 }else
1157 if( db_exists("SELECT 1 FROM plink WHERE cid=%d", rid) ){
1158 vinfo_page();
 
 
 
1159 }else
1160 {
1161 artifact_page();
1162 }
1163 }
1164
--- src/info.c
+++ src/info.c
@@ -1154,10 +1154,13 @@
1154 " WHERE rid=%d AND tagname LIKE 'tkt-%%'", rid) ){
1155 tinfo_page();
1156 }else
1157 if( db_exists("SELECT 1 FROM plink WHERE cid=%d", rid) ){
1158 vinfo_page();
1159 }else
1160 if( db_exists("SELECT 1 FROM plink WHERE pid=%d", rid) ){
1161 vinfo_page();
1162 }else
1163 {
1164 artifact_page();
1165 }
1166 }
1167
M src/shun.c
+15 -5
--- src/shun.c
+++ src/shun.c
@@ -220,10 +220,20 @@
220220
 "SELECT rcvid, login, datetime(rcvfrom.mtime), rcvfrom.ipaddr"
221221
 " FROM rcvfrom LEFT JOIN user USING(uid)"
222222
 " ORDER BY rcvid DESC LIMIT 31 OFFSET %d",
223223
 ofst
224224
 );
225
+ @ <p>Whenever new artifacts are added to the repository, either by
226
+ @ push or using the web interface, an entry is made in the RCVFROM table
227
+ @ to record the source of that artifact. This log facilitates
228
+ @ finding and fixing attempts to inject illicit content into the
229
+ @ repository.</p>
230
+ @
231
+ @ <p>Click on the "rcvid" to show a list of specific artifacts received
232
+ @ by a transaction. After identifying illicit artifacts, remove them
233
+ @ using the "Shun" feature.</p>
234
+ @
225235
 @ <table cellpadding=0 cellspacing=0 border=0>
226236
 @ <tr><th>rcvid</th><th width=15>
227237
 @ <th>Date</th><th width=15><th>User</th>
228238
 @ <th width=15><th>IP&nbsp;Address</th></tr>
229239
 cnt = 0;
@@ -269,28 +279,28 @@
269279
 " FROM rcvfrom LEFT JOIN user USING(uid)"
270280
 " WHERE rcvid=%d",
271281
 rcvid
272282
 );
273283
 @ <table cellspacing=15 cellpadding=0 border=0>
274
- @ <tr><td valign="top" align="right">rcvid:</td>
284
+ @ <tr><td valign="top" align="right"><b>rcvid:</b></td>
275285
 @ <td valign="top">%d(rcvid)</td></tr>
276286
 if( db_step(&q)==SQLITE_ROW ){
277287
 const char *zUser = db_column_text(&q, 0);
278288
 const char *zDate = db_column_text(&q, 1);
279289
 const char *zIpAddr = db_column_text(&q, 2);
280
- @ <tr><td valign="top" align="right">User:</td>
290
+ @ <tr><td valign="top" align="right"><b>User:</b></td>
281291
 @ <td valign="top">%s(zUser)</td></tr>
282
- @ <tr><td valign="top" align="right">Date:</td>
292
+ @ <tr><td valign="top" align="right"><b>Date:</b></td>
283293
 @ <td valign="top">%s(zDate)</td></tr>
284
- @ <tr><td valign="top" align="right">IP&nbspAddress:</td>
294
+ @ <tr><td valign="top" align="right"><b>IP&nbsp;Address:</b></td>
285295
 @ <td valign="top">%s(zIpAddr)</td></tr>
286296
 }
287297
 db_finalize(&q);
288298
 db_prepare(&q,
289299
 "SELECT rid, uuid, size FROM blob WHERE rcvid=%d", rcvid
290300
 );
291
- @ <tr><td valign="top" align="right">Artifacts:</td>
301
+ @ <tr><td valign="top" align="right"><b>Artifacts:</b></td>
292302
 @ <td valign="top">
293303
 while( db_step(&q)==SQLITE_ROW ){
294304
 int rid = db_column_int(&q, 0);
295305
 const char *zUuid = db_column_text(&q, 1);
296306
 int size = db_column_int(&q, 2);
297307
--- src/shun.c
+++ src/shun.c
@@ -220,10 +220,20 @@
220 "SELECT rcvid, login, datetime(rcvfrom.mtime), rcvfrom.ipaddr"
221 " FROM rcvfrom LEFT JOIN user USING(uid)"
222 " ORDER BY rcvid DESC LIMIT 31 OFFSET %d",
223 ofst
224 );
 
 
 
 
 
 
 
 
 
 
225 @ <table cellpadding=0 cellspacing=0 border=0>
226 @ <tr><th>rcvid</th><th width=15>
227 @ <th>Date</th><th width=15><th>User</th>
228 @ <th width=15><th>IP&nbsp;Address</th></tr>
229 cnt = 0;
@@ -269,28 +279,28 @@
269 " FROM rcvfrom LEFT JOIN user USING(uid)"
270 " WHERE rcvid=%d",
271 rcvid
272 );
273 @ <table cellspacing=15 cellpadding=0 border=0>
274 @ <tr><td valign="top" align="right">rcvid:</td>
275 @ <td valign="top">%d(rcvid)</td></tr>
276 if( db_step(&q)==SQLITE_ROW ){
277 const char *zUser = db_column_text(&q, 0);
278 const char *zDate = db_column_text(&q, 1);
279 const char *zIpAddr = db_column_text(&q, 2);
280 @ <tr><td valign="top" align="right">User:</td>
281 @ <td valign="top">%s(zUser)</td></tr>
282 @ <tr><td valign="top" align="right">Date:</td>
283 @ <td valign="top">%s(zDate)</td></tr>
284 @ <tr><td valign="top" align="right">IP&nbspAddress:</td>
285 @ <td valign="top">%s(zIpAddr)</td></tr>
286 }
287 db_finalize(&q);
288 db_prepare(&q,
289 "SELECT rid, uuid, size FROM blob WHERE rcvid=%d", rcvid
290 );
291 @ <tr><td valign="top" align="right">Artifacts:</td>
292 @ <td valign="top">
293 while( db_step(&q)==SQLITE_ROW ){
294 int rid = db_column_int(&q, 0);
295 const char *zUuid = db_column_text(&q, 1);
296 int size = db_column_int(&q, 2);
297
--- src/shun.c
+++ src/shun.c
@@ -220,10 +220,20 @@
220 "SELECT rcvid, login, datetime(rcvfrom.mtime), rcvfrom.ipaddr"
221 " FROM rcvfrom LEFT JOIN user USING(uid)"
222 " ORDER BY rcvid DESC LIMIT 31 OFFSET %d",
223 ofst
224 );
225 @ <p>Whenever new artifacts are added to the repository, either by
226 @ push or using the web interface, an entry is made in the RCVFROM table
227 @ to record the source of that artifact. This log facilitates
228 @ finding and fixing attempts to inject illicit content into the
229 @ repository.</p>
230 @
231 @ <p>Click on the "rcvid" to show a list of specific artifacts received
232 @ by a transaction. After identifying illicit artifacts, remove them
233 @ using the "Shun" feature.</p>
234 @
235 @ <table cellpadding=0 cellspacing=0 border=0>
236 @ <tr><th>rcvid</th><th width=15>
237 @ <th>Date</th><th width=15><th>User</th>
238 @ <th width=15><th>IP&nbsp;Address</th></tr>
239 cnt = 0;
@@ -269,28 +279,28 @@
279 " FROM rcvfrom LEFT JOIN user USING(uid)"
280 " WHERE rcvid=%d",
281 rcvid
282 );
283 @ <table cellspacing=15 cellpadding=0 border=0>
284 @ <tr><td valign="top" align="right"><b>rcvid:</b></td>
285 @ <td valign="top">%d(rcvid)</td></tr>
286 if( db_step(&q)==SQLITE_ROW ){
287 const char *zUser = db_column_text(&q, 0);
288 const char *zDate = db_column_text(&q, 1);
289 const char *zIpAddr = db_column_text(&q, 2);
290 @ <tr><td valign="top" align="right"><b>User:</b></td>
291 @ <td valign="top">%s(zUser)</td></tr>
292 @ <tr><td valign="top" align="right"><b>Date:</b></td>
293 @ <td valign="top">%s(zDate)</td></tr>
294 @ <tr><td valign="top" align="right"><b>IP&nbsp;Address:</b></td>
295 @ <td valign="top">%s(zIpAddr)</td></tr>
296 }
297 db_finalize(&q);
298 db_prepare(&q,
299 "SELECT rid, uuid, size FROM blob WHERE rcvid=%d", rcvid
300 );
301 @ <tr><td valign="top" align="right"><b>Artifacts:</b></td>
302 @ <td valign="top">
303 while( db_step(&q)==SQLITE_ROW ){
304 int rid = db_column_int(&q, 0);
305 const char *zUuid = db_column_text(&q, 1);
306 int size = db_column_int(&q, 2);
307

Keyboard Shortcuts

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