phpBB.de

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"; 

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>
&nbsp;</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