How to make the 9dragons US Server files working.

**soly95** · 13-06-14

Originally Posted by xSlAtEx

Can somebody help me? My gameguard won't update, it just gets stuck on Resolving after I press Start Game and then it gives me the error 380. Anybody could help?

PS: I talked with GM Ravenclaw from Acclaim, he said the OpperTools are the GM Tools.

Now it doesn't even get stuck it just skips the gameguard update then gives me error 380 saying this

PSagain: I've disabled all firewalls and antivirus.

Have you changed your host ?

Originally Posted by oodasm

No any update？i will share the full source,My ability is limited,hard to fix source. Wish someone can fix the old source ,than share it.I‘ll be indebted forever.waite uploading...

Thanks

**xSlAtEx** · 14-06-14

Yes, I have modified the hosts files as well, but it still doesn't work, if I try removing the hosts file or putting it back to original, it still doesn't work. I've done everything said in the tutorial, and I cannot get it to work. This game is literally my childhood, and I'd be so grateful to anyone that can help me fix my issue and allow me to run the game and be able to play.

**vitcoi15194** · 17-06-14

how to update new skill for 9dragons US campus????? pls help me

**thaicom05** · 17-06-14

can you help me for

add language : TH = Thailand

for NINEDRAGONS

I can use NDTEXTDB_TH.XSD

but ????????? ?? ?

help me plz thank you

**vitcoi15194** · 17-06-14

How to update icy dungeon and loulan dungeon, any1 here know???

**thaicom05** · 19-06-14

Can you help me plz.

- - - Updated - - -

Can you help me.

I can't connect server

But old client

D9 Version 1100

**xSlAtEx** · 19-06-14

Originally Posted by xSlAtEx

Can somebody help me? My gameguard won't update, it just gets stuck on Resolving after I press Start Game and then it gives me the error 380. Anybody could help?

PS: I talked with GM Ravenclaw from Acclaim, he said the OpperTools are the GM Tools.

Now it doesn't even get stuck it just skips the gameguard update then gives me error 380 saying this

PSagain: I've disabled all firewalls and antivirus.

Bump, someone please help me :/

**oodasm** · 20-06-14

Originally Posted by thaicom05

Can you help me plz.

- - - Updated - - -

Can you help me.

I can't connect server

But old client

D9 Version 1100

dont konw how to fix it, maybe unpack the 9Dragons.exe of the client.than to fix it by ODebug. or not any usefull.

**xSlAtEx** · 20-06-14

soly95 if you have skype add me please, poisonhands, it'd be great to get the game working

**Gilberto Rivera** · 20-06-14

Originally Posted by thaicom05

Can you help me plz.

- - - Updated - - -

Can you help me.

I can't connect server

But old client

D9 Version 1100

the packets login packets of each client is diferent... so dont expect that to be easy to make it work.
also check your serverenv at 9dragons/login/ to point to the right ip, be sure that the apache server is
reachable too. since you is using thailand client please try to translate for us the error message.

- - - Updated - - -

Originally Posted by xSlAtEx

Bump, someone please help me :/

open your host file and be sure that have the 5 lines at the end that points to your apache server ip.
and check that the apache server is working properly too. and you can try to use the gameguard file of another game too.
----------------------------------------------------------------------------------------------------------------------------------------
I want to share this stored procedure that will help you to create special characters:(the gm feature still not works)
1. open mssql magnament studio.
2.Click at " New Query"
3. when the blank query appears paste the following text:

Code:

USE [ND_GAME_0]
GO
/****** Object:  StoredProcedure [dbo].[GM_Maker]    Script Date: 20/06/2014 7:31:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


create PROC [dbo].[GM_Maker_ByEmperor]
/* 인자*/
@acc        varchar(24),        --계정         1 @name     varchar(12),        --캐릭터 이름     2
@gm        smallint, @clan smallint, @class smallint, @class_grade smallint,
@vsex         smallint,        --성별         3 @Consttitution        int,            --생기         4     @Zen         int,            --진기         5 @interlligence    int,            --영기         6 @dexterity     int,            --심기         7
@str         int,            --정기         8
@vhair         smallint,        --머리모양     9
@vface     smallint,        --얼굴모양     10
@vluck        smallint,        -- 운        11 @Vamor    smallint,        --상의        12
@vpants    smallint,        --하의        13 @zone        smallint,
@x        real, @z        real, @Max_life_pw    int,        -- 최대 체력    14 @Max_force_pw    int,        -- 최대 내력    15 @Max_con_pw    int,         -- 최대 영력    16 @Null_space1    smallint,         -- 최대 심력    17 @Null_space2     smallint,         -- 최대 정력    18 @level    smallint,
@BK bigint,
@GK int,
@acc_id    int,        -- 유저의 acc_uid    19
@vunique_id     int     OUTPUT,    --유니크 아이디    20 @Result     int     OUTPUT      --result값    21
AS
DECLARE @Max int, @alreadyName int
DECLARE @table_index INT

