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