chamilo / chamilo-lms

	 * return array answer by id else return a bool

	 * @param integer $auto_id

	 */

	public function selectAnswerByAutoId($auto_id)

	{

		$TBL_ANSWER = Database::get_course_table(TABLE_QUIZ_ANSWER);

		$auto_id = intval($auto_id);

		$sql = "SELECT id, answer, id_auto FROM $TBL_ANSWER

				WHERE c_id = {$this->course_id} AND id_auto='$auto_id'";

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

		if (Database::num_rows($rs) > 0) {

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

			return $row;

		}

		return false;

	}

    /**

     * returns the answer title from an answer's position

     * @param $surveyId

     * @return boolean return true if the survey has answers, false otherwise

     */

    public static function checkIfSurveyHasAnswers($surveyId)

    {

        $tableSurveyAnswer = Database :: get_course_table(TABLE_SURVEY_ANSWER);

        $courseId = api_get_course_int_id();

        $sql = "SELECT * FROM $tableSurveyAnswer

                WHERE

                    c_id = $courseId AND

                    survey_id='".$surveyId."'

                ORDER BY answer_id, user ASC";

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

        $response = Database::affected_rows($result);

        if ($response > 0) {

            return true;

        }

        return false;

    }

}

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

 * @version february 2006, dokeos 1.8

 */

function check_if_last_post_of_thread($thread_id)

{

    $table_posts = Database :: get_course_table(TABLE_FORUM_POST);

    $course_id = api_get_course_int_id();

    $sql = "SELECT * FROM $table_posts

            WHERE c_id = $course_id AND thread_id = ".intval($thread_id)."

            ORDER BY post_date DESC";

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

    if (Database::num_rows($result) > 0) {

        $row = Database::fetch_array($result);

        return $row;

    } else {

        return false;

    }

}

/**

 * @param $content what is it that we want to make (in)visible: forum category, forum, thread, post