- // Check for holiday system
- $isHolidayActive = FALSE;
- if (isExtensionInstalledAndNewer('holiday', '0.1.3')) {
- // Check user's holiday status
- $result_holiday = sqlQueryEscaped("SELECT
- COUNT(`d`.`userid`) AS `cnt`
-FROM
- `{?_MYSQL_PREFIX?}_user_data` AS `d`
-LEFT JOIN
- `{?_MYSQL_PREFIX?}_user_holidays` AS `h`
-ON
- `d`.`userid`=`h`.`userid`
-WHERE
- `d`.`userid`=%s AND
- `d`.`receive_mails` > 0 AND
- `d`.`status`='CONFIRMED' AND
- `d`.`holiday_active`='Y' AND
- `h`.`holiday_start` < UNIX_TIMESTAMP() AND
- `h`.`holiday_end` > UNIX_TIMESTAMP()
-LIMIT 1",
- array(bigintval($userid)), __FILE__, __LINE__);
-
- // Fetch entry
- list($count) = sqlFetchRow($result_holiday);
-
- // Free memory
- sqlFreeResult($result_holiday);