3 rettelser
I nedenstående script har jeg 3 små rettelser jeg gerne vil have gennemført.I. Kategorier bliver til links hvis kategorien har >5 links, og de links der er i den enkelte kat. vises også i 4 kolonner, og med rate ikonet foran.
II. I index.php vises alle links blandet og med et ikon der viser dens rate, oversigten skal ændres så den vises ligesom index.php?show=kat og ikonerne vises foran hvert link
III. /links/index.php?show=kat ændres så den vises også når man kun skriver /links/index.php eller /links
<?php
$page_title = "Links";
$stylesheet = "style";
$bg = "index";
$menu = "links";
include($DOCUMENT_ROOT.'/php/start.php');
require($_SERVER["DOCUMENT_ROOT"].'/php/links_boot.php');
include($_SERVER["DOCUMENT_ROOT"].'/php/links_functions.php');
$thisfile = $PHP_SELF;
// linkstrenge til de tre funktioner.
//$linkshowtop = "<a href=\"$thisfile\">Top links</a> ";
$linkshowall = "<a href=\"$thisfile?show=all\">Vis alle</a> ";
$linkshowkat = "<a href=\"$thisfile?show=kat\">Kategorier</a> ";
$linkadd = "<a href=\"addurl.php\">Tilføj link</a>";
if (strtolower($show) == "all") {
$where = "";
} else {
$where = " having point >= 0";
}
$count = query("select sum(hits) as cnt from links");
$hitcount = $count[0]->cnt;
//$result = query("select id,title,date,rating,hits,url,(hits*rating-(to_days(curdate())-to_days(date))) as point ".
$result = query("select id,title,date,rating,hits,url,(hits*rating) as point ".
"from links$where order by point DESC");
page_start("");
//echo $linkshowtop;
//echo $linkshowall;
//echo $linkshowkat;
//echo $linkadd;
if ($_GET['addurl'] != "yes" && $_GET['show'] == "all" || !$_GET['show']) {
echo "<table width='100%' border='0'>\n";
for ($i=0;$i<sizeof($result);$i++) {
if ($result[$i]->point >= 0) {
$point = $result[$i]->point;
} else {
$point = "-";
}
echo "<tr><td><p title='".$result[$i]->url."'>".
"<a href='golink.php?id=".$result[$i]->id."'target='_blank'>".
stripslashes($result[$i]->title)."</a><a href='".$result[$i]->url."'>".
"</a></td>".
"<td><img src=\"/images/links/".$result[$i]->rating.".gif\" ".
"alt='".stars($result[$i]->rating)."'width='33' height='9'></td>".
"<td align=\"right\">".$result[$i]->hits."</td>";
echo "<td align=\"right\">$point</td>";
echo "</tr>\n";
}
echo "</table>";
} else if ($_GET['show'] == "kat") {
echo '<table style="margin: auto; width: 100%;"><tr>';
$number = 0;
//$query = mysql_query("SELECT * FROM links_kat ORDER BY kategori ASC") or die(mysql_error());
$query = mysql_query("SELECT * FROM links_kat WHERE speciel='0' ORDER BY kategori ASC") or die(mysql_error());
while ($data = mysql_fetch_array($query)) {
$id = $data['id'];
$kategori = $data['kategori'];
$number++;
$query2 = mysql_query("SELECT id, title, url FROM links WHERE kat_id = '$id' ORDER BY hits DESC LIMIT 5") or die(mysql_error()); // Viser 5 links pr. kat.
//$query2 = mysql_query("SELECT id, title, url FROM links WHERE kat_id = '$id' ORDER BY hits DESC") or die(mysql_error()); // Viser alle links i kat.
$query3 = mysql_query("SELECT id FROM links WHERE kat_id = '$id'") or die(mysql_error());
$count = mysql_num_rows($query3);
echo '<td style="width: 25%; vertical-align: top"><strong>' . $kategori . '</strong> (' . $count . ')<br />';
while ($data2 = mysql_fetch_array($query2)) {
$title = $data2['title'];
$url = $data2['url'];
echo ' • <a href="' . $url . '" target="_blank" title="' . $url . '">' . stripslashes($title) . '</a><br />';
}
echo '</td>';
if ($number != 0) {
if (($number % 4) == 0) {
echo "</tr>\n\n";
echo "<tr>\n";
}
}
}
echo '</tr></table>';
} else {
?>
<?php
}
echo "Klik i alt : $hitcount\n";
echo mysql_error();
page_end();
include($DOCUMENT_ROOT.'/php/end.php');
?>
