/** * 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; } }