Ага, нашел... Вот этот подозрительный тип, неприятной наружности!
строка 170 файла arenateam.php
Код:
$members = $sqlc->query("SELECT arena_team_member.guid,`characters`.name, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', $rating_offset), ' ', -1) AS personal_rating, level, arena_team_member.played_week, arena_team_member.wons_week, arena_team_member.played_season, arena_team_member.wons_season, `characters`.race, `characters`.class, `characters`.online, `characters`.account, `characters`.logout_time, gender, account FROM arena_team_member,`characters` LEFT JOIN arena_team_member k1 ON k1.`guid`=`characters`.`guid` AND k1.`arenateamid`='$arenateam_id' WHERE arena_team_member.arenateamid = '$arenateam_id' AND arena_team_member.guid=`characters`.guid ORDER BY `characters`.`name`");
Вот так у меня сейчас, попробуй у себя сделать.
Код:
$members = $sqlc->query("SELECT arena_team_member.guid,`characters`.name, `characters`.`arenaPoints` AS personal_rating, level, arena_team_member.played_week, arena_team_member.wons_week, arena_team_member.played_season, arena_team_member.wons_season, `characters`.race, `characters`.class, `characters`.online, `characters`.account, `characters`.logout_time, gender, account FROM arena_team_member,`characters` LEFT JOIN arena_team_member k1 ON k1.`guid`=`characters`.`guid` AND k1.`arenateamid`='$arenateam_id' WHERE arena_team_member.arenateamid = '$arenateam_id' AND arena_team_member.guid=`characters`.guid ORDER BY `characters`.`name`");
Это на проверку, не в svn сразу лить!!!!
Kirix
в аттаче кажется оно.