[Release] Coins Per Level System

Page 1 of 2

02/11/2014 19:32 KingDollar#1

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

then you will create this table

Spoiler

last thing you will create the proc

Spoiler

btw this system with anti cheat

02/13/2014 12:17 PortalDark#2

#Approved

02/14/2014 13:07 Mr.gotsha#3

i want to get this coin at lvl 110 only

02/14/2014 13:40 KingDollar#4

Quote:

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

02/14/2014 14:15 khaledlollol#5

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.

02/15/2014 23:41 Divine Online#6

Awesome

02/15/2014 23:57 Sionic#7

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

02/28/2014 04:14 CannibalOnline#8

thx

05/05/2014 15:33 lepitismak#9

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

04/01/2016 15:34 KingDollar#10

Quote:

Originally Posted by lepitismak

Msg 137, Level 15, State 2, Procedure _AddLogChar, Line 188
Must declare the scalar variable @[Only registered and activated users can see links. Click Here To Register...]Time".

just
declare @[Only registered and activated users can see links. Click Here To Register...]Time datetime = GETDATE()

12/27/2016 00:36 iSwOo#11

Quote:

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 ????

12/27/2016 01:11 Hamza FiGo#12

Quote:

Originally Posted by iSwOo

Where I get the SRO_VT_SYSTEM_ALEXIUNS ????

Use any DB. SYSTEM_ALEXIUNS its for example.

12/27/2016 04:56 TeamSpartans#13

Thanks

12/28/2016 08:16 iSwOo#14

Quote:

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

12/28/2016 08:34 Lanvin*#15

Quote:

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

Page 1 of 2