Everything about sro files / coding / reversing

[•ᵔBeGodOfWarᵔ•]

Important :

 Spoiler

#Todo list
#Thanks for Disco for renaming my thread c;
#After 3 days ( to be honest ) I will re-work on this thread , do all my best to keep it alive ..
Every mediafire link will not be removed , it's uploaded by premium account (mine)

 Spoiler

#TODO; 1.making ftp client on my pc to download items while mediafire down or smth else , maybe i will use multiupload.nl but i'm afraid of closing again like what did happen last
2.making Pk2 edit section for who want to start good server ( pvp / pve )
3.Free launcher design will come ( soon , means no1 will ask me till i release the work )
4.Most errors - fixes for wired pop-up in server files or server client section.
=-=-=-=-=-=

Thanks , Regards
Ahmed.

Welcome all of visitors , members , moderators or even admins
This thread will collect everything in silk road world , To be honest the server files - reversing to make good server w/o bugs , etc.

This thread contest :
1.V-sro files + Tools
2.BR Files + Tools
3.ZSZC Files + Tools
4.SwSro Files + Tools
5.Leaked/Released Database
6.Reversing section
7.Download package ( All in one + Guides ) *
*

 Spoiler

Download package will be finished after I will finish the thread from A to Z , because I will not upload every time full package

1. 1.188 List
   Uploading on ftp client ( since it's popular files )
2. 1.193
   =-=Vsro 1.193 files with 120-cap database/gameserver
   
   =-=Vsro 1.193 Original leaked files -Not edited.
   
3. Tools
   1.Make your gameserver has no captcha:
   
   ATTENTION: IT WILL STOP YOUR AUTO UPDATER AND CRASH IT!
   2.[Release] Evangelion (VSRO v188 gameserver addon)
   
    Spoiler

   Originally Posted by Chernobyl*

   So, here is a little gameserver addon (v188 vsro), which allows you to set stuff like level/mastery cap, enable/disable dumps, etc. Nothing special at the moment, but will be updated through time.
   
   v1.0.1:
   - Set max level
   - Set max mastery
   - Enable/disable any messages in gameserver window (performance increasement)
   - Enable/disable dumps (performance increasement)
   - Enable/disable green book
   - Enable/disable writing data to log db (mssql/gs itself performance increasement)
   
   
   [v1.0.1]
   
   V1.0.2:
   - Fixed problems with setting cap to 130
   - Added some basic detour functions (should show up unique kills at console window). Not logging anything to log files yet, just testing.
   - Some more little fixes
   
   Link : [v1.0.2]
   
   
   V1.0.3:
   - Fixed warning message in gameserver window (processing green book opcode)
   - Added logging of unique kills into log files
   - Fixed some issues with detour
   
   Link: [v1.0.3]
   
   V1.0.4:
   - Added max exchange gold setting
   - Added max stall item price gold setting
   Don't forget, you have to edit client side too, and you got to do it on your own, since this is server-side project. Also, both values are 4 bytes, setting too high values will cause overflow.
   
   Link: [v1.0.4]
   
   V1.0.5 [not so much changes coz i've been lazy + spent some time at hospital]:
   - Added "spoofing" ip address for certification etc
   - Fixed disabling log database calls
   - Added max pet level setting
   - Fixed tons of minor bugs (also related to crashes)
   - Added arena/ctf reward count [test] (reward items comes in next ver)
   - Disable any patch by setting it's value to -1
   - Fixed error with green book
   - Added arena reward item codename/param settings [test]
   - Added CTF reward item codename/param settings [test]
   - Some more i cant remember
   
   Link: [v1.0.5]
   
   
   Requires Visual c++ 2010 runtime libs.
   
   Request any features you want in this thread.

   3.
   

• Guides
  Dr.moron guides:
  1.{Guide/Release} SQL Server configuration For vsro files & Patches options
  
   Spoiler

  Originally Posted by Dr.Abdelfattah

  Hello
  
  let's start real topic
  now all can make server with out bugs ~ (Just only still topic for explain billing server cuz most of us path this billing is dead but u don't know it's really still died and u will got item bug and DC bug and so)
  but now we are on fixing mobs respawn bugs and pet 2
  those fixed in patchs wich i will explain then in the last of this topic
  Now we will start with mssql (sql server) configuration
  
  Introduction
  
  By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first, you’ll see one of these error messages.
  
  “An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. ….�?
  
  “Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.�?
  
  To resolve these problems, you have 2 majors task. One is to enable both SQL Server and Windows authentication mode on SQL Server and the other is to allow remote connection and SQL Server Browser.
  Step-by-step
  
  

  • Check that you have allowed both SQL Server and Windows Authentication mode (If you’re not use Windows Authentication mode). For instance, user ‘sa’.
    1. Login to SQL Server using SQL Server Management Studio Express on local SQL Server with Windows Authentication user. This will use Windows account to authenticate to SQL Server.
       
    2. In Object Explorer, right click on the instance name and select Properties.
       
    3. On the left, select Security and change Server authentication to SQL Server and Windows Authentication mode. If the choice is already selected, that means you have already allowed SQL Server authentication.
       
    4. There’ll be an information window shows that you need to restart SQL Server to takes effect of the changes.
       
    5. Right-click on the instance name again, select Restart to restart SQL Server service.
       
    6. Select Yes.
       
    7. Wait for service stop and start.
       
    8. That’s it. You have enabled both SQL Server and Windows authentication so now you can login to SQL Server with your current Windows account or your created account.
  • Check that you have enabled remote connection on SQL Server Surface Area Configuration
    1. Open SQL Server Surface Area Configuration.
       
    2. Select Surface Area Configuration for Services and Connections.
       
    3. On the left side, expand your SQL Server instance -> Database Engine -> Remote Connections. On the right side, select Local and remote connections -> using both TCP/IP and named pipes.
       
    4. On the left side, select SQL Server Browser -> Service.
       On the right side, if the startup type is Disable, you need to change to Automatic and click Apply and click Start button to start the service. Then, click OK.
       
    5. You have finished configure. Now try to login to your SQL Server from remote computer using SQL Server authentication mode.
       
    6. Login to SQL Server succeeded.
       

  Summary
  
  This topic may be found on the Internet in many site or even Microsoft support but the purpose is to rearrange with easier to read and follow with graphic along with each step so it may help you reminder solution faster or even the person who have just start to use SQL Server 2005 Express Edition.
  
  
  --------------------------------------------------------------
  Now we finish sql problems (all errors comes from database gone now !!!)
  and u must do what in this sql explain to make patchs works fine
  
  
  
  Start explain patchs
  
  
  patch 3 with same ports !
  patch 3.1 with unsame ports !!!
  patch 4 with more download server and gateway server and same with 3.1
  and patch 4.1 with more download server and gateway server and same with 3.1 !! but more servers in list !
  
  
  
  
  Patch 3 = 2 gameserver & 2 agentserver & 2 machinemanager
  
  
  Patch 3.1 = 2 gameserver & 2 agentserver & 2 machinemanager (with diffrent ports)
  
  
  Patch 4 = 2 downloadserver & 2 gatewayserver & 2 machinemanager & 2 gameserver & 2 agent server
  
  
  Patch 4.1 = 2 downloadserver & 2 gatewayserver & 2 machinemanager & 2 gameserver & 2 agent server & 2 sharedmanager
  
  
  Patch 5 = 2 downloadserver & 2 gatewayserver & 3 machinemanager & 3 gameserver & 3 agent server
  
  
  Patch 5.1 = 2 downloadserver & 2 gatewayserver & 3 machinemanager & 3 gameserver & 3 agent server & 3 sharedmanager
  
  
  Patch 3 & 3.1 & 4 & 4.1
  hosted on 2 machines (can't host on vmware )
  
  Patch 5 & 5.1
  more stable but must hosted on 3 machines (can't host on vmware 2 )
  
  Patch 4.1 & 5.1
  u must Edot db _SharedService
  with
  64 0
  65 0
  that's for 4.1 and for 5.1
  64 0
  65 0
  66 0
  
  
  Works and more explain u will find notbad in each patch explain what's it's function and how to open it and u will find too in this .txt the ports u must open on firewall (i suggest to use plesk panel it will make much easyer thing to ur server in creat ftp or website or make db mssql )
  
  
  
  -----------------------------------------------------------
  Edit
  in
  
  
  
  change node_type=335 to node_type=336
  in patch 5&5.1
  -----------------------------------------------------------------------------------
  
  
  (My Final Work)
  Now
  Download Patches From attachement
  Have a Nice Time (Don't forget to Like )

  enough for him !
• [Guide] Finally how to add Avatar in Item Mall VSRO Files
  
   Spoiler

  Originally Posted by mostafa2224

  Hello Brothers
  Yesterday i was ask all how i can add Avatar to Item mall
  and Finally i get Way personal with Care of Allah
  So i say i must make guide because all ask about it and no one answer
  
  Program Required :
  1- Pk2ExtractorSE.exe
  2- Pk2Editor.exe
  
  Steps :
  1- Open PK2ExtractorSE.exe and open media From it
  then Extract " refpackageitem.txt "
  

  /server_dep/silkroad/textdata

  then open it i mean " refpackageitem.txt " and change all Saletag to 0 ( ZERO )
  
  2- open SQL then open table dbo._refpackageitem
  

  SRO_VT_SHARD/TABLES/dbo._RefPackageItem

  and change all Saletag to 0 For All
  
  3- now open Pk2Editor.exe and open media then import file refpackageitem.txt Edited
  
  now try your server you will found all Avatar in Item Mall
  i hope help some others

• [Guide] [vSRO] How to Fix Attack / Pick Pet Bug
  
   Spoiler

  Originally Posted by InPanic Kev

  Hello , i see much ppl got this problem .... i solove this problem so .
  
  there i will give u some infos to Fix ur DC problem with the Pets .
  
  1. Database : SRO_VT_SHARD / _CharCOS
  
  
  
  2.
  
  
  3.
  
  
  4. finish .
  
  
  Restart ur Server and have fun .
  
  i hope its usefull
  
  Greetz
  
  Kev

• [SQL Guide] vSRO - Premium Free Access System
  
   Spoiler

  Originally Posted by •ᵔBeGodOfWarᵔ•

  Hello Epvp members
  today i'm gonna share the leaked version of new sql revolution
  
  1-you need to drop and re-create dbo.TB_USER
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Table [dbo].[TB_User]    Script Date: 05/19/2012 21:52:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TB_User](
    [JID] [int] IDENTITY(1,1) NOT NULL,
    [StrUserID] [varchar](25) NOT NULL,
    [password] [varchar](50) NOT NULL,
    [truepassword] [varchar](50) NULL,
    [Status] [tinyint] NULL,
    [GMrank] [tinyint] NULL,
    [Name] [varchar](25) NULL,
    [Email] [varchar](100) NULL,
    [sex] [char](2) NULL,
    [certificate_num] [varchar](30) NULL,
    [address] [varchar](100) NULL,
    [postcode] [varchar](10) NULL,
    [phone] [varchar](20) NULL,
    [mobile] [varchar](20) NULL,
    [regtime] [datetime] NULL,
    [reg_ip] [varchar](25) NULL,
    [Time_log] [datetime] NULL,
    [freetime] [int] NULL,
    [sec_primary] [tinyint] NOT NULL,
    [sec_content] [tinyint] NOT NULL,
    [AccPlayTime] [int] NULL,
    [LatestUpdateTime_ToPlayTime] [int] NULL,
    [at] [smallint] NULL,
    [block] [smallint] NULL,
    [blockreason] [varchar](500) NULL,
    [expired] [datetime] NULL,
    [emailkey] [varchar](50) NULL,
    [hashigh] [smallint] NULL,
    [lastloginip] [int] NULL,
    [question] [varchar](50) NULL,
    [answer] [varchar](50) NULL,
 CONSTRAINT [PK_TB_User] PRIMARY KEY CLUSTERED 
(
    [JID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY],
 CONSTRAINT [IX_TB_User] UNIQUE NONCLUSTERED 
(
    [StrUserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_Status]  DEFAULT ((1)) FOR [Status]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_GMrank]  DEFAULT ((0)) FOR [GMrank]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_regtime]  DEFAULT (getdate()) FOR [regtime]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_freetime]  DEFAULT ((0)) FOR [freetime]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_sec_primary]  DEFAULT ((3)) FOR [sec_primary]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_sec_content]  DEFAULT ((3)) FOR [sec_content]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_at]  DEFAULT ((0)) FOR [at]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_block]  DEFAULT ((0)) FOR [block]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_expired]  DEFAULT (getdate()) FOR [expired]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_hashigh]  DEFAULT ((0)) FOR [hashigh]
GO

ALTER TABLE [dbo].[TB_User] ADD  CONSTRAINT [DF_TB_User_lastloginip]  DEFAULT ((0)) FOR [lastloginip]
GO 


  2-create dbo._FreeAccess
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Table [dbo].[_FreeAccess]    Script Date: 05/19/2012 21:55:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_FreeAccess](
    [JID] [int] NOT NULL,
    [EndTime] [datetime] NOT NULL,
    [ShardID] [int] NOT NULL
) ON [PRIMARY]

