start using $_SERVER['DOCUMENT_ROOT'] . for PR 158

Lots of changes for PR 158
start using $_SERVER['DOCUMENT_ROOT'] .

First commit

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.

Standardize the date format

format the commit date better.

add scripts/hourly_stats.pl

Add daily_stats, daily_stats_data.

this works.  previous didn't.  don't know why.

move the get above where it is first referenced

add AddSlashes

add FreshPorts::Config::HourlySummaryDir

Rearrange items and add statistics

start using revision

start using the revision

use the defined HEAD

Start using version, but we'll use HEAD for now.

HTML tweaks.  no real changes.

First commit - a cron job for running daily statistics.

use $sort    = $_GET["sort"];

add missing $

use $visitor = $_COOKIE["visitor"];

use _SERVER

start using the _POST variables

use $_SERVER

use $method     = AddSlashes($_POST["method"]);

use _POST["variable"]

use $_GET["id"]

left align port name in the "Port from your watch lists" column.

use $_GET["category"]

use $_GET["remove"]

use $_COOKIE["visitor"]

Include version+revision in commit history for each commit

use _POST["<varname>"]

$_GET["message_id"]

helpful instructions for restoring a db

use _SERVER["DOCUMENT_ROOT"]

use _SERVER["DOCUMENT_ROOT"] instead of DOCUMENT_ROOT

Add this tarfile.

general tidy of HTML code

change .php3 to .php

Cater for watch lists correctly on lists of ports.

Add NumberOfDays

various mailto improvements

Add customizable number of days to show in history
Add mailto link for committer

also fetch ports.revision

fix display of things we want to be shown

Pull committer from the result set

AddSlashes on incoming data.
Remove some outdated code.

Fix the URL for the watch list

fixed typo.  evenshtein should be levenshtein

Update copyright

Update date in copyright message

rm _phpgraph as it is not used

not used in FP 2

grab is_clickable while we have it.

Add labels to graphs
Make some graphs clickable and some not

Add a trailing slash to the URL

minor tweaks for ports-new.php

minor tweaks to cope with changes for ports-new.php

Add Deleted Ports

Delete or activate the parent if a child is modified

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

clean this up for production

when calling freshports_PortDescriptionPrint, include
the URL to use for long commits.

move freshports_MorePortsToShow to include/freshports.php
when calling freshports_PortDescriptionPrint, include
the URL to use for long commits.

I have added the FP2 people.  so don't say I haven't.

Fix the map file name

more permissions

remove files not in FP2

fix syntax

html fix

html fix

html fix

removed.   not on branch

Let's go back to 100% width tables.

Use $PHP_SELF

Add disclaimer.

Use $db not $conn

put FreshPorts in the title of the cached file.

Let's put it all together.  Looking good for graphs.

fix HTML

First commit

remove extra </P>

Almost there.

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

Add news feeds

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

Add date/time loaded.

Add "Add tab to Netscape 6" button

Call our copyright function

First commit.  Used for netscape 6

use DOCTYPE 4.01 Transitional
and call htmlspecialchars

Remove references to the phorum, which is gone.

Add committer to message

Use onwatchlist not watch

mention FreeBSD

Don't show the description link

Let's use play instead of a bullet for long commits

Icon tweaking.

Show only the first 10 ports of a commit.  Then link to the commits.php page.

add $ to pr2html functions so "http://example.org" is converted to an HREF

Add status to ports_all

Pass watch lists id to call to files.php

Add some missing elements to the commit, including watch list support.

Add some missing fields and standardize date/time format to get
encoding_losses running.

cater for older xml encodings without EncodingLosses

tag the file as UTF-9

Add EncodingLosses

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

Add EncodingLosses
TRUE  - characters were changed to conform to UTF-8.
FALSE - otherwise

commit out debugging

Add link to BSDMall

Add watch and watch add icons.

Add TITLE strings to images
Add pr2html

Add ports_all to permissions

include commit link within the files page

Allow searching by message_id

globalize that variable so we can get to the CVSWeb page

urls are now transparent.

fix typo

Start using the new deleted and refresh icons.

Add domain renewal time

Add commits_latest_tmp.message_id so we can link from the webpage to the
mailing list archive.

call freshports_Email_Link

call freshports_Email_Link
fix typo in SystemTimeAdjust()

oops, reverse the sign on SystemTimeAdjust()

Grab port_id and adjust the time using SystemTimeAdjust()

Use SystemTimeAdjust()

Tidy up the interval.

Remember to use the system time adjustment

merge from branch

merge to branch

Add new caching functions to keep track of updating the cache

