chamilo / chamilo-lms

	 * Gets the number of terms and conditions available

	 * @return int

	 */

	public static function count()

    {

		$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);

		$sql = "SELECT count(*) as count_result

		        FROM $legal_conditions_table

		        ORDER BY legal_id DESC ";

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

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

		$result = $url['count_result'];

		return $result;

	}

	/**

	 * Get type of terms and conditions

     * @param sql : a sql query (as a string)

     * @desc Return many results of a query in a 1 column tab

     */

    public static function getManyResults1Col($sql)

    {

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

        if ($res !== false) {

            $i = 0;

            while ($resA = Database::fetch_array($res, 'NUM')) {

                $resu[$i++] = $resA[0];

            }

        }

        return $resu;

    }

    /**

     * @author Sebastien Piraux <[email protected]>

     * @author Julio Montoya

     * @return int count of urls

     * */

    public static function url_count()

    {

        $table_access_url= Database :: get_main_table(TABLE_MAIN_ACCESS_URL);

        $sql = "SELECT count(id) as count_result FROM $table_access_url";

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

        $url = Database::fetch_array($res,'ASSOC');

        $result = $url['count_result'];

        return $result;

    }

    /**

     * Gets the id, url, description, and active status of ALL URLs

    /**

	 * @return array

	 */

	function get_all_categories()

	{

		$table = Database::get_course_table(TABLE_QUIZ_CATEGORY);

		$sql = "SELECT * FROM $table ORDER BY title ASC";

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

		while ($row = Database::fetch_array($res,'ASSOC')) {

			$array[] = $row;

		}

		return $array;

	}

	/**

	 * @param Exercise $exercise