chamilo / chamilo-lms

 * @author Patrick Cool <[email protected]>, Ghent University

 * @version february 2006, dokeos 1.8

 */

function get_post_information($post_id)

{

    $table_posts = Database::get_course_table(TABLE_FORUM_POST);

    $table_users = Database::get_main_table(TABLE_MAIN_USER);

    $course_id = api_get_course_int_id();

    $sql = "SELECT posts.*, email FROM ".$table_posts." posts, ".$table_users." users

            WHERE

                c_id = $course_id AND

                posts.poster_id=users.user_id AND

                posts.post_id = ".intval($post_id);

    $result = Database::query($sql);

    $row = Database::fetch_array($result, 'ASSOC');

    return $row;

}

/**

 * This function retrieves all the information of a thread

     * @author Patrick Cool <[email protected]>, Ghent University

     * @version January 2007

     */

    public static function delete_all_survey_questions_options($survey_id, $shared = false)

    {

        // Table definitions

        $table_survey_question_option = Database::get_course_table(TABLE_SURVEY_QUESTION_OPTION);

        $course_id = api_get_course_int_id();

        $course_condition = " c_id = $course_id AND ";

        if ($shared) {

            $course_condition = "";

            $table_survey_question_option = Database::get_main_table(TABLE_MAIN_SHARED_SURVEY_QUESTION_OPTION);

        }

        $sql = "DELETE FROM $table_survey_question_option

                WHERE $course_condition survey_id='".intval($survey_id)."'";

        // Deleting the options of the survey questions

        Database::query($sql);

        return true;

    }

    /**

     * @author Julio Montoya

     * @version March 2007

     */

    public static function delete_survey_question_option($survey_id, $question_id, $shared = false)

    {

        $course_id = api_get_course_int_id();

        $course_condition = " c_id = $course_id AND ";

        // Table definitions

        $table_survey_question_option = Database::get_course_table(TABLE_SURVEY_QUESTION_OPTION);

        if ($shared) {

            $course_condition = "";

            $table_survey_question_option = Database::get_main_table(TABLE_MAIN_SHARED_SURVEY_QUESTION_OPTION);

        }

        // Deleting the options of the survey questions

        $sql = "DELETE from $table_survey_question_option

		        WHERE

		            $course_condition survey_id='".intval($survey_id)."' AND

		            question_id='".intval($question_id)."'";

        Database::query($sql);

        return true;

    }

    /**

     * SURVEY ANSWERS FUNCTIONS

     * @param int $courseId

     * @return bool Returns TRUE if the session and the course are related, FALSE otherwise.

     * */

    public static function relation_session_course_exist($session_id, $courseId)

    {

        $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);

        $return_value = false;

        $sql = "SELECT c_id FROM $tbl_session_course

                WHERE

                  session_id = " . intval($session_id) . " AND

                  c_id = " . intval($courseId);

        $result = Database::query($sql);

        $num = Database::num_rows($result);

        if ($num > 0) {

            $return_value = true;

        }

        return $return_value;

    }

    /**

     * Get the session information by name