مشكلة فى ال AddLogItem ارجو المساعدة

[testmis]

السلام عليكم ورحمة الله وبركاتة
شباب عندى مشكلة رخما جدا
وهيا ان ال _AddLogItem بتاع ال SRO_VT_ShardLog مش عاوز يقرا اخر 4 حاجات
بمعنا تانى انا عندى كذا Scroll فى السيرفر اخر 4 مش شغلين لو شلط السطور بتعتهوم من اخر الصفحة فى _AddLogItem و رفعتوهوم فوق 4 حاجات تنين ال4 الكانو تحت مش شغلين هيشتغلو و ال4 الكانو فوق بعد ما نزلو تحت بقو مش شغلين و كاءن اخر 4 دايمن مش هيشتغلو....

مشكلة رخما جدا جدا...

[tarekelpop1]

بص شوف addlogitem clean وامسح ال عندك وضيف الحجات دي من جديد

[testmis]

بص شوف addlogitem clean وامسح ال عندك وضيف الحجات دي من جديد

ال _AddLogItem شغال تمام بس زى ما تقول كدا جاب اخرو فا ديمن اخر اربع حاجات مش هتشتغل يعنى لو اخدت 4 حاجات ال فى الاخر تحت المش شغلين و حتتهم مكان اربع حاجات شغلين فوق هيبقا التلعو فوق اشتغلو و التحت مش شغلين
و دة بردو ال _AddLogItem بتاعى ممكن تبوص بصة...
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/10/2018 3:21:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âأپ¸ ¾أ†أ€أŒأ…أ› ·أژ±× أ€أ”·أ‚ Stored procedure ¼أ¶أپ¤
-- DataBase : Shard Log
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 »أ°أ€أ”
as
declare @len_pos int
declare @len_desc 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
-- أ€¯·أ، ¾أ†أ€أŒأ…أ› ±¸أ€أ”أ€أŒ¸é!
-- #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 = 41 ) AND (@ItemRefID = 41800))
BEGIN
exec SRO_VT_SHARD.dbo._Reset_Mastery_And_Skills_Scroll @CharID
END
IF (@Operation = 41 AND @ItemRefID = 41801)
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 50
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
IF ((@Operation = 41 ) AND (@ItemRefID = 41888))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID
END
IF ( @Operation = '41') AND @ItemRefID = '41890'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @CharID END
IF (@Operation = 41 AND @ItemRefID = 41933) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeMoon @CharId, @ItemRefID
END

[testmis]

و دة بردو ال _AddLogItem بتاعى ممكن تبوص بصة...
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/10/2018 3:21:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âأپ¸ ¾أ†أ€أŒأ…أ› ·أژ±× أ€أ”·أ‚ Stored procedure ¼أ¶أپ¤
-- DataBase : Shard Log
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 »أ°أ€أ”
as
declare @len_pos int
declare @len_desc 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
-- أ€¯·أ، ¾أ†أ€أŒأ…أ› ±¸أ€أ”أ€أŒ¸é!
-- #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 = 41 ) AND (@ItemRefID = 41800))
BEGIN
exec SRO_VT_SHARD.dbo._Reset_Mastery_And_Skills_Scroll @CharID
END
IF (@Operation = 41 AND @ItemRefID = 41801)
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 50
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
IF ((@Operation = 41 ) AND (@ItemRefID = 41888))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID
END
IF ( @Operation = '41') AND @ItemRefID = '41890'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @CharID END
IF (@Operation = 41 AND @ItemRefID = 41933) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeMoon @CharId, @ItemRefID
END

[tarekelpop1]

