شـريـط الاهـداءات | |
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
05-06-2015, 04:10 PM | #1 | ||||||||||||
|
السلام عليكم ورحمة الله وبركاته ازيكم يارجاله ...والله انا كان عندى طلب بسيط لو سمحت واتمنى اى حد يقدر يساعدنى انا كنت عايز اعمل نظام silk per h كل حاجه عملتها تمام من الموضوع ده عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] بس مرضاش يشتغل مش بيجيلى اى سيلك ولا بعد ساعه ولا حتى 10 ساعات اتمنى الى بيفهم فيه يساعدنى لو سمحت ويستحسن يكون T.V لانى بقالى يومين مش عارف احل المشكله دى وشكرا |
||||||||||||
|
05-06-2015, 11:45 PM | #2 | ||||||||||||
|
اولا ممنوع التيم فيور
تاني حاجة السيستم شغال 100% . فية غلطة عندة بس في البروسيدر دي كود:
USE [USE SRO_VT_SHARDLOG] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[_GetSilkperHour] /*by Yui*/ @CharID int as Declare @totalMinutes bigint = (SELECT tMinutes FROM _OnlineOffline WHERE CharID = @CharID), @Silkoutput int; /*Calculating the Silk/Hour-Amount related to the Online Time*/ SET @Silkoutput = CASE WHEN @totalMinutes >= (SELECT [Step3Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements') THEN (SELECT [Step3Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') WHEN @totalMinutes >= (SELECT [Step2Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements') THEN (SELECT [Step2Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') WHEN @totalMinutes >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements') THEN (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') ELSE (SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') END RETURN @Silkoutput كود:
USE [SRO_VT_SHARDLOG] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[_GetSilkperHour] /*by Yui*/ @CharID int as Declare @totalMinutes bigint = (SELECT tMinutes FROM _OnlineOffline WHERE CharID = @CharID), @Silkoutput int; /*Calculating the Silk/Hour-Amount related to the Online Time*/ SET @Silkoutput = CASE WHEN @totalMinutes >= (SELECT [Step3Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements') THEN (SELECT [Step3Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') WHEN @totalMinutes >= (SELECT [Step2Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements') THEN (SELECT [Step2Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') WHEN @totalMinutes >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements') THEN (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') ELSE (SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates') END RETURN @Silkoutput |
||||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|