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
![[Release] SAVI v1.4.0.0 | Auto Events | vSro](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-savi-v1-4-0-0-auto-events-vsro_ltr.gif){kind=small}