if commiting a port, call DailySummaryDateAdd

- update copyright
- remove mistakenly copied routines
    - ReadFile
    - FetchFile
    - InitSyslog
    - ReportError
    - SendEmailNotice

move CreateDailySummary to new cache.pm module

moves this file around.

white space changes only

Allow URL of /category/ports/files.php?commitid to show files affected
by said commit it

remove ports2, categories2, and element2
no idea where they came from

Add Daily_Refreshes table and function for adding stuff to
and removing entries from.

No longer needed

First import

doh, change the right line

Upgrade to latest on FreshPorts2

spelling mistake changes, etc.

Make the functions previously in sp-config.txt.sample data driven
and move them back into sp.txt

Add committer to front page.

put category after the port and smaller.

Fix a broken </B> tag

If the email test fails, set the flag.

Use Combined logs not Common (so we can see the referer)

Get the URL right

This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.

Put this on the branch

This is a great port for installing ports needed by FreshPorts

Let's use fetch, not lynx

Tidy up directories

Make the first column of the table 100%

remove extra unneeded table

merge two statements

Change date format to include time zone

Add missing VALIGN

Add a link to the FTP site for each port
rename the Changes link to CVSWeb

Include the correct field on the form so that searching from the side bar
will provide results on the search page instead of just going to the search
page.

Also add a bit more debugging info on search.php

Fix the default email address

files should be non-empty

Put the hostname in there

add instructions for soundex

add previously ommitter permissions

rename the Bugs link to Problem reports

update PortVerifyBegin to use new ports_check strategy

remember to update the categories field.
pr 114

use ports.revision/version if commit_log_ports value is null

PR 112
watch_notice_log.frequency_id needs to be implemented

changing frequency to frequency_id
check scripts/email.pl and AddToLogs

new layout

not much

RecordLastestPortCommits now works independently of date. and uses a view.

Start using our view so we only get all the ports for the last 100 commits

update copyright

There is no need to grab the commit_log id first.  It will be obtained
by the commit_log class.

Add Makefile.inc to the list of things we ignore

If we try to add a file into the tree, and it's parent is a file,
change it to a directory rather than raise an exception.

Put the committer into the output

Tidy up the whitespace etc so it looks better in the HTML

Mark those ports found in the INDEX and those not found.

remove SQL used before we started caching

Let's start logging changes to the staging area.

adjust comments to be accurate

*** empty log message ***

add links to the help page

Suggest they use the search list to add unfound ports to their watch list.

*** empty log message ***

"Your browser must allow cookies for the login to work."

OK, now we have staging area clear, and update watch list working.

use fetch, not lynx

Use the new ports strategy from pkg_info -qoa

remove gtabug note, add FreshPorts2 note

checkpoint - about to change to pkg_info -qoa output

Added new tables: watch_list_staging_results & watch_list_staging
for use with processing pkg_info uploads

We can now upload 282 ports from pkg_info and process it in 2 seconds.

Just string to modify the process to use
the database, not INDEX.

Update permissions and instructions

update copyright

add retry directory and update copyright

move failed files to a new retry directory

add ip-address to users table.

remove a commit

use HTTP_HOST instead of hardcoding the host name

don't let disable or unconfirmed users login

standardize that table.

we don't automagicaly log people in now.  so don't try to display their user name.

New users must now supply a valid email address.  Instructions
to enable their account are forwarded to that email address.

Add copyright notices

we no longer need lynx

display the full file name when processing

Check for blank branch name

Add a banner to the faq

The announcement

IF YOU CHANGE THE MAKE COMMAND, CHANTGE THE SPLIT!!!!!!!!!!!!!!!

we'll have to refresh all ports now.

Add an incompleted FAQ

Start taking notice of WatchListID

Add search to the front page

Lots of tidy up, no real coding changes.  just make things look better.

Use 1/0 for onwatchlist

adjust debugging code

Don't die with an error, just report it.
We will clear refresh_now so the SP
doesn't have to.

tidy up html
replace mysql with postgresql
upgrade php graphic

include getvalues so we so who is logged in

use AddSlashes correctly

put sidebars in there

Put the sidebars in here

include element_id so watch list add/remove can work

OOPs, 24 hours clock, not 12.

Hmmm, dates weren't looking right, let's do this instead.

remove debugging info

move debugging info into a previous if

display the date in the default format

This service is down by default

let's use fetch instead of lynx

remember to install procmail

missed this

things to do before running

let's make this into a daemon-type script for use with daemontools.

lastest and greatest

put add/remove in small font

center the form

adjust some debugging information

Use the right script

remember to include housekeeping module

