[phpwebapp-commits] CVS: top10/templates/proj_details/comments comments.php,1.4,1.5 comments.js,1.3,1.4 comments.db,1.4,1.5

[Dashamir H. <das...@us...>]

Update of /cvsroot/phpwebapp/top10/templates/proj_details/comments
In directory sc8-pr-cvs1:/tmp/cvs-serv15358/templates/proj_details/comments

Modified Files:
	comments.php comments.js comments.db 
Log Message:
keep comment count up to date


Index: comments.php
===================================================================
RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/comments/comments.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** comments.php	29 Dec 2003 14:59:40 -0000	1.4
--- comments.php	29 Dec 2003 15:56:37 -0000	1.5
***************
*** 11,15 ****
--- 11,26 ----
        $params["date"] = date("Y-m-d");
        $params["ip"] = $_SERVER["REMOTE_ADDR"];
+       //add the comment record
        WebApp::execDBCmd("insert_comment", $params);
+ 
+       $this->update_comment_count();
+     }
+ 
+   function update_comment_count()
+     {
+       //update the comment count of the project
+       $rs = WebApp::openRS("comment_list");
+       $nr_comments = $rs->count;
+       WebApp::execDBCmd("update_comment_count", compact("nr_comments"));
      }
  
***************
*** 19,22 ****
--- 30,34 ----
          {
            WebApp::execDBCmd("delete_comment", $event_args);
+           $this->update_comment_count();
            return;
          }

Index: comments.js
===================================================================
RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/comments/comments.js,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** comments.js	29 Dec 2003 14:59:40 -0000	1.3
--- comments.js	29 Dec 2003 15:56:37 -0000	1.4
***************
*** 28,32 ****
      + "title=" + title + ";"
      + "comment=" + comment;
!   alert(event_args);
    SendEvent("comments", "add_comment", event_args);
  }
--- 28,32 ----
      + "title=" + title + ";"
      + "comment=" + comment;
! 
    SendEvent("comments", "add_comment", event_args);
  }

Index: comments.db
===================================================================
RCS file: /cvsroot/phpwebapp/top10/templates/proj_details/comments/comments.db,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** comments.db	29 Dec 2003 14:59:40 -0000	1.4
--- comments.db	29 Dec 2003 15:56:37 -0000	1.5
***************
*** 29,32 ****
--- 29,40 ----
  </dbCommand>
  
+ <dbCommand ID="update_comment_count">
+   <Query>
+     UPDATE proj_list
+     SET    nr_comments = '{{nr_comments}}'
+     WHERE  proj_id = '{{proj_id}}'
+   </Query>
+ </dbCommand>
+ 
  <Recordset ID="get_comment">
    <Query>