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 int

     */

    public static function getCategoriesCount()

    {

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY);

        $sql = "SELECT count(id) count

                FROM $table ";

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

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

        return $category['count'];

    }

    /**

     * @param int $id

    /**

	 * @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

 * @version August 2008

 * @since v1.8.6

 */

function getNumberOfTemplates()

{

    // Database table definition.

    $table_system_template = Database :: get_main_table('system_template');

    // The sql statement.

    $sql = "SELECT COUNT(id) AS total FROM $table_system_template";

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

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

    // Returning the number of templates.

    return $row['total'];

}

/**

 * Gets all the template data for the sortable table.