[Savannah-dev] [bug #5131] empty project_name in patch_mail

[nobody]

=================== BUG #5131: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5131&group_id=11

Changes by: Mathieu Roy <address@hidden>
Date: lun 08.09.2003 à 15:43 (Europe/Paris)

            What     | Removed                   | Added
---------------------------------------------------------------------------
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This tracker will be  replaced soon.



=================== BUG #5131: FULL BUG SNAPSHOT ===================


Soumis par: None                      Projet: Savannah                      
Signalé le: lun 08.09.2003 à 13:49
Category:  Mail                       Severity:  5 - Average                
Priority:  None                       Resolution:  Wont Fix                 
Assigned to:  yeupou                  Status:  Closed                       
Fixed Release:                        

Summary:  empty project_name in patch_mail

Original Submission:  The sql-Statement in file "patch/patch_utils.php" in 
"mail_followup" is wrong.

The variable project_name is not set in the sql-Statement.

----------------- look at the source code ----------

function mail_followup($patch_id,$more_addresses=false) {

        global $sys_datefmt,$feedback;

        /*



                Send a message to the person who opened this patch and the 
person it is assigned to



                Accepts the unique id of a patch and optionally a list of 
additional addresses to send to



        */



        $sql="SELECT 
patch.group_id,patch.patch_id,patch.summary,groups.unix_group_name,".

                "patch_status.status_name,patch_category.category_name, ".

                "user.email,user2.email AS assigned_to_email ".

                "FROM patch,user,user user2,groups,patch_category,patch_status 
".

                "WHERE user2.user_id=patch.assigned_to ".

                "AND patch.patch_status_id=patch_status.patch_status_id ".

                "AND patch.patch_category_id=patch_category.patch_category_id ".

                "AND user.user_id=patch.submitted_by ".

                "AND patch.patch_id='$patch_id'";



        $result=db_query($sql);



        if ($result && db_numrows($result) > 0) {



                $body = "Patch #".db_result($result,0,"patch_id")." has been 
updated. ".

                        "nnProject: ".db_result($result,0,'project_name').

                        "nCategory: ".db_result($result,0,'category_name').

                        "nStatus: ".db_result($result,0,'status_name').

                        "nSummary: 
".util_unconvert_htmlspecialchars(db_result($result,0,'summary'));



Follow-up Comments
*******************

-------------------------------------------------------
Date: lun 08.09.2003 à 15:43        By: yeupou
This tracker will be  replaced soon.

-------------------------------------------------------
Date: lun 08.09.2003 à 15:42        By: yeupou
This tracker will be replaced soon.


La liste CC est vide


Il n'y a aucun fichier attaché actuellement


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5131&group_id=11

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/