chamilo / chamilo-lms

     * @param integer $id              The id (an integer number) of the corresponding database record.

     * @return array/bool                 Returns the requested data as an array or FALSE on failure.

     */

    public static function get_course_request_info($id)

    {

        $id = (int)$id;

        $sql = "SELECT *

                FROM ".Database :: get_main_table(TABLE_MAIN_COURSE_REQUEST)."

                WHERE id = ".$id;

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

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

            return Database::fetch_array($result);

        }

        return false;

    }

    /**

     * Gets the code of a given course request using its database id as an access key.

	 * Check availability of a survey code

	 * @param string $survey_code

	 */

    public function is_survey_code_available($survey_code)

    {

		$table_sur = Database :: get_course_table(TABLE_SURVEY);

		$sql = "SELECT * FROM $table_sur

		        WHERE

		            c_id = ".$this->destination_course_id." AND

		            code='".self::DBUTF8escapestring($survey_code)."'";

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

		if (Database::num_rows($result) > 0) return false; else return true;

	}

	/**

	 * Restore survey-questions