/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'){ |