#!/usr/bin/env bash

set -e

FTPL='pureftpd.log'
UFILE='users.txt'
TIMESTAMP=$(date +%Y%m%d)

echo "Checking to see if users file exists..."

# if to see if the users file exists. If it does move to to a backup file and name it after the current timestamp

if [ -f users.txt ]
then
	echo "Yes it does, moving to backup file"
	mv users.txt users\_$TIMESTAMP.txt
else
	echo "no file"	
fi

# here we connect to the mySQL database and pull a list of the current users down and put them into a text file. 	
echo " connecting to mysql to get users"
sleep 5	
# I know I shouldnt be using the PW here but I have been told to :/
mysql -h db.xxx.xxx.xx -u xxxxxx --password=xxxxxxx -e "use FTP; SELECT SUBSTRING_INDEX(user , '.', 1) AS username from users;" > users.txt
echo "done!"
echo "now what we need to do is read the user file, then grep the ftp log against that."
sleep 5 
while read line; 
do 
	echo "Now trying to read the user list"
	echo "${line}";
	echo "reading the file.."
	echo "grepping for the users"
	grep "$line" pureftpd.log | tail -n 5 >> main.log
done < <(cat $UFILE)	
sleep 5
echo "now we are going to check for people who have NOT uploaded"
while read line;
if [ -f notuploaded.txt ]
then
	echo "Yes it does, moving to backup file"
	mv notuploaded.txt noupload\_$TIMESTAMP.txt
else
	echo "no sign of it, creating new file"	
fi
do
	echo "$line";
	grep -v "$line" pureftpd.log > notuploaded.log
done < <(cat $UFILE) 

sleep 5

system mysql -h db.xxx.xxx.xx -u xxxxxx --password=xxxxxxx -e "use FTP; SELECT SUBSTRING_INDEX(user , '.', 1) AS username from users;" > users.txt
# Read users one by one
var str users, user ; cat "users.txt" > $users
lex "1" $users > $user
while ($user <> "")
do
    # Get the next user for next time
    lex "1" $users > $user

    # Get all lines containing this user from pureftpd.log .
    var str log ; script SS_FindStr.txt files("pureftpd.log") str($user) > $log

    # Get the number of lines in $log
    var int lines ; set $lines = { len $log }

    # We want to remove $lines-5 lines from $log.
    lex (makestr(int($lines-5))+"]") $log > null

    # Last 5 lines for user $user are in $log. Print.
    echo $log
done

if test `grep -c "$line" $UFILE` -eq 0; then ...
if ! grep -q "$line" $UFILE; then ...