Recent Links on ezPortal

[SethDeBlade]

ich habe vorhin den Links-Mod und das von dir geschriebene "Add-on" eingebaut. funktioniert soweit alles super, aber gibt es vielleicht die möglichkeit dieses

Code: Alles auswählen

onMouseOver="document.all.recent_links.stop()"

auch für mozilla & co zum laufen zu bringen?? scheinbar interessiert mozilla dieser stopbefehl nicht im geringsten

[oxpus]

Ersetze das mal mit

Code: Alles auswählen

onMouseOver="stop()" onMouseOut="start()"

[SethDeBlade]

hat leider nicht geholfen

[oxpus]

Poste mal den Abschnitt der portal_body.tpl. Ich glaube, ich habe das woanders eingesetzt.

[SethDeBlade]

hier mein abschnitt aus der portal.php

Code: Alles auswählen

//
// Recent Links
//
$sql = "SELECT l.link_url, l.link_title, l.link_logo_src, l.link_desc, l.link_id, lc.cat_title, lc.cat_id, u.username, u.user_id
                FROM " . LINKS_TABLE . " l, " . LINK_CATEGORIES_TABLE . " lc, " . USERS_TABLE . " u
                WHERE l.link_active = 1
                AND l.link_category = lc.cat_id
                AND l.user_id = u.user_id
                ORDER BY l.link_joined DESC
                LIMIT 0,".$board_config['recent_links'];
if (!$result = $db->sql_query($sql))
{
        message_die(GENERAL_ERROR, 'Could not query links information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
        $template->assign_block_vars('recent_links', array(
              'LINK_URL' => '<a href="'.append_sid("links.$phpEx?action=go&link_id=" . $row['link_id']).'" target="_blank" onMouseOver="stop()" onMouseOut="start()"><img src="'.$row['link_logo_src'].'" border="0"></a>',
              'LINK_CAT' => '<a href="'.append_sid("links.$phpEx?t=sub_pages&cat=" . $row['cat_id']).'" onMouseOver="stop()" onMouseOut="start()"><i>'.$row['cat_title'].'</i></a>',
              'LINK_DESC' => $row['link_desc'])
//              'LINK_AUTHOR' => '<a href="'.append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $row['user_id']).'" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()">'.$row['username'].'</a>')
        );
}
$template->assign_vars(array(
        'L_RECENT_LINKS' => $lang['Recent_links'])
);

und der in der portal_body.tpl

Code: Alles auswählen

                  <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
                   <tr>
                        <td class="row2" height="25" align="center"><span class="genmed"><b>{L_RECENT_LINKS}</b></span></td>
                   </tr>
                   <tr>
                        <td class="row1"><span class="gensmall">
                        <marquee id="recent_links" behavior="scroll" direction="up" height="100" scrolldelay="75" scrollamount="2">
                  <!-- BEGIN recent_links -->
                        <center>{recent_links.LINK_URL}
                        <!-- <br />{recent_links.LINK_CAT} --><br />{recent_links.LINK_DESC}<br /><br /></center>
                  <!-- END recent_links -->
                        </marquee></span></td>
                   </tr>
                  </table>

[oxpus]

Hier mal funktionierend zurück (so habe ich es jedenfalls hier auf oxpus.de):
portal.php:

Code: Alles auswählen

//
// Recent Links
//
$SQL = "SELECT l.link_url, l.link_title, l.link_logo_src, l.link_desc, l.link_id, lc.cat_title, lc.cat_id, u.username, u.user_id
        FROM " . LINKS_TABLE . " l, " . LINK_CATEGORIES_TABLE . " lc, " . USERS_TABLE . " u
        WHERE l.link_active = 1
        AND l.link_category = lc.cat_id
        AND l.user_id = u.user_id
        ORDER BY l.link_joined DESC
        LIMIT 0,".$board_config['recent_links'];
if (!$result = $db->sql_query($SQL))
{
    message_die(GENERAL_ERROR, 'Could not query links information', '', __LINE__, __FILE__, $SQL);
}
while( $row = $db->sql_fetchrow($result) )
{
    $template->assign_block_vars('recent_links', array(
       'LINK_URL' => '<a href="'.append_sid("links.$phpEx?action=go&link_id=" . $row['link_id']).'" target="_blank"><img src="'.$row['link_logo_src'].'" border="0"></a>',
       'LINK_CAT' => '<a href="'.append_sid("links.$phpEx?t=sub_pages&cat=" . $row['cat_id']).'"><i>'.$row['cat_title'].'</i></a>',
       'LINK_DESC' => $row['link_desc'])
//       'LINK_AUTHOR' => '<a href="'.append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $row['user_id']).'" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()">'.$row['username'].'</a>')
    );
}
$template->assign_vars(array(
    'L_RECENT_LINKS' => $lang['Recent_links'])
);

portal_body.tpl

Code: Alles auswählen

         <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
          <tr>
            <td class="row2" height="25" align="center"><span class="genmed"><b>{L_RECENT_LINKS}</b></span></td>
          </tr>
          <tr>
            <td class="row1"><span class="gensmall">
            <marquee id="recent_links" behavior="scroll" direction="up" height="100" scrolldelay="75" scrollamount="2"  onMouseOver="stop()" onMouseOut="start()">
         <!-- BEGIN recent_links -->
            <center>{recent_links.LINK_URL}
            <!-- <br />{recent_links.LINK_CAT} --><br />{recent_links.LINK_DESC}<br /><br /></center>
         <!-- END recent_links -->
            </marquee></span></td>
          </tr>
         </table>

[SethDeBlade]

nu gehts, danke. direkt mal bei den recent topics auch nachrüsten

[darakhshan]

Hi, I have a big problem with german language, please help me from Korea
I installed the recent links on ezportal, but all I get is BLANK block
dp update was OK, modification seemed to be ok I think there must be something wrong with my Portal configuration , Please it is christmas and I do not want to have headache please help

I send my portal.php for your reference

Code: Alles auswählen

<?php
/***************************************************************************
 *                                portal.php
 *                            -------------------
 *   begin                : Tuesday, August 13, 2002
 *   copyright            : (C) 2002 Smartor
 *   email                : smartor_xp@hotmail.com
 *
 *   $Id: portal.php,v 2.1.7 2003/01/30, 17:05:58 Smartor Exp $
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   Some code in this file I borrowed from the original index.php, Welcome
 *   Avatar MOD and others...
 *
 ***************************************************************************/

//
// Set configuration for ezPortal
//

// Welcome Text: note that we are in PHP file, so use \' instead of ' and use \\ instead of \ (HTML enabled)
$CFG['welcome_text'] = 'به انجمن اطلاعات فرهنگي ايرانيان مقيم كره <b>خوش آمديد> <BR>
تلفن 2799-406-031<BR>>

ساعات خوبي را داشته باشيد! ^_^';

// Number of news on portal
$CFG['number_of_news'] = '5';

// Length of news
$CFG['news_length'] = '100';

// News Forum ID: separate by comma for multi-forums, eg. '1,2,5'
$CFG['news_forum'] = '24';

// Poll Forum ID: separate by comma for multi-forums, eg. '3,8,14'
$CFG['poll_forum'] = '1,13,19,20';

// Start add  - Photo Album Block
// Pics Cat ID: no multi-categories support
$CFG['cat_id'] = '8';

// Number of pics on portal
$CFG['pics_number'] = '4';

// Pics viewing all: replace '0' with '1' to display both public & personal pics
$CFG['pics_all'] = '0';

// Pics randomization: replace '0' with '1' for random
$CFG['pics_sort'] = '1';
// End add  - Photo Album Block


// Number of Recent Topics (not Forum ID)
$CFG['number_recent_topics'] = '20';

// Exceptional Forums for Recent Topics, eg. '2,4,10' (note: my Recent Topics script has its own permission checking, so you can leave this variable blank)
$CFG['exceptional_forums'] = '61';

//
// END configuration
// --------------------------------------------------------

define('IN_PHPBB', true);
$phpbb_root_path = './';
$album_root_path = $phpbb_root_path . 'album_mod/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'fetchposts.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
// Start add  - Photo Album Block
include($album_root_path . 'album_common.'.$phpEx);
// End add  - Photo Album Block
//
// If you don't use these stats on your index you may want to consider
// removing them
//
$total_posts = get_db_stat('postcount');
$total_users = get_db_stat('usercount');
$total_topics = get_db_stat('topiccount');
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];

if( $total_posts == 0 )
{
   $l_total_post_s = $lang['Posted_articles_zero_total'];
}
else if( $total_posts == 1 )
{
   $l_total_post_s = $lang['Posted_article_total'];
}
else
{
   $l_total_post_s = $lang['Posted_articles_total'];
}

if( $total_users == 0 )
{
   $l_total_user_s = $lang['Registered_users_zero_total'];
}
else if( $total_users == 1 )
{
   $l_total_user_s = $lang['Registered_user_total'];
}
else
{
   $l_total_user_s = $lang['Registered_users_total'];
}

//

// Recent Topics

//


