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!");
}
