changeset 677:bdf33fbd977b

Sort team names
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 13 May 2020 10:48:59 +0900
parents cd6f0badcff4
children db77378201ab
files s4-funcs.sh
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/s4-funcs.sh	Wed May 13 10:45:23 2020 +0900
+++ b/s4-funcs.sh	Wed May 13 10:48:59 2020 +0900
@@ -2405,7 +2405,7 @@
 hexteams() {	# $1=gname, $2(optional)=user
   cond=${2:+" AND user='$2'"}
   query "SELECT DISTINCT hex(val) FROM grp_mem_m
-	 WHERE gname='$1' AND key='team'$cond;"
+	 WHERE gname='$1' AND key='team'$cond ORDER by val;"
 }
 showgroup() { # $1=group-rowid
   if [ -z "$1" ]; then

yatex.org