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

SVNWeb

Number of commits found: 7

Thu, 17 Jul 2014

[ 08:57 olgeni ]   362126 ports-mgmt/bpm/Makefile 362126 ports-mgmt/bxpkg/Makefile 362126 ports-mgmt/pkg_search/Makefile 362126 ports-mgmt/porteasy/Makefile 362126 ports-mgmt/portscout/Makefile 362126 print/bibcursed/Makefile 362126 print/c2ps/Makefile 362126 print/dvi2tty/Makefile 362126 print/fpdf/Makefile 362126 print/freetype/Makefile (Only the first 10 of 206 ports in this commit are shown above. ) Remove indefinite articles and trailing periods from COMMENT, plus minor COMMENT typos and surrounding whitespace fixes. A few Makefiles where not included as they contain Latin-1 characters that break the Phabricator workflow. Categories P-S. CR: D422 Approved by: portmgr (bapt)

Mon, 14 Jul 2014

[ 18:42 bapt ]   361812 math/givaro/Makefile 361812 math/gmp-ecm/Makefile 361812 math/igraph/Makefile 361812 math/lapack95/Makefile 361812 math/ocamlgsl/Makefile 361812 math/octave-forge-dicom/Makefile 361812 math/octave-forge-gsl/Makefile 361812 math/octave-forge-ltfat/Makefile 361812 math/octave-forge-octproj/Makefile 361812 math/octave-forge-symbolic/Makefile (Only the first 10 of 280 ports in this commit are shown above. ) Modernize LIB_DEPENDS With hat: portmgr

Fri, 4 Jul 2014

[ 12:46 bapt ]   360609 security/arpCounterattack/Makefile 360609 security/bioapi/Makefile 360609 security/courierpassd/Makefile 360609 security/courierpasswd/Makefile 360609 security/courieruserinfo/Makefile 360609 security/cracklib/Makefile 360609 security/cvm/Makefile 360609 security/distcache-devel/Makefile 360609 security/distcache/Makefile 360609 security/dmitry/Makefile (Only the first 10 of 67 ports in this commit are shown above. ) Resetting maintainership on ports that have not been staged and without any pending PR (related to stage) With hat: portmgr

Mon, 26 May 2014

[ 12:50 miwi ]   355321 security/aide/Makefile 355321 security/clamsmtp/Makefile 355321 security/courierpassd/Makefile 355321 security/doscan/Makefile 355321 security/fwbuilder/Makefile 355321 security/gpasman/Makefile 355321 security/libprelude/Makefile 355321 security/libpreludedb/Makefile 355321 security/libtomcrypt/Makefile 355321 security/lsh/Makefile (Only the first 10 of 31 ports in this commit are shown above. ) - Convert gmake, bzip2 to USES Approved by: portmgr

Fri, 20 Sep 2013

[ 22:55 bapt ]   327769 security/ADMsmb/Makefile 327769 security/ADMsnmp/Makefile 327769 security/R-cran-ROAuth/Makefile 327769 security/R-cran-digest/Makefile 327769 security/aescrypt/Makefile 327769 security/aespipe/Makefile 327769 security/afterglow/Makefile 327769 security/aide/Makefile 327769 security/aimsniff/Makefile 327769 security/amap/Makefile (Only the first 10 of 1016 ports in this commit are shown above. ) Add NO_STAGE all over the place in preparation for the staging support (cat: security)

Sat, 22 Jun 2013

[ 09:36 rene ]   321559 security/scannedonly/Makefile 321559 security/scannedonly/pkg-message - Remove conditional code for net/samba34, it was removed on 2013-06-04 - Convert Makefile header - Fix typo in pkg-message PR: ports/179279 Submitted by: myself Approved by: maintainer timeout (girald@etcom.ufrgs.br, 19 days)

Thu, 1 Dec 2011

[ 20:01 crees ]   1.1232 security/Makefile 1.1 security/scannedonly/Makefile 1.1 security/scannedonly/distinfo 1.1 security/scannedonly/files/scannedonly.in 1.1 security/scannedonly/pkg-descr 1.1 security/scannedonly/pkg-message Scannedonly is a samba VFS module and a scanning daemon that ensure that only files that have been scanned for viruses are visible and accessible to the end user. Scannedonly was developed because of scalability problems with samba-vscan: high server loads when (the same) files were requested often, and timeouts when large zip files were requested. Scannedonly doesn't have these problems, but it does introduce some other issues. Choose the product that suits you best. Scannedonly is available under the open source GPL licence. The source code repository is available on Sourceforge. WWW: http://olivier.sessink.nl/scannedonly/ PR: ports/154202 Submitted by: girald@etcom.ufrgs.br Feature safe: yes

Number of commits found: 7