| Story | Created | Length"; if ($auth_username) { echo " | # Yours"; } echo " | Last Author\n"; while ($story = mysql_fetch_array($story_list)) { $story_id = $story['story_id']; $storylines = mysql_query("SELECT * FROM storylines WHERE story_id='$story_id' ORDER BY when_written DESC"); $line_count = mysql_num_rows($storylines); printf(" |
|---|---|---|---|---|
| %s", $story_id, $story['title']); // if ($auth_username) { // printf(" | ||||
| %s", // $story_id, $story['title']); // } else { // echo " | ||||
| ", $story['title']; // } printf(" | %s | %d", $story['created'], $line_count); if ($auth_username) { $user_id = $auth_user_info['user_id']; $your_lines = mysql_query("SELECT * FROM storylines WHERE story_id='$story_id' AND user_id='$user_id' ORDER BY when_written DESC"); $your_line_count = mysql_num_rows($your_lines); echo " | $your_line_count"; } if ($line_count > 0) { $last_line = mysql_fetch_array($storylines); $last_author_id = $last_line['user_id']; $last_author = mysql_query("SELECT * FROM users WHERE user_id='$last_author_id'"); $last_author_info = mysql_fetch_array($last_author); $last_author_name = $last_author_info['nickname']; echo " | $last_author_name\n"; } else { echo "\n"; } } echo " |
Finished stories:
\n"; $story_list = mysql_query("SELECT * FROM stories WHERE status!='open'"); echo "| Story | Closed | Length (lines)\n"; while ($story = mysql_fetch_array($story_list)) { $story_id = $story['story_id']; $storylines = mysql_query("SELECT * FROM storylines WHERE story_id='$story_id' ORDER BY when_written DESC"); $line_count = mysql_num_rows($storylines); printf(" |
|---|---|---|
| %s", $story_id, $story['title']); printf(" | %s | %d", $story['closed'], $line_count); } echo " |