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

SVNWeb

Number of commits found: 6

Thu, 10 Nov 2005

[ 04:22 pav ]   1.805 MOVED 1.772 misc/Makefile 1.11 misc/gaim-bangexec/Makefile 1.4 misc/gaim-bangexec/distinfo 1.4 misc/gaim-bangexec/files/patch-bangexec.c 1.2 misc/gaim-bangexec/pkg-descr 1.36 misc/gaim-guifications/Makefile 1.17 misc/gaim-guifications/distinfo 1.2 misc/gaim-guifications/pkg-descr 1.11 misc/gaim-guifications/pkg-plist (Only the first 10 of 20 ports in this commit are shown above. ) Move gaim related ports to a newly created net-im category: misc/gaim-bangexec -> net-im/gaim-bangexec misc/gaim-guifications -> net-im/gaim-guifications misc/gaim-ignorance -> net-im/gaim-ignorance Repocopied by: marcus

Mon, 24 Oct 2005

[ 09:26 jylefort ]   1.10 misc/gaim-ignorance/Makefile 1.5 misc/gaim-ignorance/distinfo 1.1 misc/gaim-ignorance/files/patch-ignorance.c 1.2 misc/gaim-ignorance/pkg-descr 1.2 misc/gaim-ignorance/pkg-plist - Update to 2.2 [1] - Also copy ignorance.conf when installing from a package - Unsilence post-install - Polish the Makefile [1]: PR: ports/87900 Submitted by: maintainer

Thu, 13 Oct 2005

[ 10:34 flz ]   1.9 misc/gaim-ignorance/Makefile 1.4 misc/gaim-ignorance/distinfo - Project moved to sourceforge. - Update to 2.1. - Mark as BROKEN since the new version doesn't compile and the oldest is not fetchable anymore (previous master site disappeared). PR: ports/87344 Submitted by: maintainer

Mon, 11 Jul 2005

[ 05:14 novel ]   1.6 misc/gaim-ignorance/Makefile 1.3 misc/gaim-ignorance/distinfo Update to 1.3.1.2. PR: 83231 Submitted by: Kevin Brunelle (maintainer)

Mon, 9 May 2005

[ 22:40 jylefort ]   1.2 misc/gaim-ignorance/Makefile 1.2 misc/gaim-ignorance/distinfo Update to 1.3.0.1 PR: ports/80817 Submitted by: maintainer

Tue, 19 Apr 2005

[ 13:03 jylefort ]   1.12331 /CVSROOT/modules 1.739 misc/Makefile 1.1 misc/gaim-ignorance/Makefile 1.1 misc/gaim-ignorance/distinfo 1.1 misc/gaim-ignorance/files/pkg-message.in 1.1 misc/gaim-ignorance/pkg-descr Ignorance is a content filtering plugin for Gaim. If you love Gaim for chat, but find yourself missing the filtering features of clients like zinc, then Ignorance is for you! PR: ports/80047 Submitted by: Kevin Brunelle <kruptos@mlinux.org> Approved by: adamw (mentor)

Number of commits found: 6