Entferne:
show_table_separator($lang['top_image_rating'], 4);
$sql = "SELECT image_id, image_name, image_rating
FROM ".IMAGES_TABLE."
ORDER BY image_rating DESC
LIMIT $stats_limit";
$result = $site_db->query($sql);
$num = 1;
while ($row = $site_db->fetch_array($result)) {
if ($num == 1) {
$max = $row['image_rating'];
if ($max == 0) {
$max = 1;
}
}
echo "<tr class=\"".get_row_bg()."\">\n";
echo "<td> ".$num.".</td>\n<td nowrap=\"nowrap\"><b><a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$row['image_id'])."\" target=\"_blank\">".$row['image_name']."</a></b></td>\n\n";
$per = intval($row['image_rating'] / $max * 100);
echo "<td width=\"100%\">\n";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\" width=\"100%\"><tr><td bgcolor=\"#FFFFFF\">\n";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"".$per."%\"><tr>\n";
echo "<td bgcolor=\"#FCDC43\"><img src=\"images/spacer.gif\" height=\"10\" width=\"2\"></td>\n";
echo "</tr></table></td></tr></table>\n</td>";
echo "<td align=\"center\">".$row['image_rating']."</td></tr>\n";
$num++;
}
if ($num == 1) {
echo "<tr class=\"".get_row_bg()."\">\n<td colspan=\"4\">".$lang['no_search_results']."</td></tr>";
}
$sql = "SELECT SUM(image_votes) AS sum
FROM ".IMAGES_TABLE;
$row = $site_db->query_firstrow($sql);
$sum = (isset($row['sum'])) ? $row['sum'] : 0;
show_table_separator($lang['top_image_votes']." (".$lang['homestats_total']." ".$sum.")", 4);
$sql = "SELECT image_id, image_name, image_votes
FROM ".IMAGES_TABLE."
ORDER BY image_votes DESC
LIMIT $stats_limit";
$result = $site_db->query($sql);
$num = 1;
while ($row = $site_db->fetch_array($result)) {
if ($num == 1) {
$max = $row['image_votes'];
if ($max == 0) {
$max = 1;
}
}
echo "<tr class=\"".get_row_bg()."\">\n";
echo "<td> ".$num.".</td>\n<td nowrap=\"nowrap\"><b><a href=\"".$site_sess->url(ROOT_PATH."details.php?".URL_IMAGE_ID."=".$row['image_id'])."\" target=\"_blank\">".$row['image_name']."</a></b></td>\n\n";
$per = intval($row['image_votes'] / $max * 100);
echo "<td width=\"100%\">\n";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\" width=\"100%\"><tr><td bgcolor=\"#FFFFFF\">\n";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"".$per."%\"><tr>\n";
echo "<td bgcolor=\"#FCDC43\"><img src=\"images/spacer.gif\" height=\"10\" width=\"2\"></td>\n";
echo "</tr></table></td></tr></table>\n</td>";
echo "<td align=\"center\">".$row['image_votes']."</td></tr>\n";
$num++;
}
if ($num == 1) {
echo "<tr class=\"".get_row_bg()."\">\n<td colspan=\"4\">".$lang['no_search_results']."</td></tr>";
}
Jan