slugtalk-cvs Mailing List for SlugTalk

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/slugtalk/slugboards/slugtalk
In directory sc8-pr-cvs1:/tmp/cvs-serv5897

Modified Files:
	Slugboards.cs delete.aspx.cs 
Log Message:
More updates again! Deleting works now!

Index: Slugboards.cs
===================================================================
RCS file: /cvsroot/slugtalk/slugboards/slugtalk/Slugboards.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** Slugboards.cs	5 Jan 2004 11:54:13 -0000	1.1
--- Slugboards.cs	5 Jan 2004 12:23:05 -0000	1.2
***************
*** 211,215 ****
  
              HtmlCode += "\t<TR>\n";
!             if((short)Webpage.Session["Type"] == 2)
                  HtmlCode += "\t\t<TD width=\"1%\" bgcolor=#eeffff><A href=\"delete.aspx?TopicID=" + Topics.GetColumn("ID").ToString() + "\"><IMG src=\"bigX.gif\" border=0></A></TD>\n";
              else
--- 211,215 ----
  
              HtmlCode += "\t<TR>\n";
!             if((short)Webpage.Session["Type"] == 2 || (int)Boards.GetColumn("ModeratorID") == (int)Webpage.Session["ID"])
                  HtmlCode += "\t\t<TD width=\"1%\" bgcolor=#eeffff><A href=\"delete.aspx?TopicID=" + Topics.GetColumn("ID").ToString() + "\"><IMG src=\"bigX.gif\" border=0></A></TD>\n";
              else
***************
*** 296,304 ****
                  
              // Only display the delete button if the user posted the message or the user is an admin
!             if((int)Users.GetColumn("ID") == (int)Webpage.Session["ID"] || (short)Webpage.Session["Type"] == 2)
              {
                  HtmlCode += "\t\t<TD width=50% bgColor=#ffff99 align=right>";
                  HtmlCode += "<A href=\"user.aspx?UserID=" + Users.GetColumn("ID").ToString() + "\"><IMG src=\"userinfo.gif\" border=0></IMG></A>";
!                 HtmlCode += "<IMG src=\"delete.gif\"></IMG></TD>\n";
              }
              else
--- 296,305 ----
                  
              // Only display the delete button if the user posted the message or the user is an admin
!             if((int)Users.GetColumn("ID") == (int)Webpage.Session["ID"] || (short)Webpage.Session["Type"] == 2 ||
!                 (int)Boards.GetColumn("ModeratorID") == (int)Webpage.Session["ID"])
              {
                  HtmlCode += "\t\t<TD width=50% bgColor=#ffff99 align=right>";
                  HtmlCode += "<A href=\"user.aspx?UserID=" + Users.GetColumn("ID").ToString() + "\"><IMG src=\"userinfo.gif\" border=0></IMG></A>";
!                 HtmlCode += "<A href=\"delete.aspx?TopicID=" + TopicID + "&MessageID=" + MessageID + "\"><IMG src=\"delete.gif\" border=0></IMG></A></TD>\n";
              }
              else

Index: delete.aspx.cs
===================================================================
RCS file: /cvsroot/slugtalk/slugboards/slugtalk/delete.aspx.cs,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** delete.aspx.cs	5 Jan 2004 11:54:13 -0000	1.1
--- delete.aspx.cs	5 Jan 2004 12:23:05 -0000	1.2
***************
*** 151,155 ****
                  Response.Redirect("error.aspx?Message=Topic no longer exists");
  
!             if(!Boards.Read("SELECT * FROM Boards WHERE ID='" + Topics.GetColumn("BoardID").ToString() + "'"))
                  Response.Redirect("error.aspx?Message=Unknown error");
  
--- 151,157 ----
                  Response.Redirect("error.aspx?Message=Topic no longer exists");
  
!             string BoardID = Topics.GetColumn("BoardID").ToString();
! 
!             if(!Boards.Read("SELECT * FROM Boards WHERE ID='" + BoardID + "'"))
                  Response.Redirect("error.aspx?Message=Unknown error");
  
***************
*** 179,183 ****
              Boards.Update();
  
!             Response.Redirect("slugboards.aspx?BoardID=" + Topics.GetColumn("BoardID").ToString());
          }
  
--- 181,185 ----
              Boards.Update();
  
!             Response.Redirect("slugboards.aspx?BoardID=" + BoardID);
          }
  