SET @alreadyName  = 0
/* 캐릭터 이름 @name 을 조건으로 동명의 다른 컬럼이 존재하는지
 검사한다.(캐릭터 이름의 고유이성을 지켜주기 위해)*/
SELECT @alreadyName = 1  FROM ND_V01_Charac WHERE chr_name = @name   --@@rowcount에 결과컬럼 저장
/* 같은 캐릭터 이름을 같은 컬럼이 이미 존재한다면 
작업을 포기하고 @Result = 1을 OUTPUT하고 종료한다.*/
if @alreadyName > 0
BEGIN
   SET @Result = 1
   RETURN
END
SET @Max = 0
SELECT @Max = count(*) FROM ND_V01_Charac WHERE acc_id = @acc_id  AND delete_flag = 0 - @Max ( 계정이 갖고있는 캐릭터수)
if @Max > 2
BEGIN
   SET @Result = 2
   RETURN
END
SET @Result = 1 
--BEGIN TRAN    --트랜잭션 처리 시작
INSERT ND_V01_Charac
    ([user_id],
    [chr_name],
    [gm],
    [party],
    [class],
    [class_grade],
    [sex],
    [hair],
    [face],
    [luck] ,
    [acc_id])
VALUES 
    (@acc,
    @name,
    @gm,
    @clan,
    @class,
    @class_grade,
    @vsex,
    @vhair,
    @vface,
    @vluck,
    @acc_id)
/* 캐릭터 이름 @name을 조건으로 SELECT 쿼리를 실행하여
해당 캐릭터의 유티크아이디를 OUTPUT 인수 @vUid 로 얻어진다.*/
SELECT  @vunique_id=unique_id FROM ND_V01_Charac WHERE [chr_name] =  @name
/* 위 셀렉트 문으로 얻어진 @vUid(유니크아이디값)를 이용해 4개 테이블을 동시 생성 */

-- 인벤토리 버전 2 에서 추가된 사항.
EXEC DSSP_InvenV2_FindTableIndex @vunique_id, @table_index OUTPUT

INSERT ND_V01_Charac_Level
    (unique_id, max_life_pw, max_force_pw, max_con_pw, constitution, zen, intelligence, dexterity, [str])
    VALUES
    (@vunique_id, @Max_life_pw, @Max_force_pw, @Max_con_pw, @Consttitution, @Zen, @interlligence, @dexterity, @str)
    
    
INSERT ND_V01_CharacState 
    (unique_id, inner_level, gong, honor)
    VALUES
    (@vunique_id, @level, @BK, @GK)


INSERT ND_V01_CurBasicInfo
    (unique_id, zone, x, z, vital_power, inner_power, soul_power, heart_power, stamina_power) 
    VALUES ( @vunique_id, @zone, @x, @z, @Max_life_pw, @Max_force_pw, @Max_con_pw, @Null_space1, @Null_space2)
INSERT ND_V01_Charac_Martial
    (unique_id) VALUES ( @vunique_id)
INSERT ND_V01_Charac_Quest_Data
    (unique_id) VALUES (@vunique_id)
INSERT ND_V01_FriendList
    (unique_id) VALUES (@vunique_id)
INSERT ND_V01_Charac_MailList 
    (unique_id) VALUES(@vunique_id)
INSERT ND_V01_Charac_Nic
    (unique_id) VALUES(@vunique_id)
INSERT ND_V01_Charac_Match
    (unique_id) VALUES (@vunique_id)
INSERT ND_V01_Charac_Effect
    (unique_id) VALUES (@vunique_id)
/*
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 0 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 1 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 2 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 3 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 4 )
*/
--COMMIT TRAN
SET @Result = 0

