Simple Machines Community Forum

http://custom.simplemachines.org/mods/index.php?mod=3839

I'm calling the top 5 states but seems to be something wrong in the code

<?php
/*
*block- breeze comments 
*simple-portal 
*code write by  - dhayzon
*/

if (!defined('SMF'))
  die('Hacking attempt...');


function breeze_coments(){

global $txt, $db_prefix, $scripturl, $memberContext, $modSettings, $txt, $context ;
    global $smcFunc, $boarddir;

$limit = 6;
$default_avatar = "/default_avatar.jpg";


$breeze = $smcFunc['db_query']('', '

SELECT mem.status_body, mem.status_poster_id, mem.status_time, mem.status_owner_id, mem.status_id,
 m.real_name, m.avatar
    FROM {db_prefix}breeze_status AS mem
       LEFT JOIN {db_prefix}members AS m ON (m.id_member = mem.status_poster_id)
       ORDER BY {raw:sort}
      LIMIT {int:limit}',
array(
'sort' =>'status_id DESC',
'limit' => $limit,
)
);


$breeze_status[] = array();


while ($breeze_statues = $smcFunc['db_fetch_assoc']($breeze) )
  {

   global $memberContext;
      loadMemberData($breeze_statues['status_poster_id']);
      loadMemberContext($breeze_statues['status_poster_id']);

$breeze_status[] = array(

'poster_id' => $breeze_statues['status_poster_id'],
'real_name' => $breeze_statues['real_name'],
'href' => $scripturl . '?action=profile;u=' . $breeze_statues['status_poster_id'],
'status_body' => $breeze_statues['status_body'],
'status_owner_id' => $breeze_statues['status_owner_id'],
'status_id' => $breeze_statues['status_id'],
        'avatar' => $breeze_statues['avatar'] == '' ? $memberContext[$breeze_statues['status_poster_id']]['avatar']['href'] : (stristr($breeze_statues['avatar'], 'http://') ? $breeze_statues['avatar'] : $modSettings['avatar_url'] . '/' . $breeze_statues['avatar']),

'time' => timeformat($breeze_statues['status_time']),

);


}

 $smcFunc['db_free_result']($breeze);



foreach ($breeze_status as $comments) {

    if ($comments['poster_id'] == $comments['status_owner_id'] ) {

      echo'<div class="media">
     <a class="pull-left" href="'.$comments['href'].'"><img class="media-object avatar" src="',empty($comments['avatar']) ?''.$default_avatar.'':''.$comments['avatar'].'' ,'" alt="" width="34px" height="34px"> </a>
     <div class="media-body">
     <h4 class="media-heading">'.$comments['real_name'].' - <small>'.$comments['time'].'</small></h4>

      '.$comments['status_body'].'
     </div>
    </div>';
    }
//echo'id - '.$comments['poster_id'].' </br> name-'.$comments['real_name'].' '.$comments['status_body'].'';


//fin foreach
   }


}

?>

result

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FVrYTybV.png&hash=015cfeb4cb447542e3583c118ef6d8b134fad831)

Posted this also in topic at simpleportal site: http://simpleportal.net/index.php?topic=13393.msg66249#msg66249

global $db_prefix, $scripturl, $memberContext, $modSettings, $smcFunc;

$limit = 6;
$default_avatar = "/default_avatar.jpg";

$breeze = $smcFunc['db_query']('', '
SELECT mem.status_body, mem.status_poster_id, mem.status_time, mem.status_owner_id, mem.status_id, m.real_name, m.avatar
FROM {db_prefix}breeze_status AS mem
LEFT JOIN {db_prefix}members AS m ON (m.id_member = mem.status_poster_id)
ORDER BY {raw:sort}
LIMIT {int:limit}',
array(
'sort' =>'status_id DESC',
'limit' => $limit,
)
);

$breeze_status = array();

while ($breeze_statues = $smcFunc['db_fetch_assoc']($breeze))
{
global $memberContext;
loadMemberData($breeze_statues['status_poster_id']);
loadMemberContext($breeze_statues['status_poster_id']);

$breeze_status[] = array(
'poster_id' => $breeze_statues['status_poster_id'],
'real_name' => $breeze_statues['real_name'],
'href' => $scripturl . '?action=profile;u=' . $breeze_statues['status_poster_id'],
'status_body' => $breeze_statues['status_body'],
'status_owner_id' => $breeze_statues['status_owner_id'],
'status_id' => $breeze_statues['status_id'],
'avatar' => $breeze_statues['avatar'] == '' ? $memberContext[$breeze_statues['status_poster_id']]['avatar']['href'] : (stristr($breeze_statues['avatar'], 'http://') ? $breeze_statues['avatar'] : $modSettings['avatar_url'] . '/' . $breeze_statues['avatar']),
'time' => timeformat($breeze_statues['status_time']),
);
}

$smcFunc['db_free_result']($breeze);

foreach ($breeze_status as $comments)
{
if ($comments['poster_id'] == $comments['status_owner_id'] && !empty($comments['poster_id']))
{
echo'
<div class="media">
<a class="pull-left" href="'.$comments['href'].'"><img class="media-object avatar" src="',empty($comments['avatar']) ?''.$default_avatar.'':''.$comments['avatar'].'' ,'" alt="" width="34px" height="34px"> </a>

<div class="media-body">
<h4 class="media-heading">'.$comments['real_name'].' - <small>'.$comments['time'].'</small></h4>
'.$comments['status_body'].'
</div>
</div>';
}
}

(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi.imgur.com%2FTpcheRM.gif&hash=cdd60a4a43d4331c59643fc6127a042567323c68)  thanks you