شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
04-12-2017, 02:22 PM | #1 | ||||||||||||
|
انا عندي في الجيم ضيفت 2 سكرول واحدة بتدي 100 سيلك و 100 gift و واحدة بتدي 10 سيلك و 10 gift دلوقتي دخلت الجيم و جربتهم مش بيدوا غير سيلك بس و كمان مش متتالي يعني بيمسحوا السيلك القديم و بيضيفوا الجديد بس انا بقى عاوز يبقى + مش Reset للقديم و عاوز السكرول الواحدة تدي 100 سيلك و 100 gift كمان عاوز اعرف ازاي ماتحطش في storge او guild storge او exc او stall |
||||||||||||
|
04-12-2017, 07:17 PM | #2 | ||||||||||||
|
دى Bug فى ال AddNewChar نفسها المفروض تخلى اى New Char ينزل يتعملو سطر فى ال SK_SILK لان ال scroll كل اللى بتعملو انها بتزود العدد لو فى سطر فى ال SK_SILK وخلى بالك لازم اى New Char يتعمل يتعملو سطر ولو تعمل Char تانى مينزلش سطر لى كل اكونت بسطر واحد بس هتمسح كل ال Accounts اللى فى Database وهتعمل دى فى ال AddNewChar تحت ال Items اللى بيبدأ بيها ال Char كود:
IF Not Exists (Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserJID) Begin ---- Silk Bug Fixed #Ri3o---- INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) VALUES (@UserJID, 0, 0, 0); End |
||||||||||||
|
04-12-2017, 09:51 PM | #3 | ||||||||||||
|
تمام جداً كله شغال زي الفل ما عدا بعد ما شغلت السكرول التانية الاولى شغالة لسه لكن التانية ولا بتعمل اي حاجة كود:
if (@JobID= '33791') BEGIN DECLARE @USERJID int; SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0 UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 10 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 10 WHERE JID = @USERJID; END " مع العلم ان التانية مش شغالة ( عممال اعيد و ازيد انا هههه ) " كود:
if (@JobID= '33792') BEGIN SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0 UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 100 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 100 WHERE JID = @USERJID; END |
||||||||||||
|
05-12-2017, 12:11 AM | #4 | ||||||||||||
|
بص ... هات ال AddLogItem_ وانا هعدلك عليه وهديهولك
|
||||||||||||
|
05-12-2017, 12:33 AM | #5 | ||||||||||||
|
ايه الحوارات الفكسانة دول الاتنين مفهمش Begin فكك من ال TimedJob اشتغل AddLogItem عشان ال Teleport كود:
IF (@Operation = 41) Begin IF (@ItemRefID >= 46899 And @ItemRefID <= 46902) Begin Select @SilkAmount = Case When @ItemRefID = '46899' Then '10' When @ItemRefID = '46900' Then '100' END END Begin Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + @SilkAmount Where JID = @UserJID Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_gift = silk_gift + @SilkAmount Where JID = @UserJID END END |
||||||||||||
|
05-12-2017, 01:28 AM | #6 | |||||||||||||
|
اقتباس:
كود:
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 12/05/2017 00:27:52 ******/ 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= '33791') BEGIN DECLARE @USERJID int; SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0 UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 10 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 10 WHERE JID = @USERJID; END if (@JobID= '33792') BEGIN SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0 UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 100 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 100 WHERE JID = @USERJID; 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 --##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 due to develop composite item set @NewJobID = @@identity if (@@error <> 0 or @@rowcount = 0) return -3 return @NewJobID |
|||||||||||||
|
05-12-2017, 01:29 AM | #7 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
05-12-2017, 01:35 AM | #8 | |||||||||||||
|
اقتباس:
كود:
if (@JobID= '33792') BEGIN DECLARE @USERJID2 int; SET @USERJID2 = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID2) > 0 UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 100 WHERE JID = @USERJID2; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 100 WHERE JID = @USERJID2; END |
|||||||||||||
|
05-12-2017, 02:49 AM | #9 | ||||||||||||
|
هتعمل دي وكلو هيبقا تمام : كود:
USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 12/05/2017 00:27:52 ******/ 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, @USERJID int --##end due to develop composite item as declare @CheckSilkTable int = (select count(*) from [SRO_VT_ACCOUNT].dbo.SK_Silk where JID = @USERJID) if (@JobID= '33791') BEGIN SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); if (@CheckSilkTable = '0') begin INSERT INTO [SRO_VT_ACCOUNT].dbo.SK_Silk (JID,silk_gift,silk_own,silk_point) values (@USERJID,'0','0','0') UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 10 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 10 WHERE JID = @USERJID; end if (@CheckSilkTable != '0') begin UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 10 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 10 WHERE JID = @USERJID; end END if (@JobID= '33792') BEGIN SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID); if (@CheckSilkTable = '0') begin INSERT INTO [SRO_VT_ACCOUNT].dbo.SK_Silk (JID,silk_gift,silk_own,silk_point) values (@USERJID,'0','0','0') UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 100 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 100 WHERE JID = @USERJID; end if (@CheckSilkTable != '0') begin UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 100 WHERE JID = @USERJID; UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_GIFT = SILK_GIFT + 100 WHERE JID = @USERJID; end 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 --##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 due to develop composite item set @NewJobID = @@identity if (@@error <> 0 or @@rowcount = 0) return -3 return @NewJobID |
||||||||||||
|
05-12-2017, 11:43 AM | #10 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
05-12-2017, 11:48 AM | #11 | |||||||||||||
|
اقتباس:
و بفتح ولا بلاقي سيلك و لا اي حاجة |
|||||||||||||
|
05-12-2017, 03:12 PM | #12 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
05-12-2017, 03:14 PM | #13 | ||||||||||||
|
او اشتغل AddLogItem احسن
|
||||||||||||
|
05-12-2017, 08:50 PM | #14 | ||||||||||||
|
و ربنا متأكد من الـ Scroll و كل حاجة صح بس هو المشكلة في JopTimed شكلي كدا هعمل Scroll على Time بس عاوز اعرف ازاي اخلي الجيم خفيفة لاني خايف اما اعمل كدا تتقل |
||||||||||||
|
05-12-2017, 10:06 PM | #15 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|