public static function getFromBLID($blid, $offset, $limit) { $database = new DatabaseManager(); NotificationManager::verifyTable($database); $resource = $database->query("SELECT * FROM `user_notifications` WHERE\n\t\t\t`blid` = '" . $database->sanitize($blid) . "'\n\t\t\tORDER BY `date` DESC\n\t\t\tLIMIT " . $database->sanitize($offset) . ", " . $database->sanitize($limit)); if (!$resource) { throw new Exception("Database error: " . $database->error()); } $userNotes = []; while ($row = $resource->fetch_object()) { $userNotes[] = $row->id; } $resource->close(); return $userNotes; }