$sql = "SELECT * FROM ". FORUMS_TABLE . " ORDER BY forum_id";
if (!$result = $db->sql_query($sql))
{
   message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
}
$forum_data = array();
while( $row = $db->sql_fetchrow($result) )
{
   $forum_data[] = $row;
}
$is_auth_ary = array();
$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);
if( $CFG['exceptional_forums'] == '' )
{
   $except_forum_id = '\'start\'';
}
else
{
   $except_forum_id = $CFG['exceptional_forums'];
}
for ($i = 0; $i < count($forum_data); $i++)
{
   if ((!$is_auth_ary[$forum_data[$i]['forum_id']]['auth_read']) or (!$is_auth_ary[$forum_data[$i]['forum_id']]['auth_view']))
   {
      if ($except_forum_id == '\'start\'')
      {
         $except_forum_id = $forum_data[$i]['forum_id'];
 
      }
      else
      {
         $except_forum_id .= ',' . $forum_data[$i]['forum_id'];
 
      }
   }
}
$sql = "SELECT  f.forum_name, f.forum_id, t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
      FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u,  " . FORUMS_TABLE . " AS f
      WHERE t.forum_id NOT IN (" . $except_forum_id . ")
         AND t.topic_status <> 2
         AND p.post_id = t.topic_last_post_id
         AND p.poster_id = u.user_id
         AND f.forum_id = t.forum_id
      ORDER BY p.post_id DESC
      LIMIT " . $CFG['number_recent_topics'];
if (!$result = $db->sql_query($sql))
{
   message_die(GENERAL_ERROR, 'Could not query recent topics information', '', __LINE__, __FILE__, $sql);
}
$number_recent_topics = $db->sql_numrows($result);
$recent_topic_row = array();
while ($row = $db->sql_fetchrow($result))
{
   $recent_topic_row[] = $row;
}
for ($i = 0; $i < $number_recent_topics; $i++)
{
   $template->assign_block_vars('recent_topic_row', array(
      'L_FORUMNAME' => $recent_topic_row[$i]['forum_name'],
      'U_FORUMNAME' => append_sid("viewforum.$phpEx?"."f=".$recent_topic_row[$i]['forum_id']),
      'U_TITLE' => append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topic_row[$i]['post_id']) . '#' .$recent_topic_row[$i]['post_id'],
      'L_TITLE' => $recent_topic_row[$i]['topic_title'],
      'U_POSTER' => append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $recent_topic_row[$i]['user_id']),
      'S_POSTER' => $recent_topic_row[$i]['username'],
      'S_POSTTIME' => create_date($board_config['default_dateformat'], $recent_topic_row[$i]['post_time'], $board_config['board_timezone'])
      )
   );
}

//

// END - Recent Topics

//


if( $userdata['session_logged_in'] )
{
   $sql = "SELECT COUNT(post_id) as total
         FROM " . POSTS_TABLE . "
         WHERE post_time >= " . $userdata['user_lastvisit'];
   $result = $db->sql_query($sql);
   if( $result )
   {
      $row = $db->sql_fetchrow($result);
      $lang['Search_new'] = $lang['Search_new'] . "&nbsp;(" . $row['total'] . ")";
   }
}

//
// BEGIN Music Statistics
//

// Get Categories Info
$sql = "SELECT c.cat_id, c.cat_title, c.cat_order
         FROM " . MUSIC_CAT_TABLE . " c
         ORDER BY c.cat_order";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query cats information', '', __LINE__, __FILE__, $sql);
}
$catrow = array();
while( $row = $db->sql_fetchrow($result) )
{
   $catrow[] = $row;
}
$total_cats = count($catrow);

// Get Songs Info
$sql = "SELECT s.song_id, s.song_title, s.song_user_id, s.song_username, s.song_time
         FROM " . MUSIC_TABLE . " s
         ORDER BY s.song_time DESC";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query songs information', '', __LINE__, __FILE__, $sql);
}
$songrow = array();
while( $row = $db->sql_fetchrow($result) )
{
   $songrow[] = $row;
}
$total_songs = count($songrow);

// Get Last Song Info
$sql = "SELECT song_id, song_title, song_user_id, song_username, song_time
         FROM phpbb_music
         ORDER BY song_time DESC
         LIMIT 0,1";
if (!$result = $db->sql_query($sql))
   {
   message_die(GENERAL_ERROR, 'Could not query last song information', '', __LINE__, __FILE__, $sql);
   }
$lastsong = $db->sql_fetchrow($result);

//
// END Music Statistics
//
//
// Start output of page
//
define('SHOW_ONLINE', true);
$page_title = $lang['Home'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
   'body' => 'portal_body.tpl')
);

