Mercurial > hgrepos > hgweb.cgi > s4
comparison s4-blog.sh @ 570:9328392f7c55
Attach user account name as baloon on author icon and name
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Tue, 23 Apr 2019 09:56:06 +0900 |
parents | 2f580c147434 |
children | 27442a1d95c0 |
comparison
equal
deleted
inserted
replaced
569:81b5ec847687 | 570:9328392f7c55 |
---|---|
268 WHEN '$notifyto' = '' THEN '' -- 不要モードならなし | 268 WHEN '$notifyto' = '' THEN '' -- 不要モードならなし |
269 WHEN '$user' = author THEN '' -- 筆者自身ならなし | 269 WHEN '$user' = author THEN '' -- 筆者自身ならなし |
270 ELSE "yes" | 270 ELSE "yes" |
271 END notify, | 271 END notify, |
272 (SELECT rowid FROM user WHERE name=author) user_rid, | 272 (SELECT rowid FROM user WHERE name=author) user_rid, |
273 author, | |
273 coalesce((SELECT val FROM user_s | 274 coalesce((SELECT val FROM user_s |
274 WHERE name=author AND key='gecos'), | 275 WHERE name=author AND key='gecos'), |
275 author) uname, | 276 author) uname, |
276 (SELECT val FROM user_s WHERE name=author AND key='$iconcachekey') | 277 (SELECT val FROM user_s WHERE name=author AND key='$iconcachekey') |
277 icon, | 278 icon, |
294 $cond_qz) a | 295 $cond_qz) a |
295 LEFT JOIN | 296 LEFT JOIN |
296 a_s s | 297 a_s s |
297 ON a.id=s.id; | 298 ON a.id=s.id; |
298 EOF | 299 EOF |
299 while IFS='|' read id edit notify uid uname icon aid tm new hte fa imgids | 300 while IFS='|' read id edit notify uid author uname icon aid tm new hte fa imgids |
300 do | 301 do |
301 cachefile="$td/$id.row.html" | 302 cachefile="$td/$id.row.html" |
302 stampfile="$td/$id.row.stamp" | 303 stampfile="$td/$id.row.stamp" |
303 editlink="${edit:+<a href="$elink+$edit">編集</a> }" | 304 editlink="${edit:+<a href="$elink+$edit">編集</a> }" |
304 nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\"\ | 305 nt="<label style=\"font-size: 70%;\"><input type=\"checkbox\"\ |
319 else | 320 else |
320 { ######## New ROW creation begins here ######## >$cachefile | 321 { ######## New ROW creation begins here ######## >$cachefile |
321 tdcls="__NEWCLS__repatt" | 322 tdcls="__NEWCLS__repatt" |
322 if [ -s "$icon" ]; then | 323 if [ -s "$icon" ]; then |
323 icfn=`echo "$icon"|htmlescape` | 324 icfn=`echo "$icon"|htmlescape` |
324 picon="<p class=\"proficon\"><a href=\"$hlink+$uid\"><img src=\"$icfn\"></a></p>" | 325 picon="<p class=\"proficon\"><a href=\"$hlink+$uid\" title=\"${author%@*}\"><img src=\"$icfn\"></a></p>" |
325 else | 326 else |
326 echo "DELETE FROM user_s WHERE key='$iconcachekey' AND | 327 echo "DELETE FROM user_s WHERE key='$iconcachekey' AND |
327 val=`sqlquotestr \"$icon\"`;" >> $iconcleaner | 328 val=`sqlquotestr \"$icon\"`;" >> $iconcleaner |
328 picon="" | 329 picon="" |
329 fi | 330 fi |
330 | 331 |
331 cat<<EOF | 332 cat<<EOF |
332 <tr id="$id"> | 333 <tr id="$id"> |
333 <td class="$tdcls">${picon}__EDIT__<a href="#$aid">#$aid</a> | 334 <td class="$tdcls">${picon}__EDIT__<a href="#$aid">#$aid</a> |
334 <a href="$hlink+$uid">$uname</a> | 335 <a href="$hlink+$uid" title="${author%@*}">$uname</a> |
335 $tm | 336 $tm |
336 <__NOTIFY__></td> | 337 <__NOTIFY__></td> |
337 EOF | 338 EOF |
338 echo -n "<td id=\"$aid\" class=\"repl\">" | 339 echo -n "<td id=\"$aid\" class=\"repl\">" |
339 echo "$hte"|unhexize|htmlescape|hreflink|minitbl | 340 echo "$hte"|unhexize|htmlescape|hreflink|minitbl |