Selamat datang Guest!

Anda belum login untuk melihat isi forum ini .
Jika belum login silahkan Klik ''Login" Dibawah ini !

Jika anda belum terdaftar, Silahkan Klik ''Register'' Dibawah Ini !
Terimakasih -
ChibiOnline Team -



 
IndeksCalendarGalleryFAQPencarianAnggotaPendaftaranLogin

Share | 
 

 Create Ran Offline EP7

Topik sebelumnya Topik selanjutnya Go down 
PengirimMessage
perhat22
Sgt. 1st Class Grade 1
Sgt. 1st Class Grade 1


Jumlah Posting Jumlah Posting : 385
Join Date Join Date : 13.05.11
Age Age : 26
Lokasi Lokasi : ****

PostSubyek: Create Ran Offline EP7   Mon Mar 05, 2012 7:28 pm

SORRY INGGRIS


EP7 Gunner Server Files + RaceRan Client ( do at your own risk )


Setting up an Episode 7 Version 1 RAN Gunner Server

I. Required Softwares:

1. Download and instal : [You must be registered and logged in to see this link.]
2. Download and install : [You must be registered and logged in to see this link.]

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 and logged in to see this link.]
For Service Pack 3 : [You must be registered and logged in to see this link.]
For Service Pack 2 : [You must be registered and logged in to see this link.]
No Service Pack : [You must be registered and logged in to see this link.]

4. After downloading the MSQL 2005 Express Edition with the right Service Pack compatible with your computer. Install it

Hehe is the video guide :

[You must be registered and logged in to see this link.]
[You must be registered and logged in to see this link.]




EP7 Gunner Server Files + RaceRan Client ( do at your own risk )



Setting up an Episode 7 Version 1 RAN Gunner Server

I. Required Softwares:

1. Download and instal : [You must be registered and logged in to see this link.]
2. Download and install : [You must be registered and logged in to see this link.]

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 and logged in to see this link.]
For Service Pack 3 : [You must be registered and logged in to see this link.]
For Service Pack 2 : [You must be registered and logged in to see this link.]
No Service Pack : [You must be registered and logged in to see this link.]

4. After downloading the MSQL 2005 Express Edition with the right Service Pack compatible with your computer. Install it

Hehe is the video guide :


[You must be registered and logged in to see this link.]


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 and logged in to see this link.]
For Service Pack 3 : [You must be registered and logged in to see this link.]
For Service Pack 2 : [You must be registered and logged in to see this link.]
No Service Pack : [You must be registered and logged in to see this link.]

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.

Hehe is the video guide : [You must be registered and logged in to see this link.]
[You must be registered and logged in to see this link.]

II. Server Files:
1. Download : [You must be registered and logged in to see this link.] NO PASSWORD< LEAVE IT BBLANK

Great thanks to 3rdPegasus for sharing the server files





Quote:

to change IP

change IP in cfg


and change IP in all server files

hex it search 222.222.222.222

change to you Ip

you can use this : [You must be registered and logged in to see this link.]


I've try this and its work !

ss :




2. Download [You must be registered and logged in to see this link.]




Quote:

Guide using Neo Tools ( by McX )

1.In The 1st Browse Button(BROWSE The itemstable,skillstable or Any File You Want To Decryp of RR's Glogic.rcc)
2. In The 2nd browse Button Where the File SHould be Save any Destination its up To you : ))

3. 3rd Click The Decryp Button To Decryp The FIle
4. 4th step: Open Reeditor4.exe and browse The Itemstable,Skillstable or The File You Want To Decryp..(WALLA ITS DECYPTED : ))

How To Encryp The FIles Again
1. 1st Browse The itemstable,SKillstable or The File You Want TO Encryp
of RR's Glogic.rcc(DECRYPTED ALREADY) Using The Cryptic Tool.Exe.

Click The Encryp Button To Re Encryp The File Again : ))

Its That SImple!!

TAKE NOTE THERE SOME FUNCTIONS ALSO SO YOU CAN SEE
.rcc,.bin,.wld,.x,textures,packtest,item.isf And Etc .... Explore Other
Function You Can Do It So You Can Learn Also By Your Selve'S


3. Download : [You must be registered and logged in to see this link.] ( by raminspo )

To avoid error on database, execute this ( thnx to dev02 for the script )

FIX FOR ERROR



Quote:
"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"




Quote:

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


4. How to make it work

follow essaeypride guide :




Quote:

Add this to your dbo.Chainfo

ChaCP,SumMain,SumSub

I dont know if what data type try ..

ChaCP - Bigint - Null
SumMain - int - Null
SumSub - int - Null

