RANKING_TBL

Atre

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

[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

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

[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

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

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

RANKING_TBL

Jetzt mitmachen!

SCHNELLZUGRIFF

HILFE & COMMUNITY

RECHTLICHES