phpBB.de

Code: Alles auswählen

<?php 
//Benötigte Dateien und Variablen von phpBB 
define('IN_PHPBB', true); 
$phpbb_root_path = './'; 
include($phpbb_root_path . 'extension.inc'); 
include($phpbb_root_path . 'common.'.$phpEx); 


//Session auslesen und Benutzer-Informationen laden 
$userdata = session_pagestart($user_ip, PAGE_INDEX); 
init_userprefs($userdata); 


//Dieser Block kann weggelassen werden, wenn du nur den die Userdaten brauchst und auf den phpBB-Header verzichen möchtest 
$page_title = ''; 
include($phpbb_root_path . 'includes/page_header.'.$phpEx); 

// Haupt Limit eingeben
$limit = 1;
$max_hoehe = 150;
$max_breit = 150;

// Sammle Haupt Informationen für das Bild
$sql = "SELECT * FROM `phpbb_attachments_desc` WHERE `extension` = 'jpg' OR `extension` = 'jpeg' OR `extension` = 'png' ORDER BY `attach_id` DESC LIMIT $limit";
if(!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not query last attachement', '', __LINE__, __FILE__, $sql);
}
while($attach_data = $db->sql_fetchrow($result)) {

//Sammle Informationen für die post_id
$sql = "SELECT * FROM `phpbb_attachments` WHERE `attach_id` = '".$attach_data['attach_id']."' LIMIT 1";
if(!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not query general attachement data', '', __LINE__, __FILE__, $sql);
}
$attach_general = $db->sql_fetchrow($result);

$post_id = $attach_general['post_id'];
$filename = $phpbb_root_path.'files/'.$attach_data['physical_filename'];
$filetime = $attach_data['filetime'];
$filetime = date('d.m.Y H:i', $filetime);

// Lade Username und User Id aus der Datenbank
$sql = "SELECT `username`, `user_id` FROM `".USERS_TABLE."` WHERE `user_id` = '".$attach_general['user_id_1']."' LIMIT 1";
if(!($result = $db->sql_query($sql)))
{
message_die(GENERAL_ERROR, 'Could not query userdata', '', __LINE__, __FILE__, $sql);
}
$attach_user = $db->sql_fetchrow($result);

// Ermitteln von Daten für kleineres Bild
       $size = getimagesize($filename); 
       $height = $size[1]; 
       $width = $size[0]; 
     if ($height > $max_hoehe) 
         { 
               $height = 150; 
               $percent = ($size[1] / $height); 
               $width = ($size[0] / $percent); 
         } 
     else if ($width > $max_breite) 
         { 
               $width = 150; 
               $percent = ($size[0] / $width); 
               $height = ($size[1] / $percent); 
         }

// Ausgeben
$post_link = append_sid($phpbb_root_path.'viewtopic.'.$phpEx.'?p='.$post_id.'#'.$post_id);
$user_link = append_sid($phpbb_root_path.'profile.'.$phpEx.'?mode=viewprofile&u='.$attach_user['user_id']);
echo '<a href="'.$post_link.'"><img src="'.$filename.'" border="0" width="'.$width.'" height="'.$height.'" /></a><br />';
echo 'Von <a href="'.$user_link.'">'.$attach_user['username'].'</a>';

} // Ende der While Schleife

//Footer - nur dann weglassen, wenn du auch den Header weglässt 
include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 
?>

Code: Alles auswählen

$limit = 1;
$max_hoehe = 150;
$max_breit = 150;