الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**F77** · 14-10-2017, 11:11 PM

انا مشيت ورا الموضوع ده بالظبط
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بس انا عامل علي الاسلحة بس مش السيت
وبضرب السكرول مفيش حاجه بتيجي

**Scrox** · 15-10-2017, 12:10 AM

الاسكرول دى زى Model switcher بس السكرول دى برسودر بتاعوا فى حاجة غلط
شوف الموضوع دى هم الاتنين نفس الفكرة
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**F77** · 15-10-2017, 01:23 AM

ده عندي وبرده مش شغال
بس السيستم ده غير ده لان اللي بقول عليه ده بيغير اي سلاح ل سلاح تانى
انما اللي بتقول عليه ده بيغير اي شكل سلاح ل اي ل شكل اي ديجرى حسب السكرول

**HB#** · 15-10-2017, 11:48 AM

يبقا فيه مشكله عند حضرتك في ال AddLogItem_ فا اعمل الكويري ده وهيصلح ال AddLogItem_ وبعديها بقا ضيف الاسكرول تاني فيها في الآخر خالص

:

كود:

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 10/15/2017 10:46:48 AM ******/
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

**F77** · 15-10-2017, 01:30 PM

هو فعلا في مشكله لان كمان مفيش ولا اسكرول عندى شغاله
مع ان كل السكرولات كانت شغاله فى الاول
وعملت اللي قولت عليه برده مفيش

**Neoon** · 15-10-2017, 01:53 PM

كدة ال procedure مش مظبوط اتاكد انت حاطط lines فى مكانها واتأكد من ID بتاع الاسكرول

و جرب البروسيدور ده بـ Log DB

كود PHP:

USE [SRO_VT_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 02/20/2015 08:35:45 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[_UpgradeSystem] @CharID Int As -- Declare expression. Declare @CreaterName Varchar(60) = 'iLegend' , -- Creater Name @WeaponSlot Int = 6 , -- char inventory weapon slot @ShieldSlot Int = 7 , -- char inventory shield slot @ReqOptLevel Int = 7 , -- Change old item requiared plus for upgrade. @NewOptLevel Int = 0 , -- Change new item plus after upgrade -- Set Old and New Weapons RefObjCommon ID below -- Use This Query to get each item ID by Codename128 -- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name' ---> Old weapon ID's ---> New weapons ID's @Old_CH_SWORD_ID Int = 25611 , @New_CH_SWORD_ID Int = 25669 , --@New Chinese Sword @Old_CH_BLADE_ID Int = 25612 , @New_CH_BLADE_ID Int = 25670 , --@Chinese Blade @Old_CH_SPEAR_ID Int = 25613 , @New_CH_SPEAR_ID Int = 25671 , --@Chinese Spear @Old_CH_TBLADE_ID Int = 25614 , @New_CH_TBLADE_ID Int = 25672 , --@Chinese Glaive @Old_CH_BOW_ID Int = 25615 , @New_CH_BOW_ID Int = 25673 , --@Chinese Bow @Old_CH_SHIELD_ID Int = 25616 , @New_CH_SHIELD_ID Int = 25674 , --@Chinese Shield @Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger @Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow @Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe @Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword @Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword @Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff @Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod @Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod @Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp @Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield -------------------------------------------------------------------------------------------- -- Start Upgrade system : -- CH Weapons Upgrade. Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@Sword Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield -- EU Weapons Upgrade. Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DAGGER_ID and (OptLevel >= @ReqOptLevel) --@Dagger Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_XBOW_ID and (OptLevel >= @ReqOptLevel) --@Crossbow Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_AXE_ID and (OptLevel >= @ReqOptLevel) --@Axe Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_SWORD_ID and (OptLevel >= @ReqOptLevel) --@OneHand Sword Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSWORD_ID and (OptLevel >= @ReqOptLevel) --@T-Sword Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel >= @ReqOptLevel) --@T-Staff Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_STAFF_ID and (OptLevel >= @ReqOptLevel) --@Staff Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel >= @ReqOptLevel) --@Dark-Staff Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_HARP_ID and (OptLevel >= @ReqOptLevel) --@Harp Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield

**F77** · 15-10-2017, 01:59 PM

البروسيدر ده بتاع حاجه تانيه اللي هي سلاح ايجي بلاص 10 مثلا تضربها تديك سلاح B

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

بص علي ده كده شوف في حاجه غلط او مش مترتب صح كده

كود بلغة HTML:

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 15/10/2017 12:59:46 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 »أ°أ€أ”   
  @RefItemID Int
  , @ID64 Int
  , @NewItem Int 
  , @OptLevel Varchar(20)
   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

**Neoon** · 15-10-2017, 02:11 PM

كود PHP:

USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 11/12/2014 03:24:57 م ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF 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) 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) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial) 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) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial) 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) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial) end else if (@len_pos = 0 and @len_desc = 0) begin insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial) 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

**F77** · 15-10-2017, 02:19 PM

طيب بالنسبة للحاجات دي في اسكرول عندي مكتوب فيها الحاجات دي
وحضرتك مش كاتبها مع الحاجات اللي فوق

كود بلغة HTML:

, @ID64 Int
, @NewItem Int 
, @OptLevel Varchar(20)

وبعدين بتجيب المشكله دي

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 758
Incorrect syntax near 'END'.

**Neoon** · 15-10-2017, 02:39 PM

كود PHP:

USE [SRO_VT_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 11/12/2014 03:24:57 م ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF 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 »أ°أ€أ” @RefItemID Int , @ID64 Int , @NewItem Int , @OptLevel Varchar(20) 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) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial) 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) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial) 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) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial) end else if (@len_pos = 0 and @len_desc = 0) begin insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64) values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial) 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

**F77** · 15-10-2017, 02:57 PM

ضفته وبرده السكرولات مش عايزه تشتغل
هى ممكن تكون من حاجه تانيه ولا هي من البروسيدر ده بس
عشان ابقى عارف بس ؟

**F77** · 15-10-2017, 02:57 PM

ضفته وبرده السكرولات مش عايزه تشتغل
هى ممكن تكون من حاجه تانيه ولا هي من البروسيدر ده بس
عشان ابقى عارف بس ؟

**Neoon** · 15-10-2017, 02:58 PM

لو متاكد من الـ ID بتاع الاسكرول يبقا المشكلة من البروسيدور

**F77** · 15-10-2017, 03:02 PM

طبعا متاكد لان كل السكرولات شغاله اصلا
بس معرفش حصل ايه عمل ده كله

**F77** · 15-10-2017, 03:52 PM

تم حل المشكلة انا رفعت داتا باك اب وظبط فيها اللي كنت عاملو فى الداتا التانية
##

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟

شـريـط الاهـداءات