POSTFIX AUTOMÁTICO COM MYSQL E IPTABLES - LÊ O BANCO E EXIBE OS DADOS

Descrição

Esconder código-fonte

#!/bin/sh
#
###############################################################################
#   Script TYPE_USERS.SH v1.0                                                 #
#                                                                             #
#  Autor: Alessandro Dias                                                     #
###############################################################################
#
#clear
echo "*********************************************************************************************"
echo "*                                    Programa TYPE_USER 1.0                                 *"
echo "*********************************************************************************************"
echo "Autor: Alessandro Dias"
echo "---------------------------------------------------------------------------------------------"
USERNAME=$1
if [ "$USERNAME" != "" ]; then
  echo "Dados do Usuario: "
  #Deleta o usuario do banco
  QUOTA=$(mysql -u root -ppostfix -e "select quota from user_quota where usuario='$USERNAME'" quota)
  QUOTA=`echo $QUOTA |cut -d " " -f 2`
  USO=$(mysql -u root -ppostfix -e "select uso from user_quota where usuario='$USERNAME'" quota)
  USO=`echo $USO |cut -d " " -f 2`
  NUM_MSG=$(mysql -u root -ppostfix -e "select num_msg from user_quota where usuario='$USERNAME'" quota)
  NUM_MSG=`echo $NUM_MSG |cut -d " " -f 2`
  EMAIL=$(mysql -u root -ppostfix -e "select email from user_quota where usuario='$USERNAME'" quota)
  EMAIL=`echo $EMAIL |cut -d " " -f 2`
  DESCR=$(mysql -u root -ppostfix -e "select descr from user_quota where usuario='$USERNAME'" quota)
  DESCR=`echo $DESCR |cut -d " " -f 2,3,4`
  SENHA=$(mysql -u root -ppostfix -e "select senha from user_quota where usuario='$USERNAME'" quota)
  SENHA=`echo $SENHA |cut -d " " -f 2`
  echo
  echo "Nome:  $USERNAME"
  echo "Quota: $QUOTA MB"
  echo "Uso:   $USO %"
  echo "N.Msg: $NUM_MSG"
  echo "Email: $EMAIL"
  echo "Descr: $DESCR"
  echo "Senha: $SENHA"
else 
  echo -e "\nEntre com a sintaxe correta do comando:\n./type_user.sh <nome_usuario>\n" 
fi
echo -e "---------------------------------------------------------------------------------------------\n"