Include own posts on friends wall

buensumisoStarter

232 posts

I'm interested in Including your own posts on friends wall.

In the function serviceViewBlockAccountTimeline with the query that I marked in red, the friends are obtained to show their publications.
 
function getMyFriendsEx($iID, $sWhereParam = '', $sSortParam = '', $sqlLimit = '')

 {

  $sOrderBy = '';

  $sWhereParam = "AND p.`Status`='Active' " . $sWhereParam;

  switch($sSortParam) {

  case 'activity' :

  case 'last_nav' : // DateLastNav

  $sOrderBy = 'ORDER BY p.`DateLastNav`';

  break;

  case 'activity_desc' :

  case 'last_nav_desc' : // DateLastNav

  $sOrderBy = 'ORDER BY p.`DateLastNav` DESC';

  break;

  case 'date_reg' : // DateReg

  $sOrderBy = 'ORDER BY p.`DateReg`';

  break;

  case 'date_reg_desc' : // DateReg

  $sOrderBy = 'ORDER BY p.`DateReg` DESC';

  break;

  case 'image' : // Avatar

  $sOrderBy = 'ORDER BY p.`Avatar` DESC';

  break;

  case 'rate' : // Rate and RateCount

  $sOrderBy = 'ORDER BY p.`Rate` DESC, p.`RateCount` DESC';

  break;

  default : // DateLastNav

  $sOrderBy = 'ORDER BY p.`DateLastNav` DESC';

  break;

  }

  $sLimit = ($sqlLimit == '') ? '' : /*"LIMIT 0, " .*/ $sqlLimit;

  $iOnlineTime = (int)getParam( "member_online_time" );

  $sqlQuery = "SELECT `p`.*, `f`.`ID`,
  if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL $iOnlineTime MINUTE ), 1, 0) AS `is_online`,
  UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
  SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '{$iID}' AND `Check` =1
  UNION
  SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '{$iID}' AND `Check` =1
  ) AS `f`
  INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
  WHERE 1 {$sWhereParam}
  {$sOrderBy}
  {$sLimit}";

  $aFriends = array();

  $vProfiles = db_res($sqlQuery);

  while ($aProfiles = mysql_fetch_assoc($vProfiles)) {

  $aFriends[$aProfiles['ID']] = array($aProfiles['ID'], $aProfiles['TS_DateLastLogin'], $aProfiles['TS_DateReg'],$aProfiles['Rate'], $aProfiles['DateLastNav'], $aProfiles['is_online']);

  }

  return $aFriends;

 }
 
How can I include the owner of the wall so that their posts are also displayed?