Exquisite Story List

Open Stories:

\n"; $story_list = mysql_query("SELECT * FROM stories WHERE status='open' ORDER BY created"); echo "\n"; echo "
StoryCreatedLength"; 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 "
\n"; if ($auth_username) { echo "

Start a new story

"; } echo "

Finished stories:

\n"; $story_list = mysql_query("SELECT * FROM stories WHERE status!='open'"); echo "\n"; echo "
StoryClosedLength (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 "
\n"; ?>

Return to Exquisite Main