Mercurial > hgrepos > hgweb.cgi > 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 wrap: on
line diff
--- a/s4-blog.sh Tue Apr 23 09:22:17 2019 +0900 +++ b/s4-blog.sh Tue Apr 23 09:56:06 2019 +0900 @@ -270,6 +270,7 @@ ELSE "yes" END notify, (SELECT rowid FROM user WHERE name=author) user_rid, + author, coalesce((SELECT val FROM user_s WHERE name=author AND key='gecos'), author) uname, @@ -296,7 +297,7 @@ a_s s ON a.id=s.id; EOF - while IFS='|' read id edit notify uid uname icon aid tm new hte fa imgids + while IFS='|' read id edit notify uid author uname icon aid tm new hte fa imgids do cachefile="$td/$id.row.html" stampfile="$td/$id.row.stamp" @@ -321,7 +322,7 @@ tdcls="__NEWCLS__repatt" if [ -s "$icon" ]; then icfn=`echo "$icon"|htmlescape` - picon="<p class=\"proficon\"><a href=\"$hlink+$uid\"><img src=\"$icfn\"></a></p>" + picon="<p class=\"proficon\"><a href=\"$hlink+$uid\" title=\"${author%@*}\"><img src=\"$icfn\"></a></p>" else echo "DELETE FROM user_s WHERE key='$iconcachekey' AND val=`sqlquotestr \"$icon\"`;" >> $iconcleaner @@ -331,7 +332,7 @@ cat<<EOF <tr id="$id"> <td class="$tdcls">${picon}__EDIT__<a href="#$aid">#$aid</a> -<a href="$hlink+$uid">$uname</a> +<a href="$hlink+$uid" title="${author%@*}">$uname</a> $tm <__NOTIFY__></td> EOF