If no files are found during a regular GetFiles procedure, try invoking
GetFilesImported instead.  This will process any file imports.

Trim input from users. No sense having trailing/leading spaces.
We trim more fields than we have to, but let's be consistent.

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

Add another good test page: /lang/php4/

Fix URLs which contain PR references.  such as that found at
/databases/postgresql7/files.php?message_id=200302062046.h16KkqNv024036@repoman.freebsd.org

Remove notice about multiple watch lists.

Use the correct number of parameters when calling SendMail.

Remove changes committed in error.

customize.php

The HTMLify code is now in another file.  Remove it from here, and
include it when needed.

Remove "use housekeeping".
Remove RefreshMainPage function because we no longer do this.

Lots of whitespace fixes.

Record the information which is used during Error Notification.
(message subject and message id)

Fix error reporting which failed to correctly report the error.

Add the latest_commits and latest_commits_ports back in.  We need them.

If no files found in a commit, report an error.  This was prompted by
someone who did a cvs import instead of using addport.

Change all $UserName references to $User->Name to avoid conflicts with
Phorum scripts.

Turn off debuggin

Indicate that ports marked with a * actually reside within another category but
have this category listed as a secondary category.

A port always has one primary category.  This category corresponds to
the directory in which the port resides. This directory is always
within the ports tree.  A port may also reside in other categories
but they are referred to as secondary categories.

When displaying the contents of a category, the same port name may appear
twice, but from different categories.  For example, japanese/gawk and
lang/gawk.  The query to obtain a list of ports from a given category
will now return both the primary category (as category) and the name
of the category we are looking at (as category_looking_at).

Add WRAPCOMMITSATCOLUMN

for ElementTagSet, be sure to check for an existing revision before
adding it.  For some reason this was removed.

remove: commit_log_ports_insert
        commit_log_insert
        commit_log_update

Fix HTMLify solution when applied to multi-line situations such as
http://www.freshports.org/commit.php?message_id=200206232029.g5NKT1O13181@freefall.freebsd.org

We don't need this in this repo any more.  Phorum is now standalone.

minor changes to allow phorum headers/footers to work better

things to ignore

ignore blank lines

disallow commit.php

remove references to INDEX.db which is not a cvs file

This belongs in develop.freshports.org/www/directories

Fix typo

Show them the way to the phorum

first commit

Example database

First commit

Remove functions associated with element_pathnames table.
This table was experimental and attempted to deal with path parsing
issues which would arise with watch lists on FreshSource. We might be
able to use these functions at a later date if we allow people to
watch a directory.

Each category has a pkg/COMMENT file which describes that category.
When a new category is encountered, if we cannot fetch pkg/COMMENT, then go
with a fake description.

Wrap all committer messages at column 72.
Tidy up the email code to make it easier to read.

Improve the error reporting during sanity testing.  I found a case where
we got an error such as this: "/usr/home/dan/ports/french/homard/Makefile",
line 56: Need an operator (caused by spaces instead of tabs in a section
such as do-install:).  In such cases, no results are returned from the
make command.  Instead, the errors will be captured in the tmp file
we created to capture ERROUT.

Add two new functions: SetActive and SetDeleted.

Remove link to bchosting.com because it is now in footer.

- remove inactive debugging code
- remove commented out code
- some whitespace changes

Use the small text links rather than graphics for the valid
html, rss, and CSS links.

PHP nits

Remove references to LastChangeLogID.  This variable is no longe used.

Improve handling when no date is supplied.
Ensure commits part of the table is as wide as available.
Slight cellpadding adjustment to match index.php

Sometimes a port can be deleted in one commit, and a later
commit will remove a missed file.  If this port is deleted, don't refresh it.
If we don't need to refresh it, we don't need to save it.

Include the error code in the email

Remove the temp error collection files when and where we should.  Not where
we are.

Don't have a border around the Valid RSS image.

Add details for newsfeed parameters.

Fix more PHP issues

Remove code no longer used.

Fix php notice message

Use newly added function EmptyTheListCategory instead of EmptyTheList.
Let's not clear the entire watch list every time someone adds ports
from a category.

Use the terms primary and secondary, instead of real and virtual.

Don't use get.

minor corrections to burst media code

fix broken css validator links

use abstime instead of datetime. This fixes phorum on PostgreSQL 7.3

Add a redirect for news.php

Add tools for people to create xml from email

- Use ports_active, not ports, so we don't have to check if a
port has been deleted.  Which means we don't need to refer
to the element table at all.  So remove all that code.

- Use tabs to delimit things instead of :

Update some things

Improve handling of email.  Send it out, even if previous email has bounced.
Log all attempts.

Move the WLC explanation into the "What do these symbols mean?" section.

