传奇3重症监护室，传奇3疑难杂症处理中心新闻-传奇3重症监护室-Www.Mir3.icu

您的位置：传奇3重症监护室 → 传奇三 → 光通版传奇3常用的SQL查询脚本，最近太忙发得晚了点！

光通版传奇3常用的SQL查询脚本，最近太忙发得晚了点！

2022-06-27 18:12:21　　　分类：传奇三

原神哔哩哔哩版v2.4.0_5199000

类型：动作游戏

大小：244MB

评分：5.0

平台：

标签：二次元冒险幻想动作

查看详情

‌‍删除复制装备的SQL已经有人发了就不发了，喜欢的顶一下！
    1、架设服务器时修改herocommon1的脚本.

    use herocommon1

    update rareitemsdata
    set servername='你的传奇名'
    from rareitemsdata

    update rareitemsdata
    set passedhours=0
    from rareitemsdata

    update rareitemsdata
    set dropped=1
    from rareitemsdata

    update rareitemsdata
    set missedcount=0
    from rareitemsdata

    --将爆出时间全设为0，直接运行爆率文件！自己看着办！
    --update rareitems
    --set DropHours=0
    --from rareitems

    2、调级SQL脚本

    use Game1
    DECLARE @username varchar(10)
    set @username='用户名'

    UPDATE [Game1].[dbo].[TBL_CHARACTER]
    SET [FLD_LEVEL]=45
    WHERE [FLD_CHARACTER] like @username

    UPDATE [Game1].[dbo].[TBL_ABILITY]
    SET [FLD_LEVEL]=45
    WHERE [FLD_CHARACTER] like @username

    3、查找人物名SQL脚本

    use Game1
    SELECT *
    FROM TBL_CHARACTER
    where FLD_CHARACTER='人物名'

    4、查找游戏ID脚本

    use Game1
    SELECT *
    FROM TBL_CHARACTER
    where FLD_USERID='用户名'

    5、查找某个装备在谁那的SQL脚本

    DECLARE @index decimal(12)
    set @index=297296589

    use Game1
    SELECT *
    FROM TBL_ITEM
    where FLD_MAKEINDEX=@index

    SELECT *
    FROM TBL_SAVEDITEM
    where FLD_MAKEINDEX=@index

    6、全部删除服务器某件装备

    use Game1
    DELETE FROM [Game1].[dbo].[TBL_ITEM]
    WHERE [FLD_INDEX]=34
    DELETE FROM [Game1].[dbo].[TBL_SAVEDITEM]
    WHERE [FLD_INDEX]=34

    7、查询人物全数据的SQL脚本

    DECLARE @username varchar(12)
    set @username='人物名'

    use Game1
    SELECT *
    FROM TBL_CHARACTER
    where [FLD_CHARACTER] like @username

    SELECT *
    FROM TBL_ABILITY
    where [FLD_CHARACTER] like @username

    SELECT *
    FROM TBL_FACEIMG
    where [FLD_USERNAME] like @username

    SELECT *
    FROM TBL_MAGIC
    where [FLD_CHARACTER] like @username

    SELECT *
    FROM TBL_QUEST
    where [FLD_CHARACTER] like @username

    SELECT *
    FROM TBL_SAVEDITEM
    where [FLD_CHARACTER] like @username

    SELECT *
    FROM TBL_ITEM
    where [FLD_CHARACTER] like @username

    SELECT *
    FROM TBL_SUBHUMAN
    where [FLD_CHARACTER] like @username

    暂时发这么多，等有了新的再发吧，喜欢的顶啊！！！！！
    不好意思，有一处错误，修改一下