21,6 → 21,7 |
sms_t="SMS_ban_temp" |
|
inb="inbox" |
SMS_c="SMS_country" |
|
config="/etc/gammu_smsd_conf" |
logfile="/var/log/gammu-smsd/gammu-smsd.log" |
97,6 → 98,23 |
mysql --user=$u_db --password=$p_db -B -se "$sql_remove_compte" |
} # end function unlock |
|
function change_country() { |
# recupère le status du pays |
sql_status_country="connect gammu; SELECT status FROM SMS_country WHERE name='$1'" |
stat=$(mysql --user=$u_db --password=$p_db -B -se "$sql_status_country") |
|
if [ $stat -eq 0 ] |
then |
sql_change_country="connect gammu; UPDATE $SMS_c SET status=1 WHERE name='$1'" |
mysql --user=$u_db --password=$p_db -B -se "$sql_change_country" |
else |
sql_change_country="connect gammu; UPDATE $SMS_c SET status=0 WHERE name='$1'" |
mysql --user=$u_db --password=$p_db -B -se "$sql_change_country" |
fi |
|
|
} # end change_country |
|
function supp_acc_rad() { |
# Suppression du compte dans Radcheck |
sql_del_compte="connect radius; DELETE FROM $rad WHERE username='$1';" |
146,146 → 164,157 |
# On recupère le nombre de mots (resultat) |
nb=$(echo $result | wc -w) |
|
# On récupère le numéro de l'ID |
id=$(echo $result | cut -d ' ' -f1) |
# On récupère le numéro de l'ID |
id=$(echo $result | cut -d ' ' -f1) |
|
numero=$(echo $result | cut -d ' ' -f2) |
numero=$(echo $result | cut -d ' ' -f2) |
|
if [[ $numero =~ ^\+ ]] |
then |
if [[ $numero =~ ^\+ ]] |
then |
|
numero=$(echo $numero | cut -d '+' -f2) |
|
# On vérifie que le numéro n'est pas Ban Perm |
sql_ban_perm="connect gammu; SELECT * FROM $sms_p WHERE SenderNumber=$numero" |
result_bp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_ban_perm") |
# On vérifie si le pays est bloqué |
sql_select_countries="connect gammu; SELECT id FROM $SMS_c WHERE status=1" |
mysql --user=$u_db --password=$p_db -B -se "$sql_select_countries" | while read result_c; |
do |
|
if test -z "$result_bp" |
then |
# Test sur le nombre de mots (resultat) |
if [ $nb -eq 2 ] # Si 2 mots : le mot de passe est manquant |
then |
# On incrémente de 1 dans la table des bans temp // NO PASSWORD |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
if [[ $numero =~ ^"$result_c" ]] |
then |
|
elif [ $nb -eq 3 ] # Si 3 mots : id + mot de passe + numero |
then |
export pass=$(echo $result | cut -d ' ' -f3) |
pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt) |
numero=$(echo $numero | cut -d '+' -f2) |
|
# On vérifie que le numéro n'est pas Ban Perm |
sql_ban_perm="connect gammu; SELECT * FROM $sms_p WHERE SenderNumber=$numero" |
result_bp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_ban_perm") |
|
if test -z "$result_bp" |
then |
# Test sur le nombre de mots (resultat) |
if [ $nb -eq 2 ] # Si 2 mots : le mot de passe est manquant |
then |
# On incrémente de 1 dans la table des bans temp // NO PASSWORD |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
|
elif [ $nb -eq 3 ] # Si 3 mots : id + mot de passe + numero |
then |
export pass=$(echo $result | cut -d ' ' -f3) |
pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt) |
|
export LC_TIME="en_US.UTF-8" |
expir=$(date '+%d %B %Y' -d "$time_account days") |
export LC_TIME="en_US.UTF-8" |
expir=$(date '+%d %B %Y' -d "$time_account days") |
|
supp_acc_rad "$numero" |
add_acc_rad "$numero" "$pass_salt" "$expir" |
supp_num_temp "$numero" |
add_num_perm "$numero" "$expir" |
supp_acc_rad "$numero" |
add_acc_rad "$numero" "$pass_salt" "$expir" |
supp_num_temp "$numero" |
add_num_perm "$numero" "$expir" |
|
else |
# Autrement, le mot de passe est trop grand ( > un mot ) |
# On incrémente d'un 1 dans la table des bans temp |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
fi |
else |
# Autrement, le mot de passe est trop grand ( > un mot ) |
# On incrémente d'un 1 dans la table des bans temp |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
fi |
|
# On gère les bans temp en ban perm |
sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'" |
r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp") |
nb_ban_t=$(echo $r_select_temp| wc -w) |
# On gère les bans temp en ban perm |
sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'" |
r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp") |
nb_ban_t=$(echo $r_select_temp| wc -w) |
|
if [ $nb_ban_t -ge $nb_essais ] |
then |
supp_num_temp "$numero" |
if [ $nb_ban_t -ge $nb_essais ] |
then |
supp_num_temp "$numero" |
|
export LC_TIME="en_US.UTF-8" |
expir_f=$(date '+%d %B %Y' -d "$time_ban days") |
export LC_TIME="en_US.UTF-8" |
expir_f=$(date '+%d %B %Y' -d "$time_ban days") |
|
# Ajout du numero table SMS_ban_perm, 1 : flood |
sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm" |
fi |
else |
date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4) |
perm=$(echo $result_bp | cut -d ' ' -f5) |
# Ajout du numero table SMS_ban_perm, 1 : flood |
sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm" |
fi |
else |
date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4) |
perm=$(echo $result_bp | cut -d ' ' -f5) |
|
export LC_TIME="en_US.UTF-8" |
date_script=$(date '+%d %B %Y' -d "now") |
export LC_TIME="en_US.UTF-8" |
date_script=$(date '+%d %B %Y' -d "now") |
|
# On converti les deux dates en secondes, pour les comparer. |
d_exp=$(date --date "$date_expiration" +%s) |
d_scr=$(date --date "$date_script" +%s) |
# On converti les deux dates en secondes, pour les comparer. |
d_exp=$(date --date "$date_expiration" +%s) |
d_scr=$(date --date "$date_script" +%s) |
|
|
if test $d_scr -gt $d_exp # Si le ban à expiré |
then |
if test $d_scr -gt $d_exp # Si le ban à expiré |
then |
|
# Test sur le nombre de mots (resultat) |
if [ $nb -eq 2 ] # Si 2 mots : le mot de passe est manquant |
then |
# On incrémente de 1 dans la table des bans temp |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
# Test sur le nombre de mots (resultat) |
if [ $nb -eq 2 ] # Si 2 mots : le mot de passe est manquant |
then |
# On incrémente de 1 dans la table des bans temp |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
|
elif [ $nb -eq 3 ] # Si 3 mots : id + mot de passe + numero |
then |
date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4) |
perm=$(echo $result_bp | cut -d ' ' -f5) |
elif [ $nb -eq 3 ] # Si 3 mots : id + mot de passe + numero |
then |
date_expiration=$(echo $result_bp | cut -d ' ' -f2,3,4) |
perm=$(echo $result_bp | cut -d ' ' -f5) |
|
date_script=$(date '+%d %B %Y' -d "now") |
date_script=$(date '+%d %B %Y' -d "now") |
|
# On converti les deux dates en secondes, pour les comparer. |
d_exp=$(date --date "$date_expiration" +%s) |
d_scr=$(date --date "$date_script" +%s) |
# On converti les deux dates en secondes, pour les comparer. |
d_exp=$(date --date "$date_expiration" +%s) |
d_scr=$(date --date "$date_script" +%s) |
|
export pass=$(echo $result | cut -d ' ' -f3) |
pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt) |
|
export LC_TIME="en_US.UTF-8" |
expir=$(date '+%d %B %Y' -d "$time_account days") |
export pass=$(echo $result | cut -d ' ' -f3) |
pass_salt=$(perl -e'print crypt($ARGV[0],$ARGV[1])' $pass $salt) |
|
export LC_TIME="en_US.UTF-8" |
expir=$(date '+%d %B %Y' -d "$time_account days") |
|
|
supp_acc_rad "$numero" |
add_acc_rad "$numero" "$pass_salt" "$expir" |
supp_num_temp "$numero" |
supp_num_perm "$numero" |
add_num_perm "$numero" "$expir" |
supp_acc_rad "$numero" |
add_acc_rad "$numero" "$pass_salt" "$expir" |
supp_num_temp "$numero" |
supp_num_perm "$numero" |
add_num_perm "$numero" "$expir" |
|
else |
# Autrement, le mot de passe est trop grand ( > un mot ) |
# On incrémente d'un 1 dans la table des bans temp |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
echo "Mot de passe incorrect, ajout du numero en ban temporaire" |
fi |
else |
# Autrement, le mot de passe est trop grand ( > un mot ) |
# On incrémente d'un 1 dans la table des bans temp |
sql_add_temp="connect gammu; INSERT INTO $sms_t(SenderNumber) VALUES ('$numero');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_temp" |
echo "Mot de passe incorrect, ajout du numero en ban temporaire" |
fi |
|
# On gère les bans temp en ban perm |
sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'" |
r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp") |
nb_ban_t=$(echo $r_select_temp| wc -w) |
# On gère les bans temp en ban perm |
sql_select_temp="connect gammu; SELECT ID FROM $sms_t WHERE SenderNumber='$numero'" |
r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp") |
nb_ban_t=$(echo $r_select_temp| wc -w) |
|
if [ $nb_ban_t -ge $nb_essais ] |
then |
if [ $nb_ban_t -ge $nb_essais ] |
then |
supp_num_perm "$numero" |
supp_num_temp "$numero" |
|
supp_num_perm "$numero" |
supp_num_temp "$numero" |
|
export LC_TIME="en_US.UTF-8" |
expir_f=$(date '+%d %B %Y' -d "$time_ban days") |
|
# Ajout du numero table SMS_ban_perm, 1 : flood |
sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');" |
mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm" |
export LC_TIME="en_US.UTF-8" |
expir_f=$(date '+%d %B %Y' -d "$time_ban days") |
|
# Ajout du numero table SMS_ban_perm, 1 : flood |
sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');" mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm" |
fi |
else |
echo "Le ban de $numero est encore valide" |
fi |
break |
fi |
else |
echo "Le ban de $numero est encore valide" |
fi |
fi |
else |
echo "Numero non autorisé (ex: 36665)" |
fi |
# On supprime la ligne d'ID=$id dans inbox |
mysql --user=$u_db --password=$p_db -B -e "$sql_delete_inbox WHERE ID=$id;" |
#else |
#echo "Pays bloqué" |
fi |
done |
else |
echo "Numero non autorisé (ex: 36665)" |
fi |
# On supprime la ligne d'ID=$id dans inbox |
mysql --user=$u_db --password=$p_db -B -e "$sql_delete_inbox WHERE ID=$id;" |
done |
} # end function new_sms |
|
399,6 → 428,35 |
unlock "$2" |
exit 0 |
;; |
--change_country) |
# Permet de changer l'état de blocage d'un pays |
a="" |
for i in "$@" |
do |
a=$(echo "$a $i") |
done |
a=$(echo $a | cut -d ' ' -f2-$#) |
change_country "$a" |
exit |
;; |
--change_country_ena_all) |
# Active l'ensemble des pays |
sql_change_country="connect gammu; UPDATE $SMS_c SET status=1" |
mysql --user=$u_db --password=$p_db -B -se "$sql_change_country" |
exit |
;; |
--change_country_dis_all) |
# Desactive l'ensemble des pays |
sql_change_country="connect gammu; UPDATE $SMS_c SET status=0" |
mysql --user=$u_db --password=$p_db -B -se "$sql_change_country" |
exit |
;; |
--change_country_filter) |
# Change la valeur du filtrage (FR, UE, all, perso) |
sql_change_country="connect gammu; UPDATE $SMS_c SET id='$2' WHERE name='FILTRAGE'" |
mysql --user=$u_db --password=$p_db -B -se "$sql_change_country" |
break |
;; |
--new_sms) |
# Appel de la fonction new_sms : filtrage du password, creation du compte et ban |
new_sms |
433,10 → 491,10 |
exit 0 |
;; |
--mode) |
# Mode huawei |
mode_huawei |
exit 0 |
;; |
# Mode huawei |
mode_huawei |
exit 0 |
;; |
*) |
# Default |
echo "$usage" |
444,4 → 502,3 |
;; |
esac |
exit 0 |
|