//* DEBUG: */ echo basename(__FILE__)."<br />\n";
// Check for holidays we need to enable and send email to user
-$result_main = SQL_QUERY("SELECT userid, holiday_activated FROM `{!_MYSQL_PREFIX!}_user_data`
+$result_main = SQL_QUERY("SELECT userid, holiday_activated
+FROM `{!_MYSQL_PREFIX!}_user_data`
WHERE holiday_activated > 0 AND holiday_activated < UNIX_TIMESTAMP() AND holiday_active='N'
-ORDER BY holiday_activated", __FILE__, __LINE__);
+ORDER BY holiday_activated",
+ __FILE__, __LINE__);
+
+// Entries found?
if (SQL_NUMROWS($result_main) > 0) {
+ // Init SQLs
+ INIT_SQLS();
+
// We have found at least one useraccount so let's check it...
- while (list($uid, $activated) = SQL_FETCHROW($result_main)) {
+ while ($content = SQL_FETCHARRAY($result_main)) {
// Check if his holiday can be activated
- $result_holiday = SQL_QUERY_ESC("SELECT holiday_start, holiday_end FROM `{!_MYSQL_PREFIX!}_user_holidays`
-WHERE userid=%s AND holiday_start <= UNIX_TIMESTAMP() AND holiday_end > UNIX_TIMESTAMP() LIMIT 1",
- array(bigintval($uid)), __FILE__, __LINE__);
- if (SQL_NUMROWS($result_holiday) == 1)
- {
+ $result_holiday = SQL_QUERY_ESC("SELECT holiday_start, holiday_end
+FROM `{!_MYSQL_PREFIX!}_user_holidays`
+WHERE userid=%s AND holiday_start <= UNIX_TIMESTAMP() AND holiday_end > UNIX_TIMESTAMP()
+LIMIT 1",
+ array(bigintval($content['userid'])), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result_holiday) == 1) {
// Okay, this user can be send away to holiday...
- list($start, $end) = SQL_FETCHROW($result_holiday);
+ $content = merge_array($content, SQL_FETCHARRAY($result_holiday));
// Prepare all data for the template
$content = array(
- 'activated' => MAKE_DATETIME($activated, "1"),
- 'start' => MAKE_DATETIME($start , "1"),
- 'end' => MAKE_DATETIME($end , "1")
+ 'activated' => MAKE_DATETIME($content['holiday_activated'], "1"),
+ 'start' => MAKE_DATETIME($content['holiday_start'] , "1"),
+ 'end' => MAKE_DATETIME($content['holiday_end'] , "1")
);
// Send email to user
- $msg = LOAD_EMAIL_TEMPLATE("member_holiday_activated", $content, $uid);
- SEND_EMAIL($uid, HOLIDAY_MEMBER_ACTIVATED, $msg);
+ $msg = LOAD_EMAIL_TEMPLATE("member_holiday_activated", $content, $content['userid']);
+ SEND_EMAIL($content['userid'], getMessage('HOLIDAY_MEMBER_ACTIVATED_SUBJ'), $msg);
// Update account
- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET holiday_active='Y'
+ ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data`
+SET holiday_active='Y'
WHERE userid=%s
-LIMIT 1", array(bigintval($uid)), __FILE__, __LINE__);
- }
+LIMIT 1",
+ array(bigintval($content['userid'])), __FILE__, __LINE__, false));
+ } // END - if
// Free memory
SQL_FREERESULT($result_holiday);
- }
+ } // END - while
+
+ // Run all SQLs
+ runFilterChain('run_sqls');
}
// Free memory