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;
}
