传奇3架设常用的SQL脚本命令

畅游

传奇3架设常用的SQL脚本命令

1、架设服务器时修改ACCOUNT和HEROCOMMON1的脚本.

update TBL_GMIP
set FLD_IP='127.0.0.1'     
from TBL_GMIP

update TBL_PUBIPS
set FLD_PUBIP='127.0.0.1'   
from TBL_PUBIPS

update TBL_SELECTGATEIPS
set FLD_NAME='夜游神论坛'   
from TBL_SELECTGATEIPS

update TBL_SELECTGATEIPS
set FLD_IP='127.0.0.1'   
from TBL_SELECTGATEIPS

update TBL_SERVERINFO
set FLD_SERVERNAME='夜游神论坛'   
from TBL_SERVERINFO
------------------------------------------------------------------
update rareitemsdata
set PassedHours='0'                  
from rareitemsdata

update rareitemsdata
set Dropped='0'                  
from rareitemsdata

update rareitemsdata
set MissedCount='0'                  
from rareitemsdata

update CastleDefine
set ServerName='夜游神论坛'
from CastleDefine

update CastleWars
set servername='夜游神论坛'
from CastleWars

update rareitemsdata
set servername='夜游神论坛'
from rareitemsdata

update rareitems
set upgprob='6'                  
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=49444675

use Game1
SELECT *
FROM TBL_ITEM
where FLD_MAKEINDEX=@index

SELECT *
FROM TBL_SAVEDITEM
where FLD_MAKEINDEX=@index

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

use Game1
DELETE FROM [muddb].[dbo].[TBL_ITEM]
WHERE [FLD_INDEX]=34
DELETE FROM [muddb].[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

lyx6974

谢谢分享，支持楼主

cailiaock

谢谢分享要森要

tianqihao

感谢楼主分享

lyx6974

好帖子，顶起来！！！