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

SVNWeb

Number of commits found: 8

Wed, 23 Jul 2014

[ 16:44 bapt ]   362705 benchmarks/himenobench/Makefile 362705 benchmarks/spec-sfs/Makefile 362705 biology/crux/Makefile 362705 biology/embassy/Makefile 362705 biology/p5-bioperl-run/Makefile 362705 biology/phd2fasta/Makefile 362705 biology/protomol/Makefile 362705 biology/pymol/Makefile 362705 cad/alliance/Makefile 362705 cad/cider/Makefile (Only the first 10 of 55 ports in this commit are shown above. ) Reset maintainership for ports not staged with no pending PR With hat: portmgr

Mon, 9 Jun 2014

[ 11:21 olgeni ]   357139 archivers/file-roller/Makefile 357139 astro/ephem/Makefile 357139 astro/gpsman/Makefile 357139 astro/josm/Makefile 357139 astro/p5-ZConf-Weather/Makefile 357139 astro/wmspaceweather/Makefile 357139 astro/xephem/Makefile 357139 audio/ampache/Makefile 357139 audio/beets/Makefile 357139 audio/cdparanoia/Makefile (Only the first 10 of 120 ports in this commit are shown above. ) Remove indefinite articles and trailing periods from COMMENT, plus minor COMMENT typos and surrounding whitespace fixes. Categories A-C. CR: D196 Approved by: portmgr (bapt)

Sat, 10 May 2014

[ 18:07 antoine ]   353593 biology/consed/Makefile 353593 biology/phd2fasta/Makefile 353593 biology/phrap/Makefile 353593 biology/phred/Makefile Replace maintainer's email address with one that seems to work With hat: portmgr

Fri, 3 Jan 2014

[ 15:46 adamw ]   338550 biology/biojava/Makefile 338550 biology/blast/Makefile 338550 biology/consed/Makefile 338550 biology/finchtv/Makefile 338550 biology/mafft/Makefile 338550 biology/mummer/Makefile 338550 biology/njplot/Makefile 338550 biology/p5-bioperl-run/Makefile 338550 biology/p5-bioperl/Makefile 338550 biology/paml/Makefile (Only the first 10 of 14 ports in this commit are shown above. ) Convert biology to MDOCS and MEXAMPLES

Fri, 20 Sep 2013

[ 15:55 bapt ]   327709 biology/ariadne/Makefile 327709 biology/artemis/Makefile 327709 biology/avida/Makefile 327709 biology/babel/Makefile 327709 biology/biococoa/Makefile 327709 biology/biojava/Makefile 327709 biology/blast/Makefile 327709 biology/blat/Makefile 327709 biology/boinc-simap/Makefile 327709 biology/chemeq/Makefile (Only the first 10 of 94 ports in this commit are shown above. ) Add NO_STAGE all over the place in preparation for the staging support (cat: biology)

Fri, 26 Apr 2013

[ 16:23 bdrewery ]   316622 biology/phd2fasta/Makefile Remove unneeded escaping

Sun, 25 May 2008

[ 23:05 edwin ]   1.2 biology/consed/Makefile 1.2 biology/phd2fasta/Makefile 1.2 biology/phrap/Makefile 1.2 biology/phred/Makefile Teach the building cluster that these ports are not to be build

Sat, 24 May 2008

[ 07:01 edwin ]   1.99 biology/Makefile 1.1 biology/phd2fasta/Makefile 1.1 biology/phd2fasta/distinfo 1.1 biology/phd2fasta/files/patch-Makefile 1.1 biology/phd2fasta/pkg-descr New port: biology/consed viewing and editing workbench for sequence assembly Consed is a tool for viewing, editing, and finishing sequence assemblies. The port is constituted of 4 parts: biology/phred: base caller with quality evaluation biology/phrap: sequence assembler for shotgun sequencing biology/consed: workbench biology/phd2fasta: small utility All these can be used separately; however, most function of consed depends on the others. Although these programs are licensed freely for academic and nonprofit purposes, users have to contact the authors to get the softwares. Phred (including phd2fasta) and phrap are emailed, and consed can be downloaded to a restricted IP address. For commercial users, the licensing fee is ca. $10,000 at the time of writing. PR: ports/118548 Submitted by: Motomichi Matsuzaki <mzaki@biol.s.u-tokyo.ac.jp>

Number of commits found: 8