Merge to HEAD from FreshPorts2

Only display the commit flags if the user is logged in.

Add the displaying of flagged commits

Add the class for accessing flagged commits.

revision -> revision_name

Returns 0, not an undefined value.  It is easier on the logs.

Use a plain URL link, not HTML

use the newly created freshports_Commit_URL()

Rename freshports_CommitFilesLink() to freshports_CommitFilesLink()
Prefix the port URL to start with a / and thus be absolute.

Make sure the GUID are unique.
Link to the commit details for this one port, and be unique about it.

base class for fetching files associated with a commit

We are still using PHP4.  __construct is available only in PHP5.

use the supplied LIMIT and OFFSET

Add ?> to end of file.

Add PageNum and PageSize to the cache parameters.

GetCountCommitsByCommitMessage() becomes GetCountCommits()

Add UserIDSet() and TreePathConditionSet()
Alter FetchByTreePath() to use these attributes.

Add new feature: SetShowAllPorts()

If you want to show all the ports/elements associated with this commit,
invoke this function with true.

Use revision_name, not revision.
Use pathname, not element_pathname.

Introduce better debugging and error logging.
Add:
GetCountPortCommitsByTreeLocation()
GetCountCommitsByTreeLocation()
FetchByTreePath()
FetchByTreePathSrc()

For FetchByCommitMessageContents() and
GetCountCommitsByCommitMessage(), be more specific
in what we are passing in: a condition, not a value.

Be sure to sort the result by date desc, category, port

Cater for Sanity Test Failure messages.

Add an S

Add class for getting latest vuln.

Do not log.

Use newly created IsDeleted()
If the port has been deleted, do not display installation instructions.

Mention that is_primary will be either 't' or 'f'

Add IsOnWatchList

Whitespace only

Fix broken comment

Stop using the security_notice table

Correct the comment describing this class.
Better display HTML when there is nothing to display.

Put the Add/Remove at the start of the line.

When a fetch fails, die.  Leave a nice message.

Remove FRESHPORTS_TASKS_SECURITY_NOTICE_ADD

*** empty log message ***

Add a GUID to the feed.

Whitespace changes only.  Remove trailing control-m's

Fix the cache name.  Should be news.*.xml

Remove all   to better format the output when not all items appear
Display all categories, "real" or not, as hyperlinks

We no longer pass in the cache data via a parameter.  Now we set it
explicity during a function call.

Set the mask so we get the expected permissions

Don't call syslog directly.  Invoke _Log instead.

Create two different types of caching: Commits, and Details.
When removing a cache entry, remove all types (e.g. commits and details)

Be concise with our reason for not displaying lack of packages.

Be consistent in the log messages.  Prefix each one with 'Cache: '.
Expand _CleanKey() and prevent directory stepping: i.e. ..

include the htmlify code

Give an initial value to $result;

Use fwrite instead of fputs (they are aliases).
Check the results of frwite.
Do an fclose on the spool file before moving it into the cache.
Do an fclose if the write fails
chmod the file to be 664 so the perl scripts can remove it

For spool file names, use tempname to avoid collisions.

Add some logging
fix some syntax errors

The first draft, pretty much untested, of caching code.

Start using new DisplayCommit class.  This allows the code for
displaying commits to be shared between this module and the search module.

This commit adds support for displaying commits by committer.

Allow for LIMIT and OFFSET in the result set.
Add new functions:
  SetLimit()
  SetOffset()
  GetCountCommitsByCommitter()
  GetCountPortCommitsByCommitter()
  GetCountPortsTouchedByCommitter()
  FetchByCommitter()

Add new function IsCategoryByName() which returns the category id
of the supplied name.

Add code for avoiding watch list token collision.

Remove syslog call.

Convert to a constant for our background colour.
We really should go CSS.

Turn off debugging

*** empty log message ***

Add missing ?>
Update copyright

Update copyright

Include the format for the date.

Correctly quote the category name.

Add support for Last-Modified

Handle expiration_date

improve spacing around restricted and no_cdrom

add restricted and no_cdrom fields

Add vulnerable_current, ports_vulnerable.past to whatever calls we have.
Display error text on any errors.

During object creation, set the vuxml list to undef.
Remove VulnerabilityCount() and
replace it with IsVulnerable() and WasVulnerable()

Instead of unset($VID), using $VID=array().

Add new attribute: VuXML_List;
And the function to populate it: LoadVulnerabilities()

Use *_Icon_Link where appropriate.

add IsSlavePort()

This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.

Turn debugging off.

Set Debug to zero.  Use the right watch list variable.

Whitespace changes only.

In FetchInitialize, remove $element_id from the select and use
commit_log_elements.element_id instead.  This will give us the correct value
and correctly name the column as element_id a the same time.

Add port_epoch

Start grabbing port epoch

comment out debugging code

Give an initial values to $VID

Ensure that id is set before returning from FetchByName()

add something for package searching

Use FRESHPORTS_VERSION_REVISION_JOINER

Add constants
Add GLOBAL

Display master/slave information

Display security_notice_id
white space changes to align columns

Start using ignore

handle the new ports.deprecated field

status -> security_notice_status_id
expand information returned by Fetch

Add FetchByStatus, GetStatus, and FetchNth.

Only include those security notices which are Active.

Remove references to external variables by providing hooks to set
these values.

Better handle the case of no watch lists

Handle ports_moved table

If no watch lists are in service return the first one which is in service.

Adjust the way we determine GetDefaultWatchListID.
Change a 0 to $i.

Add a syslog to track down a problem.

If user details cannot be found, remove their cookie and log details.

Code for displaying the last N commits.
Moved here from www/index.php

Whitespace adjustment
Explicity set debugging off

Add missing EncodingLosses()

rename PackagesExists to PackageExists

whitespace changes
Add EncodingLosses()

add EncodingLosses()

add FetchByElementID

comment out debugging code

Given a pathname, get the element details

Whitespace only

No functionality changes.  Just whitespace and better use of existing variables.

use the correct database field name: firstlogin not firslogin

Fix php notice message

Add WatchlistCount which gives us the number of watch lists upon which this
port appears.

Update the copyright notice to 2003

add FetchNth, FetchAllActive, FetchUpdateID, and GetPopulateValues functions

Add Announcements table

log all changes to the description

update header

header update

First commit

better handling if we don't find the port

comment out a debugging statement

start using the new stored procedure for security notices.

enhanced debugging

actually loop and use more than just one task
start using constants

Allow paging through category contents

turn off debugging

Handle the multiple watch lists correctly when fetching a single port

define SUPER_USER and USER types

For mainttaining commit_log_ports_ignore

Include needs_refresh for each commit

turn off debugging
use the categories table

remove trailing control-m's

Try doing the join a bit faster.

Don't set message id on retrieve
return message id

Allow us to add users to tasks

whitespace

Start pulling stuff in from the new security_notice table.

Use AddSlashes correctly

Add DeleteAllLists

PR 235 - WatchList needs to use UserID when deleting items.

Add FetchByName

Set debug off

use ' instead of "

Use require_once

Add DeleteElementFromWatchLists

Use onwatchlist not watch

Start using the new User class

Add watch_list_count, which is optional

First commit

Tidy of SQL strings.
Make FetchByID work.

add in_service

Repair comments

Cater for watch lists

add FetchNth and _PopulateValues
The query needs to be modified to cater for time zones and adjustments
thereto.

This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.

move some max functions
FetchByID does not appear to be used.  So print a message and exit if
we are called.

Format the data appropriately

Cater for watch lists correctly on lists of ports.

add message_id and encoding_losses, which might be used in some circumstances

add FetchByName

New class

OOPs, 24 hours clock, not 12.

remove debugging info

remember to timezone adjust the commit date

rename date_created -> date_added

Add some debugging code.
for ports, make sure we don't include commit log information when
retriving by partial path name.

Add a new class.

PR 26 - adding new class for commit_log_ports which is used on the
port description page (i.e. missing-port.php). see the
port-description.php3 page for a similar output.

Add missing.php.

This page is activated via ErrorDocument 404 /missing.php in the apache
configuration for this website.  It uses the classes element and port to
grab information from the database.

This is the start of being able to browse to:

http://FreshPorts.org/net/samba and get the samba page.  Or, if a port
is uniqely named, http://FreshPorts.org/samba will take you to the
same place.

Much to do, but this is the proof of concept.