طلب مهم

[loverslove]

موضوع ان كل المعاهم pet attack بيعملو بج tarde انا عارف ان فى موضوع بيدى DC او مبيخليش ال pet ينزل وده فى سيلفرات بس انا مش عارف ازاى

[Dev.Ri3o]

شوف ده
http://silkroad4arab.com/vb/showthread.php?t=601387

[loverslove]

طب بتتعمل فى shard log

[loverslove]

Error
Msg 156, Level 15, State 1, Procedure _AddLogChar, Line 166
Incorrect syntax near the keyword 'begin'.

[Dev.Ri3o]

فى ال Shardlog

[loverslove]

Error
Msg 156, Level 15, State 1, Procedure _AddLogChar, Line 166
Incorrect syntax near the keyword 'begin'.

[Dev.Ri3o]

Error
Msg 156, Level 15, State 1, Procedure _AddLogChar, Line 166
Incorrect syntax near the keyword 'begin'.


فى قوس ناقص
هتبقى كدة

If @EventID = 6 and exists (select * from SRO_VT_SHARD.._CharCOS where OwnerCharID = @CharID and refcharid in (select id from SRO_VT_SHARD.._refobjcommon where codename128 like '%COS_T%'))
BEGIN
update SRO_VT_SHARD.._InvCOS set itemid = 0 where COSID = (select id from SRO_VT_SHARD.._CharCOS where OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where codename128 like '%COS_T%'))
update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0 where OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%')
end

[loverslove]

انا جربتها مجاش dc ولا لازم اقفل السيلفر و افتحو ؟

[Dev.Ri3o]

طبعا لازم Restart لل Server File

[loverslove]

طب معلش اخر سؤال انا كنت بعد حوار البج ده قفلت كل pet مخلتهمش يتركبو لو حبيت ارجعهم تانى اعمل ايه اصل نسيت

[loverslove]

CanBeVehicle sa7 ?

[Dev.Ri3o]

من ال RefObjChar خلى CanBeVehicle =1

[loverslove]

جربت البج تريد ومجبش dc

[loverslove]

نزلت pet ومجاش dc

[loverslove]

ameral
?

[Dev.Ri3o]

اتاكد انك حطيت ال Procedure تحت كلمة As

[loverslove]

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 18-Aug-16 4:06:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogChar]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as

If @EventID = 6 and exists (select * from sro_vt_shard.._charcos where ownercharid = @CharID and refcharid in (select id from sro_vt_shard.._refobjcommon where codename128 like '%COS_T%'))
begin
update SRO_VT_SHARD.._InvCOS set itemid = 0
where COSID = (select id from sro_vt_shard.._CharCOS where OwnerCharID = @CharID and RefCharID in (select id from sro_vt_Shard.._RefObjCommon where codename128 like '%COS_T%'))
update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0
where
OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%')
END
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
insert _LogEventChar values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
end
else
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
end كده؟

[loverslove]

?????????????

[loverslove]

؟؟؟