/**
* Delete row by test ID
* @access public
* @param testID
* @return true or false
* @author Cindy Qi Li
*/
function DeleteByTestID($testID)
{
$sql = "DELETE FROM " . TABLE_PREFIX . "content_tests_assoc \n\t WHERE test_id = " . $testID . "";
if ($this->execute($sql)) {
// update the courses.modified_date to the current timestamp
include_once TR_INCLUDE_PATH . 'classes/DAO/TestsDAO.class.php';
include_once TR_INCLUDE_PATH . 'classes/DAO/CoursesDAO.class.php';
$testsDAO = new TestsDAO();
$test_rows = $testsDAO->get($testID);
if ($test_rows['course_id'] > 0) {
$coursesDAO = new CoursesDAO();
$coursesDAO->updateModifiedDate($test_rows['course_id']);
}
return true;
} else {
$msg->addError('DB_NOT_UPDATED');
return false;
}
}
/**
* 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 content
* @access public
* @param content ID
* @return true, if successful
* false and add error into global var $msg, if unsuccessful
* @author Cindy Qi Li
*/
public function Delete($contentID)
{
global $msg;
require_once TR_INCLUDE_PATH . 'classes/A4a/A4a.class.php';
$a4a = new A4a($contentID);
$a4a->deleteA4a();
// delete the content tests association
include_once TR_INCLUDE_PATH . 'classes/DAO/ContentTestsAssocDAO.class.php';
$contentTestsAssocDAO = new ContentTestsAssocDAO();
$contentTestsAssocDAO->DeleteByContentID($contentID);
// delete the content forums association
include_once TR_INCLUDE_PATH . 'classes/DAO/ContentForumsAssocDAO.class.php';
$contentForumsAssocDAO = new ContentForumsAssocDAO();
$contentForumsAssocDAO->DeleteByContentID($contentID);
$sql = "DELETE FROM " . TABLE_PREFIX . "content WHERE content_id = " . $contentID;
if ($this->execute($sql)) {
// update the courses.modified_date to the current timestamp
include_once TR_INCLUDE_PATH . 'classes/DAO/CoursesDAO.class.php';
$coursesDAO = new CoursesDAO();
$coursesDAO->updateModifiedDate($contentID, "content_id");
return true;
} else {
$msg->addError('DB_NOT_UPDATED');
return false;
}
}
