شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
23-02-2015, 09:59 PM | #1 | ||||||||||||
|
دلوقتي انا ضفت اسكرول بيشيل الادفنس وتمام و بينزل عادي وكل حاجه بس لما بضربه مش بيشيل حاجه حتي لو رجعت التون او عملت ريسترت للاكونت ودا El TimedJop_ بتاعه كود PHP:
|
||||||||||||
|
23-02-2015, 10:23 PM | #2 | ||||||||||||
Never ForGive
|
33854 الرقم ده بتاع اية ؟؟ RefSkill ولا انت مغير فيه حاجا ؟؟ |
||||||||||||
|
23-02-2015, 10:24 PM | #3 | ||||||||||||
|
انتا دفتها في l TimedJop |
||||||||||||
|
23-02-2015, 10:25 PM | #4 | ||||||||||||
|
اتاكد منها في Refskill same code |
||||||||||||
|
23-02-2015, 10:26 PM | #5 | ||||||||||||
|
Yes 33854 This Form RefSkill وانا ضفتها Times Jop |
||||||||||||
|
23-02-2015, 10:49 PM | #6 | ||||||||||||
|
اول حاجة من كلامك انك ضايفها غلط اقولك لية
لان انت لما تستخدم الاسكرول لازم يجيلك DC علشان return -3 لو مجالكش DC يبقي الــ ID مختلف تماما |
||||||||||||
|
24-02-2015, 11:48 AM | #7 | ||||||||||||
|
دا ال Timed jop بتاعي ممكن تتاكد
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 24/02/2015 10:44:55 ص ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[_AddTimedJob] @CharID int, @Category tinyint, @JobID int, @TimeToKeep int, @Data1 int, @Data2 int, --##begin due to develop composite item @Data3 int, @Data4 int, @Data5 int, @Data6 int, @Data7 int, @Data8 int, @Serial64 bigint, @JID int --##end due to develop composite item as if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) return -1 if (@TimeToKeep <= 0) return -2 declare @NewJobID int set @NewJobID = 0 --##begin due to develop composite item insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID) values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) --##end due to develop composite item set @NewJobID = @@identity if (@@error <> 0 or @@rowcount = 0) return -3 if @Category=2 and @JobID=2 begin delete from _TimedJob where ID=@NewJobID end return @NewJobID if(@JobID= '33853') ---Remove Maximum By Che--- begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventory where CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 99999) end ---------designed by krmfrnc-------------- if(@JobID= '33854') -- Remover ADV Ticket added by krmfrnc begin DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID) and bOptType=2 return -3 end ---------designed by krmfrnc-------------- |
||||||||||||
التعديل الأخير تم بواسطة Mostafa Shaaban ; 24-02-2015 الساعة 11:51 AM
|
24-02-2015, 02:19 PM | #8 | ||||||||||||
|
زي منا قولتلك حضرتك ضايفها غلط اتفضل يا باشا كود:
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 24/02/2015 01:17:11 م ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[_AddTimedJob] @CharID int, @Category tinyint, @JobID int, @TimeToKeep int, @Data1 int, @Data2 int, --##begin due to develop composite item @Data3 int, @Data4 int, @Data5 int, @Data6 int, @Data7 int, @Data8 int, @Serial64 bigint, @JID int --##end due to develop composite item as if(@JobID= '33853') ---Remove Maximum By Che--- begin Update _Items Set MagParamNum = 0 , MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventory where CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 99999) end ---------designed by krmfrnc-------------- if(@JobID= '33854') -- Remover ADV Ticket added by krmfrnc begin DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID) and bOptType=2 return -3 end if (not exists (select CharID from _Char with (nolock) where CharID = @CharID)) return -1 if (@TimeToKeep <= 0) return -2 declare @NewJobID int set @NewJobID = 0 --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader --##If you want to only have one not both, then just modify the line below! --if (@JobID = 1 and @Category = 2 and @Serial64=0) or (@JobID = 2 and @Category = 2 and @Serial64=0) --For Guild and CharJob if (@JobID = 1 and @Category = 2 and @Serial64=0) --Only for Guild BEGIN set @CharID = 0 insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID) values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) END ELSE BEGIN --##begin due to develop composite item insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID) values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID) END --##end due to develop composite item set @NewJobID = @@identity if (@@error <> 0 or @@rowcount = 0) return -3 return @NewJobID --???? |
||||||||||||
|
24-02-2015, 02:35 PM | #9 | ||||||||||||
|
تمام يغلق
## |
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|