Help AddLogChar

05/19/2020 07:38 thangchohd0#1
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
05/19/2020 07:40 devdash#2
Here we go

I think you're asking for auto equipment system
here it's
[Only registered and activated users can see links. Click Here To Register...]

Hope this helps you.
05/19/2020 07:49 thangchohd0#3
Quote:
Originally Posted by alydandy View Post
Here we go

I think you're asking for auto equipment system
here it's
[Only registered and activated users can see links. Click Here To Register...]

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
05/20/2020 01:53 elmagico321#4
Quote:
Originally Posted by thangchohd0 View Post
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
Quote:
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
05/24/2020 11:36 thangchohd0#5
Quote:
Originally Posted by elmagico321 View Post
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
But I have an error that I just need to teleport back and get enough items from the previous level
05/25/2020 19:12 sonzenbi#6