system

[revldo1]

i want frist player arrived level 110 take reward silk

[DeviasOnline]

[revldo1]

up

[leo2111]

Read that fking post omg! Up what?!

[blapanda]

It is simple:
He wants it ready to use, on this page.

Here you go:
-

This is not working due to the stupid "@"-mention tagging (despite [code] and [php] tagging. Thanks epvpshizzl), download the text file and just execute the query as usual:

[leo2111]

Edited post

[blapanda]

Originally Posted by leo2111

DECLARE @Count INT,
@JID INT,
@ varchar(50),

SELECT @JID = u.UserJID, @ = c.CharName16 FROM SRO_VT_SHARD.._User u INNER JOIN SRO_VT_SHARD.._Char c ON u.CharID = c.CharID WHERE u.CharID = @D
SELECT @Count = COUNT(CharID) FROM MaxLevel_Log
IF(@EventID = 22 AND @2 = 110)
BEGIN
IF NOT EXISTS(SELECT CharID FROM MaxLevel_Log WHERE CharID = @D)
BEGIN
IF @Count <= 50
BEGIN
INSERT INTO PlusNotice (sent,Message) VALUES (0 @ + ' has reached level 110,' + @Count + '/50')
UPDATE SRO_VT_ACCOUNT..SK_Silk SET silk_own = silk_own + 150 WHERE JID = @JID
END
END
END

You dummy, that is not the entire query, and not even sure where to add it. Leave him using my query!

[leo2111]

He won't click on that link

[blapanda]

You are probably right.

Lemme try this

USE [SRO_VT_LOG]
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]

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 07.04.2017 14:50:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogChar]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as

-- Event detection
INSERT INTO [_EventDetect] VALUES (@CharID, @eventID, @data1, @data2, @strPos, @desc, GetDate())

IF ( -- Skips over the unnecessary Records
(@EventID != 11) AND
(@EventID NOT BETWEEN 21 AND 27) AND
(@EventID NOT BETWEEN 200 AND 202) AND
(@EventID NOT BETWEEN 204 AND 206) AND
(@EventID != 210) AND (@EventID != 214) AND (@EventID != 244)
)BEGIN

declare @len_pos int
declare @len_desc int
set @len_pos = len(@strPos)
set @len_desc = len(@Desc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventChar values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
end
else
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
end

IF (@EventID = 19)
BEGIN
UPDATE SRO_VT_SHARD.dbo._ClientConfig
SET Data = 1677722602, SlotType = 74
WHERE SlotSeq = 0
AND CharID = @CharID
END
GO
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
END

USE master;
DROP DATABASE SRO_VT_SHARDLOG, SRO_VT_LOG, SRO_VT_SHARDINIT, SRO_VT_SHARD_INIT, SRO_VT_SHARD, SRO_VT_ACCOUNT;

PRINT 'Have fun! The work has been done! Further tutorials, contact: l33th4x0R @Epvp'