cvs: php-bugs-web /scripts email-bug-summaries

philip Mon Jun 2 19:40:26 2008 UTC Modified files: /php-bugs-web/scripts email-bug-summaries Log: Explicit use of the MySQL connection, then close it before sending out emails http://cvs.php.net/viewvc.cgi/php-bugs-web/scripts/email-bug-summaries?r1=1.15&r2=1.16&diff_format=u Index: php-bugs-web/scripts/email-bug-summaries diff -u php-bugs-web/scripts/email-bug-summaries:1.15 php-bugs-web/scripts/email-bug-summaries:1.16 --- php-bugs-web/scripts/email-bug-summaries:1.15 Mon Jun 2 19:22:15 2008 +++ php-bugs-web/scripts/email-bug-summaries Mon Jun 2 19:40:26 2008 @@ -8,9 +8,9 @@ if (!in_array($version, array(4,5,6,'Irrelevant'))) { $version = '4'; } - mysql_connect("localhost","nobody","") or die("Unable to connect to SQL server\n"); - mysql_select_db("phpbugdb"); - $result = mysql_query("select id,bug_type,status,sdesc,assign from bugdb where status not in ('Closed', 'Bogus', 'Duplicate', 'No Feedback', 'Wont fix') and php_version like '$version%' order by bug_type,id"); + $conn = mysql_connect("localhost","nobody","") or die("Unable to connect to SQL server\n"); + mysql_select_db("phpbugdb", $conn); + $result = mysql_query("select id,bug_type,status,sdesc,assign from bugdb where status not in ('Closed', 'Bogus', 'Duplicate', 'No Feedback', 'Wont fix') and php_version like '$version%' order by bug_type,id", $conn); if (!is_numeric($version)) { $version = ''; } @@ -38,6 +38,8 @@ $body .= " ".$row['sdesc']."\n"; } mysql_free_result($result); + mysql_close($conn); + $body .= "\nAssigned bugs and feature requests (reminders sent):\n"; $body_header = " PHP $version Bug Database summary - http://bugs.php.net/\n\n";