static function remove_forum_k1($course_id, $forum_id) { require_once JPATH_ADMINISTRATOR . '/components/com_kunena/libraries/category.php'; $db = JFactory::getDBO(); kimport('tables.kunenacategory'); $row = new TableKunenaCategory($db); $kunena_forum_id = JoomdleHelperForum::get_kunena_forum_id($course_id, $forum_id); $row->delete($kunena_forum_id); $query = 'DELETE ' . ' FROM #__joomdle_course_forums' . " WHERE course_id = " . $db->Quote($course_id); $query .= " AND moodle_forum_id = " . $db->Quote($forum_id); $db->setQuery($query); $db->query(); }
function addModerator($option, $id, $cid = null, $publish = 1) { $kunena_app =& JFactory::getApplication(); $kunena_db =& JFactory::getDBO(); $kunena_my =& JFactory::getUser(); $numcid = count($cid); $action = ""; if ($publish == 1) { $action = 'add'; } else { $action = 'remove'; } JArrayHelper::toInteger($cid); if (!is_array($cid) || count($cid) < 1) { echo "<script> alert('" . JText::_('COM_KUNENA_SELECTMODTO') . " {$action}'); window.history.go(-1);</script>\n"; exit; } if ($action == 'add') { for ($i = 0, $n = count($cid); $i < $n; $i++) { $kunena_db->setQuery("INSERT INTO #__kunena_moderation SET catid='{$id}', userid='{$cid[$i]}'"); $kunena_db->query(); if (KunenaError::checkDatabaseError()) { return; } } } else { for ($i = 0, $n = count($cid); $i < $n; $i++) { $kunena_db->setQuery("DELETE FROM #__kunena_moderation WHERE catid='{$id}' AND userid='{$cid[$i]}'"); $kunena_db->query(); if (KunenaError::checkDatabaseError()) { return; } } } kimport('tables.kunenacategory'); $row = new TableKunenaCategory($kunena_db); $row->checkin($id); $kunena_db->setQuery("UPDATE #__kunena_sessions SET allowed='na'"); $kunena_db->query(); KunenaError::checkDatabaseError(); while (@ob_end_clean()) { } $kunena_app->redirect(JURI::base() . "index.php?option={$option}&task=edit2&uid=" . $id); }