[platal.git] / bin / getuser.sh

#!/bin/sh

field=$1
nom=$2
promo=$3

query="SELECT $field FROM auth_user_md5 AS u "
where=""
pos=0
for i in $nom ; do
  query="$query INNER JOIN search_name AS sn${pos} ON (u.user_id = sn${pos}.uid) "
  [ "$where" != "" ] && where="$where AND"
  where="${where} sn${pos}.token LIKE \"${i}%\""
  pos=$((pos + 1))
done
if [ "${promo}" != "" ] ; then
  [ "$where" != "" ] && where="$where AND "
  where="${where} u.promo = $promo"
fi
query="${query} WHERE ${where} GROUP BY u.user_id"

echo $query | mysql --default-character-set=utf8 -N x4dat
Commit	Line	Data
5c110c68 FB	1	#!/bin/sh
	2
	3	field=$1
	4	nom=$2
	5	promo=$3
	6
	7	query="SELECT $field FROM auth_user_md5 AS u "
	8	where=""
	9	pos=0
	10	for i in $nom ; do
	11	query="$query INNER JOIN search_name AS sn${pos} ON (u.user_id = sn${pos}.uid) "
	12	[ "$where" != "" ] && where="$where AND"
	13	where="${where} sn${pos}.token LIKE \"${i}%\""
	14	pos=$((pos + 1))
	15	done
	16	if [ "${promo}" != "" ] ; then
	17	[ "$where" != "" ] && where="$where AND "
	18	where="${where} u.promo = $promo"
	19	fi
	20	query="${query} WHERE ${where} GROUP BY u.user_id"
	21
	22	echo $query \| mysql --default-character-set=utf8 -N x4dat