شـريـط الاهـداءات |
|
| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
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
|
| إعلانات google |
|
|
|
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 زائر) | |
|
|
.gif){kind=icon}
العرض العادي