//
// Avatar On Index MOD
//
$avatar_img = '';
if ( $userdata['user_avatar_type'] && $userdata['user_allowavatar'] )
{
   switch( $userdata['user_avatar_type'] )
   {
      case USER_AVATAR_UPLOAD:
         $avatar_img = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $userdata['user_avatar'] . '" alt="" border="0" />' : '';
         break;
      case USER_AVATAR_REMOTE:
         $avatar_img = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $userdata['user_avatar'] . '" alt="" border="0" />' : '';
         break;
      case USER_AVATAR_GALLERY:
         $avatar_img = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $userdata['user_avatar'] . '" alt="" border="0" />' : '';
         break;
   }
}
// Check For Anonymous User
if ($userdata['user_id'] != '-1')
{
   $name_link = '<a href="' . append_sid("profile.$phpEx?mode=editprofile&amp;" . $userdata['user_id']) . '">' . $userdata['username'] . '</a>';
   $profile_id = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&u=" . $userdata['user_id']) . '" class="gensmall">' . $lang['view_profile'] . '</a><br />';
}
else
{
   $name_link = $lang['Guest'];
   $profile_id = '';
}
//
// END: Avatar On Index MOD
//
// Start add  - Photo Album Block
// Build Categories Index
$sql = "SELECT c.*, COUNT(p.pic_id) AS count
      FROM ". ALBUM_CAT_TABLE ." AS c
         LEFT JOIN ". ALBUM_TABLE ." AS p ON c.cat_id = p.pic_cat_id
      WHERE cat_id <> 0
      GROUP BY cat_id
      ORDER BY cat_order ASC";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$catrows = array();

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)
   {
      $catrows[] = $row;
   }
}
if ( $CFG['pics_all'] == '1' )
{
   $allowed_cat = '0'; // For Recent Public Pics below
}
else
{
   $allowed_cat = '';
}

//
// $catrows now stores all categories which this user can view. Dump them out!
//
for ($i = 0; $i < count($catrows); $i++)
{
   // Build allowed category-list (for recent pics after here)
   $allowed_cat .= ($allowed_cat == '') ? $catrows[$i]['cat_id'] : ',' . $catrows[$i]['cat_id'];

   // Get Last Pic of this Category
   if ($catrows[$i]['count'] == 0)
   {
      // Category is empty
      $last_pic_info = $lang['No_Pics'];
      $u_last_pic = '';
      $last_pic_title = '';
   }
   else
   {
      // Check Pic Approval
      if ( ($catrows[$i]['cat_approval'] == ALBUM_ADMIN) or ($catrows[$i]['cat_approval'] == ALBUM_MOD) )
      {
         $pic_approval_sql = 'AND p.pic_approval = 1'; // Pic Approval ON
      }
      else
      {
         $pic_approval_sql = ''; // Pic Approval OFF
      }
   }
   // END of Last Pic
}

// Recent Public Pics
if ( $CFG['pics_all'] == '1' )
{
   $pics_allowed = '0';
}
else
{
   $pics_allowed = '';
}

