Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Re: [Tutorial] : How to make 9dragons US Server file working.
[ok, you say to remove a check in it but what check would that be?
QUOTE=soly95;8034103]With a good Compiler, compile the Game sever and remove a check in it it will fix the drop bug same method will make FL and Whispering works
Good Luck.
You Prolly Changed the Game Server with one (older or newer) that not synced with your client version, hence u get Login Problems[/QUOTE]
I tryed to inject that script you wrote to make '' GM '' Accounts in my SQL 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
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
And It gives me this error:
Msg 156, Level 15, State 1, Procedure GM_Maker_ByEmperor, Line 25
Incorrect syntax near the keyword 'AS'.
Msg 137, Level 15, State 2, Procedure GM_Maker_ByEmperor, Line 32
Must declare the scalar variable name".
Msg 137, Level 15, State 1, Procedure GM_Maker_ByEmperor, Line 37
Must declare the scalar variable result".
Msg 102, Level 15, State 1, Procedure GM_Maker_ByEmperor, Line 41
Incorrect syntax near '계정이'.
Msg 137, Level 15, State 1, Procedure GM_Maker_ByEmperor, Line 44
Must declare the scalar variable result".
Msg 137, Level 15, State 1, Procedure GM_Maker_ByEmperor, Line 47
Must declare the scalar variable result".
Msg 137, Level 15, State 2, Procedure GM_Maker_ByEmperor, Line 63
Must declare the scalar variable name".
Msg 137, Level 15, State 2, Procedure GM_Maker_ByEmperor, Line 75
Must declare the scalar variable name".
Msg 137, Level 15, State 2, Procedure GM_Maker_ByEmperor, Line 84
Must declare the scalar variable Max_force_pw".
Msg 137, Level 15, State 2, Procedure GM_Maker_ByEmperor, Line 90
Must declare the scalar variable level".
Msg 137, Level 15, State 2, Procedure GM_Maker_ByEmperor, Line 95
Must declare the scalar variable "@zone".
Msg 137, Level 15, State 1, Procedure GM_Maker_ByEmperor, Line 118
Must declare the scalar variable result".
Re: [Tutorial] : How to make 9dragons US Server file working.
Hai All ...
I am new here, and I want to try build this 9Dragons Server
First
I want to ask permision from Mr Zero for downloading the files and his tutorial
Second
I got problem when try to download US Server Files From Mr str8killa with this link https://mega.co.nz/#!QcQ1hIpZ!JpvVJH...n4Er8-KNZl44_0
it said the file no longer available
can anyone reupload or give other link for this server files
Third
Thank You for all that sharing and post about this 9Dragons Server Development