[Release] SAVI v1.4.0.0 | Auto Events | vSro

Link not working !

Quote:

Originally Posted by MR_MeGO Link not working !

The Link work
Copy paster after elitepvpers.com
also only this link

The event does not give a reward, at the end, how to repair that?
And in kill the gm, after it dies, it does not revive.

Thanks for releasing i was looking for this.

What should i change?
appear me this error

Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 24
Must declare the scalar variable "@len_desc1".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 25
Must declare the scalar variable "@len_desc1".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 28
Must declare the scalar variable "@strDesc_separado".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 30
Must declare the scalar variable "@len_desc1".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 33
Must declare the scalar variable "@strDesc_separado".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 35
Must declare the scalar variable "@strDesc_separado".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 39
Must declare the scalar variable "@strDesc_separado".

Quote:

Originally Posted by NorseGodTyr The Link work Copy paster after elitepvpers.com also only this link Code: https://mega.nz/#!lQYQibKB!vMcL1g4TpYthZm7h6WIseWxFqlX2m0ctO92v7-eLAaE

thank you for helping us :)

Quote:

Originally Posted by OwenXtreme The event does not give a reward, at the end, how to repair that? And in kill the gm, after it dies, it does not revive.

about reward , change database name in procedures
and add it to addlogchar to fix GM

IF (@EventID =20 AND @strPos Like '%(0x65bd)%')
BEGIN
DECLARE @Name nvarchar(32)= (SELECT CharName16 FROm Vengard_SHARD.._Char Where CharID=@CharID)
INSERT INTO SaVi_Bot.._AddKill (CharName)values(@Name)
END
IF (@EventID = 20)
BEGIN
EXEC SaVi_Bot.._KillAdd @CharID,@Desc,@strPos
END

also apologize for late thats cus i dont open forum much

Quote:

Originally Posted by hexagram1 Thanks for releasing i was looking for this.

hope its helped you

Quote:

Originally Posted by iAmAndrew What should i change? appear me this error Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 24 Must declare the scalar variable "@len_desc1". Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 25 Must declare the scalar variable "@len_desc1". Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 28 Must declare the scalar variable "@strDesc_separado". Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 30 Must declare the scalar variable "@len_desc1". Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 33 Must declare the scalar variable "@strDesc_separado". Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 35 Must declare the scalar variable "@strDesc_separado". Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 39 Must declare the scalar variable "@strDesc_separado".

replace this part in addlogitem

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 5/12/2019 6:27:03 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »?AO
as
declare @len_pos int
declare @len_desc int
declare @strDesc_separado varchar(128)
declare @len_desc1 int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³?¼
end
-- A¯·? ¾?A??U ±¸AOA?¸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
if (@Operation = 90 OR @Operation = 160)
begin
set @len_desc1 = CHARINDEX (']',@strDesc)
if(@len_desc1 = 9)
begin
set @strDesc = SUBSTRING(@strDesc,0,9)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 1)
end
else if(@len_desc1 = 10)
begin
set @strDesc = SUBSTRING(@strDesc,0,10)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 2)
end
if(@strDesc_separado >= 1)
begin
--set @strDesc_separado = @len_desc1
Declare @CharName nvarchar(32) =( SELECT CHARname16 From SRO_VT_SHARD.._Char Where CharID=@CharID)
insert SaVi_Bot.._LogPlus(CharName, ItemRefID, Plus) values(@CharName, @ItemRefID, @strDesc_separado)
end
end

Only trivia is active from event screens. How do I activate other tabs?

Quote:

Originally Posted by LiteSro Only trivia is active from event screens. How do I activate other tabs?

c# If you have any information, you can edit the source and use it.
you only need to manually set the other 3 buton set to the button active setting C# information is required.

do u have data for server hyperion can i use it