Welcome!

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!

Join Today!

[Guide]Converting EP3 DB to EP4 DB

Status
Not open for further replies.
Joined
May 12, 2008
Messages
2,547
Reaction score
437
REMINDERS BACK UP FIRST YOUR DATA BASE

1.ADD COLLUMS In rangame1>ChaInfo.. ChaSex [Int] Nulls , ChaHairStyle [Int] Nulls, ChaHairColor [Int] Nulls,

2.DOWNLOAD THE EP4 RanGame1 DATABASE SCRIPT AND EXECUTE
THIS SCRIPT DONT HAVE PET TABLE OR SP_PETS



3.OPEN MSSQL THEN OPEN THE TABLE OF RANUSER>Programmability>Stored Procedures>dbo.user_verify right click then MODIFY

THEN REPLACE THIS SCRIPT...

Code:
USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[user_verify] Script Date: 06/28/2008 00:18:31 ******/
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,
@dummy1 int,
@dummy2 int,
@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

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 眉农...
IF @nUserNum = 0
BEGIN
-- ID / PWD 阂老摹 肚绰 荤侩阂啊瓷惑怕
SET @nReturn = 0
RETURN @nReturn
END
ELSE
BEGIN
-- ID / PWD 老摹
SET @nReturn = 1
-- 5 吝汗立加, 捞固 立加登绢 乐澜
IF @nState = 1
BEGIN
SET @nReturn = 5
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
4.DOWNLOAD THIS PHP SCRIPT TO CHANGE THE NORMAL PASSWORD TO MD5 HASH PASSWORD ALL USERACCOUNT



MEDIAFIRE =


AND TRY TO LOG IN..
haha:punch:

Credits:

PDF Team
RZ EP4 Team


 

Attachments

You must be registered for see attachments list
Last edited:
Initiate Mage
Joined
Dec 15, 2006
Messages
91
Reaction score
0
Re: [guide]convert ep3 database to ep4 database

bahhh, this thread is already discussed too, take note... he didnt put any credits..
 
Saucepan
Member
Joined
Jun 16, 2008
Messages
710
Reaction score
29
Re: [guide]convert ep3 database to ep4 database

Copy again how many copies you will do???
 
Initiate Mage
Joined
Dec 15, 2006
Messages
91
Reaction score
0
Re: [guide]convert ep3 database to ep4 database

he'll keep on copying files.. lets make a bet, not only ragezone forum he'll gonna post some leech ^_^
 
Junior Spellweaver
Joined
Feb 5, 2008
Messages
117
Reaction score
2
Re: [guide]convert ep3 database to ep4 database

nyay copy and paste wakokokok
 
Experienced Elementalist
Joined
Oct 26, 2007
Messages
296
Reaction score
0
Re: [guide]convert ep3 database to ep4 database

not so bad....always make a review of this guide every week
 
Initiate Mage
Joined
Dec 15, 2006
Messages
91
Reaction score
0
Re: [guide]convert ep3 database to ep4 database

well lets just say, a review.. but the prob is.. ders no credit, i know hus the original poster of that.. ^_^
 
Initiate Mage
Joined
Mar 11, 2007
Messages
57
Reaction score
0
Re: [guide]convert ep3 database to ep4 database

@TS

nice copy..
 
Junior Spellweaver
Joined
Jul 4, 2008
Messages
193
Reaction score
0
Re: [guide]convert ep3 database to ep4 database

@TS
y u always leeching files?
 
Status
Not open for further replies.
Back
Top