ALTER procedure [dbo].[_AddLogChar]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as
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
return -1
end
else if (@len_pos > 0 and @len_desc = 0)
begin
return -2
end
else if (@len_pos = 0 and @len_desc > 0)
begin
return -3
end
else
begin
return -4
end
--// JuStiCe
If @EventID = 211 --// Spawn Pet
Begin
Update SH_OWOJuStiCe.._CharCOS
Set Lvl = '130'
Where PetOption in (0,1) --// Attack Pet
and RefCharID = @Data2 --// CharID
END