热血江湖私服技术文章总结(一)

人物小退自动五转的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网转载！