4. Press F5
5. close the query dont need to save.
6.find the database ND_GAME_0 ----> Programability---> stored procedures and click to expand.
7. find the stored procedure called dbo.GM_Maker do right click and select "execute stored procedure"
8.then the window will appear just fill the values. some of them is output values take care.

maybe someone can insert that stored procedure in C app to make it more easy for people.

**soly95** · 20-06-14

Originally Posted by Gilberto Rivera

the packets login packets of each client is diferent... so dont expect that to be easy to make it work.
also check your serverenv at 9dragons/login/ to point to the right ip, be sure that the apache server is
reachable too. since you is using thailand client please try to translate for us the error message.

- - - Updated - - -

open your host file and be sure that have the 5 lines at the end that points to your apache server ip.
and check that the apache server is working properly too. and you can try to use the gameguard file of another game too.
----------------------------------------------------------------------------------------------------------------------------------------
I want to share this stored procedure that will help you to create special characters:(the gm feature still not works)
1. open mssql magnament studio.
2.Click at " New Query"
3. when the blank query appears paste the following text:

Code:

USE [ND_GAME_0]
GO
/****** Object:  StoredProcedure [dbo].[GM_Maker]    Script Date: 20/06/2014 7:31:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


create PROC [dbo].[GM_Maker_ByEmperor]
/* 인자*/
@acc        varchar(24),        --계정         1 @name     varchar(12),        --캐릭터 이름     2
@gm        smallint, @clan smallint, @class smallint, @class_grade smallint,
@vsex         smallint,        --성별         3 @Consttitution        int,            --생기         4     @Zen         int,            --진기         5 @interlligence    int,            --영기         6 @dexterity     int,            --심기         7
@str         int,            --정기         8
@vhair         smallint,        --머리모양     9
@vface     smallint,        --얼굴모양     10
@vluck        smallint,        -- 운        11 @Vamor    smallint,        --상의        12
@vpants    smallint,        --하의        13 @zone        smallint,
@x        real, @z        real, @Max_life_pw    int,        -- 최대 체력    14 @Max_force_pw    int,        -- 최대 내력    15 @Max_con_pw    int,         -- 최대 영력    16 @Null_space1    smallint,         -- 최대 심력    17 @Null_space2     smallint,         -- 최대 정력    18 @level    smallint,
@BK bigint,
@GK int,
@acc_id    int,        -- 유저의 acc_uid    19
@vunique_id     int     OUTPUT,    --유니크 아이디    20 @Result     int     OUTPUT      --result값    21
AS
DECLARE @Max int, @alreadyName int
DECLARE @table_index INT

SET @alreadyName  = 0
/* 캐릭터 이름 @name 을 조건으로 동명의 다른 컬럼이 존재하는지
 검사한다.(캐릭터 이름의 고유이성을 지켜주기 위해)*/
SELECT @alreadyName = 1  FROM ND_V01_Charac WHERE chr_name = @name   --@@rowcount에 결과컬럼 저장
/* 같은 캐릭터 이름을 같은 컬럼이 이미 존재한다면 
작업을 포기하고 @Result = 1을 OUTPUT하고 종료한다.*/
if @alreadyName > 0
BEGIN
   SET @Result = 1
   RETURN
END
SET @Max = 0
SELECT @Max = count(*) FROM ND_V01_Charac WHERE acc_id = @acc_id  AND delete_flag = 0 - @Max ( 계정이 갖고있는 캐릭터수)
if @Max > 2
BEGIN
   SET @Result = 2
   RETURN
END
SET @Result = 1 
--BEGIN TRAN    --트랜잭션 처리 시작
INSERT ND_V01_Charac
    ([user_id],
    [chr_name],
    [gm],
    [party],
    [class],
    [class_grade],
    [sex],
    [hair],
    [face],
    [luck] ,
    [acc_id])
VALUES 
    (@acc,
    @name,
    @gm,
    @clan,
    @class,
    @class_grade,
    @vsex,
    @vhair,
    @vface,
    @vluck,
    @acc_id)
/* 캐릭터 이름 @name을 조건으로 SELECT 쿼리를 실행하여
해당 캐릭터의 유티크아이디를 OUTPUT 인수 @vUid 로 얻어진다.*/
SELECT  @vunique_id=unique_id FROM ND_V01_Charac WHERE [chr_name] =  @name
/* 위 셀렉트 문으로 얻어진 @vUid(유니크아이디값)를 이용해 4개 테이블을 동시 생성 */

