<?
if(isset($blog_id) && !empty($blog_id) && is_numeric($blog_id))
{
$query = mysql_query("SELECT blog_id, header, content, DATE_FORMAT(date, '%d %M %Y %H:%i') AS dato FROM blog_blogs WHERE blog_id = '".$blog_id."' LIMIT 1") or die("Blog med id".mysql_error());
$row = mysql_fetch_assoc($query);
echo "<div class=\"content_top\">\n";
echo "<h2>» ".$row["header"]."</h2>\n";
echo "<div class=\"date\">".$row["dato"]."</div>\n";
echo afterDB($row["content"]);
echo "</div>\n";
echo "<div class=\"content_bot\" style=\"text-align:left;\">\n";
echo "<h2>Kommentarer</h2>\n";
$get_comments = mysql_query("SELECT comment_id, name, email, website, comment, DATE_FORMAT(date, '%d %M %Y %H:%i') AS comment_date FROM blog_comments WHERE blog_id = '".$row["blog_id"]."'") or die("Kommentar med id".mysql_error());
if(mysql_num_rows($get_comments) < 1)
{
echo "Der er ingen kommentarer endnu!";
}
else
{
while($row_comments = mysql_fetch_assoc($get_comments))
{
echo "<div class=\"content_comments\">\n";
echo "<b>".$row_comments["name"]."</b> <div class=\"date\">".$row_comments["comment_date"]."</div>\n";
echo afterDB($row_comments["comment"]);
echo "</div>\n";
}
}
echo "<h2>Kommenter</h2><a name=\"comment\"></a>\n";
echo "<form action=\"".$config["root"]."handle.php?handle_type=comment&blog_id=".$row["blog_id"]."\" method=\"post\">\n";
echo "<table cellpadding=\"1\" cellspacing=\"0\" style=\"width:90%;z-index:0;\">\n";
echo "<tr>\n";
echo "<td>\n";
echo "<div class=\"comment_txt\">Navn: *</div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"text\" name=\"name\" size=\"25\"/><br />\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<div class=\"comment_txt\">Email: * (Bliver ikke vist) </div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"text\" name=\"email\" size=\"25\"/><br />\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<div class=\"comment_txt\">Website:</div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"text\" name=\"website\" size=\"25\" /><br />\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<div class=\"comment_txt\">Sikkerhedskode:<br />";
echo "</div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<input type=\"text\" name=\"website\" size=\"25\" /><br />\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<div class=\"comment_txt\">Besked *</div>\n";
echo "</td>\n";
echo "<td>\n";
echo "<textarea name=\"comment\" style=\"width:100%;height:150px;\"></textarea><br />\n";
echo "</td>\n";
echo "</tr>\n";
echo "<tr>\n";
echo "<td>\n";
echo "<div class=\"comment_txt\">* Skal udfyldes korrekt</div>\n";
echo "</td>\n";
echo "<td style=\"text-align:right;\">\n";
echo "<input type=\"submit\" value=\"Kommenter\">\n";
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "</form>\n";
echo "</div>\n";
}
else
{
$query = mysql_query("SELECT blog_id, header, content, DATE_FORMAT(date, '%d %M %Y %H:%i') AS dato FROM blog_blogs ORDER BY blog_id DESC LIMIT 5") or die("Forside".mysql_error());
while($row = mysql_fetch_assoc($query))
{
$get_comments = mysql_query("SELECT COUNT(comment_id) FROM blog_comments WHERE blog_id = '".$row["blog_id"]."'") or die(mysql_error());
$count_comments = mysql_result($get_comments, 0);
echo "<div class=\"content_top\">\n";
echo "<h2>» ".$row["header"]."</h2>\n";
echo "<div class=\"date\">".$row["dato"]."</div>\n";
if(strlen($row["content"]) > 300)
{
echo substr(afterDB($row["content"]), 0, 300)." [...]";
}
else
{
echo afterDB($row["content"]);
}
echo "</div>\n";
echo "<div class=\"content_bot\">\n";
echo "<img src=\"gfx/comment.gif\" alt=\"Kommenter\" title=\"Kommenter\" /> <a href=\"".$config["root"]."index.php?page_type=blog&blog_id=".$row["blog_id"]."&page_id=#comment\">Kommentér (".$count_comments.")</a>\n";
echo " ";
echo "<img src=\"gfx/read_more.gif\" alt=\"Læs mere\" title=\"Læs mere\" /> <a href=\"".$config["root"]."index.php?page_type=blog&blog_id=".$row["blog_id"]."&page_id=\">Læs mere</a>\n";
echo "</div>\n";
}
}
?>
