public function reload() { $texts = Emulator::getDatabase()->query("SELECT * FROM emulator_texts;"); foreach ($texts as $text) { $this->texts[$text->key] = $text->value; } }
private function loadPublicRooms() { $query = Emulator::getDatabase()->query("SELECT * FROM rooms WHERE is_public = ? OR is_staff_picked = ? ORDER BY id DESC;", array("1", "1")); foreach ($query as $public) { $this->activeRooms[(int) $public->id] = new Room($public); } }
private function loadTickets() { $query = Emulator::getDatabase()->query("SELECT S.username as sender_username, R.username AS reported_username, M.username as mod_username, support_tickets.* FROM support_tickets INNER JOIN users as S ON S.id = sender_id INNER JOIN users AS R ON R.id = reported_id INNER JOIN users AS M ON M.id = mod_id WHERE state != 0;"); foreach ($query as $ticket) { $this->tickets[(int) $ticket->id] = new ModToolIssue($ticket); } }
public function reload() { if (!Emulator::getConfig()->getBoolean("hotel.wordfilter.enabled")) { return; } unset($this->autoReportWords); unset($this->hideMessageWords); unset($this->words); $this->autoReportWords = array(); $this->hideMessageWords = array(); $this->words = array(); $query = Emulator::getDatabase()->query("SELECT * FROM wordfilter;"); foreach ($query as $word) { $word = new WordFilterWord($word); if ($word->isAutoReport()) { $this->autoReportWords[] = $word; continue; } if ($word->isHideMessage()) { $this->hideMessageWords[] = $word; continue; } $this->words[] = $word; } }
public function loadFromDatabase() { $settings = Emulator::getDatabase()->query("SELECT * FROM emulator_settings;"); foreach ($settings as $setting) { $this->values[$setting->key] = $setting->value; } }
public function loadSoundTracks() { unset($this->soundTracks); $query = Emulator::getDatabase()->query("SELECT * FROM soundtracks;"); foreach ($query as $soundtrack) { $this->soundTracks[$soundtrack->code] = new SoundTrack($soundtrack); } }
public function reload() { unset($this->newsWidgets); $this->newsWidgets = array(); $query = Emulator::getDatabase()->query("SELECT * FROM hotelview_news ORDER BY id DESC LIMIT 10;"); foreach ($query as $news) { $this->newsWidgets[] = new NewsWidget($news); } }
private function loadEnables() { unset($this->enables); $this->enables = array(); $query = Emulator::getDatabase()->query("SELECT * FROM special_enables;"); foreach ($query as $enable) { $this->enables[(int) $enable->effect_id] = (int) $enable->min_rank; } }
public function reload() { unset($this->winners); $this->winners = array(); $query = Emulator::getDatabase()->query("SELECT users.look, users.username, users.id, users_settings.hof_points FROM users_settings INNER JOIN users ON users_settings.user_id = users.id WHERE hof_points > 0 ORDER BY hof_points DESC, users.id ASC LIMIT 10;"); foreach ($query as $winner) { $winner = new HallOfFameWinner($winner); $this->winners[$winner->getId()] = $winner; } }
public function loadGuildParts() { unset($this->guildParts); foreach (GuildPartType::values() as $t) { $this->guildParts[$t] = array(); } $query = Emulator::getDatabase()->query("SELECT * FROM guilds_elements;"); foreach ($query as $elem) { $this->guildParts[strtoupper($elem->type)][$elem->id] = new GuildPart($elem); } }
private function loadPetCommands() { $commandsList = array(); $query = Emulator::getDatabase()->query("SELECT * FROM pet_commands_data;"); foreach ($query as $command) { $commandsList[(int) $command->command_id] = new PetCommand($command); } $query = Emulator::getDatabase()->query("SELECT * FROM pet_commands ORDER BY pet_id ASC;"); foreach ($query as $command) { $this->petData[(int) $command->pet_id]->petCommands[] = $commandsList[(int) $command->command_id]; } }
private function loadGiftWrappers() { unset($this->giftWrappers); $this->giftWrappers = array(); $query = Emulator::getDatabase()->query("SELECT * FROM gift_wrappers WHERE type = ? ORDER BY sprite_id DESC;", array("wrapper")); foreach ($query as $gift) { $this->giftWrappers[(int) $gift->sprite_id] = (int) $gift->item_id; } unset($this->giftFurnis); $this->giftFurnis = array(); $query = Emulator::getDatabase()->query("SELECT * FROM gift_wrappers WHERE type = ? ORDER BY sprite_id DESC;", array("gift")); foreach ($query as $gift) { $this->giftFurnis[(int) $gift->sprite_id] = (int) $gift->item_id; } }
public function databaseCleanup() { Emulator::getDatabase()->exec("UPDATE users SET online = ?;", array("0")); Emulator::getLogging()->logStart("Database -> Cleaned!"); }