***************
*** 189,192 ****
--- 191,291 ----
          private void DeleteMessage()
          {
+             bool RedirectToTopic = true;
+ 
+             EzSqlConnection SqlConn = new EzSqlConnection(this);
+ 
+             EzSqlTable Boards   = new EzSqlTable(SqlConn, "Boards", Server.MapPath("boards.xsd"));
+             EzSqlTable Topics   = new EzSqlTable(SqlConn, "Topics", Server.MapPath("topics.xsd"));
+             EzSqlTable Messages = new EzSqlTable(SqlConn, "Messages", Server.MapPath("messages.xsd"));
+ 
+             // First, read the topic and board from the database
+             if(!Topics.Read("SELECT * FROM Topics WHERE ID='" + TopicID + "'"))
+                 Response.Redirect("error.aspx?Message=Topic no longer exists");
+ 
+             string BoardID = Topics.GetColumn("BoardID").ToString();
+ 
+             if(!Boards.Read("SELECT * FROM Boards WHERE ID='" + BoardID + "'"))
+                 Response.Redirect("error.aspx?Message=Unknown error");
+ 
+             // Now, read in the message
+             if(!Messages.Read("SELECT * FROM Messages WHERE ID='" + MessageID + "'"))
+                 Response.Redirect("error.aspx?Message=Message no longer exists");
+ 
+             // First message?
+             if((long)Messages.GetColumn("PrevMessageID") == -1)
+             {
+                 // Only message in the topic
+                 if((long)Messages.GetColumn("NextMessageID") == -1)
+                 {
+                     // Delete the message and delete the topic
+                     Messages.Delete();
+                     Topics.Delete();
+                     Boards.SetColumn("Posts", (int)Boards.GetColumn("Posts") - 1);
+                     Boards.SetColumn("LastUpdate", DateTime.Now);
+                     RedirectToTopic = false;
+                 }
+                     // There are multiple messages, remove this message from the front
+                 else
+                 {
+                     long NextMessageID = (long)Messages.GetColumn("NextMessageID");
+                     
+                     Topics.SetColumn("FirstMessageID", NextMessageID);
+                     Topics.SetColumn("Replies", (int)Topics.GetColumn("Replies") - 1);
+                     Messages.Delete();
+                     Messages.Update();
+                     if(Messages.Read("SELECT * FROM Messages WHERE ID='" + NextMessageID + "'"))
+                     {
+                         Messages.SetColumn("PrevMessageID", -1);
+                     }
+                     Boards.SetColumn("LastUpdate", DateTime.Now);
+                 }
+             }
+             else
+             {
+                 // Last message
+                 if((long)Messages.GetColumn("NextMessageID") == -1)
+                 {
+                     long PrevMessageID = (long)Messages.GetColumn("PrevMessageID");
+                     
+                     Topics.SetColumn("LastMessageID", PrevMessageID);
+                     Topics.SetColumn("Replies", (int)Topics.GetColumn("Replies") - 1);
+                     Messages.Delete();
+                     Messages.Update();
+                     if(Messages.Read("SELECT * FROM Messages WHERE ID='" + PrevMessageID + "'"))
+                     {
+                         Messages.SetColumn("NextMessageID", -1);
+                     }
+                     Boards.SetColumn("LastUpdate", DateTime.Now);
+                 }
+                 // A message somewhere in the middle
+                 else
+                 {
+                     long PrevMessageID = (long)Messages.GetColumn("PrevMessageID"), 
+                          NextMessageID = (long)Messages.GetColumn("NextMessageID");
+ 
+                     Topics.SetColumn("Replies", (int)Topics.GetColumn("Replies") - 1);
+                     Messages.Delete();
+                     Messages.Update();
+                     if(Messages.Read("SELECT * FROM Messages WHERE ID='" + PrevMessageID + "'"))
+                     { 
+                         Messages.SetColumn("NextMessageID", NextMessageID);
+                         Messages.Update();
+                     }
+                     if(Messages.Read("SELECT * FROM Messages WHERE ID='" + NextMessageID + "'"))
+                     {
+                         Messages.SetColumn("PrevMessageID", PrevMessageID);
+                     }
+                 }
+             }
+ 
+             // Update the message the topic and the board with the changes
+             Messages.Update();
+             Topics.Update();
+             Boards.Update();
+ 
+             if(RedirectToTopic)
+                 Response.Redirect("slugboards.aspx?TopicID=" + TopicID);
+             else
+                 Response.Redirect("slugboards.aspx?BoardID=" + BoardID);
          }

2003	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (23)	Dec (2)
2004	Jan (7)	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec