Everything about sro files / coding / reversing

Quote:

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 :D 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. ….�? [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] “Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.�? [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] 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’. 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. [Only registered and activated users can see links. Click Here To Register...] In Object Explorer, right click on the instance name and select Properties. [Only registered and activated users can see links. Click Here To Register...] 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. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] There’ll be an information window shows that you need to restart SQL Server to takes effect of the changes. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] Right-click on the instance name again, select Restart to restart SQL Server service. [Only registered and activated users can see links. Click Here To Register...] Select Yes. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] Wait for service stop and start. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] 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 Open SQL Server Surface Area Configuration. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] Select Surface Area Configuration for Services and Connections. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] 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. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] 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. [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] You have finished configure. Now try to login to your SQL Server from remote computer using SQL Server authentication mode. [Only registered and activated users can see links. Click Here To Register...] Login to SQL Server succeeded. [Only registered and activated users can see links. Click Here To Register...] 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 ! [Only registered and activated users can see links. Click Here To Register...] 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 :) )

Quote:

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 [Only registered and activated users can see links. Click Here To Register...] 2- Pk2Editor.exe [Only registered and activated users can see links. Click Here To Register...] Steps : 1- Open PK2ExtractorSE.exe and open media From it then Extract " refpackageitem.txt " Code: /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 Code: 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

Quote:

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 [Only registered and activated users can see links. Click Here To Register...] 2. [Only registered and activated users can see links. Click Here To Register...] 3. [Only registered and activated users can see links. Click Here To Register...] 4. finish . [Only registered and activated users can see links. Click Here To Register...] Restart ur Server and have fun . i hope its usefull ;) Greetz Kev

Quote:

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 ---------------------------------------------------------------------- -- &#3616;ฺภฏมขฑูภฬ ฐกดษวัม๖ธฆ ศฎภฮวฯฑโ ภงวั วมทฮฝรมฎ  ---------------------------------------------------------------------- CREATE PROCEDURE [dbo].[_CheckFreeAccess]     @JID        INT,     @ShardID    INT AS     -- &#3623;ุด็ JID ภว วุด็ ปตๅภว BanLvl ภฬ ฑโบปภฬ พฦดั พึต้ฟก EndTime ภป ฐกมฎฟยดู.      DECLARE @EndTIme DATETIME      SET @EndTIme = 0     -- &#3623;๖ภ็ ผณฐ่ ป๓ 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 ---------------------------------------------------------------------- -- &#3603;ฏยฅฐก ม๖ณญ พึต้ภบ ป่มฆวุ น๖ธฐดู. ---------------------------------------------------------------------- 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     -- &#3608;ีภ๚ ฑโฐฃภฬ ม๖ณญ ณัภบ ม๖ฟ๖ น๖ธฐดู!     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         -- &#3607;นฤฺตๅฐก พ๘ดย ฐๆฟ์ ด๕นฬภป บธณปมึภฺ.         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())     -- &#3616;ฯน ฑโฐฃมฆ พฦภฬลภว ป็ฟ๋ภบ วุด็ ฤณธฏลอทฮ ฑนวัตศดู.     INSERT INTO _FreeAccessBanLvl VALUES (@JID, @BanLevel, @EndDate) -----------------------------------------------------------------------------------------------------------------------     --[ Start !!! ] 2009.05.12. FREE_ACCESS &#3600;ณผฑ by ta4rom -----------------------------------------------------------------------------------------------------------------------     --AccountDB &#3617;ขผำ มคบธฟอ ตฅภฬลอบฃภฬฝบภฬธงภบ ม๗มข วฯตๅ ฤฺต๙ตวพ๎มฎ ภึดู. กฺ บฮบะ ศฎภฮ      IF @BanLevel = 4      BEGIN    -- &#3609;ทนบง 4ภฯ ฐๆฟ์ฟกธธ, AcountDB ฟก วุด็ มคบธธฆ ณฒฑไดู.          INSERT INTO SRO_VT_ACCOUNT.dbo._FreeAccess VALUES (@JID, @EndDate, @ShardID )         -- &#3585;ฺ _Account_For_SMC ภว Account DB ตฅภฬลอบฃภฬฝบธํภธทฮ พหธยฐิ ผ๖มค      END  -----------------------------------------------------------------------------------------------------------------------     --[ End !!! ] 2009.05.12. FREE_ACCESS &#3600;ณผฑ by ta4rom -----------------------------------------------------------------------------------------------------------------------              -- &#3611;ตๅธลดฯภ๚ฟกฐิ พหทมมึฑโ ภงวุ ภฬ มภป วัดู. -_-     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)     -- &#3611;ตๅธลดฯภ๚ฟกฐิ พหทมมึฑโ ภงวุ ภฬ มภป วัดู. -_-     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////

Quote:

Originally Posted by evelknievel10 This Thread contains many Assembly edits which are useful if you run a Vsro P-Server. Requirments: Ollydbg ([Only registered and activated users can see links. Click Here To Register...]) Dezimal -> Hex Converter ([Only registered and activated users can see links. Click Here To Register...] or [Only registered and activated users can see links. Click Here To Register...]) 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 [Only registered and activated users can see links. Click Here To Register...] - 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. Code: 004E52C7 |. 80F9 50 CMP CL,6E Press CTRL+G and fill in 004E52C7 It will bring you to this line. [Only registered and activated users can see links. Click Here To Register...] DoubleClick on CMP CL,6E and edit it to CMP CL,(Your max lv in hex) For example Code: CMP CL,78 for lv 120. Additional fix to prevent crash after lv 110:  Spoiler This is the line. Code: 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: Code: 004E5471 817C24 20 E00>cmp dword ptr [esp+20], 1E0 Changing Max Mastery Level:  Spoiler This is the line: Code: 0059C5E6 |. 3D 2C010000 CMP EAX,14A Change 12C to the Max mastery level you want in hex. For example: Code: CMP EAX, 168 //for Mastery 360 Serverrates cap:  Spoiler These are the lines. For Expoint rates: Code: 00B45B90 . 0000C842 DD FLOAT 100.0000 For Drop rates Code: 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. Code: 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. [Only registered and activated users can see links. Click Here To Register...] Now to the SRO_Client.exe edits. Changing mastery showup:  Spoiler This is the line: Code: 006A51BC |. BF 2C010000 MOV EDI,14A Change 14A to the Mastery limit you use in your GameServer. for example Code: 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: Code: 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: Code: 005448B1 80B8 AC000000 7 CMP BYTE PTR DS:[EAX+0AC],6E Change Code: 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 [Only registered and activated users can see links. Click Here To Register...]) 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 ([Only registered and activated users can see links. Click Here To Register...] 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