create msgs directory
Let's use fetch, not lynx
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
Tidy up directories
Tidy up the directories
Make the first column of the table 100%
remove unneeded table
remove extra unneeded table
remove some outdated links
merge two statements
Instructions for merging data and user information
Change date format to include time zone
convert to use cache table
Add missing VALIGN
Don't show the category name when showing all ports in a category.
Add a link to the FTP site for each port rename the Changes link to CVSWeb
Latest version
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
Ajust DD DT and DL tags PR124
Fix the default email address
Fix hardcoded domain name
files should be non-empty
There are two phorums
Put the hostname in there
add ports_active
add instructions for soundex
Add this missing file
add previously ommitter permissions
scripts for comparing the database with a list of category/port entries.
rename the Bugs link to Problem reports
- add list of options required in PowerDesigner 6.0 to generate this database schema - modify ports_check replacing found_in_ports wih category_id and port_id - create index on ports (element_id) - create view ports_active
update PortVerifyBegin to use new ports_check strategy
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
remember to update the categories field. pr 114
Add revision to commits_latest
use ports.revision/version if commit_log_ports value is null
latest changes
PR 112 watch_notice_log.frequency_id needs to be implemented changing frequency to frequency_id check scripts/email.pl and AddToLogs
Alter watch_notice_log, rename frequency to frequency_id and add FK to watch_notice. add view commits_recent.
new layout
Add main page search
not much
Add commits_recent view used to ensure the last one hundred ports are listed.
RecordLastestPortCommits now works independently of date. and uses a view.
RecordLastestPortCommits now works independently of date.
Start using our view so we only get all the ports for the last 100 commits
remove DROP FUNCTION statements. change CREATE FUNCTION to CREATE OR REPLACE FUNCTION to avoid dependency problems which arise when you drop a function which is used by another function.
update copyright
call freshports_ConverPortPathToStandardLocation
There is no need to grab the commit_log id first. It will be obtained by the commit_log class.
Add freshports_ConverPortPathToStandardLocation, which will change path names to the standard /usr/ports pathname
Add Makefile.inc to the list of things we ignore
standardize the URLs used to show RUN DEPENDS and BUILD DEPENDS. PR 110
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.
Let's try distinct, just in case...
Put the committer into the output
Latest and greatest
Tidy up the whitespace etc so it looks better in the HTML
Bring up to working state
Mark those ports found in the INDEX and those not found.
Add functions for checking /usr/ports/INDEX
remove SQL used before we started caching
Let's start logging changes to the staging area
Let's start logging changes to the staging area.
Let's start logging changes
adjust comments to be accurate
WatchListStagingMergeWatchList is no longer used
*** empty log message ***
remove some unused but duplicated references
add links to the help page
better formatting
Suggest they use the search list to add unfound ports to their watch list.
Add soundex to the search page. Allow the user to go from staging area to search page for ports not found.
*** empty log message ***
Start a help file for use with the pkg_upload.php page
"Your browser must allow cookies for the login to work."
Add "Your browser must allow cookies for this login to work."
OK, now we have staging area clear, and update watch list working.
make the table borders look like the rest of the site.
use fetch, not lynx
new pkg_info -qoa strategy
Use the new ports strategy from pkg_info -qoa
make WatchListID global. fix some white space.
remove gtabug note, add FreshPorts2 note
major change to use pkg_info -qao
checkpoint - about to change to pkg_info -qoa output
Now we have the results split into multiple tables.
Added new tables: watch_list_staging_results & watch_list_staging for use with processing pkg_info uploads
stuff for processing pkg_info uploading
We can now upload 282 ports from pkg_info and process it in 2 seconds.
Make sure the values set by getvalues are available everywhere by declaring them to be GLOBAL. If a disabled account is found, log them out, and let them know.
Just string to modify the process to use the database, not INDEX.
split the SQL into a seperate file so we can do psql DBNAME < POSTGRESQL.sql
Update permissions and instructions
sleep at the start of the script, not the end. if an error occurs, we don't retry it right away.
update copyright
update copyright change return value of 3 to 0 if all is well we don't move files around. the fp-daemon script does
add retry directory and update copyright
need to create the directories
move failed files to a new retry directory
get it right
add ip-address to users table.
turn off debugging
remove a commit
add debugging
use HTTP_HOST instead of hardcoding the host name
specify a full URL using hostname and origin. this should avoid some problems with Opera
don't let disable or unconfirmed users login
Don't show the about graphics here.
standardize that table.
Add ConfirmUserAccount
we don't automagicaly log people in now. so don't try to display their user name.
don't allow blank passwords
New users must now supply a valid email address. Instructions to enable their account are forwarded to that email address.
when a new user is created, add a token to user_confirmations
Add copyright notices
Consolidate the documentation:
we no longer need lynx
Put copyrights into scripts
display the full file name when processing
umm, we should have the log file in the repo
Check for blank branch name
All make commands must refer to the correct ports tree via PORTSDIR=
Add a banner to the faq
wrap commit messages at 80 characters, not 72
The announcement
lotsa q+a
IF YOU CHANGE THE MAKE COMMAND, CHANTGE THE SPLIT!!!!!!!!!!!!!!! we'll have to refresh all ports now.
add stuff on phorum
Add an incompleted FAQ
New class
Start taking notice of WatchListID
oops, problems in headers/footers. let's fix that.
Add search to the front page
looks good for avoiding deadlock on slower machinesk
Lots of tidy up, no real coding changes. just make things look better.
Improve the search add/remove so you get back to the orginal search.
Use 1/0 for onwatchlist
Include the WatchListID so we see add/remove put the footer in a 97% table
adjust debugging code
let's add a commit-rollback just for fun.
Don't die with an error, just report it. We will clear refresh_now so the SP doesn't have to.
replace mysql with postgresql upgrade php graphic
tidy up html replace mysql with postgresql upgrade php graphic
add some user documentation
include getvalues so we so who is logged in
remove border
use AddSlashes correctly
use AddSlashes and do some debugging stuff
put sidebars in there
Add the other-copyright
Put the sidebars in here
instructions for this dir
include element_id so watch list add/remove can work
we need to include the watch list id on this page. remove some old cache code while here
OOPs, 24 hours clock, not 12.
we need the committer in here.
Hmmm, dates weren't looking right, let's do this instead.
Tweak the sort.
remove debugging info
add function IsOnWatcList
move debugging info into a previous if
When we add a user, create their watch list.
display the date in the default format
remember to timezone adjust the commit date
This service is down by default
we really need this
let's use fetch instead of lynx
change LooksLikeAMakefile to be correct more often
remember to install procmail
add .forward
missed this
Add these into the repo
things to do before running
notes on setup
let's make this into a daemon-type script for use with daemontools.
First commit
lastest and greatest
The first thing we do is reset the refresh bit in case any refreshes complete while we are updating.
put add/remove in small font
standardize the banner messages
center the form
Adjust the watch list slight. eye candy.
adjust some debugging information
Show Add/Remove on the port page.
Use the right script
at the end move the input file away to the raw directory
remember to include housekeeping module
oops, never put this into CVS
New class.
Start using the housekeeping class
Don't commit here when refreshing ports. We'll do that lower down in the code.
After refreshing a port, update housekeeping.
Added "Forums" to the menus.
Add a new column to housekeeping, refresh_done. Any time a port is refreshed, this bit should be set. It will be cleared by RecordLastestPortCommits.
Clear the refresh_done bit.
Mention that this login isn't the same as the main login.
Include the revision, if non-zero, as <VERSION>-<REVISION>
new style
Adjustments for new style
adjust the header/footer for FreshPorts
how was this missed?
add some notes on setup...
oh geez, I forgot all this stuff!
Ahhh, we need these too!
Ahhh, we need these too!
use the commits_latest not the ports table for the PORT ID when displaying +/-
if a watchlistid is supplied, use it to display +/- on the page for each port
Commit phorum-3.3.2a to the tree
rm phorum. we are going to import phorum version by version
remove all this stuff
Change how we do phorum. This is phorum-3.3.2a
Slight adjustment to error returns
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.
only refresh non-deleted ports
link to the daemon copyright page only from the front page.
Add latest details of caching, user manual, etc.
The link to the port should contain a trailing /
only do the table update if a new port has been committed.
no longer any need to create daily summaries here.
no longer a need to touch a file after refreshing.
Make sure we put the basic data into the system so it is usable.
add some raw data into the required tables
Add two new tables: commits_latest housekeeping
Add two table: commits_latest and housekeeping which will be used mostly by RecordLastestPortCommits which records the query results into a table for easy retrieval.
how about only doing the SQL if there is a need to do so
To speed up the home page, we are going to cache the data in a table. The main page will then read from that table. The main page will be updated every minute.
start using freshports_PortDescriptionPrint
tidy up and bring up to standard
remove old FP1MigrationCutoffDate code create new freshports_PortDescriptionPrint which will centralize the formatting of port commit messages, long descriptions, and short descriptions.
tidy this up a big.
whitespace changes only
update information about latest work
center the ad.
comment out that message. I don't think we need it. PR# 87
remove code from old versions add our footer to the bottom
pull back all ports, not just those with commits ignore deleted ports
Fake commit to branch
Add a link to the commit details to the front page. Modify the details on the port page to be more like the main page.
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
no changes
Add single click watch-list maintenance.
fix a broken tag
If it really is a 404, then display a nice message.
general updates to website
that should not be here
Make it more user friendly
does this go to the right branch? add a bit more text so the user knows what to do on this page.
minor adjustments. and use IsSet instead of defined...
ummm, use IsSet instead of defined.
now that we have a good wrapping scheme for lines > 72 characters, we don't have to treat pre and post migratin data differently.
use text instead of varchar in Element_Pathname
The migrated fp1 commits are single line log messages. They must be wrapped. Therefore, use <CODE> if before a certain date, and <PRE> afterwards.
Start using "make master-sites-all" instead of "make -V MASTERSITES"
Refresh all ports.
Add the ports.categories field to the schema
refresh-unrefreshed-ports.pl stays as it was, refreshing unrefreshed ports based on commit_log_ports.needs_refresh.
Change date_created to date_added
rename date_created -> date_added
Get rid of extra ID tag
Add a flag which allows us to refresh all ports. useful during fp1-fp2 migration
script to create ~/msgs
OK, add this back in where it should be.
daemontools is a nice way to keep scripts around as daemons.
Standard project directories initialized by cvs2svn.
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.
talk about latest changes to migration details
If an invalid file action is found, display it as well as report it.
don't export deleted ports - they won't exist in the ports tree and we won't be able to refresh the port. This does mean we lose the history for about 451 deleted ports. I can live that that. We can always import them later.
add link to daemon copyright
use DOCUMENT_ROOT
allow incoming parameter to set limit If file_action = 'I' (import) used add and change filename to '.../Makefile'
Add incoming limit parameter
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.
remember to clear out MessageTo in case there is more than one recipient.
don't fetch stuff if -r flag is set.
oops, use PST not EST
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
Create a monthly compression archive. note that the other compress script appears to be unused.
Add port_revision to commit_log_ports
make sure utilities is included where it should be included. and that config is included in utilities.
if the code dies, email me
Use new error routine
Add new commit_log class Start using new ReportError function from utilities.pm instead of calling SysLog and die.
instead of a <BR>, put a space before [deleted].
oops, don't do asc on indexes.
commit that stuff
add default values for some timestamp field add index on commit_log(message_id)
updated, white background.
my first thoughts on data migration
make sure to use " not ' when expanding $variables.
doh! do not hard code path names!
add date time
add map link
First commit
center the table containing the logo
I should test more before committing.
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
Put a knob in to turn off creation of a pkg directory. I think I added this to detect problems which arose if this directory exists. noteably: pre-everything having two : after it.
umm, ports-supfile is in ~/scripts not ~/
We need a custom supfile for this. Let's also add a cvsup to the crontab.
get rid of duplicate page name
use PRE tags around the commit description and the file names. remove the file graphic and make the cvsweb hyperlink on the file name instead.
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.
Ensure all references to images directory starts with /images. This is most for use by the missing*.php files.
Add a link to the port tarball. Add a link to the port_upgrade.php page for logged in users.
Put the port tarball into the tree. We'll store it here until it gets added to the FreeBSD ports tree.
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
Upgrade the port for uploading your pkg_info data.
add freshports_GetNextValue for incrementing and obtaining a sequence.
After a reco-copy of these files from another section of the tree, we now have a process by which the user can upload their pkg_info information and add them to their watch list.
put a bit of spacing around the fields so it looks better
white space only
simplify WatchListAdd so you provide the watch list id and the element pathname
Update the SQL which records that a logged in user has accessed the website. We track the last time they logged in so we know whether or not an account is active. We do not record what pages they are visiting.
Remove include of classes/watch object
when we find an unknown cookie, clear it.
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.
Add copyright
no longer needed
Add copyrights
add copyright
Add copyright
convert to PostgreSQL
Add copyright
Start using ${HOME}
Unless stated otherwise, everything should work now.
Adjust the HTML to be centered and 98%. Missed this during the recent mega-adjustment.
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.
Add in the copyright notice. fix up the paths to refer to HOME
Massive HTML tidy up. Mostly only whitespace changes.
change freshports to FreshPorts
Only try getting the port if the port name is set and non-blank.
Add update_description to class
Changes to update_description so it in in <PRE>..</PRE>
white space change only
convert to postgresql
convert to postgresql
Use website title
*** empty log message ***
Add some debugging code. for ports, make sure we don't include commit log information when retriving by partial path name.
use the predefined website name add a bit of cell padding use an outer join to get the correct count value
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.
convert to postgresql PR 45
remove extra <BR>
whitespace only
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
remove the <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> entries because they are all in include/freshports.php
mysql was case insensitive. postgresql isn't. therefore convert login ids to lower case when comparing.
oops, insufficient testing failed to find wrong field name.
Convert to postgresql
Convert to postgresql from mysql
Add a new class.
Rename files from .php3 to .php. The code within many of these files still needs to be converted from mysql to postgresql.
reaname this file
update copyright date
update copyright year
Oops, forgot to commit this. Add FetchByID and FetchByCategory.
convert to use recently created ports.php class and redirect to <category>/<port>/
add another simple test
remove debugging code
simple whitespace change
$hash{portname} is not the same as
$hash{$portname}
Fix this annoying bug so more than just the first port in a commit gets refreshed.
daily summary changes - use category/port format - add time-ajustment factor to cater for time zone differences
Reconcile code which existed in both files: include/freshports.php missing-port.php
convert to postgresql
Put website name into a global variable.
Handle return HTML from missing-port.php
If they get the category right, but provide an unknown port, tell them and then show the link to the category they provided.
slight table adjustments
use <category>/<port> URLs
convert to use postgresql. include revision_number in output
stop using category.php3 in favour of <category>/<port> URLs.
- correct where the script was still using ports.needs_refresh instead of commit_log_ports.needs_refresh. - for now, we will fetch every file touch by a port commit. I still don't have a solution for files included by Makefile.
Use $ENV{HOME} not ~/
Handle deleted ports better. Remove the path-to-ports so it works with symlinks.
Add some real-path calls so we have the real pathname instead of symlinks.
Start using the new format URLs and use $SERVERNAME to determine the URL instead of hardcoding http://www.FreshPorts.org/
oops, missing some leading and trailing / and a missed category.php3
start using <cateogory> and <category/port> instead of category.php3 and port-description.php3
oops. fix a typo
slight whitespace change to make SQL easier to read
after refreshing a port from newly fetched files, let's actually save the results to the database.
in CreateDailySummary, use commit_log_ports.{port_version|port_revision}
handle port_version
move the commit to be before the CreateDailySummary call. If that call falls over, we want to be sure the transaction is closed. otherwise, it will roll back and undo what we did.
Now you can broswe to a category: http://www.freshports.org/<category>
Slightly modify broken/forbidden message by adding words to the graphics which were already there.
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.
PR 26 We should now be able to browse to any port via <category-name>/<port name>.
start using commit_log_ports.needs_refresh instead of ports.need_refresh which is now deprecated.
add ErrorDocument 404 /missing.php PR 26
pull back more detail into the port class. This should be enough for the port-description.php functionality to be put into a function rather than a webpage. PR 26
Start using commit_log_ports.port_version not port.version
update to use commit_log_ports.needs_refresh not ports.needs_refresh
- with master/slave ports, the directory we are fetching to (master port) may not be the directory we are working in (slave port; the one being refreshed. adjust fetching scheme accordingly. - add function to remove port directory prefix (RemovePortsPrefix).
start using $ENV{HOME} so we know the correct home directory without modifying
this config file.
slightly modify the SQL to match similar query in refresh-unrefreshed-ports.pl
Update this script to use commit_log_ports.needs_refresh instead of ports.needs_refresh PR56
use relative paths, not absolute
Add call to script to archive out messages.
change default pathnames to be relative not absolute
It appears we have a working solution for storing port version with each commit.
My first attempt at moving needs_refresh from the port table to the commit_log_ports table. In addition, the commit_log_ports will hold the port_version associated with that commit. Thus, as you look down the page, you should be able to see the port_version change from commit to commit (not that every commit causes a change).
remove comments no longer relevant
No longer needed here
Includes commit_log_ports
Includes commit_log_ports.
Latest build
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.
Standard project directories initialized by cvs2svn.
barh! removed a LIMIT BY 3 which rather restricted the output.
remove a echo mysql_errno() left in after debugging
slightly change the text
Move formattime from index.php3 to include/freshports.php
Add the new archive-messages.sh. call this from cron. it will call the improved archive-logs.sh which will move the msgs away from the main directory and archive them.
correctly detect the successful opening of a file for our daily summary output.
test for packages.exists file before we grep from it
Upgrade to FP2
provide a new option: -O (Overwrite) when processing an XML file, if the supplied message id exists, delete it and continue processing. Useful when you need to reprocess a message for some reason.
use the commit_log_ports table, not commit_log_port.
upgrade to FP2
put default values which make sense but can't be used.
Remove some commented out code
First commit
New FP2 version of script
First commit
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
Add copyright notices and Id tags to each file.
Add copyright notice expand messages when Makefile errors occur
Add copyright notice start using the new and improved commit_log_ports
This commit was manufactured by cvs2svn to create branch 'FreshPorts1'.
Add link to stats
use LocalTimeAdjustment for displaying the date/time at the top right of the webpage.
use the new values CVSTimeAdjustment and LocalTimeAdjustment
Add two new values: CVSTimeAdjustment - difference in seconds between CVS server and database server. LocalTimeAdjustment - differnece in seconds between web server and user. Plan is to allow the user to override either or both of these settings to suit their location.
commit_log_port has been renamed commit_log_ports
Use DOCUMENTROOT for pathname.
add some testing scripts
first commit. includes instructions about installing perl modules for these scripts.
Add link to developers.php
fix type (reason => reasons).
convert some HTML tags to lower case which don't work in upper case on Opera (LT, and GT).
convert all varchar(x) fields where x > 1 to text
Add new tables:
Security_Notice - details of notice
Security_Notice_Log - who added the notice, who moderated it, modified it
Security_Notice_Elements - what elements of the source tree are affected?
...for use with security notifications.
Change to landscape. It won't all fit on the screen in portrait and be big enough to read. Rename commit_log_port to commit_log_port_elements. Add commit_log_port which does what it should.
Add commit_log_port and renamed commit_log_port to commit_log_port_elements
don't save commit_log_id unless it is supplied.
better folding style to match Vim/Emacs standard
Fixing folding
Put the main tap at the top of the cell vi VALIGN="top"
Add some basic code to cater for master/slave ports.
ensure we take the commit date before we clear out all the date values.
add missing ) to an if. actually write HTML to FILE.
If the version isn't set, don't try to display it
Don't do the build of daily summaries until after we have refreshed the ports. Otherwise for new ports, version will be empty.
Don't do any of the port update things if there are no ports. This mainly reduces the size of the log file.
don't quote the date
Remove trailing / from 'use lib' statement.
Add CreateDailySummary to the list of things that happen when a message is processed.
remove : introduced during last commit
For broken and forbidden ports, display just Broken or Forbidden in the ALT text, not the actual text of the broken/forbidden message. For the commit message itself, yes, we're going to use <PRE></PRE> until we can find a better way.
update the to-do list to remove things done and to point to MANTIS for everything else.
If a port has been deleted, make sure we delete the element which corresponds to that port.
use the ports.date_created field.
Add system.time_adjust field
pick up newly added ports.date_created PR 55
convert category function to postgresql
comment out code not needed.
replace a </BR> with a <BR>
first commit
Remember to update the date
Add user_confirmations table for email verification
This commit was manufactured by cvs2svn to create branch 'FreshPorts1'.
remove the HEADS UP notice.
Add a short introduction for developers who are new to the project
restrict result set to 100 rows.
remove a pg_exec ($database, "end"); which was causing this: [Tue Nov 27 01:33:54 2001] [error] NOTICE: COMMIT: no transaction in progress
When displaying the commit message, turn all links into hyperlinks.
use nl2br instead of PRE
add $db parameter to freshports_PortDetails remove unneeded caching code
freshports_PortDetails now needs $db use nl2br where we once used <PRE>; this allows us to have the same line breaks, but in a better font. takes less real estate too. change a while loop to a for.
freshports_PortDetails now uses $db
Add $db parameter to freshports_PortDetails fix broken subject field on mailto: change a </BR> to a <BR> Change "download port" link to FreeBSD.org website Add conversion utilities for add hyperlinks to text upper case various tags.
call freshports_PortDetails instead of including ./include/port-basics.php pretty some of the HTML output by adding \n fix the HTML by adding missing end tabs (</DD>) enclose the commit description within <PRE></PRE>
sort the files by name make the displayed pathnames relative to the port directory (i.e. remove /ports/<category>/<port>/ from pathnames
make the HTML output look better by adding a few \n
comment out some debugging code
commit work done today. upgraded to postgresql.
converted to FreshPorts2
Upgrade to FreshPorts2
Include both the develop mailing list and the cvs-all mailing list.
Add link to http://fp2.FreshPorts.org/
Move things around so they work better.
Whitespace changes. Add $FreshPortsName so we can change the name as needed.
Start using $FreshPortsName. general tidy up.
Upgrade to postgresql.
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
remove outdated news items
remove CommitLogElementsInsert replace EnsureCategoryAndPortExist with SaveChangesToPortsTree create _CompileListOfPorts which replaces the fuctionality of EnsureCategoryAndPortExist Instead of saving a port as we go along, we will compile a list of ports based on the files we find. Once all files are processed and saved to the database, we have our list. Then we process the files again, setting the needs_refresh value for the port affected by this file. If we find that the Makefile for a port has been deleted, we set needs_refresh = 0.
correct some on delete cascade...
use a hash instead of a character string for ignored files
first commit
Make sure we are looking for " Revision" at the start of the line. See 200111231716.fANHGwN21197@freefall.freebsd.org for what broke this.
if the port is new and has not been deleted, then set needs_refresh.
make the title page say commits
more typos found by kelleye
fix typo pointed out by Kelleye
remove unneeded exports
if the port has been deleted, make sure we set port->{deleted} correctly
and process things.
move the refresh ports process to port.pm so it can be used
both with load_xml_into_db.pl and from refresh-unrefreshed-ports.pl
separate out the refreshing of a port from the saving of a commit message.
now we have the time zone correct to PST by default.
first commit
latest and greatest
Always check if the ElementRevisionExists before doing a ElementRevisionInsert.
directory_file_flag should be F or D. make some RI constraints cascade not restrict
directory_file_flag should be F or D. make some RI constraints cascade not restrict
remove GetOrCreateCategory which was not used. Remove quotes from field names which screwed up the category entries.
Looks good. broken, deleted, refresh and forbidden need to be tested.
Name things correctly
Spell the path correctly
remove exta my.
remember to set status in element.
use SystemID not SystemBranchID
commit_log contains a field called description, not update_description
log it when we create a new branch
fix typos
rename system_version to system_branch rename system_version_element to system_branch_element_revision
check for failed file open
rename system_version to system_branch rename system_version_element to system_branch_element_revision remove some unneeded sequences
remove comment to enable drop trigger.
rename system_version to system_branch rename system_version_element to system_branch_element_revision
rename system_version to system_branch rename system_version_element to system_branch_element_revision remove some unneeded sequences
add ID to head of file.
New stuff
add commit_log - commit_log_elements integrity
Add stuff about creating INDEXES
for latest changes
Put <PRE></PRE> around the commit message to preserve line breaks.
clean up code, check for port and category before deciding this is a port
PR 4 solved. scan the lines following the subject and include them as part of the subject if they start with 9 spaces.
fix typo. should be OBTAINEDFROM not OBTAINED in the dtd.
The previous commit was in error. PR 15 Previously the log message was terminated at the first occurance of: Revision PR: Submitted by: Approved by: Reviewed by: To Unsubscribe Now it's only: Revision To Unsubscribe Also, populate the ObtainedFrom field while we are here.
PR 15 Previously the log message was terminated at the first occurance of:
This is what used to be ports.php. We might find it useful as a debugging tool, so I moved it here.
Go to a FreshPorts - like format
bring back only one line per port changed by commit
This commit was manufactured by cvs2svn to create branch 'FreshPorts1'.
spell receive
About time we put these into cvs
first commit
add link to processing overview
add the revision field.
Use commit_log_element
provide a way to get a category/port from a pathname
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
This commit was manufactured by cvs2svn to create branch 'FreshPorts1'.
Update to new version: new commit_log_elements and system_version_element table. add commit_log_port table for direct links between a port and a commit.
Use new class: commit_log_port
use ne instead of eq. condition was wrong.
instructions for creating database schema
updates
This commit was manufactured by cvs2svn to create tag 'FreshPorts2'.
add missing files
Get those values from the result set.
save the right stuff when saving. it still needs to be read back in.
use the right id
put it all away again
change ports table
Now we fetch the files needed to refresh the port, we update the port class, and we save it. port.pm needs to be updated to save and fetch more fields.
set the commit id before saving
Move ReadFile to a common location.
remove code we've already converted
correct the sql for updating a port
remove unneeded comment
Add new descriptions
recent additions and updates
when a port is created, needs_refresh is set correctly. now we need to set that when a port is updated.
first commit
needs_refresh is now being computed. We have have to do something special for ports which are created first time.
Now processing the files and ports correctly. now we just have to parse the file names and update the port needs_refresh.
We now have a list of ports which needs to be updated. next step: set the needs_refresh field and then save the results back to the database.
Create a hash of ports...
whitespace changes only
fetch by partial name
checkpoint
just a checkpoint
Ummm, let's get the element_id of the port before we create the port.
Remove GetDBHandle and use the one provided by FreshPorts::Database. use $dbh not $dbh_pg
die if "is_primary" is not set.
use the recently created FreshPorts::Category and FreshPorts::Port classes
Move GetDBHandle to database.php Add test_port_save
port.pm and category.pm are done.
Updates to scripts
Add GetCategory(int4)
Add CreatePort
Just another checkpoint
This commit was manufactured by cvs2svn to create tag 'beta'.
first import
Standard project directories initialized by cvs2svn.
Make save work.
This commit was manufactured by cvs2svn to create tag 'beta'.
This commit was manufactured by cvs2svn to create tag 'beta'.
first time
Add the ID to the file
Add IsPortsTree return TRUE if the element exists under the ports tree
Remove space in width field. This causes problems with Opera.
doh, wrong website
Add lnb's ad.
ouch. news.php *is* different from everything else. don't make it the same.
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
put date small
remove channel reference.
simplify things greatly
This commit was manufactured by cvs2svn to create tag 'ads_2000_10_20'.
This commit was manufactured by cvs2svn to create tag 'ads_2000_10_20'.
Put ads into FreshPorts
Not sure we need this any more
tidy that heads up up.
thanks for the disk
Ask for a disk
fix small fonts
backups are handled by another user now
try $HOME instead of /usr/local/etc/freshports
Add the HEADS UP to the website and newsfeed
deactivate this page as it might be causing swap shortages
how about we fix the right code here.
FreshPorts not freshports
better the grammar
instead of port/category, try category/port
fix path to lastupdate.
provide details on each port to be refreshed
fix typo
update path
change path to fonts
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
This commit was manufactured by cvs2svn to create branch 'FreshPorts1'.
add fonts
change path to fonts
change file extension
change include paths
first commit
fix typo in last commit
fix path
broken graphics
Put the database connect into freshports_database.pm and use freshports_database.pm.sample as the example.
correct path to log file
add the chgrp
use the logs directory
add details for logs directory
update
get the path right
get the directory correct
updates
tidy up
move crontab to scripts more aliases
fix up crontabs
first commit
put copyright into smaller font
Talk about new webserver
welcome to the new box
Send out individualized messages for the ports changes.
more stuff to set up
first commit
added the stuff
pick a better password
First instructions for setting up incoming mail for FreshPorts
remove _private
add note about new box and old website
remove file, commit new one.
turn off the survey
*** empty log message ***
remove link to survey but don't use cach files.
don't mention the phorum
Slight adjustments to improve looks
first commit
revive dead files
revive dead file
revive dead files.
updates
move these out of the www tree
database permissions
Add some cache busting code to the fetch.
Show Powered by graphics only on the about page
put the headers back in
Make sure we go to the Right Place if we log out
make sure the right screens see the right data.
fix the display of information
fix a problem with links not being disabled when they should be
show the right stuff when you need to
fix syntax error
Don't create a pkg directory in fetch-cvs-file.sh. Let's do it where werun the make -V. then we'll remove it. this catches the pre-everything bug.
Don't create a pkg directory here. Let's do it where we run the make -V. then we'll remove it. this catches the pre-everything bug.
Don't chown any more
change path. This should really become a local configuration item
fix dir path
change paths
change path
Update locations
change locations
use htmlspecialchars on certain fields.
first commit
fresh updates from the website
first commit
first commits
update the scripts with the latest from the website
rename this file
rename this file
This commit was manufactured by cvs2svn to create tag 'r2001-09-27'.
oops. forgot these!
Standard project directories initialized by cvs2svn.
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
This commit was manufactured by cvs2svn to create tag 'beta'.
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
This commit was manufactured by cvs2svn to create tag 'beta'.
first commit
Standard project directories initialized by cvs2svn.
This commit was manufactured by cvs2svn to create tag 'r2001-09-27'.
Ready to deploy. I think.
Change the URL to the ftp site and remove .tar
another item to do: make a link to list broken and forbidden ports.
add GetPort
change a restrict to a cascade.
Moving these files to a src directory within the port.
First commit
first commit
first commit
first commmit
First commit
give the form a name so we can set focus to it.
slightly change welcome message
use freshports_PortDetails
- When logging in, make sure we come back to where we were by using rawurldecode. - Set the focus to the first edit field when asking the user for data entry.
put a <br> \n at the end of a debugging line
List 100 ports at a time, instead of only 50. Create new function freshports_PortDetails to print details of a port.
First commit
first commit
First commit
Add Harold's and John's name to the tasks they are doing.
Add some headers
This commit was manufactured by cvs2svn to create tag 'Release-2001_03_23'.
deactivate this page for now.
deactivate this page for now
show them where to get info about the ports tree
remove the voting options..
add a bit more to the orphaned elements task. This is really something which we could do in log_accum.pl on freefall... if they'll let us do it.
Call htmlspecialchars in a few special places.
Add some background colour and a link to the TO DO page...
a new gif
we don't want robots here.
Adding redirect script to allow rewriting of port requests like /www/apache13. Still pretty rough right now.
A place to record who created what.
add more comments and debugging. comment out all debugging.
Don't let an object be a parent of itself.
Make sure default value for status is specified.
I think we should be using this instead of the other.pd* files
fix up some typos add/remove some drops to avoid error messages.
Remove uneeded sequences. Remove asc from index creation. Remove foreign key names from foreign key creation.
first commit - use this code to create a FreshPorts2 database.
Adding summary of freshports survey results
Add the orphans created by ports commits not having ports in front of the path.
Latest files for uploading output of pkg_info. Added support for pre-deleting ports if "-c" option is given. Improved debug (-d) support.
Latest commit of the port. Bump version and checksum.
adding cvs.html: fp2 CVS instructions
latest checksum for the port
0.2a version of port to upload output of pkg_info to freshports and register the listed ports
Files to process an uploaded file that contains the output of a pkg_info command.
makefile to craate ports' .tar files and whatever else we may want
IsLoginValid added.
This commit was manufactured by cvs2svn to create tag 'dummy'.
Import of Freshports port
add WatchListAdd, a function for adding an element to a user's main watch list.
Show the date the port was deleted. Limit the number of ports shown to something reasonable.
Added message to say stats are just since FreshPorts started and that they are updated daily.
Another todo item: automagically remove people if their email starts to bounce.
add a htmlspecialchars for those pesky things committers include in log messages.
Add the "verify the website against the mailing list" script which I've been thinking about for months.
Send the userid and password, not just the password.
remove extra fetch which was stopping passwords from being mailed out. reported by Gerald Pfeifer <pfeifer@dbai.tuwien.ac.at>
This commit was manufactured by cvs2svn to create tag 'r2001-09-27'.
This commit was manufactured by cvs2svn to create tag 'ads_2000_10_20'.
This commit was manufactured by cvs2svn to create tag 'Release-2001_03_23'.
Change ports.committer to change_log.committer where it is actually used. Remove it where it it not actually used. Reported by Michael Haro <mharo@FreeBSD.org>
Initial commit of things to do.
Upgrade to fwatch 1.1 courtesy of Volker
Adding triggers to set an element as deleted if a new commit_log_element arrives with change_type = 'R'.
Remember to add parents as we trace through the tree to add a new element.
Change mysql.org to mysql.com
Add an announcement type feature.
add functions for system_version_element
just a commit
The final bit of code to reflect the latest database changes. element_revsion is just two fields. system_version_element is just three fields.
add 2001 to copyright
add some breaks; to switch statements.
make sure that those special HTML characters in the log messages are properly escaped.
Just the latest.
test
test
test
tset
test
test
test
test
test
test
test
test
test
test
test
test
removing file used for testing
more testing
more testing
Please delete this file
Add a timeline.
This commit was manufactured by cvs2svn to create tag 'www1-0'.
Importing development website
Standard project directories initialized by cvs2svn.
ConvertUsers now translates watch notice codes to watch notice ids.
more changes.
It works.
First commit
Works correctly now.
Now adds watch lists.
Script to copy Users from FreshPorts to FreshPorts2.
*** empty log message ***
Initial import.
*** empty log message ***
*** empty log message ***
*** empty log message ***
This commit was manufactured by cvs2svn to create tag 'head'.
This commit was manufactured by cvs2svn to create tag 'head'.
This commit was manufactured by cvs2svn to create tag 'head'.
This commit was manufactured by cvs2svn to create tag 'head'.
Create the FreshPorts2 project
Standard project directories initialized by cvs2svn.
adding sample messages
new version.
revision 2
*** empty log message ***
This commit was manufactured by cvs2svn to create tag 'release1_1'.
Removed <body > which was in _private/header.inc Commit ports-not-in-latest-index.php3 for first time. Modified Files: about.php3 authors.php3 bouncing.php3 categories.php3 category.php3 change_log.php3 change_log_details.php3 change_log_port.php3 changes.php3 convert_change_log.php3 customize.php3 files.php3 forgotten-password.php3 index.php3 inthenews.php3 legal.php3 login.php3 new-user.php3 port-description.php3 port-watch.php3 ports-deleted.php3 ports-new.php3 ports.php3 privacy.php3 search.php3 stats.php3 thanks.php3 watch-categories.php3 watch.php3 welcome.php3 whatnext.php3 Added Files: ports-not-in-latest-index.php3
This commit was manufactured by cvs2svn to create tag 'release1_1'.
2nd edition of DTD and XML example.
First commit of docs directory
Standard project directories initialized by cvs2svn.
This commit was manufactured by cvs2svn to create tag 'release1_1'.
*** empty log message ***
Fonts are now in another location
Upgrade to latest phorum
add link to stats page
added an include for an announcement.
First commit
First commit
This commit was manufactured by cvs2svn to create tag 'release1_1'.
add a USE statement.
Fix a spelling mistake.
This commit was manufactured by cvs2svn to create tag 'release1_1'.
use a LIB command.
Get this committed.
Added logs of time stamp printing so I could see where things took up time.
CreateDailySummary mods to increase db performance
use the correct file names when describing pkg-descr
Change number of commits shown to 100.
Add help with dbi->quote. Fix news query to take less CPU. Restrict robots.
Various changes to allow admin to work.
For deleting change_logs
*** empty log message ***
Cater for no incoming parameters
*** empty log message ***
Remove long description search Modified Files: search.php3
Diff applied against port-description.php3 to allow commits to be deleted. Added Files: deleting_commits.txt
Remove the BSDCon banner ad Modified Files: header.inc
Add code to strip timezone from timestamp. Might be related to new mysql. Modified Files: updates.pl
Hmmm, it assumed that a port commit started with cvs commit: ports/ now, it doesn't. the ports/ bit can be anywhere on the subject: line. Modified Files: log-catcher.awk
oops! forgot to add the ports changes for pkg-descr etc. Committing in updates Modified Files: updates.pl
changed pkg/DESCR to pkg-descr and other changes associated with new ports layout. Modified Files: ports.pm
extra checks to ensure directories exist. Modified Files: fetch-cvs-file.sh
first commit Added Files: fetch-cvs-file.sh
remove unused code. change freshports to FreshPorts. Modified Files: news.php3
change it so it uses fetch?rev=head Modified Files: fetch-cvs-file.sh
Disallow: /phorum/ Modified Files: robots.txt
ask for help in getting graphics clickable. Modified Files: stats.php3
moving to stats.php3 Removed Files: stats.php
add stats Modified Files: side-bars.php3
add stats. Modified Files: stats.php3
Always convert the id to lower case before creating the cookie. That's because mysql is case insensitive. Committing in _private Modified Files: commonlogin.php3
Add a bit of debugging Modified Files: index.php3
add a few more debugging lines Modified Files: getvalues.php3
Don't send stuff out if dont have an email or have been bouncing. Modified Files: forgotten-password.php3
redirect them to / if they are going back to index.php3 Modified Files: bouncing.php3
Clear out $UserID so the correct menu items are shown in the side-bar. Modified Files: forgotten-password.php3
Allow the users to recieve their password via email. Modified Files: login.php3 Added Files: forgotten-password.php3
let the owner know if a category is created. Modified Files: updates.pl
Add a new feature to allow showing of port creation date. Committing in _private Modified Files: port-basics.inc getvalues.php3
Pull back the correct information. When combined with a script to update the ports.last_change_id field correctly, this page now shows the correct details. Sorry about that folks. Modified Files: watch.php3
new gif Added Files: logs.gif
new gifs Added Files: broken.gif forbidden.gif
Modified Files: category.php3
if an error occurs fetching a category, show the error Modified Files: freshports.php3
do some parameter checking and give the user a nice screen when they get no data. Modified Files: category.php3 port-description.php3 port-watch.php3
Added broken and forbidden to the code. Modified Files: port-basics.inc
Added broken and forbidden to the code. Modified Files: index.php3 category.php3 ports-new.php3 port-description.php3 search.php3 ports-deleted.php3 watch.php3
just adding in. Added Files: graph.php image.php index.html phpgraph.php
New files. Added Files: graphics.php stats.php
change the logs.gif file to something with better definition Modified Files: files.php3 port-description.php3
some final touchups. Modified Files: port-description.php3 files.php3
put the cat/port values into the title Modified Files: files.php3
Allow the users to see what files are changed within a port. Modified Files: files.php3 port-description.php3
initial import
create a hardcode variable to the cvs repository Modified Files: port-basics.inc freshports.php3
use the freesoftware.com server to serve up the ads. Modified Files: header.inc
add in bsdcon banners to the whole site. Committing in _private Modified Files: header.inc
white space changes only. Modified Files: legal.php3
fix some caching bugs related to host name mistakes I made. Committing in _private Modified Files: commonlogin.php3
just restrict access to here
make the new changes Modified Files: changes.php3
add in the legal notice.
Add this legal name. Added Files: legal.php3 Modified Files: footer.inc
Add thislegal name. Added Files: legal.php3
change file to use side-bars Modified Files: welcome.php3
normal updates Modified Files: changes.php3
Cater for ports which are deleted, then reimported. We have them in the tree, but they are deleted. Just set them "status = 'A'" and get on with it. Modified Files: updates.pl
Don't let people do ugly things to the data input. use addslashes to stop such things. Modified Files: new-user.php3
Don't let people do ugly things to the data input. use addslashes to stop such things. Modified Files: login.php3 search.php3
recent changes.
Add jay to the thanks.
add this file Added Files: .htaccess
Add this file. Added Files: .htaccess
Tell the user that their email is bouncing. Modified Files: side-bars.php3 getvalues.php3
Tell the user that their email is bouncing. Modified Files: customize.php3 Added Files: bouncing.php3
add GetPortCategory add category to PortCreate add GetPortID Modified Files: updates.pl
fix up broken news. Modified Files: news.php3
change the code to use change_log, change_port. Modified Files: email.pl
Add privacy statement to website. Added Files: privacy.php3
change to use /usr/local/etc/freshports/ports.pm Modified Files: email.pl
show the latest 100 commits Modified Files: index.php3
don't do a getvalues.php3 during the submit. it overwrites values. Modified Files: new-user.php3
adding this file because if it's not there, and with these permission settings, news.php3 will fail to create it. Added Files: news.txt
remove "store more than one commit" as that's already in there now. Modified Files: whatnext.php3
initial add Added Files: thanks.php3
initial add Added Files: whatnext.php3
inital add Added Files: index.php3 list.php3 phpPollAdmin.php3 phpPollBar.gif phpPollCollector.php3 phpPollConfig.php3 phpPollUI.php3 results.php3 view.php3 vote.php3
post FreshPost 1.1 install Committing in _private Modified Files: commonlogin.php3
post FreshPost 1.1 install Committing in . Modified Files: convert_change_log.php3 index.php3 permissions.txt upgrade.1.txt watch.php3
first commit Added Files: passwd passwd.group
new permissions
new stuff
damn, forgot the db login Modified Files: updates.pl
another path which needs changing. Modified Files: updates.pl
change db and password to values which obviously need changing. Modified Files: updates.pl
add fake paths so we don't updates stuff we shouldn't. Committing in . Modified Files: log-catcher.awk
final changes before freshports 1.1 Committing in . Modified Files: log-catcher.awk log-catcher.pl Modified Files: updates.pl
final changes before freshports 1.1 Committing in . Modified Files: log-catcher.awk log-catcher.pl
add a stop-gap so we don't change the wrong database. Modified Files: commonlogin.php3
how to update.
final changes after doing a dry run. Modified Files: commonlogin.php3 getvalues.php3 new-user.inc
final changes after doing a dry run. Modified Files: changes.txt convert_change_log.php3 customize.php3 permissions.txt port-description.php3
fixed some of the origin= links. Committing in _private Modified Files: side-bars.php3
tables which need creating for version 1 Added Files: changes.txt
rename change_log_details.change_port_id to change_log_port_id Modified Files: updates.pl
These allow you to check the logs. Added Files: change_log.php3 change_log_details.php3 change_log_port.php3
rename change_log_details.change_port_id to change_log_port_id Modified Files: convert_change_log.php3
move the call to MarkPortAsRefreshNeeded to where it is always called for every entry being modified. Failure to do this means pkg/DESCR are not fetched and therefore the data is out of date. Modified Files: updates.pl
add these files to the collection Added Files: list-all-ports.pl one-off-walk-ports-and-update.pl
add a zero to the mask (to make it octal? or hex?) Modified Files: portschange.pm
now tests for a failed make call. Modified Files: ports.pm
now disconnects commented out some of the STDIN lines. Modified Files: walk-ports-and-update.pl
now adds up the total number of ports. also tided up some of that HTML. Modified Files: categories.php3
added a warning about stop signs and testing Modified Files: index.php3
The big change to full automation of commits.
creates a daily summary for all change_logs in system.
initial commits.
now removes the temp file it fetches. Modified Files: fetch-cvs-file.sh
change side bar table widths to 152. This should really go into a variable somewhere. change sorting to be by commit date, change_log_id, port name, category, version. add change_log_id to output so we can clump commits together under one commit time and commit message. This saves lots of real estate. Modified Files: index.php3
change table width to 152. This really should go into a variable somewhere. Committing in _private Modified Files: side-bars.php3
the new version for index. Modified Files: index.php3
Set $UserID to '' in getvalues adding origin to post in login.inc change username to userid in sidebars. Modified Files: getvalues.php3 login.inc.php3 side-bars.php3
fixed some spacing. and a redirect. Modified Files: login.php3
now includes code so you can refresh a single port. Modified Files: fetch-refresh-ports.pl
Now creates directories if a port is new. This allows the fetch to succeed. Modified Files: fetch-cvs-file.sh
Still looks good. have to consolidate index2..4, newrefreshtime, keichii, headerwithtwolines Committing in _private Modified Files: commonlogin.php3 getvalues.php3 new-user.inc port-basics.inc side-bars.php3
Still looks good. have to consolidate index2..4, newrefreshtime, keichii, headerwithtwolines Committing in . Modified Files: customize.php3 index.php3 port-description.php3 ports-deleted.php3 stats.php3 watch.php3
Looks good so far. Just a quick commit to save everything. At this point, I have the fetching of Makefile, pkg/DESCR, and pkg/COMMENTS going. But I have to know when to fetch such things. Committing in . Modified Files: fetch-cvs-file.sh fetch-refresh-ports.pl ports.pm test.pl
fetch-cvs-file.pl is actually fetch-cvs-file.sh Committing in . Modified Files: announce.pl email.pl ports.pm refresh-ports.pl test.pl Removed Files: fetch-cvs-file.pl
These files are used to refresh a port on-the-fly. fetch-cvs-file.sh will fetch the latest version of any cvs file. fetch-refresh-ports.pl uses the above to refresh all ports which need refreshing. Added Files: fetch-refresh-ports.pl fetch-cvs-file.sh
Standard project directories initialized by cvs2svn.
Added Files: fetch-cvs-file.pl
Sends announcements to people. Added Files: announce.pl
*** empty log message ***
Now uses change_log* tables fully. Should remove old fields from database and see if the .php3 files and scripts still work. Committing in _private Modified Files: port-basics.inc
Now uses change_log* tables fully. Should remove old fields from database and see if the .php3 files and scripts still work. Committing in . Modified Files: index.php3 port-description.php3 watch.php3
latest and greatest Modified Files: log-catcher.pl log-munger.awk
This looks like a good candidate for promotion. It includes the customization, uses the change_log, change_log_port, and change_log_details tables. Needs some minor changes yet. Show all changes on port-description page. Rename port.last_change_log_detail_id to last_change_log_id. What about deleted ports being added back in? Check watch.php for correct use of log tables. Committing in _private Modified Files: commonlogin.php3 getvalues.php3 port-basics.inc
This looks like a good candidate for promotion. It includes the customization, uses the change_log, change_log_port, and change_log_details tables. Needs some minor changes yet. Show all changes on port-description page. Rename port.last_change_log_detail_id to last_change_log_id. What about deleted ports being added back in? Check watch.php for correct use of log tables. Committing in . Modified Files: category.php3 convert_change_log.php3 index.php3 login.php3 port-description.php3 ports-deleted.php3 ports-new.php3 watch.php3
lists of permissions needed by mysql users. Added Files: permissions.txt
adding in the customization stuff Committing in phorum/include Modified Files: header.php
adding in the customization stuff Modified Files: commonlogin.php3 footer.inc freshports.php3 getvalues.php3 new-user.inc port-basics.inc side-bars.php3
adding in the customization stuff Modified Files: category.php3 customize.php3 index.php3 login.php3 port-description.php3 ports-deleted.php3 ports-new.php3 search.php3
just a file for converting change_log_detail to use change_log_port. Added Files: convert_change_log.php3
Initial import. Added Files: stats.php3
removed www from url Modified Files: footer.inc
fixed up setting of refresh_needed and started using index instead of a regex for FilesWhichPromptRefresh. Modified Files: updates.pl
now updates change_log_details properly. obtains needs_refresh and status when checking for existing ports. assigns value to needs_refresh only if necessary. sets needs_refresh to "N" if port is deleted. Modified Files: updates.pl
use index function instead of a regex when searching for existing pacakges. Modified Files: ports.pm
initial add Added Files: advdel.php datedel.php db.php easyadmin.php edit.php files.php global.php html.php main.php manage.php managemenu.php master.php new.php pass.php props.php quickapp.php quickdel.php quickedit.php setup.php
initial add Added Files: 3.php
initial commit Added Files: footer.php header.php index.php login.php stats.php upgrade.php upgrade.txt
Added scrolling through ports. Modified Files: index.php3
adding it. Added Files: pbfbsd2.gif
initial adding to the system Added Files: apache_pb.gif freshports.jpg mysql.gif new.gif php3.gif
added relative pathnames. incorporate changes from production. Modified Files: changes.php3 index.php3 category.php3
now uses the change_log file Modified Files: port-description.php3
change to use relative path names Modified Files: watch.php3 categories.php3 search.php3
the link to the page you are on is now disabled when you are on that page. Modified Files: side-bars.php3
change the URL to be site independent. Modified Files: header.inc
dunno Modified Files: port-basics.inc
added freshports_SideBarHTML* functions for side bar functionality Modified Files: freshports.php3
include caching here Modified Files: commonlogin.php3
change to relative path names Modified Files: header.php footer.php
fixe the | which was a wrong color Modified Files: read.php
Use relative path names. cache file name are now set in common_login Modified Files: about.php3 authors.php3 customize.php3 inthenews.php3 login.php3 port-watch.php3 ports-deleted.php3 ports-new.php3 watch-categories.php3 welcome.php3
remove hardcoded path names Modified Files: news.php3
added side bars etc. Modified Files: new-user.php3
add the favicon Added Files: favicon.ico
change to use mysql_connect for connecting to remove sleeping mysql processes Modified Files: mysql.php
This commit was manufactured by cvs2svn to create tag 'release-1-0'.
change the number of days something is marked as new to 10. Modified Files: port-basics.inc
add UNIX_TIMESTAMP(ports.date_created) as date_created to SQL so we can show whether or not something is new. Modified Files: watch.php3 ports.php3 port-description.php3
add vote now Modified Files: side-bars.php3
add copyright notice Modified Files: footer.inc
remove search on description until we get it right. Modified Files: search.php3
normal changes Modified Files: changes.php3
remove an echo HTML from freshports_echo_HTML Modified Files: freshports.php3
make sure it uses _private/port-basics.inc Modified Files: category.php3
remember to echo the html out Modified Files: categories.php3
added new.gif Modified Files: port-basics.inc
now records the changes in distinct tables as they arrive Modified Files: updates.pl
latest changes Modified Files: changes.php3
replaced delete ports link with the correct URL Modified Files: side-bars.php3
that blank line was causing problems. Modified Files: port-watch.php3
normal updates
redirection when login/logout is needed/done. Modified Files: side-bars.php3 Modified Files: watch.php3 watch-categories.php3 logout.php3 login.php3 customize.php3
redirection when login/logout is needed/done. Modified Files: side-bars.php3
added sidebars redirects to / if going to index.php3 Modified Files: login.php3
now handles an undefined $homepage much better. Modified Files: refresh-ports.pl ports.pm
added SIZE="+1" to titles of each table Modified Files: side-bars.php3
removed the styles Modified Files: header.php
modified URL to point to port description. Modified Files: news.php3
updated the outgoing message Modified Files: ports.pm
sends out email to people on a frequency basis. Added Files: email.pl
Added SendWatchNotice Modified Files: ports.pm
you can now sort by category or last update. useful if you get told something has been modified, but you don't know what. Modified Files: watch.php3
fix situation wherein not watching any ports caused an error.
Fixed error in in_array function Modified Files: freshports.php3
fix off-by-one bug when reading in watched categories for a given user. Modified Files: watch-categories.php3
changed meta tags adding new files to repository. Modified Files: about.php3 authors.php3 categories.php3 category-watch.php3 category.php3 changes.php3 customize.php3 inthenews.php3 login.php3 new-user.php3 port-description.php3 port-watch.php3 ports-new.php3 ports.php3 watch-categories.php3 watch.php3 welcome.php3 Added Files: news.php3 ports-deleted.php3 search.php3 ----------------------------------------------------------------------
change font sizes add deleted-ports page to side bars
for deleted ports, display "was maintainted by" and hide the download link.
removed unneeded code
tell robots to stay away from port-description.php3
ignored deleted ports
now marks ports as deleted if the Makefile is removed.
code to refresh ports which need refreshing.
no longer sets status to 'N' when a port is updated ignored ports are now tested for individually as using a REGEX was causing too many problems. improved formatting of code.
more testing
added search screen.
added deleted notice for deleted ports short description, and maintainer are now optionally displayed.
added ports.status to cater for deleted ports.
regular changes
Added bit about IRC.
When a new port is added, the status is now set to 'A' - active.
now works fine.
now uses ports.pm
split the file name into three parts, so we can recognize special files such as pkg/DESCR, etc.
All the scripts for log catching, log munging, and dataabse update.
now uses the new ports.pm module.
finally created a perl module for the most common routines.
Standard project directories initialized by cvs2svn.
now updates home page correctly
changed <big><big> to size="+2"
added standard font for in the news
made it standard.
add sidebars.
put side bar at the same level as other windows.
no longer needed.
removed as renamed to authors.php3
nada
mere formatting.
changed the graphics around.
Port description now includes Also listed in, required to build, and required to run.
nothing. really.
changes for login/logout taking you back to the original screen.
login/logout now take you to the screen from which they were invoked.
Just the latest changes.
a list of articles talking about freshports
Added an <h2>
replaced by about.php3
Add phorum to cvs.
Put the image above the table.
Put the image above the table. put sidebar in.
put a table in there.
made sure the user name appeared and not the user id.
New header file.
fixed spacing after last item in each table. It needed a <br>
Added graphics.
added headers and footers. much better. and graphics
Removed references to "Test site" and "not in production".
Added a message to show watch list is empty. now shows the home page for the port.
all is well
looks good. now lets add side bars
now changed to link to watch-categories.php3 upon submit.
Use this screen to view what categories you have ports watched.
committing the ports2.php3 and ports.php3 and swapping them around
getting pretty close. just need to settle the start and end parameters
just before trying to use a new method for retrieving large amounts of data
proper sorting added.
just more testing.
hide committer and update_description if null
fixed homepage bug, now ignore more directories, and allows you to start at a particular spot in the tree.
New format
new include file which details port attributes.
fix sorting.
fixed sorting, added bold to column titles, added notes to page about sorting.
describes the port
new look watch pages. now uses _private/port-basics.inc
now links to category.php3 page.
now links to port-description.php2 page.
shows the ports you are watching and their status. Needs to include categories too.
This version uses the new ports table, caters for ports without version numbers, and does rather nicely, thank you.
Added bit about lzh.
for a new port, set short_description to '-- waiting for description --'. also, set date_created to a datetime value instead of a date.
needs_update field is now being set correctly. yahoo!
OK. it ran through the entire ports tree that time. Looking good!
getting pretty close now. looking good.
most of the code has been written. Just have to start calling PortUpdate now.
Just adding more and more code to this.
After finding that I'd overwritten the log catcher with the log munger, I quickly learned out to extract a particular revision from cvs. Added headers to the top of each file. That should solve the above problem.
Commit of files right after moving scripts to /www/freshports.org/scripts/
*** empty log message ***
*** empty log message ***
This commit was manufactured by cvs2svn to create tag 'devel'.
Standard project directories initialized by cvs2svn.
*** empty log message ***
Committing in . Added Files: side-bars.php3
Committing in . Added Files: connect.pl log-catcher.awk log-catcher.pl log-munger.awk updates.pl
welcome.php3 added
Here we go. another commit. let's see how it goes.
This commit was manufactured by cvs2svn to create tag 'beta'.
This is the first commit of FreshPorts. Long may she live.
Standard project directories initialized by cvs2svn.