H I T L E R
23-06-2020, 09:02 PM
جبتلكم انهارده Fortress Kill Counter
بيجمع الKills الMembers ال في ال جيلد بيجبها و كل ما يجيبو 100 كل يتكتب Notice
]Guildname has destroyed 50 Enimes[
بس لازم طبعا تكون شعال علي Vsro Multi Tolls لأني ظبطو عليه
و ده لينك الموضوع بتاع البرنامج
Vsro Multi Tools (https://www.silkroad4arab.com/vb/showthread.php?t=588584)
لينك تحميل النسخه الجديده من البرنامج مطوره من McDisel
تحميل Vsro Multi Tools (https://mega.nz/file/reBSmKzQ#4HNhMxHvmKrmpbugodLIzF5VWVH_1AN2ABfEQqad3 MM)
نبداء ب الTables
_FW_COUNTER
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_FW_COUNTER] Script Date: 23/06/2020 08:00:21 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_FW_COUNTER](
[No.] [int] IDENTITY(1,1) NOT NULL,
[Guild_Name] [varchar](max) NULL,
[kills] [int] NULL,
CONSTRAINT [PK___HITLERT__C7D1C6D019F64CE0] PRIMARY KEY CLUSTERED
(
[No.] 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
Trigger
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Trigger [dbo].[FW_COUNTER_NOTICE] Script Date: 23/06/2020 08:01:44 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[FW_COUNTER_NOTICE]
ON [dbo].[_FW_COUNTER]
after insert,update,delete
as
---------------------------- Q1 -----------------------------------------------------------------
declare @Guildname Varchar(100)
SET @Guildname = (select Guild_name from _FW_COUNTER)
declare @kills int = (select kills from _FW_COUNTER)
IF @Kills IN (50, 100, 200, 300, 400, 600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1600, 1700, 1800, 2000, 2100, 2200, 2300, 2400, 2500, 2600, 2800, 2900, 3000)
insert into SRO_VT_SHARDLOG..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',''+@Guildname+' has destroyed '+CAST(@kills as nvarchar)+' Enimes',Getdate())
GO
_AddLogChar
DECLARE @Killer1 Varchar(64),
@Killer2 Varchar(64),
@Charname Varchar(100),
@Guildname Varchar(100)
SET @Killer1 = SUBSTRING(@Desc, CHARINDEX('His(', @Desc), CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))
SET @killer2 = REPLACE(@Killer1,'His(','');
SET @killer2 = REPLACE(@Killer2,'): no job,','');
SET @Charname = (Select Charname16 From SRO_VT_SHARD.._Char Where CharID = @CharID)
SET @Guildname = (Select name From SRO_VT_SHARD.._Guild Where ID = (select GuildID from SRO_VT_SHARD.._Char Where CharName16 = @Killer2))
declare @kills int = (select kills from _FW_COUNTER)
If (@EventID = '20' and @strPos like '%0x%' and @Desc like '%freebattle%')
begin
If exists (select * from SRO_VT_SHARDLOG.._FW_COUNTER where Guild_name = @Guildname)
begin
Update SRO_VT_SHARDLOG.._FW_COUNTER Set Kills = Kills+1 where Guild_name = @Guildname
End
ELSE Insert Into SRO_VT_SHARDLOG.._FW_COUNTER (Guild_name,kills) values (@Guildname,1)
End
بالتوفيق :Emoji2:
بيجمع الKills الMembers ال في ال جيلد بيجبها و كل ما يجيبو 100 كل يتكتب Notice
]Guildname has destroyed 50 Enimes[
بس لازم طبعا تكون شعال علي Vsro Multi Tolls لأني ظبطو عليه
و ده لينك الموضوع بتاع البرنامج
Vsro Multi Tools (https://www.silkroad4arab.com/vb/showthread.php?t=588584)
لينك تحميل النسخه الجديده من البرنامج مطوره من McDisel
تحميل Vsro Multi Tools (https://mega.nz/file/reBSmKzQ#4HNhMxHvmKrmpbugodLIzF5VWVH_1AN2ABfEQqad3 MM)
نبداء ب الTables
_FW_COUNTER
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_FW_COUNTER] Script Date: 23/06/2020 08:00:21 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_FW_COUNTER](
[No.] [int] IDENTITY(1,1) NOT NULL,
[Guild_Name] [varchar](max) NULL,
[kills] [int] NULL,
CONSTRAINT [PK___HITLERT__C7D1C6D019F64CE0] PRIMARY KEY CLUSTERED
(
[No.] 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
Trigger
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Trigger [dbo].[FW_COUNTER_NOTICE] Script Date: 23/06/2020 08:01:44 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[FW_COUNTER_NOTICE]
ON [dbo].[_FW_COUNTER]
after insert,update,delete
as
---------------------------- Q1 -----------------------------------------------------------------
declare @Guildname Varchar(100)
SET @Guildname = (select Guild_name from _FW_COUNTER)
declare @kills int = (select kills from _FW_COUNTER)
IF @Kills IN (50, 100, 200, 300, 400, 600, 700, 800, 900, 1000, 1100, 1200, 1300, 1400, 1600, 1700, 1800, 2000, 2100, 2200, 2300, 2400, 2500, 2600, 2800, 2900, 3000)
insert into SRO_VT_SHARDLOG..iLegend_Tool (Service,Type,Message,Date) Values (1,'Notice',''+@Guildname+' has destroyed '+CAST(@kills as nvarchar)+' Enimes',Getdate())
GO
_AddLogChar
DECLARE @Killer1 Varchar(64),
@Killer2 Varchar(64),
@Charname Varchar(100),
@Guildname Varchar(100)
SET @Killer1 = SUBSTRING(@Desc, CHARINDEX('His(', @Desc), CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))
SET @killer2 = REPLACE(@Killer1,'His(','');
SET @killer2 = REPLACE(@Killer2,'): no job,','');
SET @Charname = (Select Charname16 From SRO_VT_SHARD.._Char Where CharID = @CharID)
SET @Guildname = (Select name From SRO_VT_SHARD.._Guild Where ID = (select GuildID from SRO_VT_SHARD.._Char Where CharName16 = @Killer2))
declare @kills int = (select kills from _FW_COUNTER)
If (@EventID = '20' and @strPos like '%0x%' and @Desc like '%freebattle%')
begin
If exists (select * from SRO_VT_SHARDLOG.._FW_COUNTER where Guild_name = @Guildname)
begin
Update SRO_VT_SHARDLOG.._FW_COUNTER Set Kills = Kills+1 where Guild_name = @Guildname
End
ELSE Insert Into SRO_VT_SHARDLOG.._FW_COUNTER (Guild_name,kills) values (@Guildname,1)
End
بالتوفيق :Emoji2: