Sidste nyt! element
 Kodeopenside("Sidste nyt!");
$result = dbquery(
"SELECT l.type AS type, l.id AS id, l.title AS title, MAX(l.mdate) AS mdate, fusion_users.user_name AS name FROM ".
"( ".
"SELECT 'PA' AS type, fusion_photos.album_id AS id, ".
"fusion_photos.photo_datestamp AS mdate, fusion_photo_albums.album_title AS title, fusion_photos.photo_user AS user_id ".
"FROM fusion_photos ".
"LEFT JOIN fusion_photo_albums ON fusion_photos.album_id=fusion_photo_albums.album_id ".
"UNION ".
"SELECT 'A' AS type , article_id AS id, article_datestamp AS mdate, article_subject as title, article_name AS user_id ".
"FROM fusion_articles ".
"UNION ".
"SELECT CONCAT('C', comment_type) AS type, comment_item_id AS id, comment_datestamp AS mdate, comment_message AS title, comment_name AS user_id ".
"FROM fusion_comments ".
"WHERE comment_type='A' OR comment_type='P' ".
") AS l ".
"LEFT JOIN fusion_users ON fusion_users.user_id=l.user_id ".
"GROUP BY l.type, l.id, l.user_id ".
"ORDER BY mdate DESC LIMIT 0,10"
);
if (dbrows($result) != 0) {
while($data = dbarray($result))
{
$id = $data['id'];
$titlelong = $data['title'];
$titleshort = trimlink($titlelong, 25);
$name = $data['name'];
switch ($data['type'])
{
case 'PA':
$link="photogallery.php?album_id=".$id;
$titlelong="Nye billeder: ".$titlelong." fra ".$name;
break;
case 'A':
$link="readarticle.php?article_id=".$id;
$titlelong="Ny artikel: ".$titlelong." fra ".$name;
break;
case 'CA':
$link="readarticle.php?article_id=".$id;
$titlelong="Ny kommentar til artikel: ".trimlink($titlelong, 50)." fra ".$name;
break;
case 'P':
$link="photogallery.php?photo_id=".$id;
$titlelong="Nyt billede: ".$titlelong." fra ".$name;
break;
case 'CP':
$link="photogallery.php?photo_id=".$id;
$titlelong="Ny kommentar til billede: ".trimlink($titlelong, 50)." fra ".$name;
break;
default:
$link="";
break;
}
echo "<img src='".THEME."images/bullet.gif' alt=''> <a href='".BASEDIR.$link."' title='".$titlelong."' class='side'>$titleshort</a><br>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
|
Billede ind i profil
Danish
English
