| H I T L E R |
30-11-2020 02:00 AM |
]Exclusive[ Fortress Counter By Notice
حاجه بسيطه كدا للابطال ال في المنتدي ❤
متنساش لازم تكون شغال ب VSro Multi Tools
لو قبلك اي مشكله كلمني علطول احلهالك
Table
كود:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_FW_COUNTER] Script Date: 11/29/2020 5:40:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_FW_COUNTER](
[No.] [int] IDENTITY(1,1) NOT NULL,
[Guild_Name] [varchar](max) NOT 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
AddlogChar
كود:
DECLARE @Killer1 Varchar(64),
@Killer2 Varchar(64),
@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 @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 Guild_Name 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 If not exists (select Guild_Name from SRO_VT_SHARDLOG.._FW_COUNTER where Guild_name = @Guildname)
begin
Insert Into SRO_VT_SHARDLOG.._FW_COUNTER (Guild_name,kills) values (@Guildname,1)
End
end
declare @Guildname2 Varchar(100) = (select Guild_name from _FW_COUNTER )
declare @kills2 int = (select top 1 kills from _FW_COUNTER where Guild_Name = @Guildname order by kills desc)
IF @Eventid = 20 and @Kills2 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)
begin
insert into SRO_VT_SHARDLOG..iLegend_Tool
(Service,Type,Message,Date)
Values
(1,'Notice',''+@Guildname+' has Killed '+CAST(@kills2 as nvarchar)+' Enimes',Getdate())
end
|
