Subversion Repositories ALCASAR

Rev

Rev 1387 | Rev 1452 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log

Rev 1387 Rev 1416
Line 19... Line 19...
19 
 
 19 
 
20 
sms_p="SMS_ban_perm"
 20 
sms_p="SMS_ban_perm"
21 
sms_t="SMS_ban_temp"
 21 
sms_t="SMS_ban_temp"
22 
 
 22 
 
23 
inb="inbox"
 23 
inb="inbox"
- 
 
 24 
SMS_c="SMS_country"
24 
 
 25 
 
25 
config="/etc/gammu_smsd_conf"
 26 
config="/etc/gammu_smsd_conf"
26 
logfile="/var/log/gammu-smsd/gammu-smsd.log"
 27 
logfile="/var/log/gammu-smsd/gammu-smsd.log"
27 
script="/usr/local/bin/alcasar-sms.sh"
 28 
script="/usr/local/bin/alcasar-sms.sh"
28 
separator="########## START ##########"
 29 
separator="########## START ##########"
Line 95... Line 96...
95 
	# Suppression du compte dans Radcheck
 96 
	# Suppression du compte dans Radcheck
96 
		sql_remove_compte="connect radius; DELETE FROM $rad WHERE username='$1';"
 97 
		sql_remove_compte="connect radius; DELETE FROM $rad WHERE username='$1';"
97 
		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_compte"
 98 
		mysql --user=$u_db --password=$p_db -B -se "$sql_remove_compte"
98 
} # end function unlock
 99 
} # end function unlock
99 
 
 100 
 
- 
 
 101 
function change_country() {
- 
 
 102 
	# recupère le status du pays
- 
 
 103 
		sql_status_country="connect gammu; SELECT status FROM SMS_country WHERE name='$1'"
- 
 
 104 
		stat=$(mysql --user=$u_db --password=$p_db -B -se "$sql_status_country")
- 
 
 105 
 
- 
 
 106 
		if [ $stat -eq 0 ]
- 
 
 107 
		then
- 
 
 108 
			sql_change_country="connect gammu; UPDATE $SMS_c SET status=1 WHERE name='$1'"
- 
 
 109 
			mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
- 
 
 110 
		else
- 
 
 111 
			sql_change_country="connect gammu; UPDATE $SMS_c SET status=0 WHERE name='$1'"
- 
 
 112 
			mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
- 
 
 113 
		fi
- 
 
 114 
 
- 
 
 115 
 
- 
 
 116 
} # end change_country
- 
 
 117 
 
100 
function supp_acc_rad() {
 118 
function supp_acc_rad() {
101 
	# Suppression du compte dans Radcheck
 119 
	# Suppression du compte dans Radcheck
102 
		sql_del_compte="connect radius; DELETE FROM $rad WHERE username='$1';"
 120 
		sql_del_compte="connect radius; DELETE FROM $rad WHERE username='$1';"
103 
		mysql --user=$u_db --password=$p_db -B -se "$sql_del_compte"
 121 
		mysql --user=$u_db --password=$p_db -B -se "$sql_del_compte"
104 
} # end function supp_acc_rad()
 122 
} # end function supp_acc_rad()
Line 152... Line 170...
152 
	numero=$(echo $result | cut -d ' ' -f2)
 170 
		numero=$(echo $result | cut -d ' ' -f2)
153 
 
 171 
 
154 
	if [[ $numero =~ ^\+ ]]
172 
		if [[ $numero =~ ^\+ ]]
155 
	then
 173 
		then
156
174
- 
 
 175 
			# On vérifie si le pays est bloqué
- 
 
 176 
				sql_select_countries="connect gammu; SELECT id FROM $SMS_c WHERE status=1"
- 
 
 177 
				mysql --user=$u_db --password=$p_db -B -se "$sql_select_countries" | while read result_c;
- 
 
 178 
				do
- 
 
 179 
 
- 
 
 180 
				if [[ $numero =~ ^"$result_c" ]]
- 
 
 181 
				then
- 
 
 182 
 
157 
		numero=$(echo $numero | cut -d '+' -f2)
 183 
				numero=$(echo $numero | cut -d '+' -f2)
158
184 
 
159 
		# On vérifie que le numéro n'est pas Ban Perm
185 
				# On vérifie que le numéro n'est pas Ban Perm
160 
			sql_ban_perm="connect gammu; SELECT * FROM $sms_p WHERE SenderNumber=$numero"
 186 
					sql_ban_perm="connect gammu; SELECT * FROM $sms_p WHERE SenderNumber=$numero"
161 
			result_bp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_ban_perm")
 187 
					result_bp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_ban_perm")
Line 264... Line 290...
264 
						r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp")
 290 
								r_select_temp=$(mysql --user=$u_db --password=$p_db -B -se "$sql_select_temp")
