SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/irc/bitchx/files/patch-amd64_fix'
			   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/irc/bitchx/files/patch-amd64_fix'
   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/irc/bitchx/files/patch-amd64_fix

SVNWeb

Number of commits found: 4

Fri, 31 May 2013

[ 09:48 crees ]   319475 irc/bitchx/Makefile 319475 irc/bitchx/distinfo 319475 irc/bitchx/files/patch-amd64_fix 319475 irc/bitchx/files/patch-ap 319475 irc/bitchx/files/patch-aq 319475 irc/bitchx/files/patch-configure 319475 irc/bitchx/files/patch-source_gcc_fix 319475 irc/bitchx/files/patch-source_server_c 319475 irc/bitchx/pkg-plist Update to 1.2 The release is finally here! Add vulnerabilities to vuxml, and remove bitchx-devel Approved by: Dan Mashal <dan.mashal@gmail.com> (maintainer) Security: CVE-2007-4584 Security: CVE-2007-5839 Security: CVE-2007-5922

Mon, 19 Nov 2012

[ 04:01 wxs ]   307552 irc/Makefile 307552 irc/bitchx-devel 307552 irc/bitchx-devel/Makefile 307552 irc/bitchx-devel/files/patch-configure 307552 irc/bitchx/Makefile 307552 irc/bitchx/distinfo 307552 irc/bitchx/files/patch-amd64_fix 307552 irc/bitchx/files/patch-ap 307552 irc/bitchx/files/patch-aq 307552 irc/bitchx/files/patch-configure (Only the first 10 of 13 ports in this commit are shown above. ) Copy irc/bitchx to irc/bitchx-devel and attach to the build. Revert irc/bitchx back to 1.1.0.1. Set LATEST_LINK for irc/bitchx-devel appropriately. PR: ports/172294, ports/172295 Submitted by: Chris Petrik <c.petrik.sosa@gmail.com> (maintainer) Feature safe: yes

Sun, 16 Sep 2012

[ 14:16 danfe ]   304350 irc/bitchx/Makefile 304350 irc/bitchx/distinfo 304350 irc/bitchx/files/patch-amd64_fix 304350 irc/bitchx/files/patch-ap 304350 irc/bitchx/files/patch-aq 304350 irc/bitchx/files/patch-configure 304350 irc/bitchx/files/patch-funny.c 304350 irc/bitchx/files/patch-source_gcc_fix 304350 irc/bitchx/files/patch-source_server_c 304350 irc/bitchx/pkg-plist BitchX, an ass-kicking IRC client, is out of limbo and back on the track! - Update to version 1.2; project was moved to GitHub - Convert to new OPTIONS framework; simplify features handling logic - Enable IPv6 and SSL by default to catch up with new era - Ditto for plugins that do not require external dependencies - Drop hard-coded ABI shlib version numbers in LIB_DEPENDS - Remove obsolete patches [1, 2] and cleanup Makefile while I am here - Utilize DOCSDIR for smarter handling of documentation (and thus greatly offload pkg-plist) - Give maintainership back to Chris Petrik per his request: he is part of the developer team and has time to look after the port again) PR: ports/163555 (audit trail) [1] ports/170409 (remove patch-funny.c) [2] Submitted by: Chris Petrik (last follow-up) [1] Gary Stanley [2]

Thu, 3 Jul 2008

[ 00:21 beech ]   1.91 irc/bitchx/Makefile 1.1 irc/bitchx/files/patch-amd64_fix - Add patch to fix core dump issue on amd64 - Bump portrevision PR: ports/125108 Submitted by: Chris Pet <chrispetso@gmail.com>

Number of commits found: 4