传奇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 ..
SET =45
WHERE like @username
UPDATE ..
SET =45
WHERE 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 ..
WHERE =34
DELETE FROM ..
WHERE =34
7、查询人物全数据的SQL脚本
DECLARE @username varchar(12)
set @username='人物名'
use Game1
SELECT *
FROM TBL_CHARACTER
where like @username
SELECT *
FROM TBL_ABILITY
where like @username
SELECT *
FROM TBL_FACEIMG
where like @username
SELECT *
FROM TBL_MAGIC
where like @username
SELECT *
FROM TBL_QUEST
where like @username
SELECT *
FROM TBL_SAVEDITEM
where like @username
SELECT *
FROM TBL_ITEM
where like @username
SELECT *
FROM TBL_SUBHUMAN
where like @username
感谢分享》》》》》 感谢分享》》》》》