SQL-Bug in statement for calculation of loading times

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Open User Stats for a single user.

What is the expected output? What do you see instead?
Loading times should be shown.
Instead there is a 0.00/0.00/0.00 output an a error message in black on
black background

What version of the product are you using? On what operating system?
allstats r71

Please provide any additional information below.
fixed the bug in user.php
~line 275
$sql = "SELECT MIN(datetime), MIN(loadingtime), MAX(loadingtime),
AVG(loadingtime) FROM gameplayers LEFT JOIN games ON
games.id=gameplayers.gameid LEFT JOIN dotaplayers ON
dotaplayers.gameid=games.id AND dotaplayers.colour=gameplayers.colour LEFT
JOIN dotagames ON games.id=dotagames.gameid WHERE name='$username' AND
winner!=0";

and ~line 375
$sql = "SELECT MIN(datetime), MIN(loadingtime), MAX(loadingtime),
AVG(loadingtime) FROM gameplayers LEFT JOIN games ON
games.id=gameplayers.gameid LEFT JOIN dotaplayers ON
dotaplayers.gameid=games.id AND dotaplayers.colour=gameplayers.colour LEFT
JOIN dotagames ON games.id=dotagames.gameid WHERE name='$username'";

Original issue reported on code.google.com by af944...@googlemail.com on 14 Aug 2009 at 2:26

[GoogleCodeExporter]

see also: http://forum.codelain.com/index.php?topic=4752.msg56763#msg56763

Original comment by af944...@googlemail.com on 14 Aug 2009 at 2:32

[GoogleCodeExporter]

Original comment by af944...@googlemail.com on 27 Aug 2009 at 10:35

• Changed state: Verified