Context Navigation

source: extensions/Mail_supervisor/include/fonctions.php @ 4065

Last change on this file since 4065 was 4065, checked in by cljosse, 15 years ago
[mail_supervisor] update help.
File size: 14.0 KB

Rev	Line
[4020]	1	<?php
[4029]	2	// +-----------------------------------------------------------------------+
	3	// \| Piwigo - a PHP based picture gallery \|
	4	// +-----------------------------------------------------------------------+
	5	// \| Copyright(C) 2008-2009 Piwigo Team http://piwigo.org \|
	6	// \| Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net \|
	7	// \| Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick \|
	8	// +-----------------------------------------------------------------------+
	9	// \| This program is free software; you can redistribute it and/or modify \|
	10	// \| it under the terms of the GNU General Public License as published by \|
	11	// \| the Free Software Foundation \|
	12	// \| \|
	13	// \| This program is distributed in the hope that it will be useful, but \|
	14	// \| WITHOUT ANY WARRANTY; without even the implied warranty of \|
	15	// \| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU \|
	16	// \| General Public License for more details. \|
	17	// \| \|
	18	// \| You should have received a copy of the GNU General Public License \|
	19	// \| along with this program; if not, write to the Free Software \|
	20	// \| Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, \|
	21	// \| USA. \|
	22	// +-----------------------------------------------------------------------+
	23
	24	if (!defined('PHPWG_ROOT_PATH'))
	25	{
	26	die('Hacking attempt!');
	27	}
[4051]	28	if (!defined('MAIL_SUPERV_DIR')) define('MAIL_SUPERV_DIR' , basename(dirname(__FILE__)));
[4041]	29	if (!defined('MAIL_SUPERV_PATH')) define('MAIL_SUPERV_PATH' , PHPWG_PLUGINS_PATH.basename(dirname(__FILE__)).'/');
[4029]	30
[4049]	31
[4020]	32	include_once(PHPWG_ROOT_PATH.'include/functions_mail.inc.php');
[4052]	33	include_once(PHPWG_ROOT_PATH.'include/functions.inc.php');
[4053]	34
	35	global $lang ;
	36
[4040]	37	include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
	38	include_once (MAIL_SUPERV_PATH.'include/function_test_send.php');
	39
[4053]	40	global $period_search,$period_match,$lang ;
[4040]	41
[4053]	42
[4059]	43	load_language('plugin.lang', MAIL_SUPERV_PATH);
	44	$period_search=array("W","D","H","M","S");
[4029]	45	array_push($period_search,l10n('Week'),l10n('Day'),l10n('Hour'),l10n('Minute'),l10n('Seconde'));
[4059]	46	array_push($period_search,l10n('Week').'s',l10n('Day').'s',l10n('Hour').'s',l10n('Minute').'s',l10n('Seconde').'s');
[4029]	47
[4059]	48
	49	$period_match=array(' week',' day',' hour',' minute',' seconde');
[4029]	50	array_push($period_match,'week','day','hour','minute','seconde');
[4059]	51	array_push($period_match,'week','day','hour','minute','seconde');
	52
