SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/mail/dbmail/files/patch-src_clientbase.c'
			   AND EP.element_id = CLE.element_ID
			   AND CL.id         = CLE.commit_log_id

		SELECT DISTINCT
			CL.commit_date - SystemTimeAdjust()                                                                 AS commit_date_raw,
			CL.id                                                                                               AS commit_log_id,
			CL.encoding_losses                                                                                  AS encoding_losses,
			CL.message_id                                                                                       AS message_id,
			CL.committer                                                                                        AS committer,
			CL.description                                                                                      AS commit_description,
			to_char(CL.commit_date - SystemTimeAdjust(), 'DD Mon YYYY')                                         AS commit_date,
			to_char(CL.commit_date - SystemTimeAdjust(), 'HH24:MI')                                             AS commit_time,
			element.name                                                                                                AS port,
			element_pathname(element.id)                                                                                AS pathname,
			element.status                                                                                              AS status,
			element_pathname.pathname                            as element_pathname,
			CL.message_subject,
			NULL AS port_id,
			0    AS needs_refresh,
			NULL AS forbidden,
			NULL AS broken,
			NULL AS deprecated,
			NULL AS ignore,
			commit_log_elements.element_id,
			NULL AS version,
			NULL AS epoch,
			NULL as date_added,
			NULL AS short_description,
			NULL AS category_id,
			NULL AS category,
			NULL AS watch,
			NULL AS vulnerable_current,
			NULL AS vulnerable_past,
			NULL AS restricted,
			NULL AS no_cdrom,
			NULL AS expiration_date,
			NULL AS is_interactive,
			NULL AS only_for_archs,
			NULL AS not_for_archs,
			NULL AS stf_message,
			commit_log_elements.revision_name as revision,
			R.name         AS repo_name,
			R.svn_hostname AS hostname,
			R.path_to_repo AS path_to_repo 
    FROM commit_log_elements, commit_log CL LEFT OUTER JOIN repo R on  CL.repo_id = R.id, element_pathname, element 
	  WHERE CL.id IN (SELECT tmp.ID FROM (SELECT DISTINCT CL.id, CL.commit_date
  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
 WHERE EP.pathname   = '/ports/head/mail/dbmail/files/patch-src_clientbase.c'
   AND EP.element_id = CLE.element_ID
   AND CL.id         = CLE.commit_log_id
ORDER BY CL.commit_date DESC 
LIMIT 100) AS tmp)
	    AND commit_log_elements.commit_log_id = CL.id
	    AND commit_log_elements.element_id    = element.id
        AND element_pathname.element_id       = element.id
   ORDER BY 1 desc,
			commit_log_id, element_pathname

non port: head/mail/dbmail/files/patch-src_clientbase.c

SVNWeb

Number of commits found: 3

Sun, 24 Aug 2014

[ 17:00 adamw ]   365968 mail/dbmail/Makefile 365968 mail/dbmail/distinfo 365968 mail/dbmail/files/extra-patch-acinclude.m4 365968 mail/dbmail/files/patch-acinclude.m4 365968 mail/dbmail/files/patch-src_clientbase.c 365968 mail/dbmail/pkg-plist Upgrade mail/dbmail to 3.2.0 3.2.0 contains all the stability improvements done in 3.1 over the last year. On top of that, it has some nice additions of it's own: - auto-migrations; An admittedly little tested feature is automatic migrations of the database schema. Running any of the binaries against an up-to-date and standard 3.1 schema will try to do all the necessary upgrades if required. - static code audit; the Coverity service was used to flush out as many potential problems as possible. - new capabilities; some interesting new IMAP capabilities have been added. QRESYNC (rfc5162), LITERAL+ (rfc2088), UIDPLUS (rfc4315) will improve performance especially for mobile clients. Also: - Remove redundant option THREADS - Add additional mirror - Rework post-install for auto-migration scripts - Use @sample framework PR: 192967 Submitted by: maintainer

Thu, 25 Jul 2013

[ 19:58 wg ]   323664 mail/dbmail/Makefile 323664 mail/dbmail/distinfo 323664 mail/dbmail/files/extra-patch-acinclude.m4 323664 mail/dbmail/files/extra-patch-configure 323664 mail/dbmail/files/patch-acinclude.m4 323664 mail/dbmail/files/patch-src_clientbase.c 323664 mail/dbmail/files/patch-src_dbmail.h.in 323664 mail/dbmail/pkg-plist mail/dbmail: update to 3.1.1 - Update to 3.1.1 [1] - Remove leading article from COMMENT Check share/doc/dbmail/UPGRADING for upgrading details. Changes: http://git.dbmail.eu/paul/dbmail/log/ PR: ports/180768 Submitted by: Alan Hicks <ahicks p-o.co.uk> (maintainer)

Sun, 24 Jun 2012

[ 19:19 beech ]   1.51 mail/dbmail/Makefile 1.2 mail/dbmail/files/dbmail-timsieved.in 1.1 mail/dbmail/files/patch-src_clientbase.c - Fix error connecting from ipv6 address. - Also fix typo in timsieved rc script and updated from bsd.ports.[pre|post].mk to bsd.ports.mk - Bump PORTEVISION PR: ports/169268 Submitted by: Alan Hicks <ahicks@p-o.co.uk> (maintainer)

Number of commits found: 3