oops, use the configuration file item instead of hard coding whether or
not to show the Watch List Count value.

Add watch_list_count

The Watch List Count image

start using find because we have too many files...

We now ignore a refresh once it has been reported. But we can't ignore
it forever.   Add an option to allow inclusion of ignored refreshes.

Add ShowWatchListCount

The default is to show the announcements.

bit more tuning of the announcement updates

Attempt a sort

comment out some debugging syslog stuff

update copyright
Create new features which disables user updates when/if necessary.

Add copyright notice

Update the copyright notice to 2003

comment out a message

With the move to a flat directory structure, we don't need
archive-logs.sh.  archive-messages.sh does it all.

convert to use a single directory for raw email, xml, xml loading, and
errors.

final amendments

add FetchNth, FetchAllActive, FetchUpdateID, and GetPopulateValues functions

whitespace adjustment

Add Announcements table

Removed unused GLOBAL

refer to /login.php instead of login.php.
whitespace adjustment
remove redundant code

Update GetPortID to treat virtual and physical categories differently.

Use MAILTO instead of $mailto
HTML nits

HTML nits

Add the security notice report to the report table

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

Add defaults for email.pm

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

Oops, got the table cells wrong

html nits

fix typos

comment out some debugging

Add the announcement

We don't want to use SystemTimeAdjust here...

When totaling categories, use the right formual depending on whether or
not it's a virtual category.

create element_pathname with an optional boolean

Add new defaults

log all changes to the description

indicate the virtual categories

Put a date on this thing before we introduce the new title.

ignore tmp

Put copyright years into a DEFINE
shorten URLs, the visible portion

Start using latest_commits_ports_anchor

We use phorum-3.3.2a now

header updates
use watch_list.in_service

add some debugging and use the right variable name

update header

header update

add users.page_size

whitespace

HTML nits

Add the valid css image

Let's fetch the data instead of just executing the query

HTML nits

some html nits
count only the primary categories
include a note that the port total is incorrect

grant select commit_log_ports_ignore for www

it's www, not wwww

Fix some footers/side bars to use the functions, not the includes...

Add security_notice_audit triggers

Add SecurityNoticeAudit class

Use int4 instead of int8 in some places.

Add a header so 404s are not generated for files.php

remove microtime for start/finish of page rendering

The VALID HTML icon

add commit_log_ports_ignore for commits
remove extraneous grant for ports_categories

remove duplicate trigger and function
add missing commit_log_update

Supply the dbname and website URL when emailing out.

Move to a user-independent directory structure

things to ignore

fix errors which prevented compare from working.
use MAILTO from config file

Allow an optional parameter, n, for the number of commits to return.
max 150.

start using triggers instead of rules on latest_commits_ports and latest_commits

First commit, set local values here

Start using config.sh

Better handling and reporting of non-fatal errors.

Add permissions to commits for ports_categories

standard headers

remove duplicate GetPortID

WatchListStagingClear now takes and returns int8
and also renamed WatchListID to UserID to reflect new strategy

WatchListStagingLogClearing now takes int8

ports_categories_set is moved to ri.txt as it becomes a trigger

turn off debugging

check for config file

use a variable, not a hard coded constant

also ignore config.sh

Update copyrights

Add the rules for commit_log_ports which keep it populated with new commits.
We still have to write the rules to clear out this table from time to time.

Indicate that we need a path to the scripts directory and things aren't always
in the home directory any more

Document

create the retry directory

Move to a better method of message handling.  This will allow
multiple databases per user and for the processing of multiple
incoming cvs-all streams.

Avoid a problem which occurs on the day after DST changes:
<               select (current_date - interval ''1 day'')::date
---
>               select (current_date - 1)::date

While here: whitespace adjustment

Better handle the lack of a pkg-descr file

improve debugging and avoid undefined values for special conditions.

Show zero values.

First commit

better handling if we don't find the port

show the category name

Ask them to disable auto-responders.

add the Security report

whitespace

remove trailing ^M

First commit.  Untested.

fix incorrect references to code definition

Add permissions for security_notice_audit and security_notice_audit_id_seq.
Adjust permissions on security_notice to be less liberal.

rename commits_latest_ports to latest_commits_ports

add trigger on security_notice for security_notice_audit

comment out a debugging statement

better logging

std headers

start using the new stored procedure for security notices.

drop the old commits_latest_ports, create the new smaller leaner version

PR 251 - columns of user_tasks table should be user_id, task_id

Allow trusted users to alter description for non-virtual categories.

start using constants

enhanced debugging

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

This commit was manufactured by cvs2svn to create tag 'RELEASE-beta-
2003_03_07'.

include the category name in the banner.

