$row['message_id']){
$query = "select * from ".$table." where message_id = ".$newest;
$result1 = mysql_query($query);
while($row1 = mysql_fetch_assoc($result1)){
if ($PHORUM[mods][bbcode] ==1){
$msgbody = preg_replace( "|]*>|i", "", $row1['body']);
$msg['body'] = truncate_string(str_replace("#", "//", str_replace("/", "/
", str_replace("//", "#", preg_replace( "|\[/*[a-z][^\]]*\]|i", "", $msgbody)))), $preview_length, 1);
}
$msg['datestamp'] = date("j.n.Y G:i", $row1['datestamp']);
$msg['author'] = truncate_string($row1['author'], 12, 1);
$msg['message_id'] = $newest;
}
} else {
if ($PHORUM[mods][bbcode] ==1){
$msgbody = preg_replace( "|]*>|i", "", $row['body']);
$msg['body'] = truncate_string(str_replace("#", "//", str_replace("/", "/
", str_replace("//", "#", preg_replace( "|\[/*[a-z][^\]]*\]|i", "", $msgbody)))), $preview_length, 1);
}
$msg['datestamp'] = date($date_format, $row['datestamp']);
$msg['author'] = truncate_string($row['author'], 12, 1);
$msg['message_id'] = $row['message_id'];
}
$msg['subject'] = "" .truncate_string($row['subject'], 60, 1). "";
$p[] = $msg;
}
foreach ($p as $key => $data) {
// in case you want to sort by date not messageid
//$pdate[$key] = $data['datestamp'];
$pkey[$key] = $data['message_id'];
}
array_multisort($pkey, SORT_DESC, $p);
// I use smarty templating engine to assign stuff to template, use whatever method you like.
$smarty->assign("p", $p);
function truncate_string($string, $length, $greater) {
// truncated subjects end with:
$end_string = "...";
$i = $length - strlen($end_string);
// where do we chop the string, earlier or later?
if($greater == 1){
while ($i < strlen($string)) {
if ($string[$i] == " ") {
$string = substr($string, 0, $i).$end_string;
return $string;
}
$i++;
}
} else {
while ($i > 0) {
if ($string[$i] == " ") {
$string = substr($string, 0, $i).$end_string;
return $string;
}
$i--;
}
}
// if it's just one long word or first word longer than maxlength chop it in the middle anyway
if($i == 0 || $i == strlen($string)) {
$string = substr($string, 0, $length-strlen($end_string)).$end_string;
}
return $string;
}
?>