الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   مشكلة في Procedure لـSkill Scroll (https://silkroad4arab.com/vb/showthread.php?t=633443)

iRock 01-12-2019 05:14 PM
مشكلة في Procedure لـSkill Scroll
 
كود:
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
Error
كود:
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 ده ميطلعش تاني

محمد منتصر 01-12-2019 08:08 PM
رد: مشكلة في Procedure لـSkill Scroll
 
ايوه عايز ايه برده ؟

iRock 02-12-2019 01:16 AM
رد: مشكلة في Procedure لـSkill Scroll
 
عايز اعرف الError ده اصلحه ازاي

محمد منتصر 02-12-2019 06:46 PM
رد: مشكلة في Procedure لـSkill Scroll
 
شوف التابل عندك USE [SRO_VT_LOG] ولا اسمه ايه
+ هو اصلا انت بتعمل ايه ديكلير لايه التابل اللي هتضيف فيه ده موجود ؟ ولا هتعمله كريت اصلا ولا اليرت ليه ؟؟ حدد بلاش كوبي بست افهم انت بتعمل ايه

iRock 02-12-2019 09:56 PM
رد: مشكلة في Procedure لـSkill Scroll
 
اقتباس:
المشاركة الأصلية كتبت بواسطة محمد منتصر (المشاركة 5375369)
شوف التابل عندك USE [SRO_VT_LOG] ولا اسمه ايه
+ هو اصلا انت بتعمل ايه ديكلير لايه التابل اللي هتضيف فيه ده موجود ؟ ولا هتعمله كريت اصلا ولا اليرت ليه ؟؟ حدد بلاش كوبي بست افهم انت بتعمل ايه
طبعا التابل كلها موجوده يا باشا و ال ID كلها صح و انا راجعت عليهم اكتر من مره

عملت التابل بال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
رد: مشكلة في Procedure لـSkill Scroll
 
اقتباس:
المشاركة الأصلية كتبت بواسطة iRock (المشاركة 5375376)


طبعا التابل كلها موجوده يا باشا و ال ID كلها صح و انا راجعت عليهم اكتر من مره

عملت التابل بال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:57 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2024, vBulletin Solutions, Inc.