please i need this system

[AmirBabiliOn]

how i can give a player item when getting level

example:

when _char get level 20 and 30 and 40 and 50 ..etc
give 'here the item code to give them'

please i need this system

[MentaL]

[AmirBabiliOn]

any help

[Brad Alfred]

i just find this .. maybe can help u

[Release] Get a reward after reaching max level

Here we go ^^
1- create this table

Quote:
USE [SRO_VT_SHARDLOG]
GO

/****** Object: Table [dbo].[MaxLeveL_Log] Script Date: 10/12/2014 1:48:39 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MaxLevel_Log](
[CharID] [int] NULL
) ON [PRIMARY]

GO


then add this to _AddLogChar ^^

Quote:
Declare @MaxLevelCount int = (Select Count(CharID) from MaxLevel_Log)
declare @userJID int = (select UserJID from SRO_VT_SHARD.._User where CharID @CharID)
declare @CharName varchar(max) = (select charname16 from SRO_VT_SHARD.._Char where CharID = @CharID)
if (@EventID = '22' and @DaTa2 = '110')
begin
insert MaxLevel_Log (CharID) values @CharID)
begin
if @MaxLevelCount <= 50
begin
insert into PlusNotice (sent,Message)values(0 @Charname +' has reached level 110, ' + @MaxLevelCount + '/50')
Update SRO_VT_ACCOUNT..SK_Silk set silk_own += 150 where JID = @userJID
end
end
end