Display master/slave information
<? => <?php
Display security_notice_id white space changes to align columns
Cater for security_notice_id
Start using ignore
remove debugging echo.
handle the new ports.deprecated field
status -> security_notice_status_id
status -> security_notice_status_id expand information returned by Fetch
status -> security_notice_status_id
Add FetchByStatus, GetStatus, and FetchNth.
only include those security notices which are Active.
Only include those security notices which are Active.
Add GetAllActive
Remove references to external variables by providing hooks to set these values.
When determining whether or not a port is on a watch list, consider only those watch lists which are in service.
Better handle the case of no watch lists
Add from and to moves.
Handle ports_moved table
Forced commit to correct previous commit message: If no watch lists are in service return the first one ordered by name.
If no watch lists are in service return the first one which is in service.
add a missing fetch row.
Adjust the way we determine GetDefaultWatchListID. Change a 0 to $i.
Only call syslog if we don't have a WLID.
Add a syslog to track down a problem.
Remove some redudant debugging code.
If user details cannot be found, remove their cookie and log details.
Ensure you call AddSlashes. I noticed this problem because of this error: 2003-11-26 05:43:12 [82327] ERROR: parser: parse error at or near "cgi" at character 41 And was able to reproduce it by using this URL: %20+%20base%20+%20'cgi-bin/ads/'%20+%20%20%20adcode%20+%20'.cgi'%20+%20Tv%20+%20%20%20
Code for displaying the last N commits. Moved here from www/index.php
Functions for saving data on page rendering times
Whitespace adjustment Explicity set debugging off
whitespace only
Add missing EncodingLosses()
Add missing ?>
rename PackagesExists to PackageExists
Add PackagesExists()
Add EncodingLosses()
Stop using "if (In_Array(" because it appears to not work
whitespace changes Add EncodingLosses()
add IsPrimary()
add EncodingLosses()
rename FetchByPartialName to FetchByElementID for use by missing-ort.php
add FetchByElementID
add IsPort and IsCategory
comment out debugging code
Obtain the commits for an element.
Given a pathname, get the element details
Add element_pathname
Whitespace only
A class for handling the records used on index.php
No functionality changes. Just whitespace and better use of existing variables.
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).
use the correct database field name: firstlogin not firslogin
Remove debug code Refer to the correct database handle when fetching a commit
Fix php notice message
Add EmptyTheListCategory which allows us to empty a watch list of all elements in a given category.
Add WatchlistCount which gives us the number of watch lists upon which this port appears.
Attempt a sort
Update the copyright notice to 2003
final amendments
add FetchNth, FetchAllActive, FetchUpdateID, and GetPopulateValues functions
remove inaccurate comment
Add Announcements table
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
log all changes to the description
update header use only in_service watch lists
update header
remove FetchByName
header update
Let's fetch the data instead of just executing the query
First commit
Add SecurityNoticeAudit class
better handling if we don't find the port
fix incorrect references to code definition
comment out a debugging statement
use query, not sql remove syslog calls - logging now done by stored procedure
start using the new stored procedure for security notices.
This commit was manufactured by cvs2svn to create tag 'RELEASE-beta- 2003_03_07'.
enhanced debugging
turn off debugging
actually loop and use more than just one task start using constants
fix debugging statement. return id, not name when fetching by name. add UpdateDescription to allow users to set description on new virtual categories
Allow paging through category contents
PostgreSQL 7.3 changes
turn off debugging
add EmptyAllLists
Handle the multiple watch lists correctly when fetching a single port
Fix GROUP by because of 7.3 changes
define SUPER_USER and USER types
Start using the port_categories table
For mainttaining commit_log_ports_ignore
Add new functions to support NeedsRefreshClear
Include needs_refresh for each commit
white space
turn off debugging use the categories table
Fix group by problem under 7.3
remove trailing control-m's
Turn debugging off
Try doing the join a bit faster.
whitespace
Don't set message id on retrieve return message id
remove Rename, added in error. add IsTaskAllowed
Allow us to add users to tasks
New class
whitespace
Add FetchByMessageId
Start pulling stuff in from the new security_notice table.
Add new function GetTasks
Use AddSlashes correctly
fix copyright
Add DeleteAllLists
Correctly count the number of watch lists for a given user.
PR 235 - WatchList needs to use UserID when deleting items.
Add GetDefaultWatchListID
Add FetchByName
Add SetLastWatchListChosen
Set debug off
limit watch lists to users.max_number_watch_lists
use ' instead of "
adjust error handling
Use require_once
Show all watch lists regardless of whether or not the element is on the list. Improve debugging.
Add DeleteElementFromWatchLists
Fix a mistaken query
Use onwatchlist not watch
use new watch list structure
Start using the new User class
Add FetchByCookie
Add watch_list_count, which is optional
Optionally show whether or not a given element is on the list
First commit
Add the user class. still pretty basic.
Tidy of SQL strings. Make FetchByID work.
rename $commit to $WatchList. add in_service
add in_service
Add the class for the WatchList and WatchLists
Repair comments
repair debug message
Cater for watch lists
Create a new commit class and move that functionality there from commits
add FetchNth and _PopulateValues The query needs to be modified to cater for time zones and adjustments thereto.
First commit
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
If we are using watch lists, we need another optional group by item
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 data appropriately
Include version+revision in fetched details
Cater for watch lists correctly on lists of ports.
Pull committer from the result set
add message_id and encoding_losses, which might be used in some circumstances
add encoding_losses
add FetchByName
Grab port_id and adjust the time using SystemTimeAdjust()
New class
Start taking notice of WatchListID
OOPs, 24 hours clock, not 12.
Tweak the sort.
remove debugging info
add function IsOnWatcList
remember to timezone adjust the commit date
pull back all ports, not just those with commits ignore deleted ports
rename date_created -> date_added
Add update_description to class
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.
Add a new class.
Oops, forgot to commit this. Add FetchByID and FetchByCategory.
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.
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
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.