FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link. Remember
I remember
I am looking for an LTO tape library. Do you have one to spare?
found NOTHING in cache
			SELECT count(DISTINCT CL.id) AS count
			  FROM element_pathname EP, commit_log_elements CLE, commit_log CL
			 WHERE EP.pathname   = '/ports/head/games/quake2-3zb2/pkg-plist'
			   AND EP.element_id = CLE.element_ID
			   AND CL.id         = CLE.commit_log_id
PageNumber='1'
Offset='0'
		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/quake2-3zb2/pkg-plist'
   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
That would give us 14 rows
non port: head/games/quake2-3zb2/pkg-plist
SVNWeb

Number of commits found: 3

Mon, 13 May 2013
[ 03:21 danfe ] Original commit 
317993 games/quake2-3zb2/Makefile
317993 games/quake2-3zb2/pkg-plist
- Catch up with r317934
- Rename NODES to more descriptive ROUTES
Sun, 17 Mar 2013
[ 11:07 danfe ] Original commit 
314417 games/quake2-3zb2/Makefile
314417 games/quake2-3zb2/distinfo
314417 games/quake2-3zb2/files/pkg-message.in
314417 games/quake2-3zb2/pkg-descr
314417 games/quake2-3zb2/pkg-plist
- Trim old-school Makefile header per new guidelines
- Convert to modern OPTIONS framework (courtesy of jgh@)
- Install routes for a few more deathmatch levels
- Mute MKDIR's and generally cleanup Makefile while here
- Reword port description and port message texts
Thu, 28 Dec 2006
[ 18:50 alepulver ] Original commit 
1.1074 games/Makefile
1.1 games/quake2-3zb2/Makefile
1.1 games/quake2-3zb2/distinfo
1.1 games/quake2-3zb2/files/Makefile
1.1 games/quake2-3zb2/files/pkg-message.in
1.1 games/quake2-3zb2/pkg-descr
1.1 games/quake2-3zb2/pkg-plist
3rd-Zigock Bot II for Quake II.

WWW: http://users.jp.tri6.net/~ponpoko/3zb2/

Number of commits found: 3

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
jenkinsOct 31
jenkins-ltsOct 31
twikiOct 31
libsshOct 29
libpurpleOct 24
pidginOct 24
phpmyadminOct 22
asterisk11Oct 21
libxml2Oct 18
drupal7Oct 16
firefox*Oct 16
firefox-esr*Oct 16
libxul*Oct 16
linux-firefox*Oct 16
linux-seamonkey*Oct 16

7 vulnerabilities affecting 10 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds


Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 24275
Broken 98
Deprecated 42
Ignore 356
Forbidden 2
Restricted 206
No CDROM 93
Vulnerable 18
Expired 0
Set to expire 38
Interactive 0
new 24 hours 5
new 48 hours5
new 7 days14
new fortnight36
new month136

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.