人物小退自动五转的sql语句
CREATE TRIGGER zhuansheng ON [dbo].[TBL_CHAR]
FOR UPDATE
AS
begin
update TBL_CHAR set FLD_JOB_LEVEL=5
where FLD_LEVEL>99
end
解决卡号
选择RXJHGAME库 执行 即可
update tbl_char set fld_x=840.0859,fld_y=2120.5017,fld_menow=101 where fld_x=0 or fld_y=0 or fld_menow=0
装备不受职业、等级、性别、转生、正邪限制的改法!
职业不受限制
use rxjhgame update TBL_ITEM set FLD_RESIDE1 = 0
等级不受限制
use rxjhgame update TBL_ITEM set FLD_LEVEL = 1
性别不受限制
use rxjhgame update TBL_ITEM set FLD_SEX = 0
转生不受限制
use rxjhgame update TBL_ITEM set FLD_JOB_LEVEL = 0
正邪不受限制
use rxjhgame update TBL_ITEM set FLD_ZX = 0
修改人数限制(www.83511.com)
USE rxjhaccount
update TBL_ONLINE set FLD_MAXUSER=500 (500可以自己修改 是表示人数)
点执行查询 或者按 F5
成功后,删除刚才复制的,再复制下面的
CREATE TRIGGER online_update ON [dbo].[TBL_ONLINE]
FOR UPDATE
执行查询
更改历练倍率
use rxjhgame
update tbl_kongfu
set fld_needExp=fld_needExp*0.1
更改经验倍率
SELECT *
FROM TBL_EXP
替换成
UPDATE TBL_EXP
SET FLD_EXP = FLD_EXP / 10
然后[运行]
同样TBL_Char这个里面的人物表也一样方法!
查看综合仓库
SELECT *
FROM TBL_PublicWarehouse
WHERE (FLD_ID = '帐号')
查询等级>80
SELECT TOP 100 *
FROM TBL_Char
WHERE (FLD_ID NOT IN
(SELECT TOP 100 FLD_ID
FROM rxjhgame.dbo.TBL_Char)) AND (FLD_LEVEL > 80)
ORDER BY FLD_LEVEL DESC, FLD_NAME
等级排行榜
SELECT TOP 10 *
FROM rxjhgame.dbo.TBL_Char
WHERE (FLD_ID NOT IN
(SELECT TOP 10 FLD_ID
FROM rxjhgame.dbo.TBL_Char))
ORDER BY FLD_LEVEL DESC, FLD_NAME
查询帐号
SELECT *
FROM rxjhACCOUNT.dbo.TBL_ACCOUNT
WHERE (FLD_ID = '帐号'')
SELECT *
FROM rxjhgame.dbo.TBL_Char
WHERE (FLD_ID = '帐号'')
查询名字
SELECT *
FROM TBL_Char
WHERE (FLD_NAME = '名字)
此文由83511热血江湖SF网转载!