/**
* delete a category from the database
*
* @param object $category reference to the category to delete
* @param bool $force
*
* @return bool FALSE if failed.
*/
public function delete(&$category, $force = false)
{
// Deleting this category ITEMs
$criteria = new Criteria('categoryid', $category->categoryid());
$this->publisher->getHandler('item')->deleteAll($criteria);
unset($criteria);
// Deleting the sub categories
$subcats =& $this->getCategories(0, 0, $category->categoryid());
foreach ($subcats as $subcat) {
$this->delete($subcat);
}
if (!parent::delete($category, $force)) {
$category->setErrors('An error while deleting.');
return false;
}
$moduleId = $this->publisher->getModule()->getVar('mid');
xoops_groupperm_deletebymoditem($moduleId, 'category_read', $category->categoryid());
xoops_groupperm_deletebymoditem($moduleId, 'item_submit', $category->categoryid());
xoops_groupperm_deletebymoditem($moduleId, 'category_moderation', $category->categoryid());
return true;
}
/**
* delete a category from the database
*
* @param object $category reference to the category to delete
* @param bool $force
* @return bool FALSE if failed.
*/
function delete(&$category, $force = false)
{
if (strtolower(get_class($category)) != 'sfcategory') {
return false;
}
// Deleting the FAQs
$faq_handler = new sfFaqHandler($this->db);
if (!$faq_handler->deleteAll(new Criteria('categoryid', $category->categoryid()))) {
return false;
}
// Deleteing the sub categories
$subcats =& $this->getCategories(0, 0, $category->categoryid());
foreach ($subcats as $subcat) {
$this->delete($subcat);
}
$sql = sprintf("DELETE FROM %s WHERE categoryid = %u", $this->db->prefix("smartfaq_categories"), $category->getVar('categoryid'));
$smartModule =& sf_getModuleInfo();
$module_id = $smartModule->getVar('mid');
if (false != $force) {
$result = $this->db->queryF($sql);
} else {
$result = $this->db->query($sql);
}
xoops_groupperm_deletebymoditem($module_id, "category_read", $category->categoryid());
//xoops_groupperm_deletebymoditem ($module_id, "category_admin", $categoryObj->categoryid());
if (!$result) {
return false;
}
return true;
}
/**
* delete an item from the database
*
* @param object $item reference to the ITEM to delete
* @param bool $force
* @return bool FALSE if failed.
*/
function delete(&$item, $force = false)
{
$hModule =& xoops_gethandler('module');
$smartModule =& $hModule->getByDirname('smartsection');
$module_id = $smartModule->getVar('mid');
if (strtolower(get_class($item)) != 'smartsectionitem') {
return false;
}
// Deleting the files
global $smartsection_file_handler;
if (!$smartsection_file_handler->deleteItemFiles($item)) {
$item->setErrors('An error while deleting a file.');
}
$sql = sprintf("DELETE FROM %s WHERE itemid = %u", $this->db->prefix("smartsection_items"), $item->itemid());
if (false != $force) {
$result = $this->db->queryF($sql);
} else {
$result = $this->db->query($sql);
}
if (!$result) {
$item->setErrors('An error while deleting.');
return false;
}
xoops_groupperm_deletebymoditem($module_id, "item_read", $item->itemid());
return true;
}
function delTopic()
{
if (!isset($_REQUEST['topic_id']) || $_REQUEST['topic_id'] == 0) {
redirect_header('index.php?op=topicsmanager', 3, _AMS_AM_NOTOPICSELECTED);
}
global $xoopsDB, $xoopsModule;
if (!isset($_POST['ok'])) {
echo "<h4>" . _AMS_AM_CONFIG . "</h4>";
$xt = new XoopsTopic($xoopsDB->prefix("ams_topics"), intval($_GET['topic_id']));
xoops_confirm(array('op' => 'delTopic', 'topic_id' => intval($_GET['topic_id']), 'ok' => 1), 'index.php', _AMS_AM_WAYSYWTDTTAL . '<br />' . $xt->topic_title('S'));
} else {
$xt = new XoopsTopic($xoopsDB->prefix("ams_topics"), intval($_POST['topic_id']));
// get all subtopics under the specified topic
$topic_arr = $xt->getAllChildTopics();
array_push($topic_arr, $xt);
foreach ($topic_arr as $eachtopic) {
// get all stories in each topic
$story_arr = AmsStory::getByTopic($eachtopic->topic_id());
foreach ($story_arr as $eachstory) {
if (false != $eachstory->delete()) {
xoops_comment_delete($xoopsModule->getVar('mid'), $eachstory->storyid());
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'story', $eachstory->storyid());
}
}
// all stories for each topic is deleted, now delete the topic data
$eachtopic->delete();
// Delete also the notifications and permissions
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'category', $eachtopic->topic_id);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'ams_approve', $eachtopic->topic_id);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'ams_submit', $eachtopic->topic_id);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'ams_view', $eachtopic->topic_id);
}
redirect_header('index.php?op=topicsmanager', 1, _AMS_AM_DBUPDATED);
exit;
}
}
function delTopic()
{
global $xoopsDB, $xoopsModule;
if (!isset($_POST['ok'])) {
xoops_cp_header();
echo '<h4>' . _AM_CONFIG . '</h4>';
$xt = new XoopsTopic($xoopsDB->prefix('topics'), intval($_GET['topic_id']));
xoops_confirm(array('op' => 'delTopic', 'topic_id' => intval($_GET['topic_id']), 'ok' => 1), 'index.php', _AM_WAYSYWTDTTAL . '<br />' . $xt->topic_title('S'));
} else {
xoops_cp_header();
$xt = new XoopsTopic($xoopsDB->prefix('topics'), intval($_POST['topic_id']));
if (isset($_SESSION['items_count'])) {
$_SESSION['items_count'] = -1;
}
// get all subtopics under the specified topic
$topic_arr = $xt->getAllChildTopics();
array_push($topic_arr, $xt);
foreach ($topic_arr as $eachtopic) {
// get all stories in each topic
$story_arr = NewsStory::getByTopic($eachtopic->topic_id());
foreach ($story_arr as $eachstory) {
if (false != $eachstory->delete()) {
xoops_comment_delete($xoopsModule->getVar('mid'), $eachstory->storyid());
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'story', $eachstory->storyid());
}
}
// all stories for each topic is deleted, now delete the topic data
$eachtopic->delete();
// Delete also the notifications and permissions
xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'category', $eachtopic->topic_id);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'news_approve', $eachtopic->topic_id);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'news_submit', $eachtopic->topic_id);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'news_view', $eachtopic->topic_id);
}
news_updateCache();
redirect_header('index.php?op=topicsmanager', 1, _AM_DBUPDATED);
exit;
}
}
$sform->addElement($create_tray);
$sform->display();
unset($hidden);
}
switch ($op) {
case "mod":
xoops_cp_header();
adminmenu(_AM_CHANADMIN, $extra = '');
$CID = isset($HTTP_POST_VARS['CID']) ? $HTTP_POST_VARS['CID'] : $CID;
edittopic($CID);
break;
case "del":
global $xoopsUser, $xoopsUser, $xoopsConfig, $xoopsDB;
if ($confirm) {
$xoopsDB->query("DELETE FROM " . $xoopsDB->prefix("wfschannel") . " WHERE CID = {$CID}");
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), '', $CID);
xoops_comment_delete($xoopsModule->getVar('mid'), $CID);
redirect_header("index.php", 1, sprintf(_AM_CHANISDELETED, $pagetitle));
exit;
} else {
$CID = isset($HTTP_POST_VARS['CID']) ? $HTTP_POST_VARS['CID'] : $CID;
$result = $xoopsDB->query("SELECT CID, pagetitle FROM " . $xoopsDB->prefix("wfschannel") . " ");
if ($xoopsDB->getRowsNum($result) == 1) {
redirect_header("index.php", 3, _AM_CANNOTDELETELASTONE);
exit;
}
$result = $xoopsDB->query("SELECT CID, pagetitle FROM " . $xoopsDB->prefix("wfschannel") . " WHERE CID = {$CID}");
list($CID, $pagetitle) = $xoopsDB->fetchrow($result);
xoops_cp_header();
echo "<table width='100%' border='0' cellpadding = '2' cellspacing='1' class = 'confirmMsg'><tr><td class='confirmMsg'>";
echo "<div class='confirmMsg'>";
/**
* delete an FAQ from the database
*
* @param object $faq reference to the FAQ to delete
* @param bool $force
* @return bool FALSE if failed.
*/
function delete(&$faq, $force = false)
{
$smartModule =& sf_getModuleInfo();
$module_id = $smartModule->getVar('mid');
if (strtolower(get_class($faq)) != 'sffaq') {
return false;
}
// Deleting the answers
$answer_handler = new sfAnswerHandler($this->db);
if (!$answer_handler->deleteFaqAnswers($faq)) {
// error msg...
echo "error while deleteing an answer";
}
$sql = sprintf("DELETE FROM %s WHERE faqid = %u", $this->db->prefix("smartfaq_faq"), $faq->getVar('faqid'));
if (false != $force) {
$result = $this->db->queryF($sql);
} else {
$result = $this->db->query($sql);
}
if (!$result) {
return false;
}
xoops_groupperm_deletebymoditem($module_id, "item_read", $faq->faqid());
return true;
}
/**
* delete a category from the database
*
* @param object $category reference to the category to delete
* @param bool $force
* @return bool FALSE if failed.
*/
function delete(&$category, $force = false)
{
if (strtolower(get_class($category)) != 'smartsectioncategory') {
return false;
}
// Deleting the ITEMs
global $smartsection_item_handler;
$items =& $smartsection_item_handler->getItems(0, 0, -1, $category->categoryid());
if ($items) {
foreach ($items as $item) {
$smartsection_item_handler->delete($item);
}
}
// Deleteing the sub categories
$subcats =& $this->getCategories(0, 0, $category->categoryid());
foreach ($subcats as $subcat) {
$this->delete($subcat);
}
$sql = sprintf("DELETE FROM %s WHERE categoryid = %u", $this->db->prefix("smartsection_categories"), $category->getVar('categoryid'));
$hModule =& xoops_gethandler('module');
$smartModule =& $hModule->getByDirname('smartsection');
$module_id = $smartModule->getVar('mid');
if (false != $force) {
$result = $this->db->queryF($sql);
} else {
$result = $this->db->query($sql);
}
xoops_groupperm_deletebymoditem($module_id, "category_read", $category->categoryid());
xoops_groupperm_deletebymoditem($module_id, "item_submit", $category->categoryid());
//xoops_groupperm_deletebymoditem ($module_id, "category_admin", $categoryObj->categoryid());
if (!$result) {
return false;
}
return true;
}
function deletegenre($del = 0)
{
global $xoopsDB;
if (isset($_POST['del']) && $_POST['del'] == 1) {
$sql1 = "\r\n\t\tDELETE \r\n\t\tFROM " . $xoopsDB->prefix('debaser_genre') . " \r\n\t\tWHERE genretitle=" . $xoopsDB->quoteString($_POST['genrecat']) . " ";
$sql2 = "\r\n\t\tDELETE \r\n\t\tFROM " . $xoopsDB->prefix('debaser_files') . " \r\n\t\tWHERE genre=" . $xoopsDB->quoteString($_POST['genrecat']) . " ";
$sql3 = "SELECT filename \r\n\t\tFROM " . $xoopsDB->prefix('debaser_files') . " \r\n\t\tWHERE genreid=" . $xoopsDB->quoteString($_POST['genrecat']) . " ";
$result3 = $xoopsDB->query($sql3);
if ($xoopsDB->query($sql1) && $xoopsDB->query($sql2)) {
while (list($filename) = $xoopsDB->fetchRow($result3)) {
@unlink(XOOPS_ROOT_PATH . '/modules/debaser/upload/' . $filename);
xoops_groupperm_deletebymoditem($xoopsModule->getVar('mid'), 'WF3DownCatPerm', $genreid);
}
redirect_header('index.php', 2, $_POST['genrecat'] . _AM_DEBASER_DELETED);
} else {
redirect_header('index.php', 2, $_POST['genrecat'] . _AM_DEBASER_NOTDELETED);
}
exit;
} else {
echo "<h4>" . _AM_DEBASER_GENREADMIN . "</h4>";
xoops_confirm(array('genreid' => $_GET['genreid'], 'genrecat' => $_GET['genrecat'], 'del' => 1), 'category.php?op=deletegenre', _AM_DEBASER_SUREDELETEGENRE);
}
//xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'song', $_POST['mpegid']);
//xoops_notification_deletebyitem($xoopsModule->getVar('mid'), 'category', $_POST['genrecat']);
}
