Subversion Repositories ALCASAR

Compare Revisions

Ignore whitespace Rev 1415 → Rev 1416

/conf/gammu-smsd-db-vierge.sql
1,13 → 1,13
-- phpMyAdmin SQL Dump
-- version 3.5.8.2
-- version 4.1.14.1
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Mar 06 Mai 2014 à 10:39
-- Version du serveur: 5.5.25-MariaDB
-- Version de PHP: 5.3.27
-- Client : localhost
-- Généré le : Mar 22 Juillet 2014 à 10:01
-- Version du serveur : 5.5.37-MariaDB
-- Version de PHP : 5.5.14
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
 
 
17,7 → 17,7
/*!40101 SET NAMES utf8 */;
 
--
-- Base de données: `gammu`
-- Base de données : `gammu`
--
 
-- --------------------------------------------------------
68,7 → 68,7
`RecipientID` text NOT NULL,
`Processed` enum('false','true') NOT NULL DEFAULT 'false',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
--
-- Déclencheurs `inbox`
293,3 → 293,255
`SenderNumber` varchar(20) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 
-- --------------------------------------------------------
 
--
-- Structure de la table `SMS_country`
--
 
CREATE TABLE IF NOT EXISTS `SMS_country` (
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
`id` varchar(20) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
`status` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
--
-- Contenu de la table `SMS_country`
--
 
INSERT INTO `SMS_country` (`name`, `id`, `status`) VALUES
('Afghanistan', '+93', 0),
('Afrique du Sud', '+27', 0),
('Albanie', '+355', 0),
('Algerie', '+213', 0),
('Allemagne', '+49', 0),
('Andorre', '+376', 0),
('Angleterre', '+44', 0),
('Angola', '+244', 0),
('Anguilla', '+1264', 0),
('Antigua et Barbuda', '+1268', 0),
('Arabie Saoudite', '+966', 0),
('Argentine', '+54', 0),
('Armenie', '+374', 0),
('Aruba', '+297', 0),
('Australie', '+61', 0),
('Autriche', '+43', 0),
('Azerbaidjan', '+994', 0),
('Bahamas', '+1242', 0),
('Bahrein', '+973', 0),
('Bangladesh', '+880', 0),
('Barbade', '+1246', 0),
('Belgique', '+32', 0),
('Benin', '+229', 0),
('Bermudes', '+1441', 0),
('Bhoutan', '+975', 0),
('Bielorussie', '+375', 0),
('Birmanie', '+95', 0),
('Bolivie', '+591', 0),
('Bonaire', '+599', 0),
('Bosnie', '+387', 0),
('Botswana', '+267', 0),
('Bresil', '+55', 0),
('Brunei', '+673', 0),
('Bulgarie', '+359', 0),
('Burkina Faso', '+226', 0),
('Burundi', '+257', 0),
('Cambodge', '+855', 0),
('Cameroun', '+237', 0),
('Canada', '+1', 0),
('Cap Vert', '+238', 0),
('Chili', '+56', 0),
('Chine', '+86', 0),
('Chypre', '+357', 0),
('Colombie', '+57', 0),
('Comores', '+269', 0),
('Congo RDC', '+243', 0),
('Congo RPC', '+242', 0),
('Coree du Nord', '+850', 0),
('Coree du Sud', '+82', 0),
('Costa Rica 1', '+501', 0),
('Costa Rica 2', '+506', 0),
('Cote d Ivoire', '+225', 0),
('Croatie', '+385', 0),
('Cuba', '+53', 0),
('Curacao', '+599', 0),
('Danemark', '+45', 0),
('Djibouti', '+253', 0),
('Dominique', '+1767', 0),
('Egypte', '+20', 0),
('El Salvador', '+503', 0),
('Emirats Arabes Unis', '+971', 0),
('Equateur', '+593', 0),
('Erythree', '+291', 0),
('Espagne', '+34', 0),
('Estonie', '+372', 0),
('Etats-Unis', '+1', 0),
('Ethiopie', '+251', 0),
('Falklands Malouines', '+500', 0),
('Finlande', '+358', 0),
('France', '+33', 1),
('Gabon', '+241', 0),
('Gambie', '+220', 0),
('Georgie', '+995', 0),
('Ghana', '+233', 0),
('Gibraltar', '+350', 0),
('Grece', '+30', 0),
('Grenade', '+1473', 0),
('Groenland', '+299', 0),
('Guadeloupe', '+590', 0),
('Guatemala', '+502', 0),
('Guernesey', '+441481', 0),
('Guinee', '+224', 0),
('Guinee Bissau', '+245', 0),
('Guinee Equatoriale', '+240', 0),
('Guyana', '+5921', 0),
('Guyane France', '+594', 0),
('Haiti', '+509', 0),
('Herm', '+441481', 0),
('Honduras', '+504', 0),
('Hong Kong', '+852', 0),
('Hongrie', '+36', 0),
('Ile de Ascension', '+247', 0),
('Ile Maurice', '+230', 0),
('Iles Cayman', '+1345', 0),
('Iles Christmas', '+61', 0),
('Iles Coco', '+61', 0),
('Iles Cook', '+682', 0),
('Iles Fidji', '+679', 0),
('Iles Mariannes', '+1670', 0),
('Iles Marshall', '+692', 0),
('Iles Salomon', '+677', 0),
('Iles Vierges GB', '+1284', 0),
('Iles Vierges USA', '+1340', 0),
('Inde', '+91', 0),
('Indonesie', '+62', 0),
('Irak', '+964', 0),
('Iran', '+98', 0),
('Irlande', '+353', 0),
('Islande', '+354', 0),
('Israel', '+972', 0),
('Italie', '+39', 0),
('Jamaique', '+1876', 0),
('Japon', '+81', 0),
('Jersey', '+441534', 0),
('Jordanie', '+962', 0),
('Kazakhstan', '+7', 0),
('Kenya', '+254', 0),
('Kirghizistan', '+996', 0),
('Kiribati', '+686', 0),
('Koweit', '+965', 0),
('Laos', '+856', 0),
('Lesotho', '+266', 0),
('Lettonie', '+371', 0),
('Liban', '+961', 0),
('Libye', '+218', 0),
('Liechtenstein', '+423', 0),
('Lituanie', '+370', 0),
('Luxembourg', '+352', 0),
('Macao', '+853', 0),
('Macedoine', '+389', 0),
('Madagascar', '+261', 0),
('Malaisie', '+60', 0),
('Malawi', '+265', 0),
('Maldives', '+960', 0),
('Mali', '+223', 0),
('Malte', '+356', 0),
('Maroc', '+212', 0),
('Martinique', '+596', 0),
('Mauritanie', '+222', 0),
('Mayotte', '+269', 0),
('Mexique', '+52', 0),
('Micronesie', '+691', 0),
('Moldavie', '+373', 0),
('Monaco', '+377', 0),
('Mongolie', '+9761', 0),
('Montserrat', '+1664', 0),
('Mozambique', '+258', 0),
('Namibie', '+264', 0),
('Nauru', '+674', 0),
('Nepal', '+977', 0),
('Nicaragua', '+505', 0),
('Niger', '+227', 0),
('Nigeria', '+2349', 0),
('Norvege', '+47', 0),
('Nouvelle Caledonie', '+687', 0),
('Nouvelle Zelande', '+64', 0),
('Oman', '+968', 0),
('Ouganda', '+2560', 0),
('Ouzbekistan', '+998', 0),
('Pakistan', '+92', 0),
('Palau', '+680', 0),
('Palestine', '+970', 0),
('Panama', '+507', 0),
('Papouasie Nouvelle Guinee', '+675', 0),
('Paraguay', '+595', 0),
('Pays-Bas', '+31', 0),
('Perou', '+51', 0),
('Philippines', '+63', 0),
('Pologne', '+48', 0),
('Polynesie France', '+689', 0),
('Porto Rico', '+1787', 0),
('Portugal', '+351', 0),
('Qatar', '+974', 0),
('Republique Centrafricaine', '+236', 0),
('Republique Dominicaine', '+1809', 0),
('Republique Tcheque', '+420', 0),
('Reunion', '+262', 0),
('Roumanie', '+40', 0),
('Royaume Uni', '+44', 0),
('Russie', '+7', 0),
('Rwanda', '+250', 0),
('Saint Marin (Rep.)', '+378', 0),
('Sainte Lucie', '+1758', 0),
('Samoa occidental', '+685', 0),
('Sao Tome et Principe', '+239', 0),
('Senegal', '+221', 0),
('Serbie', '+381', 0),
('Sercq', '+441481', 0),
('Seychelles', '+248', 0),
('Sierra Leone', '+232', 0),
('Singapour', '+65', 0),
('Slovaquie', '+421', 0),
('Slovenie', '+386', 0),
('Somalie', '+252', 0),
('Soudan', '+249', 0),
('Sri Lanka', '+94', 0),
('St Kitts', '+1869', 0),
('St Pierre et Miquelon', '+508', 0),
('St Vincent et les Grenadines', '+1784', 0),
('Suede', '+46', 0),
('Suisse', '+41', 0),
('Surinam', '+597', 0),
('Swaziland', '+268', 0),
('Syrie', '+963', 0),
('Tadjikistan', '+992', 0),
('Taiwan', '+886', 0),
('Tanzanie', '+255', 0),
('Tchad', '+235', 0),
('Thailande', '+661', 0),
('Togo', '+228', 0),
('Tonga', '+676', 0),
('Trinidad et Tobago', '+1868', 0),
('Tunisie', '+216', 0),
('Turkmenistan', '+993', 0),
('Turks et Caicos', '+1649', 0),
('Turquie', '+90', 0),
('Tuvalu', '+688', 0),
('Ukraine', '+380', 0),
('Uruguay', '+598', 0),
('Vanuatu', '+678', 0),
('Vatican', '+379', 0),
('Venezuela', '+58', 0),
('Vietnam', '+84', 0),
('Wallis et Futuna', '+681', 0),
('Yemen', '+967', 0),
('Zambie', '+260', 0),
('Zimbabwe', '+263', 0),
('FILTRAGE', 'fr', 0);
 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/scripts/alcasar-sms.sh
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
 
/scripts/sbin/alcasar-bl.sh
51,10 → 51,20
mkdir $DIR_IP_BL_ENABLED
chown apache $DIR_IP_BL_ENABLED
fi
rm -rf $DIR_DNS_BL_ENABLED $DIR_DNS_WL_ENABLED # cleaning for dnsmasq and iptables
if [ -d $DIR_DNS_BL_ENABLED ]
then
for file in `ls -1 $DIR_DNS_BL_ENABLED | grep -v "^ossi-*"`
do
rm -f $DIR_DNS_BL_ENABLED/$file
done
else
mkdir $DIR_DNS_BL_ENABLED
chown apache $DIR_DNS_BL_ENABLED
fi
rm -rf $DIR_DNS_WL_ENABLED # cleaning for dnsmasq and iptables
$SED "/\.Include/d" $DIR_DG/bannedsitelist $DIR_DG/bannedurllist # cleaning for DG
$SED "s?^[^#]?#&?g" $BL_CATEGORIES $WL_CATEGORIES # cleaning BL & WL categories file (comment all lines)
mkdir $DIR_DNS_BL_ENABLED $DIR_DNS_WL_ENABLED
mkdir $DIR_DNS_WL_ENABLED
# process the file $BL_CATEGORIES with the choice of categories
for ENABLE_CATEGORIE in `cat $BL_CATEGORIES_ENABLED`
do
85,10 → 95,10
$SED "s/^reportinglevel =.*/reportinglevel = 3/g" /etc/dansguardian/dansguardian.conf
if [ "$PARENT_SCRIPT" != "alcasar-conf.sh" ] # don't launch on install stage
then
service dansguardian restart
service dnsmasq restart
service dnsmasq-blacklist restart
service dnsmasq-whitelist restart
/bin/systemctl restart dansguardian
/bin/systemctl restart dnsmasq
/bin/systemctl restart dnsmasq-blacklist
/bin/systemctl restart dnsmasq-whitelist
/usr/local/bin/alcasar-iptables.sh
fi
}
100,10 → 110,10
$SED "s/^\*ip$/#*ip/g" $DIR_DG/bannedsitelist # remove pureip browsing
if [ "$PARENT_SCRIPT" != "alcasar-conf.sh" ] # don't launch on install stage
then
service dansguardian restart
service dnsmasq restart
service dnsmasq-blacklist restart
service dnsmasq-whitelist restart
/bin/systemctl restart dansguardian
/bin/systemctl restart dnsmasq
/bin/systemctl restart dnsmasq-blacklist
/bin/systemctl restart dnsmasq-whitelist
/usr/local/bin/alcasar-iptables.sh
fi
}
/web/acc/admin/bl_filter.php
76,15 → 76,16
$l_safe_youtube="Pour Youtube, entrez votre identifiant ici : ";
$l_youtube_id="(<a href='http://www.youtube.com/education_signup' target='cat_help' onclick=window.open('http://www.youtube.com/education_signup','cat_help','width=800,height=600,toolbar=no,scrollbars=yes,resizable=yes') title='Youtube for school'>lien pour créer un identifiant Youtube (Id)</a>)";
$l_error_open_file="Erreur d'ouverture du fichier";
$l_ip_file_title="Fichier d'IP";
$l_personal_file_title="Fichiers personnels";
$l_file_list="Liste des fichiers IP";
$l_add_ip_file="Ajouter un fichier d'IP (une IP par ligne)";
$l_add_file="Ajouter un fichier (une entrée par ligne)";
$l_file_name="Nom du fichier";
$l_file_remove="Supprimer";
$l_error_upload="Erreur d'envoi du fichier d'ip";
$l_error_upload="Erreur d'envoi du fichier";
$l_remove="Supprimer";
$l_submit="Envoyer";
$l_nb_ip="Nombre d'IP";
$l_nb_domain_names="Nombre de noms de domaine";
$l_nbDomainNames="Noms de domaine :";
$l_nbUrl="Url :";
$l_nbIp="Ip :";
124,9 → 125,9
$l_safe_youtube="For Youtube, enter your ID here : ";
$l_youtube_id="(<a href='http://www.youtube.com/education_signup' target='cat_help' onclick=window.open('http://www.youtube.com/education_signup','cat_help','width=800,height=600,toolbar=no,scrollbars=yes,resizable=yes') title='Youtube for school'>link to create a Youtube Id</a>)";
$l_error_open_file="Error opening file";
$l_ip_file_title="IP files";
$l_file_list="IP files list";
$l_add_ip_file="Add a file of IP (one IP per line)";
$l_personal_file_title="Personal files";
$l_file_list="Files list";
$l_add_file="Add a file (one entry per line)";
$l_file_name="Filename";
$l_file_remove="Remove";
$l_error_upload="Error during the upload process";
133,6 → 134,7
$l_remove="Delete";
$l_submit="Submit";
$l_nb_ip="Number of IP";
$l_nb_domain_names="Number of domain names";
$l_nbDomainNames="Domain names :";
$l_nbUrl="Url :";
$l_nbIp="Ip :";
150,7 → 152,8
$urlregex_file=$dir_dg."urlregexplist";
$bannedsite_file=$dir_dg."bannedsitelist";
$dir_tmp="/tmp/blacklists";
$upload_dir = "/usr/local/share/iptables-bl-enabled/";
$upload_dir_ip = "/usr/local/share/iptables-bl-enabled/";
$upload_dir_domain_names = "/usr/local/share/dnsmasq-bl-enabled/";
# default values
if (is_file ($conf_file))
{
257,10 → 260,11
{
if($fichier != "choix")
{
exec("rm -rf $upload_dir$fichier");
}
exec("rm -rf $upload_dir_ip$fichier");
exec("rm -rf $upload_dir_domain_names$fichier");
exec ("sudo /usr/local/sbin/alcasar-bl.sh --reload");
}
}
exec ("sudo /usr/local/bin/alcasar-iptables.sh");
break;
case 'MAJ_ip_file_upload' :
$nom = basename($_FILES['fichier_ip']['name']);
268,19 → 272,36
if(!empty($nom))
{
# On l'upload
if(move_uploaded_file($_FILES['fichier_ip']['tmp_name'], $upload_dir.$nom))
if(move_uploaded_file($_FILES['fichier_ip']['tmp_name'], $upload_dir_ip.$nom))
{
# On extrait uniquement les ip du fichier
exec("grep -Eo '([0-9]{1,3}\.){3}[0-9]{1,3}' $upload_dir$nom > $upload_dir\ossi-$nom");
# On crée la sauvegarde du set
exec("sed -i \"s/^/add blacklist_ip_blocked /g\" $upload_dir\ossi-$nom && rm -f $upload_dir$nom");
exec("grep -Eo '([0-9]{1,3}\.){3}[0-9]{1,3}' $upload_dir_ip$nom > $upload_dir_ip\ossi-ip");
 
# Suppression des doublons
exec("sort -u $upload_dir_ip\ossi-ip > $upload_dir_ip\ossi-$nom && rm -f $upload_dir_ip\ossi-ip");
 
# On adapte le fichier à la sauvegarde du set
exec("sed -i \"s/^/add blacklist_ip_blocked /g\" $upload_dir_ip\ossi-$nom");
 
# On extrait uniquement les noms de domaine
exec("grep -Eo '([a-zA-Z0-9_-]+\.){1,2}[a-zA-Z]{2,3}' $upload_dir_ip$nom > $upload_dir_domain_names\ossi-domain_names");
 
# Suppression des doublons
exec("sort -u $upload_dir_domain_names\ossi-domain_names > $upload_dir_domain_names\ossi-$nom && rm -f $upload_dir_domain_names\ossi-domain_names");
 
# On adapte le fichier pour Dnsmasq
exec("sed -i \"s/^/address=\//g\" $upload_dir_domain_names\ossi-$nom");
exec("sed -i \"s/$/\/192.168.182.1/g\" $upload_dir_domain_names\ossi-$nom");
 
# Suppression du fichier
exec("rm -f $upload_dir_ip$nom");
}
else
{
echo $l_error_upload;
}
exec ("sudo /usr/local/sbin/alcasar-bl.sh --reload");
}
exec ("sudo /usr/local/bin/alcasar-iptables.sh");
break;
}
?>
/web/acc/admin/bl_filter2.php
132,7 → 132,7
echo "</table></td><br/>";
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><th><?php echo $l_ip_file_title; ?></th></tr>
<tr><th><?php echo $l_personal_file_title; ?></th></tr>
<tr bgcolor="#FFCC66"><td><img src="/images/pix.gif" width="1" height="2"></td></tr>
</table>
<table width="100%" border=1 cellspacing=0 cellpadding=1>
141,15 → 141,15
<?php
echo "<tr><td width=50% colspan=5 align=center>";
echo "<H3>$l_file_list</H3>";
echo "<table cellspacing=2 cellpadding=3 border=1><tr><th>$l_file_name<th>$l_nb_ip<th>$l_file_remove</tr>";
exec("cd $upload_dir && ls ossi-*", $fichiersIp);
echo "<table cellspacing=2 cellpadding=3 border=1><tr><th>$l_file_name<th>$l_nb_ip<th>$l_nb_domain_names<th>$l_file_remove</tr>";
exec("cd $upload_dir_ip && ls ossi-*", $fichiersIp);
foreach($fichiersIp as $fichier => $value)
{
echo "<tr><td><center>".exec("sed 's/^.....//g' <<< $value")."</center></td><td><center>".exec("wc -l $upload_dir$value | awk '{print $1}'")."</center></td><td><center><input type='submit' name='$value' value='$l_remove'></center></td></tr>";
echo "<tr><td><center>".exec("sed 's/^.....//g' <<< $value")."</center></td><td><center>".exec("wc -l $upload_dir_ip$value | awk '{print $1}'")."</center></td><td><center>".exec("wc -l $upload_dir_domain_names$value | awk '{print $1}'")."</center></td><td><center><input type='submit' name='$value' value='$l_remove'></center></td></tr>";
}
echo "</table><br/></td></form><form action='bl_filter.php' method='POST' enctype='multipart/form-data'>";
echo "<input type='hidden' name='choix' value='MAJ_ip_file_upload'><td width=50% colspan=5 align=center>";
echo "<H3>$l_add_ip_file</H3>";
echo "<H3>$l_add_file</H3>";
echo "<input type='file' name='fichier_ip'>";
echo "<input type='submit' value='$l_submit'>";
echo "</td></tr>";
/web/acc/manager/htdocs/autoregistration.php
19,6 → 19,7
$error_nb_essais = "";
$error_time_perm = "";
$error_num_alcasar = "";
$country_filter="";
 