Try try try :)


5. Download : [You must be registered and logged in to see this link.] ( this glogicserver compatible with raceran client, so no error about open period.ini )

Client :




other mirror :

uploaded by dmc0105 : [You must be registered and logged in to see this link.]

people who already make it work : jemce025, Seifer13, zentrixph, ( sorry if forgot to put the others ) need rush posting this

some ss :

















If you want to test the client,

extract [You must be registered and logged in to see this link.] to raceran client,

you can try :

Login ID : terryz
Password : terryz1619

thx to everybody who shared this files,



DO THIS BY YOUR OWN RISK !
LEAVING RZ AWHILE..GOT TO CONTINUE WORKING...

SORRY FOR MY BAD ENGLISH

RZ, MORE POWER

___________________________________________________________________

---== QqnetCraft ==---
IP : QqCRAFT.chickenkiller.com
: 118.96.107.4:25565
-----------------------------------------------------------
Di buka lowongan sukarelawan server dan website kami

Minecraft :
- Peramai Server ( 4 Orang )
- Penata Plugin ( 3 Orang )
- Penata Map ( 5 Orang )

Website :
- Penata Template ( 3 Orang )
- Penata Forum ( 6 Orang )
- Staff 2 Jam sekali ( 15 Orang )
------------------------------------------------------------
Silahkan Kontak Saya Jika Kalian Ingin Mendaftarkan Diri.
Kembali Ke Atas Go down
Lihat profil user http://www.qqnetcommunity.com/
Boy Natural
Sgt. 1st Class Grade 1
Sgt. 1st Class Grade 1
avatar

Jumlah Posting Jumlah Posting : 413
Join Date Join Date : 21.05.11
Age Age : 19
Lokasi Lokasi : Jakarta

PostSubyek: Re: Create Ran Offline EP7   Wed Mar 07, 2012 8:37 pm

nah yg ini lgi gw cri2 , 1 cendol buat ente

___________________________________________________________________



Kembali Ke Atas Go down
Lihat profil user
pigar
Traniee
Traniee
avatar

Jumlah Posting Jumlah Posting : 1
Join Date Join Date : 23.05.12
Age Age : 20
Lokasi Lokasi : bekasi

PostSubyek: Re: Create Ran Offline EP7   Wed May 23, 2012 1:03 pm

Gan itu server online apa offline..
mohon penjelasan nya
Kembali Ke Atas Go down
Lihat profil user
murry90
Traniee
Traniee
avatar

Jumlah Posting Jumlah Posting : 1
Join Date Join Date : 27.05.12
Age Age : 26
Lokasi Lokasi : jakarta

PostSubyek: Re: Create Ran Offline EP7   Sun May 27, 2012 4:37 pm

kga ngerti niih yg di jelasin nya :D
Kembali Ke Atas Go down
Lihat profil user
Dachomeeboon
Traniee
Traniee
avatar

Jumlah Posting Jumlah Posting : 1
Join Date Join Date : 26.07.12
Age Age : 24
Lokasi Lokasi : Bangkok

PostSubyek: Re: Create Ran Offline EP7   Thu Jul 26, 2012 12:42 am

I Love Indonesia
Kembali Ke Atas Go down
Lihat profil user
erizawa
Traniee
Traniee
avatar

Jumlah Posting Jumlah Posting : 1
Join Date Join Date : 12.09.12
Age Age : 23
Lokasi Lokasi : indonesia

PostSubyek: Re: Create Ran Offline EP7   Wed Sep 12, 2012 1:25 pm

itu glogicservernya link downloadnya mty gan
Kembali Ke Atas Go down
Lihat profil user
helmihel
Traniee
Traniee
avatar

Jumlah Posting Jumlah Posting : 1
Join Date Join Date : 13.02.14
Age Age : 22
Lokasi Lokasi : Jl Bantaran gan

PostSubyek: Re: Create Ran Offline EP7   Thu Feb 13, 2014 9:50 pm

Ini Client RaceRannya mana ?
Kembali Ke Atas Go down
Lihat profil user
Sponsored content




PostSubyek: Re: Create Ran Offline EP7   

Kembali Ke Atas Go down
 
Create Ran Offline EP7
Topik sebelumnya Topik selanjutnya Kembali Ke Atas 
Halaman 1 dari 1

Permissions in this forum:Anda tidak dapat menjawab topik
 :: ChibiOnline | Indonesian Games (Online & Offline) :: Other Online Game :: R A N-
Navigasi:  
Free forum | © phpBB | Free forum support | Kontak | Report an abuse | Sosblogs.com