\n"; echo "\n"; echo "" . $title . "\n\n"; echo "\n"; echo "

" . $heading . "

\n\n"; } function write_html_trailer() { echo "\n

\n"; echo "

\n\n"; echo "\n\n"; } $story_id = $_GET['story_id']; $sql = "SELECT * FROM stories WHERE story_id='$story_id'"; $result = mysql_query($sql); $story_info = mysql_fetch_array($result); if (!$story_info) { $err = "Bad story ID ($story_id)\n"; write_html_header($err, "Error: " . $err); write_html_trailer(); die(); } $story_title = htmlentities($story_info['title']); $owner_id = $story_info['owner_id']; $owner_query = mysql_query("SELECT * FROM users WHERE user_id='$owner_id'"); $owner_info = mysql_fetch_array($owner_query); $owner_name = $owner_info['nickname']; write_html_header($story_title, $story_title); echo "

An Exquisite Story

\n\n"; $sql = "SELECT * FROM storylines WHERE story_id='$story_id' ORDER BY line_number DESC"; $story_lines = mysql_query($sql); $last_line = mysql_fetch_array($story_lines); $sql = "SELECT * FROM storylines WHERE story_id='$story_id' ORDER BY line_number"; $story_lines = mysql_query($sql); if ($story_info['status'] == 'open') { echo "

Started by: $owner_name
\n"; if ($auth_username) { echo "

"; echo "Add to this story\n"; } echo "

Summary:\n"; echo "

";
    $story_line = mysql_fetch_array($story_lines);
    while ($story_line) {
      $author_id = $story_line['user_id'];
      $author_query = mysql_query("SELECT * FROM users WHERE user_id='$author_id'");
      $author_info = mysql_fetch_array($author_query);
      if ($story_line['line_number'] == 1) {
        printf("%2d %-10s [Text hidden while the story is open]\n",
               $story_line['line_number'], $author_info['nickname']);
      } else {
        printf("%2d %-10s [-----------------------------------]\n",
              $story_line['line_number'], $author_info['nickname']);
      }
      $story_line = mysql_fetch_array($story_lines);
    }
    echo "

\n"; } else { // ($story_info['status'] != 'open') $last_author_id = $last_line['user_id']; $last_author_query = mysql_query("SELECT * FROM users WHERE user_id='$last_author_id'"); $last_author_info = mysql_fetch_array($last_author_query); $last_author_name = $last_author_info['nickname']; echo "

Started by: $owner_name
\n"; echo "Finished by: $last_author_name\n"; echo "

";
    $story_line = mysql_fetch_array($story_lines);
    while ($story_line) {
      $line_number = $line_number+1;
      $author_id = $story_line['user_id'];
      $author_query = mysql_query("SELECT * FROM users WHERE user_id='$author_id'");
      $author_info = mysql_fetch_array($author_query);
      printf("%2d %-10s %s\n", $story_line['line_number'],
             $author_info['nickname'], htmlentities($story_line['text']));
      $story_line = mysql_fetch_array($story_lines);
    }
    echo "

\n"; } write_html_trailer(); ?>