-- 인벤토리 버전 2 에서 추가된 사항.
EXEC DSSP_InvenV2_FindTableIndex @vunique_id, @table_index OUTPUT

INSERT ND_V01_Charac_Level
    (unique_id, max_life_pw, max_force_pw, max_con_pw, constitution, zen, intelligence, dexterity, [str])
    VALUES
    (@vunique_id, @Max_life_pw, @Max_force_pw, @Max_con_pw, @Consttitution, @Zen, @interlligence, @dexterity, @str)
    
    
INSERT ND_V01_CharacState 
    (unique_id, inner_level, gong, honor)
    VALUES
    (@vunique_id, @level, @BK, @GK)


INSERT ND_V01_CurBasicInfo
    (unique_id, zone, x, z, vital_power, inner_power, soul_power, heart_power, stamina_power) 
    VALUES ( @vunique_id, @zone, @x, @z, @Max_life_pw, @Max_force_pw, @Max_con_pw, @Null_space1, @Null_space2)
INSERT ND_V01_Charac_Martial
    (unique_id) VALUES ( @vunique_id)
INSERT ND_V01_Charac_Quest_Data
    (unique_id) VALUES (@vunique_id)
INSERT ND_V01_FriendList
    (unique_id) VALUES (@vunique_id)
INSERT ND_V01_Charac_MailList 
    (unique_id) VALUES(@vunique_id)
INSERT ND_V01_Charac_Nic
    (unique_id) VALUES(@vunique_id)
INSERT ND_V01_Charac_Match
    (unique_id) VALUES (@vunique_id)
INSERT ND_V01_Charac_Effect
    (unique_id) VALUES (@vunique_id)
/*
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 0 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 1 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 2 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 3 )
INSERT ND_V03_Dismantle_Bag ( cuid, slot ) VALUES ( @vunique_id, 4 )
*/
--COMMIT TRAN
SET @Result = 0

4. Press F5
5. close the query dont need to save.
6.find the database ND_GAME_0 ----> Programability---> stored procedures and click to expand.
7. find the stored procedure called dbo.GM_Maker do right click and select "execute stored procedure"
8.then the window will appear just fill the values. some of them is output values take care.

maybe someone can insert that stored procedure in C app to make it more easy for people.

don't expect anything related to GM will work without the GM client, this GMs Features sadly isnt a command lines that will be written into the console like most of the games, there is built-in app (like Oper_Tool) in the client that do the following :-

1. Teleport

2. Mob / Boss Spawns

3. Invisibility

4. And many features isn't included in the Oper_tool

so without even the old client source of the GM_Client, logging into GM Character is a dream

@Slate :- can u tell me what you want in a PM :), Please ?

**xSlAtEx** · 20-06-14

Originally Posted by Gilberto Rivera

- - - Updated - - -

open your host file and be sure that have the 5 lines at the end that points to your apache server ip.
and check that the apache server is working properly too. and you can try to use the gameguard file of another game too.
----------------------------------------------------------------------------------------------------------------------------------------

As you saw, I cannot get my gameguard to patch itself, it always gives me the same error, and I have no clue how to fix it. I have edited my host files and I don't get why it's not working. My antivirus and firewall are both disabled while testing and no luck.

**elco** · 20-06-14

Originally Posted by xSlAtEx

As you saw, I cannot get my gameguard to patch itself, it always gives me the same error, and I have no clue how to fix it. I have edited my host files and I don't get why it's not working. My antivirus and firewall are both disabled while testing and no luck.

dont forget this step

Launch the ndreg Editor contained inside the client

write your vm ip address into:
Status server
Login Server

rin as administrator if het does not save.

**Devyn Jones** · 21-06-14

I try to edit ndreg and did it in administrator mode it changes when I open ndlauncher this is very irritating. How do you fix it??

Edit: fixed had to edit PATCH.PSC in apachee forgot the 2 other ips :D

**xSlAtEx** · 21-06-14

I have modified those as well, but I'm using my own PC as the localhost, because it would not work on a VM either.

How to make the 9dragons US Server files working.

Thread Tools

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Re: [Tutorial] : How to make 9dragons US Server file working.

Advertisement