شـريـط الاهـداءات |
|
| قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
04-12-2017, 02:22 PM
|
#1 | ||||||||||||
  
|
انا عندي في الجيم ضيفت 2 سكرول واحدة بتدي 100 سيلك و 100 gift و واحدة بتدي 10 سيلك و 10 gift دلوقتي دخلت الجيم و جربتهم مش بيدوا غير سيلك بس و كمان مش متتالي يعني بيمسحوا السيلك القديم و بيضيفوا الجديد بس انا بقى عاوز يبقى + مش Reset للقديم و عاوز السكرول الواحدة تدي 100 سيلك و 100 gift كمان عاوز اعرف ازاي ماتحطش في storge او guild storge او exc او stall 
|
||||||||||||
|
|
| إعلانات google |
|
|
|
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 زائر) | |
|
|
.gif){kind=icon}
العرض العادي
