2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2010 */
6 /* Inclusive Design Institute */
8 /* This program is free software. You can redistribute it and/or */
9 /* modify it under the terms of the GNU General Public License */
10 /* as published by the Free Software Foundation. */
11 /************************************************************************/
14 * DAO for "forums_courses" table
20 if (!defined('TR_INCLUDE_PATH')) exit;
22 require_once(TR_INCLUDE_PATH. 'classes/DAO/DAO.class.php');
24 class ForumsCoursesDAO extends DAO {
29 * @param forum_id, course_id
30 * @return true / false
33 function Create($forum_id, $course_id)
35 $sql = 'INSERT INTO ' . TABLE_PREFIX . 'forums_courses' .
36 '(forum_id, course_id) ' .
37 'VALUES (' . $forum_id . ", $course_id)";
38 return $this->execute($sql);
42 * Delete row by course ID
45 * @return true or false
48 function DeleteByCourseID($courseID)
50 include_once(TR_INCLUDE_PATH.'classes/DAO/ForumsDAO.class.php');
51 $forumsDAO = new ForumsDAO();
53 $all_forums = $this->getByCourse($courseID);
54 if (is_array($all_forums)) {
55 foreach ($all_forums as $forums) {
56 $forumsDAO->Delete($forums['forum_id']);
59 $sql = "DELETE FROM ".TABLE_PREFIX."forums_courses
60 WHERE course_id = ".$courseID."";
61 return $this->execute($sql);
65 * Delete row by forum ID
68 * @return true or false
71 function DeleteByForumID($forumID)
73 $sql = "DELETE FROM ".TABLE_PREFIX."forums_courses
74 WHERE forum_id = ".$forumID."";
75 return $this->execute($sql);
79 * Return rows by course ID
85 function getByCourse($course_id)
87 $sql = "SELECT * FROM ".TABLE_PREFIX."forums_courses WHERE course_id = '".$course_id."'";
88 return $this->execute($sql);
92 * Return rows by forum ID
98 function getByForum($forum_id)
100 $sql = "SELECT * FROM ".TABLE_PREFIX."forums_courses WHERE forum_id = '".$forum_id."'";
101 return $this->execute($sql);