Code: Alles auswählen
$sql = "SELECT pic_id, pic_title, pic_username, pic_time FROM phpbb_album WHERE pic_cat_id>0 ORDER BY pic_time DESC LIMIT 0,1"; 
und trotzdem es muss doch irgendwie möglich sein das bild da problemlos reinzubekommen Code: Alles auswählen
#
#-----[ ÖFFNE ]---------------------------------------------
#
portal.php
#
#-----[ FINDE ]----------------------------------------
#
// CHECK FOR ANONYMOUS USER START
#
#-----[ DAVOR EINFÜGEN ]-----------------------------------
#
//
// START GET NEWEST PIC ON AWSW PORTAL
//
$sql = "SELECT pic_id, pic_title, pic_username, pic_time FROM phpbb_album WHERE pic_cat_id>0 ORDER BY pic_time DESC LIMIT 0,1";
if (!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Could not query album information', '', __LINE__, __FILE__, $sql);
}
$picrow = $db->sql_fetchrow($result);
//
// END GET NEWEST PIC ON AWSW PORTAL
//
#
#-----[ FINDE ]----------------------------------------
#
'L_MARK_FORUMS_READ' => $lang['Mark_all_forums'],
#
#-----[ DAVOR EINFÜGEN ]-----------------------------------
#
// START PHOTO ALBUM ADDON FÜR AWSW
'L_NEWEST_PIC' => $lang['Newest_pic'],
'PIC_IMAGE' => append_sid('album_thumbnail.'. $phpEx . '?pic_id=' . $picrow['pic_id']),
'PIC_TITLE' => $picrow['pic_title'],
'PIC_POSTER' => $picrow['pic_username'],
'U_PIC_LINK' => append_sid('album_pic.' . $phpEx . '?pic_id=' . $picrow['pic_id']),
'PIC_TIME' => create_date($board_config['default_dateformat'], $picrow['pic_time'], $board_config['board_timezone']),
// END PHOTO ALBUM ADDON FÜR AWSW
#
#-----[ ÖFFNE ]---------------------------------------------
#
templates/subSilver/portal_body.tpl
#
# Dieser Block kann je nachdem ob linke, rechte, oder mittlere Spalte in die tpl-Datei eingesetzt werden.
#
<!-- ##### START PORTAL ALBUM NEUSTES FOTO ##### -->
<div align="center">
<table width="100%" cellspacing="1" border="0" class="forumline" style="border-collapse: collapse">
<tr>
<td class="catHeadportal_1"><span class="cattitle"><center><b>{L_NEWEST_PIC}:</b></center></span></td>
</tr>
<tr>
<td height="1" class="row3"><img src="images/spacer.gif" width="1" height="1" alt="."></td>
</tr>
<tr>
<td class="row1" width="100%">
<span class="gensmall" style="line-height:150%"><br /><center><a href="{U_PIC_LINK}"><img src="{PIC_IMAGE}" border="0" alt="{L_NEWEST_PIC}"></a><br /><br /></span>
</td>
</tr>
<tr>
<td class="row1" align="center">
<span class="gensmall" style="line-height:150%"><b>{PIC_TITLE}</b> von <b>{PIC_POSTER}
- </b>{PIC_TIME}</span>
</td>
</tr>
<tr>
<td class="row1" width="100%" align="center">
<span class="gensmall">[ <a href="{U_ALBUM}">{L_ALBUM}</a> ]</span>
<br>
</td>
</tr>
</table>
</div>
<!-- ##### ENDE PORTAL ALBUM NEUSTES FOTO ##### -->
#
#-----[ ÖFFNE ]---------------------------------------------
#
language/lang_german/lang_main.php
#
#-----[ FINDE ]----------------------------------------
#
$lang['Viewing_Portal'] = "Betrachtet das Portal";
#
#-----[ DANACH EINFÜGEN ]-----------------------------------
#
$lang['Newest_pic'] = 'Neustes Foto:';
#
#-----[ ÖFFNE ]---------------------------------------------
#
language/lang_english/lang_main.php
#
#-----[ FINDE ]----------------------------------------
#
$lang['Viewing_Portal'] = "Viewing the Portal";
#
#-----[ DANACH EINFÜGEN ]-----------------------------------
#
$lang['Newest_pic'] = 'Newest Pic'; // Album Addon
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoF
