Reward per mob like EXP/SP

04/03/2019 09:56 devdash#1

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.

04/03/2019 10:17 speed2019#2

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

04/03/2019 10:25 devdash#3

Quote:

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

04/03/2019 23:05 speed2019#4

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 @[Only registered and activated users can see links. Click Here To Register...] varchar(59) = (Select CharName from inserted)
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Name varchar(128) = (Select MobName from inserted)
-- Start

exec UniqueRanking @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]Name -- Create your own Prodcure

END

04/04/2019 18:27 devdash#5

Quote:

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 @[Only registered and activated users can see links. Click Here To Register...] varchar(59) = (Select CharName from inserted)
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Name varchar(128) = (Select MobName from inserted)
-- Start

exec UniqueRanking @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]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.

04/05/2019 02:59 $WeGs#6

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

04/05/2019 07:55 B1Q#7

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
[Only registered and activated users can see links. Click Here To Register...]
as well as an achievement system (just a basic quest system built in filter. i don't have dbs)