svn: /web/php-bugs/trunk/scripts/cron/ email-assigned

philip Wed, 18 Aug 2010 16:54:47 +0000 Revision: http://svn.php.net/viewvc?view=revision&revision=302450 Log: Added all open-ish types of status, as we have assigned bugs with many different open status types. And added status to the email. Changed paths: U web/php-bugs/trunk/scripts/cron/email-assigned Modified: web/php-bugs/trunk/scripts/cron/email-assigned =================================================================== --- web/php-bugs/trunk/scripts/cron/email-assigned 2010-08-18 16:17:16 UTC (rev 302449) +++ web/php-bugs/trunk/scripts/cron/email-assigned 2010-08-18 16:54:47 UTC (rev 302450) @@ -3,11 +3,17 @@ require __DIR__ . '/../../include/prepend.php'; -// NOTE: We could adjust to email other combinations. Ex: assign is user 'foo', and status is 'Feedback' ... -$sql = "SELECT id, package_name, bug_type, sdesc, assign, UNIX_TIMESTAMP(ts1) AS ts_opened, UNIX_TIMESTAMP(ts2) AS ts_changed +/* + Many times bugs are assigned to humans but not given the 'Assigned' status. Our bug tracker + is a little odd that way. + And the only real 'debatable' status here is 'No Feedback', but people should take care of their + bugs. And because the 'No Feedback' status is given automatically by the tracker, there is + a good chance that most of these were simply forgotten. +*/ +$sql = "SELECT id, package_name, bug_type, sdesc, status, assign, UNIX_TIMESTAMP(ts1) AS ts_opened, UNIX_TIMESTAMP(ts2) AS ts_changed FROM bugdb WHERE length(assign) > 1 - AND status = 'Assigned' + AND status IN ('Assigned', 'Open', 'Re-Opened', 'Feedback', 'No Feedback', 'Analyzed', 'Verified', 'Critical', 'Suspended', 'To be documented') ORDER BY id"; $res = $dbh->query($sql); @@ -51,7 +57,7 @@ $link_title = strlen($binfo['sdesc']) < 65 ? $binfo['sdesc'] : substr($binfo['sdesc'], 0, 65) . '...'; $links .= " Title: $link_title\r\n"; - $links .= " Type: {$binfo['bug_type']}\r\n"; + $links .= " Type: {$binfo['bug_type']} with Status: {$binfo['status']}\r\n"; $links .= " Link: http://bugs.php.net/{$binfo['id']}\r\n\r\n"; }