[Share] Ep7 V1 Server Files And Client

[dev02]

My 1st time to share server files
Server files + game.exe

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
Part 1
Part 2
Part 3
Part 4

Default.charclass & coment.ini
download me
* 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

[MentaL]

[apang]

ty very much sir.....

[mervin15]

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

[dev02]

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

[mervin15]

the client,

[deadz112]

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

[sintonizaire]

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

or you already modify it?

[dev02]

@ 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]

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

[dev02]

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

[IamDJDRB]

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

[sintonizaire]

@ 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]

@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]

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

[dev02]

@deadz112
EP6 GMC

try that sir..