swaygodeus Posted February 1, 2010 Share Posted February 1, 2010 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: <?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; <!-- 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!! Link to comment https://forums.phpfreaks.com/topic/190562-displaying-phpbb-avatar-on-external-posting/ Share on other sites More sharing options...
swaygodeus Posted February 2, 2010 Author Share Posted February 2, 2010 anyone? Link to comment https://forums.phpfreaks.com/topic/190562-displaying-phpbb-avatar-on-external-posting/#findComment-1005299 Share on other sites More sharing options...
swaygodeus Posted February 4, 2010 Author Share Posted February 4, 2010 hmmm...no one knows the answer? Link to comment https://forums.phpfreaks.com/topic/190562-displaying-phpbb-avatar-on-external-posting/#findComment-1006520 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.