

<?php


if (stristr($_SERVER['SCRIPT_NAME'], basename(__FILE__)) OR !defined('UN_KERNELFILES_LOADED')) {
Header("Location: ../index.php");
die();
}


if ($multilingual == 1) {
$queryalang = "WHERE (alanguage='$currentlang' OR alanguage='')"; /* top stories */
$querya1lang = "WHERE (alanguage='$currentlang' OR alanguage='') AND"; /* top stories */
$queryslang = "WHERE slanguage='$currentlang' "; /* top section articles */
$queryplang = "WHERE planguage='$currentlang' "; /* top polls */
$queryrlang = "WHERE rlanguage='$currentlang' "; /* top reviews */
} else {
$queryalang = "";
$querya1lang = "WHERE";
$queryslang = "";
$queryplang = "";
$queryrlang = "";
}


global $prefix, $db;
$a = 1;


$result = $db->sql_query("SELECT sid, title, counter FROM ".$prefix."_stories $queryalang ORDER BY counter DESC LIMIT 0,10");
if ($db->sql_numrows($result) > 0) {
$content = "<table border="0" cellpadding="10" width="100%"><tr><td align="left">";
$content. = "<font class="option"><b>10 "._READSTORIES."</b></font><br><br><font class="content">";
while ($row = $db->sql_fetchrow($result)) {
$sid = intval($row['sid']);
$title = stripslashes(check_html($row['title'], "nohtml"));
$counter = intval($row['counter']);
if($counter>0) {
$content. = "<strong><big>·</big></strong> $a: <a href="modules.php?name=News&file=article&sid=$sid">$title</a> - ($counter "._READS.")<br>";
$a++;
}
}
$content. = "</font></td></tr></table><br>";
}




?>
Osobně bych to spáchal nějak takhle:


<?php


if (stristr($_SERVER['SCRIPT_NAME'], basename(__FILE__)) OR !defined('UN_KERNELFILES_LOADED')) {
Header("Location: ../index.php");
die();
}


////////////////////
// CONFIG //


$pocet = 10;
///////////////////


global $prefix, $multilingual, $currentlang, $db;


if ($multilingual == 1) {
$querylang = "WHERE (alanguage='$currentlang' OR alanguage='')";
} else {
$querylang = "";
}


$content = "<center><font class="option"><b>10 "._READSTORIES."</b></font></center><br><br>";
$content .= "<table width="100%" border="0">";


$a = 1;
$result = $db->sql_query("SELECT sid, title, comments, counter FROM ".$prefix."_stories $querylang ORDER BY counter DESC LIMIT 0,$pocet");
while ($row = $db->sql_fetchrow($result)) {
$sid = intval($row['sid']);
$title = stripslashes($row['title']);
$comtotal = stripslashes($row['comments']);
$counter = $row['counter'];
$content .= "<tr><td align="left" width="100%"><strong><big>·</big></strong> $a: <a href="modules.php?name=News&file=article&sid=$sid">$title</a></td></tr><tr><td align="right" width="100%">[ $counter "._READS." ]</td></tr>";
$a++;
}


$content .= "</table>";


?>


)


<?php


if (stristr($_SERVER['SCRIPT_NAME'], basename(__FILE__)) OR !defined('UN_KERNELFILES_LOADED')) {
Header("Location: ../index.php");
die();
}


//////////////////////
// CONFIG //
$pocet = 10;
/////////////////////


global $prefix, $multilingual, $currentlang, $db;


if ($multilingual == 1) {
$querylang = "WHERE (alanguage='$currentlang' OR alanguage='')";
} else {
$querylang = "";
}


$a = 1;
$result = $db->sql_query("SELECT sid, title, counter FROM ".$prefix."_stories $querylang ORDER BY counter DESC LIMIT 0,$pocet");
while ($row = $db->sql_fetchrow($result)) {
$sid = intval($row['sid']);
$title = stripslashes($row['title']);
$counter = $row['counter'];
$content .= "<strong><big>·</big></strong> <a href="modules.php?name=News&file=article&sid=$sid">$title</a><br>[ $counter "._READS." ]<br>";
$a++;
}


?>
Obsah fóra BLASSENweb » United-Nuke
![]() |
|