backout previous commit, which was whitespace only and in error

*** empty log message ***

Add facilities for displaying the vuxml details, useful for debugging
and for the VuXML team to verify that all went well.

Start using port->IsSlave()
Add freshports_CheckForOutdatedVulnClaim($commit, $port, $VuXMLList)
if the most recent commit for a slave port is marked as vulnerable,
and the commit version isn't the same as the port version, let them
know that the master port may have been updated, and the port may no longer
be vulnerable.

Use *_Icon_Link where appropriate.

add IsSlavePort()

Add a few more fields to the SQL

whitespace only

Order the data by ID, so it retains the original ordering.
add print()

Use vuxml_affected_id when retrieving.
Add set_id(), set_vuxml_affected_id(), set_name(), and print()

Comment out printing

Alter FetchByVID() to take a parameter
Add FetchPackages()

FetchByVID() now takes the vuln id as a parameter

Remember to empty out objects before using them again.

remove unused shift in empty()
Remove unneeded quote in save()

Remove extra comma from UPDATE

Add functions for setting values

add fetch by id, and empty()

First attempt at grabbing all package information for a vuxml entry

add FetchByVID

clean up _initialize

Allow for updates

First work towards incremental updates of vuxml instead of wiping the tables
and starting from scratch again.

white space changes only

Add commits.html cache

Add link to commits.php

Add commits.php

Remove unused usage

We no longer use this.

Add TITLE / hover text to the hyperlinks

Improve the Hover text by including the actual FORBIDDEN, BROKEN,
DEPRECATED, or IGNORE message.

also: Implement links to PORTSMON without actually using it yet....

Fix broken HTML tag on search results

Include links to the FAQ for most icons, such as freshports_Broken_Icon()
by providing a function, freshports_Broken_Icon_Link().

Change <? to <?php
Add more detail about the refresh icon.

Add People Who Watch This Port

Add PeopleWatchingThisPortAlsoWatch()

Add some vuxml functions expected to be used when I start optimizing
the vuxml process.
Add currenttimestamputc() that may be useful when moving to UTC
Add WatchersAlsoWatched() to display "People watching this port, also watch".

Let's talk about freebsd software.

Move the header('Content-type: text/xml'); from news.php to caching-files/news.php

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

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

Add permissions for vuxml

Add new search option

Let's make this actually update the fields it claims to upgrade

Use ILIKE instead of lower() when doing case insensitive LIKE
Order the code so that it's always depends_build, depends_lib, depends_run.
  Just so it is consistent.
Add depends_all which searches all of the above three terms.
Better format the SQL when an error occurs.

Add searching on depends_{lib|build|run}

Why does the search page use GET and not POST

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

Allow searching by package and by latest link

Use package_name, not latest_link when looking up package names

When telling people how to alter their watch lists, include the icons they
can click.

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

Show poppy from 1 Nov to 12 Nov

Add CopyStagingToWatchList() to be used for copying directly to watch lists
bypassing the staging area.

$HRML should be $HTML

Add three new fields:
  no_latest_link
  no_package
  package_name

use the right dbh variable

Set the ports.last_commit_id field for those ports that have no such value.

Mention that if the package_add information does not appear, you'll be shown
a reason why.

HTML nits

Use IsSet($_SERVER['REDIRECT_QUERY_STRING']) instead of In_Array("REDIRECT_QUERY_STRING", $_SERVER)
which appears to fail.

While here, adjust whitespace on a }

Add missing </b>.

Add the vuxml tables

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

Put a standard header into the file

The file for is processing UPDATING is /dynamic/refresh_updating

use ' not "
Use :: not : for the config package.

Add vuxml class for dealing with the VuXML table.

*** empty log message ***

This file was taken from process_vuxml.pl and will now be the file that
just loads the vuxml file into the database.

process_vuxml.pl will soon load the file, and mark the commits.

Remove code and use PortsFreezeStatus() instead.

For non-ports, do not show revision.
For non-ports, don't display a lots of things, like forbidden, deprecated, etc.

In the function freshports_CommitsFooter, the parameter is not a $port.
It is an $element_record.  Make it so.

In freshports_Commits, use $element_record, not $port, which is undefined.

Use ORDERBYDESCENDING, not other variants.

Initialize $LastVID

Display all the vuxml entries if ?list is supplied

Include portepoch in the fetch

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

whitespace only

Become more useful by adding a couple of parameters:

URL=$1    - The URL to fetch from.  Useful for local testing.
SUFFIX=$6 - The suffix to attach to the URL.  Useful to specify the repository.

Put them to the vuxml.org site, for now.

Remove this file as it will not be used.

Start updating commit_log_ports
Add some code for extracting PORTEPOCH via make -V, but then
comment it out because some old revisions of makefiles do not
parse cleanly.
Ignore PortEpochs that are variables.  We can't use them here.

If the port never sets PORTEPOCH, it must be set in the MASTERPORT.
Detect such situations and display the master port name.

This is much better.

A better idea for historical epoch

Put a div around the footer ad to center it

use freshports_PackageVersion()

Add the revision icon.  used to link to revision in CVS when displaying
files touched by a commit.

Start using the PackageVersion() function.
Link to the revision of the file.

Perhaps we can solve this in the short term by getting PORTEPOCH right for the
ports affected by vuln.

Start using epoch

Add port_epoch

Provide more information about using pkg_version -t

standardize header

start using new function freshports_PackageVersion()

Introduce new function: freshports_PackageVersion() which creates the
package name, based upon PORTVERSION, PORTREVISION, and PORTEPOCH.

Alter existing code to use this new function.
Fix a problem with MAINTAINER mailto by not obscuring the subject field

Now we are invoking pkg_version to test versions.  Getting closer now!

We now have all the commits for a given package.

Change the column order to op1, version1, op2, version2.

Add FUNCTION vuxml_ranges()

In vuxml_ranges, rename the fields so they do not contain range_ and _start|_finish.

Add this soon to be completed file

If there is a ports freeze in effect, say so.

Start processing all the special files

Stop calling FreshPorts::SpecialProcessingFiles::Eat

Add the shell script that corresponds to the perl script

Set commit_log_ports.port_epoch

Handle new field: quoted_port_epoch

More elaboration

Give initial values to port_epoch

rename ports.pkgname to package_name

Grab PKGNAMEPREFIX and PKGNAMESUFFIX
rename pkgname => package_name

-    is_slave_port              text                          ,
+    master_port                text                          ,
     latest_link                text                          ,
+    depends_lib                text                          ,
     no_latest_link             text                          ,
     no_package                 text                          ,
     pkgname                    text                          ,
+    portepoch

Rename is_slave_port to master_port to reflect what we are actually using in the
database.
Add depends_lib and portepoch.

Grant select on on VuXML tables

Add update_database_vuxml_affected and update_database_vuxml_references
This completes the database updates for vuxml data.

There is no date_modified column.  Remove usage.
We use vuxml_affected_id, not vuxml_id.  Change it.

Start updating the database

Include constants
Set status

Allow invocation like this:

(DBHandle => $dbh, Stream   => *STDIN)

cater for undefined values

First attempt.  untested.

Add Matthew Seaman's work into the tree.  This will be used to parse the
vuxml database.

Move range_version_start nearer to the top of the table.
Now we can see the data like this:

range_version_start range_operator_start VERSION and VERSION range_operator_end range_version_end

Example:

1.04b <= VERSION and VERSION < 1.06

Add these fields to ports:
   no_latest_link
   no_package
   pkgname

Add vuxml tables

Create a new deleted icon, a tombstone.

whitespace changes only

strip out unmentionables, unprintable characters.

Initalize some variables

Fix broken HTML

Change to a policy of using the VID, not our internal IDs when linking.

How to get a list of VuXML entries for a port

Ensure that id is set before returning from FetchByName()

dbh is global.  define it as such.

Use local debug variable.

Use Searches package for form

Add class for searching

Add GetCategoryPortFromLatestLink(text)

Move to an Observer/Observable stragegy.
This commit requires use of
http://search.cpan.org/~cwinters/Class-Observable-1.02/lib/Class/Observable.pm

See also this port: http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/70339

For this commit, most of load_xml_into_db.pl was moved to a new file: xml_munge.pm

whitespace only

add missing ' in debugging message

update copyright year

use the right paths so that reinstalling this port works.

remove @dates, which is no longer used.

add PortsUpdatingPortsXrefAdd

Use FRESHPORTS_VERSION_REVISION_JOINER

talk about /usr/ports/UPDATING

Start using AddUpdatingXref

Use FRESHPORTS_VERSION_REVISION_JOINER

Welcome to ports_updating and ports_updating_port_xref.
A way to display the contents of /usr/ports/UPDATING

Remove unused variable $file.
Remove unnecessary push.

remove unused variable

Fix some HTML nits by using & instead of &
Use the Right ALT and TITLE values when calling freshports_Commit_Link
Fix a broken tag.
Use htmlspecialchars on the port homepage
Introduce freshports_Head whereby we can show all the commit message
if it's over the limit by just a few lines.
Properly define WRAPCOMMITSATCOLUMN

Change the mime type to text/xml

Display master/slave information

Add latest_link

Ignore vacuum.sh

Process slave ports when the master port is updated.

fix copyright
fix page title
add latest_link

update copyright
add latest_list

