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