phpBB.de

Code: Alles auswählen

while ( $row = $db->sql_fetchrow($result) )
{
  if (!@eval('$nav_name = ' . $row['nav_name'] . ';'))
  {
    $nav_name = $row['nav_name'];
  }
  $template->assign_block_vars("topicrownav", array(
    'nav_link' => $row['nav_link'],
    'nav_name' => $nav_name)
  );
}

Code: Alles auswählen

                'IntroPortaltext26' => $lang['IntroPortaltext26'],

Code: Alles auswählen

                'IntroPortaltext27' => $lang['IntroPortaltext27'],

Code: Alles auswählen

// MAIN PART AND FOOTER START

Code: Alles auswählen

// RECENT ALBUM PIC FOR SMARTORS ALBUM MOD
// MOST CODE PARTS BORROWED FROM SMARTORS ALBUM MOD

// change this according to your Album MOd installation. In doubt, look in album.php ;-)
$album_root_path = $phpbb_root_path . 'album_mod/';
include($album_root_path . 'album_common.'.$phpEx);

// get cat list so we can see which ones are viewable be the user

$allowed_cat = '1,3,4';
// uncomment this if you want to have this done automatically and comment out the above line
/* $sql = "SELECT cat_id AS cat_id
                FROM ". ALBUM_CAT_TABLE ." AS c
                WHERE cat_id <> 0";

if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}

$catrows = array();

$allowed_cat = ''; // For Recent Public Pics below

while( $row = $db->sql_fetchrow($result) )
{
        $album_user_access = album_user_access($row['cat_id'], $row, 1, 0, 0, 0, 0, 0); // VIEW
        if ($album_user_access['view'] == 1)
        {
                $allowed_cat .= ($allowed_cat == '') ? $row['cat_id'] : ',' . $row['cat_id'];
        }
} */

// get the latest picture. To get more than just one, change LIMIT 1 and edit your template
$sql = "SELECT p.pic_id as pid, p.pic_title as pt, p.pic_desc as pd
        FROM ". ALBUM_TABLE ." AS p
        LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
        WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )
        ORDER BY pic_time DESC
        LIMIT 1";

if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query recent picture list'.$allowed_cat, '', __LINE__, __FILE__, $sql);
}

$row = $db->sql_fetchrow($result);

// finally, the pic's ID
$latest_pic_id = $row['pid'];

$template->assign_block_vars("recent_picture", array(
        'U_PIC' => append_sid("album_page.$phpEx?pic_id=" . $latest_pic_id),
        'TITLE' => $row['pt'],
        'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=" . $latest_pic_id),
        'DESC' => $row['pd'])
);

$template->assign_block_vars('switch_album_active', array());
// RECENT ALBUM PIC END

Code: Alles auswählen

<!-- ##### RECENT PICTURE START ##### -->
<!-- BEGIN switch_album_active -->
<table width="100%" border="0" cellpadding="1" cellspacing="1" style="border-collapse: collapse" class="forumline">
  <tr>
        <td class="cat" height="25"><span class="cattitle"><center><b>{IntroPortaltext27}:</b></center></span></td>
  </tr>
  <tr>
       <td height="1" class="row3"><img src="images/spacer.gif" width="1" height="1" alt="."></td>
  </tr>
<!-- END switch_album_active -->
<!-- BEGIN recent_picture -->
  <tr>
      <td align="center" nowrap="nowrap" class="row2">
        <span class="genmed"><b>{recent_picture.TITLE}</b><br />
        <a href="{recent_picture.U_PIC}"><img src="{recent_picture.THUMBNAIL}" /></a><br />
        {recent_picture.DESC}</span>
      </td>
  </tr>
<!-- END recent_picture -->
<!-- BEGIN switch_album_active -->
</table>
<br />
<!-- END switch_album_active -->
<!-- ##### RECENT PICTURE END ##### -->

Code: Alles auswählen

$lang['IntroPortaltext26'] = 'Heise - Newsticker';

Code: Alles auswählen

$lang['IntroPortaltext27'] = 'Das neueste Bild';