Make automatic notice!

05/03/2018 07:56 [gm]noob#1
done
05/03/2018 17:00 {Skrillex}#2
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 => [Only registered and activated users can see links. Click Here To Register...]

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:.
05/03/2018 23:58 wurstbrot123#3
[Only registered and activated users can see links. Click Here To Register...] maybe this helps you ? =)
05/04/2018 00:28 AnimuNazi#4
That's a bad idea mate, all those spams is gonna be annoying.
05/05/2018 01:12 [GM]SkyLine.™#5
First apply skrillex text and make this steps,

Code:
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"

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.