function confirmdelete($link_id, $option) { global $mtconf, $mainframe, $Itemid; // Check for request forgeries JRequest::checkToken() or jexit('Invalid Token'); $database =& JFactory::getDBO(); $my =& JFactory::getUser(); $jdate = JFactory::getDate(); $now = $jdate->toMySQL(); $nullDate = $database->getNullDate(); $database->setQuery("SELECT * FROM #__mt_links WHERE " . "\n link_published='1' AND link_approved > 0 AND link_id='" . $link_id . "'" . "\n AND ( publish_up = " . $database->Quote($nullDate) . " OR publish_up <= '{$now}' ) " . "\n AND ( publish_down = " . $database->Quote($nullDate) . " OR publish_down >= '{$now}' ) "); $link = $database->loadObject(); if ($mtconf->get('user_allowdelete') && $my->id == $link->user_id && $my->id > 0) { $link = new mtLinks($database); $link->load($link_id); if ($mtconf->get('notifyadmin_delete') == 1) { // Get owner's email $database->setQuery("SELECT email FROM #__users WHERE id = '" . $my->id . "' LIMIT 1"); $my_email = $database->loadResult(); $subject = JText::_('Admin notify delete subject'); $body = sprintf(JText::_('Admin notify delete msg'), $link->link_name, $link->link_name, $link->link_id, $my->username, $my_email, $link->link_created); mosMailToAdmin($subject, $body); } $link->updateLinkCount(-1); $link->delLink(); $cache =& JFactory::getCache('com_mtree'); $cache->clean(); $mainframe->redirect(JRoute::_("index.php?option={$option}&task=viewowner&user_id=" . $my->id . "&Itemid={$Itemid}"), JText::_('Listing have been deleted')); } else { echo _NOT_EXIST; } }
function delCatLinks($cat_id) { $this->_db->setQuery("SELECT l.link_id FROM #__mt_links AS l, #__mt_cl AS cl WHERE cl.link_id = l.link_id AND cl.cat_id = '" . $cat_id . "' AND cl.main = '1'"); $link_ids = $this->_db->loadResultArray(); # Remove all hard listing foreach ($link_ids as $link_id) { mtLinks::delLink($link_id); } # Remove all soft listing $this->_db->setQuery("DELETE FROM #__mt_cl WHERE cat_id = '" . $cat_id . "'"); $this->_db->query(); return true; }
function removeLinks($link_id, $option, $post = null) { global $mainframe; $database =& JFactory::getDBO(); $row = new mtLinks($database); $row->load($link_id[0]); if (!is_array($link_id) || count($link_id) < 1) { echo "<script> alert('" . JText::_('Select an item to delete') . "'); window.history.go(-1);</script>\n"; exit; } if (count($link_id)) { $link_ids = implode(',', $link_id); $total = count($link_id); # Locate all CL mapping and decrease the categories' link count foreach ($link_id as $id) { $database->setQuery('SELECT cat_id FROM #__mt_cl WHERE main = 0 AND link_id = ' . $database->quote($id)); $link_cls = $database->loadResultArray(); if (count($link_cls) > 0) { foreach ($link_cls as $link_cl) { $row->updateLinkCount(-1, $link_cl); } } } # Delete the main records foreach ($link_id as $id) { $database->setQuery('SELECT link_approved FROM #__mt_links WHERE link_id = ' . $database->quote($id)); $link_approved = $database->loadResult(); if ($link_approved <= 0) { $total--; } $row->delLink($id); } # Update link count for all category if ($total > 0) { $row->updateLinkCount(-1 * $total); } } if (is_null($post)) { $returntask = JRequest::getCmd('returntask', '', 'post'); } else { $returntask = $post['returntask']; } if ($returntask != '') { $mainframe->redirect("index2.php?option={$option}&task={$returntask}", sprintf(JText::_('Links have been deleted'), count($link_id))); } else { $mainframe->redirect("index2.php?option={$option}&task=listcats&cat_id=" . $row->cat_id); } }