Make automatic notice!

[[gm]noob]

done

[{Skrillex}]

Hi,
idk why you shuld use this kind of notice on an shaiya server because of spamming. But If you want to install it okay.

1. Work with the ActionLog Procedure or (better) an GameLog.dbo.ActionLog Trigger.

You need to know the ActionType from an Player PvP Kill.
You need this =>

With a bit of sql knowledge it should be no Problem to solve this kind of notice.

If you don´t able to install feel free to contact me.

Sorry for my bad English.

Regards

.:Skrillex:.

[wurstbrot123]

maybe this helps you ? =)

[AnimuNazi]

That's a bad idea mate, all those spams is gonna be annoying.

[[GM]SkyLine.™]

First apply skrillex text and make this steps,

USE [PS_GameLog]
GO

--Object: Table [dbo].[Boss_Death_Log] Script Date: 6/18/2016 12:17:17 PM 
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Boss_Death_Log](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[MobID] [int] NOT NULL,
[MobName] [varchar](30) NOT NULL,
[UserUID] [int] NOT NULL,
[CharName] [nvarchar](50) NOT NULL,
[MapID] [tinyint] NOT NULL,
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[ActionTime] [datetime] NOT NULL DEFAULT (getdate()),
CONSTRAINT [PK_Boss_Death_Log] PRIMARY KEY CLUSTERED 
(
[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

if you do not using trigger put this codes below "AS"

 Spoiler

IF @Type = 173 AND @ = 'death' -- boss death, only applies to the ones from the Obelisk.ini
BEGIN
SET @ID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharName = @3)
INSERT INTO PS_GameLog.dbo.Boss_Death_Log VALUES (@Value3, @, @ID, @3, @D, @X, @, @, @)
DECLARE @value int
DECLARE @ varchar(max)
SET @ = N'/nt ' + @ + ' Killed By ' + @3 + '.'
EXEC @value = [SK_WEB].[dbo].[Command]=>change with your db.
@Name = N'ps_game',
@d = @

END

I give your basicly tactic, for stamp map names in notice please use brain.exe
Credits goes to [DEV]Arkham and betalfa for this amazing system.