openside("Komentarze");



$result = dbquery("SELECT user_avatar, user_imie, user_nazwisko, c.*, IFNULL(u.user_name, c.comment_name) as user_name FROM ".DB_COMMENTS." c LEFT JOIN ".DB_USERS." u ON (c.comment_name = u.user_id) ORDER BY c.comment_id DESC LIMIT 10");



if (dbrows($result) != 0) {

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



switch ($data['comment_type']) {

case 'A': $typ='readarticle.php?article_id';

$kom= "artykuł";

$nazwa='';

break;

case 'N':$typ='news.php?readmore' ;

$kom= "news'a";

$nazwa='';

break;

case 'P':$typ='photogallery.php?photo_id' ;

$kom= "zdjęcie";

$nazwa='';

break;

case 'U':$typ='userphotogallery.php?photo_id' ;

$kom= "zdjęcie";

$nazwa='';

break;

case 'C':$typ='viewpage.php?page_id' ;

$kom= "dodatkową stronę";

$nazwa='';

break;

}

echo "<table cellpadding='0' cellspacing='2' width='100%' border='0'><tr>";

if (isNum($data['comment_name'])) { // Jesli liczba - user, w przeciwnym wypadku - gosc

if ($data['user_avatar'] && file_exists(IMAGES."avatars/".$data['user_avatar']))  {

echo "<td width='40px' valign='top'>

<a href='".BASEDIR."profile.php?lookup=".$data['comment_name']."' class='nick'><img src='".IMAGES."avatars/".$data['user_avatar']."' border='0' height='40' width='40' align='left' alt='' /></a></td>";

} else {

echo "<td width='40px' valign='top'>

<a href='".BASEDIR."profile.php?lookup=".$data['comment_name']."' class='nick'><img src='".IMAGES."noav.gif' border='0' height='40' width='40' align='left' alt='' /></a></td>";

}



} else {

echo "<td><span class='gosc'>".$data['user_name']."</span></td>";

}



echo "<td valign='top' style='border-top:1px solid #999999;'><span class='data' style='font-size:10px;'>".showdate("longdate",$data['comment_datestamp'])." | <a href='".BASEDIR."profile.php?lookup=".$data['comment_name']."' class='nick'>".$data['user_imie']." ".$data['user_nazwisko']."</a> skomentował <strong><a href='".BASEDIR.$typ."=".$data['comment_item_id']."' title='".$data['comment_message']."'>".$kom."</a>:</strong></span><br /><span style='color:#333333;'>";



echo trimlink(strip_tags(parseubb($data['comment_message'])),60);

echo"</span></td>";



}

echo "</tr></table>";

}

echo "<p align='right'><a href='".BASEDIR."comments.php'>Więcej...</a></p>";



closeside();