# Choice of language
$Language = 'en';
64,8 → 65,10
$l_num_expiration="Date d'expiration";
$l_num_action="Action";
$l_num_exist="Un compte a été créé";
$l_num_flood="Le nombre d'essais maximum a été dépacé";
$l_num_flood="Le nombre d'essais maximum a été dépassé";
$l_num_unlock="Effacer";
$l_country_enable="Activer";
$l_country_disable="Désactiver";
$l_service_status_img_ok="Démarré";
$l_service_status_img_ko="Arrété";
78,8 → 81,18
$l_tab_prev = "précédent";
$l_tab_search = "Recherche :";
$l_tab_pmenu = "Affiche la page _PAGE_ sur _PAGES_";
$l_tab_info = "Montrer _MENU_ résultat par page";
$l_tab_info = "Montrer _MENU_ résultats par page";
$l_tab_infoempty = "Aucun résultat";
 
$l_country_filter = "Filtrage en cours : ";
$l_country_filtering = " Filtrage par pays";
$l_country_filtering_plus = " Filtrage par pays avancé";
$l_phone_ban = " Numéro de téléphone bloqués";
$l_country_france_ena = "Autorise les numéros français";
$l_country_ue_ena = "Autorise les numéros européens";
$l_country_all_ena = "Autorise tous les pays";
$l_country_advanced_ena = "Autorisation personnalisé";
$l_advance = "Avancé";
}
else {
$l_title = "Auto registration (SMS)";
122,6 → 135,8
$l_num_exist="An account has been created";
$l_num_flood="The number of try has been reached";
$l_num_unlock="Erase";
$l_country_enable="Enable";
$l_country_disable="Disable";
$l_service_status_img_ok="Running";
$l_service_status_img_ko="Stopped";
136,12 → 151,22
$l_tab_pmenu = "Showing _PAGE_ to _PAGE_ of _PAGE_ entries :";
$l_tab_info = "Show _MENU_ entries";
$l_tab_infoempty = "No matching records found";
 
$l_country_filter = "Current filtering : ";
$l_country_filtering = " Country filtering";
$l_country_filtering_plus = " Country filtering advanced";
$l_phone_ban = " Phone Number banned";
$l_country_france_ena = "Authorize the french numbers";
$l_country_ue_ena = "Authorize european numbers";
$l_country_all_ena = "Authorize all countries";
$l_country_advanced_ena = "Advanced Authorization";
$l_advance = "Advanced";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><!-- written by Rexy -->
<head>
<META HTTP-EQUIV="Refresh" CONTENT="30">
<!--<META HTTP-EQUIV="Refresh" CONTENT="30">-->
<meta http-equiv="Content-Type" content="text/html; charset=$config[general_charset]">
<title>Auto enregistrement</title>
<link rel="stylesheet" href="/css/style.css">
152,11 → 177,22
<!-- DataTables -->
<script type="text/javascript" charset="utf8" src="../../../js/jquery.dataTables.js"></script>
<script type="text/javascript">
function timedRefresh(timeoutPeriod) {
var interval = setInterval(refreshPage, timeoutPeriod);
}
 
function refreshPage() {
if ($("input[name=autoRefreshCheckboxes]").is(":checked")) {
location.reload(true);
}
}
 
$(document).ready( function () {
$('#table_id').DataTable({
 
$('#table_id').DataTable({
"language": {
"paginate": {
"sFirst": "<?php echo $l_tab_dirst; ?>",
"sFirst": "<?php echo $l_tab_first; ?>",
"sLast": "<?php echo $l_tab_last; ?>",
"sPrevious": "<?php echo $l_tab_prev; ?>",
"sNext": "<?php echo $l_tab_next; ?>"
168,10 → 204,43
"sSearch": "<?php echo $l_tab_search; ?>"
}
});
 
$('#table_country').DataTable({
"language": {
"paginate": {
"sFirst": "<?php echo $l_tab_first; ?>",
"sLast": "<?php echo $l_tab_last; ?>",
"sPrevious": "<?php echo $l_tab_prev; ?>",
"sNext": "<?php echo $l_tab_next; ?>"
},
"lengthMenu": "<?php echo $l_tab_info; ?>",
"zeroRecords": "<?php echo $l_tab_infoempty; ?>",
"info": "<?php echo $l_tab_pmenu; ?>",
"infoEmpty": "<?php echo $l_tab_infoempty; ?>",
"sSearch": "<?php echo $l_tab_search; ?>"
}
});
 
$(".showhide-div_country").slideUp("slow");
$(".showhide-div_ban").slideUp("slow");
$(".showhide-div_country_plus").slideUp("slow");
 
$(".showhide-but_country").on("click", function(){
$(".showhide-div_country").slideToggle("slow");
});
 
$(".showhide-but_country_plus").on("click", function(){
$(".showhide-div_country_plus").slideToggle("slow");
});
 
$(".showhide-but_ban").on("click", function(){
$(".showhide-div_ban").slideToggle("slow");
});
 
} );
</script>
</head>
<body>
<body onload="JavaScript:timedRefresh(30000);">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="0">
<?php
echo "
183,7 → 252,7
</tr>
</TABLE>
<br />
$l_autorefresh
<input type='checkbox' checked='checked' name='autoRefreshCheckboxes' >".$l_autorefresh."</input>
";
 
?>
549,8 → 618,44
header('Location: autoregistration.php');
}
 
# Edition etat pays
if(isset($_GET['country_select'])){
$country=utf8_decode($_GET['country_select']);
exec("sudo $script --change_country $country");
exec("sudo $script --change_country_filter advance");
header('Location: autoregistration.php');
}
 
if(isset($_GET['b_france_enable'])){
exec("sudo $script --change_country_dis_all");
exec("sudo $script --change_country France");
exec("sudo $script --change_country_filter fr");
header('Location: autoregistration.php');
}
 
if(isset($_GET['b_ue_enable'])){
exec("sudo $script --change_country_dis_all");
$array_ue = array("Allemagne","Autriche","Belgique","Bulgarie","Chypre","Croatie","Danemark","Espagne","Estonie","Finlande","France","Grece","Hongrie","Irlande","Italie","Lettonie","Lituanie","Luxembourg","Malte","Pays-Bas"," Pologne","Portugal","Republique Tcheque","Roumanie","Angleterre","Slovaquie","Slovenie","Suede");
foreach ($array_ue as $pays){
exec("sudo $script --change_country $pays");
}
exec("sudo $script --change_country_filter ue");
header('Location: autoregistration.php');
}
 
if(isset($_GET["b_country_enable"])){
exec("sudo $script --change_country_ena_all");
exec("sudo $script --change_country_filter all");
header('Location: autoregistration.php');
}
 
if(isset($_GET["b_country_disable"])){
exec("sudo $script --change_country_dis_all");
header('Location: autoregistration.php');
}
 
 
#Si une clé 3g est plugué
echo "<form action=\"autoregistration.php\" methode=\"GET\">
620,9 → 725,9
</tr>
</table>
</form>";
</form>";
 
require('/etc/freeradius-web/config.php');
 
if (is_file("../../../pass/sql/drivers/$config[sql_type]/functions.php"))
630,9 → 735,8
else{
echo "<b>Could not include SQL library</b>\n";
exit();
}
}
 
 
$con = mysqli_connect("$config[sql_server]","$config[sql_username]","$config[sql_password]","gammu");
 
if(mysqli_connect_errno())
640,49 → 744,142
echo "Fail to connect to $config[sql_type]" . mysqli_connect_error();
}
 
$result = mysqli_query($con, "SELECT * FROM SMS_ban_perm");
 
# Country table
 
?>
<table id="table_id" class="display">
<thead>
 
<div style="border-radius: 5px; background: #BDBDBD; margin-top: 15px;">
<span class="showhide-but_country"><?php echo "<strong>$l_country_filtering<strong>" ?><img src="/images/down2.gif" width="15" height="15"></span>
 
<div class="showhide-div_country">
<br />
<table width=100% style="background: #BDBDBD;">
<tr>
<th><b><font color="black"><?php echo $l_num_num; ?></font></b></th>
<th><b><font color="black"><?php echo $l_num_raison; ?></font></b></th>
<th><b><font color="black"><?php echo $l_num_expiration; ?></font></b></th>
<th><b><font color="black">Action</font></b></th>
<?php
$result_country_filter = mysqli_query($con, "SELECT id FROM SMS_country WHERE name = 'FILTRAGE'");
$row = mysqli_fetch_array($result_country_filter);
 
if($row['id'] == "advance") {
$country_filter = $l_country_advanced_ena;
} elseif($row['id'] == "ue") {
$country_filter = $l_country_ue_ena;
} elseif($row['id'] == "fr") {
$country_filter = $l_country_france_ena;
} elseif($row['id'] == "all") {
$country_filter = $l_country_all_ena;
} else {
$country_filter = "Err.";
}
?>
<td colspan="3" align="center"><strong><?php echo $l_country_filter; ?></strong><font size="3" color="red"><?php echo $country_filter; ?></font></td>
</tr>
</thead>
<tbody>
<?php
while($row = mysqli_fetch_array($result))
{
echo "
<tr>
<form action=\"autoregistration.php\" methode=\"POST\">
<td>
<input type=\"hidden\" name=\"num_select\" value=\"" .$row['SenderNumber']."\">
".$row['SenderNumber']."
</td>";
<form action="autoregistration.php" methode="POST">
<td align="center" width=33%><button type="submit" name="b_france_enable"><?php echo "$l_country_france_ena" ?></button></td>
<td align="center" width=34%><button type="submit" name="b_ue_enable"><?php echo "$l_country_ue_ena" ?></button></td>
<td align="center" width=33%><button type="submit" name="b_country_enable"><?php echo "$l_country_all_ena" ?></button></td>
</form>
</tr>
</table>
<div style="border-radius: 5px; background: #D8D8D8; margin: 15px;">
<span class="showhide-but_country_plus"><?php echo "<strong>$l_country_filtering_plus<strong>" ?> <img src="/images/down2.gif" width="15" height="15"></span>
<div class="showhide-div_country_plus">
<table id="table_country" class="display">
<thead>
<tr>
<th><b><font color="black">Pays</font></b></th>
<th><b><font color="black">code</font></b></th>
<th><b><font color="black">Etat</font></b></th>
</tr>
</thead>
<tbody>
<?php
 
$result_country = mysqli_query($con, "SELECT * FROM SMS_country WHERE name != 'FILTRAGE'");
while($row = mysqli_fetch_array($result_country))
{
echo "
<tr>
<form action=\"autoregistration.php\" methode=\"POST\">
<td>
<input type=\"hidden\" name=\"country_select\" value=\"" .$row['name']."\">
".$row['name']."
</td>
<td>".$row['id']."</td>
";
if($row['status']=='0')
{
echo "<td><input type='image' src=\"/images/state_error.gif\" width=\"15\" height=\"15\"></td>";
}
if($row['status']=='1')
{
echo "<td><input type='image' src=\"/images/state_ok.gif\" width=\"15\" height=\"15\"></td>";
}
echo " </form>
</tr>
";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php
$result = mysqli_query($con, "SELECT * FROM SMS_ban_perm");
 
?>
 
<div style="border-radius: 5px; background: #BDBDBD; margin-top: 15px;">
<span class="showhide-but_ban"><?php echo "<strong>$l_phone_ban</strong>" ?><img src="/images/down2.gif" width="15" height="15"></span>
 
<div class="showhide-div_ban">
<table id="table_id" class="display">
<thead>
<tr>
<th><b><font color="black"><?php echo $l_num_num; ?></font></b></th>
<th><b><font color="black"><?php echo $l_num_raison; ?></font></b></th>
<th><b><font color="black"><?php echo $l_num_expiration; ?></font></b></th>
<th><b><font color="black">Action</font></b></th>
</tr>
</thead>
<tbody>
<?php
while($row = mysqli_fetch_array($result))
{
echo "
<tr>
<form action=\"autoregistration.php\" methode=\"POST\">
<td>
<input type=\"hidden\" name=\"num_select\" value=\"" .$row['SenderNumber']."\">
".$row['SenderNumber']."
</td>";
if($row['Perm']=='0')
{
echo "<td>$l_num_exist</td>";
}
if($row['Perm']=='1')
{
echo "<td>$l_num_flood</td>";
}
echo " <td>" . $row['Expiration']. "</td>
<td>
<input type='submit' value='".$l_num_unlock."'>
</td>
</form>
</tr>
";
}
?>
</tbody>
</table>
if($row['Perm']=='0')
{
echo "<td>$l_num_exist</td>";
}
if($row['Perm']=='1')
{
echo "<td>$l_num_flood</td>";
}
echo " <td>" . $row['Expiration']. "</td>
<td>
<input type='submit' value='".$l_num_unlock."'>
</td>
</form>
</tr>
";
}
?>
</tbody>
</table>
</div>
</div>
<?php
mysqli_close($con);
}
/web/autoregistrationinfo.php
37,9 → 37,9
$l_num_expiration = "Expiration du bloquage";
 
$l_tuto_1 = "Bienvenue sur la page d'auto enregistrement.";
$l_tuto_2 = "Le portail auquel vous essayez de vous connectez offre la possibilité de s'inscrire automatiquement, en envoyant votre mot de passe par SMS au numéro (prix d'un SMS, non surtaxé):";
$l_tuto_2 = "Le portail auquel vous essayez de vous connecter offre la possibilité de s'inscrire automatiquement, en envoyant votre mot de passe par SMS au numéro (prix d'un SMS, non surtaxé):";
$l_tuto_3 = "Votre SMS ne doit contenir qu'un seul mot.";
$l_tuto_4 = "A la suite de votre inscription, vous pourrez retrouver votre numéro de téléphone dans le tableau ci-dessous, avec l'état et la date d'expiration de validité ou bloquage de ce dernier.";
$l_tuto_4 = "A la suite de votre inscription, vous pourrez retrouver votre numéro de téléphone dans le tableau ci-dessous, avec l'état et la date d'expiration de validité ou blocage de ce dernier.";
$l_tuto_5 = "Le champ de recherche ci-dessous vous permet de rechercher votre numéro suivant les 5 derniers chiffres.";
 
$l_tab_first = "premier";
48,7 → 48,7
$l_tab_prev = "précédent";
$l_tab_search = "Recherche :";
$l_tab_pmenu = "Affiche la page _PAGE_ sur _PAGES_";
$l_tab_info = "Montrer _MENU_ résultat par page";
$l_tab_info = "Montrer _MENU_ résultats par page";
$l_tab_infoempty = "Aucun résultat";
} elseif($Language == 'en'){