/** * trashGameworldTables() * * Drop all the gameworld tables in the database 'game'. * */ private function trashGameworldTables() { $query = "USE game;"; $this->db->setquery($query); $this->db->query(); $query = "DROP TABLE mapzone;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE city;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE region;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE tradegoodplatonic;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE tradegoodtoken;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE agent;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE estate;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE persona;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE useraccount;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE clan;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE tribe;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE depot;"; $this->db->setQuery($query); $this->db->query(); $query = "DROP TABLE news;"; $this->db->setQuery($query); $this->db->query(); }