/** * Delete a category, and all sub-categories, and all ads * * @param integer $id Category ID to delete * @return boolean True on success, False on failure */ public static function Delete($id) { global $_TABLES, $_CONF_ADVT; $id = (int) $id; // find all sub-categories of this one and delete them. $sql = "SELECT cat_id FROM {$_TABLES['ad_category']} \n WHERE papa_id={$id}"; $result = DB_query($sql); if ($result) { while ($row = DB_fetcharray($result)) { if (!adCategory::Delete($row['cat_id'])) { return false; } } } // now delete any ads associated with this category $sql = "SELECT ad_id FROM {$_TABLES['ad_ads']} \n WHERE cat_id={$id}"; $result = DB_query($sql); if ($result) { while ($row = DB_fetcharray($result)) { if (adDelete($row['ad_id'], true) != 0) { return false; } } } // Delete this category // First, see if there's an image to delete $img_name = DB_getItem($_TABLES['ad_category'], 'image', "cat_id={$id}"); if ($img_name != '' && file_exists($this->imgPath . $img_name)) { unlink($this->imgPath . $img_name); } DB_delete($_TABLES['ad_category'], 'cat_id', $id); // If we made it this far, must have worked ok return true; }
$content = ''; // Start by processing the specified action, if any switch ($mode) { case $LANG_ADMIN['delete']: if (empty($LANG_ADMIN['delete'])) { break; } if ($id > 0) { adDelete($id); } $page = 'manage'; break; case 'delete_ad': // DEPRECATE if ($id > 0) { adDelete($id); } $page = 'manage'; break; case 'update_account': // only valid users allowed if ($isAnon) { $content .= CLASSIFIEDS_errorMsg($LANG_ADVT['login_required'], 'alert', $LANG_ADVT['access_denied']); break; } USES_classifieds_class_userinfo(); $U = new adUserInfo(); $U->SetVars($_POST); $U->Save(); $page = $page == '' ? 'account' : $page; break;
$view = 'admin'; $actionval = 'ad'; } break; } break; case 'delete_ad': // Delete a specific ad adDelete($ad_id, true); $view = 'admin'; $actionval = 'ad'; break; case 'deletesubmission': // DEPRECATE // Delete a specific ad adDelete($ad_id, true, 'ad_submission'); $view = 'moderation'; break; case 'update_ad': // DEPRECATE // DEPRECATE case 'updatesubmission': $r = adSave('adminupdate'); $content .= $r[1]; $view = 'admin'; $actionval = 'ad'; break; case 'save': if ($type == 'submission') { // new submission $r = adSave('submission');