ال _AddLogItem شغال تمام بس زى ما تقول كدا جاب اخرو فا ديمن اخر اربع حاجات مش هتشتغل يعنى لو اخدت 4 حاجات ال فى الاخر تحت المش شغلين و حتتهم مكان اربع حاجات شغلين فوق هيبقا التلعو فوق اشتغلو و التحت مش شغلين
و دة بردو ال _AddLogItem بتاعى ممكن تبوص بصة...
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/10/2018 3:21:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âأپ¸ ¾أ†أ€أŒأ…أ› ·أژ±× أ€أ”·أ‚ Stored procedure ¼أ¶أپ¤
-- DataBase : Shard Log
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 »أ°أ€أ”
as
declare @len_pos int
declare @len_desc 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
-- أ€¯·أ، ¾أ†أ€أŒأ…أ› ±¸أ€أ”أ€أŒ¸é!
-- #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 = 41 ) AND (@ItemRefID = 41800))
BEGIN
exec SRO_VT_SHARD.dbo._Reset_Mastery_And_Skills_Scroll @CharID
END
IF (@Operation = 41 AND @ItemRefID = 41801)
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 50
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
IF ((@Operation = 41 ) AND (@ItemRefID = 41888))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID
END
IF ( @Operation = '41') AND @ItemRefID = '41890'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @CharID END
IF (@Operation = 41 AND @ItemRefID = 41933) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeMoon @CharId, @ItemRefID
END
طب خد دا اعملو query بدل ال عندك انا ضايف كل الاسكرولس بتاعتك فيه بردو
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/10/2018 2:09:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
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 »ðÀÔ
as
declare @len_pos int
declare @len_desc 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
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #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 = 41 ) AND (@ItemRefID = 41800))
BEGIN
exec SRO_VT_SHARD.dbo._Reset_Mastery_And_Skills_Scroll @CharID
END
IF (@Operation = 41 AND @ItemRefID = 41801)
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 50
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
IF ((@Operation = 41 ) AND (@ItemRefID = 41888))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID
END
IF ( @Operation = '41') AND @ItemRefID = '41890'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @CharID END
IF (@Operation = 41 AND @ItemRefID = 41933) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeMoon @CharId, @ItemRefID
END
|

[testmis]

طب خد دا اعملو query بدل ال عندك انا ضايف كل الاسكرولس بتاعتك فيه بردو
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/10/2018 2:09:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
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 »ðÀÔ
as
declare @len_pos int
declare @len_desc 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
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #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 = 41 ) AND (@ItemRefID = 41800))
BEGIN
exec SRO_VT_SHARD.dbo._Reset_Mastery_And_Skills_Scroll @CharID
END
IF (@Operation = 41 AND @ItemRefID = 41801)
BEGIN
DECLARE @JID int,
@Silk int;

SET @Silk = 50
SELECT @JID = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = @JID)
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + @Silk where JID = @JID
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT @JID, @Silk, 0, 0
END
IF ((@Operation = 41 ) AND (@ItemRefID = 41888))
BEGIN
exec SRO_VT_SHARD.dbo._ForgottenWorldReset @CharID
END
IF ( @Operation = '41') AND @ItemRefID = '41890'
BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob where JobID = '2'AND CharID = @CharID END
IF (@Operation = 41 AND @ItemRefID = 41933) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldSun @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BowMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._TbladeMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SpearMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ShieldMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._SwordMoon @CharId, @ItemRefID
END
IF @ItemRefID BETWEEN '41944' and '41951' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._BladeMoon @CharId, @ItemRefID
END
|


نفس المشكلة بظبط....بردو اخر 4 مش شغلين مع العلم انهم اساسا شغلين بس لو غيرت مكنهم بس المشكلة الهيبقا مكنهم هيبقا مش شغال بردو...

[tarekelpop1]

تقريبا المشكله من السيستم ال انت عملو دا يعني جرب تضيف اي سكرول تانيه هتشتغل شكل السيستم دا في دروب شغال مثلا ع 10 ايتم بس وانت ضايف 14 لان ال adlogitem انا ضايف في حجاات كتير اكتر منك باضعاف فا جرب او ممكن حد يرد عليك من المشرفين هيكون فاهم الموضوع بس انا بقولك ال اعرفو مش اكتر :smoke:
ولو لاحظت كدا هتلاقي نفسك حاطط الكود 41944/41951 يعني دول 7 وانت ضايف 11 سطر فا راجع السيستم تانى

[testmis]

تقريبا المشكله من السيستم ال انت عملو دا يعني جرب تضيف اي سكرول تانيه هتشتغل شكل السيستم دا في دروب شغال مثلا ع 10 ايتم بس وانت ضايف 14 لان ال adlogitem انا ضايف في حجاات كتير اكتر منك باضعاف فا جرب او ممكن حد يرد عليك من المشرفين هيكون فاهم الموضوع بس انا بقولك ال اعرفو مش اكتر :smoke:
ولو لاحظت كدا هتلاقي نفسك حاطط الكود 41944/41951 يعني دول 7 وانت ضايف 11 سطر فا راجع السيستم تانى

الاكواد تمام جدا و كل حاجة 10/10 بس هوا ال _AddLogItem المش عاوز يقرا اخر 4 مهما كانو اة هوما اخر اربعة مش هيقراهم و اكن هوا اكتفا... عمتن انا فعلا متشكر جدا لمشركت حضرتك و هستنى ممكن واحد يفيدنى انا واثق ان المشكلة دة عدت على ناس غيرى قبل كدة..

[testmis]

تم الحل بفضل الله ثم الاستاذ طارق
يغلق...منفضلكو

[testmis]

الحل كان انى اضيف Scrolls جديدة..

[Dev.Ri3o]

##