RANKING_TBL

Atre · 15. Dezember 2010, 02:08

Hallo liebe Coreler
Ich habe gemerkt das die Ranking_tbl nicht beschrieben wird .
Somit ist beste gilde ... ingame nicht verfügbar Ich habe 2 Ranking tbls benutzt 1x die Ranking tbl von rage**** wo die datenbanken kommplett seien sollten und die von gn*.
Wenn ich werte extern reinschreibe werden diese Ingame ausgegeben also denke ich liegt das Problem beim eintragen , am Server , wenn ich falsch liege bitte sagen .
Wie kann ich das richten bzw. was muss ich ändern .
Wenns umbedingt nötig ist würde ich bis zu 10 euro paypal bezahlen :s
lg Atre

Cross · 15. Dezember 2010, 02:12

[FONT="Tahoma"][COLOR="LemonChiffon"][SIZE="2"]irgendwo hier im forum war mal eine komplette ranking_dbf mit ranking_str releast.. finds grad nur nichmehr - war zwar für v14 sollte aber auf 15 genauso laufen.[/SIZE][/COLOR][/FONT]

Atre · 15. Dezember 2010, 02:29

Also hat es nichts mit dem Server zu tun ? , nutze die Server ausm Source .
habe die von gn* mal getestet nur um zu sehen obs geht und da es bei denen ja geht , es ging bei mir nicht , ich habe einen street gw gemacht und die db war unbeschrieben .
Linked Servers habe ich natürlich erstellt.

Cross · 15. Dezember 2010, 02:44

[FONT="Tahoma"][COLOR="LemonChiffon"][SIZE="2"]ich tippe mal das die ranking_str nen schuss weg hat.
finds grad nich im forum.
versuch mal das hier:

PHP-Quellcode

CREATE PROC MAKE_RANKING_STR
@iserverindex CHAR(2) = '01'
AS
set nocount on
DECLARE @currDate char(10),@om_nCount INT,@of_nCount INT
SET @currDate = CONVERT(CHAR(8),GETDATE(),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
-- + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
--R1 : ????
--R2 : ???
--R3 : ???
--R4 : ?????
--R5 : ?????
--R6 : ????
--R7 : ????
--R8 : ?????
--SELECT * FROM RANKING.RANKING_DBF.dbo.RANKING_TBL
--DELETE RANKING.RANKING_DBF.dbo.RANKING_TBL
--R1 : ????
IF EXISTS(SELECT * FROM RANKING.RANKING_DBF.dbo.RANKING_TBL WHERE s_date = @currDate and serverindex = @iserverindex)
BEGIN
DELETE RANKING.RANKING_DBF.dbo.RANKING_TBL WHERE s_date = @currDate and serverindex = @iserverindex
END
BEGIN
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R1',s_date = @currDate,-- m_Title = '????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority ='F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_nWinPoint DESC,m_nWin DESC
--R2 : ???
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R2',s_date = @currDate,--m_Title = '???',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_nWin DESC,CreateTime
--R3 : ???
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R3',s_date = @currDate,-- m_Title = '???',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_nLose DESC,m_nSurrender DESC
--R4 : ?????
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R4',s_date = @currDate,-- m_Title = '?????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_nSurrender DESC,m_nLose DESC
--R5 : ?????
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R5',s_date = @currDate,-- m_Title = '?????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_MaximumUnity DESC,CreateTime
--R6 : ????
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
select top 20 *
from (
SELECT TOP 20 Gu = 'R6', s_date = @currDate,-- m_Title = '????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(dbo.fn_GuildGold(A.m_nGuildGold)),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
and A.m_nGuildGold > 0
GROUP BY B.m_idGuild
ORDER BY m_nGuildGold DESC,CreateTime
/*union all
SELECT TOP 20 Gu = 'R6', s_date = @currDate,-- m_Title = '????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
-- m_nGuildGold = ISNULL(MAX(A.m_nGuildGold + 4294967295),0),
m_nGuildGold = isnull(max(dbo.fn_GuildGold(A.m_nGuildGold)), 0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
and A.m_nGuildGold < 0
GROUP BY B.m_idGuild
ORDER BY A.m_nGuildGold DESC,CreateTime*/)x
order by m_nGuildGold desc, CreateTime
/*SELECT TOP 20 Gu = 'R6',s_date = @currDate,-- m_Title = '????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_nGuildGold DESC,CreateTime
*/
--R7 : ????
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R7',s_date = @currDate,-- m_Title = '????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND A.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_AvgLevel DESC,CreateTime
--R8 : ?????
INSERT RANKING.RANKING_DBF.dbo.RANKING_TBL
(
Gu, s_date,
serverindex,
m_dwLogo,
m_idGuild,
m_szGuild,
m_szName,
m_nWin,
m_nLose,
m_nSurrender,
m_MaximumUnity,
m_AvgLevel,
m_nGuildGold,
m_nWinPoint,
m_nPlayTime,
CreateTime
)
SELECT TOP 20 Gu = 'R8',s_date = @currDate,-- m_Title = '????',
serverindex = MAX(A.serverindex),
m_dwLogo = MAX(A.m_dwLogo),
B.m_idGuild,
m_szGuild = MAX(A.m_szGuild),
m_szName = MAX(C.m_szName),
m_nWin = MAX(A.m_nWin),
m_nLose = MAX(A.m_nLose)+ MAX(A.m_nSurrender),
m_nSurrender = MAX(A.m_nSurrender),
m_MaximumUnity = CONVERT(REAL,MAX(A.m_nWin)-(COUNT(B.m_nSurrender)/MAX(A.m_nLevel))),
m_AvgLevel = ISNULL(AVG(E.m_nLevel),0),
m_nGuildGold = ISNULL(MAX(A.m_nGuildGold),0),
m_nWinPoint = ISNULL(MAX(A.m_nWinPoint),0),
m_nPlayTime = ISNULL(SUM(E.TotalPlayTime),0),
CreateTime = MAX(A.CreateTime)
FROM GUILD_TBL A,GUILD_MEMBER_TBL B,CHARACTER_TBL C,ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL D,CHARACTER_TBL E
WHERE A.m_idGuild = B.m_idGuild
AND C.serverindex = E.serverindex
AND C.m_idPlayer = E.m_idPlayer
AND B.m_nMemberLv = 0
AND B.m_idPlayer = C.m_idPlayer
AND A.serverindex = B.serverindex
AND B.serverindex = C.serverindex
AND C.serverindex = @iserverindex
AND D.m_chLoginAuthority = 'F'
AND C.account = D.account
GROUP BY B.m_idGuild
ORDER BY m_nPlayTime DESC,CreateTime
END

Alles anzeigen

Fand ich eben noch auf meiner Festplatte[/SIZE][/COLOR][/FONT]

Atre · 15. Dezember 2010, 14:42

hab die prozedur ersetzt und es geht leider wieder nit :< steht auch nix drin in der ranking
hab ingame auch /GuildRanking aktualisiert .
Hms wenn jemand noch kostenlose vorschläge hat :D , wenn nicht ich bezahle 10 euro dafür /pm wer interrese hat

PHP-Quellcode

Teilen