Topic: Recent posts with post preview

[Blue]

Now it's better. Thanks rocknroller

Have you seen that I've manage to include avatars in your pop-up block?

[wiecher]

Yes i would like that but i can`t get it to work here.
Sorry

Here, try this.

There are 2 parameters that you can change in the beginning of the code -> HEIGHT and SPEED. For default HEIGHT = 150px and SPEED = 3.

Code: [Select]

<?php

/*
Block: Recent posts with post preview
Author: Blue @ Simple Portal.net
*/

/* [SETUP WHAT YOU WANT HERE] */

// How many recent posts do you want to output?
$limit = 5;

// How many characters do you want to output?
$number = 70;

// Scroll Height and Speed?
$height = "150px";
$speed = 3;           // SLOW - 1 | MEDIUM - 10 | FAST - 20

// Do you want to translate it to your own language? :P
$text['sportal_false'] = 'Simple Portal not found';

$text['board'] = 'in';
$text['who'] = 'by';

/* [STOP!] - THIS IS THE END OF SETUP */

//Only code from now on ;)
global $smcFunc, $scripturl, $sourcedir, $modSettings;

// Lets see if you are using Simple Portal. If not...well...go get them :D
if (!file_exists($sourcedir . '/PortalBlocks.php'))
{
echo $text['sportal_false'];
return;
}

// Let's grab some database results
$posts_result = $smcFunc['db_query']('', '
   SELECT m.poster_name, m.poster_time, m.id_msg, m.id_member, m.subject, m.body, m.id_topic, b.name, u.avatar
   FROM {db_prefix}messages AS m
   LEFT JOIN {db_prefix}boards AS b ON (m.id_board = b.id_board)
   LEFT JOIN {db_prefix}members AS u ON (m.id_member = u.id_member)
   WHERE m.approved=1
   ORDER BY m.id_msg DESC
   LIMIT ' . $limit);
$posts = array();
while ($row_posts = $smcFunc['db_fetch_assoc']($posts_result))
{

      global $memberContext;
      loadMemberData($row_posts['id_member']);
      loadMemberContext($row_posts['id_member']);

   $posts[] = array(
  'id' => $row_posts['id_member'],
      'username' => '<a href="' . $scripturl . '?action=profile;u=' . $row_posts['id_member'] . '">' . $row_posts['poster_name'] . '</a>',
      'subject' => '<a style="font-weight: bold;" title="' . $text['board'] . '&nbsp;' . $row_posts['name'] .'" href="' . $scripturl . '?topic=' . $row_posts['id_topic'] . '.msg' . $row_posts['id_msg'] . ';topicseen#new">' . $row_posts['subject'] . '</a>',
      'body' => $row_posts['body'],
  'avatar' => $row_posts['avatar'] == '' ? $memberContext[$row_posts['id_member']]['avatar']['href'] : (stristr($row_posts['avatar'], 'http://') ? $row_posts['avatar'] : $modSettings['avatar_url'] . '/' . $row_posts['avatar']),
  'board' => $row_posts['name'],
  'time' => timeformat($row_posts['poster_time'])
   );
}
$smcFunc['db_free_result']($posts_result);

//Finally the Output

//Scrolling xD
echo '<marquee height=' . $height . ' behavior="scroll" direction="up" scrollamount="' . $speed . '" onmouseover="this.stop()" onmouseout="this.start()">';

foreach ($posts as $post) {
echo'<table>
<tr>
<td style="width: 40px;">
<img src="' . $post['avatar'] .'" alt="" width="40px" height="40px" />
</td>
<td>
' . $post['subject'] .'<br />
<small>' . $text['who'] . '&nbsp;' . $post['username'] . '&nbsp;|&nbsp;' . $post['time'] .'</small>
</td>
</tr>
</table>
' . substr ($post['body'],0,$number) .'...
<hr />';
}

echo '</marquee>';
?>

Thnx Blue that was what it. 

[Blue]

Glad I could help

rocknroller, do you want latest topics with the new messages shown or the first message?

[rocknroller]

Glad I could help

rocknroller, do you want latest topics with the new messages shown or the first message?

Latest topic with new messages. thank you for help me with avatar in this http://simpleportal.net/index.php?topic=9096.msg48266#new .

[Blue]

rocknroller,

I've made what you want. Check it out here:
http://simpleportal.net/index.php?topic=9138.0

[rocknroller]

rocknroller,

I've made what you want. Check it out here:
http://simpleportal.net/index.php?topic=9138.0

great, thank you!

[Blue]

Glad I could help