"")
{
$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="";
}
}
}
//=================================================================================
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()
{
global $period_search,$period_match ;
$query = "
SELECT *
FROM ".MAIL_SUPERV_TABLE."
;";
$data = mysql_fetch_array(pwg_query($query));
//====================================================================================
$mails_periode="+".str_replace($period_search, $period_match, $data['nb_mails_periode']);
$next_day = strtotime( $mails_periode,$data['date_mail']);
$data['rest_mail']= ( $next_day )-time() ;
$spams_periode="+".str_replace($period_search, $period_match, $data['nb_spams_periode']);
$next_day = strtotime( $spams_periode,$data['date_spam']);
$data['rest_spam']= ( $next_day )-time() ;
$quarantaine_periode="+".str_replace($period_search, $period_match, $data['quarantaine_periode']);
$next_day = strtotime( $quarantaine_periode,$data['date_quarantaine']);
if ($data['quarantaine']) {
$data['reste'] = ( $next_day )-time() ;
}else{
$data['reste'] = 0;
}
return $data;
}
//===============================================
function not_is_empty($variable)
{
global $args;
echo $variable." ".count($args[$variable]) ;
if (isset($args[$variable]))
{
if ( count($args[$variable]) > 0) ;
{
echo count($args[$variable]) ;
$args[$variable]=array_filter($args[$variable]);
echo count($args[$variable]) ;
}
}
}
//=================================================================================
function corrige_header($Carbonne,$headers)
{
global $mails_options,$conf_mail,$mailto,$args;
$headers = preg_replace('/.*'.$Carbonne.'(.*).\n/i', $Carbonne.' : '.get_strict_email_list()."\n", $headers);
return $headers;
}
function int_to_heure($int)
{
$week= (int) ($int/(3600*24*7));
$int=$int-($week*(3600*24*7));
$day= (int) ($int/(3600*24));
$int=$int-($day*(3600*24));
$heures=(int) ($int/3600);
$int=$int-($heures*(3600));
$minutes=(int) ($int/60);
$int= $int - ($minutes*(60));
$secondes=(int) ($int);
$heures= substr ('00'. $heures,-2,2);
$day= substr ('00'. $day,-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()
{
$q = "
CREATE TABLE IF NOT EXISTS ".MAIL_SUPERV_TABLE." (
`id` SMALLINT( 5 ) NOT NULL DEFAULT '0',
`nb_mails` INT NOT NULL DEFAULT '0',
`date_mail` INT NOT NULL DEFAULT '0',
`nb_mails_maxi` INT NOT NULL DEFAULT '2000',
`nb_mails_periode` TEXT ,
`nb_spams` INT NOT NULL DEFAULT '0',
`date_spam` INT NOT NULL DEFAULT '0',
`nb_spams_maxi` INT NOT NULL DEFAULT '10',
`nb_spams_periode` TEXT ,
`quarantaine` TEXT ,
`date_quarantaine` INT NOT NULL DEFAULT '0',
`quarantaine_periode` TEXT ,
`message` TEXT ,
`message_test` TEXT ,
`header_text` TEXT ,
PRIMARY KEY (`id` )
)
;";
pwg_query($q);
$nb = Get_colonnes_de(MAIL_SUPERV_TABLE);
$table=$nb[MAIL_SUPERV_TABLE];
//================================================================================
if (!in_array( "nb_mails",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails` INT NOT NULL default '0' ";
pwg_query($query); }
if (!in_array( "date_mail",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_mail` INT NOT NULL default '0' ";
pwg_query($query); }
if (!in_array( "nb_mails_maxi",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails_maxi` INT NOT NULL default '2000' ";
pwg_query($query); }
if (!in_array( "nb_mails_periode",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails_periode` TEXT ";
pwg_query($query); }
if (!in_array( "nb_spams",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams` INT NOT NULL default '0' ";
pwg_query($query); }
if (!in_array( "date_spam",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_spam` INT NOT NULL default '0' ";
pwg_query($query); }
if (!in_array( "nb_spams_maxi",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams_maxi` INT NOT NULL default '10' ";
pwg_query($query);
if (!in_array( "nb_spams_periode",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams_periode` TEXT ";
pwg_query($query); } }
if (!in_array( "quarantaine",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `quarantaine` TEXT , ";
pwg_query($query); }
if (!in_array( "date_quarantaine",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_quarantaine` INT NOT NULL default '0' ";
pwg_query($query);
}
if (!in_array( "quarantaine_periode",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `quarantaine_periode` TEXT ";
pwg_query($query); }
if (!in_array( "message",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `message` TEXT ";
pwg_query($query); }
if (!in_array( "message_test",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `message_test` TEXT ";
pwg_query($query); }
if (!in_array( "header_text",$table)) {
$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `header_text` TEXT ";
pwg_query($query); }
$query = "
SELECT COUNT(*)
FROM ".MAIL_SUPERV_TABLE."
;";
//==============================================================================
list($count) = mysql_fetch_row(pwg_query($query));
if ($count == 0)
{
$next_day = time() ;
$date_quarantaine=time();
$q = '
INSERT INTO '.MAIL_SUPERV_TABLE.' (id,
nb_mails,date_mail,nb_mails_maxi,nb_mails_periode,
nb_spams,date_spam,nb_spams_maxi,nb_spams_periode,
quarantaine, date_quarantaine,quarantaine_periode,
message,header_text)
VALUES (1,
0,
'.time().',
2000,
"1 "'.l10n('Week').'",
0,
'.time().',
10,
"2 "'.l10n('Day').'",
false,
'.time().',
"2 "'.l10n('Day').'",
"Init.",
"'.l10n('supervisor').'",
"'.l10n('hello').'"
)
;';
pwg_query($q);
}
}
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))
{
if (!empty($group['email']))
{
array_push($groups, format_email($group['username'], $group['email'] ));
}
}
}
return $groups ;
}
?>