Reitings

get_results(“select result.date as date
from result
where year(result.date) = ” . $year->year . ”
and month(result.date) = $month
group by result.date
order by 1;”);
foreach ($dates as $date) {
?>

year;
if ($month) {
$sql = $sql . ” and month(result.date) = $month”;
}
$sql = $sql . ” group by players.name,
players.surname
order by 4 desc;”;
$players = $wpdb->get_results($sql);
$k = 0;
foreach ($players as $player) {
if ($k == 0) {
echo(“

“);
$j++;
if (!$month) {
for ($i = 1; $i <= 12; $i++) { $sql = "select result.player_id as players_id, sum(result.points) as points from result where year(result.date) = " . $year->year . ”
and result.player_id = $player->id
and month(result.date) = $i
group by result.player_id
order by date;”;
$results = $wpdb->get_results($sql);
echo(“

“);
}
} else {
$dates = $wpdb->get_results(“select result.date as date
from result
where year(result.date) = ” . $year->year . ”
and month(result.date) = $month
group by result.date
order by 1;”);
foreach ($dates as $date) {
$results = $wpdb->get_results(“select result.points as points
from result
where result.player_id = $player->id
and result.date = ‘$date->date’
group by result.player_id
order by date;”);
echo(“

“);
}
}
$sql = “select result.player_id as players_id,
sum(result.points) as points
from result
where year(result.date) = ” . $year->year . ”
and result.player_id = $player->id”;
if ($month) {
$sql = $sql . ” and month(result.date) = $month”;
}
$sql = $sql . ” group by result.player_id
order by date;”;
$results = $wpdb->get_results($sql);
foreach ($results as $result) {
echo(“

“);
}
echo(“

“);
}
?>