My Little Scripts - forum-threads.php - PHP ASP Scripts, JavaScript, HTML

<?
function ShowThread($message_id, $level)
         {
         $select = "select date_format(time_stamp, '%W %M %d, %Y %l:%i  %p') as time_stamp, " .
                   "messages.id, guests.id as guests_id, body, topic, name from " .
                   "messages, guests where messages.guest_id = guests.id and reply_to_id ";
         if($message_id == null)
            //Thread starters have message_id set to null.
            $select .= "is null";
         else
            $select .= "= " . $message_id;

         $select .= " order by messages.time_stamp desc";

         $Messages = mysql_query($select);

         while($Message = mysql_fetch_assoc($Messages))
              {
              $new_post = param("new_post");

              if($new_post == "edit")
                {
                $id = param("id");
                if($id == $Message["id"])
                   //Passing the id of a message means it will be editted.
                   EditMessage($Message, $level);
                else
                   ShowMessage($Message, $level);
                }
              else
                ShowMessage($Message, $level);

              if($new_post == "reply")
                {
                $id = param("id");
                if($id == $Message["id"])
                   ReplyToMessage($Message, $level);
              }

              //Recursive call.
              ShowThread($Message["id"], $level + 1);
              }
         }

function ShowMessage($Message, $level)
         {
         $background_color = "#000000";
         if($level > 1)
            $background_color = "#555555";
         echo("<tr><td>");

         $new_post = param("new_post");
         if($new_post == "reply")
           {
           $id = param("id");
           if($id == $Message["id"])
              echo("<a name=\"reply\"></a>");
           }

         echo("<table width=\"100%\"><tr>");
         echo("<td>" . $Message["topic"] . "</td>");
         echo("<td align=\"right\">" . $Message["name"] . "    " . $Message["time_stamp"] . "</td>");
         echo("</tr></table>");
         echo("</td></tr>");

         echo("<tr><td>");
         echo("<table bgcolor=\"" . $background_color . "\" cellpadding=\"30\" width=\"100%\"><tr><td>");
         echo($Message["body"]);
         echo("</td></tr></table>");
         echo("</td></tr>");

         echo("<tr><td valign=\"top\" align=\"right\">");
         echo("<table><tr>");
         echo("<form method=\"post\">");
         echo("<td>");
         echo("<input type=\"hidden\" name=\"new_post\" value=\"edit\" />");
         echo("<input type=\"hidden\" name=\"id\" value=\"" . $Message["id"] . "\" />");
         echo("<input type=\"hidden\" name=\"guests_id\" value=\"" . $Message["guests_id"] . "\" />");
         echo("<td>");
         echo("<input type=\"submit\" value=\"edit\" /></td>");
         echo("</form>");
         if($level < 10)
           {
           echo("<form method=\"post\">");
           echo("<input type=\"hidden\" name=\"new_post\" value=\"reply\" />");
           echo("<input type=\"hidden\" name=\"id\" value=\"" . $Message["id"] . "\" />");
           echo("<input type=\"hidden\" name=\"guests_id\" value=\"" . $Message["guests_id"] . "\" />");
           echo("<td>");
           echo("<input type=\"submit\" value=\"reply\" /></td>");
           echo("</form>");
           }

         echo("</tr></table>");
         echo("</td></tr>");
         }

function EditMessage($Message, $level)
         {
         echo("<form name=\"edit\" method=\"post\" action=\"update.php\">");
         echo("<tr><td>");
         echo("<input type=\"hidden\" name=\"id\" value=\"" . $Message["id"] . "\" />");
         echo("<input type=\"hidden\" name=\"guests_id\" value=\"" . $Message["guests_id"] . "\" />");
         echo("<a name=\"edit\"></a>");
         echo("<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">");
         echo("<tr>");
         echo("<td rowspan=\"4\"><textarea name=\"body\" cols=\"80\" rows=\"10\">" . $Message["body"] . "</textarea></td>");
         echo("<td colspan=\"2\" align=\"right\" valign=\"top\">topic <input type=\"text\" name=\"topic\" value=\"" . $Message["topic"] . "\" /></td>");
         echo("</tr>");
         echo("<tr>");
         echo("<td colspan=\"2\" align=\"right\" valign=\"top\">guest name <input type=\"text\" name=\"name\" value=\"" . $Message["name"] . "\" /></td>");
         echo("</tr>");
         echo("<tr>");
         echo("<td colspan=\"2\" align=\"right\" valign=\"top\">password <input type=\"password\" name=\"p5ssw0rd\" /></td>");
         echo("</tr>");
         echo("<tr>");
         echo("<td align=\"right\" valign=\"bottom\"><input type=\"submit\" value=\"submit\" /></td>");
         echo("<td align=\"right\" valign=\"bottom\">");
         echo("<input type=\"button\" value=\"cancel\"");
         echo("onclick=\"document.edit.action = 'index.php';");
         echo("document.edit.submit();\" /></td>");
         echo("</tr>");
         echo("<tr><td>");
         echo("<br /><br /><br /><br />");
         echo("</td></tr>");
         echo("</table>");
         echo("</td></tr>");
         echo("</form>");
         }

function ReplyToMessage($Message, $level)
         {
         if($Message != null)
            $id =  $Message["id"];
         else
            $id = "";

         echo("<form name=\"reply\" method=\"post\" action=\"post.php\">");
         echo("<tr><td>");
         echo("<input type=\"hidden\" name=\"id\" value=\"" . $id . "\" />");
         echo("<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">");
         echo("<tr>");
         echo("<td rowspan=\"4\"><textarea name=\"body\" cols=\"80\" rows=\"10\"></textarea>></td>");
         echo("<td colspan=\"2\" align=\"right\" valign=\"top\">topic <input type=\"text\" name=\"topic\" /></td>");
         echo("</tr>");
         echo("<tr>");
         echo("<td colspan=\"2\" align=\"right\" valign=\"top\">guest name <input type=\"text\" name=\"name\" /></td>");
         echo("</tr>");
         echo("<tr>");
         echo("<td colspan=\"2\" align=\"right\" valign=\"top\">password <input type=\"password\" name=\"p5ssw0rd\" /></td>");
         echo("</tr>");
         echo("<tr>");
         echo("<td align=\"right\" valign=\"bottom\"><input type=\"submit\" value=\"submit\" /></td>");
         echo("<td align=\"right\" valign=\"bottom\">");
         echo("<input type=\"button\" value=\"cancel\"");
         echo("onclick=\"document.reply.action = 'index.php';");
         echo("document.reply.submit();\" /></td>");
         echo("</tr>");
         echo("<tr><td>");
         echo("<br /><br /><br /><br />");
         echo("</td></tr>");
         echo("</table>");
         echo("</td></tr>");
         echo("</form>");
         }
?>

create table guests
(
id int primary key auto_increment,
name varchar(255) not null,
email varchar(255),
p5ssw0rd varchar(255)
);

create table messages
(
id int primary key auto_increment,
guest_id int not null,
time_stamp datetime not null,
reply_to_id int,
topic varchar(255),
body text not null
);

FORUM_THREADS.PHP