diff options
| author | mkanat%kerio.com <> | 2005-02-25 08:37:47 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-02-25 08:37:47 +0100 |
| commit | 63dde60072374b2f7ef2f756d4ab9dff66669793 (patch) | |
| tree | 294b30fddd43508bc9fa4d8c3c540ac4bbcd3c8c /Bugzilla/Attachment.pm | |
| parent | 32882b6e3513fa69185ea5b3d115e70b69ea5362 (diff) | |
| download | bugzilla-63dde60072374b2f7ef2f756d4ab9dff66669793.tar.gz bugzilla-63dde60072374b2f7ef2f756d4ab9dff66669793.tar.xz | |
Bug 280500: Replace "DATE_FORMAT()" with Bugzilla::DB function call
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=myk
Diffstat (limited to 'Bugzilla/Attachment.pm')
| -rw-r--r-- | Bugzilla/Attachment.pm | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/Bugzilla/Attachment.pm b/Bugzilla/Attachment.pm index 5f491f315..8be92dcf2 100644 --- a/Bugzilla/Attachment.pm +++ b/Bugzilla/Attachment.pm @@ -67,6 +67,8 @@ sub query # "attachments" variable. my ($bugid) = @_; + my $dbh = Bugzilla->dbh; + my $in_editbugs = &::UserInGroup("editbugs"); &::SendSQL("SELECT product_id FROM bugs @@ -76,9 +78,9 @@ sub query # Retrieve a list of attachments for this bug and write them into an array # of hashes in which each hash represents a single attachment. - &::SendSQL(" - SELECT attach_id, DATE_FORMAT(creation_ts, '%Y.%m.%d %H:%i'), - mimetype, description, ispatch, isobsolete, isprivate, + &::SendSQL("SELECT attach_id, " . + $dbh->sql_date_format('creation_ts', '%Y.%m.%d %H:%i') . + ", mimetype, description, ispatch, isobsolete, isprivate, submitter_id, LENGTH(thedata) FROM attachments WHERE bug_id = $bugid ORDER BY attach_id "); |