X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=0.2.1%2Finc%2Fmails%2Fbeg_mails.php;h=2391b284d9ad4d8f627b5d58cc07384b761e655d;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=c4fb2fe756ee8d0605b4d325845ddc6e7faa682a;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/mails/beg_mails.php b/0.2.1/inc/mails/beg_mails.php index c4fb2fe756..2391b284d9 100644 --- a/0.2.1/inc/mails/beg_mails.php +++ b/0.2.1/inc/mails/beg_mails.php @@ -1,170 +1,170 @@ - 0 AND beg_ral_en_notify < beg_ral_di_notify)"; - $MODE = "en"; - } - else - { - // Do not notify! - $SQL = ""; - } - break; - -case "N": // Begging rallye is deactivated - if ($CONFIG['beg_ral_di_notify'] == "Y") - { - // Okay, let's check for member accounts - $SQL .= " > 0 AND beg_ral_di_notify < beg_ral_en_notify"; - $MODE = "di"; - } - else - { - // Do not notify! - $SQL = ""; - } - break; -} - -if (!empty($SQL)) -{ - // The SQL command needs to be finisched here (only confirmed accounts!) - $SQL .= ") AND status='CONFIRMED' ORDER BY last_online ASC"; - - // Prepare data for the template - define('__BEG_MIN_POINTS' , TRANSLATE_COMMA($CONFIG['beg_points'])); - define('__BEG_MAX_POINTS' , TRANSLATE_COMMA($CONFIG['beg_points_max'])); - define('__BEG_MAX_WINNERS', round($CONFIG['beg_ranks'])); - if ($CONFIG['beg_ip_timeout'] == 0) - { - // No IP locking setuped! - define('__BEG_IP_LOCKER', BEG_NO_LIMITATION); - } - else - { - // Create timemark - define('__BEG_IP_LOCKER', CREATE_FANCY_TIME($CONFIG['beg_ip_timeout'])); - } - - // Check for accounts to be notified - $result_main = SQL_QUERY($SQL, __FILE__, __LINE__); - if (SQL_NUMROWS($result_main) > 0) - { - // Normal notification mails or bonus mails? - $MAIL_MODE = (($CONFIG['beg_notify_bonus'] > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus"))); - - // Generate subject line - $eval = "\$SUBJECT = BEG_RALLYE_".strtoupper($MODE)."_NOTIFY;"; - eval($eval); - - // Load message body for bonus mails - $MSG = LOAD_EMAIL_TEMPLATE("beg_en_notify_body", "", "{PER}uid{PER}"); - $RECEIVER = ""; $UIDs = array(); - - // Okay lets notify all users! - while(list($uid, $email) = SQL_FETCHROW($result_main)) - { - // Update account - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data -SET beg_ral_notify='%s', beg_ral_%s_notify='%s' WHERE userid=%d LIMIT 1", - array(time(), $MODE, time(), $uid), __FILE__, __LINE__); - - // Load email template and send it to the user! - if ($MAIL_MODE) - { - // Add userid to queue - $UIDs[] = $uid; - } - else - { - // Send normal notification mail to the members - $MSG = LOAD_EMAIL_TEMPLATE("beg_".$MODE."_notify", "", $uid); - SEND_EMAIL($email, $SUBJECT, $MSG); - } - } - - // Shall I send out bonus mails? - if ($MAIL_MODE) - { - // Okay, make array to string - $RECEIVER = implode(";", $UIDs); - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus -(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, is_notify) -VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', 'Y')", - array( - $SUBJECT, - $MSG, - $RECEIVER, - $CONFIG['beg_notify_bonus'], - $CONFIG['beg_notify_wait'], - URL."/modules.php?module=index&what=login", - 0, - SELECTION_COUNT(explode(";", $RECEIVER)), - SQL_NUMROWS($result_main), -), __FILE__, __LINE__); - } - } - - // Free memory - SQL_FREERESULT($result_main); -} - -// -?> + 0 AND beg_ral_en_notify < beg_ral_di_notify)"; + $MODE = "en"; + } + else + { + // Do not notify! + $SQL = ""; + } + break; + +case "N": // Begging rallye is deactivated + if ($CONFIG['beg_ral_di_notify'] == "Y") + { + // Okay, let's check for member accounts + $SQL .= " > 0 AND beg_ral_di_notify < beg_ral_en_notify"; + $MODE = "di"; + } + else + { + // Do not notify! + $SQL = ""; + } + break; +} + +if (!empty($SQL)) +{ + // The SQL command needs to be finisched here (only confirmed accounts!) + $SQL .= ") AND status='CONFIRMED' ORDER BY last_online ASC"; + + // Prepare data for the template + define('__BEG_MIN_POINTS' , TRANSLATE_COMMA($CONFIG['beg_points'])); + define('__BEG_MAX_POINTS' , TRANSLATE_COMMA($CONFIG['beg_points_max'])); + define('__BEG_MAX_WINNERS', round($CONFIG['beg_ranks'])); + if ($CONFIG['beg_ip_timeout'] == 0) + { + // No IP locking setuped! + define('__BEG_IP_LOCKER', BEG_NO_LIMITATION); + } + else + { + // Create timemark + define('__BEG_IP_LOCKER', CREATE_FANCY_TIME($CONFIG['beg_ip_timeout'])); + } + + // Check for accounts to be notified + $result_main = SQL_QUERY($SQL, __FILE__, __LINE__); + if (SQL_NUMROWS($result_main) > 0) + { + // Normal notification mails or bonus mails? + $MAIL_MODE = (($CONFIG['beg_notify_bonus'] > 0) && ($MODE == "en") && (EXT_IS_ACTIVE("bonus"))); + + // Generate subject line + $eval = "\$SUBJECT = BEG_RALLYE_".strtoupper($MODE)."_NOTIFY;"; + eval($eval); + + // Load message body for bonus mails + $MSG = LOAD_EMAIL_TEMPLATE("beg_en_notify_body", "", "{PER}uid{PER}"); + $RECEIVER = ""; $UIDs = array(); + + // Okay lets notify all users! + while(list($uid, $email) = SQL_FETCHROW($result_main)) + { + // Update account + $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data +SET beg_ral_notify='%s', beg_ral_%s_notify='%s' WHERE userid=%d LIMIT 1", + array(time(), $MODE, time(), $uid), __FILE__, __LINE__); + + // Load email template and send it to the user! + if ($MAIL_MODE) + { + // Add userid to queue + $UIDs[] = $uid; + } + else + { + // Send normal notification mail to the members + $MSG = LOAD_EMAIL_TEMPLATE("beg_".$MODE."_notify", "", $uid); + SEND_EMAIL($email, $SUBJECT, $MSG); + } + } + + // Shall I send out bonus mails? + if ($MAIL_MODE) + { + // Okay, make array to string + $RECEIVER = implode(";", $UIDs); + $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus +(subject, text, receivers, points, time, data_type, timestamp, url, cat_id, target_send, mails_sent, is_notify) +VALUES ('%s', '%s', '%s', '%s', '%s', 'NEW', UNIX_TIMESTAMP(), '%s', '%s', '%s', '%s', 'Y')", + array( + $SUBJECT, + $MSG, + $RECEIVER, + $CONFIG['beg_notify_bonus'], + $CONFIG['beg_notify_wait'], + URL."/modules.php?module=index&what=login", + 0, + SELECTION_COUNT(explode(";", $RECEIVER)), + SQL_NUMROWS($result_main), +), __FILE__, __LINE__); + } + } + + // Free memory + SQL_FREERESULT($result_main); +} + +// +?>