function PaidSpecsEndingReminder() { global $DB; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/smail.php"; require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/op_codes.php"; $mail = new smail(); $ops = new op_codes(); $price = $ops->getCodes(self::OP_PAID_SPEC); if (!$price) { return 0; } $price = $price[self::OP_PAID_SPEC]; $sql = "SELECT user_id, COUNT(*) AS cnt FROM spec_paid_choise\n INNER JOIN users u ON u.uid = user_id AND u.is_banned = '0'\n WHERE paid_to > NOW()+'1 day' AND paid_to <= NOW()+'1 day 1 hour' AND is_autopaid = TRUE\n GROUP BY user_id"; $res = $DB->query($sql); while ($row = pg_fetch_array($res)) { $mail->PaidSpecsEnding($row['user_id'], $row['cnt'] * $price['sum']); } return 0; }