الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   Rank Uniqe (https://silkroad4arab.com/vb/showthread.php?t=555005)

Silver4NET 21-04-2014 03:42 PM

Rank Uniqe
 
حد هنا عرف يوصل لعميل Rank زى ده

http://im85.gulfup.com/KXlRwJ.bmp

Hero 21-04-2014 04:26 PM

يعنى انتا عملها ولا عايز تعملها

magic99 22-04-2014 01:07 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hero (المشاركة 5042803)
يعنى انتا عملها ولا عايز تعملها

اكيد عاوز يعمل واحده زيها

Silver4NET 22-04-2014 11:50 AM

والله حضراتكوا فجئتونى طبعا عايز اعمل واحده زيها بس تكون طريقه عن تجربه

Silver4NET 23-04-2014 01:22 PM

UP

Silver4NET 24-04-2014 04:47 PM

UP

Silver4NET 26-04-2014 10:52 PM

UP

Silver4NET 27-04-2014 08:55 PM

UP

Silver4NET 28-04-2014 11:46 AM

UP

Silver4NET 01-05-2014 10:07 PM

هو مفيش حد هنا ليه فى PHP خلاص يا رايت الموضوع يغلق وانا اتعلمت PHP وهبقى انزل Rank كامل ان شاء الله فى شهر 6

Tigger 02-05-2014 01:17 AM

كود بلغة HTML:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_UniqueRanking_UPDATE] by Caipi // Script Date: 03/06/2012 12:44:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_UniqueRanking_UPDATE]

        @Path varchar(max), @Days int

as

SET NOCOUNT ON

Declare
        @End varchar(max), @Date varchar(max),
        @Start varchar(max), @1 varchar(max), @2 varchar(max), @3 varchar(max), @SEnd varchar(max);

SET        @Start = (SELECT CONVERT(varchar(8), (GETDATE()-(1+(@Days))), 112))
SET        @1 = SUBSTRING(@Start,1,4)
SET        @2 = SUBSTRING(@Start,5,2)
SET        @3 = SUBSTRING(@Start,7,2)
SET        @SEnd = @1 + '-' + @2 + '-' + @3

SET        @Date    =    @SEnd
SET        @End    =    'BULK INSERT dbo.#temp_fatallog FROM'+' '+'"'+@Path+'\'+@Date+'_FatalLog.txt"'

IF exists (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like '#temp_finalkilllog')
BEGIN DROP TABLE #temp_finalkilllog END
IF exists (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like '#temp_fatallog')
BEGIN DROP TABLE #temp_fatallog END
IF exists (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like '#temp_killlog')
BEGIN DROP TABLE #temp_killlog END

IF not exists (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like '_FatalLog_Files')
BEGIN
CREATE TABLE _FatalLog_Files
(
[Already added] varchar(max) NULL
)
END

/*##*/
IF not exists (SELECT [Already added] FROM _FatalLog_Files WHERE [Already added] = @Date)
BEGIN
/*#*/

CREATE TABLE #temp_fatallog (
[Date1] varchar(max),
[Date2] varchar(max),
[Text1] varchar(max)
)

EXEC (@End) /*BULK INSERT*/

DELETE FROM #temp_fatallog WHERE (Text1 not like '%Unique%' OR Text1 not like '%killed%')

SELECT Date1+' '+Date2 as 'Datum', Text1 as 'Textstring' INTO #temp_killlog FROM #temp_fatallog WITH (NOLOCK) ORDER BY Date2 asc

DROP TABLE #temp_fatallog

IF not exists (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like '_temp_UniqueRanking')
BEGIN

SELECT
SUBSTRING(Textstring,PATINDEX('%MOB%',Textstring),PATINDEX('%by%',Textstring)-(PATINDEX('%MOB%',Textstring)+2)) as 'Unique',
SUBSTRING(Textstring,PATINDEX('%by%',Textstring)+4,LEN(Textstring)-(PATINDEX('%by%',Textstring)+4)) as Killer
INTO _temp_UniqueRanking
FROM #temp_killlog WITH (NOLOCK)

END
ELSE BEGIN

INSERT INTO _temp_UniqueRanking
SELECT
SUBSTRING(Textstring,PATINDEX('%MOB%',Textstring),PATINDEX('%by%',Textstring)-(PATINDEX('%MOB%',Textstring)+2)) as 'Unique',
SUBSTRING(Textstring,PATINDEX('%by%',Textstring)+4,LEN(Textstring)-(PATINDEX('%by%',Textstring)+4)) as Killer
FROM #temp_killlog WITH (NOLOCK)

END

DROP TABLE #temp_killlog


IF not exists (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like '_UniqueRanking')
BEGIN

SELECT temp.[Killer],
temp.[Unique],
COUNT(temp.[Unique]) as Kills
INTO _UniqueRanking
FROM _temp_UniqueRanking as temp
GROUP BY (temp.[Killer]), temp.[Unique]
ORDER BY temp.[Killer] asc

INSERT INTO _FatalLog_Files VALUES(@Date)

END
ELSE BEGIN


TRUNCATE TABLE _UniqueRanking

INSERT INTO _UniqueRanking
SELECT temp.[Killer],
temp.[Unique],
COUNT(temp.[Unique]) as Kills
FROM _temp_UniqueRanking as temp
GROUP BY (temp.[Killer]), temp.[Unique]
ORDER BY temp.[Killer] asc


INSERT INTO _FatalLog_Files VALUES(@Date)


END

/*#*/
END
/*##*/

SET NOCOUNT OFF


Tigger 02-05-2014 01:17 AM

كود بلغة HTML:

Declare @Days int, @Path varchar(max);

SET @Days = 35
SET @Path = 'C:\Blitzkrieq_Bin_Data\FatalLog'

WHILE (@Days >= 0)
BEGIN
exec _UniqueRanking_UPDATE @Path,@Days
SET @Days = @Days - 1
END


Tigger 02-05-2014 01:18 AM

كود بلغة HTML:

ELECT
    Killer,
    CASE [Unique]
    WHEN 'MOB_KK_ISYUTARU' THEN 'Isyutaru'
    WHEN 'MOB_CH_TIGERWOMAN' THEN 'Tiger Girl'
    ELSE [Unique] END as 'Unique',
    Kills

FROM    _UniqueRanking
WHERE    [Unique] like 'MOB_KK_ISYUTARU' OR [Unique] like 'MOB_CH_TIGERWOMAN'

ORDER BY Kills desc


Tigger 02-05-2014 01:18 AM

Done:lmfao:

Silver4NET 02-05-2014 05:21 PM

شكراً بس انا عارف الرانك فى الداتا بيز والحمد لله انا بس كنت عايز طريقه جميله زى اللى فى الصوره معبره عنها فى Website (PHP)

وملقتهاش وشكراً ولو مفيش حل يغلق


الساعة الآن 01:44 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.