GO 


  3-create dbo.BrutalBlockedIP
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Table [dbo].[_BrutalBlockedIP]    Script Date: 05/19/2012 21:55:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_BrutalBlockedIP](
    [nIdx] [int] IDENTITY(1,1) NOT NULL,
    [szIPBegin] [varchar](16) NOT NULL,
    [szIPEnd] [varchar](16) NOT NULL,
    [szGM] [varchar](64) NOT NULL,
    [dIssueDate] [datetime] NOT NULL,
    [szISP] [varchar](256) NULL,
    [szDesc] [varchar](512) NULL,
 CONSTRAINT [PK__BrutalBlockedIP] PRIMARY KEY CLUSTERED 
(
    [nIdx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 


  4-drop and create dbo._PrivilegedIP
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Table [dbo].[_PrivilegedIP]    Script Date: 05/19/2012 21:57:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_PrivilegedIP](
    [nIdx] [int] IDENTITY(1,1) NOT NULL,
    [szIPBegin] [varchar](16) NOT NULL,
    [szIPEnd] [varchar](16) NOT NULL,
    [szGM] [varchar](64) NOT NULL,
    [dIssueDate] [datetime] NOT NULL,
    [szISP] [varchar](256) NULL,
    [szDesc] [varchar](512) NULL,
 CONSTRAINT [PK__PrivilegedIP] PRIMARY KEY CLUSTERED 
(
    [nIdx] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 


  Now the required stored procedures for AccountDB
  
  5-CertifyTB_User
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  StoredProcedure [dbo].[_CertifyTB_User]    Script Date: 05/19/2012 21:59:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- 4. ALTER PROCEDURE _CertifyTB_User
CREATE PROCEDURE [dbo].[_CertifyTB_User]
    @szUserID    varchar(25),
    @szPassword    varchar(50)
AS



    if exists ( 
        select 
            '' 
        from _Punishment with ( nolock )
        where SerialNo = ( 
            select 
                max( SerialNo ) from _BlockedUser with ( nolock ) 
            where UserJID = ( SELECT JID FROM TB_User WHERE StrUserID = @szUserID ) and 
                Type = 99 and getdate() between timeBegin and timeEnd ) )
    begin
        select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szUserID ), convert( tinyint, 0), convert( tinyint, 0)

        return
    end
    if exists (select 1 from TB_User where StrUserID=@szUserID and block=1 and expired>=GETDATE())
    begin
        select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szUserID ), convert( tinyint, 0), convert( tinyint, 0)
        return
    end
    declare @nUserJID int
    declare @sec_primary tinyint
    declare @sec_content tinyint

    set    @nUserJID        = 0
    set    @sec_primary        = 0
    set    @sec_content        = 0

-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????????? ???????? ??????
    declare @ApplyType            tinyint
    declare @AccPlayTime             int        
    declare @LatestUpdateTime_ToPlayTime     int            

    set @ApplyType                 = 0        -- ?????? ?????????? ???????? ?????????? ???????? ???? ?????????? ???? ??????
    set @AccPlayTime             = 0        
    set @LatestUpdateTime_ToPlayTime     = 0  
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

-- ?????? ?????? ???? ????
--    select @nUserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content from TB_User

    SELECT @nUserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content
    , @AccPlayTime = AccPlayTime, @LatestUpdateTime_ToPlayTime = LatestUpdateTime_ToPlayTime FROM TB_User
    WHERE StrUserID = @szUserID and password = @szPassword 
    --and AT=1

-- Edit For fatigue system
-- Please, fill value to @ApplyType ( 1 : TEEN USER , 2 : ADULT USER ) from your web database
-- ex ) @ApplyType = exec web.proc.certify

    if( @nUserJID = 0 or @nUserJID is null or @@error <> 0 or @@rowcount = 0)
    begin
-- ?????? ?????? ???? ????
        select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
        --select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
        return
    end
    if( exists( select Type from _BlockedUser where UserJID = @nUserJID and Type = 1 and getdate() between timeBegin and timeEnd))
    begin
-- ?????? ?????? ???? ????
        select convert( tinyint, 3), @nUserJID, convert( tinyint, 0), convert( tinyint, 0)
        --select convert( tinyint, 3), @nUserJID, convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
        return
    end
-- ?????? ?????? ???? ????
select convert(tinyint, 0), @nUserJID, @sec_primary, @sec_content
    --select convert(tinyint, 0), @nUserJID, @sec_primary, @sec_content, @ApplyType, @AccPlayTime, @LatestUpdateTime_ToPlayTime
    return

GO 


  6-create _CheckfreeAccess
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  StoredProcedure [dbo].[_CheckFreeAccess]    Script Date: 05/19/2012 22:04:52 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




----------------------------------------------------------------------
-- ภฺภฏมขฑูภฬ ฐกดษวัม๖ธฆ ศฎภฮวฯฑโ ภงวั วมทฮฝรมฎ 
----------------------------------------------------------------------
CREATE PROCEDURE [dbo].[_CheckFreeAccess]
    @JID        INT,
    @ShardID    INT
AS
    -- วุด็ JID ภว วุด็ ปตๅภว BanLvl ภฬ ฑโบปภฬ พฦดั พึต้ฟก EndTime ภป ฐกมฎฟยดู. 
    DECLARE @EndTIme DATETIME 
    SET @EndTIme = 0

    -- ว๖ภ็ ผณฐ่ ป๓ BANLevel ภฬ 4 ( BanLevel รึฐํฤก ) ภฮ ฐๆฟ์ฟกธธ FA ฐก ฐกดษวฯดู. 
    SELECT TOP 1 @EndTIme = Endtime 
        FROM _FreeAccess 
        WHERE JID = @JID 
            AND ShardID = @ShardID 
        ORDER BY EndTime DESC
    if exists (select 1 from TB_User where JID=@JID and block=1)
    begin
        Select 1 
        return
    end
    IF  ( @EndTIme <> 0 )  AND (  DATEDIFF( SECOND, GETDATE(), @EndTIme  ) > 0 )
     BEGIN 
        -- &#3613;รฐฃย๗ฐก พ็ผ๖, ฝรฐฃ ฟฉภฏฐก ภึดยณ๐ 
        SELECT 1
    END 
    ELSE 
    BEGIN
        -- &#3613;รฐฃย๗ฐก ภฝผ๖, ฝรฐฃ ฟฉภฏฐก พ๘ดยณ๐ 
        SELECT 0
    END



GO 


  7-create _ResetFreeAccess
  

  PHP Code:

  USE [SRO_VT_ACCOUNT]
GO

/****** Object:  StoredProcedure [dbo].[_ResetFreeAccess]    Script Date: 05/19/2012 22:06:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




----------------------------------------------------------------------
-- ณฏยฅฐก ม๖ณญ พึต้ภบ ป่มฆวุ น๖ธฐดู.
----------------------------------------------------------------------
CREATE PROCEDURE [dbo].[_ResetFreeAccess]
AS
    DELETE FROM _FreeAccess WHERE GETDATE() > EndTime



GO 


  now we finished AccountDB time for ShardDB
  
  8-create table _FreeAccessBanlvl
  

  PHP Code:

  USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_FreeAccessBanLvl]    Script Date: 05/19/2012 22:07:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_FreeAccessBanLvl](
    [JID] [int] NOT NULL,
    [BanLvl] [int] NOT NULL,
    [EndTime] [datetime] NOT NULL
) ON [PRIMARY]

GO 


  9-create procedure _GetAllFreeAccessBanlvl
  

  PHP Code:

  USE [SRO_VT_SHARD]
GO

/****** Object:  StoredProcedure [dbo].[_GetAllFreeAccessBanLvl]    Script Date: 05/19/2012 22:10:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO




CREATE PROCEDURE [dbo].[_GetAllFreeAccessBanLvl]
AS
    -- ธีภ๚ ฑโฐฃภฬ ม๖ณญ ณัภบ ม๖ฟ๖ น๖ธฐดู!
    DELETE FROM _FreeAccessBanLvl 
    WHERE GETDATE() > EndTime

    IF EXISTS (SELECT JID FROM _FreeAccessBanLvl WITH (NOLOCK))
    BEGIN
        -- SELECT ALL!!
        SELECT JID, BanLvl, EndTime 
        FROM _FreeAccessBanLvl WITH (NOLOCK)     
    END
    ELSE
    BEGIN
        -- ทนฤฺตๅฐก พ๘ดย ฐๆฟ์ ด๕นฬภป บธณปมึภฺ.
        SELECT 0, 0, GETDATE()
    END



GO 


  10-create this function because the next stored procedure will ask for it
  

  PHP Code:

  USE [SRO_VT_SHARD]
GO

/****** Object:  UserDefinedFunction [dbo].[_DiffTime_CRTTIME_SQLTIME]    Script Date: 05/19/2012 22:13:17 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE FUNCTION [dbo].[_DiffTime_CRTTIME_SQLTIME]
    (@CRTTime INT, @SQLTime DATETIME)
RETURNS INT
AS
BEGIN
    DECLARE @nTimeTo     INT
    DECLARE @nTimeFrom    INT

    SET @nTimeTo     = 0
    SET @nTimeFrom    = @CRTTime

    SET @nTimeTo     = DATEDIFF( ss, '1970-01-01 09:00:00', @SQLTime )
/*
    DECLARE @nRemainHH    INT
    DECLARE @nRemainMM    INT
    DECLARE @nRemainSS    INT

    SET @nRemainHH     = (@nTimeTo - @nTimeFrom) / 60 / 60
    SET @nRemainMM     = (@nTimeTo - @nTimeFrom) / 60 - (@nRemainHH * 60)
    SET @nRemainSS    = (@nTimeTo - @nTimeFrom) - (@nRemainMM * 60 ) - (@nRemainHH * 60 * 60)
*/
/*
    RETURN cast( abs(@nRemainHH) as varchar(128)) + 'ฝรฐฃ'
        + cast( abs(@nRemainMM) as varchar(128)) + 'บะ'
        + cast( abs(@nRemainSS) as varchar(128)) + 'รส'
*/
    RETURN (@nTimeFrom - @nTimeTo)
END




GO 


  11- create procedure _InitializeFreeAccessBanLvl
  

  PHP Code:

  USE [SRO_VT_SHARD]
GO

/****** Object:  StoredProcedure [dbo].[_InitializeFreeAccessBanLvl]    Script Date: 05/20/2012 13:15:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE proc [dbo].[_InitializeFreeAccessBanLvl]
as
    delete _FreeAccessBanLvl where BanLvl in(3, 4)

    declare @CharID        int
    declare @Category    int
    declare @JobID        int
    declare @TimeToKeep    int
    declare @Data1        int
    declare @Data3        int
    declare @JID        int

    declare @Gold1D_ItemID      int
    declare @Gold4W_ItemID      int
    declare @Silver1D_ItemID int
    declare @Silver4W_ItemID int

    declare @EndDateTime    datetime

    select @Gold1D_ItemID = id  from _RefObjCommon with(nolock) where codename128 = 'ITEM_MALL_GOLD_TIME_SERVICE_TICKET_1D'
    if( @@error <> 0 or @@rowcount = 0 )
    begin
        raiserror( '1ภฯ ฐ๑ตๅลธภำ พฦภฬลภฬ พ๘ฝภดฯดู.', 0, 1 )
        return -1
    end

    select @Gold4W_ItemID = id  from _RefObjCommon with(nolock) where codename128 =  'ITEM_MALL_GOLD_TIME_SERVICE_TICKET_4W'
    if( @@error <> 0 or @@rowcount = 0 )
    begin
        raiserror( '4มึ ฐ๑ตๅลธภำ พฦภฬลภฬ พ๘ฝภดฯดู.', 0, 1 )
        return -1
    end

    select @Silver1D_ItemID = id  from _RefObjCommon with(nolock) where codename128 =  'ITEM_MALL_SILVER_TIME_SERVICE_TICKET_1D'
    if( @@error <> 0 or @@rowcount = 0 )
    begin
        raiserror( '1ภฯ ฝวน๖ลธภำ พฦภฬลภฬ พ๘ฝภดฯดู.', 0, 1 )
        return -1
    end

    select @Silver4W_ItemID = id  from _RefObjCommon with(nolock) where codename128 =  'ITEM_MALL_SILVER_TIME_SERVICE_TICKET_4W'
    if( @@error <> 0 or @@rowcount = 0 )
    begin
        raiserror( '4มึ ฝวน๖ลธภำ พฦภฬลภฬ พ๘ฝภดฯดู.', 0, 1 )
        return -1
    end

    set @JID = 0

    declare @Date datetime
    declare @DiffTime int
    set @Date = cast(getdate() as datetime)

    declare timedjob_cursor  cursor fast_forward for    
    
    -- &#3600;๑ตๅ, ฝวน๖, วมธฎนฬพ๖ พฦภฬล
    select max(Category), max(JobID), max(TimeToKeep), max(Data1), max( isnull(Data3, 0) ), CharID
    from _TimedJob with (nolock)
    where Category = 5 or ( Category = 3 and JobID in( @Gold1D_ItemID,@Gold4W_ItemID,@Silver1D_ItemID,@Silver4W_ItemID ) )
    group by CharID

    open timedjob_cursor

    fetch next from timedjob_cursor into @Category, @JobID, @TimeToKeep, @Data1, @Data3, @CharID

    while @@fetch_status = 0
    begin    
        select @JID = UserJID from _User where CharID = @CharID
        if @@rowcount = 0 or @@error <> 0
        begin
            close timedjob_cursor
            deallocate timedjob_cursor    
            Raiserror('ฤณธฏลอฟก วุด็วฯดย ฐ่มคภฬ พ๘ณื! [%d]', 1, 16, @CharID)
            return -1
        end

        if( @Category = 3  )
        begin
            declare @ItemTotalSecond int
            
            select @ItemTotalSecond = param1 from _RefObjItem where id in ( select link from _RefObjCommon where id = @JobID )

            set @TimeToKeep = @Data1 + ( @ItemTotalSecond + ( @Data3 * 86400 ) + 86400 )
        end

        set @DiffTime = dbo._DiffTime_CRTTIME_SQLTIME( @TimeToKeep, @Date )
        set @EndDateTime = DATEADD(second, @DiffTime, getdate())
        insert into _FreeAccessBanLvl values(@JID,  4, @EndDateTime)

        fetch next from timedjob_cursor into @Category, @JobID, @TimeToKeep, @Data1, @Data3, @CharID
    end

    close timedjob_cursor
    deallocate timedjob_cursor    






GO 


  12-create procedure _InsertFreeAccessBanLvl_CashItemUsed and watch out from it because it link ShardDB with AccountDB
  

  PHP Code:

  USE [SRO_VT_SHARD]
GO

/****** Object:  StoredProcedure [dbo].[_InsertFreeAccessBanLvl_CashItemUsed]    Script Date: 05/19/2012 22:16:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE PROCEDURE [dbo].[_InsertFreeAccessBanLvl_CashItemUsed]
    @JID        INT,
    @BanLevel    INT,
    @ValidityTerm    INT,
    @ShardID    INT    
AS
    DECLARE @EndDate DATETIME
    SET @EndDate = DATEADD(second, @ValidityTerm, GETDATE())

    -- ภฯน ฑโฐฃมฆ พฦภฬลภว ป็ฟ๋ภบ วุด็ ฤณธฏลอทฮ ฑนวัตศดู.
    INSERT INTO _FreeAccessBanLvl VALUES (@JID, @BanLevel, @EndDate)

-----------------------------------------------------------------------------------------------------------------------
    --[ Start !!! ] 2009.05.12. FREE_ACCESS ฐณผฑ by ta4rom
-----------------------------------------------------------------------------------------------------------------------
    --AccountDB มขผำ มคบธฟอ ตฅภฬลอบฃภฬฝบภฬธงภบ ม๗มข วฯตๅ ฤฺต๙ตวพ๎มฎ ภึดู. กฺ บฮบะ ศฎภฮ 

    IF @BanLevel = 4 
    BEGIN    -- นทนบง 4ภฯ ฐๆฟ์ฟกธธ, AcountDB ฟก วุด็ มคบธธฆ ณฒฑไดู. 
        INSERT INTO SRO_VT_ACCOUNT.dbo._FreeAccess VALUES (@JID, @EndDate, @ShardID )
        -- กฺ _Account_For_SMC ภว Account DB ตฅภฬลอบฃภฬฝบธํภธทฮ พหธยฐิ ผ๖มค 
    END 

-----------------------------------------------------------------------------------------------------------------------
    --[ End !!! ] 2009.05.12. FREE_ACCESS ฐณผฑ by ta4rom
-----------------------------------------------------------------------------------------------------------------------
        
    -- ปตๅธลดฯภ๚ฟกฐิ พหทมมึฑโ ภงวุ ภฬ มภป วัดู. -_-
    SELECT @JID, @BanLevel, @EndDate

GO 


  look at that
  

  PHP Code:

  INSERT INTO SRO_VT_ACCOUNT.dbo._FreeAccess VALUES (@JID, @EndDate, 


  so basically if you're useing the same names of DBs then just execute without edit and if it's not then change SRO_VT_ACCOUNT to w/e
  
  13-create procedure _InsertFreeAccessBanLvl_SilkPurchased
  

  PHP Code:

  USE [SRO_VT_SHARD]
GO

/****** Object:  StoredProcedure [dbo].[_InsertFreeAccessBanLvl_SilkPurchased]    Script Date: 05/19/2012 22:19:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO



CREATE PROCEDURE [dbo].[_InsertFreeAccessBanLvl_SilkPurchased]
    @JID        INT
AS
    DECLARE @EndDate DATETIME
    SET @EndDate = DATEADD(dd, 30, GETDATE())

    INSERT INTO _FreeAccessBanLvl VALUES (@JID, 1, @EndDate)

    -- ปตๅธลดฯภ๚ฟกฐิ พหทมมึฑโ ภงวุ ภฬ มภป วัดู. -_-
    SELECT @JID, 1, @EndDate



GO 


  okay that's SQL side now server side and the easy part you will just need to add 2 parameters to server.cfg under Sr_ShardManager
  

  PHP Code:

          EnablePremiumFreeAccess                1
        BanUselessUserWhenFreeAccess            1 


  it's not recommended to set BanUselessUserWhenFreeAccess to 0 cause it may make flood when your server get crowded
  okay you must download the GW too from Chrenobyl's thread and if you got problem with download server you can replace with BR's one it works too
  
  Credit goes to : SnapPop
  

   Spoiler

  ////LEACHED////

1.Game server w-o data folder ( You've to add it by extracting data.pk2 of zszc cap 100 files / 105 )

2.

• Full zszc files (100cap)
  °Gameserver
  
  
  
  °Others (Have to download with Gameserver
  

• Tools
  °IP Tools
  
  °General tools [/Important]
  
  
  
  

• Guides
  °/TODO

• Download
  
  ° Other mirrors under uploading atm.
  
• Guides
  ° /TODO

• Download
  °
  1. 
  2. 
  3. 
• Guides
  °/
   Spoiler

  1. You will need a client - prefer EliteSRO from sro.vn or Plasma Client (better for this configuration but miss some important stuff like shops as default).
  2. Certification configuration:
  	- Open Certification folder and go to ini folder.
  	- Open srShard.ini and srGlobalService.ini with any text editor
  	- Edit the following: 
  		SERVER_IP_OR_ADDRESS = This must be your database server ip adress or name .\SQLEXPRESS (may vary if you're more experienced on these and setup your own name).
  		YOUR_PASSWORD_HERE = Database password.
  		SERVER NAME = Change this to your server name.
  	- Run Compile.bat and you're done with Cert.
  3. Extract data.pk2 into folder Data in Server directory (from the client you want to use).
  4. Restore the databases with following names:
  	BR_ACCOUNT = BR_ACCOUNT.bak
  	BR_SHARD = BR_SHARD.bak
  	BR_SHARDLOG = BR_SHARDLOG.bak
  !! DO NOT CHANGE THE DATABASE NAMES TO OTHER YOU WILL HAVE SILK ERRORS AND IT WILL DC YOU INGAME !!
  
  Okay so if you've done this far, now you'll need to create yourself and GM Account (admin).
  1. Go to BR_ACCOUNT.
  2. Open TB_User and create an account with sec_primary = 1 and sec_content = 1 (if you haven't done this already)
  3. Open _PrivilegedIP table and fill the fields as following:
  	szIPBegin: Ip adress range start (ex: 127.0.0.1)
  	szIPEnd: Ip adress range end (ex: 127.0.0.5)
  	szGM: This is your login id! (ex: admin)
  	dIssueDate: date when the privilege was created. (ex: 2012-01-10 00:00:00.000) - just enter 2012-01-10 or something and hit enter it'll automatically create the other part.
  
  Okay so far everything should be okay and you should be able to login & play.
  NOTE: These files should run perfectly on one machine with all areas enabled, performance based on your machine.
  
  These serverfiles are full 100 CAP, Both euro and china with all areas enabled.
  Databases are clean & working / fixed.
  
  note: if you're using eliteSRO client you might want to IPinput the locale to 22.

• Assembly
  °
   Spoiler

  Originally Posted by evelknievel10

  This Thread contains many Assembly edits which are useful if you run a Vsro P-Server.
  
  Requirments:
  Ollydbg ()
  Dezimal -> Hex Converter ( or ) they are all the same.
  
  Small tutorial how to use OllyDBG:
  - if you start OllyDBG, simply drag the file you want to check in the OllyDBG window (in this case the SR_GameServer.exe of VSRO). Let Olly analyze the file completly (black bar at the bottom)
  
  - The lines are working like this: Expression |. Binary | Assemble | Comment
  
  
  - If i give you an expression, just press CTRL+G to get there. It will get you to the line of the procedure which we want to edit.
  
  - All numbers are in floats or in hex. We just need a hex <-> dezimal converter. I prefer you to use the Windows Calculator for this, but you can use any.
  
  - to edit the lines, doubleclick on the Assemble code. A new Window appears, just replace the content. After edit, the line is red. Make sure you select all edited lines and copy them to executeable (more infos about save later)
  
  
  
  First of all, the GameServer edits.
  
  Changing Max Level:
  

   Spoiler

  This is the line for the max character level.
  

  004E52C7  |.  80F9 50       CMP CL,6E

  Press CTRL+G and fill in 004E52C7
  It will bring you to this line.
  
  DoubleClick on CMP CL,6E and edit it to CMP CL,(Your max lv in hex)
  For example

  CMP CL,78 for lv 120.

  
  
  Additional fix to prevent crash after lv 110:
  

   Spoiler

  This is the line.
  

  004E5471      817C24 20 B40>cmp     dword ptr [esp+20], 1B4

  Change "dword ptr [esp+20], 1B4" to "dword ptr [esp+20], 1E0" :
  This is the final line:
  

  004E5471      817C24 20 E00>cmp     dword ptr [esp+20], 1E0

  
  
  Changing Max Mastery Level:
  

   Spoiler

  This is the line:
  

  0059C5E6  |.  3D 2C010000   CMP EAX,14A

  Change 12C to the Max mastery level you want in hex. For example:

  CMP EAX, 168 //for Mastery 360

  
  
  Serverrates cap:
  

   Spoiler

  These are the lines.
  For Expoint rates:
  

  00B45B90   .  0000C842      DD FLOAT 100.0000

  For Drop rates
  

  00B45B84   .  0000C842      DD FLOAT 100.0000

  Here you right click on the line, go to Edit and then Edit 32/64 Bit float.
  Then change the number to the max server rates you want. This time, no Hex!

  
  
  Remove the annoying Quest:RaiseEvent Error(It reduces the lag very much!!):
  !!THIS EDIT IS NEW AND VERY IMPORTANT!!
  

   Spoiler

  This is the part. Go to the first expression, you will see the other lines behind it.
  

  005805C8   .  56            push    esi
  005805C9   .  68 C4D8AF00   push    00AFD8C4
  005805CE   .  68 00000001   push    1000000
  005805D3   .  E8 68603B00   call    00936640
  005805D8   .  83C4 0C       add     esp, 0C

  Mark them all, then right click, Edit, Nop All
  This Edit is good because it prevents the overfloat of the gameserver. the GS gets spammed with error infos, with this edit the GS doesnt show up this error anymore!

  
  
  Removing the green book (Credits to ÑõÑ_Ŝŧóp)
  

   Spoiler

  Right click - Search for - for constants : 3122 (hex)
  you'll find PUSH 3122
  click on it,and look at the start of the routine,patch it to RETN
  
  It's not a good way to remove it, it's fast & easy way, also you will get a warning in the gameserver "msg is not completely used..."

  
  
  To save the edited gameserver, use right click - edit - select all, then again right click - edit - copy to executeable.
  Now right click in the new Window and then Save As... and save your file.
  
  
  
  
  
  Now to the SRO_Client.exe edits.
  
  Changing mastery showup:
  

   Spoiler

  This is the line:
  

  006A51BC  |.  BF 2C010000   MOV EDI,14A

  Change 14A to the Mastery limit you use in your GameServer. for example

  MOV EDI,168 //for lv 360 mastery.

  Important info:
  Sometimes the SRO_Client Mastery shows up wrong if you edited your sro client too much. I prefer you to do this edit first, then the other edits. If the mastery shows wrong, just skill 1 more mastery of any skill, doesnt matter which, and the mastery will show up correct again. This error appears rarely, but in case it happens just follow the instruction and it will work fine again.

  
  
  Change Party Matching level:
  

   Spoiler

  These are the lines:
  

  0073940E      6A 6E         PUSH 6E
  00739453      6A 6E         PUSH 6E
  0073AFAE      6A 6E         PUSH 6E
  0073B013      6A 6E         PUSH 6E
  0073B030      6A 6E         PUSH 6E
  0073FA4C      6A 6E         PUSH 6E
  0073FAAF      6A 6E         PUSH 6E
  0073FACC      6A 6E         PUSH 6E

  Go to every single expression and change 6E to the Max level you use in your Gameserver. For example PUSH 78 for lv 120.

  
  
  Fix the lv 120 Skills showup (you have to do this if you want to add 120 skills.)
  

   Spoiler

  This is the line:
  

  005448B1    80B8 AC000000 7 CMP BYTE PTR DS:[EAX+0AC],6E

  Change

  CMP BYTE PTR DS:[EAX+0AC],6E //to 
  CMP BYTE PTR DS:[EAX+0AC],78

  
  Change Autoselect range (All Sro) (Credits to ÑõÑ_Ŝŧóp)
  

   Spoiler

  You don't need ollydbg this time,you can use any hex editor (get one )
  search for pattern: 00 00 8C 42 55 00 49 00 49
  replace with : 00 40 9C 45 55 00 49 00 49 (for 5000 range)
  explain:the autoselect range is 70 (Float) (0x428c0000) by default,it's the first 4 bytes
  so we can change it using any float -> hex converter ( recommended)
  so we change it to 5000 (0x459c4000) (you can change it to any other value ofc)

  
  
  As I noticed most of the servers copied the PK2 and Client from DWO, Aurora or Class, because they were the first who got this edit from me (except Class, they were smart enough to find it themself) So now you can take a clean Client and pk2 and edit it as you want
  
  
  Hope you like this tutorial
  
  Regards,
  ZubZero / Ra

  
  

1. PvP-Database
   
    Spoiler

   1. 110 PvP database
   

    Spoiler

   Originally Posted by LegendM

   Hi guys I just created this db yesterday so I want release
   
   -There's only dw enabled
   -All nova's( Egypt and normal ones with %100 stats,fb) in npc
   -All elixir's in npc
   -Item mall @ Item mall npc.f10 mall is clean
   -110 start,10 m sp etc
   -Added all dress's to msro item mall
   Note:Use orginal client from vsro test 110 cap
   Also gameserver 'll give some errors.Just skip it
   Just 1 small pic from item mall npc
   
   
   Database and media download :
   
   
   Download link pw :
   epvp-rz
   For haters.I'm sure they will write who cares or something like that
   
   This is for everyone,If you dont want just click back

   2.[Release] Database D13 No Bugs, All Avatars, Angel Spirit, Yellow Name!
   

    Spoiler

   Originally Posted by ღ ∂ Ropp

   Hello community, this evening I was searching around a found a nice post that I think e*P community would enjoy being released here, and since it's not, here it is.
   About DB it's your dream everything working angel, stone, D13, Advanced Elixer's A&B , New Avatars , 28 New Yellow Names ,Fixed All Skills like Warrior, Fire, Cold. And many other specials, [ check by yourself ] (;
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   Credits , Ezma and others.
   

   Regards,
   ღ ∂ropp.

2. Pve database
   
    Spoiler

   1.Fixed DataBase vSRO Files Cap120+Skil On SQL Server 2005
   

    Spoiler

   Originally Posted by Peclawz

   good I just copied the table from the DataBase d12 SQL2008 RC2 Posted by Artuuro_lv and I added in my DataBase SQL2005 but I took advantage and fixed some bug.
   
   
   
   no Dc item mall
   120 skill, 120 nivel maxim
   D12 weapons
   All Region Work In Only one GameServer
   SHARD All regions
   Magic Pop rates 100x
   Fix honor ranking
   
   
   Download the client ISRO or KSRO
   
   what change in the server folder.?
   extract the files from the DATA.PK2 with pk2Tools, and replace the files to the server folder.
   
   replace the GameSeerver.exe to the server folder posted by Artuuro_lv
   
   what change in client.?
   replace the date.PK2, MUSIC.PK2, MAP.PK2, PARTICLES.PK2, client folder (ISRO or KSRO) to the client's folder VSRO
   
   Open the media.pk2 with the pk2tools and import the textdata posted by Artuuro_lv

   2.[ReUploaded] Database 120 Cap and Skill + Jupiter Map - Running SQL Server 2005
   

    Spoiler

   Originally Posted by hoshikawakun

   Database Added
   
   Map Jupiter work
   D12 weapons and items
   Level Users and Skills 120 Max
   item mall Work 100%
   All Region Work
   Magic Pop rates 100x
   Fix honor ranking
   
   
   
   Download Database v1.05
   Media Fire Size: 17MB
   Media Fire Size: 15,23MB
   
   Scan VirusTotal
   
   
   
   The VirusTotal may have found some viruses, but has no because before I upload the KasperSky Interenet Security 2012 in the files and everything was clean : D
   
   - Download KSRO you can find it here:
   - After the download finished, start it, and let it update.
   - replace the files from the DATA.PK2, and replace the files to the server folder.
   
   
   Go to Shard DB _RefTeleLink
   there is a Service on "0"Set to "1" Jangan - Dowhan

   3.[Release] Database 120 Cap and Skill + Jupiter Map - Running SQL Server 2005
   

    Spoiler

   Originally Posted by PlayCreedSRO

   Database Added
   
   Map Jupiter work
   D12 weapons and items
   Level Users and Skills 120 Max
   item mall Work 100%
   All Region Work
   Magic Pop rates 100x
   Fix honor ranking
   
   
   
   Download Database v1.05 ,
   
   PASSWORD:
   

   [COLOR="Red"]http://playcreedsro.net[/COLOR]

   - Download KSRO you can find it here:
   - After the download finished, start it, and let it update.
   - replace the files from the DATA.PK2, and replace the files to the server folder.
   
   
   Go to Shard DB _RefTeleLink
   there is a Service on "0"Set to "1" Jangan - Dowhan
   
   
   You like? Give me Thanks +1 :thumbup:

   4.90 cap Pve database
   

    Spoiler

   Originally Posted by x*Manu*x

   Heyho,
   
   the titel says all! Clean the Db and have fun with a 90 Cap Server!
   
   Download:
   
   
   
   
   Greetz
   xManux

   Very important guide: [DEV-In work] Database uniquescroll adder
   
    Spoiler

   Originally Posted by cpgAwesome

   Hello epvp,
   
   I release my half finish programm and all codes you need to add Uniquescrolls.
   It's for Titan uniquescrolls only !
   
   
   ItemdataX.txt (x the last Itemdata in your media.pk2)
   You need to edit the 41798 to 41801 to your last numbers
   

   1	41798	ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	???	xxx	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	100000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_CH_TIGERWOMAN_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
   1	41799	ITEM_SCROLL_MOB_OA_URUCHI_L3	???	xxx	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	150000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_OA_URUCHI_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
   1	41800	ITEM_SCROLL_MOB_KK_ISYUTARU_L3	???	xxx	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	200000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_KK_ISYUTARU_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
   1	41801	ITEM_SCROLL_MOB_TK_BONELORD_L3	???	xxx	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	1	1	1	255	0	1	0	0	1	0	300000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	xxx	xxx	5	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	-1	MOB_TK_BONELORD_L3	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

   RefObjCommon
   You need to edit the number 41799 to 41802 to your last !
   At the end each line 21334 to 21337 , you need to edit it , too !
   

   1	41799	ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	???	xxx	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	100000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21334
   1	41800	ITEM_SCROLL_MOB_OA_URUCHI_L3	???	xxx	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	150000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21335
   1	41801	ITEM_SCROLL_MOB_KK_ISYUTARU_L3	???	xxx	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	200000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21336
   1	41802	ITEM_SCROLL_MOB_TK_BONELORD_L3	???	xxx	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	3	3	3	2	18000	3	0	0	1	1	255	3	1	0	0	1	0	300000000	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	5	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_scroll.bsr	item\etc\e050729_summon_scroll.ddj	XXX	XXX	21337

   RefObjItem
   Here is the first Number the same as in RefObjCommon the last !!
   

   21334	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_CH_TIGERWOMAN_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
   21335	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_OA_URUCHI_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
   21336	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_KK_ISYUTARU_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0
   21337	5	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	MOB_TK_BONELORD_L3	-1	xxx                                                                                                                              	-1	xxx	-1	xxxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

   
   refpackageitem
   Change the number from 84045 to 84048 , with your numbers.
   

   1	15	84045	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
   1	15	84046	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
   1	15	84047	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx
   1	15	84048	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	0	EXPAND_TERM_ALL	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	SN_ITEM_SCROLL_UNIQUE_TT_DESC	item\etc\e050729_summon_scroll.ddj	-1	xxx	-1	xxx	-1	xxx	-1	xxx

   refpricepolicyofitem
   Here are the price 10.00.00.000 Gold for Tigerwoman, 15.00.00.000 for Uruchi and so on...
   

   1	15	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	1	0	100000000	-1	xxx	0	xxx	0	xxx	0	xxx
   1	15	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	1	0	150000000	-1	xxx	0	xxx	0	xxx	0	xxx
   1	15	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	1	0	200000000	-1	xxx	0	xxx	0	xxx	0	xxx
   1	15	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	1	0	300000000	-1	xxx	0	xxx	0	xxx	0	xxx

   refscrapofpackageitem
   Change the last numbers to your last numbers !
   

   1	15	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86691
   1	15	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	ITEM_SCROLL_MOB_OA_URUCHI_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86692
   1	15	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	ITEM_SCROLL_MOB_KK_ISYUTARU_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86693
   1	15	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	ITEM_SCROLL_MOB_TK_BONELORD_L3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx	86694

   refshopgoods
   To put it in any NPC , I choose the arena manager (STORE_BATTLE_ARENA_EU_TAB1)
   

   1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
   1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_OA_URUCHI_L3	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
   1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	2	-1	xxx	-1	xxx	-1	xxx	-1	xxx
   1	15	STORE_BATTLE_ARENA_EU_TAB1	PACKAGE_ITEM_SCROLL_MOB_TK_BONELORD_L3	3	-1	xxx	-1	xxx	-1	xxx	-1	xxx

   textdata_object
   Last but not least the text add the item
   Its for all scrolls normal, strong and titan !
   

   //Unique Scrolls
   1	SN_ITEM_SCROLL_UNIQUE_TT_DESC	0	0	0	0	0	0	<sml2>Scroll which summons a special Monster<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Target another player and use the scroll.<br><br><strong><font color="255,236,219,156">Restriction</font></strong><br>Can be used only after targeting a player.<br>Summoned Unique will not spawn with an unique notice.</sml2>	<sml2>Scroll which summons a special Monster<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Target another player and use the scroll.<br><br><strong><font color="255,236,219,156">Restriction</font></strong><br>Can be used only after targeting a player.<br>Summoned Unique will not spawn with an unique notice.</sml2>	0	0	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN	0	0	0	0	0	0	Tiger Girl Summon Scroll	Tiger Girl Summon Scroll	0	0	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L2	0	0	0	0	0	0	Strong Tiger Girl Summon Scroll	Strong Tiger Girl Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_CH_TIGERWOMAN_L3	0	0	0	0	0	0	Tiger Girl (Titan) Summon Scroll	Tiger Girl (Titan) Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_EU_KERBEROS	0	0	0	Cerberus Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_OA_URUCHI	0	0	0	Uruchi Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_OA_URUCHI_L2	0	0	0	Strong Uruchi Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_OA_URUCHI_L3	0	0	0	0	0	0	Uruchi (Titan) Summon Scroll	Uruchi (Titan) Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_KK_ISYUTARU	0	0	0	Isyutaru Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L2	0	0	0	Strong Isyutaru Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_KK_ISYUTARU_L3	0	0	0	0	0	0	Isyutaru (Titan) Summon Scroll	Isyutaru (Titan) Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_TK_BONELORD	0	0	0	Lord Yarkan Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_TK_BONELORD_L2	0	0	0	Strong Lord Yarkan Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_TK_BONELORD_L3	0	0	0	0	0	0	Lord Yarkan (Titan) Summon Scroll	Lord Yarkan (Titan) Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_RM_TAHOMET	0	0	0	Demon Shaitan Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_RM_TAHOMET_L2	0	0	0	Strong Demon Shaitan Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_RM_TAHOMET_L3	0	0	0	Demon Shaitan (Titan) Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_TQ_FLAMEMASTER	0	0	0	Shinmoo Summon Scroll	0	0	0	0
   1	SN_ITEM_SCROLL_MOB_RM_ROC	0	0	0	Roc Summon Scroll	0	0	0	0

   
   
   
   DL Sourcecocode:
   
   
   Programm picture:
   

 Spoiler

//////TODO///////

Important 2 : (Please read spoiler)

 Spoiler

If anything wrong in the thread , forgot to add tool , etc. Please inform me

Thanks to : All who created the tools , I have uploaded like 70% of them but they still deserve the thank because of release it before.

Everything from-to elitepvpers , Didn't took smth out the forum ....

To contact : @My profile

 Spoiler

dont troll @ thx part

[Dr.Abdelfattah]

Hope someone got Changeset vsro obt v247-v249 and Xtrap update files, re-upload cuz got lost in my old HD

[H5_]

nice work

[WHITE_JAGUAR]

good

[hamada619]

Nice Job Bro

somefiles from zszc srochinacs log and shard but i didnt try it if it is working or not

[•ᵔBeGodOfWarᵔ•]

Originally Posted by hamada619

Nice Job Bro

somefiles from zszc srochinacs log and shard but i didnt try it if it is working or not

This is the correct data w/o db (db wrong data)

[Keyeight]

Really nice Work bro

[PortalDark]

add this ones:
Pk2ToolPatcher by ÑõÑ_Ŝŧóp and Drew's Source


Blowfisher by Chernobyl*


also, try to make first thread look cleaner, cuz it looks a little messed up

[•ᵔBeGodOfWarᵔ•]

Originally Posted by PortalDark

add this ones:
Pk2ToolPatcher by ÑõÑ_Ŝŧóp and Drew's Source


Blowfisher by Chernobyl*


also, try to make first thread look cleaner, cuz it looks a little messed up

Thanks for giving me those topics i was searching on them
@clean topic i cant make it :-s because its cool like that i wont make any edits to make it better ... if you mean spoiler or smth else its easy but colors/fonts no !

[Ahmed Abdelhady]

Thanks

[Incaner]

Thanks!

[Kape7]

Originally Posted by Dr.Abdelfattah

Hope someone got Changeset vsro obt v247-v249 and Xtrap update files, re-upload cuz got lost in my old HD

[domiss1232]

I think u give wrong link look at

Download section :--
1. Server Files
1-Vsro:-
Spoiler:

Part 1(Torrent)Part 2(Torrent)Part 3(Torrent)

U give link to database and server files part 2 and 3. U should add first part too

[•ᵔBeGodOfWarᵔ•]

Originally Posted by domiss1232

I think u give wrong link look at
U give link to database and server files part 2 and 3. U should add first part too

Thanks for attention me ! editing

[Incaner]

write there the Passwort of the vsro files