Hello & Welcome to our community. Is this your first visit? Register

Page 1 of 24 12345678911 ... LastLast
Results 1 to 15 of 349
  1. #1
    Ultimate Member terryz1619's Avatar

    Rank
    Member
    Join Date
    Sep 2010
    Location
    Kuala Lumpur,M
    Posts
    155

    Official Guide Making Ran Online Episode 7 Gunner Server

    Setting up an Episode 7 Version 1 RAN Gunner Server




    1. Download and instal : Windows Installer 3.1
    2. Download and install : .NET Framework 4

    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 : Download
    For Service Pack 3 : Download
    For Service Pack 2 : Download
    No Service Pack : Download

    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
    Spoiler:


    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 : Download
    For Service Pack 3 : Download
    For Service Pack 2 : Download
    No Service Pack : Download

    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
    Spoiler:


    Game Client : Download Game Client
    Server Files : Download Server Files
    Database : Download Database
    All Editors : Download All Editors
    Glogicserver : Download Glogicserver
    GMCharEdit : Download GMCharEdit


    Note : For the server files :

    Spoiler:
    Hex the server files, then search this IP : 222.222.222.222.
    Then change it to your own IP

    you can use this : Hex Workshop for editing the server files

    Guide for Hexing : How to hex server files (hamachi)


    Server screenshot (server side - tested by me) :
    Spoiler:


    This server files is working for me, why not you ?


    Fix for some error

    Spoiler:


    Error 1 : Character data failed to be processed ! - Shared by Dev02
    Spoiler:

    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.

    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)
    
    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
    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.

    Download File: updated gui


    Error 4 : item without proper name (IN_018_042) and no icon skill icon

    Spoiler:

    item without proper name (IN_018_042) and no icon skill icon

    screenshot :

    item without proper name (IN_018_042)
    Spoiler:


    some gunner class skill have no icon...
    Spoiler:


    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

    Spoiler:



    Solution : Run the Server correctly (Session-Login-Field-Agent)


    Error 6 : Error on deleting character

    Spoiler:




    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)

    3. Make ur own function to delete char on cp





    In Game Screenshot

    Spoiler:















    Credits: neomaster (neomastei2), Blazedex Development.
    Last edited by terryz1619; 10-06-12 at 03:05 PM.


  2.  
  3. #2
    127.0.0.1 SeiferXIII's Avatar

    Rank
    Alpha Male
    Join Date
    Sep 2007
    Location
    Somewhere
    Posts
    1,857

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    Since this is a guide,
    Thread moved.
    T̡̟̤̙̜̱͓̠̜̮̬̥̯̪̱̄̏̑͋͆̈̽ͥ͌͗̋͒́̀͢ͅr̶̬͇͔̞̯̭̦͉̹̮ͣ͛̂̐̎̆̉͒͑ͪ͘̕͞u͉̪̜͚̹̭̦̤͎͓̫̥̭͒̇͛̽͗̃̃̚͝͝͝s̴̡͖͙͕̹̰̺͎̗͉̣͔͇͓ͯ̊ͫͧ̉͗͟͡t͙͕̲̭̣̼̔̓ͦ̐ͣͩ̑͢͜͞ ̸̢̰͍̤̞̘̟̗̫̮̆̃ͪ͐̒ͣͭͫ̉̇̎̉̑͑ͫ͗̚̕͟͡n̛̠̩̠͔̟̼͙͖̙̯͎͂͊̾̉͐ͪ͆͛̅̓͑͐̉͗̓͒͌̔́͢o̯̳̯͙̪͍̦̞̫̰̞̹̦̪ͫ̀ͨͥ͊ͪ̊ͪ͌̆̐́̕̕͡ͅͅ ̢̛̳̣̫̤̼̟̰̥͚̦̻̄̑ͧͫͮͦ̋ͤ̋ͪ̈ͤ̍̆͌͋̊̄́ǫ̵̖̳̞̪͍̮͍̗̟̤͌̍̒̉̑͆̾ͥͣ͛̊̃͐̓ͮͦͧ̾͢n̵̨̛̼͙̗̞͇͉̯̮̥̩̩̳͉͖͙̖͌ͩ͑ͥ̏ͥ͛̈́̾ͦ̓̀ͧ̿̆͆̀͜e̗̯̣̺̪͈̼͈̳̝̟̺͙̯̥̹͉͔̿̈́̾ͥͨ̔ͤ̐ͣ͛̕͟͢͜͝.̷̵̛̰͎̪̩̬͇̳̫͚̣̯̦̫̪͔̍͛ͨ̂̕ͅ

  4. #3
    Hardcore Member jambrong's Avatar

    Rank
    Member
    Join Date
    Nov 2006
    Location
    Jakarta, Indone
    Posts
    138

    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....)

    Monster Speed.......
    Love my bun2.....so much.........

  5. #4
    Member

    Rank
    Member
    Join Date
    Jan 2012
    Posts
    77

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    nice guide

  6. #5
    Ultimate Member terryz1619's Avatar

    Rank
    Member
    Join Date
    Sep 2010
    Location
    Kuala Lumpur,M
    Posts
    155

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    Removed
    Last edited by terryz1619; 20-03-12 at 07:58 PM.

  7. #6
    Retired Vision's Avatar

    Rank
    Alpha Male
    Join Date
    Dec 2007
    Posts
    2,465

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    Very detailed guide. What's that robot costume name?



  8. #7
    QT is better than VS tearhear18's Avatar

    Rank
    True Member
    Join Date
    Jul 2009
    Location
    earth
    Posts
    956

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    great share ,, however crash issues still exist ..
    http://lifeline-gamez.com my development
    SLOW LOADING WEBSITE? PM ME and we will make lighter and load your site like a rocket :D

  9. #8
    Ultimate Member terryz1619's Avatar

    Rank
    Member
    Join Date
    Sep 2010
    Location
    Kuala Lumpur,M
    Posts
    155

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    Removed
    Last edited by terryz1619; 20-03-12 at 07:58 PM.

  10. #9
    QT is better than VS tearhear18's Avatar

    Rank
    True Member
    Join Date
    Jul 2009
    Location
    earth
    Posts
    956

    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.
    http://lifeline-gamez.com my development
    SLOW LOADING WEBSITE? PM ME and we will make lighter and load your site like a rocket :D

  11. #10
    Member

    Rank
    Member
    Join Date
    Jan 2012
    Posts
    77

    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 ?

  12. #11
    Ultimate Member terryz1619's Avatar

    Rank
    Member
    Join Date
    Sep 2010
    Location
    Kuala Lumpur,M
    Posts
    155

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    Removed
    Last edited by terryz1619; 20-03-12 at 07:59 PM.

  13. #12
    Alpha Member Eureka7's Avatar

    Rank
    Alpha Male
    Join Date
    Oct 2008
    Location
    Philippines
    Posts
    1,858

    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 :)

  14. #13
    Member

    Rank
    Member
    Join Date
    Jan 2012
    Posts
    77

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    Quote Originally Posted by Eureka7 View Post
    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

  15. #14
    Alpha Member Eureka7's Avatar

    Rank
    Alpha Male
    Join Date
    Oct 2008
    Location
    Philippines
    Posts
    1,858

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    as what the other dev said.


    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.

  16. #15
    Near I7 asero1933's Avatar

    Rank
    Alpha Male
    Join Date
    Mar 2011
    Location
    Here...
    Posts
    1,642

    re: Official Guide Making Ran Online Episode 7 Gunner Server

    in starting session what is bind error code:10049

 

 
Page 1 of 24 12345678911 ... LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HyperFilter
Sponsored by HyperFilter , secured by Incapsula , powered by LiteSpeed.
Mods by DBTech. All times are GMT +1. The time now is 12:21 AM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.