"")
{
$erreur_message=str_replace("\n",'
',$erreur_message) ;
$template->assign('errors',$erreur_message);
$erreur_message="";
}
}
if (isset($infos_message))
{
if ($infos_message <> "")
{
$infos_message=str_replace("\n",'
',$infos_message) ;
$template->assign('infos',$infos_message);
$infos_message="";
}
}
if (kill_list() && $user['status'] == 'guest')
if (!isset($_GET['admin'])) {
// die('blacklist Hacking attempt!');
}else{
if ($_GET['admin'] != 'piwigo')
{
// die('blacklist Hacking attempt!');
}
}
}
//=================================================================================
function Get_Datas()
{
ob_start();
$data=Lire_datas();
$m= ob_get_contents();
ob_end_clean();
if (strlen($m)>0) {
vérif_base() ;
$data=Lire_datas();
}
return $data;
}
function Lire_datas()
{
$query = "
SELECT *
FROM ".MAIL_SUPERV_TABLE."
;";
$data = mysql_fetch_array(pwg_query($query),MYSQL_ASSOC);
//====================================================================================
$next_day = Str_To_Time( $data['nb_mails_periode'], $data['date_mail'] );;
$data['rest_mail']= $next_day - time() ;
$next_day = + Str_To_Time( $data['nb_spams_periode'],$data['date_spam']);
$data['rest_spam']= $next_day - time() ;
$next_day = Str_To_Time($data['quarantaine_periode'] ,$data['date_quarantaine']);
if ($data['quarantaine'] == 'true' ) {
$data['reste'] = ( $next_day )-time() ;
}else{
$data['reste'] = 0;
}
return $data;
}
//===============================================
function corrige_header($Carbonne,$headers,$args)
{
global $mails_options,$conf_mail,$mailto,$infos_message;
if (!empty($args[$Carbonne]))
{
if ( count($args[$Carbonne]) > 0 )
{
if ($mails_options[1] == 'on') {
$list_mail = str_replace(","," ,",get_strict_email_list(implode(',', $args[$Carbonne])))." \n" ;
$headers = preg_replace('/.*'.$Carbonne.'(.*).\n/i', $Carbonne.': '.$list_mail, $headers);
}
}
} else {
// Raz Bcc, Cc dans headers
$headers = preg_replace('/.*'.$Carbonne.'(.*).\n/i', "" , $headers);
}
return $headers;
}
function int_to_heure($int)
{
$delta=(7*24*60*60) ;
$week = (int) ($int/$delta);
$int= $int-($week*$delta) ;
$delta=(24*60*60) ;
$day= (int) ($int/$delta);
$int=$int-($day*$delta);
$delta=(60*60) ;
$heures=(int) ($int/$delta);
$int=$int-($heures*$delta);
$delta=(60) ;
$minutes=(int) ($int/$delta);
$int= $int - ($minutes*$delta);
$secondes=(int) ($int);
$day = substr ('00'. $day,-2,2);
$heures = substr ('00'. $heures,-2,2);
$minutes = substr ('00'.$minutes,-2,2);
$secondes = substr ('00'.$secondes,-2,2);
if ($week > 0 )
{
return $week. " " .l10n('Week'). " " . $day . " " .l10n('Day'). "s ". $heures . " ". l10n('Hour'). "s " . $minutes. " " .l10n('minute'). "s ". $secondes." " .l10n('seconde')."s";
}
return $day . " " .l10n('Day'). "s ". $heures . " ". l10n('Hour'). "s " . $minutes. " " .l10n('Minute'). "s ". $secondes." " .l10n('Seconde')."s";
}
function memo_var($variables)
{
ob_start();
echo '';
print_r($variables);
echo '
';
$m= ob_get_contents();
ob_end_clean();
return $m;
}
function vérif_base()
{
global $lang,$superv_champs,$superv_type,$superv_bl_champs,$superv_bl_type;
load_language('plugin.lang', MAIL_SUPERV_PATH);
create_table(MAIL_SUPERV_TABLE,$superv_champs,$superv_type) ;
ajust_table(MAIL_SUPERV_TABLE,$superv_champs,$superv_type) ;
//==============================================================================
$valeurs= array ( 1,
0,
time(),
2000,
'"1 '.l10n('Week').'"' ,
0,
time(),
10,
'"2 '.l10n('Day').'"',
'"false"',
time(),
'"2 '.l10n('Day').'"',
'"Init"',
'"'.l10n('supervisor').'"',
'"'.l10n('hello').'"',
)
;
ajout_ligne(MAIL_SUPERV_TABLE,$superv_champs, $valeurs,false ) ;
create_table(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs,$superv_bl_type) ;
ajust_table(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs,$superv_bl_type) ;
}
function Get_colonnes_de($table)
{
$columns_of = array();
$query = 'DESC '.$table.';';
$result = mysql_query($query);
$columns_of[$table] = array();
while ($row = mysql_fetch_row($result))
{
array_push($columns_of[$table], $row[0]);
}
return $columns_of;
}
function get_liste($group_id)
{
global $conf ;
$query = '
SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
u.'.$conf['user_fields']['username'].' AS username,
u.'.$conf['user_fields']['email'].' AS email,
ui.status,
ui.adviser,
ui.enabled_high,
ui.level
FROM '.USERS_TABLE.' AS u
INNER JOIN '.USER_INFOS_TABLE.' AS ui
ON u.'.$conf['user_fields']['id'].' = ui.user_id
LEFT JOIN '.USER_GROUP_TABLE.' AS ug
ON u.'.$conf['user_fields']['id'].' = ug.user_id
WHERE ug.group_id='.$group_id.' ';
$groups=array();
$datas = pwg_query($query);
if (!empty($datas))
{
while ($group = mysql_fetch_array($datas,MYSQL_ASSOC))
{
if (!empty($group['email']))
{
array_push($groups, format_email($group['username'], $group['email'] ));
}
}
}
return $groups ;
}
//=================================================================================
function create_table($nom_table,$champs,$types) //MAIL_SUPERV_TABLE
{
/* $nb = Get_colonnes_de($nom_table);
$table=$nb[$nom_table]; */
$data = $types ;
$i=0;
$valeurs=array();
foreach ( $champs as $champ)
{
$champ = trim($champ);
array_push($valeurs , " `".$champ."`" . ' ' . $data[ $i] ) ;
$i +=1;
}
if ( count($valeurs) == 0) return ;
$valeurs=implode(", ",$valeurs) ;
//===============================================================================
$query = "CREATE TABLE IF NOT EXISTS `" . $nom_table . "` (". $valeurs . " , PRIMARY KEY (`id` ) ) ;";
if ( pwg_query($query) ) return ;
die($query);
}
function ajust_table($nom_table,$champs,$types) //MAIL_SUPERV_TABLE
{
$nb = Get_colonnes_de($nom_table);
$table=$nb[$nom_table];
$data = $types ;
$i=0;
$valeurs=array();
foreach ( $champs as $champ)
{
$champ = trim($champ);
if (!in_array( $champ,$table)) {
array_push($valeurs , " ADD `".$champ."`" . ' ' . $data[ $i] ) ;
}
$i +=1;
}
if ( count($valeurs) == 0) return ;
$valeurs=implode(", ",$valeurs) ;
//===============================================================================
$query = "ALTER TABLE `" . $nom_table . "` ". $valeurs ;
if ( pwg_query($query)) return ;
die($query);
}
function ajout_ligne($nom_table,$champs,$valeurs,$force)
{
if (!$force) {
$query = "
SELECT COUNT(`id`) as total
FROM `".$nom_table."`
;";
//==============================================================================
list($count) = mysql_fetch_row(pwg_query($query));
}else{
$count = 0 ;
}
if ($count == 0)
{
$n_champs=implode(",",$champs);
$n_valeurs=implode(",",$valeurs);
$query = "
INSERT INTO `".$nom_table."` (". $n_champs.")
VALUES ( ". $n_valeurs .")";
if (pwg_query($query)) return ;
die($query);
}
}
//=====================================================================
function Str_To_Time( $ajout,$init_date)
{
//========================================================
global $erreur_message;
$a_ajouter=$ajout ;
$period_search=array("W","D","H","M","S");
array_push($period_search,l10n('Week').'s',l10n('Day').'s',l10n('Hour').'s',l10n('Minute').'s',l10n('Seconde').'s');
array_push($period_search,l10n('Week'),l10n('Day'),l10n('Hour'),l10n('Minute'),l10n('Seconde'));
$period_match = array(' week ',' day ',' hour ',' minute ',' seconde ');
array_push($period_match,' week ',' day ',' hour ',' minute ',' seconde ');
array_push($period_match,' week ',' day ',' hour ',' minute ',' seconde ');
$a_ajouter = "+ " . str_replace($period_search, $period_match, $a_ajouter) ;
$a_ajouter=sup_double_espace($a_ajouter);
$v1 = array('- ','+ ','week','day','hour','minute','seconde',' -',' +',' ');
$v2 = array('-','+', (7*24*60*60) , (24*60*60), (60*60), 60,1,'|-','|+',"*" );
$new_valeur = str_replace($v1,$v2,$a_ajouter) ;
$new_valeur = str_replace('++','+',$new_valeur ) ;
$new_valeur = explode( "|",$new_valeur );
$p = $init_date ;
//$new_valeur = $a_ajouter + $init_date ;
foreach($new_valeur as $nv)
{
$return = matheval($nv) ;
if (strpos("error",$return)===false) {
$p += $return ;
}else {
$erreur_message .= $return . " nv : " . $nv ;
}
}
return $p ;
}
//=====================================================================================
function matheval($equation)
{
$return="error";
$equation = preg_replace("/[^0-9+\-.*\/()%]/","",$equation);
$equation = preg_replace("/([+-])([0-9]{1})(%)/","*(1\$1.0\$2)",$equation);
$equation = preg_replace("/([+-])([0-9]+)(%)/","*(1\$1.\$2)",$equation);
$equation = preg_replace("/([0-9]+)(%)/",".\$1",$equation);
if ( $equation == "" )
{
$return = 0;
} else {
@eval("\$return=" . $equation . ";" );
}
return $return;
}
//======================================================================================
function sup_double_espace($chaine){
global $erreur_message;
$str_temp = $chaine." ";
$sep=" ";
$chaine = trim($chaine);
$existe = (strpos($sep.$sep,$chaine )===false) ;
while ($existe ){
$str_temp = str_replace($sep.$sep, $sep, $chaine );
if($str_temp == $chaine ) return $chaine ;
// $erreur_message .= memo_var($str_temp) ;
$chaine = $str_temp;
$existe = (strpos($sep.$sep,$chaine )===false) ;
}
return $chaine;
}
function kill_list()
{
//==================== TEST black_liste ============================================
$query = "
SELECT *,COUNT(`id`) as total
FROM `".MAIL_BLACK_LISTE_TABLE."`
WHERE ip='".$_SERVER['REMOTE_ADDR']."'
;";
//==============================================================================
$row = mysql_fetch_row(pwg_query($query));
if (count($row) > 0)
{
$nb = ($row[7])+1;
$pays = isset($_POST['pays']) ? $_POST['pays'] : $pays="" ;
$ville = (isset($_POST['ville'])) ? $_POST['ville']: $ville="" ;
$region = isset($_POST['region']) ? $_POST['region'] : $region="" ;
$query ="
UPDATE " . MAIL_BLACK_LISTE_TABLE . "
SET ";
if (isset($_POST['pays']))
$query .= "
`pays` = '". $pays ."',
`region` = '" . $region ."',
`ville` = '" . $ville . "',
";
$query .= "
`nb` = " . $nb . "
WHERE ip = '".$_SERVER['REMOTE_ADDR']."' ;
";
pwg_query($query );
//================================================================================
}
return (count($row) > 0) ;
}
?>