[4020]	53
	54	function sauve_options()
	55	{
	56	global $mails_options ;
	57	$query = '
	58	UPDATE '.CONFIG_TABLE.'
	59	SET value="'.$mails_options[0]. ',' .$mails_options[1]. ',' .$mails_options[2].',' .$mails_options[3]. ',' .$mails_options[4]. '"
	60	WHERE param="mail_superv"
	61	LIMIT 1';
	62	pwg_query($query);
	63
	64	}
	65	//=================================================================================
	66	function sauve_données()
	67	{
	68	global $mails_données ;
[4029]	69
	70	$query = '
[4020]	71	UPDATE '.MAIL_SUPERV_TABLE.'
	72	SET `nb_mails` = '.$mails_données['nb_mails'].',
	73	`date_mail` = '.$mails_données['date_mail'].',
	74	`nb_mails_maxi` = '.$mails_données['nb_mails_maxi'].',
[4029]	75	`nb_mails_periode` = "'.$mails_données['nb_mails_periode'].'",
	76
[4020]	77	`nb_spams` = '.$mails_données['nb_spams'].',
	78	`date_spam` = '.$mails_données['date_spam'].',
	79	`nb_spams_maxi` = '.$mails_données['nb_spams_maxi'].',
[4029]	80	`nb_spams_periode` = "'.$mails_données['nb_spams_periode'].'",
[4020]	81
	82	`quarantaine` = "'.$mails_données['quarantaine'].'",
	83	`date_quarantaine` = '.$mails_données['date_quarantaine'].',
	84
[4029]	85	`quarantaine_periode` = "'.$mails_données['quarantaine_periode'].'",
	86
[4020]	87	`message` = "'.$mails_données['message'].'",
[4049]	88	`message_test` = "'.$mails_données['message_test'].'",
[4020]	89	`header_text` = "'.$mails_données['header_text'].'"
	90	WHERE `id` =1 LIMIT 1 ';
[4029]	91
	92
[4040]	93	if ( pwg_query($query)) return;
	94
	95	vérif_base() ;
	96	if ( pwg_query($query)) return;
[4029]	97
[4040]	98
	99	;
[4029]	100
[4040]	101
[4020]	102	}
	103	//=================================================================================
	104	function affiche_message()
	105	{
	106	global $template,$infos_message,$erreur_message ;;
	107
	108	if (isset($erreur_message))
	109	{
	110
	111	if ($erreur_message <> "")
	112	{
[4029]	113	$erreur_message=str_replace("\n",'<br />',$erreur_message) ;
[4020]	114	$template->assign('errors',$erreur_message);
	115	$erreur_message="";
	116	}
	117	}
	118
	119
	120	if (isset($infos_message))
	121	{
	122
	123	if ($infos_message <> "")
	124	{
[4029]	125	$infos_message=str_replace("\n",'<br />',$infos_message) ;
[4020]	126	$template->assign('infos',$infos_message);
	127	$infos_message="";
	128	}
	129	}
	130
	131
	132
	133	}
	134
	135
	136
	137	//=================================================================================
	138	function Get_Datas()
	139	{
[4029]	140	ob_start();
[4020]	141
[4029]	142	$data=Lire_datas();
	143
	144
	145	$m= ob_get_contents();
	146	ob_end_clean();
	147
	148	if (strlen($m)>0) {
	149	vérif_base() ;
	150	$data=Lire_datas();
	151	}
	152	return $data;
	153	}
	154
	155	function Lire_datas()
	156	{
	157	global $period_search,$period_match ;
[4059]	158	if (!isset($period_search)) {
	159	$period_search=array("W","D","H","M","S");
	160	array_push($period_search,l10n('Week'),l10n('Day'),l10n('Hour'),l10n('Minute'),l10n('Seconde'));
	161	array_push($period_search,l10n('Week').'s',l10n('Day').'s',l10n('Hour').'s',l10n('Minute').'s',l10n('Seconde').'s');
	162
	163
	164	$period_match=array(' week',' day',' hour',' minute',' seconde');
	165	array_push($period_match,'week','day','hour','minute','seconde');
	166	array_push($period_match,'week','day','hour','minute','seconde');
	167	}
	168
[4029]	169	$query = "
[4020]	170	SELECT *
	171	FROM ".MAIL_SUPERV_TABLE."
	172	;";
	173	$data = mysql_fetch_array(pwg_query($query));
[4029]	174	//====================================================================================
[4065]	175	$mails_periode = "+" . trim( str_replace($period_search, $period_match, $data['nb_mails_periode']));
	176
	177	$next_day = $data['date_mail'] + strtotime( $mails_periode,0);;
	178	$data['rest_mail']= $next_day - time() ;
	179
[4029]	180
	181	$spams_periode="+".str_replace($period_search, $period_match, $data['nb_spams_periode']);
[4065]	182	$next_day = $data['date_spam'] + strtotime( $spams_periode,0);
	183	$data['rest_spam']= $next_day -time() ;
[4029]	184
	185
	186	$quarantaine_periode="+".str_replace($period_search, $period_match, $data['quarantaine_periode']);
[4065]	187	$next_day = $data['date_quarantaine'] + strtotime( $quarantaine_periode,0);
	188
[4029]	189	if ($data['quarantaine']) {
	190	$data['reste'] = ( $next_day )-time() ;
	191	}else{
	192	$data['reste'] = 0;
	193	}
	194
	195	return $data;
[4020]	196	}
[4049]	197	//===============================================
[4020]	198
[4054]	199	function corrige_header($Carbonne,$headers,$args)
[4050]	200	{
[4054]	201	global $mails_options,$conf_mail,$mailto,$infos_message;
	202
	203	if (!empty($args[$Carbonne]))
[4050]	204	{
[4049]	205
[4050]	206	if ( count($args[$Carbonne]) > 0 )
	207	{
[4054]	208	if ($mails_options[1] == 'on') {
	209	$list_mail = str_replace(","," ,",get_strict_email_list(implode(',', $args[$Carbonne])))." \n" ;
	210	$headers = preg_replace('/.'.$Carbonne.'(.).\n/i', $Carbonne.': '.$list_mail, $headers);
	211	}
[4050]	212	}
	213	} else {
	214	// Raz Bcc, Cc dans headers
	215	$headers = preg_replace('/.'.$Carbonne.'(.).\n/i', "" , $headers);
	216	}
	217
	218
[4049]	219	return $headers;
[4020]	220
	221
	222	}
	223
	224	function int_to_heure($int)
	225	{
	226
	227
	228
[4065]	229	$delta=(72460*60) ;
	230	$week = (int) ($int/$delta);
[4020]	231
[4065]	232	$int= $int-($week*$delta) ;
[4020]	233
[4065]	234
	235	$delta=(246060) ;
	236	$day= (int) ($int/$delta);
	237	$int=$int-($day*$delta);
	238
	239	$delta=(60*60) ;
	240	$heures=(int) ($int/$delta);
	241	$int=$int-($heures*$delta);
	242
	243	$delta=(60) ;
	244	$minutes=(int) ($int/$delta);
	245	$int= $int - ($minutes*$delta);
	246
	247
[4020]	248	$secondes=(int) ($int);
	249
[4065]	250	$day = substr ('00'. $day,-2,2);
	251	$heures = substr ('00'. $heures,-2,2);
	252	$minutes = substr ('00'.$minutes,-2,2);
	253	$secondes = substr ('00'.$secondes,-2,2);
[4029]	254
[4065]	255
[4020]	256	if ($week > 0 )
	257	{
[4065]	258	return $week. " " .l10n('Week'). " " . $day . " " .l10n('Day'). "s ". $heures . " ". l10n('Hour'). "s " . $minutes. " " .l10n('minute'). "s ". $secondes." " .l10n('seconde')."s";
[4020]	259	}
[4029]	260	return $day . " " .l10n('Day'). "s ". $heures . " ". l10n('Hour'). "s " . $minutes. " " .l10n('Minute'). "s ". $secondes." " .l10n('Seconde')."s";
[4020]	261
	262	}
	263
	264	function memo_var($variables)
	265	{
	266	ob_start();
	267	echo '<pre>';
	268	print_r($variables);
	269	echo '</pre>';
	270	$m= ob_get_contents();
	271
	272	ob_end_clean();
	273	return $m;
	274
	275	}
	276
