Start: 1

Blocks: 3

Block #0

Zone: World

Players: 7564635

Rows: 386

Row: 7564635 - 0

Row: 5946422 - 100

Row: 3965438 - 25100

Row: 3351288 - 50100

<?php

$Statement1 = "SELECT k.Nickname, GROUP_CONCAT(k.Prozent1 SEPARATOR '*'),

GROUP_CONCAT(k.Prozent2 SEPARATOR '*'), l.Schnitt, k.Anz

FROM ( SELECT sp.Nickname, IF(b.BahnID<=9,SUM(b.Ass),1) Prozent1,

IF(b.BahnID>9,SUM(b.Ass),1) Prozent2, sp.ID, COUNT(b.Ass) Anz

FROM Spieler sp, Spiele s, Bahnergebnisse b, Spielergebnisse se

WHERE b.spielerID = sp.id AND b.SpielID = s.id AND se.SpielID = s.id

$qjahr $qgruppe $qgattung

GROUP BY b.BahnID, sp.Nickname )k,

( SELECT SUM(se.Gesamt)/COUNT(se.Gesamt) Schnitt, sp.ID,

try {

$this->simpleXml = new SimpleXMLElement($xmlString);

}

catch(Exception $e)

{

throw new TMException("null", 78); // invalid request

}

Note: client-server connection changed in build 2009-10-08/09

Here's a new release to fix once for good (hopefully) the player's authentication.

Summary of the previous episodes: a few additional checks were added to the server to detected players that were changing login or using

other people logins or fake logins. But they were only fixing the issue on the surface, and were easily circumvented.

So in this new version, we've introduce the correct fix (tm) for the issue, using rsa signature and the like, to make sure

that people trying to connect with some login were actually validated and trusted by the master server.

The new protocol is supposed to allow a smooth transition (new clients can still connect to old servers, old clients can still

connect to the new servers (if not forbiden via the config option).

Note: client-server connection changed in build 2009-10-08/09

Here's a new release to fix once for good (hopefully) the player's authentication.

Summary of the previous episodes: a few additional checks were added to the server to detected players that were changing login or using other people logins or fake logins. But they were only fixing the issue on the surface, and were easily circumvented.

So in this new version, we've introduce the correct fix (tm) for the issue, using rsa signature and the like, to make sure that people trying to connect with some login were actually validated and trusted by the master server.

The new protocol is supposed to allow a smooth transition (new clients can still connect to old servers, old clients can still connect to the new servers (if not forbiden via the config option).