SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Displaying phpbb avatar on external posting page

    Ok, so I followed a cut/paste tutorial on having your phpbb posts show up on an external page. I've accomplished that here:

    http://www.theuflonline.com (lower middle)

    What I am missing though is the poster's avatar. The tutorial didn't give the code to do that. I was hoping someone could edit what was given so the avatar will show up. I'd like it to look something like this:

    http://premiermaddenfootball.com/index.php (on the bottom right)

    Here is the php code:

    Code:
    <?php
    /*
    * home.php
    * Description: example file for displaying latest posts and topics
    * by battye (for phpBB.com MOD Team)
    * September 29, 2009
    */
    
    define('IN_PHPBB', true);
    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './msgboard/';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);
    include($phpbb_root_path . 'includes/bbcode.' . $phpEx);
    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
    
    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup('viewforum'); 
    
    
    /* create_where_clauses( int[] gen_id, String type )
    * This function outputs an SQL WHERE statement for use when grabbing
    * posts and topics */
    
    function create_where_clauses($gen_id, $type)
    {
    global $db, $auth;
    
    $size_gen_id = sizeof($gen_id);
    
    switch($type)
    {
    case 'forum':
    $type = 'forum_id';
    break;
    case 'topic':
    $type = 'topic_id';
    break;
    default:
    trigger_error('No type defined');
    }
    
    // Set $out_where to nothing, this will be used of the gen_id
    // size is empty, in other words "grab from anywhere" with
    // no restrictions
    $out_where = '';
    
    if ($size_gen_id > 0)
    {
    // Get a list of all forums the user has permissions to read
    $auth_f_read = array_keys($auth->acl_getf('f_read', true));
    
    if ($type == 'topic_id')
    {
    $sql = 'SELECT topic_id FROM ' . TOPICS_TABLE . '
    WHERE ' . $db->sql_in_set('topic_id', $gen_id) . '
    AND ' . $db->sql_in_set('forum_id', $auth_f_read);
    
    $result = $db->sql_query($sql);
    
    while ($row = $db->sql_fetchrow($result))
    {
    // Create an array with all acceptable topic ids
    $topic_id_list[] = $row['topic_id'];
    }
    
    unset($gen_id);
    
    $gen_id = $topic_id_list;
    $size_gen_id = sizeof($gen_id);
    }
    
    $j = 0; 
    
    for ($i = 0; $i < $size_gen_id; $i++)
     {
    $id_check = (int) $gen_id[$i]; // If the type is topic, all checks have been made and the query can start to be built if( $type == 'topic_id' ) { $out_where .= ($j == 0) ? 'WHERE ' . $type . ' = ' . $id_check . ' ' : 'OR ' . $type . ' = ' . $id_check . ' '; } // If the type is forum, do the check to make sure the user has read permissions else if( $type == 'forum_id' && $auth->acl_get('f_read', $id_check) )
    {
    $out_where .= ($j == 0) ? 'WHERE ' . $type . ' = ' . $id_check . ' ' : 'OR ' . $type . ' = ' . $id_check . ' ';
    } 
    
    $j++;
    }
    }
    
    if ($out_where == '' && $size_gen_id > 0)
    {
    trigger_error('A list of topics/forums has not been created');
    }
    
    return $out_where;
    }
    
    
    $search_limit = 10;
    
    $forum_id = array(14, );
    $forum_id_where = create_where_clauses($forum_id, 'forum');
    
    $topic_id = array( );
    $topic_id_where = create_where_clauses($topic_id, 'topic');
    
    $topics = 'SELECT * FROM ' . TOPICS_TABLE . '
    ' . $forum_id_where . '
    AND topic_status <> ' . ITEM_MOVED . '
    AND topic_approved = 1
    ORDER BY topic_id DESC';
    
    $topics_result = $db->sql_query_limit($topics, $search_limit);
    
    while ($topics_row = $db->sql_fetchrow($topics_result))
    {
    $topic_title = $topics_row['topic_title'];
    $topic_author = get_username_string('full', $topics_row['topic_poster'], $topics_row['topic_first_poster_name'], $topics_row['topic_first_poster_colour']);
    $topic_date = $user->format_date($topics_row['topic_time']);
    $topic_last_post = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "p=" . $topics_row['topic_last_post_id'] . "#" . $topics_row['topic_last_post_id']);
    $topic_last_author = get_username_string('full', $topics_row['topic_last_poster_id'], $topics_row['topic_last_poster_name'], $topics_row['topic_last_poster_colour']);
    $topic_link = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "t=" . $topics_row['topic_id']);
    
    $template->assign_block_vars('announcements', array(
    'TOPIC_TITLE' => censor_text($topic_title),
    'TOPIC_AUTHOR' => $topic_author,
    'TOPIC_DATE' => $topic_date,
    'TOPIC_LAST_POST' => $topic_last_post,
    'TOPIC_LAST_AUTHOR' => $topic_last_author,
    'TOPIC_LINK' => $topic_link,
    ));
    }
    
    page_header('External page');
    
    $template->set_filenames(array(
    'body' => 'teamnews2.html'
    ));
    
    page_footer();
    ?>
    And displaying it I have it as;

    Code:
    <!-- BEGIN announcements -->
    <table border=1 cellspacing=1 cellpadding=1 bordercolor=black width=550>
    
    <tr><td><font color=white face=verdana size=2> <b> <a href={announcements.TOPIC_LINK} target=_blank>{announcements.TOPIC_TITLE}</a> </b>
    <tr><td><font color=white face=verdana size=1> {announcements.TOPIC_AUTHOR} / {announcements.TOPIC_DATE}
    
    
    
    </table>
    <!-- END announcements -->
    I really appreciate any help I can get!! THANKS!!

  2. #2
    SitePoint Member
    Join Date
    Feb 2010
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    no one can help me?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •