opentable("Paskutiniai komentarai");

$i = 0;

$result = dbquery(

"SELECT * FROM ".$db_prefix."comments LEFT JOIN ".$db_prefix."users

ON ".$db_prefix."comments.comment_name=".$db_prefix."users.user_id

ORDER BY comment_datestamp DESC LIMIT 05"

);

if (dbrows($result)) {

echo "<table width='100%' align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n";

while ($data = dbarray($result)) {

echo "<tr>\n<td class='".($i% 2==0?"tbl1":"tbl2")."'><span class='comment-name'>";

if ($data['user_name']) {

echo "<a href='".BASEDIR."profile.php?lookup=".$data['comment_name']."' class='slink'>".$data['user_name']."</a>";

} else {

echo $data['comment_name'];

}

$comment_message = nl2br(parseubb(parsesmileys($data['comment_message'])));

$comment_item_id = $data['comment_item_id'];

$comment_type = $data['comment_type'];

echo "</span>

<span class='small'>Data: ".showdate("longdate", $data['comment_datestamp'])."</span><br>

".$comment_message."<br>";

 

if ($data['comment_type'] == "N") {

echo "<a href='".BASEDIR."news.php?readmore=".$data['comment_item_id']."'>Žiūrėti komentarą</a><br>";

}

else if ($data['comment_type'] == "F") {

echo "<a href='".BASEDIR."downloads.php?page_id=".$data['comment_item_id']."'>Žiūrėti komentarą</a><br>";

}

else {

echo "Nuorodos į saitus nėra.";

}

 

echo "</td>\n</tr>\n";

$i++;

}

echo "</table>\n";

} else {

echo "<center><br>Komentarų nėra.<br><br></center>\n";

}

closetable();