if ( $allowed_cat != $pics_allowed )
{
   $CategoryID = $CFG['cat_id'];

   if ( $CFG['pics_sort'] == '1' )
   {
      if ( $CategoryID != 0 )
      {
         $sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
            FROM ". ALBUM_TABLE ." AS p
               LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
               LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
               LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
               LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
            WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) AND pic_cat_id = ($CategoryID)
            GROUP BY p.pic_id
            ORDER BY RAND()
            LIMIT ". $CFG['pics_number'];
      }
      else
      {
         $sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
            FROM ". ALBUM_TABLE ." AS p
               LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
               LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
               LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
               LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
            WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )
            GROUP BY p.pic_id
            ORDER BY RAND()
            LIMIT ". $CFG['pics_number'];
         }
   }
   else if ( $CFG['pics_sort'] == '0' )
   {
      if ( $CategoryID != 0 )
      {
         $sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
            FROM ". ALBUM_TABLE ." AS p
               LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
               LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
               LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
               LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
            WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 ) AND pic_cat_id = ($CategoryID)
            GROUP BY p.pic_id
            ORDER BY pic_time DESC
            LIMIT ". $CFG['pics_number'];
      }
      else
      {
         $sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
            FROM ". ALBUM_TABLE ." AS p
               LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
               LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
               LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
               LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
            WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )
            GROUP BY p.pic_id
            ORDER BY pic_time DESC
            LIMIT ". $CFG['pics_number'];
      }
   }
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not query recent pics information', '', __LINE__, __FILE__, $sql);
   }
   $recentrow = array();

   while( $row = $db->sql_fetchrow($result) )
   {
      $recentrow[] = $row;
   }

   if (count($recentrow) > 0)
   {
      for ($i = 0; $i < count($recentrow); $i += $album_config['cols_per_page'])
      {
         $template->assign_block_vars('recent_pics', array());

         for ($j = $i; $j < ($i + $album_config['cols_per_page']); $j++)
         {
            if ( $j >= count($recentrow) )
            {
               break;
            }

            if (!$recentrow[$j]['rating'])
            {
               $recentrow[$j]['rating'] = $lang['Not_rated'];
            }
            else
            {
               $recentrow[$j]['rating'] = round($recentrow[$j]['rating'], 2);
            }

            // Display pics horizontally
            $template->assign_block_vars('recent_pics.recent_col', array(
               'U_PIC' => ($album_config['fullpic_popup']) ? append_sid("album_pic.$phpEx?pic_id=". $recentrow[$j]['pic_id']) : append_sid("album_page.$phpEx?pic_id=". $recentrow[$j]['pic_id']),
               'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=". $recentrow[$j]['pic_id']),
               'DESC' => $recentrow[$j]['pic_desc'])
            );

            if( ($recentrow[$j]['user_id'] == ALBUM_GUEST) or ($recentrow[$j]['username'] == '') )
            {
               $recent_poster = ($recentrow[$j]['pic_username'] == '') ? $lang['Guest'] : $recentrow[$j]['pic_username'];
            }
            else
            {
               $recent_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $recentrow[$j]['user_id']) .'">'. $recentrow[$j]['username'] .'</a>';
            }

            // Display pics vertically
            $template->assign_block_vars('recent_pics.recent_detail', array(
               'U_PIC' => ($album_config['fullpic_popup']) ? append_sid("album_pic.$phpEx?pic_id=". $recentrow[$j]['pic_id']) : append_sid("album_page.$phpEx?pic_id=". $recentrow[$j]['pic_id']),
               'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=". $recentrow[$j]['pic_id']),
               'DESC' => $recentrow[$j]['pic_desc'],
               'TITLE' => $recentrow[$j]['pic_title'],
               'POSTER' => $recent_poster,
               'TIME' => create_date($board_config['default_dateformat'], $recentrow[$j]['pic_time'], $board_config['board_timezone']),
               'VIEW' => $recentrow[$j]['pic_view_count'],
               'RATING' => ($album_config['rate'] == 1) ? ( '<a href="'. append_sid("album_rate.$phpEx?pic_id=". $recentrow[$j]['pic_id']) . '">' . $lang['Rating'] . '</a>: ' . $recentrow[$j]['rating'] . '<br />') : '',
               'COMMENTS' => ($album_config['comment'] == 1) ? ( '<a href="'. append_sid("album_comment.$phpEx?pic_id=". $recentrow[$j]['pic_id']) . '">' . $lang['Comments'] . '</a>: ' . $recentrow[$j]['comments'] . '<br />') : '')
            );
         }
      }
   }
   else
   {
      // No Pics Found
      $template->assign_block_vars('no_pics', array());
   }
}
else
{
   // No Cats Found
   $template->assign_block_vars('no_pics', array());
}
// End add  - Photo Album Block
//
//start top poster
//

$total_poster = '10'; // total of top poster
$avatar_height = '45'; // the avatar's height

$sql = "SELECT username, user_id,  user_posts,  user_avatar, user_avatar_type, user_allowavatar
        FROM " . USERS_TABLE . "
        WHERE user_id <> " . ANONYMOUS . "
        ORDER BY user_posts DESC LIMIT $total_poster";
