[TYPO3-german] small hotfix for ext:aux_newsmailer

Omar De-Giuli omario at me.com
Fri Aug 14 10:44:54 CEST 2009


hi folks


the extension aux_newsmailer had the problem, that it has sent  
newsletters also from deleted and/or hidden users in "fe_users"-table.  
i fixed this by a small clause in the sql-select-query. open the file  
aux_newsmailer/mod1/class_auxnewsmailer_core.php and go to the  
function "getUserInfo".


function getUserInfo($uid){

		$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                 '*',
                 'fe_users',
             	'uid='.$uid,
                 'deleted = 0 AND disable = 0', //put here this code!
                 '',
                 ''
             );

		$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
		$userinfo=array();
		$userinfo['name']=$row['name'];
		$userinfo['mail']=$row['email'];
		$userinfo['phone']=$row['telephone'];
		$userinfo['html']=$row['tx_auxnewsmailer_html'];
		return $userinfo;
	}




greez

omar


More information about the TYPO3-german mailing list