首页 传奇3 传奇3G 传奇Ⅲ 传奇三 传奇3私服 传奇3G私服 传奇三私服 传奇3sf 最新传奇3 新开传奇3
当前位置:主页 > 新开传奇3 > 光通版传奇3常用的SQL查询脚本,最近太忙发得晚了点!

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

  • 分类:新开传奇3
  • 阅读:2355
  • 更新:2024-06-28

删除复制装备的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

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




广告位招租

广告位招租