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

[nobody]

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

Submitted by: None                    Project: Savannah                     
Submitted on: Mon 09/08/03 at 07:49
Category:  Mail                       Severity:  5 - Average                
Priority:  None                       Resolution:  None                     
Assigned to:  None                    Status:  Open                         
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'));





No Followups Have Been Posted


CC list is empty


No files currently attached


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/