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.
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.
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
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.
Spoiler:
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)
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 ???? ??
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
-- ?? ????
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
Spoiler:
Create a new query in RanGame1 and Execute the script.
Spoiler:
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
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.
Spoiler:
Instruction: Please replace your xml's inside gui with the above file. Edit also your param.ini with "PE" as your language. Thank you.
re: Official Guide Making Ran Online Episode 7 Gunner Server
Since this is a guide,
Thread moved.
19-01-12
jambrong
re: Official Guide Making Ran Online Episode 7 Gunner Server
Don't forget, using WAN or IP Public
if you're using LAN IP, field server and agent server will crash.......
(too bad I don't have any server to try this....) :(::(::(::(:
19-01-12
SkyLerZz
re: Official Guide Making Ran Online Episode 7 Gunner Server
nice guide
19-01-12
terryz1619
re: Official Guide Making Ran Online Episode 7 Gunner Server
Removed
20-01-12
Vision
re: Official Guide Making Ran Online Episode 7 Gunner Server
Very detailed guide. What's that robot costume name?
20-01-12
tearhear18
re: Official Guide Making Ran Online Episode 7 Gunner Server
great share ,, however crash issues still exist ..
20-01-12
terryz1619
re: Official Guide Making Ran Online Episode 7 Gunner Server
Removed
20-01-12
tearhear18
re: Official Guide Making Ran Online Episode 7 Gunner Server
not really.... i take a look this file in olly,. then i found something bad.. 20% analyze here is i found.
it connect to something IP xx.xx.xx.xx
then remote those config/lib/plug in or i dont know exactly that file
when you run exe. it connect to hidden ip, then sounds like authentication method... this a part of copyright..
"be carefull" hehe
NOTE NOTE NOTE: I just base it on my analysis!! no worries unless someone have a proof.
20-01-12
SkyLerZz
re: Official Guide Making Ran Online Episode 7 Gunner Server
when right click the pet card , the pet won't come out
is it bug or what ? do anybody have solution for this ?
20-01-12
terryz1619
re: Official Guide Making Ran Online Episode 7 Gunner Server
Removed
20-01-12
Eureka7
re: Official Guide Making Ran Online Episode 7 Gunner Server
if you will only test this in your home. (disconnect from the internet to avoid getting caught :)))) as what tearhear said. it connects to hidden ip :)
20-01-12
SkyLerZz
re: Official Guide Making Ran Online Episode 7 Gunner Server
Quote:
Originally Posted by Eureka7
if you will only test this in your home. (disconnect from the internet to avoid getting caught :)))) as what tearhear said. it connects to hidden ip :)
more detailed ? sorry I am noob in english
20-01-12
Eureka7
re: Official Guide Making Ran Online Episode 7 Gunner Server
as what the other dev said.
Quote:
not really.... i take a look this file in olly,. then i found something bad.. 20% analyze here is i found.
it connect to something IP xx.xx.xx.xx
then remote those config/lib/plug in or i dont know exactly that file
when you run exe. it connect to hidden ip, then sounds like authentication method... this a part of copyright..
"be carefull" hehe
NOTE NOTE NOTE: I just base it on my analysis!! no worries unless someone have a proof.
20-01-12
Asero1933
re: Official Guide Making Ran Online Episode 7 Gunner Server
