السلام عليكم ورحمة الله وبركاتة
شباب عندى مشكلة رخما جدا
وهيا ان ال _AddLogItem بتاع ال SRO_VT_ShardLog مش عاوز يقرا اخر 4 حاجات
بمعنا تانى انا عندى كذا Scroll فى السيرفر اخر 4 مش شغلين لو شلط السطور بتعتهوم من اخر الصفحة فى _AddLogItem و رفعتوهوم فوق 4 حاجات تنين ال4 الكانو تحت مش شغلين هيشتغلو و ال4 الكانو فوق بعد ما نزلو تحت بقو مش شغلين و كاءن اخر 4 دايمن مش هيشتغلو....
المشاركة الأصلية كتبت بواسطة tarekelpop1
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بص شوف addlogitem clean وامسح ال عندك وضيف الحجات دي من جديد
ال _AddLogItem شغال تمام بس زى ما تقول كدا جاب اخرو فا ديمن اخر اربع حاجات مش هتشتغل يعنى لو اخدت 4 حاجات ال فى الاخر تحت المش شغلين و حتتهم مكان اربع حاجات شغلين فوق هيبقا التلعو فوق اشتغلو و التحت مش شغلين
و دة بردو ال _AddLogItem بتاعى ممكن تبوص بصة...
كود PHP:
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 شغال تمام بس زى ما تقول كدا جاب اخرو فا ديمن اخر اربع حاجات مش هتشتغل يعنى لو اخدت 4 حاجات ال فى الاخر تحت المش شغلين و حتتهم مكان اربع حاجات شغلين فوق هيبقا التلعو فوق اشتغلو و التحت مش شغلين
و دة بردو ال _AddLogItem بتاعى ممكن تبوص بصة...
كود PHP:
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 بدل ال عندك انا ضايف كل الاسكرولس بتاعتك فيه بردو
كود PHP:
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
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
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
طب خد دا اعملو query بدل ال عندك انا ضايف كل الاسكرولس بتاعتك فيه بردو
كود PHP:
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
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 مش شغلين مع العلم انهم اساسا شغلين بس لو غيرت مكنهم بس المشكلة الهيبقا مكنهم هيبقا مش شغال بردو...
تقريبا المشكله من السيستم ال انت عملو دا يعني جرب تضيف اي سكرول تانيه هتشتغل شكل السيستم دا في دروب شغال مثلا ع 10 ايتم بس وانت ضايف 14 لان ال adlogitem انا ضايف في حجاات كتير اكتر منك باضعاف فا جرب او ممكن حد يرد عليك من المشرفين هيكون فاهم الموضوع بس انا بقولك ال اعرفو مش اكتر
ولو لاحظت كدا هتلاقي نفسك حاطط الكود 41944/41951 يعني دول 7 وانت ضايف 11 سطر فا راجع السيستم تانى
المشاركة الأصلية كتبت بواسطة tarekelpop1
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تقريبا المشكله من السيستم ال انت عملو دا يعني جرب تضيف اي سكرول تانيه هتشتغل شكل السيستم دا في دروب شغال مثلا ع 10 ايتم بس وانت ضايف 14 لان ال adlogitem انا ضايف في حجاات كتير اكتر منك باضعاف فا جرب او ممكن حد يرد عليك من المشرفين هيكون فاهم الموضوع بس انا بقولك ال اعرفو مش اكتر
ولو لاحظت كدا هتلاقي نفسك حاطط الكود 41944/41951 يعني دول 7 وانت ضايف 11 سطر فا راجع السيستم تانى
الاكواد تمام جدا و كل حاجة 10/10 بس هوا ال _AddLogItem المش عاوز يقرا اخر 4 مهما كانو اة هوما اخر اربعة مش هيقراهم و اكن هوا اكتفا... عمتن انا فعلا متشكر جدا لمشركت حضرتك و هستنى ممكن واحد يفيدنى انا واثق ان المشكلة دة عدت على ناس غيرى قبل كدة..