chamilo / chamilo-lms

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

     * 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

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

    /**

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

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

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

    /**

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

    }

}

function getActionId($courseId)

{

    global $tableSepeCourseActions;

    $sql = "SELECT action_id FROM $tableSepeCourseActions WHERE course_id = $courseId";

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

    $aux = Database::fetch_assoc($rs);

    return $aux['action_id'];

}

function getCourse($actionId)

{

    return $aux['action_id'];

}

function getCourse($actionId)

{

    global $tableSepeCourseActions;

    $sql = "SELECT course_id FROM $tableSepeCourseActions WHERE action_id = $actionId";

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

    $aux = Database::fetch_assoc($rs);

    return $aux['course_id'];

}

function getCourseCode($actionId)

{

    global $tableCourse;