شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
22-06-2020, 07:10 PM | #1 | ||||||||||||
|
لو سمحت انا اول ما لبست لبس الهانتر في الجيم واخدت نقطة في النطام بتاعه بقي فيه بج في السيلك االلي في الاكونت ... بقي بيجي بدل السيلك عدد البوينت اللي اخدته فقط ويجيلي رسالة عدم وجود سيلك مع اللعلم معايا 100000 سيلك ودي صورة عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||||
|
22-06-2020, 07:43 PM | #2 | ||||||||||||
|
واضح كلامك اكتر او اعمل فيديو علشان اساعدك
|
||||||||||||
|
22-06-2020, 09:26 PM | #3 | ||||||||||||
|
وريني Producer السيستم
|
||||||||||||
|
23-06-2020, 10:34 AM | #4 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
23-06-2020, 08:39 PM | #5 | ||||||||||||
|
شوفو في الAddlogchar
|
||||||||||||
|
23-06-2020, 08:47 PM | #6 | |||||||||||||
|
اقتباس:
----------------------------------------------------------------- IF @EventID = '20' BEGIN DECLARE @KilledName VARCHAR(512) = @Desc ---------------------------- Pvp War Section ------------------------------------------- Declare @RunPvp varchar(100) = (Select Run From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Pvp war') Declare @ServicePvp int = (Select [Service] From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Pvp war') IF(@RunPvp='ON' And @ServicePvp = '1') BEGIN Exec [SRO_VT_XEVENT].[dbo].[EVENT_PVP_PROC] @CharID , @EventID , @KilledName , 3 , @Desc END ---------------------------- Job War Section ------------------------------------------- Declare @RunJob varchar(100) = (Select Run From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Job war') Declare @ServiceJob int = (Select [Service] From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Job war') IF(@RunJob='ON' And @ServiceJob = '1') BEGIN Exec [SRO_VT_XEVENT].[dbo].[EVENT_JOB_PROC] @CharID , @EventID , @KilledName , 3 , @Desc END ---------------------------- GM Kill Section ------------------------------------------- Declare @RunGM varchar(100) = (Select Run From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'GM Kill') Declare @ServiceGM int = (Select [Service] From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'GM Kill') IF(@RunGM ='ON' And @ServiceGM = '1') BEGIN Exec [SRO_VT_XEVENT].[dbo].[EVENT_GM_KILL_PROC] @CharID , @EventID , @KilledName , 3 , @Desc END END --------------------------------------------------------------- -----------------Jop For Each Star ----------------------------------------------------------------- IF (@EventID = 6) BEGIN EXEC [SRO_VT_SHARDLOG].[dbo].[_Job_Coin] @CharID END /* Job Top Count */ IF (@EventID = 9 OR @EventID = 11) BEGIN EXEC [SRO_VT_SHARDLOG].[dbo].[Top_Job_Count] @CharID END -- Job System IF @EventID = '19' BEGIN -- Renew for the nex day IF EXISTS (SELECT CharID FROM SRO_VT_XEVENT.dbo._JobDay WHERE isDat < GETDATE()) BEGIN DELETE FROM SRO_VT_XEVENT.dbo._JobDay WHERE CharID = @CharID DELETE FROM SRO_VT_XEVENT.DBO._JobNewSys WHERE KillerID = @CharID END IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Char WITH(NOLOCK) WHERE CharID = @CharID AND CurLevel >= '90') BEGIN EXEC SRO_VT_XEVENT.dbo.[_JobNewJobS] @CharID,@Desc END END --- |
|||||||||||||
|
24-06-2020, 02:24 PM | #7 | ||||||||||||
|
مفيش حل ؟
|
||||||||||||
|
24-06-2020, 06:48 PM | #8 | ||||||||||||
|
راجع ع التاب دة [_JobNewJobS] ممكن يكون المشكلة فية لأن انا شايف ان السيستم مافيهوش اي مشاكل بس مكتوب ان اي حاجة تحصل ف السيستم تقري الملف دة ف حاول تشوف الي جواه ممكن يطلع العيب فية
|
||||||||||||
|
24-06-2020, 07:41 PM | #9 | |||||||||||||
|
اقتباس:
USE [SRO_VT_XEVENT] GO /****** Object: StoredProcedure [dbo].[_JobNewJobS] Script Date: 6/24/2020 6:40:43 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[_JobNewJobS] @CharID int, @Desc varchar(128) as DECLARE @UserID int = (SELECT userjid FROM SRO_VT_SHARD.dbo._User where CharID = @CharID) DECLARE @KilledCharName VARCHAR(512) = @Desc SELECT @KilledCharName = REPLACE(@KilledCharName, LEFT(@KilledCharName, CHARINDEX('(', @KilledCharName)), '') SELECT @KilledCharName = REPLACE(@KilledCharName, RIGHT(@KilledCharName, CHARINDEX(')', REVERSE(@KilledCharName))), '') ----- Killer CharID DECLARE @KilledCharID INT ,@KillerWorldID INT ,@KillerCharname varchar(50) ,@Killed1Charname varchar(50) SELECT @KilledCharID = CharID , @KillerWorldID = WorldID FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = @KilledCharName SELECT @KillerCharname = CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID SELECT @Killed1Charname = NickName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @KilledCharID SELECT @KilledCharName = NickName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID DECLARE @WorldIDKiller int = (SELECT WorldID FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID) -- Check if he kills the char more than 3 times DECLARE @PKill int = (select COUNT(*) from _JobNewSys where KillerID = @CharID and KilledID = @KilledCharID AND Kills = '1') DECLARE @KillsCount int = (SELECT count(Kills) FROM _JobNewSys WHERE KillerID = @CharID ) DECLARE @JobString VARCHAR(10) = LTRIM(RTRIM(SUBSTRING(@Desc, 5, 7))) DECLARE @JobType INT = CASE WHEN @JobString LIKE 'Trader' THEN 1 WHEN @JobString LIKE 'Robber' THEN 2 WHEN @JobString LIKE 'Hunter' THEN 3 ELSE 0 END DECLARE @IpKiller varchar(max) = 1--(SELECT IP FROM SRO_VT_MYTHIC.dbo._IPLogs WHERE CharID = @CharID ) DECLARE @IpKilled varchar(max) = 2--(SELECT IP FROM SRO_VT_MYTHIC.dbo._IPLogs WHERE CharID = @KilledCharID ) select @KilledCharName IF ( @PKill <= 3 AND @JobType <> 0 AND @WorldIDKiller != '60' AND @KillsCount < '500') --AND @IpKilled != @ipkiller) BEGIN INSERT INTO _JobNewSys (KillerID , KilledID , Kills) VALUES (@CharID , @KilledCharID,'1') IF @JobType = 2 BEGIN EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,1/*Silks Count*/ Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate()) END ELSE IF @JobType != 2 BEGIN EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,1/*Silks Count*/ Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate()) END END ELSE IF ( @PKill <= 3 AND @JobType <> 0 AND @WorldIDKiller = '60' AND @KillsCount < '500') --AND @IpKilled != @ipkiller) BEGIN INSERT INTO _JobNewSys (KillerID , KilledID , Kills) VALUES (@CharID , @KilledCharID,'1') IF @JobType = 2 BEGIN EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,1/*Silks Count*/ Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate()) END ELSE IF @JobType != 2 BEGIN EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,2/*Silks Count*/ Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate()) END END ELSE IF @PKill > '3' BEGIN --INSERT INTO SRO_VT_XEVENT.dbo._Chat ([send],[sendto],[Message],[date]) VALUES ('0',@KillerCharname,'You have killed '+@Killed1Charname +' 3times you wont earn more job points from him.',GETDATE()) Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' 4 times you wont earn more job points from him.',Getdate()) INSERT INTO _JobNewSys (KillerID , KilledID , Kills) VALUES (@CharID , @KilledCharID,'0') END if (@KillsCount >= 50) begin --INSERT INTO SRO_VT_XEVENT.dbo._Chat ([send],[sendto],[Message],[date]) VALUES ('0',@KillerCharname,'Your total job kills today is ['+CAST(@KillsCount AS VARCHAR(256))+']/500',GETDATE()) Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'Your total job kills today is ['+CAST(@KillsCount AS VARCHAR(256))+']/50',Getdate()) INSERT INTO _JobDay (CharID,Charname,IsDat) VALUES (@charid,@KillerCharname,GETDATE()) |
|||||||||||||
|
24-06-2020, 10:06 PM | #10 | ||||||||||||
|
برضو تمام مافيهوش اي حاجة
هو يعني لما بتلبس لبس الجوب بس بيجيلك الي بتاخدة من الجوب بس لما بتقلع لبس الجوب السيلك بيرجع عادي زي م كان ؟ |
||||||||||||
|
24-06-2020, 10:32 PM | #11 | ||||||||||||
|
|
||||||||||||
|
24-06-2020, 10:33 PM | #12 | |||||||||||||
|
اقتباس:
|
|||||||||||||
|
24-06-2020, 11:03 PM | #13 | ||||||||||||
|
الفيديو برايفت مش عايز يشتغل عندي
|
||||||||||||
|
24-06-2020, 11:10 PM | #14 | |||||||||||||
|
اقتباس:
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
|||||||||||||
|
24-06-2020, 11:17 PM | #15 | ||||||||||||
|
بدال بيفضل يجيلك لما بتعمل تيليبورت بعد م بتموت يبقي المشكلة ف البروسيدر ممكن يكون فية حاجة غلط ف باقي التابات حاول تراجع علية كلة من الاول
|
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|