seek1981 发表于 2010-1-13 11:32:39

1399版怎么在sql里给人物角色加装备？

1399版怎么在sql里给人物角色加装备？

ctgwglzc 发表于 2010-1-13 16:37:46

1399版怎么在sql里给人物角色加装备？
seek1981 发表于 2010-1-13 11:32 http://www.kofans.cn/bbs/static/image/common/back.gif
用工具刷

seek1981 发表于 2010-1-13 16:58:52

谢谢大哥
学了几个小小的改动
TB_USER 帐号列表
ACCOUNT_CHAR 帐号对应的三个人物
USERDATA 人物属性/技能/身上物品表

leonjaykai 发表于 2010-1-13 18:55:01

身上和倉庫的東西好像都是加密的要用gm工具刷囉

gjkyyy 发表于 2010-1-14 20:03:53

身上和倉庫的東西好像都是加密的要用gm工具刷囉
正解

kkyy1020 发表于 2010-1-16 15:56:12

仓库加密

jianweis 发表于 2010-1-20 18:42:16

工具在哪下？？？

ctgwglzc 发表于 2010-1-21 06:13:05

CREATE procedure ITEMLERI_ENCODE
@StrUserID varchar(30)
AS
-- By exselansTR | HepGeL.CoM
DECLARE
@length int, -- stritem uzunlugu
@row int, -- yerine göre deisior.
@i int, -- item'in stritem deki yeri
@dwid int, -- dwid
@pos int,
@dur int,
@dur1 int,
@ext int,
@StackSize1 int,
@strName varchar(30),
@strExtName varchar(30),
@Cdwid varbinary(4),
@cdur varchar(2),
@Source tinyint,
@NEWdwid int,
@StackSize int,
@cstack varchar(2),
@sira int

    set @sira=0
    set @i = 14*0
    set @length = 401

select @row=count( * ) from userdata where struserid=@StrUserID

if @row>0
begin


Select @dwid=dwid,
@dur = durability,
@StackSize1 = stacksize,
      @StrUserID = strUserID
      From itemler
      Where strUserID = @StrUserID and sira=@sira

    Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) +
Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)
    Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as
varchar(2))
    Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as
varbinary(2)), 1, 1) as varchar(2))


    update UserData set strItem = cast(cast(cast(@Cdwid as varchar(4)) + @Cdur + @Cstack as varchar(8))   as
binary(400)) where strUserID = @strUserID


set @i=@i+8
set @sira=@sira+1



WHILE @sira < 50
Begin

Select @dwid=dwid,
@dur = durability,
@StackSize1 = stacksize,
      @StrUserID = strUserID
      From itemler
      Where strUserID = @StrUserID and sira=@sira

    Set @Cdwid = Substring(cast(@dwid as varbinary(4)), 4, 1) + Substring(cast(@dwid as varbinary(4)), 3, 1) +
Substring(cast(@dwid as varbinary(4)), 2, 1) + Substring(cast(@dwid as varbinary(4)), 1, 1)
    Set @Cdur = cast(Substring(cast(@dur as varbinary(2)), 2, 1)+Substring(cast(@dur as varbinary(2)), 1, 1) as
varchar(2))
    Set @Cstack = cast(Substring(cast(@StackSize1 as varbinary(2)), 2, 1)+Substring(cast(@StackSize1 as
varbinary(2)), 1, 1) as varchar(2))


    update UserData set strItem = cast( substring(strItem, 1, @i) + cast(cast(@Cdwid as varchar(4)) + @Cdur +
@Cstack as varchar(8)) + substring(strItem, @i+8, 401-@i) as binary(400)) where strUserID = @strUserID


set @i=@i+8
set @sira=@sira+1

end
end
delete from itemler
GO

单身 发表于 2010-1-28 13:55:57

寻找GM工具中.........




在这问下单机怎么创建账号

leonjaykai 发表于 2010-1-29 13:24:36

在數據庫裡的tb_user表內去新創
页: [1] 2
查看完整版本: 1399版怎么在sql里给人物角色加装备？