chamilo / chamilo-lms

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

	 * 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 id DESC ";

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

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

		$result = $url['count_result'];

		return $result;

	}

	/**

	 * Get type of terms and conditions

     *

     * @return integer Total number of courses

     */

    public static function get_total_number_courses()

    {

        $table = Database :: get_main_table(TABLE_MAIN_COURSE);

        $sql = "SELECT COUNT(id) count FROM $table";

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

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

        return $row['count'];

    }

    /**

     * Get data for the courses

     *

     * @return integer Total number of sessions

     */

    public static function get_total_number_sessions()

    {

        $table = Database :: get_main_table(TABLE_MAIN_SESSION);

        $sql = "SELECT COUNT(id) count FROM $table";

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

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

        return $row['count'];

    }

    /**

     * Get data for the sessions

     * @version Dokeos 1.8.6

     * @since October 2008

     */

    public static function get_number_of_users_tracking_overview()

    {

        $table = Database :: get_main_table(TABLE_MAIN_USER);

        $sql = "SELECT COUNT(id) count FROM $table";

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

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

        return $row['count'];

    }

    /**

     * get all the data for the sortable table of the reporting progress of all users and all the courses the user is subscribed to.

    /**

     * @return int

     */

    public static function getNumberOfTrackAccessOverview()

    {

        $table = Database :: get_main_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);

        $sql = "SELECT COUNT(course_access_id) count FROM $table";

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

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

        return $row['count'];

    }

    /**

     * @param $from

    /**

     * @return int

     */

    public static function get_number_of_tracking_access_overview()

    {

        $table = Database :: get_main_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);

        $sql = "SELECT COUNT(course_access_id) count FROM $table";

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

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

        return $row['count'];

    }

    /**

     * Get the ip, total of clicks, login date and time logged in for all user, in one session

     * @param string Category code

     * @return array Course category

     */

    public static function get_course_category($code)

    {

        $table_categories = Database::get_main_table(TABLE_MAIN_CATEGORY);

        $code = Database::escape_string($code);

        $sql = "SELECT * FROM $table_categories WHERE code = '$code'";

        return Database::fetch_array(Database::query($sql));

    }

    /**

     * Returns the details of a course category

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