if( !($result = $db->sql_query($sql)) )
{
        message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

if ( $row = $db->sql_fetchrow($result) )
{
        $i = 0;
        do
        {
                $username = $row['username'];
                $user_id = $row['user_id'];
                $posts = ( $row['user_posts'] ) ? $row['user_posts'] : 0;
                $poster_avatar = '';
                if ( $row['user_avatar_type'] && $user_id != ANONYMOUS && $row['user_allowavatar'] )
                {
                        switch( $row['user_avatar_type'] )
                        {
                                case USER_AVATAR_UPLOAD:
                                        $poster_avatar = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" height="' . $avatar_height . '" />' : '';
                                        break;
                                case USER_AVATAR_REMOTE:
                                        $poster_avatar = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $row['user_avatar'] . '" alt="" border="0" height="' . $avatar_height . '" />' : '';
                                        break;
                                case USER_AVATAR_GALLERY:
                                        $poster_avatar = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $row['user_avatar'] . '" alt="" border="0" height="' . $avatar_height . '" />' : '';
                                        break;
                        }
                }



                $template->assign_block_vars('topposter', array(

                        'USERNAME' => $username,
                        'POSTS' => $posts,
                        'AVATAR_IMG' => $poster_avatar,

                        'U_VIEWPOSTER' => append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$user_id"))
                );

                $i++;
        }
        while ( $row = $db->sql_fetchrow($result) );
}

//
//end top poster
//
$template->assign_vars(array(
   'WELCOME_TEXT' => $CFG['welcome_text'],
   'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),
   'TOTAL_USERS' => sprintf($l_total_user_s, $total_users),
   'TOTAL_TOPICS' => sprintf($lang['total_topics'], $total_topics),
   'NEWEST_USER' => sprintf($lang['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$newest_uid") . '">', $newest_user, '</a>'),
   'L_FORUM' => $lang['Forum'],
   'L_BOARD_NAVIGATION' => $lang['Board_navigation'],
   'L_STATISTICS' => $lang['Statistics'],   
   'L_ANNOUNCEMENT' => $lang['Post_Announcement'],
   'L_POSTED' => $lang['Posted'],
   'L_COMMENTS' => $lang['Comments'],
   'L_VIEW_COMMENTS' => $lang['View_comments'],
   'L_POST_COMMENT' => $lang['Post_your_comment'],
   'L_SEND_PASSWORD' => $lang['Forgotten_password'],
   'U_SEND_PASSWORD' => append_sid("profile.$phpEx?mode=sendpassword"),
   'L_REGISTER_NEW_ACCOUNT' => sprintf($lang['Register_new_account'], '<a href="' . append_sid("profile.$phpEx?mode=register") . '">', '</a>'),
   'L_REMEMBER_ME' => $lang['Remember_me'],
   'L_VIEW_COMPLETE_LIST' => $lang['View_complete_list'],
   'L_POLL' => $lang['Poll'],
   'L_VOTE_BUTTON' => $lang['Vote'],
   // Top Poster
   'L_TOP_POSTER' => $lang['Top_poster'],
   // View Profile
   'PROFILE_ID' => $profile_id,
   // Music Statistics
   'L_MUSIC_STATISTICS' => $lang['Music_Statistics'],
   'L_NEWEST_SONG' => $lang['Newest_song'],
   'U_SONG' => '<a href="'. append_sid('music_page.'. $phpEx . '?song_id=' . $lastsong['song_id']) . '">' . $lastsong['song_title'] . '</a>',
   'SONG_POSTER' => '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $lastsong['song_user_id']) .'">'. $lastsong['song_username'] .'</a>',
   'SONG_TIME' => create_date($board_config['default_dateformat'], $lastsong['song_time'], $board_config['board_timezone']),
   'TOTAL_SONGS' => sprintf($lang['Posted_songs_total'], $total_songs),
   'TOTAL_CATS' => sprintf($lang['Cats_total'], $total_cats),
// Start add - Photo Album Block
   'S_COLS' => $album_config['cols_per_page'],
   'S_COL_WIDTH' => (100/$album_config['cols_per_page']) . '%',
   'TARGET_BLANK' => ($album_config['fullpic_popup']) ? 'target="_blank"' : '',
   'L_NEWEST_PICS' => $lang['Newest_pics'],
   'L_NO_PICS' => $lang['No_Pics'],
   'L_PIC_TITLE' => $lang['Pic_Title'],
   'L_VIEW' => $lang['View'],
   'L_POSTER' => $lang['Poster'],
   'L_POSTED' => $lang['Posted'],
   // End add - Photo Album Block
// Recent Topics
   'L_RECENT_TOPICS' => $lang['Recent_topics'],
     'L_STAFFHEADER' => $lang['staffblockheader'],
   // Welcome Avatar
   'L_NAME_WELCOME' => $lang['Welcome'],
   'U_NAME_LINK' => $name_link,
   'AVATAR_IMG' => $avatar_img)
);

//
// Fetch Posts from Announcements Forum
//
if(!isset($HTTP_GET_VARS['article']))
{
   $template->assign_block_vars('welcome_text', array());

   $fetchposts = phpbb_fetch_posts($CFG['news_forum'], $CFG['number_of_news'], $CFG['news_length']);

   for ($i = 0; $i < count($fetchposts); $i++)
   {
      if( $fetchposts[$i]['striped'] == 1 )
      {
         $open_bracket = '[ ';
         $close_bracket = ' ]';
         $read_full = $lang['Read_Full'];
      }
      else
      {
         $open_bracket = '';
         $close_bracket = '';
         $read_full = '';
      }

      $template->assign_block_vars('fetchpost_row', array(
         'TITLE' => $fetchposts[$i]['topic_title'],
         'POSTER' => $fetchposts[$i]['username'],
         'TIME' => $fetchposts[$i]['topic_time'],
         'TEXT' => $fetchposts[$i]['post_text'],
         'REPLIES' => $fetchposts[$i]['topic_replies'],
         'U_VIEW_COMMENTS' => append_sid('viewtopic.' . $phpEx . '?t=' . $fetchposts[$i]['topic_id']),
         'U_POST_COMMENT' => append_sid('posting.' . $phpEx . '?mode=reply&amp;t=' . $fetchposts[$i]['topic_id']),
         'U_READ_FULL' => append_sid('portal.' . $phpEx . '?article=' . $i),
         'L_READ_FULL' => $read_full,
         'OPEN' => $open_bracket,
         'CLOSE' => $close_bracket)
      );
   }
}
else
{
   $fetchposts = phpbb_fetch_posts($CFG['news_forum'], $CFG['number_of_news'], 0);

   $i = intval($HTTP_GET_VARS['article']);

   $template->assign_block_vars('fetchpost_row', array(
      'TITLE' => $fetchposts[$i]['topic_title'],
      'POSTER' => $fetchposts[$i]['username'],
      'TIME' => $fetchposts[$i]['topic_time'],
      'TEXT' => $fetchposts[$i]['post_text'],
      'REPLIES' => $fetchposts[$i]['topic_replies'],
      'U_VIEW_COMMENTS' => append_sid('viewtopic.' . $phpEx . '?t=' . $fetchposts[$i]['topic_id']),
      'U_POST_COMMENT' => append_sid('posting.' . $phpEx . '?mode=reply&amp;t=' . $fetchposts[$i]['topic_id'])
      )
   );
}
//
// END: Fetch Announcements
//
//
// BEGIN: Fetch Recent album comments
//

$template->assign_block_vars('recent_comment', array());   

   $sql = "SELECT *
         FROM `phpbb_album_comment`
         ORDER BY `comment_id` DESC LIMIT 5";
         
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, "Could not obtain information needed.", "", __LINE__, __FILE__, $sql);
   }

   while( $row = $db->sql_fetchrow($result) )
   {
         $recent_comment .= '
         <a href="album_comment.php?comment_id=' . $row['comment_id'] .'">'. $row['comment_text'] . '</a><hr>
         
      ';               
   }
   
   $template->assign_vars(array(
         'RECENT_COMMENT_NAME' => $lang['Recently Submited Comments'],
         'RECENT_COMMENT' => $recent_comment
   ));
   
//
// END: Fetch Recent album comments
//
$level_staff = $lang['Staff_level'];
for( $x = 0; $x < count($level_staff); $x++ )
{
   $user_level = $level_staff[$x];

   if( $level_staff['0'] )
   {
      $where = 'user_level = '. ADMIN;
   }
   else if( $level_staff['1'] )
   {
      $where = 'user_level = '. MOD;
   }
   $level_staff[$x] = '';

   $sql_user = "SELECT * FROM ". USERS_TABLE ." WHERE $where";
   if( !($result_user = $db->sql_query($sql_user)) )
   {
      message_die(GENERAL_ERROR, 'Could not obtain user information.', '', __LINE__, __FILE__, $sql_user);
   }
   if( $staff = $db->sql_fetchrow($result_user) )
   {
      $k = 0;
      do
      {
         $row_class = ( !($k % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
         $user_id = $staff['user_id'];

         $template->assign_block_vars('staff_block', array(
            'ROW_CLASS' => $row_class,
            'STAFFUSERNAME' => $staff['username'],
            'STAFFUSERLEVEL' => $user_level,
            'U_PROFILE' => append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$staff[user_id]"),
         ));
         $k++;
      }
      while( $staff = $db->sql_fetchrow($result_user) );
   }
}

//
// Fetch Poll
//
$fetchpoll = phpbb_fetch_poll($CFG['poll_forum']);

if (!empty($fetchpoll))
{
   $template->assign_vars(array(      
      'S_POLL_QUESTION' => $fetchpoll['vote_text'],
      'S_POLL_ACTION' => append_sid('posting.'.$phpEx.'?'.POST_TOPIC_URL.'='.$fetchpoll['topic_id']),
      'S_TOPIC_ID' => $fetchpoll['topic_id'],
      'L_SUBMIT_VOTE' => $lang['Submit_vote'],
      'L_LOGIN_TO_VOTE' => $lang['Login_to_vote']      
      )
   );

   for ($i = 0; $i < count($fetchpoll['options']); $i++)
   {
      $template->assign_block_vars('poll_option_row', array(
         'OPTION_ID' => $fetchpoll['options'][$i]['vote_option_id'],
         'OPTION_TEXT' => $fetchpoll['options'][$i]['vote_option_text'],
         'VOTE_RESULT' => $fetchpoll['options'][$i]['vote_result'],
         )
      );
   }   
}
else
{
   $template->assign_vars(array(      
      'S_POLL_QUESTION' => $lang['No_poll'],
      'DISABLED' => 'disabled="disabled"'
      )
   );
}

//
// Start Top 5 Points hack
$sql = "SELECT user_id, username, user_points FROM " . USERS_TABLE ." WHERE user_id <> -1 ORDER BY user_points DESC LIMIT 10";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result)) {
      $template ->assign_block_vars("top_points", array(
      'USERNAME' => $row['username'],
      'URL' => $phpbb_root_path . "profile.php?mode=viewprofile&u=" . $row['user_id'],
       'POINTS' => $row['user_points'])
   );
}
// End Top 5 Points hack
/*******************************************/
/***** Start Tot Song hack by DB Angel *****/
/***** V0.1a *****/
$sql = "SELECT song_id, song_title, song_username, song_user_id, song_singer, song_view_count FROM " . MUSIC_TABLE ." WHERE song_id <> -1 ORDER BY song_view_count DESC LIMIT 10";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result)) {
      $template ->assign_block_vars("top_song", array(
      'SONGNAME' => $row['song_title'],
      'SINGER' => $row['song_singer'],
      'URL' => $phpbb_root_path . "music_page.$phpEx?song_id=". $row['song_id'],
      'POSTER' => $row['song_username'],
      'POSTERURL' => $phpbb_root_path . "profile.php?mode=viewprofile&u=" . $row['song_user_id'],
      'VIEWS' => $row['song_view_count'])
   );
}
/***** http://www.dbangel.net *****/
/***** End Tot Song hack by DB Angel *****/
/*********************************************/
// Generate the page
//
$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
//
// Recent Links
//
$sql = "SELECT l.link_url, l.link_title, l.link_desc, l.link_id, lc.cat_title, lc.cat_id, u.username, u.user_id
      FROM " . LINKS_TABLE . " l, " . LINK_CATEGORIES_TABLE . " lc, " . USERS_TABLE . " u
      WHERE l.link_active = 1
      AND l.link_category = lc.cat_id
      AND l.user_id = u.user_id
      ORDER BY l.link_joined DESC
      LIMIT 0,".$board_config['recent_links'];
