public static function get_all_moves_after_given_date($game_id, $timestamp)
{
if (safe_input::is_number($game_id) && safe_input::is_number_floating($timestamp)) {
$query = "SELECT * FROM `move` WHERE `gameID` = '{$game_id}' AND `date` > '{$timestamp}'";
$moves;
$db = new database();
$db->query($query);
if ($db->number_of_rows() < 1) {
return null;
} else {
while ($move = $db->fetch_row()) {
$moves[] = $move;
}
return $moves;
}
} else {
return null;
//invalid input
}
}
public static function get_all_messages_after_given_date($game_id, $date)
{
if (safe_input::is_number($game_id) && safe_input::is_number_floating($date)) {
$query = "SELECT * FROM `message` where `gameID` = '{$game_id}' AND `date` > '{$date}' ";
$db = new database();
$res = $db->query($query);
if ($db->number_of_rows() < 1) {
return null;
//no results to return
} else {
$messages;
while ($message = $db->fetch_row()) {
$messages[] = $message;
}
return $messages;
}
} else {
return null;
//invalid input
}
}
