[Share] Ep7 V1 Server Files And Client

[dev02]

My 1st time to share server filestt1:

You must be registered to see links

MD5 Password - No china region

* Fully Working Btg

* Working Item Mixing

You can implement anti cheat on the game.exe by following TearHear18 shared guide

For client:
Ep7 v1 client(from alamo2007)

*Client by Parts

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

Default.charclass & coment.ini

You must be registered to see links

* Features:
Item mixing,Attendance system,CDM(use brain to make it work),Quest on Maps and Npc's, Bonus Time Gaude, etc..

* Just edit the default.charclass and use your own commment.ini and its ready to play on..

Note: To make this client better..you can use your own items.isf,Skill.ssf and Crow,mnsf and use your own default.charclass..


Approved:*:..
Thanks to
Alamo2007 = client
Geger009 = instructions
Seifer = Clues and fix
Jolin = Ep7 Source Code


FIX FOR ERROR

"DB:Exec sp_UserAttendLog 6108
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'sp_UserAttendLog'.
ERROR:Read Attend list failed"

.
= "EXECUTE THIS ON DATABASE"

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_UserAttendLog ] Script Date: 07/17/2011 07:41:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_UserAttendLog ]
@nUserNum int

AS
DECLARE
@error_var int,
@rowcount_var int

SET NOCOUNT ON
Select (MSum-MS) As M, (FSum-FS) As F
From
(
Select isnull(Sum(M),0) As MSum, isnull(Sum(F),0) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
From
(
Select ChaClass
,
Case ChaClass
When 1 Then 1
When 2 Then 1
When 256 Then 1
When 512 Then 1
Else 0
End As M
,
Case ChaClass
When 4 Then 1
When 8 Then 1
When 64 Then 1
When 128 Then 1
Else 0
End As F
,
Case ChaClass
When 16 Then
Case ChaDeleted
When 4 Then 0
Else 1
End
Else 0
End As MS
,
Case ChaClass
When 32 Then
Case ChaDeleted
When 4 Then 0
Else 1
End
Else 0
End As FS
From ChaInfo
) As t
) As tt
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ERROR ON LOG IN

EXECUTE THIS ON DATABASE

Quote:
USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[user_verify] Script Date: 07/17/2011 09:58:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[user_verify]
@userId char(25),
@userPass char(25),
@userIp char(25),
@SvrGrpNum int,
@SvrNum int,
@proPass varchar(6), -- Ran dynamic password
@proNum varchar(2), -- Ran dynamic password random number
@nReturn int OUTPUT

AS
DECLARE
@nAvailable int,
@nUserNum int,
@nState int,
-- Declare variables used in error checking.
@error_var int,
@rowcount_var int,
@nBlock int,
@BlockDate datetime,
@EndDate datetime,
@StrSql nvarchar(100)

SET NOCOUNT ON

SET @nReturn = 0
SET @nUserNum = 0

SELECT @nUserNum=UserInfo.UserNum,
@nState=UserInfo.UserLoginState,
@nBlock=UserInfo.UserBlock,
@BlockDate=UserInfo.UserBlockDate

FROM UserInfo
WHERE UserID = @userId AND UserPass = @userPass AND UserAvailable = 1


-----------------------------------------------------------------
-- ID / PWD check...
IF @nUserNum = 0
BEGIN
SET @nReturn = 0
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 1
IF @nState = 1
BEGIN
SET @nReturn = 5
RETURN @nReturn
END
END


IF (SELECT COUNT(*) FROM BlockAddress WITH (NOLOCK) WHERE BlockAddress = @userIp) > 0

