public static function GetByAssoc($values) { global $MySQL; $item = new Item(); $item->ID = $values["item_ID"]; $item->Name = $values["item_Name"]; $item->Title = $values["item_Title"]; $item->Description = $values["item_Description"]; $item->Category = ItemCategory::GetByID($values["item_CategoryID"]); $item->Images = array(); $query = "SELECT * FROM " . System::$Configuration["Database.TablePrefix"] . "ItemImages WHERE itemimage_ItemID = " . $item->ID; $query .= " ORDER BY itemimage_ZIndex"; $result = $MySQL->query($query); $count = $result->num_rows; for ($i = 0; $i < $count; $i++) { $values1 = $result->fetch_assoc(); $image = new ItemImage(); $image->ID = $values1["itemimage_ID"]; $image->Slice = AvatarBaseSlice::GetByID($values1["itemimage_SliceID"]); $image->MimeType = $values1["itemimage_MimeType"]; $image->Left = $values1["itemimage_Left"]; $image->Top = $values1["itemimage_Top"]; $image->Width = $values1["itemimage_Width"]; $image->Height = $values1["itemimage_Height"]; $image->ZIndex = $values1["itemimage_ZIndex"]; $item->Images[] = $image; } return $item; }
public function GetSlices($max = null) { $pdo = DataSystem::GetPDO(); $query = "SELECT * FROM " . System::GetConfigurationValue("Database.TablePrefix") . "AvatarBaseSlices"; $query .= " WHERE slice_BaseID = :slice_BaseID AND slice_ParentSliceID = :slice_ParentSliceID"; if (is_numeric($max)) { $query .= " LIMIT " . $max; } $statement = $pdo->prepare($query); $result = $pdo->execute(array(":slice_BaseID" => $this->Base->ID, ":slice_ParentSliceID" => $this->ID)); $count = $statement->rowCount(); $retval = array(); for ($i = 0; $i < $count; $i++) { $values = $result->fetch(PDO::FETCH_ASSOC); $retval[] = AvatarBaseSlice::GetByAssoc($values); } return $retval; }