<?php
  
  function trimBody($theText,$lmt=500, $s\_chr="\backslash n",$s_cnt=2) {
    $pos\; =\; 0;$trimmed = FALSE;
    for ($i\; =\; 1;$i <= $s\_cnt;$i++) {
      if ($tmp\; =\; strpos($theText, $s\_chr,$pos+1)) {
        $pos\; =$tmp;
        $trimmed\; =\; TRUE;\; \}\; else\; \{$pos = strlen($theText)\; -\; 1;$trimmed = FALSE;
        break;
      }
    }
    $theText\; =\; substr($theText, 0, $pos);\; if\; (strlen($theText) > $lmt)\; \{$theText = substr($theText,\; 0,$lmt);
      $theText\; =\; substr($theText, 0, strrpos($theText,\text{'}\; \text{'}));$trimmed = TRUE;
    }
    if ($trimmed)$theText .= '...';
    return $theText;\; \}\; function\; outputStory($article, $only\_snippet=FALSE)\; \{\; global$conn;
  
    if ($article)\; \{$sql = "SELECT ar.*, usr.name " .
             "FROM cms_articles ar " .
             "LEFT OUTER JOIN cms_users usr " .
             "ON ar.author_id = usr.user_id " .
             "WHERE ar.article_id = " . $article;$result = mysql_query($sql,$conn);
  
      if ($row\; =\; mysql\_fetch\_array($result)) {
        echo "<h3>" . htmlspecialchars($row[\text{'}title\text{'}])\; .\; "$</h3>\n";
        echo "<h5><div class=\"byline\">By: " .
             htmlspecialchars(row['name']) .
             "</div>";
        echo "<div class=\"pubdate\">";
        if ($row[\text{'}is\_published\text{'}]\; ==\; 1)\; \{\; echo\; date("F\; j,\; Y",strtotime($row['date_published']));
        } else {
          echo "not yet published";
        }
        echo "</div></h5>\n";
        if ($only\_snippet)\; \{\; echo\; "$<p>\n";
          echo nl2br(htmlspecialchars(trimBody(row['body'])));
          echo "</p>\n";
          echo "<h4><a href=\"viewarticle.php?article=" .
               $row[\text{'}article\_id\text{'}]\; .\; "\backslash ">Full\; Story...$</a></h4><br>\n";
        } else {
          echo "<p>\n";
          echo nl2br(htmlspecialchars(row['body']));
          echo "</p>\n";
        }
      }
    }
  }
  
  function showComments($article,$showLink=TRUE) {
    global $conn;\; if\; ($article) {
      $sql\; =\; "SELECT\; is\_published\; "\; .\; "FROM\; cms\_articles\; "\; .\; "WHERE\; article\_id="\; .$article;
      $result\; =\; mysql\_query($sql,$conn)\; or\; die(\text{'}Could\; not\; look\; up\; comments;\; \text{'}\; .\; mysql\_error());$row = mysql_fetch_array($result);$is_published = $row[\text{'}is\_published\text{'}];$sql = "SELECT co.*, usr.name, usr.email " .
             "FROM cms_comments co " .
             "LEFT OUTER JOIN cms_users usr " .
             "ON co.comment_user = usr.user_id " .
             "WHERE co.article_id=" . $article\; .\; "\; ORDER\; BY\; co.comment\_date\; DESC";$result = mysql_query($sql,$conn)
        or die('Could not look up comments; ' . mysql_error());
  
      if ($showLink)\; \{\; echo\; "$<h4>" . mysql_num_rows(result) . " Comments";
        if (isset($\_SESSION[\text{'}user\_id\text{'}])\; and$is_published) {
          echo " / <a href=\"comment.php?article=" . $\_GET[\text{'}article\text{'}]\; .\; "\backslash ">Add\; one$</a>";
        }
        echo "</h4>\n";
      }
  
      if (mysql_num_rows(result)) {
        echo "<div class=\"scroller\">\n";
        while ($row\; =\; mysql\_fetch\_array($result)) {
          echo "<span class=\"commentName\">" .
               htmlspecialchars($row[\text{'}name\text{'}])\; .\; "$</span><span class=\"commentDate\"> (" .
               date("l F j, Y H:i", strtotime(row['comment_date'])) .
               ")</span>\n";
          echo "<p class=\"commentText\">\n" .
               nl2br(htmlspecialchars($row[\text{'}comment\text{'}]))\; .\; "\backslash n$</p>\n";
        }
        echo "</div>\n";
      }
      echo "<br>\n";
    }
  }
  ?>