/**
* create a forum
* @param string title
* @param string text/description
* @return added forum's id
*/
function createForum($title, $text, $course_id)
{
$forumsDAO = new ForumsDAO();
$forums_id = $forumsDAO->Create($title, $text);
$forumsCoursesDAO = new ForumsCoursesDAO();
$forumsCoursesDAO->Create($forums_id, $course_id);
return $forums_id;
}
/**
* Delete row by course ID
* @access public
* @param courseID
* @return true or false
* @author Cindy Qi Li
*/
function DeleteByCourseID($courseID)
{
include_once TR_INCLUDE_PATH . 'classes/DAO/ForumsDAO.class.php';
$forumsDAO = new ForumsDAO();
$all_forums = $this->getByCourse($courseID);
if (is_array($all_forums)) {
foreach ($all_forums as $forums) {
$forumsDAO->Delete($forums['forum_id']);
}
}
$sql = "DELETE FROM " . TABLE_PREFIX . "forums_courses \n\t WHERE course_id = " . $courseID . "";
return $this->execute($sql);
}
