Looking for someone to make a simple SSI.php type mod

[Royce]

I basically just need someone to write a *simple* SSI.php type file that displays the 8 most (or whatever I define) recent topics that also snips topics longer than say 30 characters.  It would ended up looking like this on the page that calls the SSI.php type script.

>>Joe bob likes monkeys
>>Why is the sky blue?
>>This is a really long topic tha... (ex. of a snipped topic)
>>Bla Bla Bla
>>La la la la la

I once had a script like this when I had the perl version and loved it.  The current SSI.php throws up tons of errors (even when error reporting is off) so I'd love it if someone could make this small little script for me.  If you live in the socal area, I'll be sending free lift tickets your way in exchange     THANKS FOR ANY HELP!!  

[[Unknown]]

LOL, I do this on my site AND I live in LA.  But, I don't need any tickets ..

Code Select Expand

$result = mysql_query("
   SELECT ms.subject, t.ID_TOPIC, b.ID_BOARD
  FROM {$yyprefix}topics AS t
     LEFT JOIN {$yyprefix}messages AS m ON (m.ID_TOPIC = t.ID_TOPIC)
     LEFT JOIN {$yyprefix}boards AS b ON (b.ID_BOARD = t.ID_BOARD)
     LEFT JOIN {$yyprefix}categories AS c ON (c.ID_CAT = b.ID_CAT)
     LEFT JOIN {$yyprefix}messages AS ms ON (ms.ID_MSG = t.ID_FIRST_MSG)
  WHERE t.ID_LAST_MSG = m.ID_MSG
     AND c.memberGroups = ''
  ORDER BY m.ID_MSG DESC
  LIMIT 8") or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
  if (strlen($row['subject']) > 30)
     $row['subject'] = substr($row['subject'], 0, 28) . '...';
  echo '<a href="index.php?board=' . $row['ID_BOARD'] . ';action=display;threadid=' . $row['ID_TOPIC'] . ';start=new">' . $row['subject'] . '</a><br />';
}
mysql_free_result($result);

Man, I really screwed thsat up at first.

Be warned that this had been adapted to 1.5.x from code for 1.6.0.  I think it works...

-[Unknown]

[Royce]

Sorry if this is a dumb question but, where exactly do I put this?

[grosbouff]

and wich files do we include ?
(it interessed me also  )

[Royce]

put that code in a php file and don't forget the <?php ?> tag.  Use php include to call it into the page you wish.  Thanks again Unknown for this!

[Royce]

Just noticed that the above code doesn't censor the words.  I had a nice S H I T on my homepage!  Can anyone fix this?  Thanks!

[[Unknown]]

Find:

Code Select Expand

while ($row = mysql_fetch_assoc($result))
{
 if (strlen($row['subject']) > 30)

Replace:

Code Select Expand

while ($row = mysql_fetch_assoc($result))
{
 CensorTxt($row['subject']);
 if (strlen($row['subject']) > 30)

-[Unknown]