Din Menu
Fra fotoalbummet...

Nyeste artikler
> Billede ind i profil
> Optimer tabler i dat...
> Total Commander
> Redirect en side
> Mods / Infusion op p...
Downloads
SE ALLE DOWNLOADS...
Nye downloads
SurrealExperience 17
Luxury Yachts 10
Glare in Dark 66
AS-AppStore 36
AS-Global 20
AS-yellow_star 24
Hitman Games Zone 19
AS-Football 23
AS-Christmas 40
JuleCountdown til c... 20
Top 5 downloads
buzzlightyear 2588
junglebook 2576
Disney2 2538
php-fusion-7-01-02 2505
Disney1 2449
mickey-pluto. 2437
Opgraderingspakke v... 2168
danish_locales_v7_1 2156
Themes-phpfusion.dk
Facebook
Facebook

Pernille

statistik
Screenshots DB
Total Images: 796
Latest Images









statistik
Fra fotoalbummet...

Connect via Facebook
Connect via Facebook
Select your language
Danish Language Danish   English Language English
Fødselsdage i Marts
03.03 Casper94 (30)
04.03 Hjorten (67)
09.03 morten (64)
10.03 zigozigo (58)
12.03 jcubbin (69)
12.03 J-cubbin (69)
22.03 vincentvega (53)
23.03 foxeri (44)
24.03 Yvonne (67)
27.03 bscargo (52)
27.03 mikkel-m (35)
29.03 dalgaard (51)
Tilfældig Billede
Udtalelser fra brugerne
"SUPER SIDE

Jeg undrer mig bare over at jeg ikke har stødt på den før...... Dumme mig."

Teamtwilight
Reklame
Antispam
Se indlæg
Hvem er her? 1 gæst(er)
 Udskriv debat
Sidste nyt! element
assensvej
Sidste nyt! element

Download kildekode  Kode
openside("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();


 
Spring til debat:
Lignende tråde
Debat Forum Svar Nyeste indlæg
2-i-et element i stedet for news.php på forsiden Kravlegården på Assensvej 8 28-05-2012 10:47
Hjælp til element igen :) Kravlegården på Assensvej 3 01-03-2012 12:12
Element til at annoncere/reklamere Kravlegården på Assensvej 42 08-02-2012 19:20
Element i venster side Kravlegården på Assensvej 4 24-01-2012 23:19
Seneste aktivitet element Tips og tricks,elementer mm v7 14 07-09-2011 23:09