Include latest_link

Whitespace adjustments

Add ascending/descending to the sorting.

Set User->id to zero instead of ''

Back out the change.  The blank line code has been tested in production for
some time, but it's not thought to be necessary.  The error it is detecting
should not occur.  It may be better to fail with when this error occurs.

For a given master port, return all the slave ports.

Set the depends_lib field

This script sets the master_porta and latest_link fields of the ports table.

Add the server name to the refresh URL

replace ClearSlavePort(int) with ClearSlavePort(text)

add SetSlavePort(text, text), GetPort(text, text), ClearSlavePort(int)

Allow user to sort output by either category or port (default).

Use cvsup host not xeon host.

Display security_notice_id
white space changes to align columns

Display security notice link.

Stop using In_array

Add forbidden, deprecated, ignore, and broken.

Whitespace only

Better examples

Catch up with the ports tree and remove this file, now replaced by a COMMENT
entry in the Makefile.

Alter freshports_commit(text) to take a page size and offset.
Add freshports_commit_count_elements(text) which returns the number of rows.

Remove

No need to email now

Start using ignore

add ignore

Add deprecated and ignore

remove USERS as it was not used.

Provide a method for adding nofollow and noindex tags.  There is far too
much information on FreshPorts for every link to be indexed.

whitespace only

Correctly state whether or not committer notifications are enabled.

Add link to root directory

remove debugging echo.

Handle hourly stats

Add a list of deprecated port

Handle the new port.deprecated field.

Add depcreated icon.

Now that we have backend/announcements.php, we have no need for announcements.txt

HTML nits

HTML nit

HTML nits

status -> security_notice_status_id

status -> security_notice_status_id
expand information returned by Fetch

security_notice[_audit].status becomes security_notice_status_id

upgrade instructions for security_notice*

Create security_notice_status

Define $ShowAnnouncements as global.
Define WRAPCOMMITSATCOLUMN if not defined.
htmlify the announcement text.

Alter SecurityNoticeCreate to take a status field

only include those security notices which are Active.

Add GetAllActive

fix html

Add

improve reporting, use Online

Start using OFFLINE

Cater for IE and pressing ENTER on forms.
see http://ppewww.ph.gla.ac.uk/~flavell/www/formquestion.html
 or http://www.cs.tut.fi/~jkorpela/forms/imagebutton.html

Only email the committer if they are opted in

Reflect changes made to .PDM file:
- announcements table dates do not have time zone
- page_load_summary now has a total and users field

Rename fields in page_load_summary to make more sense

Correct diagnostic message:
User Creation -> User Token Sent

If MessageID is not found in the message, say so, and abort.

Find a better way to do
FUNCTION freshports_commit(text) RETURNS SETOF freshports_commit_record
This was taking two minutes for commits such as
200401291613.i0TGD7Wu024303@repoman.freebsd.org

whitespace and cap changes

Add function AnnouncementsGet

Add announcements.pm

whitespace

remove maxlength and dirname, which were unused

Add more stuff

Replace the old PostgreSQL logo with the new one
Rearrange the logos for better viewing pleasure.

For the page_load_summary table, reflect changes in column names
and change the way we count things.

Add entry for daily rendering job

Script called by cronjob.

We don't need to set the search path here.

Update header, remove commented out code

in page_load_summary:
  - rename name to page_name
  - add rendering_time_min and rendering_time_max

in page_load_detail
  - break timestamp into date and time fields
  - user_id can be null

Use LatestCommits in the new fashion.

When determining whether or not a port is on a watch list, consider only
those watch lists which are in service.

Move comments closed to relevant code

Remove NOTIFY commands

Fetch all files.  Let the called routine validate the files.

Better handle the case of no watch lists

use COPYRIGHTYEARS

special processing for special files

Whitespace adjustement

remove unused code
empty table before filling it

Document Port Moves

Show from and to moves.

Add from and to moves.

permission for ports_moved

Add function freshports_PortsMoved which displays a single line for PortsMoved.

First cut.  Needs to start using stored procedure PortsMovedAdd.

Improve the error reporting for corrupted commits.

Allow nulls on ports_moved.{from_port_id|to_port_id}
I suspect from_port_id cannot be NULL, but we'll adjust that later if need be.

Warn them about chello

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

Refer to it as a freefall login, not a committer id.
Fill in the freefall login by default.

ignore status.pm

Display the Port name and the error beneath it.

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

Adjust syslog calls now that we've found a bug.

Add notes about the apology

Mention the registrar lock

Add a syslog to track down a problem.

correct typo

remove outdated comment

Add this

blur the email address

more fraud

fraud

Cope with freshports.net fraud

Updates

Add fraud images

