Help AddLogChar

[thangchohd0]

Hello community!
I have a problem that I find out a lot on forums and google but it doesn't solve, so post it for fear of helping people, please someone please help me.
I want to add the query to SRO_VT_LOG Addlogchar so that when the character reaches level 13 21 .... they will receive the item I set for themselves.
Thanks for everyone's reading

[devdash]

Here we go

I think you're asking for auto equipment system
here it's


Hope this helps you.

[thangchohd0]

Originally Posted by alydandy

Here we go

I think you're asking for auto equipment system
here it's


Hope this helps you.

this is autoequipment it is buggy, I just want 1 query for addlogchar so that when the level nv will get exactly 1 item I add it

[elmagico321]

Originally Posted by thangchohd0

this is autoequipment it is buggy, I just want 1 query for addlogchar so that when the level nv will get exactly 1 item I add it

well i don't understand for what exactly but i think that is what you are asking for !! adding 1 item to char on 1 level
add this to your logchar

declare @CurLevel int = (select top 1 CurLevel from SRO_VT_SHARD.._Char where CharID=@CharID)
declare @CharName varchar(64) = (select top 1 CharName16 from SRO_VT_SHARD.._Char where CharID=@CharID)
IF @EventID = 22 AND @CurLevel = 13
BEGIN
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName,'ITEM CODE',1,1
END

[thangchohd0]

Originally Posted by elmagico321

well i don't understand for what exactly but i think that is what you are asking for !! adding 1 item to char on 1 level
add this to your logchar

I installed the following

 Spoiler

declare @evel int = (select CurLevel from SRO_VT_SHARD.._Char where CharID @ID)
declare @ varchar(64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID @ID)
IF (@EventID = 22) AND @evel = 29) OR @evel = 37) OR @evel = 13) OR @evel = 21) OR @evel = 47) OR @evel = 57) OR @evel = 69) OR @evel = 81)
BEGIN
exec [SRO_VT_SHARD].[dbo]._ADD_ITEM_EXTERN @,'ITEM_EVENT_AUTOEQUIP_COUPON',1,0
END

But I have an error that I just need to teleport back and get enough items from the previous level

[sonzenbi]

 Spoiler

declare @ int = (select Maxlevel from SRO_VT_SHARD.._Char with (nolock) where CharID @ID)
declare @ varchar(64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID @ID)
IF (@EventID = 22) and @2 in (22,29,37,vv.v.) and @2 > @)
BEGIN
exec [SRO_VT_SHARD].[dbo]._ADD_ITEM_EXTERN @,'ITEM_EVENT_AUTOEQUIP_COUPON',1,0
END