MajorDoMo

Код: Выделить всё

$sql = "SELECT DATE_FORMAT( s.`ADDED` , '%H:%i' ) tm, IFNULL( u.name, 'Алиса' ) user,u.color, s.`MESSAGE`
FROM `shouts` s LEFT JOIN users u ON u.id = `MEMBER_ID`
WHERE s.`MESSAGE` not like 'на канале %'
ORDER BY s.`ADDED` DESC,s.id DESC LIMIT 10";
$recs = SQLSelect($sql);
$txt = '';
$total = count($recs); 
/////////////////////////////////////////////////////////////////////////////////////
for ($i = 0; $i < $total; $i++) {
 if(mb_strlen($txt,'UTF-8')>400) continue; //подберём кол-во символов в логе, чтоб за рамку не выезжало
 $user = $recs[$i]['user'];
 $color =  $recs[$i]['color'];
 if($user == 'Алиса'){
   $txt .= '<p>'. $recs[$i]['tm'].' <b>'.$user.'</b>: '.$recs[$i]['MESSAGE'].'</p>';
 }else{
   //$txt .= '<p style="color:'.$color.';">'. $recs[$i]['tm'].' <b>'.$user.'</b>: '.$recs[$i]['MESSAGE'].'</p>'; 
   $txt .= '<p style="text-align:right;color:'.$color.';">'. $recs[$i]['tm'].' <b>'.$user.'</b>: '.$recs[$i]['MESSAGE'].'</p>'; 
   //if($i == 0) DebMes('makeShoutList ->'.$txt);
 }
}

setGlobal('List.text',$txt);

Код: Выделить всё

$res=SQLSelect("SELECT shouts.*, DATE_FORMAT(shouts.ADDED, '%H:%i') as DAT, TO_DAYS(shouts.ADDED) as DT, users.NAME, users.COLOR FROM shouts LEFT JOIN users ON shouts.MEMBER_ID=users.ID WHERE $qry ORDER BY shouts.ADDED DESC, ID DESC $limit");
...

  if ($res[0]['ID']) {
   $old_dt=$res[0]['DT'];
   $total=count($res);
   for($i=0;$i<$total;$i++) {
    // some action for every record if required
    $tmp=explode(' ', $res[$i]['ADDED']);
    $res[$i]['ADDED']=fromDBDate($tmp[0])." ".$tmp[1];
    if ($res[$i]['DT']!=$old_dt) {
     $txtdata.="<hr size=1><b>".$tmp[0]."</b><br>";
     $old_dt=$res[$i]['DT'];
    }
    if ($res[$i]['MEMBER_ID']==0) {
     $res[$i]['NAME']=$comp_name;
    }
    $stl='';
    if (trim($res[$i]['COLOR'])) {
     $stl=' style="color:'.$res[$i]['COLOR'].'"';
    }
    $txtdata.="<span$stl>".$res[$i]['DAT']." <b>".$res[$i]['NAME']."</b>: ".nl2br($res[$i]['MESSAGE'])."</span><br>";
   }
   $out['RESULT']=$res;
   $out['TXT_DATA']=$txtdata;
  } else {
   $txtdata.='No data';
  }