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 دة احط فيها اية بظبط والكويرى دة بيتحط فى مكان مش نيو كويرى وخلاص والاتنين كويرى الاخير مش دة المفروض اوتامتيك بيدها للجيلد الكسبان ولا لازم انا ال اديهم