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