قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
|
05-04-2015, 02:15 AM | #1 | ||||||||||
|
انا ال Notice عندي بتبدا plus 1 انا عايزها تبدا من plus 8 ازاي |
||||||||||
|
05-04-2015, 10:44 AM | #2 | ||||||||||
|
حط ده فى Logitem فى srovtshardlog if(@strDesc_separado >= 8 |
||||||||||
|
05-04-2015, 11:51 AM | #3 | ||||||||||
|
عملت كده و برضو بيعمل بلص من 1 |
||||||||||
|
05-04-2015, 01:12 PM | #4 | ||||||||||
|
هات addlogitem كله و انا هصلحه |
||||||||||
|
05-04-2015, 02:27 PM | #5 | ||||||||||
|
كود:
USE [SRO_MATRIX_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 05/04/2015 01:27:12 م ******/ 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 declare @strDesc_separado varchar(128) declare @len_desc1 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 = 90 OR @Operation = 160) begin set @len_desc1 = CHARINDEX (']',@strDesc) if(@len_desc1 = 9) begin set @strDesc = SUBSTRING(@strDesc,0,9) set @strDesc_separado = SUBSTRING(@strDesc, 8, 1) end else if(@len_desc1 = 10) begin set @strDesc = SUBSTRING(@strDesc,0,10) set @strDesc_separado = SUBSTRING(@strDesc, 8, 2) end if(@strDesc_separado >= 8 and @strDesc_separado < 16) begin --set @strDesc_separado = @len_desc1 insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') end end if(@Operation = 90) begin declare @iname varchar(129) declare @iid int declare @cname varchar(64) select @iid = RefItemID from SRO_MATRIX_SHARD.dbo._Items where Serial64 = @ItemSerial select @iname = CodeName128 from SRO_MATRIX_SHARD.dbo._RefObjCommon where id = @iid select @cname = CharName16 from SRO_MATRIX_SHARD.dbo._Char where CharID = @CharID insert PlusNotice_mido22421(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']') insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') end |
||||||||||
التعديل الأخير تم بواسطة Hamza FiGo ; 05-04-2015 الساعة 03:56 PM
|
05-04-2015, 03:58 PM | #6 | ||||||||||
|
جرب دا مرة ودا مرة كود:
USE [SRO_MATRIX_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 05/04/2015 01:27:12 م ******/ 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 declare @strDesc_separado varchar(128) declare @len_desc1 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 = 90 OR @Operation = 160) begin set @len_desc1 = CHARINDEX (']',@strDesc) if(@len_desc1 = 9) begin set @strDesc = SUBSTRING(@strDesc,0,9) set @strDesc_separado = SUBSTRING(@strDesc, 8, 1) end else if(@len_desc1 = 10) begin set @strDesc = SUBSTRING(@strDesc,0,10) set @strDesc_separado = SUBSTRING(@strDesc, 8, 2) end if@strDesc_separado >= 8 begin --set @strDesc_separado = @len_desc1 insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') end end if(@Operation = 90) begin declare @iname varchar(129) declare @iid int declare @cname varchar(64) select @iid = RefItemID from SRO_MATRIX_SHARD.dbo._Items where Serial64 = @ItemSerial select @iname = CodeName128 from SRO_MATRIX_SHARD.dbo._RefObjCommon where id = @iid select @cname = CharName16 from SRO_MATRIX_SHARD.dbo._Char where CharID = @CharID insert PlusNotice_mido22421(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']') insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') end كود:
USE [SRO_MATRIX_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 05/04/2015 01:27:12 م ******/ 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 declare @strDesc_separado varchar(128) declare @len_desc1 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 = 90 OR @Operation = 160) begin set @len_desc1 = CHARINDEX (']',@strDesc) if(@len_desc1 = 9) begin set @strDesc = SUBSTRING(@strDesc,0,9) set @strDesc_separado = SUBSTRING(@strDesc, 8, 1) end else if(@len_desc1 = 10) begin set @strDesc = SUBSTRING(@strDesc,0,10) set @strDesc_separado = SUBSTRING(@strDesc, 8, 2) end if@strDesc_separado <= 8 begin --set @strDesc_separado = @len_desc1 insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') end end if(@Operation = 90) begin declare @iname varchar(129) declare @iid int declare @cname varchar(64) select @iid = RefItemID from SRO_MATRIX_SHARD.dbo._Items where Serial64 = @ItemSerial select @iname = CodeName128 from SRO_MATRIX_SHARD.dbo._RefObjCommon where id = @iid select @cname = CharName16 from SRO_MATRIX_SHARD.dbo._Char where CharID = @CharID insert PlusNotice_mido22421(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']') insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0') end |
||||||||||
|
05-04-2015, 04:07 PM | #7 | ||||||||||
|
الكيوري الاثنين جاب Error مش مشكله المهم اني عرفت اعمل السيستم شكرأ علي المساعده |
||||||||||
|
05-04-2015, 04:59 PM | #8 | |||||||||||
|
اقتباس:
طيب تمام يغلق ## |
|||||||||||
|
05-04-2015, 04:20 PM | #9 | ||||||||||
|
يا جدعان ثواني بس كدا .. إزاي مش حاطط إلا شرط واحد بس عشان يعمل insert فى جدول النوتيك .. اللى هو ،، كود PHP:
|
||||||||||
|
05-04-2015, 04:23 PM | #10 | ||||||||||
|
جرب تشيل اللى انا حاطه فى الرد اللى فات مش كل البروسيدور من أول كود PHP:
كود PHP:
|
||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
أدوات الموضوع | |
انواع عرض الموضوع | |
|
|
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
مشكلة فى Auto Notice/Auto plus notice | Jaffa | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 29 | 13-03-2015 12:50 AM |
Release event_script + Auto Notice plus + Auto Reward Winner pvp | Reflect | قـسـم تـعـديـل [ PK2 Edit ] | 10 | 07-03-2015 01:06 PM |
Help at Auto plus notice | ™ EgY_KhaN ™ | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 13 | 02-03-2015 09:59 PM |
Auto Plus Notice | Ahmed Seka | قسم المواضيع المكررة و المخالفة | 5 | 24-08-2014 02:48 PM |
plus Auto Notice ! | ™XerK™ | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 12 | 01-08-2014 11:37 AM |