Example #1
0
 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;
 }