Stored Produce Uniques

[loader8]

Hi guys! im working in a Stored Produce to give something to a player when he kill a Unique
but i got a problem i dont know how to get witch Unique is killed
who can help me with that.

[bimbum*]

Originally Posted by loader8

Hi guys! im working in a Stored Produce to give something to a player when he kill a Unique
but i got a problem i dont know how to get witch Unique is killed
who can help me with that.

simple one

[Chigako]

Originally Posted by bimbum*

simple one

It would be much more useful and quality work to give a reward to the player with a bot that controls the unique death package.

[loader8]

Originally Posted by bimbum*

simple one

thx so much!

Originally Posted by Chigako

It would be much more useful and quality work to give a reward to the player with a bot that controls the unique death package.

why ?
package vs stored produce

[Chigako]

Originally Posted by loader8

thx so much!



why ?
package vs stored produce

When I looked at the procedure he shared, I saw that there were too many event ids entered. I do not find it correct to add this extra load to _AddLogChar running by GameServer. Awarding awards with the bot will be much more convenient and safe.

[loader8]

Originally Posted by bimbum*

simple one

i see the produce is the same problem that i got how i get the value for @ed

declare @id int = (select id from SRO_VT_SHARD.._refobjcommon where codename128 = @ed and service =1 )

@ed
that is my problem i dont know how to get it

[bimbum*]

Originally Posted by loader8

i see the produce is the same problem that i got how i get the value for @ed

declare @id int = (select id from SRO_VT_SHARD.._refobjcommon where codename128 = @ed and service =1 )

@ed
that is my problem i dont know how to get it

declare @ed varchar(max) = (select CodeName128 from SRO_VT_SHARDLOG.._UniquesLog where id=(select max (id) from SRO_VT_SHARDLOG.._UniquesLog))

[loader8]

Originally Posted by bimbum*

declare @ed varchar(max) = (select CodeName128 from SRO_VT_SHARDLOG.._UniquesLog where id=(select max (id) from SRO_VT_SHARDLOG.._UniquesLog))

my DB SHARDLOG do not have the table and dont have the produce that insert into that table the Nickname and the ID Unique