if (!$result = $db->sql_query($sql))
{
   message_die(GENERAL_ERROR, 'Could not query links information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
   $template->assign_block_vars('recent_links', array(
         'LINK_URL' => '<a href="'.append_sid("links.$phpEx?action=go&link_id=" . $row['link_id']).'" target="_blank" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()"><b>'.$row['link_title'].'</b></a>',
         'LINK_CAT' => '<a href="'.append_sid("links.$phpEx?t=sub_pages&cat=" . $row['cat_id']).'" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()"><i>'.$row['cat_title'].'</i></a>',
         'LINK_DESC' => $row['link_desc'],
         'LINK_AUTHOR' => '<a href="'.append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $row['user_id']).'" onMouseOver="document.all.recent_links.stop()" onMouseOut="document.all.recent_links.start()">'.$row['username'].'</a>')
   );
}
$template->assign_vars(array(
   'L_RECENT_LINKS' => $lang['Recent_links'])
);
?>

[oxpus]

THis file seams okay.
I also need the portal_body.tpl.

And please attach complete files not with CODE but as a ZIP-File. Thanks.

[darakhshan]

Thank you for your response I hope I can fix it tonight and go to bed.
however I doubt there is any thing wrong with porta body tpl because I was I did according to instruction and even I changed the place of the code to see if it works some where else any way here you are waiting for your professional view

