Set client encoding in the right place.

se client_encoding = 'ISO-8859-15' to avoid ERROR:  invalid byte sequence for encoding "UTF8": 0xe1 0x66 0x69

Something to do with Ade's commits.

While here. make sure there is a space before LIMIT & OFFSET

use client_encoding = 'ISO-8859-15' to avoid ERROR:  invalid byte sequence for encoding "UTF8": 0xe1 0x66 0x69

Something to do with Ade's commits.

While here. make sure there is a space before LIMIT & OFFSET

Start using _forDisplay

Remove call to freshports_NoIndex which we did not commit

Add fetch_depends, $extract_depends, $patch_depends, & $uses

Speed up the dates query.
See also: http://news.freshports.org/2014/11/08/improving-date-search/

Don't error out, just say nothing found.

Turn off debugging

Return 0 for watch list data when no user id is supplied

use element_pathname, not pathname

use element_pathname not pathname

Add RetrievePort, AddPort, and RemovePort

Add a bunch of stuff for branches

Remove trailing ?>

move from 'pkg install PKGNAME' to 'pkg install category/port'
Recommended by Allan Jude

include R.svn_hostname and R.path_to_repo in results so we can link to the SVN comimt

whitespace only

Use pg_escape_string instead of AddSlashes.
This avoid db errors like:

Security Events
=-=-=-=-=-=-=-=
May 12 19:56:57 supernews postgres[3700]: [2-1] ERROR:  syntax error at or
near "\" at character 110

System Events
=-=-=-=-=-=-=
May 12 19:56:57 supernews postgres[3700]: [2-2] STATEMENT:  select * from
vuxml where vid = '7fcf1727-be71-11db-b2ec-000c6ec775d9\"
class=\"resultLink/general.php?*id=\'\''

Add some E'' to strings.  Avoid database errors that way...

Sort in the right place

Apply the LIMIT and OFFSET to the commits, not to the ports.

Fix /UPGRADING and /MOVED

Be sure to urlencode non-port URLs because they can be tricky.

For SVN commits, be like CVS and link to the log from the full filename

- When displaying files, provide the appropriate link to SVN when it's an

Debugging

Use Required By instead of These ports depend upon this port

Sort by cat/port
Suggested by: nox

Pull dependencies back by type.
When pulling them back, pull them back by the right port id.

remove debugging

Display license in search results.
Reported by Ruslan Mahmatkhanov <cvs-src@yandex.ru> on 12/24/2010 3:23 PM
While here, fix formating of license output to have trailing <br>.

Add support for license

asked -> marked

Add ability to search src tree, not just ports.

If showconfig is empty, display nil.

Change <i> to <b> instead.
add ports.showconfig

Whitespace only

call freshports_DistFilesSurveyURL()

Alter the Count() function to return the number of commits.

For the skull at the top of the page, link to the vuxml.php?package=

Add a bit more sorting criteria to ensure consistent sorts.

Remove link to the Design Contest.

Ummm, revert previous commit.  It messes up commits such as:

http://beta.freshsource.org/commit.php?message_id=200707091710.l69HAN45082829@repoman.freebsd.org

CategoryCacheDir should be CacheDir

In the SQL, refer to commit_log as CL (easier to type).
Add a bunch of missing columns, not really used by this type of commit, but
useful for commit_record which expects these columns.

Move to a ports/category-name/port-name caching format

plain_text => text_plain

Cater for new field in announcements table: text_plain

Use the committer as author

Use freshports_CommitDescriptionPrint(), not freshports_PortDescriptionPrint()

remove the failed attempt at & (was &rmp;) for the phorum link

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.