$database_host, 'dbUser'=>$database_username, 'dbPassword'=>$database_password, 'dbName'=>$database_name ); d2seCon( $aSeCon ); /////////SETTINGS $aSttng = array(); $sSql = " SELECT * FROM `birthdayEmails_options` "; $rResult = mysql_query($sSql); while( ($aRow=mysql_fetch_assoc($rResult)) ) $aSttng[ $aRow['var'] ] = stripslashes($aRow['value']); if( $aSttng['userlevels'] == "") $aSttng['userlevels'] = 0; ////////////////////////////////////////////////////////////////////////// if( $aSttng['enabled'] == 1 ) { $search = array('[displayname]'); $sCol = "profilevalue_".mysql_real_escape_string($aSttng['bdayField']); $aSttng['userlevels'] = mysql_real_escape_string($aSttng['userlevels']); $iTime = time(); $iMonth = date('n', $iTime); $iDay = date('j', $iTime); $sql=" SELECT `u`.`user_id`, `u`.`user_displayname`, `u`.`user_fname`, `u`.`user_lname`, `u`.`user_username`, `u`.`user_email`, `u`.`user_pdp_evc`, u.user_enabled, `v`.`{$sCol}` AS `bDate`, DAY(`v`.`{$sCol}`) AS `day`, MONTH(`v`.`{$sCol}`) AS `month` FROM `se_users` AS `u` INNER JOIN `se_profilevalues` AS `v` ON `v`.`profilevalue_user_id` = `u`.`user_id` WHERE DAY(`v`.`{$sCol}`) = '{$iDay}' && MONTH(`v`.`{$sCol}`) = '{$iMonth}' && `u`.`user_level_id` IN ({$aSttng['userlevels']}) "; $result=mysql_query($sql) or die(mysql_error()); $aSttng['subject'] = stripslashes($aSttng['subject']); $aSttng['message'] = stripslashes($aSttng['message']); $aSttng['message'].="

If you do not wish to receive further communications like this you can change your Notification Preferences by clicking here. Please note that it may take up to 10 days to process your request and you must be logged into your account. Alternatively, you can disable your BateWorld account by clicking here.

Visit our Privacy Policy and Terms of Service if you have any questions.

"; while( ($aRow = mysql_fetch_assoc($result)) ) { $aRow['name'] = user_displayname($aRow); $replace = array($aRow['name']); $message = str_replace('[pdp_uid]', $aRow['user_id'], $aSttng['message']); if($aRow['user_pdp_evc'] == 1 || $aRow['user_pdp_evc']==3){ if($aRow["user_enabled"]==1){ //echo "abc"; // echo $aRow['user_email']; // echo "
"; // $aRow['user_email']="bateworld@gmail.com"; send_birthday_email($aRow['user_email'], $aSttng['fromAddress'], $aSttng['subject'], $message, $search, $replace); // exit(); }} } } ?>