ArkiwiAPI/arav_up_users/pure-ftpd_aravsqliteauth.sh

#! /bin/sh

BASEDIR='/var/www/vhosts/upload.arkiwi.org/htdocs'
DATADIR='/var/www/vhosts/arav.ventuordici.org/htdocs'

USERID=2004
GROUPID=33

PASSWD=`echo "<?php echo hash('SHA256','$AUTHD_PASSWORD'); ?>" | php`
QUERY="SELECT groups.dir AS DIR \
	FROM users, groups \
	WHERE groups.usergroup = users.usergroup \
	AND users.username = '$AUTHD_ACCOUNT' \
	AND users.password = '$PASSWD';"

# echo $QUERY
DIR=`echo $QUERY | sqlite3 $BASEDIR/arav_up_users/arav_users.sqlite3`

if test "$DIR" != ""; then
  echo 'auth_ok:1'
  echo uid:$USERID
  echo gid:$GROUPID
  echo dir:$DATADIR$DIR/./
else
  echo 'auth_ok:0'
fi

echo 'end'