/**
* 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 forum ID
* @access public
* @param forumID
* @return true or false
* @author Cindy Qi Li
*/
function DeleteByForumID($forumID)
{
$sql = "DELETE FROM " . TABLE_PREFIX . "content_forums_assoc \n\t WHERE forum_id = " . $forumID . "";
if ($this->execute($sql)) {
// update the courses.modified_date to the current timestamp
include_once TR_INCLUDE_PATH . 'classes/DAO/ForumsCoursesDAO.class.php';
include_once TR_INCLUDE_PATH . 'classes/DAO/CoursesDAO.class.php';
$forumsCoursesDAO = new ForumsCoursesDAO();
$course_rows = $forumsCoursesDAO->getByForum($forumID);
if (is_array($course_rows)) {
foreach ($course_rows as $row) {
$coursesDAO = new CoursesDAO();
$coursesDAO->updateModifiedDate($row['course_id']);
}
}
return true;
} else {
$msg->addError('DB_NOT_UPDATED');
return false;
}
}
/**
* Delete course
* @access public
* @param course ID
* @return true, if successful
* false and add error into global var $msg, if unsuccessful
* @author Cindy Qi Li
*/
public function Delete($courseID)
{
require_once TR_INCLUDE_PATH . 'classes/FileUtility.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/ContentDAO.class.php';
require_once TR_INCLUDE_PATH . 'classes/DAO/ForumsCoursesDAO.class.php';
$contentDAO = new ContentDAO();
$forumsCoursesDAO = new ForumsCoursesDAO();
unset($_SESSION['s_cid']);
// delete course content dir
$content_dir = TR_CONTENT_DIR . $courseID . '/';
FileUtility::clr_dir($content_dir);
// delete tests and tests related data
$sql = "DELETE FROM " . TABLE_PREFIX . "content_tests_assoc\n\t\t WHERE content_id in (SELECT content_id FROM " . TABLE_PREFIX . "content WHERE course_id = " . $courseID . ")";
$this->execute($sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "tests_questions_categories WHERE course_id = " . $courseID;
$this->execute($sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "tests_questions_assoc \n\t\t WHERE test_id in (SELECT test_id FROM " . TABLE_PREFIX . "tests WHERE course_id = " . $courseID . ")";
$this->execute($sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "tests_questions WHERE course_id = " . $courseID;
$this->execute($sql);
$sql = "DELETE FROM " . TABLE_PREFIX . "tests WHERE course_id = " . $courseID;
$this->execute($sql);
// delete forums that are associated with this course
$forumsCoursesDAO->DeleteByCourseID($courseID);
// loop thru content to delete using ContentDAO->Delete(), which deletes a4a objects as well
$content_rows = $contentDAO->getContentByCourseID($courseID);
if (is_array($content_rows)) {
foreach ($content_rows as $content) {
$contentDAO->Delete($content['content_id']);
}
}
$sql = "DELETE FROM " . TABLE_PREFIX . "content WHERE course_id = " . $courseID;
$this->execute($sql);
// delete user <-> course association
$sql = "DELETE FROM " . TABLE_PREFIX . "user_courses WHERE course_id = " . $courseID;
$this->execute($sql);
// delete the course
$sql = "DELETE FROM " . TABLE_PREFIX . "courses WHERE course_id = " . $courseID;
return $this->execute($sql);
}