265 
						nb_ban_t=$(echo $r_select_temp| wc -w)
 291 
								nb_ban_t=$(echo $r_select_temp| wc -w)
266
292
267 
					if [ $nb_ban_t -ge $nb_essais ]
 293 
							if [ $nb_ban_t -ge $nb_essais ]
268 
					then
 294 
							then
269
- 
 
270 
						supp_num_perm "$numero"
 295 
								supp_num_perm "$numero"
271 
						supp_num_temp "$numero"
 296 
								supp_num_temp "$numero"
272
297
273 
							export LC_TIME="en_US.UTF-8"
 298 
									export LC_TIME="en_US.UTF-8"
274 
							expir_f=$(date '+%d %B %Y' -d "$time_ban days")
 299 
									expir_f=$(date '+%d %B %Y' -d "$time_ban days")
275
300
276 
						# Ajout du numero table SMS_ban_perm, 1 : flood
 301 
								# Ajout du numero table SMS_ban_perm, 1 : flood
277 
							sql_add_ban_perm="connect gammu; INSERT INTO $sms_p (SenderNumber,Perm,Expiration) VALUES ('$numero',1,'$expir_f');"
 302 
									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"
278 
							mysql --user=$u_db --password=$p_db -B -se "$sql_add_ban_perm"
 - 
 
279 
					fi
 303 
							fi
280 
				else
 304 
						else
281 
					echo "Le ban de $numero est encore valide"
305 
							echo "Le ban de $numero est encore valide"
282 
				fi
306 
						fi
- 
 
 307 
						break
- 
 
 308 
					fi
- 
 
 309 
				#else
- 
 
 310 
					#echo "Pays bloqué"
283 
			fi
311 
				fi
- 
 
 312 
			done
284 
	else
 313 
		else
285 
		echo "Numero non autorisé (ex: 36665)"
 314 
			echo "Numero non autorisé (ex: 36665)"
286 
	fi
 315 
		fi
287 
			# On supprime la ligne d'ID=$id dans inbox
 316 
				# On supprime la ligne d'ID=$id dans inbox
288 
			mysql --user=$u_db --password=$p_db -B -e "$sql_delete_inbox WHERE ID=$id;"
 317 
				mysql --user=$u_db --password=$p_db -B -e "$sql_delete_inbox WHERE ID=$id;"
Line 397... Line 426...
397 
	--unlock_num)
 426 
	--unlock_num)
398 
		# Appel de la fonction unlock : deban un numero $2
 427 
		# Appel de la fonction unlock : deban un numero $2
399 
		unlock "$2"
 428 
		unlock "$2"
400 
		exit 0
429 
		exit 0
401 
		;;
 430 
		;;
- 
 
 431 
	--change_country)
- 
 
 432 
		# Permet de changer l'état de blocage d'un pays
- 
 
 433 
		a=""
- 
 
 434 
		for i in "$@"
- 
 
 435 
		do
- 
 
 436 
			a=$(echo "$a $i")
- 
 
 437 
		done
- 
 
 438 
		a=$(echo $a | cut -d ' ' -f2-$#)
- 
 
 439 
		change_country "$a"
- 
 
 440 
		exit
- 
 
 441 
		;;
- 
 
 442 
	--change_country_ena_all)
- 
 
 443 
		# Active l'ensemble des pays
- 
 
 444 
		sql_change_country="connect gammu; UPDATE $SMS_c SET status=1"
- 
 
 445 
		mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
- 
 
 446 
		exit
- 
 
 447 
		;;
- 
 
 448 
	--change_country_dis_all)
- 
 
 449 
		# Desactive l'ensemble des pays
- 
 
 450 
		sql_change_country="connect gammu; UPDATE $SMS_c SET status=0"
- 
 
 451 
		mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
- 
 
 452 
		exit
- 
 
 453 
		;;
- 
 
 454 
	--change_country_filter)
- 
 
 455 
		# Change la valeur du filtrage (FR, UE, all, perso)
- 
 
 456 
		sql_change_country="connect gammu; UPDATE $SMS_c SET id='$2' WHERE name='FILTRAGE'"
- 
 
 457 
		mysql --user=$u_db --password=$p_db -B -se "$sql_change_country"
- 
 
 458 
		break
- 
 
 459 
		;;
402 
	--new_sms)
 460 
	--new_sms)
403 
		# Appel de la fonction new_sms : filtrage du password, creation du compte et ban
 461 
		# Appel de la fonction new_sms : filtrage du password, creation du compte et ban
404 
		new_sms
 462 
		new_sms
405 
		exit 0
 463 
		exit 0
406 
		;;
 464 
		;;
Line 442... Line 500...
442 
		echo "$usage"
 500 
		echo "$usage"
443 
		exit 0
 501 
		exit 0
444 
		;;
 502 
		;;
445 
esac
 503 
esac
446 
exit 0
 504 
exit 0
447 
 
 -