New class.

Don't commit here when refreshing ports. We'll do that lower down in the
code.

Added "Forums" to the menus.

Clear the refresh_done bit.

Include the revision, if non-zero, as <VERSION>-<REVISION>

Adjustments for new style

how was this missed?

oh geez, I forgot all this stuff!

Ahhh, we need these too!

if a watchlistid is supplied, use it to display +/- on the page
for each port

rm phorum.  we are going to import phorum version by version

Change how we do phorum.  This is phorum-3.3.2a

Let's have a look at the Makefiles before we use them.  If they are
ASCII Text, then they are probably a Makefile.  If not, they are probably
HTML, and that means the fetch failed.

link to the daemon copyright page only from the front page.

The link to the port should contain a trailing /

no longer any need to create daily summaries here.

Make sure we put the basic data into the system so it is usable.

Add two new tables: commits_latest housekeeping

how about only doing the SQL if there is a need to do so

start using freshports_PortDescriptionPrint

remove old FP1MigrationCutoffDate code
create new freshports_PortDescriptionPrint which will centralize the
formatting of port commit messages, long descriptions, and short
descriptions.

whitespace changes only

center the ad.

remove code from old versions
add our footer to the bottom

Fake commit to branch

This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.

Add single click watch-list maintenance.

If it really is a 404, then display a nice message.

that should not be here

does this go to the right branch?

add a bit more text so the user knows what to do on this page.

ummm, use IsSet instead of defined.

use text instead of varchar in Element_Pathname

Start using "make master-sites-all" instead of "make -V MASTERSITES"

Add the ports.categories field to the schema

Change date_created to date_added

Get rid of extra ID tag

script to create ~/msgs

daemontools is a nice way to keep scripts around as daemons.

Add flag -R which means do not refresh any ports associated with a given
commit.  Useful during the fp1-fp2 migration.  We'll just refresh each
port after the data is imported.

If an invalid file action is found, display it as well as report it.

add link to daemon copyright

allow incoming parameter to set limit
If file_action = 'I' (import) used add and change filename to '.../Makefile'

remove an unused ElementTagSet and modify the one which is used.
before we insert into system_branch_element_revision, ensure
the entry is not already there.

don't fetch stuff if -r flag is set.

Here's the file where will allow us to export
FP1 data into XML format.  Looks OK so far.
But will need further testing of output

Add port_revision to commit_log_ports

if the code dies, email me

Add new commit_log class
Start using new ReportError function from utilities.pm instead of calling
SysLog and die.

oops, don't do asc on indexes.

add default values for some timestamp field
add index on commit_log(message_id)

my first thoughts on data migration

doh!  do not hard code path names!

add map link

center the table containing the logo

When an error occurs when processing a make file, return the error to the
calling function.  Then, don't update the port because it's not ready

umm, ports-supfile is in ~/scripts not ~/

get rid of duplicate page name

PR#21
cater for imported sources.  With a recent change implemented by Josef Karthauser,
imported source cvs-all message do contain a BRANCH.  However, the
message do not contain a LOG section.  Thus the XML field is empty.

Get around the problem with a minor reorganization of the code.
Grab the message subject. Grab the log.  If the log is empty, use
the subject.

ALSO: white space changes.

Add a link to the port tarball.
Add a link to the port_upgrade.php page for logged in users.

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

add freshports_GetNextValue for incrementing and obtaining a sequence.

put a bit of spacing around the fields so it looks better

simplify WatchListAdd so you provide the watch list id and the element pathname

Remove include of classes/watch object

create and use a new function freshports_CookieClear to be used
when a person logs out or when we ware given a cookie which
we don't recognize.

no longer needed

add copyright

convert to PostgreSQL

Unless stated otherwise, everything should work now.

upgrade to postgresql.

Now that this is done, the next step is to get some of you on the Develop list
to start tracking your ports via fp2.freshports.org.  BUT FIRST I'll have to
upgrade that site to the latest database and scripts as found in
lists-test.freshports.org.  Watch this space.

Massive HTML tidy up.  Mostly only whitespace changes.

Only try getting the port if the port name is set and non-blank.

Changes to update_description so it in in <PRE>..</PRE>

convert to postgresql

Use website title

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

Rename categoryResult to LocalResult.
This file set by caller so you can set up an SQL statement and then
get Port to fetch itself for you.

remove extra <BR>

convert customize.php to use postgresql
lost of whitspace changes to getvalues.php which was also changed to postgresql
include/freshports.php now includes classes/watchnotice.php

mysql was case insensitive.  postgresql isn't.  therefore convert login ids
to lower case when comparing.