public function update($data, $catalogID = 0) { if (!(isset($data['Title']) && strlen(trim($data['Title'])) > 0)) { throw new Exception(lang('data_empty', __CLASS__)); } $db = MySQL::getInstance(); $queryStr = ""; if ($imageName = File::upload('var/catalog/')) { $this->deleteFile($catalogID); // if (File::copy($imageName, 'thumb_' . $imageName, 'var/catalog/')) { // File::imageResize('thumb_' . $imageName, 'var/catalog/', 175, 175); // } if (File::copy($imageName, 'tmb/' . $imageName, 'var/catalog/')) { File::imageResize($imageName, 'var/catalog/tmb/', 100, 100); } File::imageResize($imageName, 'var/catalog/', 800, 600); $queryStr .= ', `Image` = ' . $db->escape($imageName); } $status = isset($this->aStatus[$data['Status']]) ? $data['Status'] : 'show'; $db->query('UPDATE `catalog` SET `Status` = ' . $db->escape($status) . ', `Title` = ' . $db->escape($data['Title'], 125) . ', `PropertyID` = ' . $db->escape((int) $data['PropertyID']) . ', `MetaTitle` = ' . $db->escape($data['MetaTitle'], 125) . ', `Content2` = ' . $db->escape($data['Content2']) . ', `Description` = ' . $db->escape($data['Description']) . ', `Code` = ' . $db->escape($data['Code']) . ', `Price` = ' . $db->escape((int) $data['Price']) . ', `Ed` = ' . $db->escape($data['Ed']) . ', `Content` = ' . $db->escape($data['Content']) . ' ' . $queryStr . ' WHERE ItemID = ' . $db->escape((int) $catalogID)); $oImage = new Catalog_Image(); if (($imageList = File::upload('var/catalog/gallery/', 'Gallery', false)) !== false) { $oImage->insert($imageList, $catalogID, $data['Gallery']); } // $oConsistency = new Catalog_Consistency(); // $oConsistency->insertItems($data['ConsistencyID'], $catalogID); return $catalogID; }