قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
|
01-12-2019, 05:14 PM | #1 | ||||||||||
|
كود:
USE [SRO_VT_LOG] ---- Warrior Skills Scroll ---------------------------------- Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0) IF (@ItemRefID = 41806) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1 END END END END ---- Dagger Skills Scroll ---------------------------------- IF (@ItemRefID = 41807) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1 END END END END ---- Wizard Skills Scroll ---------------------------------- IF (@ItemRefID = 41805) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1 End END END End ---- Warlock Skills Scroll ---------------------------------- IF (@ItemRefID = 41810) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1 End END End End -- Bard Skills Scroll ------------------------------- IF (@ItemRefID = 41809) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1 End END End End -- Claric Skills Scroll --------------------------------- IF (@ItemRefID = 41808) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1 End End End END ---- Bicheon Skills Scroll ---------------------------------- IF (@ItemRefID = 41800) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1 End END End End ---- Heuksal Skills Scroll ---------------------------------- IF (@ItemRefID = 41799) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1 End END END End ---- Pacheon Skills Scroll ---------------------------------- IF (@ItemRefID = 41798) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1 End END End End ---- Cold Skills Scroll ------------------------------- IF (@ItemRefID = 41803) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1 End End End End ---- Lightning Skills Scroll ------------------------------------- IF (@ItemRefID = 41802) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1 End End End End ---- Fire Skills Scroll -------------------------------- IF (@ItemRefID = 41801) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1 End End End End ---- Force Skills Scroll --------------------------------- IF (@ItemRefID = 41804) -- RefObjCommon ID Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1 End End End END كود:
Msg 137, Level 15, State 2, Line 5 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 6 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 7 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 14 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 16 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 17 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 18 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 25 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 32 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 34 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 35 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 36 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 43 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 50 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 52 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 53 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 54 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 61 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 68 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 70 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 71 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 72 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 80 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 87 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 89 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 90 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 91 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 99 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 106 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 108 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 109 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 110 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 117 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 124 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 126 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 127 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 128 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 136 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 143 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 145 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 146 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 147 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 155 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 162 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 164 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 165 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 166 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 174 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 181 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 183 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 184 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 185 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 193 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 200 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 202 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 203 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 204 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 212 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 219 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 221 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 222 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 223 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 231 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 238 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 240 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 241 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 242 Must declare the scalar variable "@CharID". انا بستخدم SQL Server 2008 R2 Express يا ريت لو حد يقولي ايه الغلط اللي في الـ Procedure عشان اصلحه و الـError ده ميطلعش تاني |
||||||||||
التعديل الأخير تم بواسطة iRock ; 02-12-2019 الساعة 01:15 AM
|
01-12-2019, 08:08 PM | #2 | ||||||||||
|
ايوه عايز ايه برده ؟ |
||||||||||
|
02-12-2019, 01:16 AM | #3 | ||||||||||
|
عايز اعرف الError ده اصلحه ازاي |
||||||||||
|
02-12-2019, 06:46 PM | #4 | ||||||||||
|
شوف التابل عندك USE [SRO_VT_LOG] ولا اسمه ايه + هو اصلا انت بتعمل ايه ديكلير لايه التابل اللي هتضيف فيه ده موجود ؟ ولا هتعمله كريت اصلا ولا اليرت ليه ؟؟ حدد بلاش كوبي بست افهم انت بتعمل ايه |
||||||||||
|
02-12-2019, 09:56 PM | #5 | |||||||||||
|
اقتباس:
عملت التابل بالquery ده كود:
USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsBard] Script Date: 6/12/2017 12:17:19 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsBard]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsBicheon] Script Date: 6/12/2017 12:17:34 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsBicheon]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsClaric] Script Date: 6/12/2017 12:17:48 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsClaric]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsCold] Script Date: 6/12/2017 12:17:58 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsCold]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsFire] Script Date: 6/12/2017 12:18:08 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsFire]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsForce] Script Date: 6/12/2017 12:18:17 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsForce]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsHeuksal] Script Date: 6/12/2017 12:18:39 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsHeuksal]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsLightning] Script Date: 6/12/2017 12:18:49 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsLightning]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsPacheon] Script Date: 6/12/2017 12:18:58 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsPacheon]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsRogue] Script Date: 6/12/2017 12:19:07 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsRogue]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, CONSTRAINT [PK__SkillsRogue] PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsWarlock] Script Date: 6/12/2017 12:19:17 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsWarlock]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsWarrior] Script Date: 6/12/2017 12:19:26 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsWarrior]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, CONSTRAINT [PK__SkillsWarrior] PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[_SkillsWizard] Script Date: 6/12/2017 12:19:34 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_SkillsWizard]( [Service] [tinyint] NOT NULL, [SkillID] [int] NOT NULL, [SkillName] [varchar](max) NOT NULL, [MasteryID] [int] NULL, CONSTRAINT [PK__SkillsWizard] PRIMARY KEY CLUSTERED ( [SkillID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO |
|||||||||||
|
03-12-2019, 10:42 PM | #6 | |||||||||||
|
اقتباس:
|
|||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
Silk Scroll Procedure | BlackClover | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 2 | 07-04-2020 07:42 PM |
حصريا لاول مرة علي سيلكرود4عرب : Blue Devil Scroll Procedure | Story-Sro Owner | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 26 | 18-09-2018 06:48 AM |
مشكلة فى ال Plus Scroll | testmis | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 9 | 18-08-2018 11:21 PM |
مشكلة فى FB scroll | OoMasterOo | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 4 | 27-10-2017 05:14 PM |
Full Useful Procedure Scroll | Dev. iLegend | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 20 | 16-07-2017 05:38 PM |