#!/bin/sh
#
#    users - Show app users
#
db()
{
    sed -nr "s/^.db$1 = \"([^\"]+)\";.*\$/\\1/p" dbcfg.php
}
cd `dirname $0`

test "$1" && ord=" ORDER BY $1"
mysql -h$(db host) -u$(db user) --password=$(db pass) -D$(db name) -e "SELECT u.id,user,pass,p.name AS profile,s.name AS structure FROM users u,profiles p,structures s WHERE u.profile = p.id AND u.structure = s.id$ord"