This is a discussion on VSRO Server Files [v188] within the SilkRoad Releases forums, part of the SilkRoad Online category; Server Files
Part 1
Spoiler : Deposit Files
Part 2
Spoiler : Deposit Files
Part 3
Spoiler : Deposit Files
...
Missing Procedures and Tables SRO_VT_SHARD --> _ExistsServiceOffRentItem Procedure
Spoiler:
PHP Code:
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_ExistsServiceOffRentItem] as
if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) ) begin return -1 end GO
SRO_VT_ACCOUNT --> SK_gamebang_ip
Spoiler:
PHP Code:
USE [SRO_VT_ACCOUNT] GO /****** Object: Table [dbo].[SK_gamebang_ip] Script Date: 09/13/2011 12:05:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SK_gamebang_ip]( [ip] [int] NULL, [capacity] [int] NULL ) ON [PRIMARY] GO
SRO_VT_ACCOUNT --> dbo._PrivilegedIP
Spoiler:
PHP Code:
USE [SRO_VT_ACCOUNT] GO /****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DROP TABLE _PrivilegedIP GO CREATE TABLE [dbo].[_PrivilegedIP]( [IP1] [tinyint] NOT NULL, [IP2] [tinyint] NOT NULL, [IP3] [tinyint] NOT NULL, [IP4] [tinyint] NOT NULL, [IP5] [tinyint] NOT NULL, [IP6] [tinyint] NOT NULL, [IP7] [tinyint] NOT NULL, [IP8] [tinyint] NOT NULL ) ON [PRIMARY] GO