Files
Testing/cronjobs/birthdays.php

100 lines
4.1 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
ini_set('display_errors', 1);
// SET ERROR REPORTING
#error_reporting(E_ALL ^ E_WARNING ^ E_NOTICE);
#ini_set('display_errors', TRUE);
// SET INCLUDE PATH TO ROOT OF SE
include "../include/dbinclude.php";
include "../include/functions_email.php";
//mail("leprakhauns@gmail.com", "Birthday Emails", "Sent");
//mail("phil@b8world.com","Birthday Mail Sent", "Sent");
function user_displayname($user_info)
{
// SET DISPLAY NAME
if( !empty($user_info['user_displayname']) && trim($user_info['user_displayname']) )
return $user_info['user_displayname'];
elseif( !empty($user_info['user_fname']) && !empty($user_info['user_lname']) && trim($user_info['user_fname']) && trim($user_info['user_lname']) )
return $user_info['user_fname'].' '.$user_info['user_lname'];
elseif( !empty($user_info['user_fname']) && trim($user_info['user_fname']) )
return $user_info['user_fname'];
elseif( !empty($user_info['user_lname']) && trim($user_info['user_lname']) )
return $user_info['user_lname'];
elseif( !empty($user_info['user_username']) && trim($user_info['user_username']) )
return $user_info['user_username'];
else
return $user_info['user_id'];
}
/////////SETTINGS
$aSttng = array();
$sSql = " SELECT
*
FROM `birthdayEmails_options` ";
$rResult = $database->database_query($sSql);
while( ($aRow=$database->database_fetch_array($rResult)) )
$aSttng[ $aRow['var'] ] = stripslashes($aRow['value']);
if( $aSttng['userlevels'] == "")
$aSttng['userlevels'] = 0;
//////////////////////////////////////////////////////////////////////////
if( $aSttng['enabled'] == 1 )
{
$search = array('[displayname]');
$sCol = "profilevalue_".$database->database_real_escape_string($aSttng['bdayField']);
$aSttng['userlevels'] = $database->database_real_escape_string($aSttng['userlevels']);
$iTime = time();
$iMonth = date('n', $iTime);
$iDay = date('j', $iTime);
$sql=" SELECT
se_users.user_id,
se_users.user_displayname,
se_users.user_fname,
se_users.user_lname,
se_users.user_username,
se_users.user_email,
se_users.user_pdp_evc,
se_users.user_enabled,
se_profilevalues.{$sCol} AS `bDate`,
DAY(se_profilevalues.{$sCol}) AS `day`,
MONTH(se_profilevalues.{$sCol}) AS `month`
FROM `se_users`, se_usersettings,
`se_profilevalues`
WHERE
se_profilevalues.profilevalue_user_id = se_users.user_id
AND
se_users.user_id=se_usersettings.usersetting_user_id
AND
se_usersettings.usersetting_notify_birthday=1
AND
DAY(se_profilevalues.{$sCol}) = '{$iDay}' &&
MONTH(se_profilevalues.{$sCol}) = '{$iMonth}' &&
se_users.user_enabled='1' &&
se_users.user_level_id IN ({$aSttng['userlevels']}) ";
$result=$database->database_query($sql);
$aSttng['subject'] = stripslashes($aSttng['subject']);
$aSttng['message'] = stripslashes($aSttng['message']);
$aSttng['message'].="<div style=\"padding-top:20px;font-size:80%;\"><p>If you do not wish to receive further communications like this you can change your Notification Preferences by <a href='http://bateworld.com/user_account_privacy.php'>clicking here</a>. 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 <a href='http://bateworld.com/user_account_delete.php'>clicking here</a>.
</p><p>Visit our <a href='http://bateworld.com/privacypolicy.php?refval=[pdp_uid]'>Privacy Policy</a> and <a href='http://bateworld.com/help_tos.php'>Terms of Service</a> if you have any questions.</p></div>";
while( ($aRow = $database->database_fetch_array($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 "<br />";
// $aRow['user_email']="bateworld@gmail.com";
send_birthday_email($aRow['user_email'], $aSttng['fromAddress'], $aSttng['subject'], $message, $search, $replace);
// exit();
}}
}
}
?>