MyDynaWeb CVS: htdocs sukria

[mdw c. <myd...@li...>]

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : htdocs

Dir     : mydynaweb/htdocs


Modified Files:
	comment.php news.php set_session.php 


Log Message:
Adding the thread concept in the comments
we are close to forum aren't we ? ;-)



===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/comment.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -3 -r1.17 -r1.18
--- comment.php	19 Feb 2002 17:32:56 -0000	1.17
+++ comment.php	19 Feb 2002 18:37:31 -0000	1.18
@@ -35,6 +35,15 @@
 $row2 = $rqt2->getrow();
 $num_comments = $row2[0]; 
 
+////////////////////////////////////////////////////////////////////////
+// the comments related to that piece of news
+
+// Step 1 : init stuff
+$msg_infos = read_messages($DBH, $news);
+$get_message = $msg_infos[0];
+$get_parents = $msg_infos[1];
+$get_children = $msg_infos[2];
+
 // here we can increase the hit number
 $row[nbhit]++;
 $sql = ("UPDATE news set nbhit=".$row[nbhit]." where num_news = $row[0]");
@@ -45,7 +54,7 @@
 $PAGE .= "";
 
 $PAGE .= get_piece_of_news($row[1], '<P>' . $row['texte'] . '<br><br>' .
-$row['long_text'], $row[4], translate($row[5],$DBH), "news.php?q=$row[6]", $row[nbhit], $row[0], $row2[0], strlen($row['long_text']) * 8, $DBH);
+$row['long_text'], $row[4], translate($row[5],$DBH), "news.php?q=$row[6]", $row[nbhit], $row[0], $row2[0], strlen($row['long_text']) * 8, sizeof($get_parents), $DBH);
 
 
 
@@ -58,19 +67,10 @@
 <p>";
 
 
-////////////////////////////////////////////////////////////////////////
-// the comments related to that piece of news
-
-// Step 1 : init stuff
-$msg_infos = read_messages($DBH, $news);
-$get_message = $msg_infos[0];
-$get_parents = $msg_infos[1];
-$get_children = $msg_infos[2];
-
 $PAGE .= "<table width='100%'>";
 
 if (sizeof($get_parents)) {
-	$PAGE .= "<tr><td><b>$num_comments " . translate("COMMENTS", $DBH). " : </b></td></tr>";
+	$PAGE .= "<tr><td><b>$num_comments " . translate("COMMENTS", $DBH). " / ".sizeof($get_parents)." ". translate('THREADS', $DBH)." </b></td></tr>";
 }
 
 // Step 2 : print out the threads
@@ -85,7 +85,7 @@
 ////////////////////////////////////////////////////////////////////////
 
 
-$CONTENT = get_page("<h2>$news_titre</h2>", $info, $PAGE, $DBH);
+$CONTENT = get_page("<h3>$news_titre</h3>", $info, $PAGE, $DBH);
 
 print_template(THEMES_PATH."/main.html", $CONTENT, $row[1], $DBH,"COMMENT.$news", $REMOTE_ADDR, $HTTP_REFERER, $MSG, 10, 50);
 }
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/news.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -3 -r1.6 -r1.7
--- news.php	6 Feb 2002 14:08:18 -0000	1.6
+++ news.php	19 Feb 2002 18:37:32 -0000	1.7
@@ -179,7 +179,15 @@
       $rqt2->query($DBH, $sql);
       $row2 = $rqt2->getrow();
 
-   $HTML = get_piece_of_news($full_title, ($full_header . '<br>' . $full_page), $row[4], $row[5], "news.php?q=$row[6]", $row[nbhit], $row[0], $row2[0], strlen($full_page), $DBH);
+      $sql = "select * from comments
+              where _num_news = $row[0]
+	      and pere=0";
+      $rqtcm = new query($DBH);
+      $rqtcm->query($DBH, $sql);
+      $nbthreads = $rqtcm->numrows();
+
+
+   $HTML = get_piece_of_news($full_title, ($full_header . '<br>' . $full_page), $row[4], $row[5], "news.php?q=$row[6]", $row[nbhit], $row[0], $row2[0], strlen($full_page), $nbthreads, $DBH);
 	print_template(THEMES_PATH."/main.html", $HTML, translate("NEWS",$DBH),
 	$DBH,"NEWS.$q.$old.$num.$fam",$REMOTE_ADDR, $MSG, 10, 50);
     die();
@@ -214,6 +222,13 @@
       $rqtcm->query($DBH, $sql);
       $nbcmt = $rqtcm->numrows();
 
+      $sql = "select * from comments
+              where _num_news = $row[0]
+	      and pere=0";
+      $rqtcm = new query($DBH);
+      $rqtcm->query($DBH, $sql);
+      $nbthreads = $rqtcm->numrows();
+
 	/////////////////////////////////
 	// creation of the title
 
@@ -225,7 +240,7 @@
 
 	$news_title = $news_tt;
 
-      $PAGE .= get_piece_of_news($news_title, $intro, $row[4], $row[5], "news.php?q=$row[6]", $new_nbhit, $row[0], $nbcmt, strlen($row['long_text']), $DBH);
+      $PAGE .= get_piece_of_news($news_title, $intro, $row[4], $row[5], "news.php?q=$row[6]", $new_nbhit, $row[0], $nbcmt, strlen($row['long_text']),$nbthreads,  $DBH);
 	  $PAGE .= "<p>&nbsp;</p>\n";
   }
 
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/set_session.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -3 -r1.1 -r1.2
--- set_session.php	8 Nov 2001 03:11:12 -0000	1.1
+++ set_session.php	19 Feb 2002 18:37:32 -0000	1.2
@@ -2,6 +2,11 @@
 include("include/mydynaweb.init.php");
 include("include/mydynaweb.libs.php");
 
+if ($user == 'guest') {
+	header("Location: guest.php");
+	die();
+}
+
 $DBH=new db();
 $DBH->open($dbName, $dbServer, $dbUser, $dbPass);