ctgwglzc 发表于 2011-2-21 00:03:17

[Any version] Knight Editor/'GM tool'

Original NoahSystem/mgame character data editor.
Description
Lets you edit character data (including skills, quests, inventory & inn), and clan data.


Download

http://files.2-stars.net/2011/01/KnightEditor.zip


http://files.knightsshout.com/file/KnightEditor.zip

ctgwglzc 发表于 2011-2-21 00:04:33

Usage guide

    * Add the following stored procedure:CREATE PROCEDURE .
    @AccountID    varchar( 21),
    @Password    varchar(32),
   @nRet      smallint    OUTPUT
AS
DECLARE @pwd varchar(32), @Authority int
BEGIN

    -- <RETRIEVE ACCOUNT DATA>
    SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID
    -- </RETRIEVE ACCOUNT DATA>

    -- <ACCOUNT DOES NOT EXIST>
    IF @@ROWCOUNT = 0
    BEGIN
      SET @nRet = 0
      RETURN
    END
   -- </ACCOUNT DOES NOT EXIST>

    -- <NOT A 'GM'>
    IF @Authority <> 0
    BEGIN
      SET @nRet = 0
      RETURN
    END
   -- </NOT A 'GM'>
   
    -- <EMPTY PASSWORD>
    ELSE IF @pwd IS NULL
    BEGIN
      SET @nRet = 0
      RETURN
    END
   -- </EMPTY PASSWORD>

    -- <INVALID PASSWORD>   
    ELSE IF @pwd <> @Password
    BEGIN
      SET @nRet = 0
      RETURN
    END
   -- </INVALID PASSWORD>

    SET @nRet = 1
ENDAdd the following tables:CREATE TABLE .(
    (15) NULL,
    NULL
) ON
GO
CREATE TABLE .(
    NOT NULL,
    NULL,
CONSTRAINT PRIMARY KEY CLUSTERED
(
    ASC
)WITH (PAD_INDEX= OFF, STATISTICS_NORECOMPUTE= OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS= ON, ALLOW_PAGE_LOCKS= ON) ON
) ON Add the following version rows:INSERT INTO TOOL_VERSION VALUES(1, 1017)
INSERT INTO TOOL_USER_IP VALUES('YOUR INTERNAL IP ADDRESS GOES HERE', GetDate())# Configure "editor.ini" to reflect your database details.
# Set the strAuthority value of your account to 0 in your TB_USER table.
# Start "Xydonis.exe".

天剑风小流 发表于 2011-2-21 00:42:07

什么东西 看不懂哈哈

ryan6755 发表于 2011-3-3 23:34:01

添加表的代码貌似有错误 执行不了,CT给处理下啊

evaydd 发表于 2011-3-7 20:10:02

什么东西 看不懂哈哈
页: [1]
查看完整版本: [Any version] Knight Editor/'GM tool'