When a new user is created, a watch list is automatically created too.
When this is done, ensure the in_service flag is set to true.  Otherewise,
they can't start adding things to their watch list.

See classes/watch_list_element.php::AddToDefault($UserID, $ElementID).

Remove some redudant debugging code.

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

Add code for PR 1234, from Marcin Gryszkalis

Let's not use $HTML.= anymore.  Just echo.  It can be 20s faster for 2000 ports
 4429 | 2003-11-27 19:16:20.067438 | /watch.php | 1 | 192.168.0.99 | 00:00:52.00862
 4427 | 2003-11-27 19:14:24.64815  | /watch.php | 1 | 192.168.0.99 | 00:00:28.657504

add element_id to the freshports_commit_record data type.

Do not write to $User->id.  Instead, use $UserID.

Supply the UserID when calling FetchByElementID

If there is no message id for file.php, don't do anything.

Ensure you call AddSlashes.  I noticed this problem because of this error:
2003-11-26 05:43:12 [82327]  ERROR:  parser: parse error at or near "cgi" at character 41

And was able to reproduce it by using this URL:
%20+%20base%20+%20'cgi-bin/ads/'%20+%20%20%20adcode%20+%20'.cgi'%20+%20Tv%20+%20%20%20

Fix incorrect pkg_info options.  Submitted by Lawrence You <lyou@pacbell.net>

If the cache file exists, use it. Otherwise, go from scratch.

Update the number of google pages.

This creates the cache file used by www/index.php

Start using new classes/commit_record.php

Remove commit_log_port_elements which has been replaced by commit_log_ports_elements
Add index commit_log_ports_elements_clid on
           commit_log_ports_elements (commit_log_id)

add cache-refresh.sh

Add the hostname and database name into the mail headers

include upgrade instructions

Keep the error message with the port name
Always CC the system admin on sanity errors

Add: WEBSITEURL CACHEDIR STAGINGDIR

remember to create commit_log_ports_elements

When displaying the page footer, save the Statistics object away.

Set the database handle for the Statistics object.

Add instructions for creating disk caching directories

Use an absolute path to the poppy so it works from within the Phorums

Add a poppy

Add std headers

Don't store the start position within the form.  Leave it on the URL.
This allows us to tell the difference between clicking on search (no start
specified) and clicking on next page (start will be on the URL).

add create table for commit_log_ports_elements

Add some missing drop triggers statements.

whitespace

Add details on how to use formail to load an archive.

Fix broken email address.

Cater for both physical and virtual categories.

Whitespace adjustment
Explicity set debugging off

ignore status-config.php

Remove references to housekeeping which no longer exists

add permissions for commit_log_ports_elements

*** empty log message ***

Replace commit_log_ports_extra with commit_log_ports_elements.
Same concept, but larger scope.  This new table cross references a commit
to ports and files outside ports.

Use LatestCommits instead of LastestCommits
Use just NumRows instead of both NumRows and numrows.

- remove housekeeping table, no longer used
- alter security_notice
- remove index on security_notice (commit_log_id)
  and leave it to the primary key instead.
- move indexes on ports_categories (port_id) and ports_categories (category_id)
- add commit_log_port_extras

Any ports tree commit which touches a file not belonging to a port (e.g.
ports/INDEX) will result in an entry in this table.

Include the element_id for the file within the File structure

Add more tests for <, >, and &

Add login counts code

Use User not visitor

backout previous commit

Whitespace adjustment

remove unused variable

A page for viewing the mail queues

Start using FUNCTION freshports_commit(text) RETURNS SETOF freshports_commit_record

Add freshports_commit_record, for use by commit.php

Fix to make files.php work, the option which displays the files
with a port which were touched by a given commit.

Look for 'files.php', extract that from the pathname so we can find the
element, extract the message id, then call the freshports_Files function.

As part of this change, send the REDIRECT_URL instead of the REQUEST_URI
to freshports_Parse404URI.

< $result = freshports_Parse404URI($_SERVER['REQUEST_URI'], $db);
---
> $result = freshports_Parse404URI($_SERVER['REDIRECT_URL'], $db);

When creating a hyperlink to a port, do not include the version/revision
within the link.

Add in some missing fields.

Add CVS repo link

Add missing ?>

Move the old package code with the new package code, which was added
to the wrong place.  It is now within the IF.

Add freshports_CVS_Icon()
Add freshports_CVS_Link
Remove GLOBALs and use the defines for CVS and FTP URLs instead
Use recently added EncodingLosses() and PackagesExists() functions
Instead of referring to Homepage, use Main Web Site, as does the main FreeBSD site
Provide a link to the CVSweb for non-port entities

Do not include ports prefix when displaying element pathname
Provide a link to cvsweb

Use IsPrimary()