FTW reward

[#3mr]

اول حاجه شوف الى هتبعته مفتوح فى RefObjCommen
ولا لا
وبعدين

اعمل الكيورى ده الاول

DECLARE @CharName VARCHAR(64), @GuildID VARCHAR(64) DECLARE @ItemCodeName VARCHAR(64) = 'Item Code' DECLARE item_cur CURSOR FOR SELECT DISTINCT CharName FROM ___FortressReward ORDER BY CharName OPEN item_cur FETCH NEXT FROM item_cur INTO @CharName WHILE @@FETCH_STATUS = 0 BEGIN EXEC _ADD_ITEM_EXTERN @CharName, @ItemCodeName, 20, 1 FETCH NEXT FROM item_cur INTO @CharName END PRINT @CharName CLOSE item_cur DEALLOCATE item_cur

اعمل تابل باسم FortressReward__

واضرب الكيورى ده

USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[___FortressReward] Script Date: 9/23/2014 5:31:53 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[___FortressReward]( [GuildID] [int] NOT NULL, [CharID] [int] NOT NULL, [CharName] [varchar](64) NOT NULL, [MemberClass] [tinyint] NOT NULL, [CharLevel] [tinyint] NOT NULL, [GP_Donation] [int] NOT NULL, [JoinDate] [smalldatetime] NOT NULL, [Permission] [int] NULL, [Contribution] [int] NULL, [GuildWarKill] [int] NULL, [GuildWarKilled] [int] NULL, [Nickname] [varchar](64) NULL, [RefObjID] [int] NULL, [SiegeAuthority] [tinyint] NULL, CONSTRAINT [PK_______GuildMember] PRIMARY KEY CLUSTERED ( [GuildID] ASC, [CharID] 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].[___FortressReward] ADD DEFAULT ((0)) FOR [RefObjID] GO ALTER TABLE [dbo].[___FortressReward] ADD DEFAULT ((0)) FOR [SiegeAuthority] GO

اسم الجيلد عن طريق id

Select * From _Guild Where Name = 'GuildName'

Select * From _GuildMember Where GuildID = 'GuildID'

[stafherp]

المشاركة الأصلية كتبت بواسطة #3mr عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] اول حاجه شوف الى هتبعته مفتوح فى RefObjCommen ولا لا وبعدين اعمل الكيورى ده الاول DECLARE @CharName VARCHAR(64), @GuildID VARCHAR(64) DECLARE @ItemCodeName VARCHAR(64) = 'Item Code' DECLARE item_cur CURSOR FOR SELECT DISTINCT CharName FROM ___FortressReward ORDER BY CharName OPEN item_cur FETCH NEXT FROM item_cur INTO @CharName WHILE @@FETCH_STATUS = 0 BEGIN EXEC _ADD_ITEM_EXTERN @CharName, @ItemCodeName, 20, 1 FETCH NEXT FROM item_cur INTO @CharName END PRINT @CharName CLOSE item_cur DEALLOCATE item_cur اعمل تابل باسم FortressReward__ واضرب الكيورى ده USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[___FortressReward] Script Date: 9/23/2014 5:31:53 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[___FortressReward]( [GuildID] [int] NOT NULL, [CharID] [int] NOT NULL, [CharName] [varchar](64) NOT NULL, [MemberClass] [tinyint] NOT NULL, [CharLevel] [tinyint] NOT NULL, [GP_Donation] [int] NOT NULL, [JoinDate] [smalldatetime] NOT NULL, [Permission] [int] NULL, [Contribution] [int] NULL, [GuildWarKill] [int] NULL, [GuildWarKilled] [int] NULL, [Nickname] [varchar](64) NULL, [RefObjID] [int] NULL, [SiegeAuthority] [tinyint] NULL, CONSTRAINT [PK_______GuildMember] PRIMARY KEY CLUSTERED ( [GuildID] ASC, [CharID] 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].[___FortressReward] ADD DEFAULT ((0)) FOR [RefObjID] GO ALTER TABLE [dbo].[___FortressReward] ADD DEFAULT ((0)) FOR [SiegeAuthority] GO اسم الجيلد عن طريق id Select * From _Guild Where Name = 'GuildName' Select * From _GuildMember Where GuildID = 'GuildID'

بوص الكويرى الاول دة طالب itmes code دة احط فيها اية بظبط والكويرى دة بيتحط فى مكان مش نيو كويرى وخلاص والاتنين كويرى الاخير مش دة المفروض اوتامتيك بيدها للجيلد الكسبان ولا لازم انا ال اديهم