BEGIN
declare @params as nvarchar(100)
SET @StrSQL = 'SELECT @ordercnt=count(userid) FROM Randpass WHERE userid='''+@userId+''' AND pwd'+@proNum + '='''+@proPass + ''''
SET @params = '@ordercnt as int OUTPUT' -- OUTPUT ???? ??

exec sp_executesql @StrSQL, @params, @ordercnt = @rowcount_var OUTPUT

SELECT @error_var = @@ERROR
IF @error_var = 0 AND @rowcount_var = 1
BEGIN
SET @nReturn = 1 -- Dynamic password correct
END
ELSE
BEGIN
SET @nReturn = 7 -- Dynamic password error
RETURN @nReturn
END
END


-----------------------------------------------------------------
-- IP Address ??
IF (SELECT COUNT(*) FROM IPInfo WITH (NOLOCK) WHERE ipAddress = @userIp) > 0
-- IP ?? ??
BEGIN
SELECT @nAvailable = useAvailable
FROM IPInfo
WHERE ipAddress = @userIp

IF @nAvailable = 1
BEGIN
SET @nReturn = 2 -- ID/PWD ? ????, IP ? ????
END
ELSE
BEGIN
SET @nReturn = 4 -- ID/PWD ? ????, IP ? ????? ??
END
END
ELSE
-- IP ?? ??
BEGIN
SET @nReturn = 3 -- ID/PWD ? ????, IP ??? ??
END

-----------------------------------------------------------------
-- Block ?? ??
IF (@nBlock = 1)
BEGIN
IF (@BlockDate > GetDate())
BEGIN
SET @nReturn = 6
END
ELSE
BEGIN
UPDATE UserInfo
SET UserBlock=0
WHERE UserNum = @nUserNum

SET @nReturn = 2
END
END

-----------------------------------------------------------------
-- ??? ???? ??
IF (@nReturn = 1) OR (@nReturn = 2) OR (@nReturn = 3)
BEGIN
-- ???, ??? ????? ??
UPDATE UserInfo
SET UserLoginState=1, LastLoginDate=getdate(), SGNum=@SvrGrpNum, SvrNum=@SvrNum
WHERE UserNum = @nUserNum

-- ???? ???
INSERT INTO LogLogin (UserNum, UserID, LogInOut, LogIpAddress)
VALUES (@nUserNum, @userId, 1, @userIp)

-- ?? ????
UPDATE StatLogin
SET LCount = LCount+1
WHERE LYear=Year(GetDate()) AND LMonth=Month(GetDate()) AND LDay=Day(GetDate()) AND LHour=DatePart(hour, GetDate())

SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
INSERT INTO StatLogin (LYEAR)
VALUES (YEAR(GetDate()))
END
END

SET NOCOUNT OFF

RETURN @nReturn

NOT VALID SERVER ID
* Open glogic.rcc and look for maplist.ini..open maplist.ini with ReEditor

Number of Field server:
1 Field = 0 Flag
2 Field = 0, 1 Flag
3 Field = 0, 1, 2 Flag


So if your using 1 Field Server so replace all flags to 0
// [MAPNAME]---------------- [M,S]---- [F-SVR] [FLAGS] [NAME] [BGM]innerzone_21.lev------------ [4,0]-----[0] [1,0,0,0,1] [MP_Campus1F] sepi.oggw_school_02.Lev------------ [5,0]-----[0] [0,0,0,0,1] [MP_Campus] m7a.oggw_school_02_in_08.Lev---- [120,0]---[0] [0,0,0,0,1] [StudyRoom2] sepi.ogg

GLguidance () Guide5

Open default.chaclarss with ReEditor
find this

GUIDANCE_FILE guid01.ini
GUIDANCE_FILE guid02.ini
GUIDANCE_FILE guid03.ini
GUIDANCE_FILE guid04.ini

add

GUIDANCE_FILE guid05.ini

SUDDEN SHUTDOWN(Mostly W7)

Run your launcher as Admin.
Can Anyone Share the Full skills of Ran Ph..if you have../..Please

 

[apang]

Re: Ep7 V1 Server Files And Client

ty very much sir.....

 

[mervin15]

Re: Ep7 V1 Server Files And Client

sir can u upload it on another site? cause i cant download it on megaupload!

 

[dev02]

Re: Ep7 V1 Server Files And Client

The file is not on megaupload..its on medifire..

 

[mervin15]

Re: Ep7 V1 Server Files And Client

the client,

 

[deadz112]

Re: Ep7 V1 Server Files And Client

out of the topic..
are you using gmc for ep7 v1? ..
can u share it here pls i really nid it badly

 

[sintonizaire]

Re: Ep7 V1 Server Files And Client

is the server files same as the compiled one from sir jollin's source code?

or you already modify it?

 

[dev02]

Re: Ep7 V1 Server Files And Client

@ Mervin15 wait ill upload by parts..dont have pro account in mediafire..
@Deadz112..there is one shared here at rz for ep7..but im using ep6 Gmc as of now...

@sintonizaire
This came from the Source Code Korean_release..Jolin shared Server files Rev3 was China_release..

 

[IamDJDRB]

Re: Ep7 V1 Server Files And Client

@TS ..
Does it need TWO PC to play ?

 

[dev02]

Re: Ep7 V1 Server Files And Client

@essaeypride
Sorry..Din't tried it yet coz im running it on my DDS,,

 

[IamDJDRB]

Re: Ep7 V1 Server Files And Client

and one more question..
does it GY Skills ?? correct me if wrong thnx

 

[sintonizaire]

Re: Ep7 V1 Server Files And Client

@ Mervin15 wait ill upload by parts..dont have pro account in mediafire..
@Deadz112..there is one shared here at rz for ep7..but im using ep6 Gmc as of now...

@sintonizaire
This came from the Source Code Korean_release..Jolin shared Server files Rev3 was China_release..

so the server files was direct compiled EXE from sir jollin's code?

 

[dev02]

Re: Ep7 V1 Server Files And Client

@essaeypride
You can use your own Skill.ssf or any skill.sff..

@sintonizaire
Yes it was from Jolin Source Code..Its the compiled Korean_release version...

 

[deadz112]

Re: Ep7 V1 Server Files And Client

@dev02
are you using bk's gmc? the one for ep6 s2?

 

[dev02]

Re: Ep7 V1 Server Files And Client

@deadz112

You must be registered to see links

try that sir..

 

[deadz112]

Re: Ep7 V1 Server Files And Client

thanks =)
one last question ..
what client are you using

 

[dev02]

Re: Ep7 V1 Server Files And Client

@deadz112
Im using Ran Ph client for testing"already shared by Alamo2007"

 

[deadz112]

Re: Ep7 V1 Server Files And Client

thanks

 

[apang]

Re: Ep7 V1 Server Files And Client

sir can i ask..in param.ini when i change it to my ip theres an error [GAME TEXT OVER FLOW] ect...any tip sir? ty

 

[dev02]

Re: Ep7 V1 Server Files And Client

@apang

Change the Gui..ill upload mine..wait..

You must be registered to see links