панель последние фотки - PHP-Fusion SF Russian Support Site

<?php

/*---------------------------------------------------+

| PHP-Fusion 6 Content Management System

+----------------------------------------------------+

| Copyright © 2002 - 2005 Nick Jones

| http://www.php-fusion.co.uk/

+----------------------------------------------------+

| Released under the terms & conditions of v2 of the

| GNU General Public License. For details refer to

| the included gpl.txt file or visit http://gnu.org

+----------------------------------------------------*/

/* Created for PHP-FUSION 6.01.03 

last_images_panel v.1.1

Modified by Yuras http://pitomnik.com

*/



if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }



if (file_exists(INFUSIONS."latest_images_panel/locale/".$settings['locale'].".php")) {

	include INFUSIONS."latest_images_panel/locale/".$settings['locale'].".php";

} else {

	include INFUSIONS."latest_images_panel/locale/English.php";

}



openside($locale['lip000']);





$result=dbquery(

"SELECT ta.album_id,album_title,photo_id,photo_title,photo_thumb1 FROM ".DB_PREFIX."photo_albums ta ".

"JOIN ".DB_PREFIX."photos USING (album_id) ORDER BY photo_id DESC LIMIT 0,4"); // 4 - ограничение количества фоток



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

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

		$itemdescription = trimlink($data['photo_title'], 23); //обрезка длинных названий

		echo "<center><a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' title='".$data['photo_title']."'>

<img border='0' src='".BASEDIR."images/photoalbum/album_".$data['album_id']."/".$data['photo_thumb1']."' width='".$settings['thumb_w']."' 

title='".$data['photo_title']."' alt='".$data['photo_title']."'></a><br>

<b><a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."'>$itemdescription</a></b>

<br>".$locale['lip001'].": 

<a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."' class='gallery' title='".$locale['lip001'].": ".$data['album_title']."'>

".$data['album_title']."</a><br><br></center>\n";

	}

} else {

	echo $locale['004'];

}

closeside();

?>