\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` WHERE holiday_activated > 0 AND holiday_activated < UNIX_TIMESTAMP() AND holiday_active='N' 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 ($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($content['userid'])), __FILE__, __LINE__); if (SQL_NUMROWS($result_holiday) == 1) { // Okay, this user can be send away to holiday... $content = merge_array($content, SQL_FETCHARRAY($result_holiday)); // Prepare all data for the template $content = array( '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, $content['userid']); SEND_EMAIL($content['userid'], getMessage('HOLIDAY_MEMBER_ACTIVATED_SUBJ'), $msg); // Update account ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET holiday_active='Y' WHERE userid=%s 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 SQL_FREERESULT($result_main); // Stop currently activated holidays HOLIDAY_STOP_HOLIDAYS(); // ?>