Reward per mob like EXP/SP

[devdash]

normally when we kill any mob/unique we get SP & EXP,
how can i add Honor points too, wish means after u kill the mob u get EXP & SP & HONOR POINTS,

and how can i do the same for arena kills,

thanks in advance.

[speed2019]

with mobs you only can use quests
with uniques you can use Trigger at Unique Log table

[devdash]

Originally Posted by speed2019

with mobs you only can use quests
with uniques you can use Trigger at Unique Log table

Unique log table ? where can i find that!

i have checked SHard & Account & Log

nothing call _Unique

[speed2019]

Evangelion_uniques

USE [SRO_VT_ACCOUNT]
GO
/****** Object: Trigger [dbo].[_UniqueRanking] Script Date: 4/3/2019 11:04:59 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create TRIGGER [dbo].[_UniqueRanking]
ON [SROACCOUNT1991].[dbo].[Evangelion_uniques]
after insert
as begin
DECLARE @ varchar(59) = (Select CharName from inserted)
DECLARE @Name varchar(128) = (Select MobName from inserted)
-- Start

exec UniqueRanking @ @Name -- Create your own Prodcure

END

[devdash]

Originally Posted by speed2019

Evangelion_uniques

USE [SRO_VT_ACCOUNT]
GO
/****** Object: Trigger [dbo].[_UniqueRanking] Script Date: 4/3/2019 11:04:59 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create TRIGGER [dbo].[_UniqueRanking]
ON [SROACCOUNT1991].[dbo].[Evangelion_uniques]
after insert
as begin
DECLARE @ varchar(59) = (Select CharName from inserted)
DECLARE @Name varchar(128) = (Select MobName from inserted)
-- Start

exec UniqueRanking @ @Name -- Create your own Prodcure

END

all that i have been trying, i can't make it still, can you please make it for me ?

just explain more...

i can't find that table call UniqueRanking.

[$WeGs]

just use sr_zor game server (search for it) it has unique logs

[B1Q]

u can use a filter to keep a record of mobs killed and their killers
only then you can reward a player per monster kill

all packets you need can be found here

as well as an achievement system (just a basic quest system built in filter. i don't have dbs)