OGSpy User Status

user_status.sh

#!/bin/sh
#Script permettant de connaitre l'utilisation des sites 
# Informations à compléter
pass_mysql_root="boubou"
#username="allyu68" 
for username in `ls -1d /home/* | sed 's/\/home\///'`
do 
	echo "############$username##############"
	mysql -u root -p"$pass_mysql_root" -D "$username" -e "SELECT user_name ,FROM_UNIXTIME(user_lastvisit) FROM ogspy_user WHERE user_id=1;SELECT config_value FROM ogspy_config WHERE config_name='version';"
	#Taille Répertoire
	echo "Taille répertoire:" 
	du -sh /home/"$username"               
done