[4029]	277	function vérif_base()
	278	{
	279
[4054]	280	global $lang;
	281	load_language('plugin.lang', MAIL_SUPERV_PATH);
	282
[4029]	283	$q = "
	284	CREATE TABLE IF NOT EXISTS ".MAIL_SUPERV_TABLE." (
	285	`id` SMALLINT( 5 ) NOT NULL DEFAULT '0',
	286
	287	`nb_mails` INT NOT NULL DEFAULT '0',
	288	`date_mail` INT NOT NULL DEFAULT '0',
	289	`nb_mails_maxi` INT NOT NULL DEFAULT '2000',
	290	`nb_mails_periode` TEXT ,
	291
	292	`nb_spams` INT NOT NULL DEFAULT '0',
	293	`date_spam` INT NOT NULL DEFAULT '0',
	294
	295	`nb_spams_maxi` INT NOT NULL DEFAULT '10',
	296	`nb_spams_periode` TEXT ,
	297
[4040]	298	`quarantaine` TEXT ,
[4029]	299	`date_quarantaine` INT NOT NULL DEFAULT '0',
	300	`quarantaine_periode` TEXT ,
	301
	302
[4040]	303	`message` TEXT ,
	304	`message_test` TEXT ,
	305	`header_text` TEXT ,
[4029]	306	PRIMARY KEY (`id` )
	307	)
	308	;";
	309	pwg_query($q);
	310
	311	$nb = Get_colonnes_de(MAIL_SUPERV_TABLE);
	312	$table=$nb[MAIL_SUPERV_TABLE];
	313	//================================================================================
	314	if (!in_array( "nb_mails",$table)) {
	315	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails` INT NOT NULL default '0' ";
	316	pwg_query($query); }
	317	if (!in_array( "date_mail",$table)) {
	318	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_mail` INT NOT NULL default '0' ";
	319	pwg_query($query); }
	320	if (!in_array( "nb_mails_maxi",$table)) {
	321	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails_maxi` INT NOT NULL default '2000' ";
	322	pwg_query($query); }
	323	if (!in_array( "nb_mails_periode",$table)) {
	324	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_mails_periode` TEXT ";
	325	pwg_query($query); }
	326
	327
	328	if (!in_array( "nb_spams",$table)) {
	329	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams` INT NOT NULL default '0' ";
	330	pwg_query($query); }
	331	if (!in_array( "date_spam",$table)) {
	332	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_spam` INT NOT NULL default '0' ";
	333	pwg_query($query); }
	334
	335	if (!in_array( "nb_spams_maxi",$table)) {
	336	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams_maxi` INT NOT NULL default '10' ";
	337	pwg_query($query);
	338	if (!in_array( "nb_spams_periode",$table)) {
	339	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `nb_spams_periode` TEXT ";
	340	pwg_query($query); } }
	341
	342	if (!in_array( "quarantaine",$table)) {
[4040]	343	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `quarantaine` TEXT , ";
[4029]	344	pwg_query($query); }
	345
	346	if (!in_array( "date_quarantaine",$table)) {
	347	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `date_quarantaine` INT NOT NULL default '0' ";
	348	pwg_query($query);
	349	}
	350	if (!in_array( "quarantaine_periode",$table)) {
	351	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `quarantaine_periode` TEXT ";
	352	pwg_query($query); }
	353
	354	if (!in_array( "message",$table)) {
	355	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `message` TEXT ";
	356	pwg_query($query); }
	357
[4040]	358	if (!in_array( "message_test",$table)) {
	359	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `message_test` TEXT ";
	360	pwg_query($query); }
	361
[4029]	362	if (!in_array( "header_text",$table)) {
	363	$query = "ALTER TABLE `".MAIL_SUPERV_TABLE."` ADD `header_text` TEXT ";
	364	pwg_query($query); }
	365
[4051]	366	//-------------------------------------------------------
	367
[4029]	368	$query = "
[4051]	369	SELECT COUNT(`id`) as total
	370	FROM `".MAIL_SUPERV_TABLE."`
	371
	372	;";
[4029]	373	//==============================================================================
[4051]	374	list($count) = mysql_fetch_row(pwg_query($query));
	375
	376
[4029]	377	if ($count == 0)
	378	{
	379	$next_day = time() ;
	380	$date_quarantaine=time();
[4051]	381
	382
[4029]	383	$q = '
	384	INSERT INTO '.MAIL_SUPERV_TABLE.' (id,
	385	nb_mails,date_mail,nb_mails_maxi,nb_mails_periode,
	386	nb_spams,date_spam,nb_spams_maxi,nb_spams_periode,
	387	quarantaine, date_quarantaine,quarantaine_periode,
[4051]	388	message_test,
[4029]	389	message,header_text)
	390	VALUES (1,
	391	0,
	392	'.time().',
	393	2000,
[4051]	394	"1 '.l10n('Week').'",
[4029]	395
	396	0,
	397	'.time().',
	398	10,
[4051]	399	"2 '.l10n('Day').'",
[4029]	400
	401	false,
	402	'.time().',
[4051]	403	"2 '.l10n('Day').'",
[4029]	404
	405	"Init.",
[4049]	406	"'.l10n('supervisor').'",
[4029]	407	"'.l10n('hello').'"
	408	)
	409	;';
	410
	411
	412	pwg_query($q);
	413
	414	}
	415	}
[4054]	416
	417
[4029]	418	function Get_colonnes_de($table)
	419	{
	420	$columns_of = array();
	421	$query = 'DESC '.$table.';';
	422	$result = mysql_query($query);
	423	$columns_of[$table] = array();
	424	while ($row = mysql_fetch_row($result))
	425	{
	426	array_push($columns_of[$table], $row[0]);
	427	}
	428	return $columns_of;
	429	}
	430
[4040]	431	function get_liste($group_id)
[4020]	432	{
[4040]	433	global $conf ;
[4029]	434
[4040]	435	$query = '
	436	SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
	437	u.'.$conf['user_fields']['username'].' AS username,
	438	u.'.$conf['user_fields']['email'].' AS email,
	439	ui.status,
	440	ui.adviser,
	441	ui.enabled_high,
	442	ui.level
	443	FROM '.USERS_TABLE.' AS u
	444	INNER JOIN '.USER_INFOS_TABLE.' AS ui
	445	ON u.'.$conf['user_fields']['id'].' = ui.user_id
	446	LEFT JOIN '.USER_GROUP_TABLE.' AS ug
	447	ON u.'.$conf['user_fields']['id'].' = ug.user_id
	448	WHERE ug.group_id='.$group_id.' ';
[4029]	449
	450
[4040]	451
	452	$groups=array();
[4020]	453	$datas = pwg_query($query);
	454
	455
	456	if (!empty($datas))
	457	{
[4040]	458	while ($group = mysql_fetch_array($datas))
[4020]	459	{
[4040]	460
	461
	462	if (!empty($group['email']))
[4020]	463	{
[4040]	464	array_push($groups, format_email($group['username'], $group['email'] ));
[4020]	465	}
	466	}
[4040]	467	}
	468	return $groups ;
[4020]	469
	470	}
	471
	472	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: