[Release] Coins Per Level System

[KingDollar]

it's not important system so i decide to release it

you have first to add this code into SRO_VT_SHARDLOG.dbo._AddLogChar

 Spoiler

if (@EventID = 22)
begin
exec SRO_VT_SYSTEM_ALEXIUNS.dbo._CoinsPerLevel @CharID , @Data2, @EventTime
end

then you will create this table

 Spoiler

create table _LeveLog (CharID int,Data2 tinyint,EventTime DateTime)

last thing you will create the proc

 Spoiler

USE [SRO_VT_SYSTEM_ALEXIUNS]
GO
/****** Object: StoredProcedure [dbo].[_CoinsPerLevel] Script Date: 02/11/2014 20:27:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[_CoinsPerLevel]
@CharID int,
@Data2 tinyint,
@EventTime DateTime
as

/* This is system by Alexiuns */

declare @Charname varchar(64) = (select CharName16 from SRO_VT_SHARD.dbo._Char Where CharID = @CharID)

if not exists (select CharID,Data2 From _LeveLog Where CharID = @CharID and Data2 = @Data2)
begin
insert into _LeveLog values (@CharID,@Data2,@EventTime)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_01',1,1
end

btw this system with anti cheat

[PortalDark]

#Approved

[Mr.gotsha]

i want to get this coin at lvl 110 only

[KingDollar]

Originally Posted by Mr.gotsha

i want to get this coin at lvl 110 only

if (@EventID = 22) and (@Data2 = 110)
begin
exec SRO_VT_SYSTEM_ALEXIUNS.dbo._CoinsPerLevel @CharID , @Data2, @EventTime
end

[khaledlollol]

Alexiuns i need your help to edit an AutoEquipment Procedure maybe we can check it together if you want..
I sent you a friend request @ Skype.

[Divine Online]

Awesome

[Sionic]

I will try this on my next project.
Thanks+1.

[CannibalOnline]

thx

[lepitismak]

Msg 137, Level 15, State 2, Procedure _AddLogChar, Line 188
Must declare the scalar variable "@EventTime".

[KingDollar]

Originally Posted by lepitismak

Msg 137, Level 15, State 2, Procedure _AddLogChar, Line 188
Must declare the scalar variable @Time".

just
declare @Time datetime = GETDATE()

[iSwOo]

Originally Posted by Alexiuns*

it's not important system so i decide to release it

you have first to add this code into SRO_VT_SHARDLOG.dbo._AddLogChar

 Spoiler

if (@EventID = 22)
begin
exec SRO_VT_SYSTEM_ALEXIUNS.dbo._CoinsPerLevel @CharID , @Data2, @EventTime
end

then you will create this table

 Spoiler

create table _LeveLog (CharID int,Data2 tinyint,EventTime DateTime)

last thing you will create the proc

 Spoiler

USE [SRO_VT_SYSTEM_ALEXIUNS]
GO
/****** Object: StoredProcedure [dbo].[_CoinsPerLevel] Script Date: 02/11/2014 20:27:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[_CoinsPerLevel]
@CharID int,
@Data2 tinyint,
@EventTime DateTime
as

/* This is system by Alexiuns */

declare @Charname varchar(64) = (select CharName16 from SRO_VT_SHARD.dbo._Char Where CharID = @CharID)

if not exists (select CharID,Data2 From _LeveLog Where CharID = @CharID and Data2 = @Data2)
begin
insert into _LeveLog values (@CharID,@Data2,@EventTime)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_01',1,1
end

btw this system with anti cheat

Where I get the SRO_VT_SYSTEM_ALEXIUNS ????

[Hamza FiGo]

Originally Posted by iSwOo

Where I get the SRO_VT_SYSTEM_ALEXIUNS ????

Use any DB. SYSTEM_ALEXIUNS its for example.

[TeamSpartans]

Thanks

[iSwOo]

Originally Posted by Hamza FiGo

Use any DB. SYSTEM_ALEXIUNS its for example.

But that procedure is it?

They explain me

That is for the monsters to loose that item?
That stops to add that item to the inventory for each level achieved?
Or what is it for?

Please help

[Lanvin*]

Originally Posted by iSwOo

But that procedure is it?

They explain me

That is for the monsters to loose that item?
That stops to add that item to the inventory for each level achieved?
Or what is it for?

Please help

nothing wrong with this query just try it and it's will work