s4
changeset 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 | 81b5ec847687 |
children | 27442a1d95c0 |
files | s4-blog.sh |
diffstat | 1 files changed, 4 insertions(+), 3 deletions(-) [+] |
line diff
1.1 --- a/s4-blog.sh Tue Apr 23 09:22:17 2019 +0900 1.2 +++ b/s4-blog.sh Tue Apr 23 09:56:06 2019 +0900 1.3 @@ -270,6 +270,7 @@ 1.4 ELSE "yes" 1.5 END notify, 1.6 (SELECT rowid FROM user WHERE name=author) user_rid, 1.7 + author, 1.8 coalesce((SELECT val FROM user_s 1.9 WHERE name=author AND key='gecos'), 1.10 author) uname, 1.11 @@ -296,7 +297,7 @@ 1.12 a_s s 1.13 ON a.id=s.id; 1.14 EOF 1.15 - while IFS='|' read id edit notify uid uname icon aid tm new hte fa imgids 1.16 + while IFS='|' read id edit notify uid author uname icon aid tm new hte fa imgids 1.17 do 1.18 cachefile="$td/$id.row.html" 1.19 stampfile="$td/$id.row.stamp" 1.20 @@ -321,7 +322,7 @@ 1.21 tdcls="__NEWCLS__repatt" 1.22 if [ -s "$icon" ]; then 1.23 icfn=`echo "$icon"|htmlescape` 1.24 - picon="<p class=\"proficon\"><a href=\"$hlink+$uid\"><img src=\"$icfn\"></a></p>" 1.25 + picon="<p class=\"proficon\"><a href=\"$hlink+$uid\" title=\"${author%@*}\"><img src=\"$icfn\"></a></p>" 1.26 else 1.27 echo "DELETE FROM user_s WHERE key='$iconcachekey' AND 1.28 val=`sqlquotestr \"$icon\"`;" >> $iconcleaner 1.29 @@ -331,7 +332,7 @@ 1.30 cat<<EOF 1.31 <tr id="$id"> 1.32 <td class="$tdcls">${picon}__EDIT__<a href="#$aid">#$aid</a> 1.33 -<a href="$hlink+$uid">$uname</a> 1.34 +<a href="$hlink+$uid" title="${author%@*}">$uname</a> 1.35 $tm 1.36 <__NOTIFY__></td> 1.37 EOF