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; }
$q = $_GET; } switch ($q["Action"]) { case "Retrieve": if (isset($q["PlaceID"])) { $id = $q["PlaceID"]; if (!is_numeric($id)) { echo "{ \"Success\": false, \"ErrorMessage\": \"ID must be an integer\" }"; return; } $place = Place::GetByID($id); if ($place == null) { echo "{ \"Success\": false, \"ErrorMessage\": \"Place with ID " . $id . " does not exist\" }"; return; } $items = PlaceClippingRegion::GetByPlace($place); $count = count($items); echo "{ \"Success\": true, \"Items\": [ "; for ($i = 0; $i < $count; $i++) { echo $items[$i]->ToJSON(); if ($i < $count - 1) { echo ", "; } } echo " ] }"; } else { echo "{ \"Success\": false, \"ErrorMessage\": \"Retrieval of all 'PlaceClippingRegion' objects not supported\" }"; return; } return; }