function display_entry_from_url() { $expl = explode("/", $_SERVER['REQUEST_URI']); $entrydate = $expl[1]; $e = undirify($expl[2]); $e = trim($e); $sql = "SELECT \n\t\tentries.title, \n\t\tentries.text,\n\t\tentries.text_more, \n\t\tauthors.uid, \n\t\tentries.date, \n\t\tentries.aid,\n\t\tentries.id, \n\t\tentries.comments,\n\t\tauthors.name \n\t\t\tFROM \n\t\tentries, \n\t\tauthors \n\t\t\tWHERE \n\t\tentries.aid = authors.uid \n\t\t\tAND \n\t\tentries.title LIKE ('{$e}%')\n\t\t\tAND\n\t\tentries.status = '1'\n\t\t\tAND\n\t\tFROM_UNIXTIME(entries.date, '%d%m%y') = '{$entrydate}'\n\t\t\tLIMIT 0,15"; $result = @mysql_query($sql); if (!$result) { print "<p>Error executing query: " . mysql_error() . "</p>\n"; } if (@mysql_num_rows($result) == 1) { while ($row = @mysql_fetch_array($result)) { extract($row); $hour = date("G:i", $date); $day = date("d.m.Y", $date); $date = date("G:i d. d.m || Y", $date); print "<div class='entry'>\n"; print "<div class='head'>\n"; print "<h1><img src='/img/permlink.gif' alt='' style=\"border: 0; vertical-align:middle; margin-right: 6px;\" />{$title}</h1>"; print "</div>\n"; print "<p class='date'>Kl. {$hour} d.{$day} af {$name}</p>\n"; $text = stripslashes($text); print "{$text}\n"; if (!empty($text_more)) { $text_more = stripslashes($text_more); print "<div id=\"mere\">{$text_more}</div>\n"; } $sql_c = "SELECT * FROM comments WHERE eid = '{$id}' order by date"; if (!($result_c = @mysql_query($sql_c))) { print "<p>error " . mysql_error() . "</p>"; } else { if (@mysql_num_rows($result_c) > 0) { print "<h2 id=\"c\" style=\"font-size: medium;\">Kommentarer</h2>\n"; while ($row_c = @mysql_fetch_array($result_c)) { extract($row_c); $data = "<div class=\"comment\">\n"; $data .= "<p>{$c_text}</p>\n"; $data .= "<p class=\"komm\">{$c_author}"; if (!empty($c_url)) { $data .= " | <a title=\"Besøg {$c_author} på nettet\" href=\"{$c_url}\">web</a>"; } if (!empty($c_email)) { $data .= " | <a title=\"Skriv en email til {$c_author}\" href=\"mailto:" . spam_safe($c_email) . "\">@</a>"; } $c_date = date("G:i / d.m / Y", $date); $c_date = strtolower($c_date); $data .= " / {$c_date}"; $data .= "</p>\n"; print $data; print "</div>\n"; } } } if ($comments == 'on') { @(include 'incs/includes.inc.php'); print $comments_form; } print "</div>\n"; } } else { print "<p>Der findes ingen indlæg med den adresse.</p>"; # print "<p>{$sql}</p>"; } }
function display_entry_from_url() { $expl = array_reverse(explode("/", $_SERVER['REQUEST_URI'])); $entrydate = $expl[1]; $e = $expl[0]; $e = trim($e); $sql = "SELECT \n\t\tentries.title, \n\t\tentries.slug,\n\t\tentries.text,\n\t\tentries.text_more, \n\t\tauthors.uid, \n\t\tentries.date, \n\t\tentries.aid,\n\t\tentries.id, \n\t\tentries.comments,\n\t\tauthors.name \n\t\t\tFROM \n\t\tentries, \n\t\tauthors \n\t\t\tWHERE \n\t\tentries.aid = authors.uid \n\t\t\tAND \n\t\tentries.slug LIKE ('{$e}%')\n\t\t\tAND\n\t\tentries.status = '1'\n\t\t\tAND\n\t\tFROM_UNIXTIME(entries.date, '%d%m%y') = '{$entrydate}'\n\t\t\tLIMIT 0,15"; $result = @mysql_query($sql); if (!$result) { print "<h4>Problems with the database, please to try again later.</h4><p>" . mysql_error() . "</p>"; } if (@mysql_num_rows($result) == 1) { while ($row = @mysql_fetch_array($result)) { extract($row); $hour = date("G:i", $date); $day = date("d.m.Y", $date); print '<div class="entry">'; print "<h1>{$title} <span style='color: #799dc6'>{$day}</span></h1>\n"; # print '<p class="byline">'.$hour.'</p>'; $text = stripslashes(format_entry($text)); print '<div class="ebody">'; print "{$text}\n"; if (!empty($text_more)) { $text_more = stripslashes(format_entry($text_more)); print "<div id=\"mere\">{$text_more}</div>\n"; } print '</div>'; $sql_c = "SELECT * FROM comments WHERE eid = '{$id}' order by date"; if (!($result_c = @mysql_query($sql_c))) { print "<p>error " . mysql_error() . "</p>"; } else { if (@mysql_num_rows($result_c) > 0) { $comment_count = 1; print '<h2 id="c">Comments</h2>'; while ($row_c = @mysql_fetch_array($result_c)) { extract($row_c); # $commentstyle = ($comment_count % 2) ? 'commentdark' : 'commentlight'; $data = '<div class="' . $commentstyle . '">'; #$commentnumber = ($comment_count % 2) ? 'commentnumberlight' : 'commentnumberdark'; #$data .= '<div class="'.$commentnumber.'">'.$comment_count.'</div>'; $data .= '<p class="komm">' . $c_author . ''; if (!empty($c_url)) { $data .= " | <a title=\"Visit {$c_author} on the web\" href=\"{$c_url}\" rel=\"nofollow\">web</a>"; } if (!empty($c_email)) { $data .= " | <a title=\"Write an email to {$c_author}\" href=\"mailto:" . spam_safe($c_email) . "\">@</a>"; } $c_date = date("G:i / jS \\o\f F / Y", $date); $c_date = strtolower($c_date); $data .= " / <a href=\"#c-" . $c_id . "\" id='c-{$c_id}' title=\"Permalink to this comment\">{$c_date}</a>"; $data .= "</p>\n"; $data .= "<div class='kommentry'>" . format_entry($c_text) . "</div>"; print $data; # print '<hr />'; print "</div>\n"; $comment_count++; } } } if ($comments == 'on') { @(include 'incs/includes.inc.php'); print $comments_form; } /* $sql_seek = "select * from entries;"; $result_seek = mysql_query($sql_seek); mysql_data_seek($result_seek, 70); while ($row = mysql_fetch_array($result_seek)) { extract($row); print $id."--".$title."<br />"; } */ } } else { #print "<p>Der findes ingen indlæg med den adresse.</p>"; #print "<p>{$sql}</p>"; } }