/** * Delete by primary key, delete dependencies too * * @access public * @since unknown * @param int $id Item id * @return bool */ public function deleteByPrimaryKey($id) { $item = $this->findByPrimaryKey($id); if ( is_null($item) ) { return false; } if( $item['b_active'] == 1 && $item['b_enabled']==1 && $item['b_spam']==0 && !osc_isExpired($item['dt_expiration'])) { if($item['fk_i_user_id']!=null) { User::newInstance()->decreaseNumItems($item['fk_i_user_id']); } CategoryStats::newInstance()->decreaseNumItems($item['fk_i_category_id']); CountryStats::newInstance()->decreaseNumItems($item['fk_c_country_code']); RegionStats::newInstance()->decreaseNumItems($item['fk_i_region_id']); CityStats::newInstance()->decreaseNumItems($item['fk_i_city_id']); } $this->deleteResourcesFromHD($id); $this->dao->delete(DB_TABLE_PREFIX.'t_item_description', "fk_i_item_id = $id"); $this->dao->delete(DB_TABLE_PREFIX.'t_item_comment' , "fk_i_item_id = $id"); $this->dao->delete(DB_TABLE_PREFIX.'t_item_resource', "fk_i_item_id = $id"); $this->dao->delete(DB_TABLE_PREFIX.'t_item_location', "fk_i_item_id = $id"); $this->dao->delete(DB_TABLE_PREFIX.'t_item_stats' , "fk_i_item_id = $id"); $this->dao->delete(DB_TABLE_PREFIX.'t_item_meta' , "fk_i_item_id = $id"); osc_run_hook('delete_item', $id); $res = parent::deleteByPrimaryKey($id); return $res; }
/** * Delete by primary key, delete dependencies too * * @access public * @since unknown * @param int $id Item id * @return bool */ public function deleteByPrimaryKey($id) { osc_run_hook('delete_item', $id); $item = $this->findByPrimaryKey($id); if (is_null($item)) { return false; } if ($item['b_active'] == 1) { CategoryStats::newInstance()->decreaseNumItems($item['fk_i_category_id']); } $this->dao->delete(DB_TABLE_PREFIX . 't_item_description', "fk_i_item_id = {$id}"); $this->dao->delete(DB_TABLE_PREFIX . 't_item_comment', "fk_i_item_id = {$id}"); $this->dao->delete(DB_TABLE_PREFIX . 't_item_resource', "fk_i_item_id = {$id}"); $this->dao->delete(DB_TABLE_PREFIX . 't_item_location', "fk_i_item_id = {$id}"); $this->dao->delete(DB_TABLE_PREFIX . 't_item_stats', "fk_i_item_id = {$id}"); $this->dao->delete(DB_TABLE_PREFIX . 't_item_meta', "fk_i_item_id = {$id}"); $res = parent::deleteByPrimaryKey($id); return $res; }