public function GetByPlace($place) { if (get_class($place) != "PhoenixSNS\\Modules\\World\\Objects\\Place") { return array(); } global $MySQL; $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "PlaceClippingRegions WHERE region_PlaceID = " . $id; $result = $MySQL->query($query); $count = $result->num_rows; $retval = array(); for ($i = 0; $i < $count; $i++) { $values = $result->fetch_assoc(); $retval[] = PlaceClippingRegion::GetByAssoc($values); } return $retval; }
public function GetClippingRegions() { global $MySQL; $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "PlaceClippingRegions WHERE clippingregion_PlaceID = " . $this->ID; $result = $MySQL->query($query); $count = $result->num_rows; $retval = array(); for ($i = 0; $i < $count; $i++) { $values = $result->fetch_assoc(); $retval[] = PlaceClippingRegion::GetByAssoc($values); } return $retval; }