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; }