#!/bin/bash
#Create Users

db_user=root
db_pw=FiresHund53
db_db=ftp_user
table=user

i=0
declare -a CURUSER

dbase=`mysql -u$db_user -p$db_pw -e "use $db_db; SELECT username,passwort_ftp FROM $table WHERE passwort_ftp!='';"`
for data in $dbase ;
    do
        let i=$i+1
        let mod=$i%2

        if [ $mod -eq 0 ]; then
            password=$data
        fi
        if [ $mod -eq 1 ]; then
            user=$data
        fi
        if [ $mod -eq 0 ]; then
            if [ $i -gt 2 ]; then
                echo Creating:$user
                mkdir /web/usr/$user
                mkdir /web/usr/$user/www
                chmod 777 -R /web/usr/$user

                useradd -s /bin/false -p $password -d /web/usr/$user $user
                mysql -u$db_user -p$db_pw -e "use $db_db; UPDATE $table SET passwort_ftp=null WHERE username='$user';"
            fi
        fi
    done