Add CategoryPortCount for category paging

Better paging links

Allow paging through category contents

Changes for 7.3 compatibility

turn off debugging

mention that this page operates only on one watch list at a time

implement empty_all correctly

simple debugging change

Handle the multiple watch lists correctly when fetching a single port

Keep the Makefile status the same as it's parent.
Do a CREATE OR REPLACE on categories_insert_update
add function for user_email_change trigger

This commit was manufactured by cvs2svn to create tag 'RELEASE-beta-
2003_03_07'.

whitespace

add trigger on categories for virtual categories

Use WatchListID not wlid
try some ' instead of "

Fix GROUP by because of 7.3 changes

To populate the new table

Whitespace changes

Virtual category support
whitespace changes

virtual categories support

define SUPER_USER and USER types

Start using the port_categories table

This commit was manufactured by cvs2svn to create tag 'RELEASE-beta-
2003_03_07'.

fix typo

/www/ => /usr/websites/

Let's try some better options here...

Let's try some better names for ALT text fields.

rename ports_refresh_ignore to commit_log_ports_ignore

Add new functions to support NeedsRefreshClear

Show me the unrefreshed ports.

display refresh symbol for unrefreshed ports

Include needs_refresh for each commit

rename ports_refresh_ignore (it was ports_refesh_ignore)

Let's order by message_id, a business value, rather than commit_log_id,
which is something we set.

fix sorting error

add parameters to display master sites, make commit table header narrower, don't wrap on date column

white space

Fix group by problem under 7.3

Part of upgrade to 7.3 - use "timestamp with time zone" instead of "timestamp"

Add commits_latest, which seems to have been deleted/omitted.

Place removal of pkg directory to be after make command has run.
Ignore COMMENTFILE.  COMMENT should now always work.
remove large unused portion of needs_refrseh for new ports

Disable debugging.

We don't always fetch the comment file because now COMMENTFILE and COMMENT
both exist.

remove trailing control-m's

chomp the longdescription and mastersites to remove trailing whitespace.
whitespace changes.

Check sth
whitespace

Add names provided by Chuck Rouillard.

First commit

Try doing the join a bit faster.

Look for external searches and reject them...

remove pring which was screwing up processing

Adjust quoting to get hostname

Don't commit prematurely

handle the temp file better

start using IsTaskAllowed from user class

Upon setting security notification, set housekeeping refresh = 2 for ports

whitespace

remove Rename, added in error.
add IsTaskAllowed

put a zero border around the security icon

Allow us to add users to tasks

remove unused code for start/stop
some whitespace changes

Add facility for marking a commit as security related

add TITLE field to icons
added freshports_Security_Icon
Added security icon to port description page
some whitespace changes

remove old and unused security_notice, security_notice_elements and security_notice_log
add tasks and user_tasks
start using new security_notice

whitespace

Start pulling stuff in from the new security_notice table.

Use AddSlashes correctly

fix use of freshports_BannerSpace

something wrong here I think, needs to be checked.

use freshports_SideBar

use the correct global name

fix copyright

Add DeleteAllLists

update copyright

use SetLastWatchListChosen and GetDefaultWatchListID

get rid of that double echo

include the database name in the message

Add key to housekeeping table.

Add switch for notifying committers

white space changes

whitespace changes

Set focus when the page loads

use wlid instead of watch_list_id
Starting using GetDefaultWatchListID
Make this work with multiple watch lists.

Use a div instead of a P

Change watch_list_id to wlid

Add FetchByName

Set debug off

Start using multiple watch lists

Retrieve data based upon category name, not category id.

Add headers to each mail message.

Add a new parameter, Headers.

white space changes

use echo freshports_ErrorMessage

Fix badly constructed code

Check for invalid names

Remove "explain analyze"

whitespace changes only

add:
users.watch_list_add_remove
users.max_number_watch_lists

limit watch lists to users.max_number_watch_lists

Handle the special case of no subscriptions.

use ' instead of "
whitespace changes
attempt to not wrap date

use $_REQUEST
use ' instead of "
Get it working again

use ' instead of "
use $_REQUEST

Convert to new User class
use ' instead of "

use $_REQUEST

adjust comments

some whitespace changes
Use User class.  use " instead of '.

Tell them about the multiple watch lists

add update_status
whitespace changes

Show deleted status
fix column wrap

Use the constants provided.

more whitespace changes

white space changes

use require_once instead of include

Use require_once

Add another note to help the user

Fix typo

Show which watch lists contain the element

remove commented out code.
Use UserID not User->ID here.
use require_once.

Add DeleteElementFromWatchLists

Add debugging flag

use require_once

start using new class User
lots of whitespace changes.

Start using class watch_list_element.
Use class User.