SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/mail/bogofilter-tdb/Makefile'
			   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/bogofilter-tdb/Makefile'
   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/bogofilter-tdb/Makefile

SVNWeb

Number of commits found: 10

Sun, 28 Aug 2005

[ 22:52 linimon ]   1.675 mail/Makefile 1.10 mail/bogofilter-tdb/Makefile Remove mail/bogofilter-tdb. It was marked with an unusually long deprecation date several months ago. From the maintainer: The next (pending) update to the master port will drop TDB support in any case. A poll in the bogofilter@ mailing list didn't turn up with any FreeBSD bogofilter-tdb users. This was previously discussed with portmgr (linimon). PR: ports/85419 Submitted by: former maintainer

Mon, 30 May 2005

[ 10:48 yar ]   1.14 mail/bogofilter-qdbm/Makefile 1.2 mail/bogofilter-qdbm/files/patch-pathcycle 1.2 mail/bogofilter-sqlite/Makefile 1.9 mail/bogofilter-tdb/Makefile 1.57 mail/bogofilter/Makefile 1.40 mail/bogofilter/distinfo 1.2 mail/bogofilter/pkg-install - Update to 0.94.13 * iconv/unicode bugfixes * sqlite3 interface much more CPU efficient and faster now * bogofilter -q option to suppress printing of statistics (see share/doc/bogofilter/NEWS for details) - convert WITHOUT_*/pre-everything messaging stuff (GSL, BASH) to OPTIONS - add an OPTIONS switch for ICONV (experimental, default off), suggested by Yar Tikhiy. - revise pkg-install message - use a more suitable LIBS/CPPFLAGS passing for sibling ports or when GSL=off ICONV=on is used. - change wording of GSL OPTION. - reset -qdbm PORTREVISION - remove obsoleted bogofilter-qdbm/files/* patches - deprecate bogofilter-tdb effective 2005-11-30 Removed files: - bogofilter-qdbm/files/patch-pathcycle PR: ports/81642 Submitted by: maintainer

Thu, 26 May 2005

[ 12:07 pav ]   1.12 mail/bogofilter-qdbm/Makefile 1.8 mail/bogofilter-tdb/Makefile 1.56 mail/bogofilter/Makefile 1.4 russian/bogofilter/Makefile - Update CONFLICTS

Tue, 17 May 2005

[ 03:31 vanilla ]   1.10 mail/bogofilter-qdbm/Makefile 1.7 mail/bogofilter-tdb/Makefile 1.53 mail/bogofilter/Makefile Add CONFLICTS to bogofilter-current.

Thu, 14 Oct 2004

[ 08:06 krion ]   1.6 mail/bogofilter-tdb/Makefile Update CONFLICTS, fix portlint warnings. PR: ports/72672 Submitted by: maintainer

Fri, 18 Jun 2004

[ 14:25 yar ]   1.2 mail/bogofilter-qdbm/Makefile 1.5 mail/bogofilter-tdb/Makefile 1.38 mail/bogofilter/Makefile Prepare for committing a new sub-port russian/bogofilter (ru-bogofilter). Approved by: Matthias Andree (as maintainer)

Fri, 2 Jan 2004

[ 12:30 krion ]   1.4 mail/bogofilter-tdb/Makefile - Remove IGNORE, 0.15.13 is fine with TDB - Add CONFLICTS for bogofilter-qdbm. PR: 60812 Submitted by: maintainer

Sun, 2 Nov 2003

[ 18:13 krion ]   1.3 mail/bogofilter-tdb/Makefile - The TDB variant of bogofilter is currently broken, set it to IGNORE PR: 58837 Submitted by: maintainer

Tue, 2 Sep 2003

[ 19:05 obraun ]   1.2 mail/bogofilter-tdb/Makefile 1.25 mail/bogofilter/Makefile 1.23 mail/bogofilter/distinfo 1.7 mail/bogofilter/files/patch-aa * Upgrade to 0.14.5.4. * Add CONFLICTS bogofilter<->bogofilter-tdb PR: ports/56293 Submitted by: maintainer

Mon, 18 Aug 2003

[ 15:15 krion ]   1.413 mail/Makefile 1.1 mail/bogofilter-tdb/Makefile New bogofilter-tdb port, which is essentially the same as bogofilter, but linked against TDB (Trivial Database) rather than BerkeleyDB. PR: 55662 Submitted by: Matthias Andree <matthias.andree@web.de>

Number of commits found: 10