- 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...
4.DOWNLOAD THIS PHP SCRIPT TO CHANGE THE NORMAL PASSWORD TO MD5 HASH PASSWORD ALL USERACCOUNT
MEDIAFIRE =
AND TRY TO LOG IN..
hahaunch:
Credits:
PDF Team
RZ EP4 Team
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
You must be registered to see links
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
MEDIAFIRE =
You must be registered to see links
AND TRY TO LOG IN..
hahaunch:
Credits:
PDF Team
RZ EP4 Team
Attachments
You must be registered for see attachments list
Last edited: