SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/games/xpilot-ng/distinfo'
			   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/games/xpilot-ng/distinfo'
   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/games/xpilot-ng/distinfo

SVNWeb

Number of commits found: 6

Sun, 15 May 2005

[ 01:17 jylefort ]   1.8 games/xpilot-ng-client/Makefile 1.6 games/xpilot-ng-client/distinfo 1.3 games/xpilot-ng-client/pkg-descr 1.6 games/xpilot-ng-client/pkg-plist 1.8 games/xpilot-ng-server/Makefile 1.6 games/xpilot-ng-server/distinfo 1.3 games/xpilot-ng-server/pkg-descr 1.1 games/xpilot-ng-server/pkg-descr.client 1.1 games/xpilot-ng-server/pkg-descr.server 1.6 games/xpilot-ng-server/pkg-plist (Only the first 10 of 16 ports in this commit are shown above. ) - Split into -client and -server - Update to 4.7.1 PR: ports/66762 Submitted by: myself

Sun, 2 May 2004

[ 04:41 petef ]   1.6 games/xpilot-ng/Makefile 1.5 games/xpilot-ng/distinfo 1.2 games/xpilot-ng/files/patch-aa 1.2 games/xpilot-ng/files/patch-ba 1.2 games/xpilot-ng/files/patch-ca 1.2 games/xpilot-ng/files/patch-da 1.2 games/xpilot-ng/files/patch-ea 1.5 games/xpilot-ng/pkg-plist - update to 4.6.4 - move to sourceforge - add OPTIONS support for SDL PR: 66002 Submitted by: maintainer

Wed, 31 Mar 2004

[ 03:12 trevor ]   1.11 archivers/bzip2/distinfo 1.2 archivers/deepforest/distinfo 1.2 archivers/freeze/distinfo 1.3 archivers/lbrate/distinfo 1.2 archivers/mtf/distinfo 1.3 archivers/szip/distinfo 1.2 archivers/unadf/distinfo 1.3 archivers/wzip/distinfo 1.2 archivers/xdms/distinfo 1.3 astro/SETIsupport/distinfo (Only the first 10 of 3024 ports in this commit are shown above. ) SIZEify (maintainer timeout)

Sun, 16 Nov 2003

[ 16:35 linimon ]   1.3 games/xpilot-ng/distinfo Forced commit to state that the diff between the previous version and this one have primarily to do with documentation improvements and fixes for various non-FreeBSD OSes. There are a handful of minor code improvements for speed and a new weapon or two. Reminded by: kris.

Sat, 15 Nov 2003

[ 12:34 linimon ]   1.3 games/xpilot-ng/Makefile 1.2 games/xpilot-ng/distinfo 1.2 games/xpilot-ng/pkg-plist From the maintainer: "The program maintainer mailed me that he changed the dist tarball in place. Here's the new checksum." While here, update the plist. PR: ports/59235.

Sun, 28 Sep 2003

[ 12:03 edwin ]   1.584 games/Makefile 1.1 games/xpilot-ng/Makefile 1.1 games/xpilot-ng/distinfo 1.1 games/xpilot-ng/files/patch-aa 1.1 games/xpilot-ng/files/patch-ba 1.1 games/xpilot-ng/files/patch-ca 1.1 games/xpilot-ng/files/patch-da 1.1 games/xpilot-ng/pkg-descr 1.1 games/xpilot-ng/pkg-plist New port: games/xpilot-ng An enhanced version of games/xpilot. The two ports won't conflict, as I made this one use the -ng suffix. PR: ports/56690 Submitted by: Jean-Yves Lefort <jylefort@brutele.be>

Number of commits found: 6