chamilo / chamilo-lms

     * @param int $url_id

     * @return array

     * */

    public static function get_url_data_from_id($url_id)

    {

        $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL);

        $sql = "SELECT id, url, description, active

                FROM $table

                WHERE id = ".intval($url_id);

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

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

        return $row;

    }

    /**

     * Gets the inner join of users and urls table

     *

     * @return int Database::num_rows($res);

     **/

    public static function getCountUrlRelCourse($courseId)

    {

        $courseId = intval($courseId);

        $tableUrlRelCourse = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);

        $sql = "SELECT *

                FROM $tableUrlRelCourse

                WHERE c_id = '$courseId'";

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

        return Database::num_rows($res);

    }

    /**

     * Gets the inner join of access_url and the session table

     *

     * @return boolean true if success

     * */

    public static function deleteUserFromAllUrls($userId)

    {

        $table_url_rel_user = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);

        $result = true;

        if (!empty($userId)) {

            $sql= "DELETE FROM $table_url_rel_user

                   WHERE user_id = ".intval($userId);

            Database::query($sql);

        }

        return $result;

    }

    /**

    * Deletes an url and course relationship

 * @param int User ID

 * @return void

 */

function LoginDelete($user_id)

{

	$online_table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ONLINE);

    $user_id = intval($user_id);

	$query = "DELETE FROM " . $online_table . " WHERE login_user_id = $user_id";

	Database::query($query);

}

/**

 * @param int $user_id

    * @param int $id id message to delete.

    * @return bool status query

    */

    public static function deleteMessage($id)

    {

        $id = intval($id);

        $tblMessage = Database::get_main_table(TABLE_MESSAGE);

        $statusMessage = MESSAGE_STATUS_WALL_DELETE;

        $sql = "UPDATE $tblMessage SET msg_status = '$statusMessage' WHERE id = '{$id}' ";

        return Database::query($sql);

    }

    /**

     * Generate the social block for a user

    /**

     * @param int $userId

     */

    static function add_user_as_admin($userId)

    {

        $table_admin = Database :: get_main_table(TABLE_MAIN_ADMIN);

        $userId = intval($userId);

        if (!self::is_admin($userId)) {

            $sql = "INSERT INTO $table_admin SET user_id = $userId";

            Database::query($sql);

        }

    }

    /**

     * @param int $userId

    /**

     * @param int $userId

     */

    public static function remove_user_admin($userId)

    {

        $table_admin = Database :: get_main_table(TABLE_MAIN_ADMIN);

        $userId = intval($userId);

        if (self::is_admin($userId)) {

            $sql = "DELETE FROM $table_admin WHERE user_id = $userId";

            Database::query($sql);

        }

    }

    /**

     * @param string $from