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

     *

     * @return boolean true if success

     * */

    public static function delete_url_rel_usergroup($userGroupId, $urlId)

    {

        $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP);

        $sql= "DELETE FROM $table

               WHERE usergroup_id = '".intval($userGroupId)."' AND

                     access_url_id = ".intval($urlId);

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

        return $result;

    }

    /**

     * Deletes an url and $userGroup relationship

     *

     * @return array

     */

    public static function getUsersInCategory($categoryId)

    {

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY_REL_USER);

        $categoryId = intval($categoryId);

        $sql = "SELECT * FROM $table WHERE category_id = $categoryId";

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

        return Database::store_result($result);

    }

    /**

     * @param int $categoryId

    /**

     * @param int $categoryId

     */

    public static function deleteAllUserInCategory($categoryId)

    {

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY_REL_USER);

        $categoryId = intval($categoryId);

        $sql = "DELETE FROM $table WHERE category_id = $categoryId";

        Database::query($sql);

    }

    /**

     * Get all possible tickets statuses

     * @param    int     Link/Resource ID

     * @return   bool    false on error, true on success

     */

    public static function remove_resource_from_course_gradebook($link_id)

    {

        if (empty($link_id)) {

            return false;

        }

        // TODO find the corresponding category (the first one for this course, ordered by ID)

        $l = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);

        $sql = "DELETE FROM $l WHERE id = ".(int)$link_id;

        Database::query($sql);

        return true;

    }

    /**

     * Block students

 * @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 The language id

     * @return void()

     */

    public static function make_unavailable_language($language_id)

    {

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "UPDATE $tbl_admin_languages SET available='0'

                WHERE id = " . intval($language_id) . "";

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

        return $result !== false; //only return false on sql error

    }

    /**

     * Make available the language

     * @param int The language id

     * @return void

     */

    public static function make_available_language($language_id)

    {

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "UPDATE $tbl_admin_languages SET available='1'

                WHERE id = " . intval($language_id) . "";

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

        return $result !== false; //only return false on sql error

    }

    /**

     * Set platform language

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

     *

     * @return bool

     */

    public static function clear_session_ref_promotion($id)

    {

        $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);

        $id = intval($id);

        $sql = "UPDATE $tbl_session 

                SET promotion_id = 0

                WHERE promotion_id = $id";

        if (Database::query($sql)) {

            return true;

        } else {

            return false;

        }

    }

    /**

     * @param int $sessionId

     * @return bool

     */

    public static function removeAllDrhFromSession($sessionId)

    {

        $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);

        $sessionId = (int) $sessionId;

        if (empty($sessionId)) {

            return false;

        }

        $sql = "DELETE FROM $tbl_session_rel_user

                WHERE

                    session_id = $sessionId AND                            

                    relation_type =" . SESSION_RELATION_TYPE_RRHH;

        Database::query($sql);

        return true;

    }

    /**

     * Subscribes sessions to human resource manager (Dashboard feature)

    /**

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