- Joined
- Sep 29, 2010
- Messages
- 139
- Reaction score
- 46
Setting up an Episode 7 Version 1 RAN Gunner Server
1. Download and instal :
You must be registered to see links
2. Download and install :
You must be registered to see links
3. Download ONLY (important: wait for my further instructions on how you install this later) Microsoft SQL Server 2005 Express Edition. Before you download this program, you should first check the "service pack" of your computer if it has. To check that, go to Start> Right Click 'My Computer' > Properties > Under the 'General' Tab, at the bottom of the 'System' column, there you can see if your computer has a service pack and what version it is. After knowing your service pack, you may finally download MSQL 2005 Express Edition.
For Service Pack 4 :
You must be registered to see links
For Service Pack 3 :
You must be registered to see links
For Service Pack 2 :
You must be registered to see links
No Service Pack :
You must be registered to see links
4. After downloading the MSQL 2005 Express Edition with the right Service Pack compatible with your computer. Install it
Here is the video guide : Installing Microsoft SQL Server 2005 Express Edition
5. Last to download is the SQL Server Management Studio Express Service. It's download is the same as the MSQL 2005 Express Edition that you'll gonna match the service pack with your computer.
For Service Pack 4 :
You must be registered to see links
For Service Pack 3 :
You must be registered to see links
For Service Pack 2 :
You must be registered to see links
No Service Pack :
You must be registered to see links
6. The easiest step is installing SQL Server Management Studio Express Service. You're gonna do nothing but hit the 'next' button till you finish the installation.
Here is the video guide : Installing SQL Server Management Studio
Game Client : Download Game Client
Server Files :
You must be registered to see links
Database :
You must be registered to see links
All Editors :
You must be registered to see links
Glogicserver :
You must be registered to see links
GMCharEdit :
You must be registered to see links
Note : For the server files :
Hex the server files, then search this IP : 222.222.222.222.
Then change it to your own IP
you can use this :
Guide for Hexing : How to hex server files (hamachi)
Then change it to your own IP
you can use this :
You must be registered to see links
for editing the server filesGuide for Hexing : How to hex server files (hamachi)
Server screenshot (server side - tested by me) :
This server files is working for me, why not you ? :laugh:
Fix for some error
Error 1 : Character data failed to be processed ! - Shared by Dev02
Error 2 : No gunner class on character creation - shared by Essaeypride
Error 3 : Vending bug. - Shared by Vision
What's this bug about? You'll be disconnected in-game when someone buy's in you when vending.
Error 4 : item without proper name (IN_018_042) and no icon skill icon
Error 5 : No server list on selection menu
Solution : Run the Server correctly (Session-Login-Field-Agent)
Error 6 : Error on deleting character
1. This is the problem of ep7 server files. we cannot delete the character.
2. The problem maybe is the database.. and the gui/xml source.. (who knows) :laugh:
3. Make ur own function to delete char on cp
Solution 1 : You need 2 PC or use Virtual Machine for single PC
Guide how to use set up virtual machine - by LatneM/
Solution 2 : If you already have 2 pc or use Virtual machine but still "Data failed to be processed" Create a new query in RanUser and Execute the script.
Guide how to use set up virtual machine - by LatneM/
Solution 2 : If you already have 2 pc or use Virtual machine but still "Data failed to be processed" Create a new query in RanUser and Execute the script.
Code:
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
Error 2 : No gunner class on character creation - shared by Essaeypride
Create a new query in RanGame1 and Execute the script.
Code:
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 01/30/2012 21:22:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_Extreme]
@nUserNum int
AS
DECLARE
@error_var int,
@rowcount_var int
SET NOCOUNT ON
Select 9 As M, 9 As F
From
(
Select isnull(Sum(M),1) As MSum, isnull(Sum(F),1) 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 1 Then 0
Else 1
End
Else 0
End As MS
,
Case ChaClass
When 32 Then
Case ChaDeleted
When 1 Then 0
Else 1
End
Else 0
End As FS
From ChaInfo Where UserNum=@nUserNum And (
( ChaClass=16 OR ChaClass=32 ) OR
( ( ChaClass=1 OR ChaClass=2 OR ChaClass=4 OR ChaClass=8 OR
ChaClass=64 OR ChaClass=128 OR ChaClass=256 OR ChaClass=512 ) AND ChaLevel>=0 ) )
) As t
) As tt
What's this bug about? You'll be disconnected in-game when someone buy's in you when vending.
Instruction: Please replace your xml's inside gui with the above file. Edit also your param.ini with "PE" as your language. Thank you.
Download File:
Download File:
You must be registered to see links
Error 4 : item without proper name (IN_018_042) and no icon skill icon
item without proper name (IN_018_042) and no icon skill icon
screenshot :
item without proper name (IN_018_042)
some gunner class skill have no icon...
Solution : you need to add the item name (inside ItemStrTable.txt) and skill's icon (ran/textures/gui) MANUALLY
screenshot :
item without proper name (IN_018_042)
some gunner class skill have no icon...
Solution : you need to add the item name (inside ItemStrTable.txt) and skill's icon (ran/textures/gui) MANUALLY
Error 5 : No server list on selection menu
Solution : Run the Server correctly (Session-Login-Field-Agent)
Error 6 : Error on deleting character
1. This is the problem of ep7 server files. we cannot delete the character.
2. The problem maybe is the database.. and the gui/xml source.. (who knows) :laugh:
3. Make ur own function to delete char on cp
In Game Screenshot
Credits: neomaster (neomastei2), Blazedex Development.
Last edited: