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

SVNWeb

Number of commits found: 4

Sat, 10 Feb 2007

[ 12:56 miwi ]   1.59 mail/mailscanner/Makefile 1.41 mail/mailscanner/distinfo 1.13 mail/mailscanner/files/CHANGES.port 1.1 mail/mailscanner/files/mailscanner.in 1.4 mail/mailscanner/files/mailscanner.sh.in 1.1 mail/mailscanner/files/mta.in 1.5 mail/mailscanner/files/mta.sh.in 1.33 mail/mailscanner/pkg-plist - Update to 4.58.9 PR: 108976 Submitted by: Jan-Peter Koopmann <j.koopmann@seceidos.de> (maintainer)

Mon, 20 Feb 2006

[ 20:47 dougb ]   1.2 audio/autocd/files/autocd.sh 1.5 audio/daapd/files/daapd.sh 1.2 audio/gnump3d/files/gnump3d.sh.in 1.3 audio/icecast2/files/icecast2.sh.in 1.2 audio/musicpd/files/musicpd.sh 1.4 audio/shoutcast/files/shoutcast.sh.in 1.6 audio/slimserver/files/slimserver.sh.in 1.2 comms/ltmdm/files/ltmdm.sh.in 1.2 comms/smstools/files/patch-bin_sms 1.2 comms/vpb-driver/files/vpb.sh.in (Only the first 10 of 267 ports in this commit are shown above. ) Remove the FreeBSD KEYWORD from all rc.d scripts where it appears. We have not checked for this KEYWORD for a long time now, so this is a complete noop, and thus no PORTREVISION bump. Removing it at this point is mostly for pedantic reasons, and partly to avoid perpetuating this anachronism by copy and paste to future scripts.

Thu, 16 Feb 2006

[ 16:34 sem ]   1.45 mail/mailscanner/Makefile 1.1 mail/mailscanner/files/CHANGES.port 1.4 mail/mailscanner/files/README.FreeBSD.port 1.2 mail/mailscanner/files/mailscanner.sh.in 1.1 mail/mailscanner/files/patch-bin:cron:update_phishing_sites.cron 1.1 mail/mailscanner/files/patch-bin:cron:update_virus_scanners.cron 1.2 mail/mailscanner/files/pkg-message.in 1.2 mail/mailscanner/files/rcwarning.txt 1.28 mail/mailscanner/pkg-plist - Introduce a few more maintanence scripts - Fix a bug in a startup script - Add files/CHANGES.port where store history of the port changes PR: ports/93420 Submitted by: maintainer

Wed, 15 Feb 2006

[ 10:47 garga ]   1.44 mail/mailscanner/Makefile 1.32 mail/mailscanner/distinfo 1.3 mail/mailscanner/files/mailscanner.sh 1.1 mail/mailscanner/files/mailscanner.sh.in 1.4 mail/mailscanner/files/mta.sh 1.1 mail/mailscanner/files/mta.sh.in 1.27 mail/mailscanner/files/patch-docs:man:MailScanner.8 1.20 mail/mailscanner/files/patch-docs:man:MailScanner.8.html 1.27 mail/mailscanner/files/patch-docs:man:MailScanner.conf.5 1.23 mail/mailscanner/files/patch-docs:man:MailScanner.conf.5.html (Only the first 10 of 12 ports in this commit are shown above. ) - Update to 4.50.15 - OPTIONSify - Use USE_RC_SUBR Change Log: - Speed increased significantly! Caches SpamAssassin results. Note you need to run my install.sh script to get the new modules required. - If "Virus Scanners = auto" (ie. the installed default value) then it searches for and uses every available installed virus scanner. - Added SpamAssassin cache analyser (analyse_SpamAssassin_cache) to the distributions. 99% written by Steve Freegard of MailWatch fame. - Upgraded ClamAV+SA bundle to ClamAV 0.88. - Added default headers that Thunderbird 1.5 will use to automatically identify spam based on SpamAssassin's spam headers. - Added UU-decoder to automatically extract files from attachments that were (Only the first 15 lines of the commit message are shown above )

Number of commits found: 4