public function addZone(Zone $zone)
{
$position = $zone->getPosition();
$name = $this->database->escape_string($zone->getName());
$player = $this->database->escape_string($zone->getOwner());
$level = $zone->getLevelName();
$minx = $position[0];
$miny = $position[1];
$minz = $position[2];
$maxx = $position[3];
$maxy = $position[4];
$maxz = $position[5];
return $this->database->query("INSERT INTO izone_zones (name, player_owner, level_name, minX, minY, minZ, maxX, maxY, maxZ, pvpAvailable) VALUES ({$name}, {$player}, {$level}, {$minx}, {$miny}, {$minz}, {$maxx}, {$maxy}, {$maxz}, {$zone->pvpAvailable})");
}
public function addZone(Zone $zone)
{
$position = $zone->getPosition();
$prepare = $this->database->prepare("INSERT INTO Zones (name, player_owner, level_name, minX, minY, minZ, maxX, maxY, maxZ, pvpAvailable) VALUES (:name, :player, :level, :minx, :miny, :minz, :maxx, :maxy, :maxz, :pvp)");
$prepare->bindValue(":name", \SQLite3::escapeString($zone->getName()), SQLITE3_TEXT);
$prepare->bindValue(":player", \SQLite3::escapeString($zone->getOwner()), SQLITE3_TEXT);
$prepare->bindValue(":level", $zone->getLevelName(), SQLITE3_TEXT);
$prepare->bindValue(":minx", $position[0], SQLITE3_INTEGER);
$prepare->bindValue(":miny", $position[1], SQLITE3_INTEGER);
$prepare->bindValue(":minz", $position[2], SQLITE3_INTEGER);
$prepare->bindValue(":maxx", $position[3], SQLITE3_INTEGER);
$prepare->bindValue(":maxy", $position[4], SQLITE3_INTEGER);
$prepare->bindValue(":maxz", $position[5], SQLITE3_INTEGER);
$prepare->bindValue(":pvp", $zone->pvpAvailable);
$prepare->execute();
}
public function addZone(Zone $zone)
{
$this->zonesConfig->set($zone->getName(), [$zone->getName(), $zone->getOwner(), $zone->getLevelName(), $zone->getPosition(), $zone->pvpAvailable]);
}