[oxpus]

Looking second on the portal.php I've found the error:
The code block for the recent links must insert before

Code: Alles auswählen

$template->pparse('body');

This is an error in the mod description, I'll fix now.
So please move the block. I'll not do it, because you file has a difficult language coding.

[darakhshan]

well I did not understand sorry, But I am happy you have found the solution and I appreciate your effort. Thanks
I do not understand, Have read it again and again and even looked for the code in my portal body tpl but can not figure it out
Please will you make the changes in portal body tple and let me know what has been changed (where) and I will fix it or please explain more?

Thank you.

[oxpus]

Here the fixed file.
Just check th table headers and any text, because I can only code this in european languages.

[darakhshan]

I will check again

[oxpus]

Make sure, you have do all changes on the includes/constants.php like the mod description.

[darakhshan]

Make sure, you have do all changes on the includes/constants.php like the mod description.

But your MOD in phpbbhacks http://www.phpbbhacks.com/download/1961

has not asked any modification request for includes/constants.php :confused:

what should I modify?

[oxpus]

Yes, not my mod, but the links mod itself

[Mark0100]

Hallo,

ich habe gerade versucht, den Mod Recent Links in Portal in ein aktuelles Orion einzubauen.

Jedoch bleibt die Box auf dem Protal leer. Ich finde den Fehler einfach nicht.

Die relevanten Dateien habe ich mal angehängt

[oxpus]

Du hast aber auch den Advanced Links MOD eingebaut?
Denn darauf basiert der Portal-Block...

[Mark0100]

ist der nicht schon direkt mit drin, oder istdas doch ein anderer Links Mod?

[oxpus]

Da binich aktuell überfragt.
Stell diese Frage doch mal auf http://www.community.cback.de
Schliesslich kommt von dort auch das Orion.