[Add-on] Display posts anywhere 1.2.0 RC5

[Aratgel Sébastien]

thx a lot, I try it tonight( I live in Québec) a unficial nation in Canada!

[EXreaction]

If you want to have an extra section to display the latest topics(the first post in the last X number of topics) you can check this out:

Spoiler:

Code: Select all

function phpbb_fetch_posts($forum_sql, $number_of_posts, $text_length, $time, $type)
{
    global $db, $user, $phpbb_root_path, $phpEx, $auth;
    
    $from_forum = ($forum_sql != '') ? 't.forum_id IN (' . $forum_sql . ') AND' : '';
    $post_time = ($time == 0) ? '' : 't.topic_time > ' . (time() - $time * 86400) . ' AND';

    if ($type == 'announcments')
    {
        $topic_type = '( t.topic_type = 2 OR t.topic_type = 3 ) AND';
    }
    else if ($type == 'news_all')
    {
        $topic_type = '';
    }
    else
    {
        $topic_type = 't.topic_type = 0 AND';
    }

    $sql = 'SELECT
            t.forum_id,
            t.topic_id,
            t.topic_time,
            t.topic_title,
            p.post_text,
            u.username,
            t.topic_replies,
            p.bbcode_uid,
            t.forum_id,
            t.topic_poster,
            p.post_id,
            p.enable_smilies,
            p.enable_bbcode,
            p.enable_magic_url,
            p.bbcode_bitfield,
            p.bbcode_uid,
            t.topic_attachment,
            t.poll_title
        FROM
            ' . TOPICS_TABLE . ' AS t,
            ' . USERS_TABLE . ' AS u,
            ' . POSTS_TABLE . ' AS p
        WHERE
            ' . $topic_type . '
            ' . $from_forum . '
            ' . $post_time . '
            t.topic_poster = u.user_id AND
            t.topic_first_post_id = p.post_id AND
            t.topic_first_post_id = p.post_id AND
            t.topic_status <> 2 AND
            t.topic_approved = 1
        ORDER BY
            t.topic_time DESC';

    if(!($result = $db->sql_query($sql)))
    {
        die('Could not query topic information');
    }

    $posts = array();
    $i = 0;
    while ( ($row = $db->sql_fetchrow($result)) && ( ($i < $number_of_posts) || ($number_of_posts == '0') ) )
    {
        if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
        {
            $posts[$i]['post_text'] = censor_text($row['post_text']);
            $posts[$i]['topic_id'] = $row['topic_id'];
            $posts[$i]['forum_id'] = $row['forum_id'];
            $posts[$i]['topic_replies'] = $row['topic_replies'];
            $posts[$i]['topic_time'] = $user->format_date($row['topic_time']);
            $posts[$i]['topic_title'] = $row['topic_title'];
            $posts[$i]['username'] = $row['username'];
            $posts[$i]['poll'] = ($row['poll_title'] != '') ? true : false;
            $posts[$i]['attachment'] = ($row['topic_attachment']) ? true : false;

            $len_check = $posts[$i]['post_text'];

            $len_check = strip_post($len_check, $row['bbcode_uid'], $text_length);

            if (($text_length != 0) && (strlen($len_check) > $text_length))
            {
                $posts[$i]['post_text'] = substr($len_check, 0, $text_length);
                $posts[$i]['post_text'] .= '...';
                $posts[$i]['striped'] = true;
            }

            include_once($phpbb_root_path . 'includes/bbcode.' . $phpEx);
            $bbcode = new bbcode($row['bbcode_bitfield']);
            $posts[$i]['post_text'] = censor_text($posts[$i]['post_text']);

            $bbcode->bbcode_second_pass($posts[$i]['post_text'], $row['bbcode_uid'], $row['bbcode_bitfield']);
            $posts[$i]['post_text'] = smiley_text($posts[$i]['post_text']);
            $posts[$i]['post_text'] = str_replace("\n", '<br />', $posts[$i]['post_text']);
            $i++;
        }
    }

    return $posts;
}

It is the function I made for phpBBsp(it needs some code removal for what you would use, but its pretty much done for ya).

[Handyman]

I just found a default phpBB3 function that will be able to cut down on my code on this one.

[EXreaction]

Whats it called and where?

[EXreaction]

hi I have some trouble whit the new function get_last_posts

I get the felowing error: Parse error: syntax error, unexpected '}' in /home/julie/public_html/Forum/cache/tpl_subSilver_post_anywhere.html.php on line 10


at line 8 to 11 the code is :

Code: Select all

<tr>
    <td>subjet: <?php echo $this->_tpldata['posts'][$this->_posts_i]['POST_SUBJECT']; ?>
<?php }} ?></td>
  </tr>

my exact template code is:

Code: Select all

<table width="200" border="1">
  <tr>
    <td>{POST_ICON}</td>
  </tr>
  <tr>
    <td>{POST_SUBJECT}</td>
  </tr>
  <tr>
    <td>sujet: {posts.POST_SUBJECT}
<!-- END posts --></td>
  </tr>
  <tr>
    <td>{POST_SUBJECT4}</td>
  </tr>
  <tr>
    <td>{POST_SUBJECT5}</td>
  </tr>
</table>

(is't final, it is just a test)

[EXreaction]

I don't exactly see what your trying to do, but try removing one of the } on line 10...

[Handyman]

Whats it called and where?

Code: Select all

<?php $rowset = $db->sql_fetchrowset();

That makes $rowset an array with all the details from the query... so it can be used anywhere in the page with a foreach

Thinking about it now, I'm not sure if it will cut down on my code or not, but It will come in handy in the future.

[Handyman]

<table width="200" border="1">
<tr>
<td>{POST_ICON}</td>
</tr>
<tr>
<td>{POST_SUBJECT}</td>
</tr>
<tr>
<td>sujet: {posts.POST_SUBJECT}
<!-- END posts -->

This is the reason why it's giving you errors.
Sorry I didn't put an example in the install file... but to make this work, you have to have a <!-- BEGIN posts -->
so here is an example:

Code: Select all

<!-- BEGIN posts -->
Subject: {posts.POST_SUBJECT}
Post: [posts.POST_TEXT}
<!-- END posts -->

[Aratgel Sébastien]

thx a lot now it work !!!

[Handyman]

Sure!!!

I need to know what everybody wants this to be able to do... I'm going to add more features to it.

Here is what I have currently (not for download yet)

• Username
  
• Username Link
  
• Avatar
  
• Poster Rank
  
• Rank Image
  

If you want me to add anything else, post and let me know and I'll add it.
I'll be updating this sometime before next week.