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

yatex.org