Jon Kyd
23-09-2014, 07:32 AM
كل ادمين بيبقى عاوز يدى كل واحد فى الجيلد الايتم رورد الفورترس لى وحدة
ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL
ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL
ITEM_EVENT_HP_INC_4100_POTION
ITEM_EVENT_MP_INC_4100_POTION
ITEM_EVENT_HWAN_POTION
ITEM_EVENT_RENT_GLOBAL_CHATTING
Sending Query
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
Create Table __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
كيفيةالاستخدام
1- انت مثلا عاوز تبعت 20 زرك لكل واحد فى الجيلد هتاخد كود من فوق وتحتة فى Sending Query
2- Do Query on SRO_VT_SHARD
Select * From _Guild Where Name = 'GuildName'
3- خود ID Guild and Do Other Query
Select * From _GuildMember Where GuildID = 'GuildID'
4- خود كل الى ظهر قدامك وحتة فى ٍ __FortressReward ال Table
وبعدين Execute The Query of Sending Item
Its Toke SomeTimes
Note This 2 Point
1-i Disable Some Item Code on RefObjCommen Cannot Trade Or Put on Storage or Drop Or Put on Grap He Can use or Just Sell On NPC
2-Write Notice Please Empty Some Slot On Inventory To Send Fortress Reward
Query to Disable Item Trade Etc
Update _RefObjCommon Set CanTrade = '0' ,CanBuy = '0' ,CanDrop ='0' Where CodeName128 = 'CodeItem'
Make Sure After Finish Use This Query
USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE [dbo].[___FortressReward]
ITEM_EVENT_RENT_DAMAGE_ABS_20P_SCROLL
ITEM_EVENT_RENT_DAMAGE_INC_20P_SCROLL
ITEM_EVENT_HP_INC_4100_POTION
ITEM_EVENT_MP_INC_4100_POTION
ITEM_EVENT_HWAN_POTION
ITEM_EVENT_RENT_GLOBAL_CHATTING
Sending Query
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
Create Table __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
كيفيةالاستخدام
1- انت مثلا عاوز تبعت 20 زرك لكل واحد فى الجيلد هتاخد كود من فوق وتحتة فى Sending Query
2- Do Query on SRO_VT_SHARD
Select * From _Guild Where Name = 'GuildName'
3- خود ID Guild and Do Other Query
Select * From _GuildMember Where GuildID = 'GuildID'
4- خود كل الى ظهر قدامك وحتة فى ٍ __FortressReward ال Table
وبعدين Execute The Query of Sending Item
Its Toke SomeTimes
Note This 2 Point
1-i Disable Some Item Code on RefObjCommen Cannot Trade Or Put on Storage or Drop Or Put on Grap He Can use or Just Sell On NPC
2-Write Notice Please Empty Some Slot On Inventory To Send Fortress Reward
Query to Disable Item Trade Etc
Update _RefObjCommon Set CanTrade = '0' ,CanBuy = '0' ,CanDrop ='0' Where CodeName128 = 'CodeItem'
Make Sure After Finish Use This Query
USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE [dbo].[___FortressReward]