cronjob.php

<?php
require('config.php');
require('class-http-request.php');
require('functions.php');

$result = $dbuser->query("SELECT * FROM BNoteBot_reminder WHERE timestamp < '" . time() . "'");
while($row = $result->fetch_assoc()) {
  $result = $dbuser->query("SELECT * FROM BNoteBot_memo WHERE id = '" . $row["memoid"] . "'");
  $row2 = $result->fetch_array(MYSQLI_ASSOC);
  $result = $dbuser->query("SELECT * FROM BNoteBot_user WHERE userID = '" . $row["userID"] . "'");
  $row3 = $result->fetch_array(MYSQLI_ASSOC);
  $timezone = $row3['timezone'];

  switch ($row3["lang"]) {
    case 'it':
    include($langdir . "message.it.php");
    if($timezone == FALSE) $timezone = "Europe/Rome";
    date_default_timezone_set($timezone);
    break;
    case 'en':
    if($timezone == FALSE) $timezone = "Europe/London";
    date_default_timezone_set($timezone);
    include($langdir . "message.en.php");
    break;
    case 'de':
    if($timezone == FALSE) $timezone = "Europe/Berlin";
    date_default_timezone_set($timezone);
    include($langdir . "message.en.php");
    include($langdir . "message.de.php");
    break;
    case 'pt':
    if($timezone == FALSE) $timezone = "America/Brasilia";
    date_default_timezone_set($timezone);
    include($langdir . "message.en.php");
    include($langdir . "message.pt.php");
    break;
    case 'ru':
    if($timezone == FALSE) $timezone = "Europe/Moscow";
    date_default_timezone_set($timezone);
    include($langdir . "message.en.php");
    include($langdir . "message.ru.php");
    break;
  }

  $menu[] = array(array(
    "text" => $lang['delete'],
    "callback_data" => "deleterem-" . $row["memoid"]));
  switch ($row2["type"]) {
    case 'text':
      sm($row["userID"], $lang['remindertext'] . date("H:i") . ".\n\n" . $row2["memo"], $menu, false, false, false, false, true);
      break;

    case 'voice':
      sv($row["userID"], $row2["file_id"], $lang['remindertext'] . date("H:i"), $menu, false, false, false, true);
      break;
  }
  $dbuser->query("DELETE FROM BNoteBot_reminder WHERE id = '" . $row["id"] . "'");
}
?>