'fix ports being deleted on branches'
'adding debugging, invoke dispose()'
verifyport.pm: fix ports being deleted on branches re: https://github.com/FreshPorts/freshports/issues/528 If the port is deleted, but set active, set it deleted. After saving the port, make sure we adjust the {status} flag: If the status changes, set it back to what it was see https://news.freshports.org/2024/11/27/when-a-port-on-a-branch-is-deleted-freshports-tried-and-fails-to-refresh-it/
xml_munge_git.pm: Remove unused Element_Add() function
Add some more debugging statements
Correct impelemented
to implemented
Rename upate_generate_plist()
to update_generate_plist()
element.pm - remove code which grabbed the parent id It seems to be unnecessary Some column alignment. Remove unused $tmp variable
process_vuxml.pl: When the parsing has finished, say so. re: https://github.com/libexpat/libexpat/issues/928 Also, dispose() of the doc when completed.
Column alignment
'Slave ports need to have port vulnerabilities adjusted after a commit to the master port'
Mention we are adjusting the port vulnerabilities re: https://github.com/FreshPorts/freshports/issues/607
After processing the commit, be sure to adjust the vulnerability count on any slave ports. https://github.com/FreshPorts/freshports/issues/607 This is already done for each port in the commit, but slave ports were previously missed.
Move some use statements to the top of the file
column alignments
'fix code to deal with new categories'
'missing-port-categories.sh - make it OFFLINE aware, change get-list-of-current-categories.sh so it no longer observes OFFLINE.'
Let's change how we approach new commits Most of this refers to _CompileListOfPorts() At the start of commit processing, make sure we have the ports tree checked out to the commit in question. That allows us to get a list of categories which are current as of that commit. For example, /ports/head/ftp/vsftpd/Makefile When we are processing the file names, we check to see if ftp is a category. We look at the list we got from the repo. If we find it here, we know it is a category. If it's not, we know it's not a port and we can ignore it. Then we check the database; if it's not found, we know it's a new category and we must add it to the database.
With recent changes to config.pm.sample: * Stop using $FreshPorts::Config::OFFLINE * start using $FreshPorts::Config::Offline instead
Comment out some debugging statements, which take up a log of space in busy commits
Remove $FreshPorts::Config::OFFLINE - which had an incorrect path Add $FreshPorts::Config::Offline - which has the correct path
For new categories - they go to /ports/head/ That used to be /ports, before we added support for branches
Do not run if OFFLINE
saving incompletely tested stuff, as a checkpoint for new categories
saving incompletely tested stuff, as a checkpoint for new categories
exits, not exists
'fix version in setup.py, it was using commas'
fix release, changing , to .
'fix version in setup.py'
fix release
'remove code for fetching categories'
Update version reference to 1.0.10
Remove code for processing a new category
'new OFFLINE code, fix new categories stuff, UPDATING will now work with or without a space '
'fixes for new categories when they arrive'
Fix category creation: Fix the order of parameters on JailCategoryDescrptionScript No need to fetch the category Makefile - it's already there thanks to git re: https://news.freshports.org/2024/11/07/fixing-the-category-creation-code/
Remove leading blank line
refer to $0, not the incorrect test-master-port.sh left over from copy/paste
refer to $0, not the incorrect test-master-port.sh left over from copy/paste
remove duplicate but different instance of FUNCTION public.ports_categories_set() RETURNS trigger
Adjust column aligment for better reading
Adjust column aligment for better reading
grant truncate ON packages_raw TO packaging; allow www to read abi
Adjust column aligment for better reading
kxml_munge_git.pm: specify the correct branch for Sanity Test Failures
We were specifying whahtever branch we found in the xml file. Instead, now
we show the converted branch name ('main' from FreeBSD, is 'head' in
FreshPorts-land.
also, only show the branch on the URL within the message if it is not head.
Start using: $FreshPorts::Config::OFFLINE This replaces: $FreshPorts::Config::ScriptDir/OFFLINE
Create and start using: $FreshPorts::Config::OFFLINE This replaces: $FreshPorts::Config::ScriptDir/OFFLINE
'properly report merges and provide link; supply branch to sanity test errors'
'RIP bacula9, long live bacula15 - this time for the shell script'
Change bacula9 to bacula15
'RIP bacula9, long live bacula15'
bacula9-client has been removed from the tree use bacula15-client instead
On sanity test messages, supply the branch re:https://github.com/FreshPorts/freshports/issues/564
Update message used when empty commits are noticed.
'Add host URL to newusers.pl'
Include host url
'dump-package_imports.sh: allow for sorting by date and name (default)'
dump-package_imports.sh: allow for sorting by date and name (default) re: https://github.com/FreshPorts/freshports/issues/593#issuecomment-2308384101
'remove extraneous _enable'
remove accidental copy of trunk to tags
''
hourly/990.refresh_package_imports_page: remove extraneous _enable
'990.refresh_package_imports_page: Sort data by both name and date, providing two static files'
Sort data by both name and date, providing two static files.
'dump-package_imports.sh: add'
dump-package_imports.sh: order by repo_date - the processed date is relevant - But repo_date will be the same on all FreshPorts nodes
dump-package_imports.sh: for nulls, sort by name, package_set
dump-package_imports.sh: add - re https://github.com/FreshPorts/freshports/issues/593
add notes about the environment variables
'invoke test-master-port.sh with /bin/sh - add new script: 990.refresh_package_imports_page re: https://github.com/FreshPorts/freshports/issues/593'
Add an hourly refresh of /--/package-imports.php re: https://github.com/FreshPorts/freshports/issues/593
'Adjust for new package importing strategy'
Adjust for new package importing strategy Add: * FreshPorts::Config::LogDir * FreshPorts::Config::LogJobsWaiting Remove: * $FreshPorts::Config::NewRepoImported
'Adjust for new package importing strategy'
Adjust for new package importing strategy see: https://github.com/FreshPorts/packages-import/releases/tag/2.7.0 job-waiting.pl * remove references to FreshPorts::Config::NewRepoImported * start logging to FreshPorts::Config::LogJobsWaiting * no need to launch after report-notification-packages.pl after UpdatePackagesFromRawPackages.py * that is done by import-via-copy-packagesite-all-raw-fields.py * wow, in hindsight, I should have created a wrapper script which invokes import-via-copy-packagesite-all-raw-fields.py, and UpdatePackagesFromRawPackages.py, and then report-notification-packages.pl * Perhaps later. report-notification-packages.pl * If there is nothing to report upon, don't error out * no need to remove NewRepoImported any more
'unlink the NewRepoImported signal, and Beacuse -> Because '
ri.txt: fix broken packages triggers After INSERT, invoke package_notifications_insert, not after UPDATE After DELETE, invoked package_notifications_delete, not after UPDATE Seems like repeated copy/paste/fail to correctly amend.
job-waiting.pl - fix typo: Beacuse to Because
report-notification-packages.pl: avoid looping in job-waiting.pl Remove the flag which causes us to be launched.
database.pm: Add sslcertmode=disable Fix this issue: could not open certificate file “/root/.postgresql/postgresql.crt”: Permission denied I’m positive the problem is the connection is asking for a client certificate. I checked my pg_hba.conf configuration and found no lines mentioning cert. See also https://github.com/FreshPorts/packages-import/commit/10285544ad72311a82ed36cf9153a41db4722439
port.pm: fix some problem with _GetFileContents() Some time ago, I hit a problem. I worked on it and did not document the issue. So here I am, checking in code which seems to work. The problem with input files is they don't always encode well. I had comments like this in the code: + print "This is bullshit\n"; +# open my $in, '<:encoding(ISO-8859-1)', $file; # works +# open my $in, '<:encoding(ascii)', $file; # fails ascii "\xC3" does not map to Unicode + open my $in, '<:encoding(iso-8859-1)', $file; +# open my $in, '<:encoding(UTF-8)', $file; # fails UTF-8 "\xC3" does not map to Unicode The current code seems to work, but without knowing the original problem, I can't verify it fixes the issue. Commit away.
mv updates-2024-06-21.txt updates-2024-06-22.README.txt
Save things for freshports multiple cookies
Move users.cookie to a new table: user_cookie This allows multiple logins for different sessions, say from your desktop and from your laptop. re: https://github.com/FreshPorts/freshports/issues/574
Allow reading to select from watch_list_element re: https://github.com/FreshPorts/freshports/issues/550
for package_notifications table, use package_notifications_abi_set_port_idx CONSTRAINT
'Standardize all report email subjects'
Standardize all report emails. Subject will be: FreshPorts Notification: <topic> Hopefully this will help people to filter easily.
'loop detections added to job-waiting.pl; missing-port-categories.sh will log better; add in report-notification-packages.pl'
Add insert into reports for new package notiication report change public.report_log_package_notifications to id, not serial postgres, not postgress.
Refer to add, not insert And to package changes, not new packages.
Pulled in all the changes from the DB via PGAdmin 8.4
Add report_log_package_notifications
Attempt to standardize on one name for emails: FreshPorts notification Start keeping stats Explain what update, delete, insert will mean.
Attempt to standardize on one name for emails: FreshPorts notification
Attempt to standardize on one name for emails: FreshPorts notification
Add loop avoidance After invoking UpdatePackagesFromRawPackages.py, always run report-notification-packages.pl
This now properly handles package_set
Add the report for package notifications. re: https://github.com/FreshPorts/freshports/issues/542 It sends, duplicates, but it sends.
Perhaps a loop
Put /bin/sh in front - this affects mostly dev hosts where permissions are not set by an installing package.
Put /bin/sh in front of .sh
GRANT INSERT ON packages_last_checked TO abi_maintenance
Add more for this.
When reporting the number of found rows, make it easier for filtering
Change the rm to rm -f when removing the flag This script is invoked by a periodic script. The FLAG won't be present then.
Updates for the right names
first draft of triggers for package_notifications table
A FreshSource RO user
remove script for taking website offline - it is outdated
use nginx and fp_listen - modernize
'use su -l not su -fm which fails with postgresql16-client'
Move from su -fm to su -l -fm fails with postgresql16-client
Remove some MANIFESTS, rename one
'remove hourly/260.fp_refresh_various_cache_items'
remove hourly/260.fp_refresh_various_cache_items No longer used
'refresh-abi logging improvements'
Created in error. All wrong.
'refresh-abi logging improvements'
refresh-abi.sh: alter logging details Add process id
'Don't refresh deleted ports; remove cache_needs_refresh'
'remove some constants, improve abi refresh'
Handle deleted ports better
The code was setting $por->{deleted} but using $port->IsDeleted() which
looks at {status}, not {deleted}
I think {deleted} was used for internal usage only, but fails to do the right
thing with actually deleted ports.
re: https://github.com/FreshPorts/freshports/issues/528
No need to touch FreshPorts::Config::RefreshCachFileFlag now re: https://github.com/FreshPorts/freshports/issues/58
This is not used any more. re: https://github.com/FreshPorts/freshports/issues/58
Let's not output anything by default. Let there be less.
Let's always log the abi stuff. That way, we can see that it ran.
Renove RefreshCachFileFlag - no longer used re: https://github.com/FreshPorts/freshports/issues/58 While here, remove some items from show-config.pl which are no longer present. * DynamicDir * FlagDir * RefreshCachFileFlag * WWWENPortsCategoriesFlag
Renove RefreshCachFileFlag - no longer used re: https://github.com/FreshPorts/freshports/issues/58
'Do not mail from periodic script; the invoked perl script does that.'
daily/260.fp_newusers: Do not mail The invoked perl script will do that.
improve logging for gitCheckoutResults
column aligment - REPEAT
column aligment
Add more comments
add comment details
remove blank line
'config.sh - add ABILOG; refresh-abi.sh - better logging'
Improve logging and report to abi.log
add ABILOG
'330.refresh-abi - no not mail results'
Let's not email - let refresh-abi.sh log instead.
add update to abi_maintenance
'add abi maintenance code'
Remove this tag - going to replace it
'add abi maintenance code'
Update PostgreSQL items * For use by new abi scripts: - Use export on PGSSLMODE - Add PGSSLROOTCERT - add DBUSER_ABI
'add abi maintenance code'
'Add daily/330.refresh-abi'
Daily, refresh the ABI
add commit, and logging
Start connecting to the database. Still have to process errors.
add trailing ; to sql
save SQL updates for abi maint
Adjust to use STDIN add-new-abi.sh and delete-depcreated-abi.sh now take their input from STDIN (via cat) instead of seprately invoking current_list_of_valid_abi.sh This save an extra fetch.
Maintain the list of ABI ABI get added, deleted. This set of scripts will maintain that list in our abi table.
'260.fp_newusers - fix redirection This has been wrong since 20218.04.20'
Adjust git pull delays It used to get bigger each time. Now it's the same each time
260.fp_newusers - fix redirection This hs been wrong since 20218.04.20 re: https://svn.int.unixathome.org/viewvc.cgi/freshports-1/periodics/trunk/daily/260.fp_newusers?r1=5054&r2=5055& I've been missing out on new user reports for nearly 6 years.
For PackagesLastCheckedSetRepoDate(), indicate an update is required only if a_RepoDate is not null. If it is null, there is no such repo and it cannot be imported. See: https://news.freshports.org/2023/12/31/no-repos-need-importing-how-did-this-happen-this-should-never-happen/
'Overwrite the freshports tag backup file ; do not append to it'
Overwrite, do not append, to the backup file
'fix variables'
Fix variables
'use FP_USER_FRESHPORTS not FP_FRESHPORTS_USER'
Move from FP_FRESHPORTS_USER to FP_USER_FRESHPORTS
'Start using variables for many things'
Start using variables for everything Rename hourly/506.fp_categories_rebuild_search_html.inn to hourly/506.fp_categories_rebuild_search_html When that file was brought over from dvl/p5-freshports-scripts, it had that name. We will do a lot of processing in the FreeBSD port.
Add, moving here from the dvl/p5-freshports-scripts port
remove some blank lines
'-m'
Don't need +MANIFEST-p5-freshports-modules We have +MANIFEST-p5-FreshPorts-Modules
Igmore git-last-processed-tags.sh
Add missing logfatal()
'Add 980.dump_freshports_tags'
Save the output to a file
Adjust so we don't save the output. Let the script do that.
Script to launch saving of tags in ingress' repos
Better comments
Use grep -c ls *.xml will result in ./system_status.sh: /bin/ls: Argument list too long ... when there are large numbers of commits.
Use ne not != for comparison
Remove files/usr/src This directory was used to decieve nvidia drivers into thinking we had /usr/src installed. re: https://github.com/FreshPorts/freshports/issues/152
Update to reflect we are using actual jails now, not just chroot.
'Use full path to git'
Use the full path for git Things changed on some servers with FreeBSD 14.0
Use the full path to git
Add the non-git specific names
remove this tag, recreated/overwitten in error
'removing our flag when we start processing. tell port->save() we are working on HEAD'
'removing our flag when we start processing. tell port->save() we are working on HEAD'
'add comments mentioning that Eat() works only on HEAD'
mention that process_default_versions.pl operates only upon head
mention that Eat() works on head, and is not checking branches for special processing
On port->save(), specify HEAD, because that is only what this should be invoked for
Remove our signal
refer to $0, not process_moved.sh
When done populating the packages table, clear out the pacakges_raw table. I suspect we had lingering data in there. This was messing up the results. We'd have a version, and no record of ever importing that tree.
'update config.pm.sample - adding stuff removed in error, and sort'
add $FreshPorts::Config::CheckPortsCategoriesFlag back in, and sort the flags
'update config.pm.sample'
Add utf8, DefaultVersionsFlag, and remove CheckPortsCategoriesFlag & WWWENPortsCategoriesFlag
Add more comments
Rename cut-freshsource-git
to cut-freshsource
Rename cut-fp-listen-git.sh
to cut-fp-listen.sh
Rename ports removing the -git suffix And add +MANIFEST-py39-freshports-git-proc-commit
'cater for https://github.com/FreshPorts/freshports/issues/509'
job-waiting.pl * remove FreshPorts::Config::WWWENPortsCategoriesFlag => 'process_www_en_ports_categories.sh * add FreshPorts::Config::DefaultVersionsFlag => 'process_default_versions.pl remove: * process_CVSROOT_approvers.sh * process_www_en_ports_categories.sh add process_default_versions.pl
remove trailing space
'process Mk/bsd.default-versions.mk results'
constants.pm * remove Notify_cvsroot_approvers * add DEFAULT_VERSION * add FreshPorts::Constants::PortsAffectedByDefaultVersions special_processing_files.pm * remove processing for CVSROOT_Approvers * remove processing for FreshPorts::Constants::Categories port_refresh.pm - adding for refreshing a port * used for https://github.com/FreshPorts/freshports/issues/509
Allow reading to select from categories
'Cater for broken 2023Q4 branch'
Cater for a bug in 2023Q4 https://lists.freebsd.org/archives/freebsd-ports/2023-October/004812.html www/tomcat-devel was MFH and requires Java 21+, but 21 is not available in Q4. Cater for that.
'add categories_rebuild_search_html.sh'
Add a blank row in the drop down list, for a default search value Fixes https://github.com/FreshPorts/freshports/issues/491
'add categories_rebuild_search_html.sh'
Refresh the list of categories.
'Include changes adding port_id to RemovePortFromCache() calls'
I should have done this for scripts, not modules.
'Include changes adding port_id to RemovePortFromCache() calls'
Adjust parameters to RemovePortFromCache() which now takes a port_id see: https://github.com/FreshPorts/freshports/issues/468
'include an updated fp-listen.ini'
Update sample with FILE_CACHE_PATH
'do better cache invalidation for MOVED, UPDATING, etc'
'improve cache invalidation for MOVED, UPDATING, etc'
Caching changes 12345678901234567890123456789012345678901234567890123456789012345678901234567890 Items like MOVED & UPDATING where never cleared from cache. caching.pm was designed when the web server and the ingress server where always assumed to be on the same host. That is no longer the cache. The code has been rewritten to use the same cache clearing mechanism as in other parts of the system. A new table has been created: cache_clearing_files It functions much like the existing cache_clearing_ports table The changes here are coordinated with changes to the modules port and to the fp-listen (part of the webserver) code. re: https://github.com/FreshPorts/freshports/issues/468
Cater somewhat for invalid depends For some reason, 5699269 gave this results for RUN_DEPENDS: [18:42 empty dan /usr/ports/www/tomcat-devel] % make -V RUN_DEPENDS jsvc:devel/apache-commons-daemon /bin/java: see https://lists.freebsd.org/archives/freebsd-ports/2023-October/004775.html Which then gave invalid RUN_DEPENDS and an empty string. The code now copes.
'Add cache clearing for files, such as MOVED, UPDATING. See https://github.com/FreshPorts/freshports/issues/468'
Add deletion of files, such as MOVED, from the cache. Fixes https://github.com/FreshPorts/freshports/issues/468
spell with
Use this shebang: #!/usr/local/bin/perl -w For port.pm, use better stuff for UTF-8 re: https://github.com/FreshPorts/freshports/issues/455
Use this shebang: #!/usr/local/bin/perl -w
Add new function: DoneProcessingCommit() It is not invoked anywhere - I suspect that would be somewhere inside the commit inserting/adding code.
'Allow cache clearing for sanity test failures'
Clear cache for sanity-tests re: https://github.com/FreshPorts/freshports/issues/451 This does mean that the sanity test list is cleared each time a commit occurs. That is overkill. However, going the other way creates more work and more code. Simple cache clearing is better cache clearing.
When checking for latest commit before a quarterly branch, ignore null port versions. They can happen: https://cgit.freebsd.org/ports/commit/?id=fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4
'join the query tables when looking for slave ports'
Actually join the tables in this quewry
'for UPDATING, use case insensitive for AFFECTS; trim rowcount on missing-port-categories.sh'
'do not pass empty strings to _GetRealPath()'
Don't pass empty strings to _GetRealPath()
Use case insensitive matches for Affects and Author This allows for: 20230213: Affects: users of sysutils/nut* AUTHOR: cy@FreeBSD.org Whereas most people do upper case: 20230213: AFFECTS: users of security/logcheck AUTHOR: yasu@FreeBSD.org
remove spaces from ROWCOUNT
Remove unneeded declarations and notices.
Use ports_active instead of ports By default, it is head only.
'-m'
'Convert XML main to head; remove FetchAllFiles(), svnUpFile(); delete xml_munge_svn.pm'
Make sure we use head not branches/main Add FreshPorts::Constants::MAIN as a constant and when checking to see what branch we are on, convert main to head, because the XML gives us main, but we are using head in the database. fixes #435
As of 2022-12-10, ports_active is head only Remove the reference to /ports/head/%
Remove some old subversion specific code. FetchAllFiles() svnUpFile() xml_munge_svn.pm Thank you.
Retire vuxml_ident.pl : used for subversion commits.
'Loop over the queue until it is empty'
When we're finished checking the queue, check again. This avoids the race condition where more stuff is added to the queue and we miss it because we are processing the queue already.
Remove latest_link, no longer used.
Rename GetCategoryPortFromLatestLink to FUNCTION GetCategoryPortFromPackageName because latestlink is no longer used by Ports.
Use freshports, not FreshPorts, in URLs. see: https://github.com/FreshPorts/freshports/issues/412
'no need to create the incoming directory'
Correctly report the missing directory
'use the spooling directory'
Start using the spooling directory. This has been in use on dev since at least Sep 17 2022. Time to spread it around.
When creating a port on a branch, use the ports table, not the ports_active view to get the element_id. It won't be there because ports_active is now head only. re: https://github.com/FreshPorts/freshports/issues/413 https://github.com/FreshPorts/freshports/issues/407
'Only update if test_depends has changed. re https://github.com/FreshPorts/freshports/issues/411'
Only update if test_depends differs
Correct the name of this file.
Add test_depends to views.
'add TEST_DEPENDS'
'add TEST_DEPENDS'
Add TEST_DEPENDS re: https://github.com/FreshPorts/freshports/issues/411
Extract TEST_DEPENDS re https://github.com/FreshPorts/freshports/issues/411
Add new column: ports.test_depends re: https://github.com/FreshPorts/freshports/issues/411
'update refresh-all-active-ports.pl removing head-specific stuff because ports_active now does that for us'
'refresh-ports.sh & process_updating.sh now log to DIRLOG, process_updating.pl looks for AFFECTS and avoids duplicates in cache_clearing_ports, add show-config.sh'
make both ports_all and ports_active head-specific. We shall see if this works out OK re: https://github.com/FreshPorts/freshports/issues/407 https://github.com/FreshPorts/freshports/issues/406
Split role creation out from permissions.sql into roles-users-groups.sql This allows permissions to be re-run at any time, for example, after a view changes.
Add binmode STDOUT, ":encoding(UTF-8)" to cater for wide characters re: https://news.freshports.org/2020/05/30/tracking-down-wide-character-in-print-at-usr-local-lib-perl5-site_perl-freshports-vuxml_parsing-pm-line-232/ Remove EP.pathname like '/ports/head/%' clause from SELECT because ports_active is now only head. re: https://github.com/FreshPorts/freshports/issues/406
Be clearer about how this directory is used.
'populate the ports.makefile field re: https://github.com/FreshPorts/freshports/issues/406'
Populate ports.makefile field re: https://github.com/FreshPorts/freshports/issues/406
'fix processing of vuxml re: https://github.com/FreshPorts/freshports/issues/360'
Fix vuxml processing. The files have moved from security/vuxml/vuln-YYYY.xml to security/vuxml/vuln/YYYY.xml Fix the regex for checking for such commits. Add more logging. More detail in https://github.com/FreshPorts/freshports/issues/360
Remove references to running this from a cronjob. It is launched from job-waiting.pl
Remove code added for debugging
Mention this won't work on ingress nodes.
Add
Fix UPDATING With 20220623 and 20220620, 20220620 appears in column one. That caused failures because of a faulty regex. https://regex101.com to the rescue for this one It was broken anyway, because the directory was wrong. For cache clearing, we need to use the cache_clearing_ports table The caching module is good only on webservers, not on ingress nodes, which is where this script runs.
Log the output of process_updating.pl to process_updating.log
Althought this script is no longer relevant/used, let's use the supplied configuration value for LOGDIR
When clearing cache for a port, consider all categories re https://github.com/FreshPorts/freshports/issues/373 A port has a primary category. e.g. x11/bemenu However, this port is also listed in the wayland category, which is a virtual category. This is known as a secondary category. Secondary categories are always vritual. You can't browse to wayland/bemenu - but you can see bemenu listed at https://www.freshports.org/wayland/ Therefore, we must flush that page from cache when that port is updated. The solution: insert both of these pairs into the cache_clearing_ports table: * x11,bemenu * wayland,bemenu The fp-listen daemon, which runs on the webserver nodes, will always clear the category page in addition to the port page. It will also clear the now non-existent wayland/bemenu page - no harm done there. Should the display of a port on a virtual page be implemented one day, this solution will properly clear that cache too.
'remove dir-create.sh; correct ports_tree_file_count.pl'
Correct the ports tree file count Reported by Laurent Chardon
This script is deprecated.
Use mktemp
Let's move towards Nagios alerts instead of email.
'restrict refresh-all-active-ports.pl to head only'
Remove tag created in error
'e-and-options_name.pl for jexec. add set-pkgmessage.pl never saved before'
Restrict this port to head
'update refresh-all-active-ports.pl for modern times. update set-pkgmessage-and-options_name.pl for jexec. add set-pkgmessage.pl never saved before'
'add code for make -V WWW'
'add code for make -V WWW'
Add WWW
Update to accommodate new WWW entry in Makefiles see https://cgit.freebsd.org/ports/commit/?id=ddd0e820c8eb73acef94c72434c382982d0fa329 Add SET CLIENT_ENCODING TO 'ISO-8859-1 to accommodate DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe4 0x20 0x3c at ../port.pm line 406. This still won't work for ports which use the pkg-descr for another port e.g. https://cgit.freebsd.org/ports/tree/multimedia/linux-c7-libtheora/Makefile?id=63f36d326290febc7af8820d7bde9c78cda71c80#n17 I have emailed se@FreeBSD.org about this edge case.
Save changes from a year ago when this script was converted to use jexec
Save changes from a year ago when this script was converted to use jexec
Adjust SQL to work only on head. Adjust Port->new() call to specific 'git' repo
Comment out this NOTICE. It winds up in the .errors file for the commit.
Fix a trigger optimization which avoided updating the table if the values did not change. re: https://news.freshports.org/2022/08/19/missing-ports_categories-entries/
'remove maildrop/mailfilter - no longer used now we're on git'
'try catching sql print errors'
Start using Try::Tiny I was seeing errors on printing the SQL. Let's see if that traps that. Testing was not able to reproduce it.
Better logging message
Add more logging
Exclude deleted ports on package name search Use ports_active not ports Example: otrs has www and devel (deleted). If entered into the search box on the front page, you'd be taken to the search page where only the non-deleted port would be found. Better to take then directly to the active port, as intended.
Drop the procmail, actually maildrop filter Since FreeBSD moved to git, this is no longer required.
Updates
Add a better log message
don't tell me about required modifying the the parent % from a file to directory
'Avoid periods at the end of URLs and email addresses'
'Correct the link to commits fixes https://github.com/FreshPorts/freshports/issues/335 reported by Matthew Seaman via private email '
Avoid periods at the end of URLs and email addresses
Correct the link to commits fixes https://github.com/FreshPorts/freshports/issues/335 reported by Matthew Seaman via private email
remove subversion code
Remove daemontools specific tools
Remove subversion specific scripts
'one more time on the correct port, with updated code: require ssl'
'require ssl, really, this time, for real'
require ssl
'require ssl'
'require ssl'
require ssl
column alignment
'add newlines to refresh-ports.pl'
go for 2500 row sets
add newlines to print statements
Be sure to prepare the repo with the latest data before processing
Remove NOT EXISTS (SELECT port_id
FROM cache_clearing_ports
WHERE port_id = PD.port_id_dependent_upon)
from the trigger. It's seems extraneous
'use correct path for pkg-message'
'add launch-refreshes.sh & long options for refresh-ports.pl'
Correct the path to pkgmessagepath - this is not absolute, but relative
A script for launching multiple instances of refresh-ports.pl which each run in parallel
Add in long options: dryrun y/n debug y/n limit How many rows to process offset Where to start int the result set Stop using syslog, because output is now logged to a file
log to a file
We shall keep distfiles around - no sense removing them if we are running multiple tests
better comment
'add script name to syslog call in refresh-ports.pl'
add script name to syslog call
Create the ports_to_refresh table. re: https://github.com/FreshPorts/freshports/issues/328
Make sure the branch is in public.freshports_commit_record - fixes https://github.com/FreshPorts/freshports/issues/327
add branch text to public.freshports_commit_record
'add in $FreshPorts::Config::PortsToRefresh'
2.1.15? Should be 2.0.15
'add $FreshPorts::Config::PortsToRefresh, refresh-ports.sh, refresh-ports.pl'
'add in $FreshPorts::Config::PortsToRefresh'
we shall assume git processing when refreshing
add $FreshPorts::Config::PortsToRefresh signal
Add the ability to process the ports_to_refresh table.
Create PORTSTOREFRESHFLAG flag While here, derive BASEDIR_PACKAGER from BASEDIR
fix comment typo
'move from ports-jail to jail'
'move from ports-jail to jail'
Remove tag created in error
'move from ports-jail to jail'
remove tag created in error
'move from ports-jail to jail'
Remove variables no longer present.
fix typo in /usr/ports comment
use /usr/ports; /var/db/repos is now gone
Stop using ports-jails, start using a proper jail Use /usr/ports within that jail
Move from chroot to jexec. The ports-tree at ~freshports/ports-jail is no longer used. Instead, we use one in a true proper jail.
this is deprecated
For fortnightly, do 18 days, because it's not a perfect fortnight
We are now using a FreeBSD jail for port data extraction
Move to a /usr/ports location for the jail
Move the jail to /usr/ports, not /var/db/repos/ports
Move from chroot to jexec With make-pkg-message-in.sh, move back to apply-slist : it's great
Better pkg-message handling, but not great.
Replace JailApplySList with JailPkgMessage, for better pkg-message handling
Better pkg-message handling, but still not great.
'but that extra space!'
Remove extraneous space
'fix a typo for recent dir'
Fix a copy/paste error when displaying the name of the retry directory
'Fix the way we detect a commit against security/vuxml'
Fix the way we detect a commit against security/vuxml Look for any file like vuln-YYYY
'check ports_categories when not processing commits'
'check ports_categories when not processing commits'
Update to check ports_categories when not processing commits.
Add this to /usr/local/etc/freshports/config.sh:
CHECKPORTSCATEGORIESFILE="${BASEDIR}/signals/check_port_categories"
Update to check ports_categories when not processing commits. Add this this to /usr/local/etc/freshports/config.pm: $FreshPorts::Config::CheckPortsCategoriesFlag = $FreshPorts::Config::BaseDir . '/signals/check_port_categories';
'use the right script name'
Fix the script name and the user set_hourly_flags.sh.sh should have been set_hourly_flags.sh This script should be run by freshports
'Do not use a period in a shell variable name'
Don't use . in a shell variable name or periodic will be upset: /etc/periodic.conf.local: fp.set_hour_flags_enable=YES: not found
'adding in 215.fp_check_git_for_commits'
Add the script for invoking the set flags script
Add in some ignores with propset
Script for testing categories obtained from the repo
Comment out the debugging code
First attempt at keeping track of what reports have not been run
column alignments
column alignments
silence some entries.
'fix queue-status.pl, now checks for .errors files'
'Avoid variables without values in verifyport.pm Add a proper Undelete() for ports in port.pm Fix paths for branch commits in xml_munge_git.pm '
Properly reresurrect a port so that our local copy stays up to date. re: https://news.freshports.org/2021/07/04/when-a-deleted-port-is-resurrected/
Report upon .errors files Don't report upon ingress-svn any more
Fix path manipulation with on a branch
reduce the number of error messages we get in the the logs by ensuring a default value exists
'We don't use Jail/scripts/make-categories.sh in the port-jail'
make-apply-slist.sh is not required in the port jail. This functionality is carried out by get-list-of-current-categories.sh
Include make-categories.sh chown root:wheel too
Better shorter way to get the list of categories
Add make-apply-slist.sh
Add MANIFEST-py38-freshports-git-proc-commit
'Use Email::Stuffer'
Fix email sending. https://cgit.freebsd.org/ports/commit/?id=3505159e72da2d8313ce2a8ddc527de700b5bc37 contains some unicode characters, Let's use Simple::Email for that.
column alignment without tabs
'handle the cache_clearing_commits table'
Use ~/tmp/packaging/
Add code for clearing cached commits
Add code to clear commit cache.
start using ~/tmp/packaging
return multiple records when searching for elements
'add error handling for categories.pm'
use spaces, not tabs to column align assignments
Detect and raise a fatal error if the script fails Print the categories
No real changes. Amend some debugging output to help in the future. sort the use statements
'add get-list-of-current-categories.sh back in'
Remove get-list-of-current-categories.pl, not used. Add get-list-of-current-categories.sh back in, removed via 5713 I really should have waited. Kept this only on dev for a few days. Then test, staging, and prod would not have been affected.
'-m'
Remove this, now handled by get-list-of-current-categories.pl
Commit a work in progress, only to be deleted on my next commit
the new HTML from Jethro
Remove 'svn commit checking status' since we don't do subversion commits any more
adjust the comment headers
Document that FreshPorts::Config::FreshPortsURL must have a trailing /
'use FreshPorts:: again'
Use FreshPorts again...
'use FreshPorts::'
Use FreshPorts::
Seems we don't need this after all
'fix Makefile.PL'
Add missing '
'Create FreshPortsVerify'
Remove erronously placed tag
'Create FreshPortsVerify'
Try FreshPortVerify
Move
'Create 2irTry FreshPorts::Verify'
Move from FreshPorts::Scripts -> FreshPorts::Modules
Rename
'Create 1irAdd Makefile.pl'
Add
Add
'Create first tag'
'bringing in better category detection'
'bringing in better category detection'
Stop using IgnoredItems and use a list of Categories pulled from the repo
Add categories.pm used thusly:
use FreshPorts::categories
use List::MoreUtils 'any';
FreshPorts::categories::FetchAll();
# look for special files outside a port, such as LEGAL, GIDs, UIDs, .hooks
if ( ! any {/$category_name/} @FreshPorts::Categories::categories ) {
...
}
Be cautious when printing svn_revision - I think this arose when writing Verify/set-pkgmessage-and-options_name.pl
With IgnoredItems being removed, this script is no longer required.
Get the list of categories from the repo
FreshPorts::Config::scriptpath and FreshPorts::Config::ScriptDir have the same value. use only the latter.
FreshPorts::Config::scriptpath and FreshPorts::Config::ScriptDir have the same value. use only the latter.
Fix the debug output so it makes sense when reading it.
Also, update options_name
'add get-list-of-current-categories.sh; fix vuln_latest.pl for new HTML usage'
Bring in the changes from https://github.com/FreshPorts/freshports/pull/261
Commit my changes to vuln_latest.pl before incorporating changes from https://github.com/FreshPorts/freshports/pull/261
'Previous release was mucked up. updated config.sh.sample'
'if no pkg-message in the repo, try apply-slist - corrected'
adjust from svn to git
space changes only
Add the make-apply-slist.sh code
add make-apply-slist.sh
'if no pkg-message in the repo, try apply-slist'
'Previous release was the wrong tarball name - updated config.sh.sample'
'Updated config.sh.sample'
A new iteration of the find
Not every directory in the root directory of the repo is a category. This script pulls back a list of those categories. This need arose with this commit: https://cgit.freebsd.org/ports/commit/?id=bbc2474ef7a65eb8561c8ecf7af80c2bfed1f248 Which created the .git directory.
re https://github.com/FreshPorts/freshports/issues/245 Not all ports with a pkg-message have a pkg-message file. Some have files/pkg-message.in, for example. This script uses apply-slist to build that file.
'use main, not master, for head'
'count *.xml not *.txt'
stop counting .txt & start counting .xml
Now that the FreeBSD git repo is out, it seems they changed the name of the head branch from master to main. The main change there is: -my %BranchConversions = ( 'master' => 'head' ); +my %BranchConversions = ( 'main' => 'head' ); Adjust some constants to allow commits to process. $FreshPorts::Config::RepoDir . '/PORTS-head'; was renamed to $FreshPorts::Config::RepoDir . '/' . $FreshPorts::Config::Repo_PORTS; This meant that $FreshPorts::Config::Repo_PORTS had to be moved higher up withint config.pm Adjust the constants for the repo directories. We have abandoned github and moved to git.freebsd.org. e.g. freebsd-doc becomes doc
'add DBUSER_REPORTING to config.sh.sample'
add DBUSER_REPORTING
Some debugging
'add options_name'
'Add OPTIONS_NAME to scripts. fix ports_tree_file_count.pl to work with new configuration items'
'freebsd-cvs.sh: say if config.sh is not found queue-status.pl: stop using the database, sort the queue keys so Nagios output is consistent, look only for files > 5 minutes old. config.sh.sample: mention PORTSDIRBASE is best without a trailing slash Add the monitoring directory, but I am not sure it is used yet. process_vuxml.pl: improve spacing'
FreshPorts::Constants::Repo_Ports is gone. Use FreshPorts::Constants::Repo_Dir_Name_Ports instead
cate for OPTIONS_NAME
Start saving options_name
Add for better cache clearing: https://news.freshports.org/2021/01/31/changing-how-we-record-ports-which-need-cache-clearing/
Add pkg_plist()
add stuff for new search
comment out conflicts type so we do not lose a table
add options_name column to ports table
add author and committer name and email
Change the regex for pkgplist from 'lib/[[:alnum:]]*?\.so to 'lib/[^/]*?\.so' re https://github.com/FreshPorts/freshports/issues/216#issuecomment-794892427
'adding committer_name, committer_email, author_name, author_email'
Add new committer and author fields: * committer_name * committer_email * author_name * author_email
commiter -> committer
Add new commit_log columns * committer_name * committer_email * author_name * author_email
better suggestion from Magnus
This attempt at replacing ports.pkg_plist with generate_plist,installed_file is close, but not quite right.
This is the first attempt at converting expression which one ran on a single column into one which runs on rows. Previously, it ran on array_to_json(regexp_match(ports.pkg_plist, 'lib/[[:alpha:]]*?\.so')) But now those values are speard across several rows in the generate_plist table. This first attempt is wrong.
Add repo.db_root_prefix
Comment out some NOTICE and WARNINGS
'bring in the vuxml code from trunk; take author and committer in.'
Add p5-Email-Address-XS>0:mail/p5-Email-Address-XS as new dependecy because we need to split the user off the address. We now take in Author and Committer. Author is not yet written to the database.
Bring in the vuxml code from trunk
'bring in the vuxml code from trunk'
Pull in the vuxml code from the main branch, because we need the new vuxml code here too. While here, do some betting debugging.
Remove use of database Sort the keys before displaying them so every host has the same order of output.
Add
Add
'In /var/db/ingress/message-queues/incoming, we look for *.xml'
In /var/db/ingress/message-queues/incoming, we look for *.xml
'better queue monitoring'
Remove use of database use -mindepth 1 to avoid counting the directory itself
'add virtualhost-common-ssl.conf.sample'
'K IW svn-commit.tmp (Modified) Row 3 Col 1 Stop using FreshPorts::Utilities::CommitCountPeriod because we are counting only file more than 5 minutes old.'
queue-status.pl no longer uses FreshPorts::Utilities::CommitCountPeriod
Stop using FreshPorts::Utilities::CommitCountPeriod because we are counting only file more than 5 minutes old.
'conver all the queues'
adjust report_non_zero to cover all incoming and spooling directories. same for CountRecent
'add more queue monitoring'
trailing / issues, add in src-stable-12
Add ingress_svn/message-queues/incoming & ingress_svn/message-queues/spooling to the queue checking
Add more fake packages
Add MANIFESTs for fake packages so the real packages do not accidentally get installed. $ sudo pkg register -M +MANIFEST-FreshPorts-Scripts [dev-ingress01.int.unixathome.org] Installing FreshPorts-Scripts-9999.0.1... $ sudo pkg lock FreshPorts-Scripts FreshPorts-Scripts-9999.0.1: lock this package? [y/N]: y Locking FreshPorts-Scripts-9999.0.1
Check for and error out if config.sh is not found
PORTSDIRBASE is best without a trailing /
'correctly document what directories are used'
correctly document what directories are used
'fix system_status.sh'
Convert for use by git processing.
avoid duplicates in the cache_clearing_ports_test table
use CREATE OR REPLACE FUNCTION instead of CREATE FUNCTION
Add missing END IF
ZTHEN -> THEN Remove trailing ;
How did that space get in there?
'email files are *.txt not, not *.txt.raw'
Our files are now *.txt not *.txt.raw There was no need to rename them
Add in the changes from the subversion branch.
When inserting into the cache_clearing_ports table, which now has a unique index on port_id, detect a conflict on that index and do nothing if it occurs. While here, try to not NOTIFY if we don't have to.
Use -- instead of # for comments Remove AddNewABIToPackagesLastChecked() which does not compile against the packages_last_checked table which does not contain a column named branch_id
'Show reasons for update and number of updates'
Show reasons for update and number of updates
'allow IO::String on incoming new()'
'Adjust process_vuxml.pl to work on file open'
Add three new paramaters: * dryrun - do not update the database * showchecksums - show the checksums * printnodes - print the node we are processing Change from IO::File to IO::String for the $nodeString = $node->toString(); XML. This means the fh->open($nodeString) succeeds.
Change to allow IO::String on incoming new()
'For new security/vuxml/vuln.xml layout'
'For new security/vuxml/vuln.xml layout - perhaps 1.42 was a duplicate tag - oops'
'For new security/vuxml/vuln.xml layout'
Swap from vuxml_parsing_via_dom to vuxml_parsing
Adjust to XML processing, not XML creation. XML will be created by another user.
If fetching (svn up) fails, log a fatal error. The rest is just whitespace changes
Change to fixed length wait times. We are going to very high values for Fetch_Retry_Limit because svn is lagged on replication. It is easier to wait than to error out and fix by hand.
Remove empty error files Add more debugging output for Branch and revision
Move to using XML::DOM::XPath now that security/vuxml/vuln.xml is split into several files. Proof of concept courtesy of bapt@FreeBSD.org
When invoking parse, specify ProtocolEncoding => 'ISO-8859-1' That avoid errors like this: not well-formed (invalid token) at line 28, column 23, byte 1305 at /usr/local/lib/perl5/site_perl/mach/5.32/XML/Parser.pm line 187. on this: Reported by Andr?? Bargull on 2020-11-2</li> see vid="01ffd06a-36ed-11eb-b655-3065ec8fd3ec"
Saving before deleting. Work will be done by vuxml_parsing.pm
Let's save this before deleting it. Test worked, now moving code to process_vuxml.pl
Adding
'reverse accidental renaming'
Reverse renmaing of file in previous commit
'better layout for autoplist'
Try a different configuration for fp-listen, better for autoplist on FreeBSD
Add
Properly name this tag
'first git version of this code'
Convert from daemontools to daemon
'update to 2.0.1'
remove FreshPorts::Constants::SVN_Repo_Dir_Name_Ports which is not used
add a comment showing an example make-port.sh call
Fix up CanWeProcessThisBranch() was was passing an unnecesary parameter because it should have been invoking GetPathToRepoForBranchSVN() not GetPathToRepoForBranch()
'Add more logging which is helpful when dealing with directory permission issues'
'latest release'
Convert from `echo ${INCOMING}/*` to $(echo ${INCOMING}/*)
Put the ls output all into one command so the files are properly aligned
Correct a logging statement from load_xml_into_db_git.pl to load_xml_into_db.pl
Add more logging which is helpful when dealing with directory permission issues
add in stuff for the quarterly ports, and change tabs to spaces
Add
'first cut of git modules'
'first cut of the scripts for git'
'use better shell scripting'
Swap from `` to $()
branches.pm * add GetPathToRepoForBranchSVN * for a given branch name, return the full path. Including the CHROOT path. constants.pm * add FreshPorts::Constants::SVN_Repo_Dir_Name_Ports = ports-HEAD * is that used? port.pm * make this script work with both git and svn * the repos are in different locations * remove process_svn_mail.pm * Amend XML to include the source (subversion) so that XML processing knows which code to invoke * When invoking XML::Writer, don't specify OUTPUT, becuase that borks the code verifyport.pm * start passing around RepoType so everyone knows if this is git or svn xml_munge.pm * remove a bunch of commented out code now that most of this processing is in one of xml_munge_git.pm & xml_munge_svn.pm * we open the XML, check git or svn, and invoke the respective code to complete the processing xml_munge_git.pm xml_munge_svn.pm * adjust the code so that non-ports don't start compiling lists of ports to save * in xml_munge_git.pm, remove the code which checked the length of message_id to determin git or svn * that detemination is carried out by xml_munge.pm and it checks the XML to decide that
adjust spaces to tabs
load_xml_into_db.pl * modified to check the source repo for this XML * then invoke one of FreshPorts::xml_munge_git or FreshPorts::xml_munge_svn load_xml_into_db_git.pl load_xml_into_db_svn.pl Modified to invoke the approviaate XML munging class: * my $Munger = FreshPorts::XML_Munge_git->new($dbh); * my $Munger = FreshPorts::XML_Munge_svn->new($dbh);
Remove files no longer used.
I started to modify these scripts to work with git, then realized they are no longer used. email and commit processing is handled by services: [dan@devgit-ingress01:/usr/local/libexec/freshports-service] $ ls -l total 26 -r-xr-xr-x 1 root wheel 7267 Dec 6 22:17 freshports.sh -r-xr-xr-x 1 root wheel 1387 Dec 6 20:16 ingress.sh -r-xr-xr-x 1 root wheel 4109 Dec 6 22:13 ingress_svn.sh Look there for invoking the xml processing scripts
Convert from `stuff` to $(stuff)
We don't use this any more
slightly different comments
Convert from `stuff` to $(stuff)
Convert from `stuff` to $(stuff)
Convert from `stuff` to $(stuff)
what?
Add stuff for updating the database for use by git
Remvoe usage of public.
Fix this up for devgit - it wasn't all right
Attempt to being in updates for git which were not on this branch
Copying in things added to the sp branch which were never on the git branch
Add in * GetQuarterlyBranchName * NormalizeBranch * DenormalizeBranchName * AddNewABIToPackagesLastChecked Which where someone how only over here.
spaces onlyi
Add some comments & blank lines
'new naming convention'
Confirm to this naming convention .txt - email .xml - xml .log - loading of commit .errors - any errors caught
'cp, not mv, to avoid permissions message'
Change the mv .txt file to a cp/rm to avoid: mv: /var/db/freshports/message-queues/recent/2020.07.11.07.46.58.18048.txt: set owner/group (was: 10002/10001): Operation not permitted
'with message queue directory permissions now 0775, move .txt file to ~freshports/message-queues/recent after creating .xml file'
Better configurtion file comments
'change of file names (.txt, xml) and move .txt to ~ingress_svn/message-queues/recent after creating xml' '
Start using these file names: email: 2020.07.11.07.46.34.15635.txt xml: 2020.07.11.07.46.34.15635.xml errors: 2020.07.11.07.46.34.15635.errors Other scripts will need updating for .loading, which will become .log
'fix directory detection'
Fix the detection of required directories.
'looks reading for testing'
Good to go for testing. I got sidetracking creating fp-daemon on the git branch but then re-discovered my work here.
Check in what I have now. This work is abandoned in favor of ingress_svn.sh
Move fp-daemon up to the main directory and delete the rest. I couldn't see another way to just bring in one file
Copy fp-daemon over
Remove this whole directory created in error
Copy fp-daemon from trunk into the git branch
Create the git version of fp-daemon Starting with the the FreshPorts for git daemon and use that. The former takes XMl and laods it. The latter will take email and create XML for the former.
'work with both git and svn'
Start using the newly created load_xml_into_db.pl, not load_xml_into_db_git.pl, because it will work with both git and subversion. Also, rm -f
Revert last commit. It seems we need some of that code afterall.
Trim down the code by removing unnecessary items, such as the database connection.
Now that I've realized the website should process both svn and git commits, I wanted a way to inspect an XML file and determine which type of repo it came from. This is vital because we have two different sets of code to deal with each origin: [dan@devgit-ingress01:~/scripts] $ ls -l load_xml_into_db* -rwxr-xr-x 1 dan dan 1251 Dec 5 03:00 load_xml_into_db.pl -rwxr-xr-x 1 dan dan 1404 Jul 3 20:40 load_xml_into_db_git.pl -rwxr-xr-x 1 dan dan 1404 Jul 3 20:40 load_xml_into_db_svn.pl Invoke load_xml_into_db.pl and it determine the type of XML and then invoke one of load_xml_into_db_git.pl and load_xml_into_db_svn.pl In turn, each of those scripts will use one of these modules: [dan@devgit-ingress01:~/scripts] $ ls -l ~/modules/xml_munge* -rwxr-xr-x 1 dan dan 5392 Dec 5 02:51 /usr/home/dan/modules/xml_munge.pm -rwxr-xr-x 1 dan dan 36848 Dec 5 02:24 /usr/home/dan/modules/xml_munge_git.pm -rwxr-xr-x 1 dan dan 31944 Dec 5 02:37 /usr/home/dan/modules/xml_munge_svn.pm xml_munge.pm determines the type of repository this commit came from. This is important because there are slightly different data in the XML. For example, subversion does not have a commit_hash. load_xml_into_db.pl learns the type from this data in the XML file: <UPDATES Version="1.4.0.1" Source="git"> <UPDATES Source="subversion" Version="1.3.2.2"> The Version numbers refer to the code module and is used. Yet.
'fix code to use INGRESS_SVN_BASEDIR'
Fix INGRESS_SVN_BASEDIR variable
'fix code to use INGRESS_SVN'
change FP_DAEMON to INGRESS_SVN
Rename
'fix code to use ingress_svn'
fp-daemon -> ingress_svn because of rename
'rename to ingress_svn'
Complete the rename from fp-daemon-git to ingress_svn
rename from fp-daemon to ingress_svn
'first package'
Converted script from logger to echo
Correct FLAGDIR
Updates for daemon(8) control
fp-daemon for svn commits is going to be needed on the git branch for a while.
Correct the name of the configuration file from fp-ingress.sh to ingress.sh
Use the right value for branch name.
Properly bring a port back from the dead. After a port is deleted, it may be brought back. The code was looking for that, but not detecting it because of path issues. Let's strip the leading /ports/head or /ports/branches/2020Q4 and use what is left. While here, leave the loop once we have found something to resurrect.
Let's just do a fetch, not a pull
The signals directory lives under FRESHPORTS_BASEDIR not FRESHPORTS_MSGDIR
remove FreshPorts::Branches::GetPathToRepoForBranchCHROOT which seems outdated for git and does not work Add FreshPorts::Constants::GitRepos & FreshPorts::Constants::RepoLabelsToGitRepoNames
Convert the XML repo label to a database repo name
'become compatible with XML::Writer 0.900'
Patch to work with XML-Writer-0.900 Without this patch, the error is: Output must be a handle, a reference or 'self' at /usr/local/lib/perl5/site_perl/XML/Writer.pm line 480, <> line 114. This ties in with https://metacpan.org/changes/distribution/XML-Writer for 0.900: "Fail when a scalar other than 'self' is passed as OUTPUT."
The example email server should be a hostname, not an IP address.
Changes tabs to spaces
Fix the branch
add newline to end of file
third draft of elementGetCaseInsensitive()
second draft of elementGetCaseInsensitive()
first draft of elementGetCaseInsensitive()
Add packager and package roles
Add more notices
spacing
Sometimes you want 2020Q3 (usually for the repo), sometimes you want branches/2020Q3 (usually in git)
Add GetPort(integer), which pulls the element_pathname for this port
'fix 215.fp_check_git_for_commits'
Don't echo, that's left over. Run it.
If there is nothing to save in port_dependencies_delete_clear_cache(),
don't save it. It avoids this situation:
freshports.devgit=# delete from element where id = 1058393;
ERROR: null value in column "category" violates not-null constraint
DETAIL: Failing row contains (19934459, 59842, null, null, 2020-08-02 21:50:23.967785).
CONTEXT: SQL statement "INSERT INTO cache_clearing_ports (port_id, category, port)
VALUES (OLD.port_id, l_category, l_port)"
PL/pgSQL function port_dependencies_delete_clear_cache() line 19 at SQL statement
SQL statement "delete from element
where parent_id=old.id"
PL/pgSQL function on_delete_remove_children() line 4 at SQL statement
SQL statement "delete from element
where parent_id=old.id"
PL/pgSQL function on_delete_remove_children() line 4 at SQL statement
SQL statement "delete from element
where parent_id=old.id"
PL/pgSQL function on_delete_remove_children() line 4 at SQL statement
freshports.devgit=# rollback;
spell quarterly
Add in ports-quarterly
Add a test for showing repos: [dan@devgit-ingress01:~/modules] $ echo perl ./Testing/GetRepos.pl| sudo su -fm freshports ports has REPODIR='/var/db/freshports/ports-jail/var/db/repos/freebsd-ports' and REPODIR_CHROOT='/var/db/repos/freebsd-ports' ports-quarterly has REPODIR='/var/db/freshports/ports-jail/var/db/repos/freebsd-ports-quarterly' and REPODIR_CHROOT='/var/db/repos/freebsd-ports-quarterly'
Add missing dependency: constants
Change GetRepoNameForBranch() to use newly FreshPorts::Constants::GitRepos We want to convert ports and ports-quarterly to freebsd-port and freebsd-ports-quarterly respectively. We have labels; we want directories.
This is the start of passing in the Repository name to many functions to enable correct repo-on-disk identification
remove commented out code with hardcoded commit_hash, repo, and FileRevision
remove commented out code referring to {repository} = 'ports';
put a space before: for git
Correct unkonwn to unknown
Document where we need to delete the port
do 2>&1 to redirect stderr to std out so we capture the git stuff into the .loading log file
How did that = get in there?
Line up some columns use the right name in logging. Use the repo we told to use. delete commented out code
Correct the name of the script
Removing blank lines.
Some colum alignment
Add two functions needed for processing git commands. Perhaps they should be in another file, but config.sh is included by thoese that need these.
Adjust whitespace
These two have been replaced by job-waiting.pl
use svn+ssh://svnusers send to r720
Put a tag in there, so we know where it's coming from
Mention that we only extract values from the ports repo, not the other repos
Add SET CLIENT_ENCODING TO 'SQL_ASCII' on a select. Not everything is UTF-8, so we have to do this for now. Whitespace some stuff
While attempting to figure out a 'wide character' issue * https://github.com/FreshPorts/git_proc_commit/issues/ I rewrote the query for saving commit_log - this was to get all the encoding done by $dbh->do(). It didn't help. What heped was ;client_encoding=UTF8 on the database connection string.
Moving to git, we take a slightly different approach. We need multiple working copies because there are multiple git repos: * freebsd * freebsd-ports * freebsd-docs Change path_to_tree to RepoDir Move CheckGit from freshports to ingress signal directory
Set client_encoding=UTF8 on connect
Save commit_hash_short
Refer to master, not head.
We renamed SVNBaseDir
We have jobs for both git and svn, and for ingress and freshports
Add the script which checks out a specific commit
Now that we have git and svn processing, create a separate script.
Add deails for the ingress user directories. Add other details pertaining to git processing
Make this work for the new repo locations and names
Add in the git repos While here, column align some stuff
'correct the enable'
'adding 315.fp_check_git_for_commits'
Correct the enable: fp_check_for_git_commits_enable
'adding 215.fp_check_git_for_commits'
Add
Fairly stable now
Rename projects
'Mention that our MSGDIR is also defined in the freshports configuration file'
'rename fp-ingress to ingress'
'output the main files upon startup'
Mention that our MSGDIR is also defined in the freshports configuration file
Add INGRESS_MSGDIR to the configuration file output the main files upon startup
'Correct FRESHPORTS_MSGDIR'
Correct FRESHPORTS_MSGDIR
'rename fp-ingress to ingress'
'renamed from fp-freshports to freshports'
This repo was moved to freshports Rename everything fp-freshports to freshports
This repo was moved to ingress Rename everything fp-ingress to ingress
Rename fp-ingress to ingress
Rename fp-freshports to freshports
'move from logger to echo'
Move config.sh.sample to config/fp-ingress.sh Move from logger(1) to echo(1)
Rename config.sh.sample to config/fp-freshports.sh Yes, the script and the configuration file have the same name. The config file should be installed to /usr/local/etc/freshports/fp-freshports.sh
remove files required only for daemontools, which is no longer used to run this script.
Stop using logger, use echo. daemon(8) will direct that output to syslog and from there into the correct log file.
remove files required only for daemontools, which is no longer used to run this script.
'Move configuration file: -. /usr/local/etc/freshports/daemon-config.sh +. /usr/local/etc/freshports/fp-ingress.sh '
'Move configuration file: -. /usr/local/etc/freshports/daemon-config.sh +. /usr/local/etc/freshports/fp-ingress.sh '
'Move configuration file: -. /usr/local/etc/freshports/daemon-config.sh +. /usr/local/etc/freshports/fp-ingress.sh '
Move configuration file: -. /usr/local/etc/freshports/daemon-config.sh +. /usr/local/etc/freshports/fp-ingress.sh
'Move configuration file: -. /usr/local/etc/freshports/daemon-config.sh +. /usr/local/etc/freshports/fp-freshports.sh '
Move configuration file: -. /usr/local/etc/freshports/daemon-config.sh +. /usr/local/etc/freshports/fp-freshports.sh
Remove id, no longer required.
'Move configuration file from config.sh to . /usr/local/etc/freshports/daemon-config.sh'
Move configuration file from config.sh to . /usr/local/etc/freshports/daemon-config.sh
Add
'Move to daemon(8)'
Saving all this as we move to daemon-tools
'move fr1m sysutconfiguration file to /usr/local/etc/freshports/daemon-config.sh'
Add in the new values now that we have one shared config file
'move fr1m sysutconfiguration file to /usr/local/etc/freshports/daemon-config.sh'
'move fr1m sysutconfiguration file to /usr/local/etc/freshports/daemon-config.sh'
Change configuration file from: config.sh to: /usr/local/etc/freshports/daemon-config.sh Start using FRESHPORTS_* variables this daemon doesn't need a incoming directory any more
'move from sysutils/daemontools to daemon(8)'
I'm moving to two daemons:
fp-freshports - same function as fp-daemon had
fp-ingress - processing incoming commits into XML
this is partly the mailfilter script
and part of what fp-daemon.sh once did.
Sort the jobs
Rename fp-daemon.sh to fp-freshports.sh
Renamed this to fp-freshports It is being named after the user it runs as
Remove unused $DaysRefreshed Sort contents of %Jobs Add $FreshPorts::Config::CheckGit => 'check_git.sh
Copy this over for use as an ingress daemon: * receives notice of new commits via signals * creates XML * moves XMl into ~ingress/message-queues/incoming directory Potential signals * commits waiting * which repo? * commit hash? * run single commt * which repo? * commit hash? * hooks - I imagine hooks will be intercepted externally and signals raised * email - If commit emails are implemented, that could also raise a signal
Taken from the subversion version of this code, we now have something with works with git.
removed INGRESSDIR add MSGDIR This may be reversed soon. I'll be creating a ingress.sh daemon and it will also need a config.sh file.
When the datatypes need to be redone, redo the datatypes too
svn_hostname => repo_hostname
RENAME svn_hostname TO repo_hostname
Branch for git
whitespace only
Spell: element id
Use commit log message not email subject With git processing, we run off the repo, not incoming commit email. Thus, we must change.
Branch for work on git
'rm /usr/src/sys/Makefile from the ports-jail'
Remove the usr files re: https://github.com/FreshPorts/freshports/issues/152 The nvidia drivers are needlessly marked as IGNORE. For example https://www.freshports.org/x11/nvidia-driver-390/ The message is: IGNORE: requires kernel source files in SRC_BASE=/usr/src This message is produced by https://svnweb.freebsd.org/ports/head/Mk/Uses/kmod.mk?view=markup around line 25 Example: [dan@dev-ingress01:/var/db/freshports/ports-jail/var/db/repos/PORTS-head/x11/nvidia-driver-390] $ make -V IGNORE requires kernel source files in SRC_BASE=/usr/src The code looks for ${SRC_BASE}/sys/Makefile Creating that file avoids the issue: $ sudo mkdir /usr/src/sys $ sudo touch /usr/src/sys/Makefile $ make -V IGNORE $
'Bring in new PYTHON_PKGNAMEPREFIX code - for real this time'
add in python_pkgnameprefix
Add in make-flavors-package-names.sh
'Bring in new PYTHON_PKGNAMEPREFIX stuff, abort on UNKNOWN branch'
'Bring in new PYTHON_PKGNAMEPREFIX code'
extract PYTHON_PKGNAMEPREFIX from the port
Combine some lines into one. Whitespace only.
Add the correct command to create the required thing
'remove trailing * from NEWS_CACHE_DIR'
Some simple updates
Create git branch
Create branch for git work
Remove reference to unset value.
Need this to fix IGNORE for ports which use kmod re: https://github.com/FreshPorts/freshports/issues/152
Adding, it was never added before
'Create a fake /usr/src/sys/Makefile to avoid spurious INGORE messages by ports which use kmod '
Create a fake /usr/src/sys/Makefile to avoid spurious INGORE messages by ports which use kmod re: https://github.com/FreshPorts/freshports/issues/152
Fix GetCategoryPortFromLatestLink() which did not work well with branches. This fixes: * https://dev.freshports.org/commits.php?package=mariadb55-server * https://dev.freshports.org/?package=mariadb55-server * https://dev.freshports.org/filter.php?package=mariadb55-server * https://dev.freshports.org/vuxml.php?vid=198e6220-ac8b-11e9-a1c7-b499baebfeaf re https://github.com/FreshPorts/freshports/issues/124
'convert all http to https, get ready for MaintainerPorts'
pacakges -> packages
'fix a proctitle error with wide characters'
Avoid readproctitle errors by doing UTF-8
'remove debugging date'
remove hardcoded date used for debugging
Add missing require: FreshPorts::committer_opt_in This will avoid this error: nUndefined subroutine &FreshPorts::CommitterOptIn::RecordErrorDetails called at ./process_vuxml.pl line 124, <> chunk 1.\n
'add report-maintainer-ports.pl'
Uncomment code to detect debugging mode
Go case insensitive on the email address match
Use FQDN for pkg01
'Add daily/311.send-report-maintainer-daily & fix daily/220.fp_daily_rendering_times switch'
Add periodic script for maintainer daily notifications
Fix the broken YES switch. The logger statement is in the wrong place
fix PortVersionLatestBeforeQuarterlyBranch which was not pulling back the full version information
use https, not http
remove: * NotificationNonPorts & NotificationDirectories - they appear to be unused * add MaintainerPorts for new report
We have a report on maintainer ports
pg_hba.conf not pg_hba,conf
Mention where the real code is in dev
'add PGSSLMODE to config.sh'
Add PGSSLMODE
'add BASEDIR_PACKAGER to config.sh'
Add BASEDIR_PACKAGER
Move some inserts into another ddl update file. This one to be run after ri.txt
Remove trailing * from news cache
A copy of package_imports_completed is needed here
Move iso_date() and iso_date_seconds() above where they are used.
Adjust PortPackages to also return processed_date While here, return formatted dates, without seconds. Create iso_date_seconds() to format that date.
'remove system() which did nothing in process_vuxml.pl'
We don't need this any more. We use zfs rollback instead
Save recent work, before removing.
remove system() which did nothing
add GetPackageStatus() and iso_date()
Add value to listen_for for clearing packages.
'if the rollback fails, say so'
If the rollback fails, say so
'add category and packages cache clearing'
Change the signal name to match the others I note that the listen_for table is not named great. The script_name isn't necessarily the script which gets invoked, but it does help.
Add ability to clear packages cache via zfs rollback Add in the category cache which I'm sure is needed in prod Convert all lingering print to syslog. Remove commented out code
first version, going to start using -e next
A starting point for package cache clearing
Properly save away the package_raw update code. See http://news.freshports.org/2020/04/28/found-new-repo-release-automatically-imported-it
Add new columns to package_imports
'Add new new signals: * new_repo_ready_for_import * new_repo_imported'
'job-waiting.pl now handles the new packages code'
'remove "nothing found" logger command It fills up the logs.'
remove 'nothing found' logger command It fills up the logs.
Add new new signals: * new_repo_ready_for_import * new_repo_imported
PackagesLastCheckedSetRepoDate() needs to grab the pre-update value of repo_date for comparison
Change the update package_imports table to set newly added columns: last_checked, repo_date, import_date, processed_date
Change our job-waiting loop. When the job_waiting signal is set, run the waiting jobs and keep runnint them until we don't find anything more to run.
Rewrite PackagesLastCheckedSetRepoDate to clear processed_date & import_date if the new repo_date is not the same as the incoming date. If the dates are the same, no update occurs. Returns the number of rows updated.
Remove ports_origin from the equation
Update packages_raw by joining with ports and element_pathname
Document why the analyse is required before DELETE
Adjust names for some functions to better describe what they do.
Add * PackagesLastCheckedSetImportDate() * PackagesGetReposNeedingImports()
fix packages_last_checked to use package_sets populate public.abi
Add * GetReposToReview * PackagesLastCheckedSetRepoDate
when a new row goes into abi, add two rows into packages_last_checked
Fix how the updates are done for port_origin. There is no OLD to check.
Rename trigger and function ports_origin_insert to ports_origin_maintain because it's run on both update and insert, not just insert. Use IS DISTINCT FROM on the update.
Add public.package_imports
Add in the real PortPackages
Updates to reduce stuf we don't need any more
Add ABI table
Add DDL for packages
Whitespace for element_pathname_update Change ports_origin_insert to pull port_origin first Then do the UPDATE only if things have changed - no need to churn
When copying data from packages_raw to packages, first set port_id and abi_id When comparing, also use P.port_id = PR.port_id addReviewed by:
keep the ports_origin table up to date when package_imports is updated, note that in the packages_last_checked table a bunch of ' on ' to ' ON ' etc
Work in progress
Add UpdatePackagesFromRawPackages()
add PackagesRawDeleteForABIPackageSet()
DISTINCT doesn't need () sort_key is no longer required
PortPackages is working.
We got progress
We now have a scripts to load in new stuff
Expand PortPackages to pull back dates from packages_last_checked
adding: * NormalizeBranch - convert latest to head and quarterly to latest branch * PackagesLastCheckedSetRepoDate(a_abi_name text, a_branch_name text, a_CheckedDate text)
Add AddNewABIToPackagesLastChecked() This should be invoked each time a new row is added to the ABI table.
Add stuff
Making good progress on packages
Add stuff related to packages
Add DeleteUser
Delete by user id as supplied by the code.
The initial intent was to delete by cookie, but that
value is on the client. Let's do this by id instead.
SECURITY DEFINER - means run this function as the user
which created. This means the www
user does not require write permission
on the users table.
whitespace only
Update to new locations
fix
ouch
fix
fix
clean
Damn. That was wrong.
These are helper scripts, mostly for use with commits after they have arrived. When you're looking for the raw file, use these tools
'Don't ignore everything after Directory Properties'
Stop using variables before testing if they are defined This is fallout from testing for: * https://github.com/FreshPorts/freshports/issues/133 * https://news.freshports.org/2020/01/25/the-slave-ports-for-devel-binutils-did-not-get-deleted/
In the original version of this code, we always ignored everything after a Directory Properties line. We now just ignore that section. This error led to whole swaths of emails being ignored. Oops. see https://github.com/FreshPorts/freshports/issues/133 https://news.freshports.org/2020/01/25/the-slave-ports-for-devel-binutils-did-not-get-deleted/
'make it work'
Remove duplicate code from ClearMiscCaches() which used glob.glob
Remove superfluous comments use NEWS_CACHE_DIR instead of NEWS_CACHE_PATH
'Use path for cache/news'
Use path for cache/news because glob.glob is not working
'has_key is not Python 2 any more'
Add
has_key is gone in Python 3 While here, add more debugging.
'initial package'
'Now Python 3 compatible'
Updates for Python 3
'Always include the SQl when displaying an error'
'fix broken XML chars'
Strip characters which are not valid in XML
Note that FreshPorts::Config::email_server must be a hostname, not an IP address.
Whitespace only
r710-01 has been replaced by pkg01
'Fixes for Python 3.6'
Upgrades for Python 3.6
Fix CreatePort(text,text,text) by not using GetPort() with the SQL. It seems to not be pulling in the correct value.
Add much debugging output. Always include the SQL in the error message.
Always include the SQl when displaying an error
use = not ==
remove debugging recently added to element_pathname_insert()
Fix new element insertion failures on PostgreSQL 12
Was getting this:
select Element_Add('/ports/head/www/httpdirfs/', 'F');
ERROR: duplicate key value violates unique constraint "element_pathname_pathname" DETAIL: Key (pathname)=() already exists.
Because:
INSERT INTO element_pathname (element_id, pathname)
VALUES (NEW.id, element_pathname(NEW.id));
The pathname value was always NULL.
The fix, change the SQL to:
DECLARE
l_pathname text;
BEGIN
l_pathname := element_pathname(NEW.id);
INSERT INTO element_pathname (element_id, pathname)
VALUES (NEW.id, l_pathname);
Updates for PostgreSQL 12 iscachable -> IMMUTABLE Use ROW_COUNT because RESULT_OID is gone.
'we lost the 1.0.10 tarball'
'fix https://github.com/FreshPorts/freshports/issues/121'
remove extraneous /
Repair duplicate and extraneous results. fixes https://github.com/FreshPorts/freshports/issues/121
'Start doing cp & use mv and rm instead'
use -p to preserve mtime
Instead of using mv which caused: /usr/local/bin/readproctitle service errors: ...message-queues/recent/2019.07.15.15.42.07.48391.txt.raw: set owner/group (was: 10002/10001): Operation not permitted\nmv: /var/db/freshports/message-queues/recent/2019.07.15.15.43.31.53460.txt.raw: set owner/group (was: 10002/10001): Operation not permitted\nmv: /var/db/freshports/message-queues/recent/2019.07.15.15.45.39.56551.txt.raw: set owner/group (was: 10002/10001): Operation not permitted\n use cp and rm even when using this example: [dan@dev-ingress01:~] $ ls -l ~ingress/message-queues/ ~freshports/message-queues/ /var/db/freshports/message-queues/: total 248 drwxr-xr-x 18 freshports freshports 18 Jul 2 03:16 archive drwxr-xr-x 10 freshports freshports 18 Jun 10 22:03 retry /var/db/ingress/message-queues/: total 3 drwxr-xr-x 2 root ingress 10 Mar 20 13:53 DUPS drwxrwxr-x 2 ingress freshports 2 Jul 15 15:29 incoming
'minor changes, no bug fixes'
Add Quarterly revision * fixes #115 * display the port version on the latest quarterly branch Add sort-by last updated * fixes #116
Start describing the upgrade
fixing
fixing
Good script, but checkout-branch is better
Use $0 instead of hardcoding our own script name
Also refresh etc/make.conf in the PORT JAIL
Align the echo and the code to make it easier to read. Whitespace only.
'We have two scripts which check master-slave. One queries the databse (.pl), the other queries the Makefile (.sh). Fix both and comment appropriately'
We have two scripts which check master-slave. One queries the databse (.pl), the other queries the Makefile (.sh).
Provide a script to copy the Jail scripts into the jail.
'update test-master-port.sh now that sysutils/bacula-server is gone from the tree'
sysutils/bacula-server and sysutils/bacula-client are deprecated. Use bacula9 instead
'when logging, log to a .log file, this will help with log rotation'
Log to a .log file--This line, and those below, will be ignored-- M daily/300.send-security-notices M daily/310.send-report-notices-daily M daily/320.send-report-new-ports-daily M fortnightly/310.send-report-notices-fortnightly M fortnightly/320.send-report-new-ports-fortnightly M monthly/310.send-report-notices-monthly M monthly/320.send-report-new-ports-monthly M weekly/310.send-report-notices-weekly M weekly/320.send-report-new-ports-weekly
'fix hard-coded hostname'
Whitespace only
Stop using Email::Address::UseXS because things have been fixed. remove commented out code.
Remove leading space
'* Add element_pathnane to missing-port-categories.sh so we see branch details'
'Add new config.pm value: $FreshPorts::Config::ScriptDir, Start using Email::Address::UseXS because of upstream deprecation'
Check out the given branch to our local repo directory
Add the element pathname, so we see the branch
When we can't find the branch for a commit, try checking it out.
Add punctuation to logging messages
Add FreshPorts::Config::ScriptDir for use by perl modules which need to run scripts.
whitespace changes
Remove stuff no long relevent Add mention of sudoers.
Add hostname to test email
Better instructions
Use Email::Address::UseXS
whitespace only
Commit out We DID NOT LOCATE that port
'remember to delete package_flavors before adding'
delete existing flavor information for this port before adding
Remove vertical whitespace to avoid: replaced vertical whitespace in Subject header with space; this will become fatal in a future version at /usr/local/lib/perl5/site_pe
'Adopt a new approach by putting all the directory queue locations into a hash'
'removing status.pm'
Adopt a new approach by putting all the directory queue locations into a hash
Give the email subject a correct description
'give the missing ports_categories email a better subject'
'add Flavors, adjust ccommitter_opt_in to use new email modules, assign default value to database.pm::sslmode, update email.pm to use Email::Simple not Mail::Sender(now deprecated)'
rsyncer must be able to dump all tables
'add package flavors'
Comment out some RAISE NOTICE
Add make-flavors-package-names.sh script
Be sure to install scripts/vars.sh.sample
do not drop TYPE conflicts
mention flavors script
Change DROP TRIGGER to DROP TRIGGER IF EXISTS
Do not create plperl here. It already exists. That creation is done via an UPGRADE.
Add the tables and functions for package flavors
Here is a better way to implement LatestCommitDatePorts()
'add package flavors'
Add package flavors
Add port flavors, much whitespace adjustment while here.
Add a way to refresh just one port. You must modify the code to specify that port
Fix the way we calculate the number of vulnerable ports.
Get the number of commits processed today.
'add everythreeminutes'
Add a new periodic time frame: everythreeminutes
Add a script to get: * Number of queued commits * Commit processing status
'standardize logger use'
Invoke logger only if the periodic is enabled Standardize on logger -f local3.notice Use $0 instead of hardcoding the filename
Correct CategoryPortCount() so it uses the incoming parmeter, not a hardcoded 'databases' value.
Turn debugging off
'Convert from using p5-Mail-Sender to p5-Email-Sender, Honor $FreshPorts::Config::ReportDebugging for reports, Add test-sending-email.pl'
Delete this, created in error
'Replace p5-Mail-Sender with p5-Email-Sender'
Add a script to test outgoing email
Convert from using p5-Mail-Sender to p5-Email-Sender * headers are now passed in via a hash report-new-ports.pl now takes a range, as originally intended show-config.pl: stop using email_client and use only email_server
Replace p5-Mail-Sender with p5-Email-Sender Because of this, pass in in the headers as a hash, not a string.
Remove email_client: please use email_server instead Add ReportDebugging, to allow reports to run without sending anything.
'Append to logs instead of overwriting them'
Append to the log, via >>, instead of overwriting it with >
'honor $FreshPorts::Config::ReportDebugging'
Honor $FreshPorts::Config::ReportDebugging and stop using $Debug
'do a better job of logging'
Do the logging properly
Remove, created in error
'add periodics for daily, weekly, fortnightly, and month notices'
Add new periodic scripts for * daily security notices * daily, monthly, fortnightly, and monthly notices for * changes to ports on your watch list * new ports
Fix CategoryPortCount() to be branch-aware
'Allow ssl_mode to be set on database connections'
''
This fixes: https://github.com/FreshPorts/freshports/issues/67
Document the changes for GetPortFromPackageName()
whitespace changes only
Make it work with new repo locations
'better defaults in config.sh.sample, make missing-port-categories.sh email results'
Since this is now a periodic, and it's actually running now, make it work since we need to send an email. The output goes to a log file via: $ grep output /etc/periodic.conf hourly_output=/var/log/hourly.log daily_output="/var/log/daily.log" weekly_output="/var/log/weekly.log" monthly_output="/var/log/monthly.log"
Set default ADMINEMAIL to me
Change the default value for FRESHPORTS_JAIL_USER to freshports, from dan
Set sslmode in config.pm
Add: CREATE TRUSTED PROCEDURAL LANGUAGE plperl
Add ports_conflicts_set trigger
Add permissions for CONFLICTS
This is what worked for CONFLICTS on staging.
Save work in progress
Set defaults Correct SQL
'-m'
'better process_updating.sh logging. extract CONFLICTS, CONFLICTS_BUILD & CONFLICTS_INSTALL from port'
Add
Take a copy
Remove cruft
remove cruft
Working on CONFLICTS What I'm saving here will have to be trimmed, but I'm saving everything so I have it.
Ignore config.sh
When inserting, set a value for the commit_log_ports.port_name_revision field. This is used when comparing against the ports.conflicts* fields.
Maintain these three new database fields on the ports table * conflicts * conflicts_build * conflicts_install
Extract three new values from the Makefile: * CONFLICTS * CONFLICTS_BUILD * CONFLICTS_INSTALL
Better logging messages
The modules are now at ingress/modules Many things we once removed for packaging are no longer included.
'Fix vuxml non running, improve logging'
'renamed script, better error logging'
'supply default values for key variables'
Better and minimal logging.
'Add default values and logging upon start'
Duplicated by existing cut-freshports-periodics
Fix URLS
Renmaing
Assign default values log that you are starting up
Uncomment the real stuff
Remove superflouous files
Add
if job-waiting.pl dies, log it.
'catch more errors if vuxml_latest.pl fails'
All of the following deficiencies led to hiding permissions issues on a directory. * mention when process_vuxml.pl begins * say vuxml_ident.pl, not vuxml ident * say vuln_latest.pl, not vuxml latest * toss the output of vuln_latest.pl into the log file * if an error occurs during vuln_latest.pl, refer the reader to the logfile Instead, now we see this in the vuxml.log file: ### process_vuxml.pl finishes '/var/db/freshports/cache/html' exists trying to open '/var/db/freshports/cache/html/vuln-latest.html.tmp' could not open '/var/db/freshports/cache/html/vuln-latest.html.tmp' Tue Aug 14 14:59:55 UTC 2018 process_vuxml.sh vuxml finishes ####
Return the value from CreateVulnHTML so the calling script can take action upon error.
'fix broken vuxml running'
Created in error
'When things go wrong, log it'
'When things go wrong, log it'
There is not constants Only FreshPorts::constants This was causing vuxml to not be processed.
Add a prefix for easier logcheck filtering
There is no FreshPorts::warnings. Only warnings
Add a prefix so it's easy to filter via logcheck
When things go wrong, log it.
When saying not found, mention not found by whom
When saying not found, say by whom
'remove nice on daily/100.fp_archive_messages'
Don't do nice, it causes: su: setpriority 'root' (root): Permission denied
'remove duplicate numbers in logger messages'
Tagged in error
'remove duplicate numbers in logger messages'
Don't double up on the number in logger
Create branches, tags, trunk
Oops. Didn't mean to do exactly that.
Move
Rename to trunk
Add
Rename, while I create branches, tags, trunk
This code no longer used. see svn+ssh://svnusers@svn.int.unixathome.org/freshports-1/ingress instead Split the code into two parts: 1 - scripts run from the command line 2 - Perl modules used by some of those scripts
Split the code into two parts: 1 - scripts run from the command line 2 - Perl modules used by some of those scripts
Move scripts into a new scipts directory. Create new modules directory
Split the code into two parts: 1 - scripts run from the command line 2 - Perl modules used by some of those scripts
Code for processing incoming commits
'-m'
'improve logging messages'
Do a better logging attempt
Rename
'better messages'
Better messages
remove extraneous declaration of $FreshPorts::Config::JailBaseDir
'user logger -t FreshPorts'
With logger, add -t FreshPorts for better logcheck compatibility
'Fix SHEBANG issue in Makefile.pl'
Whitespace only
use /usr/local/bin/perl
'rename freshports to fp-daemon'
Rename freshports to fp-daemon
'perl string comparison is eq not =='
String comparison is eq, not ==
'Sys::Syslog, not Syslog'
Sys::Syslog, not Syslog
'Remove FreshPorts:: from DBI references, erroneously added.'
Remove FreshPorts:: from DBI references, erroneously added.
Add
Catch up with recent changes to the code
'Try newly checked in scripts'
'Try newly checked in scripts'
Prepend all use and require with FreshPorts::
we need config.pm.sample and status.pm.sample
Scripts for creating releases
OH, we don't need this
create trunk
Scripts for creating releases
Add this, used when building FreshPorts-Modules
If the file is blank, return from _GetRealPath
''
''
''
Use more logger, less echo
''
When inserting dependencies, ignore duplicates. re: https://www.freshports.org/commit.php?category=net&port=ceph&files=yes&message_id=201803060059.w260xMYN015292@repo.freebsd.org https://news.freshports.org/2018/03/11/duplicate-dependency-issues-avoiding-duplicate-rows/
Remove trailing whitespace from a couple of lines
'fix breaking of path:dir[:target] dependencies tuples into dir[:target] tuples'
Fix the splitting of path:dir[:target] into dir:[:target] re https://www.freebsd.org/doc/en_US.ISO8859-1/books/porters-handbook/makefile-depend.html With help from https://gist.github.com/ktracer
Flush the cache when vuxml processing occurs
'simple changes in process_vuxml to be closer to original code'
Reduce the scope for $fh Revert declaration of $p to orignal location
Remove spurious committer_opt_in include introduced in r4906
'I think4threquire SSL on connection; fix vuln processing'
'I think4threquire SSL on connection; fix vuln processing'
Although I think this script is no longer used, let's update it.
white space and comments
Fix the stale filehandle issue with processing vuxml errors. It seems we are creating a new $fh value each time through the loop. While that approach worked with HANDLE, it does not work with IO::File. We were getting errors such as: no element found at line 1, column 0, byte 0 at /usr/local/lib/perl5/site_perl/mach/5.24/XML/Parser.pm line 187. I think that is indictative of an empty file. I encountered similar messages when printing the contents of the $fh before invoking the parser but those messages went away if I did a seek to te beginning of the file before parsing. I also noticed that the processing worked for the first vuln it processed, but never for the second. Invoking the script again allowed another vuln to get processed, and so on. That is what led me to the 'reuse' issue. I also tried a $p->DESTROY(); ... this also allowed things to work but this commit is a much better solution.
Remove spurious entries Adjust whitespace
Require SSL on connection
'I think the vuln processing is fixed'
'I think the vuln processing is fixed'
I think I've fixed the vuln issue
Better SQL
Updates not previously saved
fix trailing newline
Fix trailing newline
Fix trailing newlines
Add trailing newline
Better formatting
'fix two scripts so perhahps they can work'
Supply a parameter for rendering days
Fix shebang
Add more logging re what we are deleting
Remove quotes. They are retained in the string and won't work with glob
'When adding a dependency to the database, strip any @py27 or :configure type stuff first'
When adding a dependency to the database, strip any @py27 or :configure type stuff first.
Fix news directory
'use True and False, proper Python values, not true/false'
Use proper Python boolean values (e.g. True instead of true).
Make ClearMiscCaches compile
Fix ClearMiscCaches so it runs
Adjust for what works
'Allow fp-listen to clear news cache etc when a commit occurs'
Addl fp-listen to clear news cache etc when a commit occurs
'-m'
Umm, move the code into the if, so it's not executed every time.
'-m'
Remove generate_plist from updating the ports tree. That column has been removed.
'-m'
Ignore empty lines
'-m'
'-m'
When there is no generate_plist, be sure to delete what's there.
Added when we have a bunch of FreshPorts::Ports_generate_plist=HASH(0x806d9f0d8) see https://svn.int.unixathome.org/viewvc.cgi/freshports-1/scripts/trunk/port.pm?view=annotate#l1234 I changed $this->{generate_plist} to $generate_plist
Add trailing '
Fix SPOOLINGDIR
add fp_refresh_various_cache_items
Add cache-refresh.sh
'adjust dyndirectory locations'
'8djust dyndirectory locations'
We use constants. Declare that.
Remove unused code: * summary-all-days-create.pl * test_DailySummary.pl * test_FileBasename.pl
Remove log-munger code long not used
Remove old unused code: log-catcher
Adjust this to suit new directory locations
Deprecated in favour of queue-status.pl, used by Nagios.
'Discard the output of hourly_stats.pl'
Discard the output of hourly_stats.pl
'adjust dynamic to cache'
adjust references to dynamic so they refer to the new structure
Fix the signals directory
'Correctly count files in ports tree. config.sh and config.pm improvements'
'Correctly count files in ports tree. config.sh and config.pm improvements'
Comment update
Avoid counting . files, such as .svn, which will artifically inflact the number
'use the correct user for checking missing categories on ports'
Use the correct user.
'fix hourly_stats db connection'
Add in missing my
'hourly_stats is now RO connection'
Connect read-only
Set ConnectionType if not supplied.
Whitespace only
'Allow database connections without parmeters to default sensibly'
Connect as RO
Allow for no incoming ConnectionType and default it to commits
'Add RO database connections'
Remove FREEBSDCVSUPHOST, no longer user set DBUSER='reading', because most .sh scripts should be readonly
Add whitespace
When connecting, ask for a RO connection
* Add optional parameter when invoking FreshPorts::Database::GetDBHandle * use $FreshPorts::Constants::DB_ConnectionType => SOMEVALUE * possible values are: * $FreshPorts::Constants::DB_ConnectionType_ReadOnly * $FreshPorts::Constants::DB_ConnectionType_Commits * $FreshPorts::Constants::DB_ConnectionType_Listener
Add FreshPorts::Constants::DB_ConnectionType for use when calling FreshPorts::Database::GetDBHandle
* add user_listening and password * add user_readonly and password
Add three database connection types: * Commits - used by default * read only - will become the default soon * listening - used by fp-daemon
'Add new_users.sh'
'Add new_users.sh'
Add
'Move into subdirectories'
Move things into directories which indicate intent
Add, soon to be moved
Sort by count and name
Add
Add
Renumber
Add
Same for this one
Make them silent. Make them run. Deep.
'Add master port checks'
Add two more check
Archive messges using the proper directory
use MSGDIR for archiving, not something we make up locally
''
mv to correct location
mv to correct location
mkdir branches
First release
mkdir tags
First attempt
Moved to trunk
Copy to trunk, so we can do branches etc
Initial import
Remove blank line
'stop using HANDLE for vuxml, use FILE::IO instead'
Better vuxml to avoid HANDLE errors
Stop using HANDLE and start using File::IO This will hopefully avoid: Name "main::HANDLE" used only once: possible typo at ./process_vuxml.pl line 89. This should have been included in revision 4905
Stop using HANDLE and start using File::IO This will hopefully avoid: Name "main::HANDLE" used only once: possible typo at ./process_vuxml.pl line 89.
When not refreshing explain: this port *** EITHER *** does not need a refresh *** OR *** we were told not to fetch
'make for better status gathering'
Cater for different queues used on different hosts
We're going to a single tier queue. No more multiple queues.
Do not invoke LOGGER before it is defined via config.sh Add more logging calls
Alter this script so that each port is always updated. Remove ValueHasChanged() Become branch aware, because we have active ports on branches.
'make set-generate_plist.pl work'
Make this script work
'improve config and path to script'
'improve config and path to script'
'remove pkg_plist and makefile'
Invoke freebsd-cvs.sh with /bin/sh, just to be sure.
Better logging, to local3, which is what FreshPorts uses.
Add port_dependencies_clear_cache()
Remove ports.makefile & ports.pkg_plist Add generate_plist
remove pkg_plist and makefile re https://github.com/FreshPorts/freshports/issues/53
Whitespace only
'add missing make-generate-plist.sh'
Add make-generate-plist.sh
Sometimes, you need to refresh from head..
'Add more logging during initial processing of message'
Add more logging during initial processing of message. * Branch * Subject * message-id
'Reinstated erroneously removed code. Add in JailConfigurePlist'
Reinstate the depends_* trimming erroneously removed in a recent commit. While here, remove unnecessary references to SVNDIR_CHROOT
Add missing JailConfigurePlist
'add missing file for generate_plist'
Add missing file
'Fix path to perl'
Use the correct path for perl
'Stop using paths in DEPENDS. Start using generate_plist'
better logging
Add generate_plist feature. Fixes https://github.com/FreshPorts/freshports/issues/50 This will give us a better pkg-plist solution. Stop using full path names in depends field: * depends_build * depends_run * depends_lib * fetch_depends * extract_depends * patch_depends We were storing taking a As a result, we no longer need these functions: * freshports_ConvertPortPathToStandardLocation() * depends_stripper()
'use new psycopg2 code'
Update the code for use with psycopg2, as grabbed from jester, but not checked in.
Remove unused it: QUEUENAME
move fp-listen.py to a subdiretory
Move fp-listen.py to a subdirectory
log to facility=syslog.LOG_LOCAL3
Log to facility=syslog.LOG_LOCAL3
add setup.py
Add
start using configparser
Start using configparser — Configuration file parser
Fix scriptdir typo
new fp-listen tag
Upgrade for new freshports user approach
better logging
better logging
Use FreshPorts::Utilities::Report not syslog
Use FreshPorts::Utilities::Report
Start using FreshPorts::Utilities::Report
Add Report($;$) which takes a level and a message. Use this function internally. Start logging via local3 so we can capture that via syslog
Stop using . for concatenation
Invoke logger via local3.info to help direct all syslog messages to /var/log/freshports
Invoke logger via local3.info to help direct all syslog messages to /var/log/freshports/
rename Verify/README to Verify/README.txt
rename Verify/README to Verify/README.txt
Rename to be like all the others
Adjust UMASK to be group writable (002) Adjust regex to consider only headers (:h) When discarding a message, log the Date, From, and Subject, much like a delivery.
fix broken ingress path
The incoming directory is under ingress
New directory structure
Upgrade to new directory structure
use vars.sh.sample
Rename for better FreeBSD compatibility
We have a sample file, we should use it
A little more logging
use /usr/local/bin/perl, not /usr/bin/perl
Change /usr/bin/perl to /usr/local/bin/perl
BConvert config.pm.sample to new directory structure
Migrate to new directory layout
Document that it needs fixing with respect to directories
Better mailfiltering
Add more logging. Make better use of to instead of cc
Specify Maildir despite using neither Maildir nor mbox. Why? I suspect it might make a difference in how the files are saved. Maildir saves to a temp file, then moves it o the final destination. We want that behavior. Under procmail, it was designed to save to a temp file, then mv. Now that we are using maildrop and Maildir, let's use their save/mv instead of doing it ourselves. Mind you, perhaps procmail did that too? Forwarding email address must be prefixed with a ! Stop doing the save/mv we did in procmail. Let Maildir handle that.
Document the move to maildrop
Release 1.0.2
Add support for maildrop
Release 1.0.1
Update, becase we don't do anything here, it all comes from the port.
Bring up to date with new directories. We no longer need foo+bar addresses because the recipient is now a dedicated user (i.e. not dan).
Add base to the list of part we process, despite it not being used yet. using https not http
Start using https instead of http
Adjust to the new directory layout to be introduced at 8xdtu.freshports.org
Remove, no longer required
I am not sure why we needed this directory
Use a constant for the email address
Reverse previous commit and leave config.sh in this directory. Instead, we will create a symlink to /usr/local/etc/freshports/config.sh Why? Pulling in a config.pm file for perl might be more difficult. Might as well use symlinks for both.
Move config.sh to /usr/local/etc/config.sh
Release 1.0.0
Correctly count on head: Restricted, NO CDROM, and Vulnerable
Correctly count Ingored ports
Correctly count deprecated on head
Count broken ports only on head
Make the count of expired and expiring ports branch aware.
Correctly count the number of new ports on head.
Avoid new stuff on branches fixes #29
Make WatchListStagingProcess operate upon HEAD only
Add stuff for ports dri
Add a commit
For making new branches. This script should be run this by hand.
Fix the number of params in a NOTICE. Bug was noticed by PostgreSQL 9.6
Multiple changes because we are now using psycopg2 re http://initd.org/psycopg/docs/extensions.html?highlight=notify#psycopg2.extensions.Notify
When deleting from ports_vulnerable the port might already be deleted. Cater for that.
comments only
Correct filename
Make many changes to remove php errors, mostly undefined index/variable
Better cache clearing
* convert all DROP TRIGGER to DROP TRIGGER IF EXISTS * add port_dependencies_insert_clear_cache() and port_dependencies_delete_clear_cache() to properly handle changes to the port_dependencies table
Add pkg_plist & makefile
Add pkg-plist and Makefile to the things stored in the ports table
This refreshes all ports, not just those on head
Not having a distfile is not an error
Better creation of ports
distinfo stuff
Cater for new columns associated with no-packages https://github.com/FreshPorts/freshports/issues/9 - Not all ports have packages
Add new columns for no-package https://github.com/FreshPorts/freshports/issues/9
Most of these changes allow for commits to ports on branches and the associated updates to any slave ports. * Add distinfo field to ports table * rename _GetPKGMESSAGE() to _GetFileContentsFromJail() because we are using it for both pkg-message and distinfo. * introduce CreatePortOnBranch()
pg_lasterror -> pg_last_error
Better debugging message whitespace
Better sleep and associated retry
The test must always be relative to PORTSDIR
* Master ports are always defined on head, because they may not exist on the branch It may occur that someone changes the master port on a branch, but highly unlikely * Remove extraneous fields from SQL query * pg_lasterror -> pg_last_error
Better retry / & delay times
pg_lasterror -> pg_last_error
add some debugging capability
Set distinfo.
whitespace
Do the commit each time. Don't check distinfo.
Set master sites
Add CopyPortFromHeadToBranch(text, text, text) & CreatePort(text, text, text) add new datatype: element_id_pathname alter all ''DROP TYPE' to 'DROP TYPE IF EXISTS' re: http://news.freshports.org/2016/06/28/branches-are-simple-but-more-complex-than-head/ http://news.freshports.org/2016/06/29/branches-add-a-new-port-automagically/ http://news.freshports.org/2016/07/02/copying-a-port-from-head-to-a-branch/ http://news.freshports.org/2016/07/02/a-single-function-for-creating-a-new-port/
The stored procedure GetGategory($CategoryName) did not work so I changed it to prefix the category name with 'ports/head/' instead of just 'ports/'. It seems this function was not used anywhere, but at least now it works.
make master-site-all has been replaced by make -V _MASTER_SITES_ALL
set $result before you test it. I have no idea why this bug did not arise earlier. That's terrible.
Keep track of elapsed time for svn up
Add pkgmessage to the ports table
Consider the interval, number of commits in past 5 minutes when reporting queue status.
Add pkgmessage to ports
set branch and add more debugging statements
Give a full path to HEAD
Add a bunch of debugging for processing UPDATING add repo.name to a query or two
null OR space, works better now
Add cache_clearing_ports
Update the samples to the latest stuff we are using
Add entry to listen_for table
Start watching for new entries in cache_clearing_dates
Add cache_clearing_dates and the RI for it.
Properly quote the incoming file. re 201601062012.u06KC53V085831@repo.freebsd.org
use /usr/local/bin/perl
Set branch before proceeding
Add more checks and use the right dir.
Add comment regarding use of branches.
Give better starting points
whitespace
Whitespace only
Better debugging
Attempt to prepend $PORTSDIR to each depends
add
whitespace only
Use a newly created constant
Use the configuration user, not hardcoded user
Print my SQL
Move the flag removal to the end of the tasks
We have pkg version and pkg_version is gone.
Cater for branches, and set a starting point; you can change that later via code
Cater for branches
Allow for --fetch for fetching before running (defaults to 1) --message_id=MESSAGE_ID_FROM_COMMIT --port=www/bacula-sysutils
Allow one port to be refreshed
Add and use FLAGDIR
Comment out a RAISE notice
Correctly name some depends fields
Make better use of SCRIPTDIR
Add a trailing newline
Use no symlinks
Seems we do not use BASEDIR here
Set client encoding in the right place.
remove trailing ?>
make sure there is a space before LIMIT & OFFSET
se client_encoding = 'ISO-8859-15' to avoid ERROR: invalid byte sequence for encoding "UTF8": 0xe1 0x66 0x69 Something to do with Ade's commits. While here. make sure there is a space before LIMIT & OFFSET
client_encoding = 'ISO-8859-15'
use client_encoding = 'ISO-8859-15' to avoid ERROR: invalid byte sequence for encoding "UTF8": 0xe1 0x66 0x69 Something to do with Ade's commits. While here. make sure there is a space before LIMIT & OFFSET
If the hostname in the message_id is not known, use FREEBSD_REPO_SVN
When you don't know the repo, say so
The host name for message_id has changed. Before revision 391113: svn.freebsd.org After revision 391114: repo.freebsd.org ref: http://www.freshports.org/commit.php?category=net&port=py-netifaces&files=yes&message_id=201507011757.t61Hv8u7065602@svn.freebsd.org http://www.freshports.org/commit.php?category=benchmarks&port=nttcp&files=yes&message_id=201507011852.t61Iqbv2094356@repo.freebsd.org
If no fieldname, abort
Do an exit when things get ugly
Change the wrapper used because the old one has trouble with more recent perl? "This shouldn't happen at /usr/local/lib/perl5/5.18/Text/Wrap.pm line 84." -use Text::Wrap; +use Text::Wrapper;
Start using _forDisplay
Create _forDisplay and start using it.
Use htmlentities on origin. Avoid XSS. Based on report by Pascal Jungblut <mail@pascalj.de>
Fix XSS issue. Reported by Pascal Jungblut <mail@pascalj.de>
Encode stuff
Better logging
Add error reporting
Try utf8 decode
This servers is on FreeBSD 10 now
Better
Better logging
Fix upload.
Add new dependencies
When search fails, let they search, don't die.
Fix a bug with searching/reporting bugs: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=197874 Better display of dependencies
Add, used by google search results: https://www.google.com/cse/all
Avoid mixed https and http. Credit to: sean@rastasean.net
Remove call to freshports_NoIndex which we did not commit
Add fetch_depends, $extract_depends, $patch_depends, & $uses
Add another contract
Add fetch_depends, $extract_depends, $patch_depends, & $uses
More fields! FETCH_DEPENDS, EXTRACT_DEPENDS, PATCH_DEPENDS, and USES
Remove AlreadyInserted code
Remove WHERE
This works.
Commits
require, not requires
This needs branches
$uses not uses$
Validate dates
Add FETCH_DEPENDS, EXTRACT_DEPENDS, PATCH_DEPENDS, and USES
Add images
Display depends as: autoheader-2.69 : devel/autoconf rename Required to build to Build Dependencies rename Reuired to Run to Runtime Dependencies rename Required libraries to LIbrary Dependencies Use Maintainer not Maintained By Use Homepage not Main Web Site bug becomes issue
Speed up the dates query. See also: http://news.freshports.org/2014/11/08/improving-date-search/
Convert from E'
Remove E from E'
Don't error out, just say nothing found.
Convert AddSlashes to pg_escape_string
Convert AddSlashes to pg_escape_string
Convert AddSlashes to pg_escape_string
Correct a print
Turn off debugging
Properly name pg_escape_string
Make it so we do not have to maintain this. Courtesy of bdrewrey
Update to a better formula
Add files we need in the jail
Better quoting
Don't use stuff before checking they are defined
Whitespace only
REturn repo.name
Return 0 for watch list data when no user id is supplied
escape message_id
use element_pathname, not pathname
use element_pathname not pathname
use element_pathname not pathname
Set Debug to zero
Add RetrievePort, AddPort, and RemovePort
Use newly created RetrievePort and AddPort
Remote trailing ?>
Escape the message id sort by element_pathname within a port
Get ready for more detail on commits
add trailing newline
Use pg_escape_quote not addslashes
Add CL to commit_log in searches
Use pg_escape_string, not addslashes
Improve debugging
Cater for a couple more mailing lists
Do not use SSL2, insecure
Fix certs
Now that host and dbname are in config.sh, remove them from here.
Add db connection information
Use ports_active, not ports_all, so we avoid deleted ports
updates
Use Mozilla::CA to deal with certificates
Add the changes to deal with branches
Works
Add. Incomplete.
Better error handling if pkg-descr goes wrong
Add a bunch of stuff for branches.
Add a bunch of stuff for branches
remove trailing ?>
Remove trailing ?>
Redirect commits.php to index.php
Prepare for index.php to take over from commits.php
Fix links to ports
Use bugzill, not gnats
Better debugging and make use of the jail paths
Fix Revision label on logging output.
Avoid duplicate entries in commit_log_ports_elements table
remove echo
Allow for old data format when doing depends links
Properly parse depends, which might look like: /usr/local/bin/perl5.16.3:/usr/local/PORTS-head/lang/perl5.16
Don't access REDIRECT_QUERY_STRING if it does not exist
Commit it all!
Missed these
Remove LooksLikeAMakefile(). We no longer get files via cvsweb, we get them via svn up.
Don't add slashes
fix up
When searching for my maintained ports, use exact, not match. Submitted by: Dag-Erling Smørgrav - des@des.no
move from 'pkg install PKGNAME' to 'pkg install category/port' Recommended by Allan Jude
update
add
Addition
Add
add
Add
Remove dead file
Add
Add savePortTableOnly()
Don't save on errors remove unused code whitespace
We might want to do a different kind of save
Cater for branch RELEASE*
Remove unused code Mention branch on error messages
Cater for yet another special Subject
Use eq not == for strings
Do not report failed dependency additions on branches
Cater for Subjects such as: Subject: svn commit: r341906 - in head: . dns dns/bind96 multimedia - 201401310024.s0V0OxDq013147@svn.freebsd.org - http://docs.freebsd.org/cgi/mid.cgi?201401310024.s0V0OxDq013147
Pass CommitBranch when saving port details
Cater for change to head proper, such as - http://svnweb.freebsd.org/base?view=revision&revision=261303 - http://docs.freebsd.org/cgi/mid.cgi?201401302226.s0UMQpDr065857
whitespace
Add SVNBaseDir
Not used
Update for Branches
Update for branches
Ignore everything after: Changes in other areas also in this revision
Correct the branch for the docs list
Allow commits group to access/use the session schema.
Now that we are using a perl module to get the List Id, fix the ID for the src list
use head, not HEAD.
Add
Add symlinks to make backend rss feed work
Remove _FetchFilesNeedingRefresh_DELETE_ME()
Start using a better way of getting mailing list properties.
Correctly print the jails
Go some way to detecting commits to branches and split the filename accordingly
Remove Pathname_ID. It is not used.
Use 'pkg install' instead of 'pkg_add'
Make sure we never have false null values for ports.commit_log_id
Display the svn link in Commit history. Suggested by: Mathieu Arnold <mat@freebsd.org>
include FRESHPORTS_FREEBSD_SVN_URL and PORTS_SVN
Include hostname and password in DSN
include R.svn_hostname and R.path_to_repo in results so we can link to the SVN comimt
whitespace only
whitespace only
Remove trailling ?> and whitespace
Fix search problem problem caused by port.last_commit_id containig a value which did not exist in the commit_log table. Situation arose when manually deleting a commit and rerunning it, which left an orphan value in the table. While here, add many aliases
PORTSDIR is needed by process_vuxml.sh
PostgreSQL now has autovacuum
Get rid of this MySQL antiquity
cater for scheidell (ports committer)
Move 'This site' up the page
Fix updates to revision name
Updates from CVS
Updates from cvs
Once you see Directory Properties, we're done.
Get the messages subject properly
Change copyright from DVL Software, now defunct, to Dan Langille
Add
Set long description / homepage
Remove PORTSDIR
comments out OPTIONSFILE
Add comment
Say which flag is not set
Don't test for an existing file from outside the jail. Drop the test entirely and just go get the contents.
Monitor incoming as well
no more Cwd or File-PathConvert.
add JailMasterSitesScript, JailShowConfigScript, JailDescr add _GetRealPath so we get the right description file
Start using a hostname for the database connection
add hostname to database connection
Add FreeBSDVersion = 9 I should find a way to do this without having the bump the versin all the time...
Add updates
Add some more jail scripts
Fix comment
Add vars/sh
We do the installing from the configuration directory
Divide up the install into server and client.
Avoid an uninitialized value message. See http://news.freshports.org/2013/07/09/xmlwriter-upgrade-causes-fatal-error/
Use pg_escape_string instead of AddSlashes. This avoid db errors like: Security Events =-=-=-=-=-=-=-= May 12 19:56:57 supernews postgres[3700]: [2-1] ERROR: syntax error at or near "\" at character 110 System Events =-=-=-=-=-=-= May 12 19:56:57 supernews postgres[3700]: [2-2] STATEMENT: select * from vuxml where vid = '7fcf1727-be71-11db-b2ec-000c6ec775d9\" class=\"resultLink/general.php?*id=\'\''
Add link to amazon afiliate program
Add a title to the FreshPorts logo. This appears during mouse hover.
This seems unused
Update copyright years to include 2013
Remove time-based values from page content. This causes the page to be different each time it's loaded, despite the 'content' never changing. Fix a long standing bug, which prevented 304 from ever being returned.
Use the jail to get the pkg-descr
To refresh certain broken pkg-descr commits
not sure why this wasn't already in here...
Put E in front of the message id
Make the animated bug optional
More docs on jail work
Add E to various search strings
Add E to various search strings.
Add some E'' to strings. Avoid database errors that way...
Remove links to pds.cgi which is broken
Remove commented out code
Fix RootBSD name
Fix the setting of port.last_commit_id on new ports
Add more jail stuff
use new jail for make master sites
Sort in the right place
Fix some rss validation nits
Add in index on commit_log (committer)
Apply the LIMIT and OFFSET to the commits, not to the ports.
Get the port name in there, and order the output
Fix a problem reported by Uffe Jakobsen <uffe@uffe.org>, regarding adding things to a watch list.
Fix how we update in place. Do this by deleting, then inserting. It gives better results without getting very complex on updates.
Add RootBSD to links at bottom of page.
Update instructions for running
Add
Retire cvsup-local-tree
Retiring this script now that SVN is used
Add
Add samples for config.pn and config.sh
Also display the required sudoers entries
Add trailing ;
Update to use the jail scripts
Add
Fix up
How to use jails
Fix...
Add support for the jail
Add the scripts for creating and running the jail infrastructure.
Add details for jail, as imagined by zi@
Fix /UPGRADING and /MOVED
Update to reflect locations in SVN
Start using Text::Unidecode from converters/p5-Text-Unidecode to handle UTF-8 to ASCII conversion.
Better handle file translating
turn off debug
remove code not required in prod
add p5-Email-Mime
Update to use MIME ports
Update our list of things we need.
Do not syslog messages about the queues. We cover that now via Nagios
Provide better debugging messages
Add rewrite of commit.php
Add a couple more things for the update
Add / to the db root prefixes
Add
Update to full pathes
Update to full paths
Fix the FRESHPORTS_PORTS_TREE_PREFIX to be ports/head
Moving to full pathnames, including repo, on commits
HTML nits - don't embed <br> in <li> for UPDATING - htmlify the email addresses, now that we might be seeing values like: Dan Langille <dan@langille.org>
Go with exact match when serching for yourself
spell it right
match the results of _FetchFilesNeedingRefresh
Update this for 9.x
Correctly name all columns in the result set
better links
Fix broken url
Correctly reference $IsPort
Add revision
Add in the repo names
- update for storing svn revision in the commit_log table - start doing an svn up on the revision name, not the individual files
Tell us the failure value
Add configuration for https
- remove the unused function GetFreeBSDRepository(), which always returned src. - add GetRevision() so we know the repository revision for this commit
Updates, base on what I had in config.pm
- start using PORTSVN as the PORTSDIR for our local ports tree - this lets us use svn up to grab updates - add a sanity test for CATEGORIES to ensure it contains the primary - category - ^ that is useful for repo copies - UsualPortsTreeLocation is /usr/ports, not /usr - This is because our incoming file names are prefixed with ports/ to - reflect the existing tree structure in our database which was set up when FreeBSD used cvs for the ports tree, not svn as it - now does - start fetching files from svn using svn up - this will be useful for directories involved in repo copies. No more - missing Makefiles on svn mv. - in such cases, the file being fetched will be blank, but the directory is - not.
Be sure to urlencode non-port URLs because they can be tricky.
Add more debugging. Google reported an increase in soft 404 errors Tracked it down to ports deleted before we introduced the ports_categories table. Fixed it by changing the stored procedure Port_ID to use just the element, ports, and categories table, thus ignoring the ports_categories table entirely.
Change the way we look up at Port ID. This was causing problems for some ports, which were deleted before we created the ports_categories table. And thus, have no entries in this table.
Put a Follow Us blurb at the top right corner of the page
Do not do a -w on the perl call
Add another debugging statement Be more explicit on a regex: use .* instead of *
Trim any leading/trailing whitespace in file names
- instead of processing the entire vuln.xlm file, look at each one and compare the checksum. Process only the different ones
- Start using svn cat for fetching files.
- Append to the vuxml.log, don't just overwrite it - inlude some timestamps
Adjust for changes to vuxml_mark_commits... supply a named paramter
- start saving checksum - provide a method for fetching a checksum, based on vid
Adjust for the different format of the SVN tag
- adjust for new approach of updating just the vuln that have changed
- adjust for new approach of updating just the vuln that have changed - this script now just processed one vuln at a time - record the checksum - keep track of whether or not we updated the database so our caller can take action based upon that - add more detailed debugging statements
Add new column to vuxml table for checksum Use this to see if a vuln changes.
Do not show ads if $ShowAds is not set.
Set commits debugging based on the page debugging
When fetching file names, sort them by file name. :)
Sort by by VID not ID.
For SVN commits, be like CVS and link to the log from the full filename
Add helper functions for linking to the SVN repo
Forced commit to correct log message: - When displaying files, provide the appropriate link to SVN when it's an SVN commit
- When displaying files, provide the appropriate link to SVN when it's an
Improve some debugging.
Do not fetch directories. Only files.
Remove ======
Handle the special case of 'ports' directory.
Assume ports repository and adjust the URL so it works...
Assume ports repository and adjust the URL so it works...
Ignore CVSROOT so we don't create a category and fetch it...
Start fetching from SVN, not CVS
Add the script for fetching files from SVN
Remove trail PROPS message Use the correct List-Id for the post-svn-head list
When element_id is null, use null, not a space
Now we know the List Id...
Rename a variable
- prepare for FreeBSD move of post to svn - alter svn processing so it prepends a repository name to all filenames - create process_mail.pm (FreshPorts::ProcessMail) which contains a few - common functions for parsing svn messages - move some functions from process_mail.pl to process_mail.pm - alter process_mail.pl to reference FreshPorts::ProcessMail - GetOS_RepoPrefix() is the function that gets the repo name - while here, remove process_cvs_mail.pl & process_svn_mail.pl which were deprecated by respective .pm files some time ago
Performance on vuln lookup
Correct the calculations of vulnerabilities by not using ports_vulnerable table. That's what we're setting up now. Don't use it.
If a given field is undefined, use '' instead.
Use the new FreshPorts::CommitterOptIn::GetErrorCount() function
Better comment regarding the main loop
Enhance an existing debugging message
Add GetErrorCount()
Correct a flag mentioned in usage statement
- better format a call to FreshPorts::CommitterOptIn::RecordErrorDetails() - add missing DEPENDS as a sanity test failure - add more debugging related to depends evaluation - in sanity test failures, mention DEPENDS that cannot be translated to a - dependency
Whitespace adjustment
Check for OFFLINE
Correctly spell the table name.
Fix, thanks to crees
Convert /./ to / in pathnames
More debugging output
Do for _RecordPortFilesTouchedByThatCommit() what we just did for _CompileListOfPorts()
Avoid a situation where a file at the category level is mistaken for a port. See 201205251025.q4PAPOvV092118@repoman.freebsd.org
Add more debugging information. This stemed from 201205251025.q4PAPOvV092118@repoman.freebsd.org
Allow for svn doc mailing list.
Add script for checking number of ports without entries in the categories table.
Return the HTML, not 1.
Debugging
More comments regarding partial vuln processing
Mention where we'd need to change stuff for partial vuln.xml processing.
whitespace
Add some comments regarding partial processing of vuln.xml based on keeping an MD5 of each vuln
Remove pkg from the list of constants. Issue raised by bapt re ports-mgmt/pkg
Block images
Turn off support for webpage in profile.
Disable debuging code
bouncing.php should always be an absolute URL, not a relative USL.
Make HTML valid
Update copyright year
Don't go deep
Add some RI to commit_log_ports_elements
Add some anti-injection stuff.
Complete broken tag
When rows are deleted from ports_vulnerable, be sure to clear the cache
Remember to clear the ports_vulnerable table when processing
Some commits touch no files. Thus, correctly report the number of files adjusted. This corresponds to a recent change to pulling back a commit (see sp.txt) which now uses LEFT OUTER JOIN
Fix broken SQL. Reported by Ruslan Mahmatkhanov <cvs-src@yandex.ru>
For some commits, there are no files touched. Allow for that in the SQL by using left outer joins If a port cannot be found, raise a notice, not an exception.
Do not die if no files are found. That can happen, say with an svn cp
If no valid expiration date, ignore the supplied value.
Change tab to spaces Put the / in 'quotes' to avoid division.
Add ip_address
Add another list
Add **OBSOLETE** CVS commit messages for the entire tree
Add missing pm
Add logging for failed captcha
stop using http://people.freebsd.org/~fenner/portsurvey/ and start using http://people.freebsd.org/~ehaupt/distilator/ instead
Add in projects
Add CAPTCHA stuff for new users
Some updates for port dependencies.
Introduce, and start using, process_svn_mail.pm for processing SVN commits. This has been in use on svn.freshports.org for quite some time. This change allows freebsd-cvs.sh to invoke process_mail.pl, which decides if this is an email we can process.
Set the value of FetchOK
Add examples of cvs-all, and svn
Update
Have a max depth of 1.
add
Use Required By instead of These ports depend upon this port
Add
Allow long lists of dependents to be compressed via javascript.
Sort by cat/port Suggested by: nox
Be sure to strip the depends before inserting.
Add
Add the stored procedure for PortsDependenciesAdd()
Add
Add port_dependencies
Add permissions for port_dependencies
Display the dependencies sorted by type
Pull dependencies back by type. When pulling them back, pull them back by the right port id.
how about some white space?
remove debugging
Add the upgrade for port_dependencies
Add port_dependencies
Start displaying port dependencies.
Create and use freshports_link_to_port_single()
Remove netscape 6 link... :)
Bump copyright year
Upgrade to new AdSense search code
Display license in search results. Reported by Ruslan Mahmatkhanov <cvs-src@yandex.ru> on 12/24/2010 3:23 PM While here, fix formating of license output to have trailing <br>.
Let's let them archive.
Do not index category pages.
Add FAQ for diff link
Add freshports_Diff_Icon
Provide a link to the diff
Correctly spell license, and correct a bug which prevented license from being correctly picked up. REPORTED BY: Thierry Thomas" <thierry@pompo.net>
Add for Nagios
Fix broken PHP Reported by mike@molinos.ru
Slight tweaks to SQL
Add select, which is needed for the delete WHERE...
Be consistent with syslog calls
Add form for forgotten passwords
Remove reset, we don't need that. Add link to forgotten password
Update copyright years. use preg_match instead of eregi, which is deprecated
add user_password_reset
Add the ability to reset a forgotten password.
use pg_escape_string instead of AddSlashes
Add password reset stuff
Add password token purging
The ability to delete old password tokens
Add.
Document upgrade for license support
Add support for license
Apply htmlentities to output parameters.
Add support for license
Add another test.
Improve a debugging message.
Cater for empty change values
Fix broken search, reported by Bjoern A. Zeeb
Add
remove debugging
set intval() on incoming num
invoke pg_escape_string on vid.
Allow FreeBSD 8
Remove X11BASE
Remove stunnel. We use a VPN now.
Add privacy claim for burst
Set RESTRICTED correctly.
Use the post variable, not a local var.
Check for email address
add warning about @FreeBSD.org
Keep the constants and utilities in there.
Commits to vendor branches slightly differs from normal commits. From Oleksandr Tymoshenko <gonzo@bluezbox.com>
Add new script amended by Oleksandr Tymoshenko (gonzo@)
Add more
Add new graphs
Add link to graphs
Add better handling of cache update for things such as GIDs, UIDs, LEGAL, etc.
No more Google referrers.
Now that we are not using ConvertFilePath, we aren't picking up the Freeze. Fix that.
Put the bracket ( in the right place.
Cast greatest() to ::date
better quoting, to cope with 8.3 strictness
convert to $$ for procedures
Go to $$ quoting
Cast the first arguent to digest(). Under 8.3.3 it seems to need this.
We don't need to use db_escape() any more. DBI does proper PostgreSQL quoting.
Add details for FreeBSD 7. Incorporate changes suggested by koitsu@
Invoke NullIFEmpty on several more port fields.
Use the password hash, not the no-longer-existing password field.
Treat restricted and no_cdrom with special care for NULL
asked -> marked
Put the <big></big> back in for version in the Commit History
Fix a comment - spell output For Commit History, to make it fit on a 1024x768 screen: Put the version in bold, not big. Put everything after the version on a new line
Do not log the SQL, instead log details. So we don't see the password.
Stop using the password field
First step to encrypted passwords
Correctly handle is_interactive to avoid setting that field to ENULL.
Instead of nil for no configuration items, show No options to configure
add ability to search src, not just ports
Add ability to search src tree, not just ports.
Start using NULLIfEmpty()
Remove _NULLIfEmpty() as it is now part of utilities.pm Start using the new location.
Move NULLIfEmpty() here from port.pm
Start escaping stuff going into the port table.
Start escaping the additions to the commit_log table.
Add a few debugging hints
Add db_escape, which escpaes stuff for PostgreSQL, E'stuff'
Add FRESHPORTS_LOG_CACHE_ACTIVITY
By default logging of cache activity is off.
If showconfig is empty, display nil.
For showconfig: - use OPTIONSFILE=/nonexistent - remove LOCALBASE and X11BASE
For showconfig
Add showconfig Use ports.status instead of element.status
Change <i> to <b> instead. add ports.showconfig
Add ports.showconfig
Ready to go
Add ports.showconfig, which will be the output of make showconfig
Add port epoch to the fields selected from the db.
ShowDistFilesSurveyLink => ShowDistfilesSurveyLink lowercase f
Whitespace only
Whitespace changes only.
Use the EVERYTHING statement.
Add the EVERYTHING statement
call freshports_DistFilesSurveyURL()
Add freshports_DistFilesSurveyURL()
Add DISTFILESSURVEYSHOW, new code to follow shortly. Add PORTSMONSHOW, code for which has existed for some time.
Welcome to 2008
Get the pathname right.
When displaying search results, do not set the focus.
Wrong website. :)
Add, incomplete.
ignore OFFLINE
Don't echo the parm. check for valid parm, and if none, echo usage.
Check for OFFLINE
Add support for fp-listen
Add a log message
Remove irrelevant comments Add a full path to the OFFLINE file
Check for OFFLINE
A vhost.conf used when the website is offline
Add a script for taking the website offline for maintenance
I now think ConvertFilePath is wrong. I should not munge the file name like that. Do it at fetch time!
Ooops, the include directory is now outside DOCUMENTROOT. Adjust the path so these pages still work.
Add the number of ports and non-ports in this commit.
Fix display of commits with lots of ports.
Alter the Count() function to return the number of commits.
Better handle failed master-sites-all
Sanity test failure table now has FK with delete cascade, not delete restrict.
Try htmlentities on the code first.
Change the code so a URL containing an & will have the text correctly translated. Add a test for this.
Stop using an array to store all the results and process rows as we get them.
Set the limit to the right value, not a hardcoded 100.
&page -> ?page so that everything after the ? goes into QUERY_STRING
Use REDIRECT_QUERY_STRING instead of REQUEST_URI so we get the page numbers correctly.
whitespace only
Cater for no vulns
Give a proper count of vulns and ports.
Remove
Add link to the new contact.php page move link to blog to the This Site section ditto for forums link
Add
Link to langille.org and news.freshports.org
Add a link to the vuln.xml file so we can do a quick comparison.
Add a new FAQ: why does PORTVERSION differ from top of page to first commit in commit history.
add freshports_VuXML_Link($PackageName, $HasCurrentVulns)
For the skull at the top of the page, link to the vuxml.php?package=
convert the package name to lowercase
Add package= feature so we can list all vulns for a package
Do not redirect to vuxml.org if there is just one vuxml. It is nice to be able to see what FreshPorts has recorded. When displaying all vulns, compare package names in lower case. This will put all different variations of phpMyAdmin together.
Invoke FreshPorts::Utilities::InitSyslog();
Do a better log message
Try syslog
Set the Queue as a configuration item.
We no longer patch
Use the native ports infrastructure instead of own patch MASTERPORT => MASTER_PORT
We no longer patch. The previous patch was to just keep the code instead of abandoning it.
How to patch on the fly.
we no longer patch
We don't patch any more
add ports/Mk/bsd.port.mk
We patch less for a while
No longer needed.
Remove. Covered by other patch: bsd.port.mk.master-slave-patch
Add the repository
Use more constants Fetch files before invoking scripts
Remove inaccurate comments referring to ./process_moved.sh Log more information This script no long fetches the file. That should occur before this script is invoked.
Log more information Use the CVSWEB URL from config.sh
When we can't fetch all the files, report an error and exit the loop.
Add a ConvertFilePath($FilePath) Cater for older commits, without a repository set in the message.
Remove PORTDIR from MASTERPORT. Some ports do this in a wonky way. For example: category | name | master_port --------------+----------------------------------------+----------------------------------------------- graphics | ocaml-lablgl | /usr/home/dan/ports/devel/ocaml-camlidl archivers | ocaml-zip | /usr/home/dan/ports/devel/ocaml-camlidl security | ocaml-cryptgps | /usr/home/dan/ports/devel/ocaml-camlidl x11-toolkits | ocaml-lablgtk | //usr/home/dan/ports/devel/ocaml-camlidl japanese | kinput2-canna+sj3 | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna+sj3+wnn6 | //usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna+sj3+wnn7 | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna+wnn7 | //usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna+wnn6 | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-sj3+wnn7 | //usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-wnn7 | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-freewnn+sj3 | //usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-wnn6 | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna | //usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna+freewnn | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-canna+freewnn+sj3 | //usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-sj3+wnn6 | /usr/home/dan/ports/japanese/kinput2-freewnn/ japanese | kinput2-sj3 | //usr/home/dan/ports/japanese/kinput2-freewnn/ math | spooles-mpich | /usr/home/dan/ports/math/spooles/ science | mpqc-mpich | //usr/home/dan/ports/science/mpqc/ x11-toolkits | fltk-threads | /usr/home/dan/ports/x11-toolkits/fltk/
remember to create scripts-log
Set permissions so watch list counts can be updated on-the-fly.
Add triggers to keep watch list count up to date as people add/change entries to/from their watch lists.
no idea what changed here
Add:
43 18 * * * ${DIR}/cvsup-local-tree
which replaces the old command line version... which started to get ugly
Add
Add FREEBSDCVSUPHOST
One of these compared items may be empty. So add an X so they aren't.
when processing a new category, fetch /www/en/ports/categories Yes, we should use configuration items for these URLS...
Add the master_slave() table, as yet unused. See http://news.freshports.org/2007/10/12/masterslave-relationships/
For freshports_commit_port, invoke element_pathname() such that it does not provide a leading slash in the filename.
remove inaccurate comment
that should be sysutils/bacula-server, not bacula-server.
Add the master port tests
Test via the ports tree
patch with -N
Check that bacula-client is a slave port of bacula-server. We could make this a list of such ports, but that's for future work.
Comment out a debug statement.
Clarify the diagnostic message when a category is not found
Use FreshPorts::Config::Fetch_Retry_Limit and $FreshPorts::Config::Fetch_Sleep_Time
Move the file into the dynamic dir
Handle odd URLs better. At present, http://www.freshports.org/sysutils/bacula-server/things/stuff/ will still show bacula-server. This change prevents such things. The above URL will now return a 404
Add more debuggins
Add a \n
Add the names of the files which receive special processing.
Remove extraneous line
Redirect their ass on http://
Add a bit more sorting criteria to ensure consistent sorts.
Comment out some debug code
Take a better approach when checking for non ASCII files... Don't look for HTML anywhere in the file output. Just look for it at the start of the line.
Do not munge the result value when fetching a file
Provide knobs to set fetch sleep intervals and fetch retries. This should improve handling of network comms problems.
Remove 2nd instance of my declaration.
Better error logging
Add scripts-log
Let's do logger, not echo for these errors.
Remove link to the Design Contest.
Slight changes for Verio
Give a better cvsup example
This should be run whether or not we are OFFLINE Simplify the script.
Add
Add these patches for the ports Mk system
Sanity Test Failures should have a delete cascade, not delete restrict, relationship with commit_log
Oh, we're using the old style of cache file name when flushing the cache. And we aren't finding anything. So the cache is never cleared. This is a problem.
Make the link easier to read for /usr/ports/UPDATING
process_moved.sh, process_updating.sh, and process_vuxml.sh are no longer wrong from crontab.
Start using a DIRLOG for keeping track of what happens
Order by ID, so you need all of one VUXML together.
Start the move to the new CSS layout
This commit was manufactured by cvs2svn to create branch 'DesignContest'.
Ummm, revert previous commit. It messes up commits such as: http://beta.freshsource.org/commit.php?message_id=200707091710.l69HAN45082829@repoman.freebsd.org
Add code to append the repo name to CVSROOT in each commit. Each cvs-all email contains a line of this form: FreeBSD doc repository where doc is the name of the repository. It is important to append the repository name to CVSROOT for any commits to the CVSROOT/ directory.
This commit was manufactured by cvs2svn to create branch 'DesignContest'.
When ordering by date, order by DESC.
Remove use of Date when grabbing stats. Use order by date limit 1 instead.
Get the path into CVSWEB right. Add a missing / for non-port files.
This commit was manufactured by cvs2svn to create branch 'DesignContest'.
Stop logging the URL for every single thing
Use the new ReportErrorEmailNoPrint().
add ReportErrorEmailNoPrint() and alter _ReportErrorHelper() to conditionally print the error message.
White space only
Remove silly syslog call. not really useful.
backout last commit, done in a state of madness.
Log the name of the file being processed...
Now that we are caching files and non ports, be prepared to remove directories etc (e.g. files/patch-*)
CategoryCacheDir should be CacheDir
Add a way to cache non-ports.
Define $PageLinksHTML under all circumstances. log the path being processed here...
In the SQL, refer to commit_log as CL (easier to type). Add a bunch of missing columns, not really used by this type of commit, but useful for commit_record which expects these columns.
use revision, not revision_name
Move to a ports/category-name/port-name caching format
Add caching for non-ports
Fix the ports freeze processing. It seems I broke with a previous commit. Reported by: Benedict Reuschling
invoke SetShowEntireCommit() so we see the entire commit message here.
Add SetShowEntireCommit() Use ShowEntireCommit when deciding whether or not to display the entire commit message.
Add a return NEW to categories_new()
Move back to the main cvsweb site.
plain_text => text_plain
Voting has closed.
no more voting.
No more voting
Remove the hardcoded links to the design contest.
Found a spot where we specify the whole condition. So set $sqlSetAll = true
With soundex, provide a method for setting the whole expression, not just the operator and the RHS of the expression. Add in some more parameter checking
Better set the condition.
AnnouncementsGet() -> AnnouncementsGetPlain()
Fix for IE6
Cater for new field in announcements table: text_plain
Cater for a plain text version of an announcement
Alter the announcements table to have plain text.
Add AnnouncementsGetPlain() Alter AnnouncementsGet() so it does not need an end date
Add other views
Add the other views
Mention the voting in the FreshPorts Design contest.
Add http://www.freshports.org/DesignContestVoting/
Add
Set date
Add
Vote!
Add link to the design contest. Set LastModified to gmt
Add
Done
for the design_results table
Add
Add GetParentID
Start using FRESHPORTS_FREEBSD_CVS_URL While here, output more useful debugging information.
Fixed typo
add FRESHPORTS_FREEBSD_CVS_URL
Add more debugging output
add ~checkout~ to the URL we are fetching. This avoid getting HTML in cvsweb3.
This commit was manufactured by cvs2svn to create branch 'DesignContest'.
Use FRESHPORTS_FREEBSD_CVS_URL
Use the committer as author
also ignore js.php
A better regexp
Add some more tests
Get the debug variable from the right place
./perl -> perl
The most-watched.pl needs to have a path to dynamic, and trailing ; before the }
Include data/time of last ports tree check
Add
Ignore supervise
Move to category/ports/file cache level
Update the cache file structure to category/port/files
ignore config.py
Use freshports_CommitDescriptionPrint(), not freshports_PortDescriptionPrint()
Use parent::, not Parent::
For HTMLify, do the PR processing only in some places.
Add count of file in the ports tree
Add number of files in the ports tree.
<b>Date</b>r - remove the r
Do not htmlify PRs by default
Instructions for daemontools/fp-listen/config.py
Configuration values for www/en/ports/categories
Add code for listen_category_new
add processing for NOTIFY category_new
instructions for adding processing of www/en/ports/categories for fp-listen
Add new event to look for:
insert into listen_for (name, script_name) values ('category_new',
'listen_category_new');
When a new category appears, process the categories file.
Oh, if you find a category that does not exist, that is OK. It just has not been populated yet. No worries.
Add a trail \n to debugging. Mention the file we are creating for www/en/ports/categories processing
Add textproc/p5-Text-CSV_XS as a dependency
Add special processing of www/en/ports/categories
Add a script for updating the category description based upon www/en/ports/categories
For freshports_Commit_Link_Port_URL, use & not & and let the HTMLify occur elsewhere.
remove the failed attempt at & (was &rmp;) for the phorum link
Return a 404 in the hopes that they do not return.
Add trailing newline
Allow for globs.... do it the right way.
Update copyright year.
Fix typo reported by "Marshall Brannan" <nanophenomenon@gmail.com>
Update copyright year Move the commit count to beside the date links. Change reference to today's commit to be latest commits (because commits.php is the latest 100 commits).
This commit was manufactured by cvs2svn to create branch 'DesignContest'.
remove docs index added in error
Redirect from freshports.org to www.freshports.org Add index for /docs
Do not log fetching of flagged commits
Remove bchosting... they aren't online any more and we don't use one of their machines.
Order them right....
Indicate updated vuxlm entries with a *
Order by date, lower(name)
Toggle sense of new for a vuln
Put the * for a modified vuln outside the hyperlink
Mention that * means modified vuln
Put t/f in output for a modified vuln
Put new and more on the same line.
If the vuln is not new, but modified, put a * beside the name.
Remove line left over from merge.
By default, show the ads using PHPPGADS
Remove
Merge from FreshPorts2 to HEAD
Merge from FreshPorts2 to HEAD
Merge from FreshPorts2 to HEAD
Merge to HEAD from FreshPorts2
CLE.revision_name is now returned as revision_name, not revision
Add commit_group and commit_group_contents
Comment out the call to freshports_Commit_Link()
Add entries for the flagged commit icons
Remove one of the links to commit.php Add a link to my-flagged-commits.php
Remove the Watch List functions that should not be here in the first place.
Only display the commit flags if the user is logged in.
Fix the envelope dimensions.
Add permission for commits_flagged
Add graphics for Flagged Commits
Add supporting functions for flagged commits
Add images for flagged commits
DisplayCommit now takes a db handle
DisplayCommit now needs a database handle
Add the displaying of flagged commits
Add this class
Add the class for accessing flagged commits.
Remove extraneous b from before This page created in...
Add SuperNews. Move page generation time to bottom right of page, because of increased length of sponsor list.
Fix HTML nits
Add an ad
Move include outside DOCUMENT ROOT
Do not hardcode the zone and random number for non-javascript ads.
Move include outside the DOCUMENT ROOT
Add count of commits found
Add Count()
revision -> revision_name
move include outside DOCUMENT_ROOT
Move include outside DOCUMENT_ROOT
Move include to the directory above
Add PHPPGADS
Add support for PHPPGADS
Add this, in case php is broken.
Invoke AddSlashes around the parameters of freshports_GetPortID() and report errors via syslog.
If freshports_PortDisplay() cannot display a port, do not exit.
Add a condition for tree searching.
while : is better than while true. From man sh: : A null command that returns a 0 (true) exit value.
while . was not working on 6.2-prerelease Let's use while true instead
$Category->FetchByName now returns zero, not undefined, for an unknown
category.
While here, stop using $Category->{id} and use $Category->id instead.
$Category->FetchByName now returns zero, not undefined, for an unknown category.
For $HTML, do not concatenate to an undefined value.
IsCatgory => IsCategory Set IsCategory true only if we have confirmed that it is actually a valid category.
Returns 0, not an undefined value. It is easier on the logs.
Remove echo and use syslog/die instead.
introduce freshports_Commit_Link_Port_URL(), which gives a plain URL, no HTML.
Use a plain URL link, not HTML
Reorganize so there is only one place invoking port, category, and non-port displays. This should be easier to maintain.
Remove freshports_CategoryByName(), not needed after all!
Add sanity_test_failures
Add changes to element_type
Add element_pathname to elementGet()
Add element_pathname to element_type
Add freshports_CategoryByName() to cater for virtual categories
Oops, we forgot completely about virtual categories. Let's implement them. Later we will come back here and tidy this up, to make the code path cleaner.
Redirect ^/admin/upgrade.php$
Redirect smarty.php
Update copyright year
news3.php => news.php3
freshports_Commit_URL() => freshports_Commit_Link_Port()
Add some copper mine defense
Add the files.php rewrite
freshports_CommitFilesLink() => freshports_Commit_Link_Port()
Go to a better method of parsing the URL. This copes better with pagination.
Introduce paging
This functionality now resides within classes/files.php
Remove references to files.php, no longer used.
Make wider use of constants.
Link only to the port, not to the category.
Add trailing ?> to file Change <? to <?php
> function freshports_Commit_Link_Port($MessageID, $Category, $Port) {
>
> $HTML = '<a href="/commit.php?category=' . $Category . '&port='
. $Port . '&files=yes&message_id=' . $MessageID . '">';
> $HTML .= freshports_Files_Icon();
> $HTML .= '</a>';
>
> return $HTML;
> }
>
1115,1123d1124
< function freshports_CommitFilesLink($MessageID, $Category, $Port) {
<
< $HTML = '<a href="/commit.php?message_id=' . $MessageID .
'&category=' . $Category . '&port=' . $Port . '&files=yes">';
< $HTML .= freshports_Files_Icon();
< $HTML .= '</a>';
<
< return $HTML;
< }
<
cvs
REname freshports_CommitFilesLink() to freshports_Commit_Link_Port() and
nput message_id at the end of the URL. This rearrangement caters to the
Apache mod_rewrite we are doing for files.php, which means QSA puts the
query string at the end:
RewriteRule ^/(.*)/(.*)/files\.php$ /commit.php?category=$1&port=$2&files=yes [R=permanent,QSA]
use the newly created freshports_Commit_URL()
Rename freshports_CommitFilesLink() to freshports_CommitFilesLink()
Rename freshports_CommitFilesLink() to freshports_CommitFilesLink() Prefix the port URL to start with a / and thus be absolute.
Set element_pathname from the return values, not from what was passed in a parameter.
Make sure the GUID are unique. Link to the commit details for this one port, and be unique about it.
Avoid divide by zero
When calculating Daily Stats, put the value into a bigint.
The previous commit was for FreeBSD Diary phorums. This commit actually contains the FreshPorts forums.
Oops, the previous commit was from FreeBSD Diary's forums.php This one is the right one.
Remove these, added in error. They were from FreeBSD Diary.
Add better starting points
base class for displaying files
base class for fetching files associated with a commit
Better handle unknown stype values Log it and die if we get something we don't recognize
Turn off caching. One day, this will be a tunable.
When removing items from the cache, we are wildcarding now, so use glob, and delete each matching file.
Add more capacity to the daily_stats_table by using bigint.
Centralize sponsor declaration. Add NYI
element_pathname becomes pathname Add DROP TYPE to make it easier to use this in a script
A better way of showing files. At this URL we can - show no files - show all files - show files for a particular commit
Do not set a width on the poppy cell. Just set nowrap instead. For pagelinks, for page 1, use /, not /&page=1 For showing files, use the new commit.php link.
When ordering by last update, sort by the date value, not the formatted date, which will be alphabetical.
Remove a debugging syslog
Cast our net a little wide for cache entries.
We are still using PHP4. __construct is available only in PHP5.
Remove commented out phpinfo() Set Cache pagesize
Add PageSizeSet()
use the supplied LIMIT and OFFSET
Add Stats_DatabaseSize Order output by good stuff.
Add details for page_size and database size
Update copyright year. Give Debug an initial value. Sort the output to give consistent results.
Modifications for handling pagination. Not sure this will work for all types of commits, especially for those involving MOVED
Default the page_size to User->page_size Start using ../classes/page_options.php
Start using ../classes/page_options.php
Add two new parameters to freshports_PortCommits(): $PageNumber, $NumCommitsPerPage Add pagination to freshports_PortCommits()
Add page sizes
Start pagination.
Update copyright year.
Add ?> to end of file.
Add Count(), LIMIT() and OFFSET() FetchInitialize now uses LIMIT and OFFSET. Better error reporting, only to syslog().
Add PageNum and PageSize to the cache parameters.
fix broken command
Whitespace only
Use current_database() instead of hardcoding database name.
Add database size
Start using new classes: classes/commits_by_committer.php classes/commits_by_description.php classes/commits_by_tree_location.php
CommitsTreeLocation becomes CommitsByTreeLocation
GetCountCommitsByCommitMessage() becomes GetCountCommits()
Move a lot of the functionality from commits.php into three new classes: commits_by_committer commits_by_description commits_by_tree_location
Use the new FetchByTreePath, which has no arguments.
Add UserIDSet() and TreePathConditionSet() Alter FetchByTreePath() to use these attributes.
Add a debugging switch
Start using classes/display_commit.php
Remove freshports_Commits() This functionality is now provided by classes/commits.php and classes/display_commit.php
Set HTML, don't append to an undefined variable. Return the HTML
Add freshports_commit_regular() and freshports_commit_port() to pull back the right stuff for a given message ID.
Add new feature: SetShowAllPorts() If you want to show all the ports/elements associated with this commit, invoke this function with true. Use revision_name, not revision. Use pathname, not element_pathname.
Some field name changes to be more compatible with display-commit: revision => revision_name Add pathname
Be sure to display all commits here.
Better handling of 'sounds like'
Introduce better debugging and error logging. Add: GetCountPortCommitsByTreeLocation() GetCountCommitsByTreeLocation() FetchByTreePath() FetchByTreePathSrc() For FetchByCommitMessageContents() and GetCountCommitsByCommitMessage(), be more specific in what we are passing in: a condition, not a value.
Better handling of non-port commits
Massive reorganization of the code. I'm sure there will be bugs. Simplify query building by creating arrays of keys and phrases. When searching by 'sounds like', order by the soundex for better results at the top.
Use $PortVersion, not PortVersion
Enable cache removal
Remove entity and the callbacks that invoked it. We are no longer obscuring the HTML.
Lower case some HTML tags
Don't concatenate to an undefined string.
Remove portdetails accidentally added.
Let us lower case a whole bunch of HTML tags.
Remove trailing EOL
That should be "Allow", not "Allows" in the previous commit.
Sort NULL late_update values to the end of the list. Allows sorting by port name
Take only what's in the user's staging area, not the whole staging area. Reported by Christian Ullrich <chris@chrullrich.de>
Be sure to sort the result by date desc, category, port
Turn off debugging
Add Sanity Test Failure upgrade notes
Add permissions for sanity_test_failures
Add Pager for pagination. Lots of room for improvment and consolidation in this code.
Add "starts with" and "ends with" for matching.
Add freshports_SanityTestFailure_Link() and freshports_SanityTestFailure_Icon()
Display the STF icon if the commit failed a ST
Some whitespace changes around PortsFreezeStatus()
Better quoting (' intead of ")
Ensure ShowAds is declared as a GLOBAL
Add a link to the Sanity Test Failures page.
Add sanity test failures
Add the Sanity Test Failure icon
Mention the Sanity Test Failure icon
Start using classes/display_commit.php
Better borders. Fix up HTML nits. Start using classes/display_commit.php
Cater for Sanity Test Failure messages.
Add classes for fetching all Sanity Test Failures and for just one.
Add GetErrors(). Allow others to get the errors already recorded. Added for Sanity Test Failures.
Remove the commit and rollback code. This is now handled by the xml_munge code.
When errors occur, record them in the Sanity Test Failures table
Add sanity_test_failures_id_seq
Add Sanity Test Failures
Add SanityTestFailures(int)
Update copyright year
news => backend
Convert from text_image ads to text ads. Let's see if that increases our revunue.
replace old news feeds with the new ones
Add new table: sanity_test_failures
When the Latest Vulnerabilities cache file is not available, be sure to space nicely.
remove odd echo
Populate element_pathname
Add an S
listen_for takes better names. add a new index to vuxml_names. It was in beta, but not prod, and prod runs slower, or so it seems.
When linking to the vuxml.php page, add ?all to the URL.
Use $_REQUEST instead of $_POST Don't send the $ports parameter to MoveStagingToWatchList(). It is not used in this particular form.
Be singular if there is only one port. Remove the $ports parameter from MoveStagingToWatchList() as it is not used. Start using newly added stored procedure MigrateStagingAreaToWatchList After moving staging area to watch list, clear out the watch list.
Show the Google Referrer only if showing ads. Supply a full path to vuxml.php
Add MigrateStagingAreaToWatchList()
By package is actually by date.
Move the search box up to avoid scrolling. While here, move the vul box up to be just below the new search box location.
*** empty log message ***
Better labelling of links with the Watch Lists box.
RSS validation nits: keep the channel and image URLs the same Keep the content type relative to RSS.
Add redirect for rss/watch-list.php to backend/watch-list.php
Remove the 503 and add a limit of 100.
Include ports_vulnerable when counting as the ports-vulnerable.php page needs to set the condition: PV.current != 0
Include a link to all vulnerabilities when displaying the latest vulns.
Calculate the latest vulnerabilities
Repeat the page links at the bottom of the page.
- Fix a long-standing but only discovered-today bug in freshports_SideBarHTML() where it uses the title instead of the label when we are on the URL in question. - Add A link to the newsfeed directory (/backend/). - Move the link for news.freshports.org to be just under the newsfeed link
Redirect newsfeeds.php to backend/newsfeeds.php
Put a little space above the referrer. That's what the <p>, removed in the previous commit, was for.
Redirect sidebar.php, etc to backend.
Fix up the URLs to point to /backend/
Correct the cache path
Remove unrequired <P>..</P>
Send the number of ports to freshports_ListOfPorts()
Add type="text/javascript" to the script tags.
Add a head section Do not follow links on this page
Add the news redirects
Add pagination. This will affect many pages. Great!
Update copyright year. Whitespace changes only.
Add a new parameters: PortCount. The number of ports returned by the query may be a subset of that in the group. i.e. we may be doing an OFFSET LIMIT query.
Add bit about moved newsfeeds.
Remove the logging. We know it's the deleted ports page that is causing the problems.
Log some URLs so we can find out which one is killing the httpd process.
Moving the newsfeeds
Add pear-Pager
Whitespace only.
When showing all VuXML entries, link to the VUXML website instead of ourselves.
Add a list of vuxml entries by vuln
Output the latest vulnerabilities
Display the lastest vulnerabilities.
Add class for getting latest vuln.
For deleted ports, at least show the name of the package. This can be useful when assigning names to vuxml vuln entries.
urlencode the parameters to PortsMon
Whitespace
Add two hidden options for each port: BypassCache and RefreshCache These two options must be the last on the line and be of the form: RefreshCache=1 Thus, they are mutually exclusve.
Add more debugging code.
levenshtein() takes only a max of 255 characters. Let's be careful with the depends* fields.
Log, do not display, the sql when an error occurs.
Add details for clearing stale cache entries
Replace config.sh.sample with config.py.sample and start using it.
*** empty log message ***
Make sure of Debug_FetchBeforeSavingPort Better formatting of debug information
Convert all whitespace in cagegories to a single space
Add Debug_FetchBeforeSavingPort
Better debugging output
Use last_update instead of lastupdate. The former is a date value, the latter is a text value.
Add a sleep in there when OFFLINE
Ignore log
Better checking for OFFLINE.
Disable caching now that we are using fp-listen
disambiguate status
Do not log.
Add a few things, some not yet used.
- listen_for: events that listening daemons should listen for
- top_answers, top_questions: starting point for polling users on things
- event_types: type of events that can be raised in this database
- events: events that have been raised but not yet processed
- cache_clearing_ports: ports that should be removed from cache, populated
by triggers.
Add permissions for cache_clearing_ports and ports_all
Remove textproc/p5-Text-CSV_XS, which I think we never used. Add databases/py-psycopg for the new fp-listen daemon
Add databases/py-psycopg
Add RCS ID. Correctly specify the cache path Better syslogging. Move to deleting cache entries one by one, and deleting from the cache needed table one by one. Commit after each. Sounds fair to me.
Fix an undefined variable in Fetch().
ignore thise
Add these
Add a logger tag so we know what daemon is logging.
ignore these
Ignore these
Remove fp2migration
Remove freshports-cache
Set Debug before using it. Put element_id in quotes.
Add bookmark to revision for link into CVS. REQUESTED BY: ~cydex@shady.org
Use newly created IsDeleted() If the port has been deleted, do not display installation instructions.
Remove unused IsCurrentPortVulnerable() Add IsDeleted()
Mention that is_primary will be either 't' or 'f'
Do not allow people to watch virtual categories.
Only show active ports
Invoke most-watched.pl on a weekly basis.
Add the most watched ports count for linimon
Give us a PDF version of the tables.
fix some SQL nits
Remove this one too.
Move these away. No longer used.
Add Precedence: bulk
We now fetch just one category page, and it is not HTML. The fetched page actually just calls a stored procedure.
Minimize this script to a SELECT of a stored procedure. This script now saves results to a database table, and does not return HTML.
All insert and delete on category_stats for group www.
Add code for displaying the ascending and descending icons
Add the icons for sorting
The last update field is incorrectly named for sorting. When sorting, include the ascending icon. Perhaps later, we sort up and down.
Correctly use the loop variable $i Make sure to fetch data.
Center the Google referral ad in the left hand column, make that column 160 wide to accomodate the wide skyscraper properly.
When no category stats are available, say so.
Add a method for grapping the categories on your watch list
Add element_pathname permissions for commits group.
Add CategoryStatsUpdate()
Add category_stats Allow the commits user to select from ports_moved and ports_updating_ports_xref
Add element_pathname Remove security_notice
Add IsOnWatchList
Remove OnWatchList. It is not required as the value obtained is already included in the SELECT.
Because we can't watch all categories, add freshports_Watch_Icon_Empty() which displays an empty graphic, just for us. uppercase DEFINE.
Make ShowAds global so the port description ad appears when required.
Allow users to watch categories.
Start using the category_stats table so we can provide watch list status to users.
Move to a smaller image
Add category stats
Correct a trigger name
Add empty images
Add Referrals
We need showads etc to be global
Remove values no longer used.
Allow us to swap between Burst first, then Google, and vice versa.
Remember to clear out the cache when updating a port
Remove leading whitespace Remove unneccessary table start
Move the add/remove to/from watch list to the start of the line, before the port name. Add userid to the freshports_commit() call so we can correctly determine if the port is on a watch list.
Add "on watch list" to freshports_commit()
Add LatestCommitsFiltered and LatestCommitsLargeFiltered. Remove security_notice.
Whitespace only
Be sure not to wrap
Add these temporarily.
Put the space after the ICON, not before, but the watch list icon.
Add link for adding/removing a category to/from a watch list
add creation of element_pathname
Add triggers for maintaining element_pathname
better define the changes
A late check of data. new tables for cross platform and cross arch testing of ports: releases - what releases have we had? archs - what archs do we have? port_status - status of a given port with respect to release and arch add fields to ports table already in production: - is_interactive - only_for_archs - not_for_archs For person watch lists on watch_list, create a token using generate_watch_list_token() For filtering, add new table element_pathname EOF.
For SPOOLING
Nicer description
Introduce a watch list click for adding Categories to your watch list
LOG_ERROR => LOG_ERR Use => User
White space only
When adding/removing things to/from a watch list, don't refer to ports. We can now watch categories.
Fix broken comment
Put the debug SQL into <p></p> so we can see it better.
Remove the security notice table
Remove references to the security_notice table
Put a message into <p></p>
The problems with registration have gone away. Remove this old message. While here, fix up the HTML.
Go from 4 columns to 7 in the output.
Stop using the security_notice table
Add filtering, still very beta. Correctly return the value of the CreateHTML function call.
Correct the comment describing this class. Better display HTML when there is nothing to display.
Use ' not " Add filter
Put some drop shadow on those plus/minus signs.
Specify a zero border on the sum gif
Put the Add/Remove at the start of the line.
Remove the / between the port version and the category
Add new define, CLICKTOADD, so we can be consistent with our messages.
When a fetch fails, die. Leave a nice message.
Move the add/remove icon to just before the port name.
Remove security_notice. We'll do this through VUXML now
Remove FRESHPORTS_TASKS_SECURITY_NOTICE_ADD
Remove these
*** empty log message ***
Add ads.
The SUM icon has had whitespace removed from around it. Therefore, adjust the WIDTH and HEIGHT for that icon here. Start using the new watch add and watch remove icons. Adjust the text accordingly to make more sense.
Keep this original
Use a plus/minus on the watch list add icon. Keep the originals around so we can reference them in the announcement. Keep our original artwork in case we need it later.
The reports of my death have been wrong. Use VUXML instead.
Add link to http://www.vuxml.org/freebsd/ for use by security notification report.
Update the copyright year, while adjusting whitespace only elsewhere
Remove extra whitespace around the image.
Fix an off-by-one bug, discovery of which was prompted by a report from Royce Williams.
Better description of items required, including trailing slashes.
With the recently received file for parsing the categories list, add textproc/p5-Text-CSV_XS which is a dependency for that script.
Reflect the new caching directory, news, etc.
Put a border on the report list, and put NIL in the frequency column if there is no frequency.
Properly use DEFAULT_PAGE_SIZE as the default page size, and define it to be 100. Fewer pages, less page regeneration from the cache, etc.
Move the ad above the page links. This will make caching easier.
Make $ShowAds && $BannerAd global
Display only one banner here.
Rearrange the LHS menus. Put all the watch list stuff into one box.
Update copyright date. Honour $ShowAds && $BannerAd Correct the caching directory
When showing ads, honour $ShowAds && $BannerAd
Correct the condition for showing an ad. Honour $ShowAds as well as $BannerAd.
If the description is null, tell the users something useful instead of a blank line.
Don't obscure mailto.
Try going direct with google. Does this affect the stats?
A bit dated now, but nice to look back at.
Why don't we obscure email addresses any more.
Let's not bother obscuring emails. Any email that's on FreshPorts is already available from other multiple sources.
Check the ElementID when retrieving from Cache.
When doing the rss0.91 feed, do not htmlify the description
Add feed validators links for the RSS feeds
Add a GUID to the feed.
htmlify the < and > in the description
Whitespace changes only. Remove trailing control-m's
For the feed to be valid, the Author field must contain an email address.
The news cache is now under the 'dynamic' directory.
feeds are now dynamic
If we don't quote the NEWSCASHEDIR glob, it works. Nice.
correctly spell cache
Correctly spell cache
Fix the cache name. Should be news.*.xml
Get ready to clear the news cache too
Ignore these files
Add a better news service
First newsfeed engine.
Simplify the removal of items from cache.
There was a caching problem where cache entries were not deleted as expected. This turned out to be a permissions issue. There is code here that will be removed with the next commit. It was just kind of a shame to delete it without committing it.... ;)
Change how we remove from cache. Do it for just the one file. Do an ls before and after.
Correctly handle the extraction of the ElementID from the cache when the user is not logged in.
Get the <title></title> field right by using $category/$port, not the now defunct values $port->category/$port->port. Use $MyPort instead of $port when actually fetching a port.
Reduce database access.
Remove freshports_PortDescription() and freshports_PortDescriptionByPortID()
Change freshports_PortDisplay($db, $port)
to freshports_PortDisplay($db, $category, $port)
The port cache now contains the ElementID
As a result, we need to grab the OnWatchList value in a distinct call.
Let's not do any database accesses until we have to.
Move the Debug statement further up
Add freshports_ConditionalGetUnix() which takes a Unix timestamp. This complements freshports_ConditionalGet() which takes a date/time string. Add freshports_GetElementID() which grabs the ElementID for a category/port. Add freshports_OnWatchList() which tells you how many watch lists an element ID appears on for a given user.
Add two new functions: - Element_ID(category, port) - OnWatchList(UserID, ElementID)
Remove all to better format the output when not all items appear Display all categories, "real" or not, as hyperlinks
Add LastModifiedGet() Set LastModified on Add()
start using CacheDataSet() and CacheDataGet()
We no longer pass in the cache data via a parameter. Now we set it explicity during a function call.
Let's use just one cache file for each port.
Make it easier to follow what's going on here. Put more stuff into a function and make the main code easier to follow.
Add and use Ad_728x90PortDescription()
Add tracking for Phorum Top and Bottom
Put a bigger ad on the bottom.
Add a banner ad here too.
Move to a better way of doing ads.
Move to a better way to do ads.
Move the ad from after the port description to within the port description.
Provide a way to imbed an ad within the port description.
We now use mailman, not majordomo. Update this page accordingly.
Start with the new ad strategy.
Start with the new ad strategy
Add a new ad
fir
*** empty log message ***
Correctly use the return value from FetchAllFiles().
Move the cache clearing code from PortsRefreshed to UpdateEnds.
- Tell observers about UpdateBegins and UpdateEnds - Take note of the return value from FetchAllFiles and do not refresh ports if it fails. - Event if there was a fetch problem, tell the observers that refresh has been completed, so they make take action (in this case, they mark ports as vulnerable)
When using FetchFile(), take note of the return value and propogate it up to our caller.
Add UpdateBegins and UpdateEnds.
cach -> cache
files -> file : go singular.
whitespace only
Set the mask so we get the expected permissions
Save the Ports for later cache flushing. This means we can process the cache removal requests after the transactions have been completed.
Use the new path to cache files, which is a ports-tree-like directory structure. When we pass in CommitLogPorts, it is now category/port string.
When the transaction has been committed, tell the observers.
Add TransactionCommitted Update copyright
Update copyright
If caching fails, report an error.
Update copyright year.
Do not repeat thyself.
Start using ReplaceWatchListToken(). Actually, all the files changed here should start using the cache. Then we'd have to create a new function that reads all the watch list items for the user.
Remove Burst_300x250_table, which appears to be unused.
We don't need to include ourselves.
We don't need Burst in Adsense.
Add a $ for this.
Don't call syslog directly. Invoke _Log instead.
Update the sub net.
Start caching the port details. This should be fast. A simple test of page rendering times went from .220s to .047s
Instead of populating the Watch List add/remove button, put a token in the HTML. This allows us to cache the data and replace it at run time.
Create two different types of caching: Commits, and Details. When removing a cache entry, remove all types (e.g. commits and details)
Update copyright.
Update copyright
Remove the last remnants of freshports_PortDetails()
Be concise with our reason for not displaying lack of packages.
Allow debugging messages to become part of cache.
Always display instructions for building the port Don't display package instructions if the port is Restricted.
Be consistent in the log messages. Prefix each one with 'Cache: '. Expand _CleanKey() and prevent directory stepping: i.e. ..
Improve the logging messages by using CachePort not CachPort. Move to a directory structure that reflects the ports tree: i.e. ports/CATEGORYNAME/PORTNAME Introduce and used _CacheFileName()
update for caching improve formatting to ease copy/paste
Add pkg-descr
include the htmlify code
Strat using port-diplay
Return a proper value for LastModified if there are no matches. Add User as a property. Pass to freshports_ListOfPorts()
Start using port-display instead of freshports_PortDetails
Update copyright dates
add User to the freshports_ListOfPorts parameters
Flush out the code to make it compatible with existing display methods.
Add php4-extensions
Add code for Google Analytics
whitespace only
If the file we get back is not ASCII, tell the committer. Use unlink, not rm.
Give an initial value to $result;
Why doesn't this appear on my watch list?
fix typo: descripion -> description
Add LatestCommitDatePorts(), LatestCommitDate()
Fix problem with cache removal. Only attempt removal if cache entry exists. Use unlink instead of rm. Fix typo: Finsihed => Finished
Note: This list never includes deleted ports.
Remove entries from the cache after refreshing.
For syslog, go from LOG_PID | LOG_PERROR, LOG_LOCAL0 to LOG_PID, LOG_SYSLOG This way, we don't get stuff added to /var/log/httpd-error.log and it goes to /var/log/messages instead.
Add FetchByCommitMessageContents() and GetCountCommitsByCommitMessage()
Use fwrite instead of fputs (they are aliases). Check the results of frwite. Do an fclose on the spool file before moving it into the cache. Do an fclose if the write fails chmod the file to be 664 so the perl scripts can remove it For spool file names, use tempname to avoid collisions.
Remove an extra -V some whitespace changes
Go case-insensitive.
Fix the caching path
Make it obvious that you're searching FreshPorts, not the web.
Add some ability to remove ports from the cache.
Improve and correct some of the logging.
First pass of caching. Start storing up HTML instead of doing an echo.
Change functions related to commit history. We want them to return HTML instead of doing an echo.
freshports_UpdatingOutput now returns HTML, and does not do an echo.
Update freshports_UpdatingOutput to return HTMl, not echo.
Add some logging fix some syntax errors
whitespace only
The first draft, pretty much untested, of caching code.
Fix some uploading problems when using copy/paste. This code could use some consoliation and clean up.
Split the process for parsing the data into two parts: - creation of cat/port array - processing of said array This allows us to create a new function that parses a string instead of a file.
HTML nits < => < Update copyright
indicted => indicated thanks to Francisco Reyes <francisco@natserv.com>
Use the FreshPorts Search channel
Update copyright
Update headers
Add searching of commit message Add searching by Google
Add the mini logo
The variable $dbh is not required for commit_record. Remove it.
Let's see if all those 'kernel: pid 47605 (httpd), uid 80: exited on signal 6' messages are related this to URL.
Give this page a title.
Correctly spell $ETag
Whitespace only.
forced commit to note that we now do a case insensitive check on Message-ID
Cater for null timezones
Comment out a syslog
Allow AFFECTS to span multiple lines
Add capability for searching by committer. Fix up the Add LIMIT and OFFSET capability while there.
Display Google AsSense ads right after the port description and before the commits.
Remove unused function: freshports_Search_Depends_Icon()
Add our new search icon.
Forced commit to document changes: Expand the capability to search for related items by just clicking on an icon. Now we can find: - all ports maintained by the maintainer of this port - all commits by this committer - all ports that depend upon this port
Add code for direct support of Google AdSense
Start using new DisplayCommit class. This allows the code for displaying commits to be shared between this module and the search module.
Add a new class for displaying commits
This commit adds support for displaying commits by committer. Allow for LIMIT and OFFSET in the result set. Add new functions: SetLimit() SetOffset() GetCountCommitsByCommitter() GetCountPortCommitsByCommitter() GetCountPortsTouchedByCommitter() FetchByCommitter()
Update to a more complete list of ports that need to be installed
Fix port freeze URL
Update copyright year. Look for pkg_version in the right place on FreeBSD 4 and FreeBSD 6
Update copyright year, standard headers.
Better cater for people without default watch lists
Add FAQ for What is a port and What is a package and link to it from every port.
Better document the difference between adding a port and adding a package. Better divide the output by adding some <HR> Remove an unneeded ; from SQL
fix Port_ID() and put a condition on the ports.category_id field. This avoids duplicates when a port is in more than one category. For example, mail/squirrelmail which is also listed in www.
When OFFLINE, do not process the queue. Otherwise, you wind up with unprocessed files in the RECENT directory.
Add a few more anti-breakage items
Better URL parsing.
Add the test case for a comma immediately following a URL
add freshports_PortDisplay() which takes a $port instance and displays it.
add freshports_PortDescriptionByPortID() which takes a port id, grabs a $port instance,
and then calls freshports_PortDisplay().
freshports_PortDescriptionByPortID($db, $port_id) {
> GLOBAL $TableWidth;
> GLOBAL $FreshPortsTitle;
> GLOBAL $User;
>
> $port = new Port($db);
> $port->FetchByID($port_id, $User->id);
>
> freshports_PortDisplay($db, $port);
> }
>
> function freshports_PortDisplay
Add freshports_GetPortID() which gives you a port id based on a category/port.
if no message id is supplied, complain.
Handle ports that move better. You are given links to the new and port port and that makes it easier to add/remove them.
Add old_new_ports_record, used by WatchListDeletedPorts()
Add WatchListDeletedPorts(bigint) for catering to ports on your watch list which have been deleted from the ports tree Add Port_ID() which gives you the port id for a category/port combination. This function handles virtual cagtegories.
Code to handle ports in your watch list which have been deleted.
Add new function IsCategoryByName() which returns the category id of the supplied name.
Whitespace only.
If the URL ends in a , followed by a space, don't include the comma in the URL.
Put the field name in quotes
For virtual categories, this is the description: This is a virtual category. No description is available.
For virtual categories, give 'no description available'
Make sure the port is active.
New patches
Add RefreshDescription() Cater for non primary categories by setting element_ID to null when no value is provided.
Provide a way to set the cagtegory description from the make files
Set the focus to the query field
Add code for avoiding watch list token collision.
Add this before it gets lost from my laptop
Remove syslog call.
Don't index login.php* and new-user.php*
Allow index.php to be indexed. Don't index new-user.php and login.php
Now that we are using PG8, we need to specify all the tables when we are deleting. So add some USING clauses.
Add www/p5-libwww
In 8.?, you cannot use DELETE in IMMUTABLE or STABLE functions. Such functions must be VOLATILE.
Mention that access rights are important!
Found this problem when using PG8. l_SlavePortCategory and l_SlavePortName must be declared.
A major change. Lots of new ports etc. All a result of installing on the new machine from bchosting.com
Convert to a constant for our background colour. We really should go CSS.
Update copyright to 2006
Remove AnyActiveFiles(). Committed for historical purposes only.
Add AllFilesDeleted() and AnyActiveFiles().
Add a link to the commit.
Use the Ports.date_added, not the commit_log.date_added
Include a link to Yesterday's commits. When showing yesteday's commits, include a linkto the previous date, the next date, and today. This improves over the previous situation which was just Previous Day, Next day.
When displaying dates for lists of commits, use just D, Month. No need to say it was Saturday 2005.
Sort by the raw date, not by the formatted date.
Include the URL into the FreshPorts webserver for each port that had trouble. Provide a bit more space before listing the errors. If notifications are disabled, tell me who the committer was.
Set the refresh flag when a commit is processed.
Handle the sorting options when caching.
remove CACHE_CATEGORIES to categories.php
add a flag for cache refresh
Do better caching of all the options.
If the cache is not available, be sure to provide valid HTML
Start caching the categories.php page
Start caching the categories.php page!
Add a partially completed script for checking that Deleted Ports are deleted and that non-deleted ports are not.
correctly name and locate the file
Moe updates!
Add databases/postgresql74-client
databases/postgresql74-server
sysutils/bacula-client
sysutils/daemontools
databases/mysql41-client
databases/mysql41-server
devel/pear-HTML_Common
devel/pear-HTML_Page2
databases/postgresql-contrib
Use SITE_PERL and do things better
Add newsfeeds.php, and refer to http://news.freshports.org/
Turn off debugging
Move from category/pkg/COMMENT to make -V COMMENT.
remove leading .
Make the poppy box centered and fixed width
Set is_interactive
Add this file
Add is interactive
Add is interacgtive
Add is_interactive
*** empty log message ***
add is interactive
add is_interactive
PHP nit
remove unused code
PHP nite
PHP nits
Add personal watch lists and is_interactive
Add three new columns to the ports table: is_interactive only_for_archs not_for_archs
Display the URLs for the personal news feed if they are logged in. Display the personal news feed content if they supply a valid token.
Do not echo the SQL
Ensure portepoch is available.
Add support for personal newsfeeds by using the token field.
Add missing ?> Update copyright
Add missing ?>
Update copyright
Use the right HTML variable
Add stuff for personal watch lists. WOO HOO!
added: is_interactive, only_for_archs, not_for_archs. now also checks for invalid expiration_date.
improve the error logging messages
Set error
Check for odd characters.
Use _REQUEST, not _POST and check for valid numberofdays
Log the SQL
Ask them to ask me for help if problems occur.
Use htmlentities in the HTML
Use AddSlashes in the SQL and htmlentities in the HTML
Use AddSlashes in the SQL and htmlentitie in the HTML
Include the format for the date.
Remove the <pre></pre> tags, which is not RSS compliant.
Look for jobs waiting to be run.
Serialize the processing of all updates
Go to 150, not just 100
whitespace only
Add Last-Modified
Add freshports_IsInt()
Give some variables an initial value Improve some error/debug messages
whitespace only
Add and use $FreshPorts::Config::JobWaiting. This flag is used by fp-daemon.sh to seralize jobs.
AddSlashes to names
Update the link to the Ports Freeze definition.
change the portsmon website to a new cname.
Update portsmon location
Use the correct variable name for expiration_date Properly quote or don't quote the value depending on whether or not it is NULL While here, renumber the numbers so they are sequential.
Correctly quote the category name.
Some better error handling
When calculating last-modified, consider only port commits remove hard-coded date leftover from debugging
use eq not == for strings.
Add an EOF message
Add support for Last-Modified
Provide Auto-Submitted: auto-generated support. Thanks to Donal Diamond <donal.diamond@gmail.com> for the suggestion. See http://www.faqs.org/rfcs/rfc3834.html
When a new commit comes in, part the ports as vulnerable or not.
Fix up the Last_modified() code, which still needs optimization AFAIK
Add GMT_Format()
Remove debugging code
remove debugging code
Add support for Last-Modified
Remove caching from HEADER section of HTML pages Add List-Modified support code.
comment out the logging of Last-Modified etc.
For expired ports, and those about to expire, ignore deleted ports.
Check also for ETag
No longer used
No longer used.
Let's check for If-Modified-Since
Add pre tags
Add these for diagnostics.
Start using new class, freshports_page_expiration_ports
Introducing freshports_page_expiration_ports, a new class for displaying expired ports.
add deprecated
add names for restricted and no_cdrom
Add explanations for expired and expiration.
Fix the page title and page description.
Add expiration date
Add expiration_date
Add expiration date
Add expiration_date
Dropping types
Handle expiration_date
Deal with expiration_date
Add expiration_date
Move the index further down.
Add stats functions for ports.expiration_date
Add expiration date
More about pkg_add and ignore, forbidden, and broken.
Mention that broken, ignored, and forbidden ports are not built by the package cluster. Therefore, pkg_add will not work.
New script
Add expiration_date
Better wording of the UPDATING options.
Add new two links: Show me UPDATING entries Show me only ports with UPDATING entries.
Start using new function freshports_UpdatingOutput()
Add freshports_UpdatingOutput()
Put an absolute URL into the alt link
In maintainer emails, do not include the version, but do include the category.
Do not CC the ports mailing list for maintainer emails. Requested by flz Seconded by Pav
Add comments about doing the file processing after the files have been fetched.
Remove the ====== before and after the call to PeopleWatchingThisPortAlsoWatch() Make PeopleWatchingThisPortAlsoWatch() return an empty string. The overhead on this function can be high.
Use text/xml not application/rss+xml
Change to using another RSS validator
Do the content type in www/news.php, not here.
Put the content type here.
Add image of new copy/paste feature
If there is no maintainer for a port (i.e. MAINTAINER == ports@freebsd.org), indicate that there is no maintainer, and that concerns should be addressed to the ports mailing list.
"Sounding like" is only for the short fields (i.e. "Port Name", "Package Name", "Latest Link", and "Maintainer"). If you try "Sounding like" on any other field, the system will actually use "Containing" instead.
We now use Cwd, not File::ConvertPath
Old messages ids of the form @freshports.org are now @dev.null.freshports.org
Tidy up Phorum stuff.
Reflect changes made to the main site in terms of headers and footers
Add the new ports news feed.
For the latest commits, we remove the outer LIMIT. We already have an inner limit, so that is our boundary.
We now display the most recent commits, not the most recent ports.
remove reference to include/freshports_page_list_ports_vulnerable.php which was neither implemented nor required.
UPPER case some table references add a commented out debugging statement
add Stats_PortCountVulnerable(
Add Stats_PortCountVulnerable()
Add a list of the vulnerable ports
remove references to include/side-bars.php and use freshports_SideBar() instead.
mention scripts/Verify/set-restricted-no-cdrom.pl
Add new ports rss feed.
Add an RSS feed for new ports
Add the new watch icon
Add ports-new.php
BASEIDR => BASEDIR
Use IsSet, not InArray.
Define $HTML before we use it.
We now use Cwd, not File::PathConvert
stop using File::PathConvert, and use Cwd instead
Sort output by date field only
Add blockquote margin. whitespace changes. remove BLOCKQUOTE.code
Don't specify any fonts at all. Let the user decide. Also, remove unneeded PHP.
Change from the old watch image to a new set of eyeglasses.
We no longer use packageexists. Remove it.
Move STYLE to a file.
Better grammar. Mention BSDCan. Remove whitespace.
ports.cdrom should be ports.cd_rom
Remove the file, only if it exists.
Add restricted and no_cdrom fields
A script to set initial values for restricted and no_cdrom fields of the ports table. Does not clear out existing values.
Add restricted and no_cdrom fields to the ports table
Add stats for restricted and no_cdrom ports
Add statistics for restricted and no_cdrom ports
When displaying details of the port, we do not mention vulnerabilities.
Add two more lists of ports by characteristics.
two more entries!
add restricted and no_cdrom
Add images for restricted and no_cdrom
ensure all IMG SRC have border, width, and height. Fix vulnerabity text to refer to present and past vulnernabilities more explicitly.
improve spacing around restricted and no_cdrom
Use a better cdrom image
Add restricted and no_cdrom icons
Add restricted and no_cdrom fields to LatestCommits* functions
Display icons for restricted and no_cdrom fields
add restricted and no_cdrom fields
Use a new restricted image, which has a new size and type. Correct the hyperlinks used for restricted and no_cdrom Rename freshports_NoCDROM_Icon() to freshports_No_CDROM_Icon() to be consistent with the field name. use a cdrom image to indicate no_cdrom. Correct the labels associated with the long form of the RESTRICTED and NO CDROM messages.
For restricted and no_cdrom, do not display the message associated with these fields.
Opps, there's more stuff we much update
What to update when adding a new field to the ports table
Add restricted and no_cdrom
Add restricted and no_cdrom fields
Add vulnerable_current, ports_vulnerable.past to whatever calls we have. Display error text on any errors.
Remove begin_work() and put a my on the ErrorFound.
Put transaction control here Pass the database handle into the XML_Munge object After processing, rollback or commit, as appropriate.
Remove commit/rollback as it's now in xml_munge()
Add Set_Rollback_Needed() and $_RollbackNeeded and return the value from process()
Remove the database connection from this file. It is now supplied with object
creation.
Replace $dbh with $self->{dbh}
Display both the output from the Make command and the error file when an error is detected.
First attempt at putting all the css into a file. Until now, it was in each download from the website. A terrible waste of space.
Add vulnerable_current and vulnerable_past
Start documenting the upgrade process to the latest vuxml stuff
The commits group needs to insert on ports_vulnerable
Remove Deprecated, Ignore, Broken, Forbidden, and New Ports from the Ports box. These were duplicated by entries that appear in the Statistics box.
remove ClearSlavePort (not used)
Comment out some RAISE NOTICE commands
Include instructions for setting up ports_vulnerable
Allow the commit group to access ports_vulnerable and the commit_log_ports_vuxml table
Join with the ports_vulnerable table
Instead of loading all the port vulnerabilities, join with the ports_vulnerable table.
Add an explantion of the faded skull
Add freshports_VuXML_Icon_Faded() and start using port::IsVulnerable() and port::WasVulnerable().
During object creation, set the vuxml list to undef. Remove VulnerabilityCount() and replace it with IsVulnerable() and WasVulnerable()
For the observer object, provide a database handle during creation.
Create the observer object first, then the xml munging object.
(Just because we can)
refer to $class->{dbh}, not $dbh
When ports are refreshed, update the ports_vulnerable table
On PortsRefreshed, supply a new value: CommitLogPorts
Functions to manipulate the ports_vulnerability database.
Whitespace only
Correct a comment
- When moving to using UTC internally (revision 1.79), we changed page_load_summary.date to a timestamp when it should be a date. We now change this back. - Remove commit_log_port_vxuml, added in error. Use the commit_log_ports_vxuml table instead. - Add some indexes on the ports table to speed some queries. - Add the ports_vulnerable table.
Add PortsVulnerabilityCountAdjust() which sets the correct values in the ports_vulnerable table.
whitespace changes only
When dealing with a cancelled vuln, remember to delete the vuln from the database if we are updating in place.
Add DeleteByVID()
Upgrade to the more current icon
Add note that no entry means 1 vuln
Add favicon
Bring up to the new standard of port displaying
Add the ability to set the status of the ports we are looking for. This is mainly for ports-deleted.php
Remember to pull back the ignore field.
Move on up to the freshports_page_ports_list.
Use the description, remove debug reference.
Add setDescription() and getDescription() Reproduce the sort by choices at the bottom of the page.
add getShowCategoryHeaders(). and allow sorting by port name.
Move to the new freshports page rendering style.
Update the copyright year
Add standard copyright headers
Add this for listing ports. Stuff like ports broken, deprecated, ignored, etc.
Add new attribute _debug and functions to set/get it. Add function setDB() Don't automaticaly add a new row and cell to the table. let the caller do that Simlarly, don't close off the last cell/row. Be sure to vertically align the side bar to the top.
Use = not . because the value isn't defined yet.
Add devel/pear-HTML_Page2
Add a FreshPorts page that uses PEAR's HTML/Page2 class. Very nifty.
Define column width for sidebars (value obtained from recently removed file).
Use echo on freshports_SideBar() and freshports_ShowFooter()
Start using return instead of echo. It gives more flexibility. This is being done as part of the move to using PEAR::HTML_Page2.
Instead of including these files, we put them directly into the functions that invoke them.
Use echo on Burst functions
Use echo for Burst ads
Instead of echo, use return for all functions.
Add two new functions: MarkOneCommit() RecordVulnerabilitiesForThisPortVersion()
update_database_vuxml() now takes a whole vuxml structure, not just an ID
Mark vulnerable commits during processing
Add new function MarkVulnerableCommits()
Add two new functions: IsCurrentPortVulnerable() - now just a stub VulnerabilityCount() - returns number of vulnerabilities for this port
Instead of unset($VID), using $VID=array().
Load the vulnerabilities for each port
Use Unset on the array, so we get the proper values.
Add a faded skull, for ports with vulnerabilities, but not in the latest version.
Start using $port->LoadVulnerabilities().
Add new attribute: VuXML_List; And the function to populate it: LoadVulnerabilities()
Remove Notice commands not needed.
divide LatestCommits into LatestCommitsSmall and LatestCommitsLarge which deal with 10 and 100 commits respectively. This dramatically improves the speed.
Allow commits to update vuxml table
Include the page creation time at the bottom of the page.
Start using VUXMLMUTEX
Add vuxml_mutex
Remove unneeded /'s
Add CheckForNoDefaultAndAddToDefault When there are no default watch lists, and the user has opted for 'the default watch list[s]', then when you click on add/remove for a port, no action will be taken. Silently. This at least lets them know.
Add freshports_WatchListCountDefault
Add WatchListCountDefault
whitespace changes only
Die if we don't have any watch list id
Remove unnecessary reset
Start using DISTDIR so that references to SAME come up correctly
Add DISTDIR
Comment out a notice
Handle splits that involve a ,
Indent the RSC data Put a table header on the VuXML list
Replace " in URLs with '
Streamline error handling
Supply the filename as input parameter, not STDIN
When commit is already processed, that's not an error
Display link to list of vuxml entries. Be sure to display latest vuxml updated.
Ensure colspan works.
Fix broken HTML that occurs when no rows are displayed
Whitespace changes only
Fix broken HTML
Remove line left over from merging
Ensure colspan is correct and for call to freshports_MainContentTable
Stuff about document encoding
Create a common method for display the main table and the main content table. Thereby making it easier to display things such as port freeze notifications.
Capture the RCS details of the vuln.xml file
Add the RSC details of the last processed vuln.txt file
Change the style of the Ports Freeze message.
Fix broken html
Use The Place For Ports
Fix broken HTML
Do not call PortsFreezeStatus as it is invoked in the header routines.
Add 2005 copyright
If message processing fails move all files to the retry directory
remove unneeded print messages
Add DateLessThanDate() and RecentlyAdded() both of which use Date::Calc
Add devel/p5-Date-Calc used by vuxml_parsing.pm
Remove commented out code.
Always test before committing. echo should be print
Creat -> Create
Add this package
Echo that we are doing special processing.
How do we get the list of master site?
forced commit. Add FilesFetched
Observer the FilesFetched event. Keep track of whether or not the ports tree infrastructure needs to be patched based up on the files that are in this commit
Forced commit: This file performs any patches needed to the ports tree infrastructure as required by FreshPorts.
backout previous commit, which was whitespace only and in error
Forced commit. Code now notifies observer after files have been fetched.
*** empty log message ***
Grant select on vuxml_{ranges|references} to group www
Add facilities for displaying the vuxml details, useful for debugging and for the VuXML team to verify that all went well.
Cater for both vid and vuln paramters. The latter is for verification. Let the vuxml object do the displaying
Start using port->IsSlave() Add freshports_CheckForOutdatedVulnClaim($commit, $port, $VuXMLList) if the most recent commit for a slave port is marked as vulnerable, and the commit version isn't the same as the port version, let them know that the master port may have been updated, and the port may no longer be vulnerable.
Add entry about slave ports being updated by master ports
Use *_Icon_Link where appropriate.
Remove some debugging code
add IsSlavePort()
Rename update_database to more correctly refer to database_insert
Add a few more fields to the SQL
Convert to using timestamp without timezone in anticipation of going to UTC internally. Add index on commit_log_ports_port_id on commit_log_ports (port_id);
whitespace only
Add vuxml_ranges_vid() Add TITLE to WatchersAlsoWatched()
Order the data by ID, so it retains the original ordering. add print()
*** empty log message ***
Use vuxml_affected_id when retrieving. Add set_id(), set_vuxml_affected_id(), set_name(), and print()
Print packages. comment out debugging code.
Comment out printing
Create a print() routine.
Alter FetchByVID() to take a parameter Add FetchPackages()
Alter to return a bunch of packages not an affects. This makes things conceptually easier.
FetchByVID() now takes the vuln id as a parameter
comment out debugging
Remember to empty out objects before using them again.
Whitespace changes
remove unused shift in empty() Remove unneeded quote in save()
update the SQL keywords
Remove extra comma from UPDATE
add empty() and FetchByVuXMLAffectedID()
Add functions for setting values
Add Empty(), add some whitespace
add fetch by id, and empty()
Add empty()
First attempt at grabbing all package information for a vuxml entry
Add newline to EOF
add FetchByVID
whitespace only
clean up _initialize
remove unnecessary code from _initialize
Allow for updates
Fix broken HTML by adding a = after TITLE
First work towards incremental updates of vuxml instead of wiping the tables and starting from scratch again.
Add FetchByVID() Alter Save() to allow for updates
white space changes only
Put in a toggle for PORTSMON
Add commits.html cache
Do not show PortsMon yet.
Add link to commits.php
take command line parameter numcommits Observer $MaxNumberOfPortsLong
Add commits.php
Set MaxNumberOfPorts to ten. Add $MaxNumberOfPortsLong at 100. Preparation for commits.php
Remove unused usage
We don't use this anymore
We no longer use this.
Add TEXT/hover text to the hyperlinks in the side bar, footer, etc.
Add TITLE / hover text to the hyperlinks
Whitespace only
Improve the Hover text by including the actual FORBIDDEN, BROKEN, DEPRECATED, or IGNORE message. also: Implement links to PORTSMON without actually using it yet....
Mention that using POST makes it easier for us to validate the HTML
Fix broken HTML tag on search results
Add a few missing _Link() items
Include links to the FAQ for most icons, such as freshports_Broken_Icon() by providing a function, freshports_Broken_Icon_Link().
Add link to ports-broken.php
Change <? to <?php Add more detail about the refresh icon.
Better hover on that refresh tag.
Add People Who Watch This Port
Add watch_list_also_watched.php
Add PeopleWatchingThisPortAlsoWatch()
Add also_watched_record
Add some vuxml functions expected to be used when I start optimizing the vuxml process. Add currenttimestamputc() that may be useful when moving to UTC Add WatchersAlsoWatched() to display "People watching this port, also watch".
A bit more detail on the upgrade, completed already.
Let's talk about freebsd software.
remove most 'use lib' as they are unnecessary.
Move the header('Content-type: text/xml'); from news.php to caching-files/news.php
Add a missing question mark.
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
Close the brackets around gthe GLASSES icon
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
No more BurstMediaCode() is needed.
Add permissions for vuxml
Add Will Andrews.
Add new search option
Rearrange the controls to consume less vertical space. Put notes into smaller case.
Let's make this actually update the fields it claims to upgrade
Move details of search fields to the FAQ. At the same time, expand the list.
Use ILIKE instead of lower() when doing case insensitive LIKE Order the code so that it's always depends_build, depends_lib, depends_run. Just so it is consistent. Add depends_all which searches all of the above three terms. Better format the SQL when an error occurs.
Add some tests for ads to local nets Whitespace adjustment
Add searching on depends_{lib|build|run}
Change radio buttons to checkboxes. Search by long description.
Why does the search page use GET and not POST
When using the ?package=PACKAGENAME, and there is more than one port with that package name, redirect them to the search page where the results will be listed.
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
Cater for searching by package
Allow searching by package and by latest link
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
Use package_name, not latest_link when looking up package names
Turn debugging off.
When telling people how to alter their watch lists, include the icons they can click.
Update the number of google pages. Add a proper bookmark.
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
Show the poppy until 12 Nov
Show poppy from 1 Nov to 12 Nov
Provide a new feature: allow the user to specify the watch list at upload time, bypassing the staging area entirely. Credit pav@FreeBSD.org with this idea.
Add CopyStagingToWatchList() to be used for copying directly to watch lists bypassing the staging area.
white space changes only
$HRML should be $HTML
Remove unused $pkg_info from DisplayUploadForm
Add three new fields: no_latest_link no_package package_name
Set Debug to zero. Use the right watch list variable.
use the right dbh variable
Whitespace changes only.
Set the ports.last_commit_id field for those ports that have no such value.
Add the release notes for what we are about to release.
Mention that if the package_add information does not appear, you'll be shown a reason why.
Change <? to <?php.
HTML nits
When displaying the files associated with a commit, always display the full commit message.
Use IsSet($_SERVER['REDIRECT_QUERY_STRING']) instead of In_Array("REDIRECT_QUERY_STRING", $_SERVER)
which appears to fail.
While here, adjust whitespace on a }
Fix broken HTML tags by putting the <br> within the <li></li> tags.
Add missing </b>.
Only display the package if ports.no_package is non-blank. If it is non-blank, say there is no package and give the reason.
Add the vuxml tables
Correctly spell vuxml
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
If we are offline, do nothing.
Put a standard header into the file
Log the things we process. The approvers files is in CVSROOT, not CVSROOT-ports
The file for is processing UPDATING is /dynamic/refresh_updating
Use full path to BaseDir. Include new options we have been missing to date. vuxml, etc
use ' not " Use :: not : for the config package.
Start using the new VuXML class. Display the vuxml desecription. Use a table instead of a list.
Add vuxml class for dealing with the VuXML table.
Update with process_updating.sh and process_vuxml.sh
*** empty log message ***
Play catch up: add UPDATINGFLAGFILE PORTSFREEZEFILE VUXMLFLAGFILE
This file was taken from process_vuxml.pl and will now be the file that just loads the vuxml file into the database. process_vuxml.pl will soon load the file, and mark the commits.
Display 'non port:' before the element name. Fix display so it looks like main pages. The side bars were appearing one cell lower than other pages.
Remove code and use PortsFreezeStatus() instead.
Add PortsFreezeStatus(). Display it on every page.
For non-ports, do not show revision. For non-ports, don't display a lots of things, like forbidden, deprecated, etc.
In FetchInitialize, remove $element_id from the select and use commit_log_elements.element_id instead. This will give us the correct value and correctly name the column as element_id a the same time.
In the function freshports_CommitsFooter, the parameter is not a $port. It is an $element_record. Make it so. In freshports_Commits, use $element_record, not $port, which is undefined.
Assign a value to HTML
Use ORDERBYDESCENDING, not other variants.
If we pass '' to a sub, then invoke a shell script, that is missed as a parameter. So the usage is invoked. Not nice. So use , '"''" instead. While debugging this problem, improve the debugging output.
Initialize $LastVID
Give select permission on vuxml_affected and vuxml_names to group www so www/vuxml.php can work.
Display all the vuxml entries if ?list is supplied
Use explode, not split.
Include portepoch in the fetch
Pass on to the vuxml.org URL if we have just one vuln. If we have multiple vulns, display a list. (not working yet)
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
Mention the master ports...
whitespace only
To take advantage of the new fetch script, without breaking existing code, create FetchFileURL(), and alter FetchFile to pass acceptable parameters.
Become more useful by adding a couple of parameters: URL=$1 - The URL to fetch from. Useful for local testing. SUFFIX=$6 - The suffix to attach to the URL. Useful to specify the repository.
We're pretty good here now. Hopefully it won't take much to complete this.
Put them to the vuxml.org site, for now.
Get rid of unused variables and commented out code.
Remove this file as it will not be used.
I was planning on grabbing the historical epochs for the master sites of slave ports, but that proved to be ugly because historical makefiles do not always parse cleanly.
Start updating commit_log_ports Add some code for extracting PORTEPOCH via make -V, but then comment it out because some old revisions of makefiles do not parse cleanly. Ignore PortEpochs that are variables. We can't use them here.
Add further information about obtaining historical EPOCH values.
If the port never sets PORTEPOCH, it must be set in the MASTERPORT. Detect such situations and display the master port name.
Whitespace only
This is much better.
Consider master ports
A better idea for historical epoch
First commit of this. I think it's soon to change.
Put a div around the footer ad to center it
Rename ads_* to *
use freshports_PackageVersion()
Mention the new revision icon
Add the revision icon. used to link to revision in CVS when displaying files touched by a commit.
Upgrade to the same Burst code as freebsddiary.
Start using the PackageVersion() function. Link to the revision of the file.
Add freshports_Revision_Icon() Start fixing up BurstMedia issues
Perhaps we can solve this in the short term by getting PORTEPOCH right for the ports affected by vuln.
Outline how I think I can get historical PORTEPOCH
Start using epoch
Add epoch
Add port_epoch
use freshports_PackageVersion()
Provide more information about using pkg_version -t
Use the new function freshports_PackageVersion()
standardize header
Start grabbing port epoch
start using new function freshports_PackageVersion()
Add FRESHPORTS_VERSION_EPOCH_JOINER
Introduce new function: freshports_PackageVersion() which creates the package name, based upon PORTVERSION, PORTREVISION, and PORTEPOCH. Alter existing code to use this new function. Fix a problem with MAINTAINER mailto by not obscuring the subject field
Now we are updating the commit_log_ports_vuxml table.
Now we are invoking pkg_version to test versions. Getting closer now!
Instead of doing a subselect, use a JOIN. It's faster. And continues to work if you have multiple ports with the same package name.
We now have all the commits for a given package.
Remove ranges_ from the columes in the vuxml_ranges table. Instead of using version_start, use version1, etc
Change the column order to op1, version1, op2, version2.
Add vuxml_record
Add FUNCTION vuxml_ranges()
vuxml_ranges.vuxml_name_id becomes vuxml_affected_id.
In vuxml_ranges, rename the fields so they do not contain range_ and _start|_finish.
Add package_version(text, text, text) RETURNS text This function strings together PortVersion, PortRevision, and PortEpoch as they are for a package name.
Add this soon to be completed file
Add the vuxml gif
If there is a ports freeze in effect, say so.
On a file update, invoke FreshPorts::SpecialProcessingFiles::Eat Start handling $FreshPorts::Messages::PortsFreezeCheck
Start processing all the special files
add $FreshPorts::Messages::PortsFreezeCheck
Stop calling FreshPorts::SpecialProcessingFiles::Eat
add shell script which sets PortsFreezeInEffect file
Add the shell script that corresponds to the perl script
Put the right values into the right fields for ranges
Set commit_log_ports.port_epoch
On the insert, use the right field names with the right values.
Handle new field: quoted_port_epoch
More elaboration
More elaboration
First attempt at documenting how we are going to do this
Give initial values to port_epoch
add port_epoch to commit_log_ports rename ports.pkgname to ports.package_name
rename ports.pkgname to package_name
set the newly redefined package_name field
Grab PKGNAMEPREFIX and PKGNAMESUFFIX rename pkgname => package_name
Script to set newly added fields: no_latest_link no_package pkgname portepoch
- is_slave_port text ,
+ master_port text ,
latest_link text ,
+ depends_lib text ,
no_latest_link text ,
no_package text ,
pkgname text ,
+ portepoch
Rename is_slave_port to master_port to reflect what we are actually using in the
database.
Add depends_lib and portepoch.
Add new columns to ports table:
no_latest_link
no_package
pkgname
portepoch
example:
freshports.org=# select no_latest_link, no_package, pkgname, portepoch from ports_active where name = 'dgd-net';
no_latest_link | no_package | pkgname | portepoch
----------------+------------+---------------+-----------
| | dgd-net-1.1.8 | 0
(1 row)
freshports.org=#
Grant select on on VuXML tables
Fix incorrrect html
Add update_database_vuxml_affected and update_database_vuxml_references This completes the database updates for vuxml data.
There is no date_modified column. Remove usage.
There is no date_modified column. Remove usage. We use vuxml_affected_id, not vuxml_id. Change it.
put the -w back in
Start updating the database
Pass in database handle
Include constants Set status
how to process the vuxml changes
Allow invocation like this: (DBHandle => $dbh, Stream => *STDIN) cater for undefined values
The start of using vuxml
First attempt. untested.
Raname package from vuxml-parsing to vuxml_parsing
Add Matthew Seaman's work into the tree. This will be used to parse the vuxml database.
Set the broken field.
Move range_version_start nearer to the top of the table. Now we can see the data like this: range_version_start range_operator_start VERSION and VERSION range_operator_end range_version_end Example: 1.04b <= VERSION and VERSION < 1.06
Alter GetCategoryPortFromLatestLink() to remove RAISE NOTICE debugging messages. Also if more than one match found, return -1, not the count. This makes the return value more useful.
Add these fields to ports: no_latest_link no_package pkgname Add vuxml tables
We have a new deleted icon. Change the size accordingly. Add freshports_VuXML_Icon(). In freshports_PortsMoved, give $HTML an initial value. Start using the classes/commit_log_ports_vuxml table.
Create a new deleted icon, a tombstone.
Add VuXML icon
whitespace changes only
Only work with package if one is supplied.
strip out unmentionables, unprintable characters.
Start using "ISO-8859-1" and not "UTF-8". This fixes the umlaut problems.
Initalize some variables
Fix border accidently changed in last commit.
Fix broken HTML
comment out debugging code
Change to a policy of using the VID, not our internal IDs when linking.
Give an initial values to $VID
How to get a list of VuXML entries for a port
Give initial values to $orderby and $orderbyupdown Use ORDERBYASCENDING not ORDERBYASC Use ORDERBYDESCENDING not ORDERBYDESC
Ensure that id is set before returning from FetchByName()
Ensure that $result is defined in freshports_Parse404URI
dbh is global. define it as such.
define some variables before using them. Put index variables in quotes.
Use local debug variable.
Add searching for packages
Use Searches package for form
add something for package searching
Add class for searching
Page for listing package lookup failures
Add GetCategoryPortFromLatestLink(text)
First attempt at VuXML tables
Move to an Observer/Observable stragegy. This commit requires use of http://search.cpan.org/~cwinters/Class-Observable-1.02/lib/Class/Observable.pm See also this port: http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/70339 For this commit, most of load_xml_into_db.pl was moved to a new file: xml_munge.pm
Add messages for Observer/Observable
whitespace only
Whitespace changes only
add missing ' in debugging message
have one simple queue by default
update copyright year
Add a newline
use the right paths so that reinstalling this port works.
COMMENTify this port
remove @dates, which is no longer used.
Move diagnostics code up into the main loop. Use config.pm for path to ports tree.
add PortsUpdatingPortsXrefAdd
Add permissions for the ports_updating et al table
Use FRESHPORTS_VERSION_REVISION_JOINER
Display entries from /usr/ports/UPDATING
talk about /usr/ports/UPDATING
Introduce freshports_PortsUpdating and include notices from /usr/ports/UPDATING Use FRESHPORTS_VERSION_REVISION_JOINER
Start using AddUpdatingXref
Introducing $FreshPorts::Constants::VERSION_REVISION_JOINER
Use FRESHPORTS_VERSION_REVISION_JOINER
Add FRESHPORTS_VERSION_REVISION_JOINER, as '_' which separates the port version and the port revision.
Welcome to ports_updating and ports_updating_port_xref. A way to display the contents of /usr/ports/UPDATING
Update copyright year
Remove unused variable $file. Remove unnecessary push.
Original code from Travis Campbell. Slightly modified by Dan Langille to work with STDIN and write to database.
remove unused variable
First attempt at displaying entries from /usr/ports/UPDATING which affect a given port.
Fix some HTML nits by using & instead of & Use the Right ALT and TITLE values when calling freshports_Commit_Link Fix a broken tag. Use htmlspecialchars on the port homepage Introduce freshports_Head whereby we can show all the commit message if it's over the limit by just a few lines. Properly define WRAPCOMMITSATCOLUMN
Add constants Add GLOBAL
Change the mime type to text/xml
Handle depends_lib, master_port, and latest_link
Display master/slave information
Handle master/slave relationships
Add latest_link
add missing TR
Ignore vacuum.sh
add depends_lib, master_port, latest_link
Process slave ports when the master port is updated.
Fix typo.
fix copyright fix page title add latest_link
update copyright add latest_list fix page title
update copyright add latest_list
update copyright adjust whitespace remove commented out code
Include latest_link
fix broken HTML
Whitespace adjustments
Set the ignore field of the ports table.
Add ascending/descending to the sorting.
For depends lists, display the list of ports using a function. Display depends_lib
Set User->id to zero instead of ''
document master slave and add the package
Back out the change. The blank line code has been tested in production for some time, but it's not thought to be necessary. The error it is detecting should not occur. It may be better to fail with when this error occurs.
Cater for blank lines. this will be backed out soon.
For a given master port, return all the slave ports.
For each slave port, refresh its values from the master port.
Set the depends_lib field
Add is_slave_port and latest_link to the ports table
This script sets the master_porta and latest_link fields of the ports table.
Add stub for refreshing slave ports.
Add the server name to the refresh URL
<? => <?php
replace ClearSlavePort(int) with ClearSlavePort(text)
add comments
add SetSlavePort(text, text), GetPort(text, text), ClearSlavePort(int)
Allow the date in a commit message to be : or / delimited. e.g. jeh 2001/12/04 05:22:26 PST or jeh 2001-12-04 05:22:26 PST
Allow user to sort output by either category or port (default).
Add special searching for Ports I Maintain
Use cvsup host not xeon host.
remove debugging code which was stopping the reports.
Display security_notice_id white space changes to align columns
Cater for security_notice_id
Display security notice link.
add security_notice_id to freshports_commit result set
Stop using In_array
Add forbidden, deprecated, ignore, and broken.
Add forbidden, deprecated, ignore, and broken.
whitespace only
Whitespace only
Comment out some debugging information.
Better examples
Remove directories no longer used
Catch up with the ports tree and remove this file, now replaced by a COMMENT entry in the Makefile.
Bring up to date with a COMMENT entry.
Alter freshports_commit(text) to take a page size and offset. Add freshports_commit_count_elements(text) which returns the number of rows.
Add paging to the output. This will cater for very large commits (e.g. 3000 ports) which overwhelm PHP.
Remove
Remove this form our tree.
No need to email now
Update the Google page count
Start using ignore
A port can be marked as IGNORE. Start processing that value from the makefile. All makes now use: LOCALBASE=/nonexistentlocal X11BASE=/nonexistentx This will allow ports marked as BROKEN to be queried as if they were being loaded into a empty machine (i.e. no ports installed). Idea from: Oliver Eikemeier <eikemeier@fillmore-labs.com> Brought up by: Thierry Thomas <thierry@pompo.net>
add ignore
Add ignored to the website
Add deprecated and ignore
Better format this output. Group them by Date
remove USERS as it was not used.
For all <category>/<port> pages, do not follow links.
Provide a method for adding nofollow and noindex tags. There is far too much information on FreshPorts for every link to be indexed.
Disallow several more pages
whitespace only
& are appearing as & in the URLs. This should not be so. Correct that.
Correctly state whether or not committer notifications are enabled.
HTML nit
Add link to root directory
add
remove debugging echo.
forced commit to correct previous commit message this script now handles the deprecated field.
Handle hourly stats
Handle the ports.deprecated table
Add a list of deprecated port
handle the new ports.deprecated field
Handle the new port.deprecated field.
What to do when you can't add a port to your watch list.
Add depcreated icon.
do not htmlify announcements. They may already contain HTML. Add deprecated icon.
Now that we have backend/announcements.php, we have no need for announcements.txt
reverse last commit, done in error.
HTML nits
HTML nits
HTML nit
HTML nit
HTML nits
Show the column headings only once
status -> security_notice_status_id
rename status to security_notice_status_id
status -> security_notice_status_id expand information returned by Fetch
status -> security_notice_status_id
security_notice[_audit].status becomes security_notice_status_id
Add some nowraps Remove references to UserAlt, no longer used
upgrade instructions for security_notice*
Populate security_notice_status
Create security_notice_status
Ability to view all security notices.
Define $ShowAnnouncements as global. Define WRAPCOMMITSATCOLUMN if not defined. htmlify the announcement text.
Cater for various states of security notices
Alter SecurityNoticeCreate to take a status field
Add FetchByStatus, GetStatus, and FetchNth.
only include those security notices which are Active.
Only include those security notices which are Active.
Add GetAllActive
Based up on report-notifications.pl, this script does not need to refer to report_frequency because it is run on demand. We refer to security_notice.date_added not commit_log.date_added The next step is to remove all reference to frequency.
fix html
Add OFFLINE example
Add
Start using online
improve reporting, use Online
Improve report
Start using OFFLINE
Start using system_status. delete records more than 7 days old
Cater for IE and pressing ENTER on forms. see http://ppewww.ph.gla.ac.uk/~flavell/www/formquestion.html or http://www.cs.tut.fi/~jkorpela/forms/imagebutton.html
Include a count of the number of ports touched by this commit
Only email the committer if they are opted in
Remove shadow introduced via CONTROL-W
Reflect changes made to .PDM file: - announcements table dates do not have time zone - page_load_summary now has a total and users field
Provide instructions for latest changes to page_load_summary
Rename fields in page_load_summary to make more sense
Remove Chello notice now that Chello are no longer blocking our email.
Correct diagnostic message: User Creation -> User Token Sent
Adjust header and copyright date
If MessageID is not found in the message, say so, and abort.
Better explanations about commit_log_ports_elements
Find a better way to do FUNCTION freshports_commit(text) RETURNS SETOF freshports_commit_record This was taking two minutes for commits such as 200401291613.i0TGD7Wu024303@repoman.freebsd.org
Move the "This message was generated..." phrase to the bottom of the email.
whitespace and cap changes
Security Report ID should be 5, not 6
Add function AnnouncementsGet
Give permission to announcements
Add announcements.pm
Start using FreshPorts::ReportConstants::Footer
whitespace
remove dirname which was unused
remove maxlength and dirname, which were unused
Update copyright. move WatchURL, ReportSubscriptionURL here from various report scripts Create FreshPorts::ReportConstants::Footer
Add more stuff
Remove a syslog call.
Replace the old PostgreSQL logo with the new one Rearrange the logos for better viewing pleasure.
permissions for page_load_summary + page_load_details
For the page_load_summary table, reflect changes in column names and change the way we count things.
In the page_load_summary table: remove defaults for user and non_users rename non_users to total add rendering_time_min and rendering_time_max In the page_load_detail table: split timestamp into two fields: date and time. remove NOT NULL on user_id column
Add entry for daily rendering job
Remove unused code
Script called by cronjob.
Script for creating summary for daily totals.
We don't need to set the search path here.
Add custom functions
Update header, remove commented out code
Add instructions for converting page_load_detail table
in page_load_summary: - rename name to page_name - add rendering_time_min and rendering_time_max in page_load_detail - break timestamp into date and time fields - user_id can be null
update headers
Use LatestCommits in the new fashion.
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.
fix the broken regex for the ports tree
Move comments closed to relevant code
Differentiate between from and to.
Remove NOTIFY commands
Update samples
Fetch all files. Let the called routine validate the files.
Fetch only files within the ports tree.
Better handle the case of no watch lists
Update COPYRIGHTYEARS
use COPYRIGHTYEARS
Start using special processing
special processing for special files
Add more samples
Whitespace adjustement
cronjob
remove unused code empty table before filling it
use chomp
Document Port Moves
Use == not =
Show from and to moves.
Don't include classes/ports_moved.php Include ressurected as an option
Add from and to moves.
Insert the stuff into the database
permission for ports_moved
Display Ports moves details
Add function freshports_PortsMoved which displays a single line for PortsMoved.
Handle ports_moved table
First cut. Needs to start using stored procedure PortsMovedAdd.
Add PortsMovedAdd
Improve the error reporting for corrupted commits.
ports_moved : make from_port_id not null. Add Date, Reason
Allow nulls on ports_moved.{from_port_id|to_port_id}
I suspect from_port_id cannot be NULL, but we'll adjust that later if need be.
Improve the index on page_load_detail Add ports_moved table to reflect /usr/ports/MOVED
Warn them about chello
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.
Use port_revision and port_version, not revision and version.
Refer to it as a freefall login, not a committer id. Fill in the freefall login by default.
Forced commit to fix previous commit message. Track duplicate file names in case of corrupted commit messages.
ignore status.pm
improve error collection
Display the Port name and the error beneath it.
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.
Adjust syslog calls now that we've found a bug.
Correct typo Correct hosting location
Add notes about the apology
Remove freshports.net.adminforum.se.jpg as requested by John Angelmo
Mention the registrar lock
Add two syslogs to track down a problem.
Add a syslog to track down a problem.
Set $PortCount earlier in the code so it always has a value. Be more careful when reseting the array, which may not have a value if the entire page was not sent back to the user.
correct typo
Add link to freebsddiary article
remove outdated comment
Add remaining email
Add this
Add msn.com image
blur the email address
more email
more fraud
remove extra links
fraud
tabs, not spaces.
Cope with freshports.net fraud
fraud
Updates
fraud
Add fraud images
Fix typo provided by Ceri Davies <ceri@FreeBSD.org>
When a new user is created, a watch list is automatically created too. When this is done, ensure the in_service flag is set to true. Otherewise, they can't start adding things to their watch list. See classes/watch_list_element.php::AddToDefault($UserID, $ElementID).
Use _REQUEST instead of _POST. set $error to '' not 0.
Remove some redudant debugging code.
Use $UserID instead of $User->id
If user details cannot be found, remove their cookie and log details.
white space changes (tab align, convert space to tabs etc) remove commented out code
Add code for PR 1234, from Marcin Gryszkalis
Add test for PR 1243
Let's not use $HTML.= anymore. Just echo. It can be 20s faster for 2000 ports 4429 | 2003-11-27 19:16:20.067438 | /watch.php | 1 | 192.168.0.99 | 00:00:52.00862 4427 | 2003-11-27 19:14:24.64815 | /watch.php | 1 | 192.168.0.99 | 00:00:28.657504
Put port count at the top as well as the bottom of the page.
add element_id to the freshports_commit_record data type.
If we don't know what we're adding/removing, then die. Improve debugging information. Remove commented out code.
Do not write to $User->id. Instead, use $UserID.
Some whitespace adjustments Call FetchByElementID instead of FetchByID. And supply UserID.
Supply the UserID when calling FetchByElementID
Mention that some parameters are no longer available.
If there is no message id for file.php, don't do anything.
Remove commit which we don't need.
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
Add a status check on the queues. If anything turns up in the retry queue, let the admin know.
Fix incorrect pkg_info options. Submitted by Lawrence You <lyou@pacbell.net>
Verify that WEBSITEURL is defined.
If the cache file exists, use it. Otherwise, go from scratch.
See www/news.php for more history on this file.
Update the number of google pages.
Save the statistics.
This creates the cache file used by www/index.php
Start using $_SERVER['DOCUMENT_ROOT'] . '/../caching/cache/news.rss
Start using new classes/commit_record.php
Code for displaying the last N commits. Moved here from www/index.php
Remove commit_log_port_elements which has been replaced by commit_log_ports_elements
Add index commit_log_ports_elements_clid on
commit_log_ports_elements (commit_log_id)
Limit the join on commit_log_ports_elements to those commits > latest_commits_ports_anchor()
add cache-refresh.sh
When processing a commit, check to see if the Makefile is there. If it isn't, error out and mention that if this is a repocopy, please ignore this error. While here, put the Makefile pathname into $Makefile, and stop repeating the use of MakefileDirectory/$FreshPorts::Constants::FILE_MAKEFILE
Add the hostname and database name into the mail headers
whitespace
include upgrade instructions
Refresh the cached files
Keep the error message with the port name Always CC the system admin on sanity errors
Improve error reporting by including port/category. Only report the error if the error file is > 0 and the result is zero
Add: WEBSITEURL CACHEDIR STAGINGDIR
remove references to commits_latest.
remember to create commit_log_ports_elements
Add tables for statistics
When displaying the page footer, save the Statistics object away.
Create the new Statistics object whitespace adjustments
Set the database handle for the Statistics object.
Add permissions for page_load_detail table
Add instructions for creating disk caching directories
Functions for saving data on page rendering times
Use an absolute path to the poppy so it works from within the Phorums
On Nov 11, show a poppy
Add a poppy
Fix a typo
Add std headers
use commit_log_ports_elements, not commit_log_ports
Don't store the start position within the form. Leave it on the URL. This allows us to tell the difference between clicking on search (no start specified) and clicking on next page (start will be on the URL).
Give default values to things which must have default values
add create table for commit_log_ports_elements
We now require configuration/freshports.conf.php
Add some missing drop triggers statements.
Fix typo
whitespace
Display the committer email address as an HREF
Add details on how to use formail to load an archive.
find works better with larger numbers of files.
Fix broken email address.
Standardize the php headers Inform the user about beta mailing list.
Cater for both physical and virtual categories.
Cater for virtual categories
Whitespace adjustment Explicity set debugging off
Announce BSDCan
ignore status-config.php
Include instructions for populating commit_log_ports_elements
Remove references to housekeeping which no longer exists
Ignore the backup files
add permissions for commit_log_ports_elements
Replace commit_log_port_extras with commit_log_ports_elements. The function of the table has changed, but the fields are the same.
*** empty log message ***
- Use commit_log_ports_elements instead of commit_log_ports_extra - When creating a new port, be sure to read the details back in after saving. That info is needed later. - fix up the matching of directories and ports so we quote any meta characters in the port name. i.e. \Qpathname\E
Replace commit_log_ports_extra with commit_log_ports_elements. Same concept, but larger scope. This new table cross references a commit to ports and files outside ports.
Start using new commit_log_ports_elements table in order to simply the process of displaying both ports and non-ports on a single page.
Use LatestCommits instead of LastestCommits Use just NumRows instead of both NumRows and numrows.
A little test script for checking if dirA is a subdirectory of dirB.
- remove housekeeping table, no longer used - alter security_notice - remove index on security_notice (commit_log_id) and leave it to the primary key instead. - move indexes on ports_categories (port_id) and ports_categories (category_id) - add commit_log_port_extras
- Adjust FUNCTION LastestCommits(int, int) RETURNS SETOF commit_record to use commit_log_ports_extra. - At the same time, we can remove an extraneous JOIN. - Convert those LEFT OUTER JOINs no longer needed to JOINs.
Any ports tree commit which touches a file not belonging to a port (e.g. ports/INDEX) will result in an entry in this table.
- Because the File structure now contains element_id, be sure to extract it from the where used. - Add _RecordPortsFilesOutsidePorts which will populate the commit_log_ports_extra table.
Include the element_id for the file within the File structure
Include the full path to the port element, without a leading /
Add more tests for <, >, and &
Use htmlify on the links to search.php
Add login counts code
whitespace only
Use User not visitor
By default, set debugging to zero.
backout previous commit
Include the number of users logged in per day
Whitespace adjustment
*** empty log message ***
remove unused variable
The sample status file . configure to suit installation.
A page for viewing the mail queues
Add freshports_commit_record and commit_record
Start using FUNCTION freshports_commit(text) RETURNS SETOF freshports_commit_record
add FUNCTION freshports_commit(text) RETURNS SETOF freshports_commit_record
Add freshports_commit_record, for use by commit.php
Add a ; which was missing from encoded characters.
Fix to make files.php work, the option which displays the files with a port which were touched by a given commit. Look for 'files.php', extract that from the pathname so we can find the element, extract the message id, then call the freshports_Files function. As part of this change, send the REDIRECT_URL instead of the REQUEST_URI to freshports_Parse404URI. < $result = freshports_Parse404URI($_SERVER['REQUEST_URI'], $db); --- > $result = freshports_Parse404URI($_SERVER['REDIRECT_URL'], $db);
Adjust freshports_Files so it takes an element id not a port id
When creating a hyperlink to a port, do not include the version/revision within the link.
Put the version/revision outside of the link to the port/non-port
Add in some missing fields.
Make this work for both port and non-port commits within the port tree.
Add CVS repo link
Add missing EncodingLosses()
Add missing ?>
For the packages URL, use package, not packages-stable. whitespace
Move the old package code with the new package code, which was added to the wrong place. It is now within the IF.
rename PackagesExists to PackageExists
Add freshports_CVS_Icon() Add freshports_CVS_Link Remove GLOBALs and use the defines for CVS and FTP URLs instead Use recently added EncodingLosses() and PackagesExists() functions Instead of referring to Homepage, use Main Web Site, as does the main FreeBSD site Provide a link to the CVSweb for non-port entities
Use FRESHPORTS_FREEBSD_CVS_URL, a define which has replaced a global variable.
Do not include ports prefix when displaying element pathname Provide a link to cvsweb
use EncodingLosses()
Use IsPrimary()
Add PackagesExists()
Add EncodingLosses()
Stop using "if (In_Array(" because it appears to not work
whitespace changes Add EncodingLosses()
add IsPrimary()
add EncodingLosses()
Use define for a couple of constants. Point the FTP URL at a new place for packages.
Add an icon for the CVS link for non-port links
Fix the redirect via origin so we don't get a //
remove unused function freshports_CategoryId
Leave $REQUEST_URI untouched so we can use it later. make use of missing-non-port.php
Display commit information for non-ports
Add recent changes
add IsPort IsCategory elementGet
Add element_type
rename FetchByPartialName to FetchByElementID for use by missing-ort.php
add FetchByElementID
add IsPort and IsCategory
comment out debugging code
We can now display commits for both ports and non-ports.
Remove some commented out code Add functions for displaying commits for non-ports.
Obtain the commits for an element.
Given a pathname, get the element details
Update to latest status
Instructions for keeping the database up to date with the code
Call RecordPortsTreeButNonPortCommits if we have a commit with no ports.
remove #!/usr/bin/perl -w
Remove unused values
Provide a facility for recording commits into the last_commits_ports table which are in the ports tree, but which do not involve a port.
Add element_pathname
Adjust for displaying of non-port port tree commits
Alter FUNCTION LastestCommits(int, int) to cater for non-port port commits. Bring back the full pathname.
Add element_pathname, which will be used for non-port ports tree commits
Add FUNCTION commit_log_ports_insert(int) RETURNS boolean which adds a commit to the latest_commits_ports table
Use TRIGGER instead of "trigger"
whitespace changes
whitespace and text alignment
Remove incorrect package declaration.
Whitespace only
Add FUNCTION LastestCommits(int, int) RETURNS SETOF commit_record
Add a file which contains our data type definitions
Whitespace only
A class for handling the records used on index.php
Start using a function to obtain the results. At the same time, use a class to store the result.
No functionality changes. Just whitespace and better use of existing variables.
First commit
we now use recent not msgs to store the messages processing files
Provide a better method for ensuring duplicates do not arrive in daily_refreshes.
Remove temp files when no longer needed
whitespace changes
remove commented out code
Now that main page update has gone away, we need the ability to refresh the daily summaries. One day, we'll start using it...
Wrap text at 72 for any messages sent by SendEmailNotice
We no longer use these files.
If we encounter an error, stop. Comment out all prints.
If no files are found during a regular GetFiles procedure, try invoking GetFilesImported instead. This will process any file imports.
Give the submit button a name on the front page search form. This will allow it to actually retrieve search results rather than merely populating the form when search.php is displayed.
Trim input from users. No sense having trailing/leading spaces. We trim more fields than we have to, but let's be consistent.
Whitespace changes
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
We don't have a raw directory anymore, but we do have a recent directory.
Add another good test page: /lang/php4/
Our testing file for htmlify
Fix URLs which contain PR references. such as that found at /databases/postgresql7/files.php?message_id=200302062046.h16KkqNv024036@repoman.freebsd.org
Update email address for Marcin Gryszkalis
Remove notice about multiple watch lists.
Whitespace adjustment. When we cannot open Mail::Sender, log the error using LOG_ERR not LOG_NOTICE.
Use the correct number of parameters when calling SendMail.
Change SystemTimeAdjust to be an SQL function.
Remove changes committed in error.
forced commit to fix previous log message. Include the new file in which the HTMLify code now resides.
customize.php
Include the new file in which the HTMLify code now resides.
The HTMLify code is now in another file. Remove it from here, and include it when needed.
Move the HTMLify code into its own file.
Remove "use housekeeping". Remove RefreshMainPage function because we no longer do this.
Triggers should be dropped before they are created.
Lots of whitespace fixes. Record the information which is used during Error Notification. (message subject and message id)
Allow CommitMessageID and CommitMessageSubject to be included in the notification. If Committer Notifications are turned off, don't include the part about why you are getting this message. It'll be going to the system owner, who should know why...
Fix error reporting which failed to correctly report the error.
Add SystemOwnerEmail some minor whitespace changes
Add the latest_commits and latest_commits_ports back in. We need them.
Sort by the table values, not the derived values.
If no files found in a commit, report an error. This was prompted by someone who did a cvs import instead of using addport.
Use `hostname` not `$hostname` to get the hostname.
Change all $UserName references to $User->Name to avoid conflicts with Phorum scripts.
Sort by primary_category as well as port.
Turn off debuggin
When listing ports, retrieve the primary category so that we may properly link to the right port. To remain consistent with category listings, use * to designate ports with a primary category different to that which is being displayed.
Indicate that ports marked with a * actually reside within another category but have this category listed as a secondary category.
If category_looking_at is set, and it's not the primary category, display a * after the port name. This is most useful for category listings. (e.g. http://www.FreshPorts.org/lang/) When displaying "Also listed in", use category_looking_at if it supplied, otherwise, use category. This is also useful on the same page as above.
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).
This file isn't used any more
Add WRAPCOMMITSATCOLUMN
Replace OPAQUE with TRIGGER on functions used as triggers. remember to drop triggers before replacing them: DROP TRIGGER security_notice_audit ON security_notice; DROP TRIGGER ports_ports_categories ON ports;
for ElementTagSet, be sure to check for an existing revision before adding it. For some reason this was removed.
remove: WatchListUserID
RecordLastestPortCommits
RecordLastestCommits
remove: commit_log_ports_insert
commit_log_insert
commit_log_update
WatchListStagingClear should take an int8
Fix HTMLify solution when applied to multi-line situations such as http://www.freshports.org/commit.php?message_id=200206232029.g5NKT1O13181@freefall.freebsd.org
Add note about Virtual categories are not handled
We don't need this in this repo any more. Phorum is now standalone.
We don't need these any more
minor changes to allow phorum headers/footers to work better
add forums.bak.php
things to ignore
Add files required for centralized version of Phorum
ignore blank lines
make element_pathname Pathname_ID stable
disallow commit.php
ignore ? FreshPorts2.PDB cvs server: Diffing . Index: FreshPorts2.pdm =================================================================== RCS file: /home/repositories/freshports-1/database-schema/FreshPorts2.pdm,v retrieving revision 1.71 diff -r1.71 FreshPorts2.pdm 51c51 < -- $Id: FreshPorts2.pdm,v 1.71 2003/05/09 19:39:24 dan Exp $\ --- > -- $Id: FreshPorts2.pdm,v 1.70 2003/05/02 18:37:59 dan Exp $\ 83c83 < 1052505034 --- > 1052509087 [dan@polo:/usr/websites/working-copy.freshports.org/database-schema] $ cd .. [dan@polo:/usr/websites/working-copy.freshports.org] $ cd database-schema [dan@polo:/usr/websites/working-copy.freshports.org/database-schema] $ cvs .ignore ignore FreshPorts2.PDB
remove references to INDEX.db which is not a cvs file
more functions, and add the database schema
This belongs in develop.freshports.org/www/directories
Example FreshPorts database
Fix typo
Details on how to process directories
Show them the way to the phorum
Ignore our testing directories
first commit
Sample archive
Example database
Show our examples
First commit
This is a starting point, should we ever need these files
Remove functions associated with element_pathnames table. This table was experimental and attempted to deal with path parsing issues which would arise with watch lists on FreshSource. We might be able to use these functions at a later date if we allow people to watch a directory.
Add a newline at end of line
Each category has a pkg/COMMENT file which describes that category. When a new category is encountered, if we cannot fetch pkg/COMMENT, then go with a fake description.
When creating a new port, ensure the status is set to Active. This doesn't affect the saving of the port, because a new port is always set Active. It affects code modified in the previous comment which checked the status to determine whether or not to refresh the port.
Wrap all committer messages at column 72. Tidy up the email code to make it easier to read.
Make use of the ability to include a CC: in outgoing email.
Improve the error reporting during sanity testing. I found a case where we got an error such as this: "/usr/home/dan/ports/french/homard/Makefile", line 56: Need an operator (caused by spaces instead of tabs in a section such as do-install:). In such cases, no results are returned from the make command. Instead, the errors will be captured in the tmp file we created to capture ERROUT. Add two new functions: SetActive and SetDeleted.
Include a CC field when mailing out messages. This will allow me to CC myself on any outgoing sanity test errors.
Remove link to bchosting.com because it is now in footer.
Include link to bchosting.com
- remove inactive debugging code - remove commented out code - some whitespace changes
Use IsSet, not InArray for the cookie
Use the small text links rather than graphics for the valid html, rss, and CSS links.
Fix some HTML nits: - Provide a content-type - Specify the script type when declaring Javascript - Optionally provide the commit date, commit time, and committer name Provide link to bchosting.com
PHP nits
remove extra <p>
Remove references to LastChangeLogID. This variable is no longe used.
use the correct database field name: firstlogin not firslogin
Improve handling when no date is supplied. Ensure commits part of the table is as wide as available. Slight cellpadding adjustment to match index.php
Remove debug code Refer to the correct database handle when fetching a commit
Sometimes a port can be deleted in one commit, and a later commit will remove a missed file. If this port is deleted, don't refresh it. If we don't need to refresh it, we don't need to save it.
Add two new functions, IsActive and IsDeleted.
Include the error code in the email
Add the nightly check for unrefreshed ports, including ignored ports. whitespace adjust to keep things pretty.
Remove the temp error collection files when and where we should. Not where we are.
FileName will not be set if there is no trailing slash such as: http://www.freshports.org/security/logcheck
Don't have a border around the Valid RSS image.
Mention that the news.php parameters are optional HTML nits
Add details for newsfeed parameters.
Add new parameters to the URL: - MaxArticles : number of ports to report upon - date : show the commit date - committer : show the committer name - time : show the commit time
Fix more PHP issues
Fix more problems found by PHP notification messages
Remove code no longer used.
fix PHP notice messages
Fix php notice message
Use the same icon as the diary, which faces right, not left...
Use newly added function EmptyTheListCategory instead of EmptyTheList. Let's not clear the entire watch list every time someone adds ports from a category.
Add EmptyTheListCategory which allows us to empty a watch list of all elements in a given category.
Use the terms primary and secondary, instead of real and virtual.
Some ports are in more than one category. The first category listed is the primary category. This must be a physical category (i.e. one which exists in the ports tree on disk). Any other categories are referred to as a secondary category. The others may be either physical or virtual. A category may be in more then one physical directory but will always have exactly one primary category. On this page, indicate ports which list this category as a secondary category.
Don't use get.
Fix an off-by-one error with searching. If start = 1, we don't offset starting at one, we offset starting at zero.
minor corrections to burst media code
correct the URL I just fixed
fix broken css validator links
Add a link to valid RSS
use abstime instead of datetime. This fixes phorum on PostgreSQL 7.3
Fix broken php tags
Add a redirect for news.php
Add descriptions for docs and docs/scripts directory
Add tools for people to create xml from email
Don't overwrite the outpout files....
- Use ports_active, not ports, so we don't have to check if a port has been deleted. Which means we don't need to refer to the element table at all. So remove all that code. - Use tabs to delimit things instead of :
move the raw message into the recent directory instead of the raw directory
Update some things
Allow paging of results Show the parameters in the resulting page. e.g. http://beta.freshports.org/search.php?stype=name&method=match&query=kde&num=10&deleted=excludedeleted&casesensitivity=caseinsensitive&search=1&start=61
Improve handling of email. Send it out, even if previous email has bounced. Log all attempts.
Fix typo and poorly worded sentence. Remove reference to improvements already implemented.
Move the WLC explanation into the "What do these symbols mean?" section.
Start using freshports_WatchListCount_Icon to display the WLC
oops, use the configuration file item instead of hard coding whether or not to show the Watch List Count value.
Add a missing ;
Add watch_list_count
Update the DOCType string
The Watch List Count image
By default, display WatchListCount
start using find because we have too many files...
Remove extraneous remove
We now ignore a refresh once it has been reported. But we can't ignore it forever. Add an option to allow inclusion of ignored refreshes.
Show Announcements
Add ShowWatchListCount
Add WLC info
The default is to show the announcements.
Add code for dislaying announcements using new announcements class.
bit more tuning of the announcement updates
Add WatchlistCount which gives us the number of watch lists upon which this port appears.
Attempt a sort
update copyright notice
comment out some debugging syslog stuff
Update copyright notice
update copyright Create new features which disables user updates when/if necessary.
Update copyright notice
Add copyright notice
*** empty log message ***
Update the copyright notice to 2003
Add link to bchosting
comment out a message
HTML nits
With the move to a flat directory structure, we don't need archive-logs.sh. archive-messages.sh does it all.
Remove control Ms
convert to use a single directory for raw email, xml, xml loading, and errors.
Final amendments
final amendments
Beginnings of announcement maintenance
add FetchNth, FetchAllActive, FetchUpdateID, and GetPopulateValues functions
remove inaccurate comment
whitespace adjustment
Add announcements table
Add Announcements table
Add the announcements table
Removed unused GLOBAL
refer to /login.php instead of login.php
refer to /login.php instead of login.php. whitespace adjustment remove redundant code
Rename the login form to l to avoid conflicting with the search form.
Update GetPortID to treat virtual and physical categories differently.
Use MAILTO instead of $mailto
Use MAILTO instead of $mailto HTML nits
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
HTML nits
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
Add the security notice report to the report table
Fix typo
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
Start using examples from email.pm
Add defaults for email.pm
Do a better sample
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
layout nits
Oops, got the table cells wrong
HTML nits. Because we have two forms, we need to put them into two tables
html nits
HTML nits
fix typos
move element_pathname to after a function it calls
comment out some debugging
Add function, triggers, etc, which were ommitted
Add the announcement
Point to the latest upgrade.
We don't want to use SystemTimeAdjust here...
In Stats_PortCountNewInterval, we shouldn't use SystemTimeAdjust
When totaling categories, use the right formual depending on whether or not it's a virtual category.
When totaling categories, use the right formual depending on whether or not it's a virtual category. Supply a total.
create element_pathname with an optional boolean
Limit URLs to 70 visible characters.
Add new defaults
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
log all changes to the description
More notes
indicate the virtual categories
Add our new announcement
Put a date on this thing before we introduce the new title.
update for the new release
ignore tmp
Add some new fields to the newsfeed and tidy up some formatting
Put copyright years into a DEFINE shorten URLs, the visible portion
Let's bring this up to speed too
Start using latest_commits_ports_anchor
Remove housekeeping calls because we don't need that any more
We use phorum-3.3.2a now
use watch_list.in_service
header updates use watch_list.in_service
Stop using hardcoded user id start using watch_list.in_service
add some debugging and use the right variable name
update header use only in_service watch lists
update header
remove FetchByName
header update
align graphic and text to middle
add users.page_size
Add user.page_size
whitespace
HTML nits
HTML nits
Make for valid HTML
Add the valid css image
Display the watch list name in the title and page header
Let's fetch the data instead of just executing the query
whitespace
HTML nits
use the right email check
some html nits count only the primary categories include a note that the port total is incorrect
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
grant select commit_log_ports_ignore for www
First commit
it's www, not wwww
Add a new switch, AllowUserChanges, which indicates whether or not users are allowed to make changes. This is a system wide switch. The intention is to keep the website running, but disable changes, during an upgrade, etc.
Fix some footers/side bars to use the functions, not the includes...
Add a space before the security notice icon
Add security_notice_audit triggers
Start using SecurityNoticeAudit class
Add SecurityNoticeAudit class
Add security notice links
Use int4 instead of int8 in some places.
header changes
Add a header so 404s are not generated for files.php
whitespace adjustments
remove microtime for start/finish of page rendering
Add valid HTML link
The VALID HTML icon
HTML nits
add commit_log_ports_ignore for commits remove extraneous grant for ports_categories
Let's do nice SQL
remove duplicate trigger and function add missing commit_log_update
Add missing element_pathname which takes a boolean for leading /
Supply the dbname and website URL when emailing out.
move to a better directory structure
Move to a user-independent directory structure
This commit was manufactured by cvs2svn to create tag 'FreshPorts-VuXML'.
things to ignore
Add MAILTO example
fix errors which prevented compare from working. use MAILTO from config file
Add latest_commits table
Allow an optional parameter, n, for the number of commits to return. max 150.
We don't have to update the housekeeping table any more.
start using triggers instead of rules on latest_commits_ports and latest_commits
remove anchor_clid and replace it with latest_commits_anchor and latest_commits_ports_anchor
First commit, set local values here
Add header
Start using config.sh
Use latest_commits_ports_anchor instead of Anchor_CLID
Better handling and reporting of non-fatal errors.
Add ReportErrorEmail and ReportErrorEmail
Add permissions to commits for ports_categories
expland and improve the MAILTO tools.
standard headers
Hmmm, when inserting, the check for old != new will fail, because there is no old.
remove duplicate GetPortID
Add new trigger ports_categories_set
WatchListStagingClear now takes and returns int8 and also renamed WatchListID to UserID to reflect new strategy WatchListStagingLogClearing now takes int8 ports_categories_set is moved to ri.txt as it becomes a trigger
Add optional leading slash to Element_Pathname
turn off debugging
Convert to new commits_latest_ports file add port version/revision add Security Alert flag
check for config file
- let's sort this instead of relying upon default order - tidy up headers
use a variable, not a hard coded constant
move spooling directory one leve down
also ignore config.sh
better use of variables
Update copyrights
A new way of doing the queues
Add the rules for commit_log_ports which keep it populated with new commits. We still have to write the rules to clear out this table from time to time.
By default, do not notify committers of problems. Otherwise we'll have each test system telling them.
Indicate that we need a path to the scripts directory and things aren't always in the home directory any more
Adjust things for Postfix address extentions (i.e. foo+bar@example.org) and to allow procmail to fail softly.
Document
Use this file to set configuration parameters such as the location of the msgs tree and the scripts directory location.
create the retry directory
remove an echo
Move to a better method of message handling. This will allow multiple databases per user and for the processing of multiple incoming cvs-all streams.
Use a different approach to pathnames. This should make it easier for one user to process multiple cvs-all streams.
Avoid a problem which occurs on the day after DST changes: < select (current_date - interval ''1 day'')::date --- > select (current_date - 1)::date While here: whitespace adjustment
Better handle errors when they occur when mastersites
Better handle the lack of a pkg-descr file
catch and report command line flags we don't know about.
improve debugging and avoid undefined values for special conditions.
fix broken tag
Show zero values.
std headers
First commit
Message format has changed. End of files now indicated by ______...
better handling if we don't find the port
fix typo
show the category name
Qualify the GROUP BY fields to satisfy PostgreSQL 7.3 requirements
Ask them to disable auto-responders.
Let's use English here...
add the Security report
change the report id to be the correct value add security_notice to FROM list in SQL better debugging messages
whitespace
remove debugging code
remove trailing ^M
remove references to bchosting by request. They are away for a while..
First commit. Untested.
Add freshports.conf.php remove ? files
fix incorrect references to code definition
remove extraneous code
Add permissions for security_notice_audit and security_notice_audit_id_seq. Adjust permissions on security_notice to be less liberal.
commits_latest_ports is now latest_commits_ports
rename commits_latest_ports to latest_commits_ports
Add security_notice_audit
add trigger on security_notice for security_notice_audit
Start using latest_commits_ports
comment out a debugging statement
doh, we should be loading classes/user_tasks.php Avoid repeated IsTaskAllowed calls by using a variable Allow trusted users to amend the security notice, not just add a new one.
better logging
use query, not sql remove syslog calls - logging now done by stored procedure
std headers
add new stored procedure for security notices.
start using the new stored procedure for security notices.
Add rules for commit_log_ports. Perhaps these should be changed into triggers.
drop the old commits_latest_ports, create the new smaller leaner version
allow www to update categories
PR 251 - columns of user_tasks table should be user_id, task_id
This commit was manufactured by cvs2svn to create tag 'RELEASE-beta- 2003_03_07'.
Allow trusted users to alter description for non-virtual categories.
This commit was manufactured by cvs2svn to create tag 'RELEASE-beta- 2003_03_07'.
start using constants
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
This commit was manufactured by cvs2svn to create tag 'RELEASE-beta- 2003_03_07'.
whitespace only
include the category name in the banner.
Let's not make everyone automatically a super user.
Add CategoryPortCount for category paging
comment out debugging
Better paging links
Set default paging to 50
Allow paging through category contents
PostgreSQL 7.3 changes
Changes for 7.3 compatibility
remove tables no longer used
turn off debugging
make mention of default watch lists
mention that this page operates only on one watch list at a time
add EmptyAllLists
implement empty_all correctly
Add robots.txt
simple debugging change
use _REQUEST instead of _GET oops, we didn't code for remove, just add. when removing elements from the watch list, don't worry if it's not actually there...
Handle the multiple watch lists correctly when fetching a single port
Add GetPortID
Keep the Makefile status the same as it's parent. Do a CREATE OR REPLACE on categories_insert_update add function for user_email_change trigger
use TRIGGER not OPAQUE convert some stuff to upper case
This commit was manufactured by cvs2svn to create tag 'RELEASE-beta- 2003_03_07'.
virtual categories
whitespace
WatchListStagingLogDelete updated for multiple watch lists
add trigger on categories for virtual categories
permissions for ports_categories and commit_log_ports_ignore
Use WatchListID not wlid try some ' instead of "
fix typo
Fix GROUP by because of 7.3 changes
virtual categories: - Allow categories.element_id to be null - create table clp (should be renamed) - create table ports_categories
To populate the new table
module for new table
Whitespace changes
add support for commit_log_ports_ignore
Virtual category support whitespace changes
convert some stuff to upper case, whitespace changes.
virtual categories support
add permissions for commit_log_ports_ignore
define SUPER_USER and USER types
Changes for virtual categories.
Start using the port_categories table
whitespace only
This commit was manufactured by cvs2svn to create tag 'RELEASE-beta- 2003_03_07'.
This commit was manufactured by cvs2svn to create tag 'FreshPorts_2003_05_04'.
fix typo
fix a broken tag
/www/ => /usr/websites/
logs -> log
Let's try some better options here...
whitespace
Let's try some better names for ALT text fields.
HTML validation
rename ports_refresh_ignore to commit_log_ports_ignore
For mainttaining commit_log_ports_ignore
Add new functions to support NeedsRefreshClear
This seems to work now.
Show me the unrefreshed ports.
Name the column to cater for PostgreSQL 7.3 changes
display refresh symbol for unrefreshed ports
whitespace
Include needs_refresh for each commit
Add an optional number of days to go back.
rename ports_refresh_ignore (it was ports_refesh_ignore)
Only fetch files for port tree commits
Let's order by message_id, a business value, rather than commit_log_id, which is something we set.
use FreshPorts not Freshports
fix sorting error
Make sure we display the master sites.
add parameters to display master sites, make commit table header narrower, don't wrap on date column
limit 50
white space
turn off debugging use the categories table
Fix group by problem under 7.3
Start using serial so we can remove the add sequence commands a few other random changes Part of upgrading to PostgreSQL 7.3
Part of upgrade to 7.3 - use "timestamp with time zone" instead of "timestamp"
It seems I deleted a great deal during a previous commit.
Add commits_latest, which seems to have been deleted/omitted.
Some changes, don't know what...
Place removal of pkg directory to be after make command has run. Ignore COMMENTFILE. COMMENT should now always work. remove large unused portion of needs_refrseh for new ports
Align that TD left
Disable debugging.
Display the link to the files in the same place as the version/revision.
We don't always fetch the comment file because now COMMENTFILE and COMMENT both exist.
print the command as part of debugging
remove trailing control-m's
remove trailing control-m's add master sites
chomp the longdescription and mastersites to remove trailing whitespace. whitespace changes.
Start using COMMENT and COMMENTFILE to cope with recent changes
Check sth whitespace
white space changes to SQL
Add names provided by Chuck Rouillard.
Fix broken tag. Remove Control-m
First commit
Turn debugging off
Try doing the join a bit faster.
Add $RejectExternalSearches
Look for external searches and reject them...
Deal with external searchers.
remove pring which was screwing up processing
remove ^M
Adjust quoting to get hostname
in perl, we use 0, not FALSE
Don't commit prematurely
turn autocommit off do the rollback/commit some whitespace changes
handle the temp file better
how about some instructions, for the next time we do this
start using IsTaskAllowed from user class
Add freshports_Tasks_SecurityNoticeAdd
Upon setting security notification, set housekeeping refresh = 2 for ports
Allow housekeeping to be updated from www
whitespace
Don't set message id on retrieve return message id
remove Rename, added in error. add IsTaskAllowed
In commits_latest_ports, add security_notice_id
put a zero border around the security icon
Show the security notice flag
Allow us to add users to tasks
Add this image
remove unused code for start/stop some whitespace changes
add note about the new security icon
Add facility for marking a commit as security related
add Sequence_Security_Notice_ID
add TITLE field to icons added freshports_Security_Icon Added security icon to port description page some whitespace changes
use new portnames
remove old and unused security_notice, security_notice_elements and security_notice_log add tasks and user_tasks start using new security_notice
New class
whitespace
Add FetchByMessageId
Start pulling stuff in from the new security_notice table.
Add new function GetTasks
Use AddSlashes correctly
redo the security notice tables to be more compact rearrange the diagram for printing
fix use of freshports_BannerSpace
use freshports_SideBar() and freshports_ShowFooter() whitespace changes
something wrong here I think, needs to be checked.
use freshports_SideBar() and freshports_ShowFooter()
use freshports_SideBar
whitespace only
use the correct global name
Adjust copyright
fix copyright
Correctly delete all the lists when asked to do so.
Add DeleteAllLists
Correctly count the number of watch lists for a given user.
update copyright
add more help messages
use SetLastWatchListChosen and GetDefaultWatchListID
use wlid instead of watch_list_id
get rid of that double echo
Say if the notifications are disabled
include the database name in the message
Lots of changes to fix errors/warnings found by pressing F4. Add housekeeping.id to explore speed improvements
Add key to housekeeping table.
white space changes only
Add switch for notifying committers
white space changes only
white space changes
add X-header
whitespace changes
PR 235 - WatchList needs to use UserID when deleting items.
Set focus when the page loads
Make this work with multiple watch lists.
use wlid instead of watch_list_id Starting using GetDefaultWatchListID Make this work with multiple watch lists.
use wlid instead of watch_list_id Starting using GetDefaultWatchListID
Use a div instead of a P
Only show ads if we are showing ads.
Change watch_list_id to wlid
Add GetDefaultWatchListID
Add FetchByName
Add SetLastWatchListChosen
Set debug off
Don't use userid
Start using multiple watch lists
remove GetWatchID
Retrieve data based upon category name, not category id.
Add some more meta commands, cache, etc.
Add headers to each mail message.
Use new email function. Put watch list name in subject.
Add a new parameter, Headers.
Replaced by report-notification.pl
white space changes
Fix to work with multiple watch lists per person. Put the frequency and watch list name into the headers.
use echo freshports_ErrorMessage
use echo freshports_ErrorMessage
Fix badly constructed code
Use echo
Check for invalid names
partial changes to checking for legal watch list names
Remove "explain analyze"
lots of whitespace changes rearrange the SQL to improve performance. see http://www.freebsddiary.org/samples/PostgresSQL/ports-new.txt
whitespace changes only
remove freshports_MainWatchID
add: users.watch_list_add_remove users.max_number_watch_lists
Tell people they can have no more than 5 watch lists unless otherwise arranged.
limit watch lists to users.max_number_watch_lists
Use a standard spam filter message
Handle the special case of no subscriptions.
use ' instead of "
use ' instead of " whitespace changes attempt to not wrap date
forced commit to say use ' instead of "
use $_REQUEST use ' instead of " Get it working again
Use $_REQUEST Get it working again.
use ' instead of " use $_REQUEST
use ' instead of " whitespace changes
Convert to new User class use ' instead of "
use ' instead of "
use $_REQUEST
use freshports_PortDescriptionPrint with a limit on output. use ' instead of "
adjust comments
adjust error handling
some whitespace changes Use User class. use " instead of '.
remove WatchListID
Tell them about the multiple watch lists
Some whitespace changes Add _UndeleteResurrectedPorts
add update_status whitespace changes
whitespace changes
Show deleted status fix column wrap
Fix missing ' include constants.pm
Use the constants provided.
whitespace changes Add FreshPorts::Constants::ReportDeletedPorts
more whitespace changes
Whitespace changes
white space changes
use require_once instead of include
use require_once instead of include
use require_once
Use require_once
remove extra COMMIT
Add another note to help the user
uncomment code
Fix typo
Use require_once instead of require
Show which watch lists contain the element
Show all the watch lists and allow the user to select which ones should contain the element.
remove commented out code. Use UserID not User->ID here. 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
Add debugging flag
Add some debugging
use require_once
start using new class User
start using new class User lots of whitespace changes.
Start using new class User
Start using class watch_list_element. Use class User.
use class user
alter freshports_Files to use class User.
Add $WatchListAsk parameters to freshports_Watch_Link_Add and freshports_Watch_Link_Remove. When displaying $port->date_added, show "unknown" as appropriate.
Start using $User class There will be more changes required here to complete this process.
use $User class
Modify freshports_WatchListDDLB to add new optional parameter element_id. Optionally show the number of watch lists upon which the element resides.
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
hide debugging
Add users.watch_list_add_remove
Start using user class for setting watch_list_add_remove
Add the user class. still pretty basic.
Tidy of SQL strings. Make FetchByID work.
Correctly go back to the referrer when Asking. Catch and ignore duplicate entry errors. Display the port details.
include/watch-lists.php
Add IndicateWatchListStatus to freshports_PortDetails
changes for multiple watch lists
Add watch_list.in_service Alter watch_list_staging to use user_id instead of watch_list_id
remove spurious watch_list grant.
rename $commit to $WatchList. add in_service
add in_service
Use $FreshPortsSlogan.
Use $FreshPortsName and $FreshPortsSlogan. Add TITLE to banner logo
use $FreshPortsSlogan
Start using $FreshPortsSlogan and $FreshPortsName. remove extraneous comment which is breaking the RSS.
Start using $FreshPortsSlogan and $FreshPortsName. add TITLE to logo
Hide debugging code behind if ($Debug) Start using freshports_ErrorMessage
Enable for multiple watch lists. Implement the "ask" feature for adding/removing ports.
Put the website name into the logo ALT text. Enable the "ask" feature for adding/removing ports. create freshports_ErrorMessage for displaying errors.
Default to asking about changes.
Optionally indicate default lists with a *
freshports_Watch_Link_Remove and freshports_Watch_Link_Add now take
remove GLOBALs no longer needed while here, whitespace tidy.
More work on multiple watch lists. Still more to go.
Start using UserID and WatchListID where needed
we now need a watch list id when adding removing items improve security by linking the SQL to the USER ID
use freshports_Watch_Link_Remove and freshports_Watch_Link_Add
properly use the ddlb
create freshports_WatchListSelectGoButton and freshports_WatchListDDLBForm
Checkpoint for working with multiple watch lists. Still more work to be done.
No longer abort if we can't find a watch list
Fix the URL
Add insert, delete, update on watch_list
show only the last 20 threads
Add link to how-big-is-it.php
Add notes on how stats are collected.
add TITLE and ALT tags for the graph
Make those headers bigger
Add link to watch-list-maintenance.php
Use require_once Include news.addenda as the first item
Ask for testers
Remove call to BurstMediaCode, which would already be done in freshports.php
Don't show the ads if we're not supposed to.
First commit
Put error messages into a nice fancy box
Redirect if not logged in
Add the class for the WatchList and WatchLists
Add the image and the code for creating the watch list ddlb
Add ddlb with stuff in it for selecting a watch list
Looking good.
Whitespace changes only
We had two Stats_CommitCountPorts; rename one to Stats_CommitCount.
Check for GD compiled in
Add Stats_CommitLogCount
White space changes only
Let's get a little more structured Also start using the daily stats
improve the SQL
Add note about watch_list columns not all being used
Repair comments
repair debug message
Add a link to tomorrow and yesterday
Add a <BR> at the end of the daily links.
Allow an optional text parameter. Do not include a <BR>.
Start using freshports_LinkToDate()
Add a whole new bunch of statistics
Show how many pages are in the website
Let's do the dailysummary in a better way
show how to use the new parameters on index.php
Whitespace changes only
add freshports_IndexFollow
first commit
Updates
use -- for comments, not # in psql scripts.
Start supplying links to daily pages instead of including the daily summary.
improve the error checking and reporting
add a missing ( in a string change " to ' to avoid \@
Check the return value on that message open
Adjust min number of ports to show as 10
add details about index.php parameters and date.php
Add more error checking and assumptions
remove borders used for debugging
tidy things up
Allow num and days parameters to optionally reduce the amount of traffic
Improve the speed of this query
Change the SQL around to greatly improve performance
The first step to caching the data. But I gave up when I realised that doing so will cause problems as things are updated.... Not to mention watch lists.
When displaying a port commit message, show only the first 15 lines, but allow them to click and view the rest.
Display needs_refresh on this screen
If no commits found, say so.
Add side bars
Cater for watch lists
Add watch list catering
Remove debugging code
Create a new commit class and move that functionality there from commits
Add the year to the date
Looking better now.
add FetchNth and _PopulateValues The query needs to be modified to cater for time zones and adjustments thereto.
Has an off-by-one error and the dates needs to be adjusted for the time zone.
First commit
use SendEnc instead of SendLineEnc
add report-notification.pl and report-new-ports.pl
Remove \ from email address
fix debugging
Fix debugging
Add a note about populating element_pathnames
Move element_pathnames to ri.txt from sp.txt
Start using email.pm
Add mail/p5-Mail-Sender
Add mail/p5-Mail-Sender to the list of things FP needs
Start using Mail::Sender
Add element_pathnames
Add committer_notify
Include permissions for element_pathnames
Log changes to users.email
- Make Element_Pathname iscachable - Always insert into system_branch_element_revision when setting a tag - Use a case instead of a COALESCE for system_branch_element_revision
make more use of htmlify and htmlspecialchars
Start using trim_multiple_to_single and trim on depends run and depends build. Perhaps we should do that on other fields as well?
add trim and trim_multiple_to_single
Google is my friend
don't use origin
Convert blank origins to /
Don't use orgin on committer-opt-in.php
Fixed
Start fetching all the files for a commit.
Never fetch files before refreshing all ports touched by this commit (RefreshAllPortsTouchedByCommit)
correct debugging statement
Add hostname to error messages
Add an extra blank line between items
Warn them about fortnightly/weekly reports
try using $revision instead of HEAD
In a comment, rename _GetNeedsRefreshForNewPort to GetNeedsRefreshForNewPort
checklist for upgrading postgresql
Fix broken tags
Add notes about deleting an account and emptying the watch list
use the new PORTCOMMENT features if no pkg-comment file is found
Start using message_id not commit_id as the key for files.php
move and comment out the body printing. That will greatly reduce the log size.
Make note of the notification problem
Uncomment SendWatchNoticePersonal which is a big mistake to comment out.
Move search up higher
Use only www.freshports.org
note about mail header changes
provide the commit_log_id which might just be useful
wrap text at 82, change whitespace formating, and put URL at end of note
Mention that graphs are clickable
This commit was manufactured by cvs2svn to create tag 'beta'.
First import
Standard project directories initialized by cvs2svn.
no more oracle
Ask for oracle 9 help
removed old now unused htmlify code
Use the new htmlify code, not the old stuff.
Allow google. Ignore everyone else.
Don't let robots scan
check report subscriptions
Fix password change
Set result upon error. Perhaps this will stop the duplicate error messages.
get this working properly and add lots of debug
try case insensitive
remove 'new' references
use @ not ? for email address
Warn users to allow incoming mail
Add note about trying to login if you don't get the activation email
add facility to resend a notification
remove unused code
fix bugs associated with watch notice ids and notification periods
link to other-copyrights.php
Add other copyrights
use * instead of a fixed IP address
be more specific about email
be more specific about email
Add note about spam filters
Announce the new report subscription service
Notify if embedded makefile is suspected
Add option to not refresh files on disk useful when getting around build problems
Add announcement report
add link to report-subscriptions.php
Don't show emailsitenotices_yn here any more
adjust headers for new fields
Update to use report-subscriptions table.
report-subscriptions.php now displays description
Show description thereby removing need for show-help.php
PR 183 - show the revision/version obtained from commit_log_ports not that found in ports
display the hostname when reporting
require committer_opt_in
If make -V PORTVERSION fails to return a value, notify the user.
Display the ports which need refreshing
forced checkin to test sendmail delays
Refer to http://mantis.unixthome.org/ instead of /mantis/ as we've moved things about.
first commit
Don't caclulate the cookie when logging in. Use the one already there.
First commit
mention automated nagging mentor
forced commit: why does the email take so long
forced commit: why does the email take so long
change the default IP address
First commit. Ignore vhosts.conf.
add a Location for the /msgs directory
allow for + in email addresses when converting them to links
fix typo
first commit
change final test
add reading to group reading
add group/user reading
Add ReportIDMaintainerNotification for checkaddress.pl
don't hardcode the db name in the error msg
Script for verifying maintainer subcription
show N/A if not displaying frequency
Cater for reports which have no frequency. They are instantaneous reports. This will allow for Fenner reports on ports which do not build.
allow for more URL defaults on searches
Add case sensitivity info to search log
Allow case sensitive searching
Remove debugging code
First commit - this file handles the notification of committers when an error is found with their port
Add permissions for committer opt in
Add committer opt in to the website
change post-commit interval to 1 minute
changes for committer opt-in
cater for error catching when telling committers about errors
Catch errors on the fetch so they don't appear in the .errors file
don't fetch files if you aren't supposed to (debugging tool)\nFirst steps towards committer opt-in
add missing word
Add note that encoding errors can occur anywhere in the commit email message and not just in the log message.
Add revision_name
add a much simplier commits_recent
start distinguishing from a Port and a non-Port refresh
add the vacuum analyze
sorry, that should have been changes for freshsource
latest changes for freshports
Allow commits_recent_ports
last changes
oops, use commits_recent_ports instead of commits_recent
use commits_latest_ports instead of commits_latest, which freshsource will now use.
final changes...
add then, and fix test
fix `
first commit
better handle processing of the log message
Add debugging info for master_sites PR 174: File::PathConvert does not handle // very well
allow + in email address
*** empty log message ***
remove diary_ads_Random and use Burst_468x60_Below instead
stop doing the daemon news ad
First commit
Use the right URL
oops, fix the URL
It's FreshPorts, not freshports
ignore things
Upgrade for sharing
Increase the lag to 10 minutes
Add Adam Herzog
Add missing global to freshports_SideBar
Add bchosting notice
stop using mailto and @ in mail addresses
remove old meeting notice
call it the new ports report
add report_log_latest
Add suggestions from Piet Delport <pjd@303.za.net>
use SystemTimeAdjust
first commit
latest version of report_log_latest
Remove debugging
New results
Make sure we pick up the correct report number.
Add the reporting module
Fix up message and URLs.
uncomment the commit
Remove duplicates by fixing SQL
Check only active elements Send the email notice
First commit
add permission for report_log.id
HTML tidy up.
allow perl scripts to read and log report details
Why show "don't notify me"?
Put the login deflection at the top of the code
make it work for freshports2
When first going to the page, load the values from the db for this user.
permissions for reports
standardize the man header and include the side bars
Let the users try this.
add freshports_ShowFooter and freshports_SideBar
whites space only
first testing attempts
Add skyscraper
Add skyscraper
Start using the Skyscraper ad
Add stuff for displaying bchosting files
Add the BC Hosting skyscraper ads
Add images for comparison
Add a link to search.php from the search box.
Let them talk
default the sorting to be by last update
Ottawa-Carleton Unix Users Group
stats is now in dynamic
searchlog.txt is now in dynamic
remove unneeded stuff
move search log to dynamic
Move status.html to dynamic
get the negation right
If they don't have a watch list id, say so and exit.
use www.freshports.org not migration
spell Calculated
patch from Marcin Gryszkalis to fix axis-labels-issue (in graphs that all values are 1 or 0).
turn off debuggin
Code from Marcin Gryszkalis which adjusts for wider labels
lets try it this way
Send them elsewhere!
Put the port and new count where they can be seen for each message. Add links to the website.
move title to scripts/daily_stats.pl
Add fortnight, weekly, and monthly
Allow for fortnightly and monthly totals
add fortnightly and monthly totals
Announce the site
announce site migration
improve the search logging
create Stats_PortCountNewInterval and modify Stats_PortCountNewToday Stats_PortCountNewYesterday and Stats_PortCountNewThisWeek to use it.
use _FILES["pkg_info"]
Add port count and new port count to message.
Sort by the commit date. Reported by Matador
Fix ur2link provided by Marcin Gryszkalis <mgryszkalis@cerint.pl> to fix http://migration.freshports.org/textproc/cocoon/ commit on 26 May 2002 21:33:43. Thank you.
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
use $_GET
beautify the html
explain a bit more, and add some icons.
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
add link to fp2-announcement.php and adjust white space
use $_SERVER["SERVER_NAME"]
warn them about data loss
warn about making changes
fix it.
Tell the users what to do.
Announce data migration
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
what this all means
Scripts for loading data from FP1 into FP2
Announce data transfers
Tools for converting users from FP1 to FP2.
tools for installing required packages
For setting up the website on a new box
Things to ignore
we need select not update
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
Add daily stats
start using $_SERVER['DOCUMENT_ROOT'] . for PR 158
start using $_SERVER['DOCUMENT_ROOT'] for PR 158
Lots of changes for PR 158 start using $_SERVER['DOCUMENT_ROOT'] .
Use Adjustment for system time
First commit
Add deleted/undeleted option.
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.
allow get to work for searching too
Standardize the date format
Format the data appropriately
format the commit date better.
Add an exact match search and note that searches are case sensitive.
add scripts/hourly_stats.pl
changes for daily_stats
Add daily_stats, daily_stats_data.
Add functions for more stats
this works. previous didn't. don't know why.
start using $_SERVER
move the get above where it is first referenced
Change the titles slightly and links better to ports-new.php
add AddSlashes
Allow for various periods
add FreshPorts::Config::HourlySummaryDir
first commit
Rearrange items and add statistics
Add these in
start using revision
start fetching revision
start using the revision
fetch using a revision
use the defined HEAD
define HEAD
Start using version, but we'll use HEAD for now.
First commit
HTML tweaks. no real changes.
remember to commit
First commit - a cron job for running daily statistics.
Add permissions for daily_stats and daily_stats_data
use $sort = $_GET["sort"];
use _POST
add missing $
use _SERVER
use $visitor = $_COOKIE["visitor"];
oops, use _GET["token"]
use _SERVER
add watchnoticefrequency to _POST variables
start using the _POST variables
use $_SERVER["HTTP_HOST"]
use $_SERVER
use $_SERVER["HTTP_HOST"]
use $method = AddSlashes($_POST["method"]);
use $_POST["search"]
use _POST["variable"]
use $_SERVER["DOCUMENT_ROOT"]
use $_GET["id"]
use $_POST["ports"];
left align port name in the "Port from your watch lists" column.
use $_POST["ports"]
use $_GET["category"]
add missing $
use $_GET["remove"]
use $_COOKIE["visitor"];
use $_COOKIE["visitor"]
Include version+revision in fetched details
Include version+revision in commit history for each commit
use $submit = _POST["submit"]; and $origin = _POST["origin"];
use _POST["<varname>"]
use _SERVER["PHP_SELF"]
$_GET["message_id"]
use _SERVER["REQUEST_URI"]
helpful instructions for restoring a db
use $_SERVER["DOCUMENT_ROOT"]
use _SERVER["DOCUMENT_ROOT"]
Use _SERVER
use _SERVER["DOCUMENT_ROOT"] instead of DOCUMENT_ROOT
Remove tarball, use files.
Add this tarfile.
actually call SendWatchNoticePersonal
general tidy of HTML code
adjust the size of the phorum logo. rearrange things to look better.
change .php3 to .php
When listing ports in a category, supply the watch list id. remove commented-out code
Cater for watch lists correctly on lists of ports.
add NumberOfDays
Add NumberOfDays
Oops, two functions the same.
various mailto improvements
Add NumberOfDays (of past history to show)
Add customizable number of days to show in history Add mailto link for committer
In email to the maintainer, set the cc & subject correctly
also fetch ports.revision
$ShowDateAdded="Y" => $ShowDateAdded="N"
fix display of things we want to be shown
$ShowDateAdded=1 => $ShowDateAdded="Y"
Pull committer from the result set
fix typos
AddSlashes on incoming data. Remove some outdated code.
fix regex for mail regex
Fix the URL for the watch list
removed duplicated AddSlashes
fixed typo. evenshtein should be levenshtein
merge to FreshPorts1 from HEAD
Update copyright
send one message per user
Update date in copyright message
Add index on ports (element_id) Add graphs table
rm _phpgraph as it is not used
We don't use this directory any more
not used in FP 2
Remove mySQL references
grab is_clickable while we have it.
Add labels to graphs Make some graphs clickable and some not
Add labels to graphs Make some graphs clickable and some not
Lets simply the code and make it work with inserts and null parents
Add a trailing slash to the URL
add ports-new.php
minor tweaks for ports-new.php
minor tweaks to cope for ports-news.php
minor tweaks to cope with changes for ports-new.php
All new, based on ports-deleted.php
Add Deleted Ports
Ummm, let's only check parent status if we are dealing with a port here
Delete or activate the parent if a child is modified
First commit
add message_id and encoding_losses, which might be used in some circumstances
Add links to the commit message, original cvs-all message, and to the files touched in this port.
clean this up for production
PR142 - after refreshing a port, queue the date into the daily_refreshes
table so that the daily summaries are updated.
when calling freshports_PortDescriptionPrint, include the URL to use for long commits.
move freshports_MorePortsToShow to here from index.php create freshports_MoreCommitMsgToShow based upon that function create freshports_Head to return only the n lines of a string alter freshports_PortDescriptionPrint optionally show only the first n lines of the string and supply a URL to the full message.
move freshports_MorePortsToShow to include/freshports.php when calling freshports_PortDescriptionPrint, include the URL to use for long commits.
move over comments from freshports.php which should have been moved in a previous commit. add $freshports_CommitMsgMaxNumOfLinesToShow
I have added the FP2 people. so don't say I haven't.
put deleted where it should be deleted.
Fix the map file name
oh, don't show that here!
more permissions
html fixes
remove files not in FP2
html fix
fix syntax
html fixes
html fix
HTML fix
html fix
fix html
html fix
HTML fix
removed. not on branch
html fixes
Let's go back to 100% width tables.
Add a section for FP2
Use $PHP_SELF
Change name to graphs.php
Add disclaimer.
add link to graphs
Use $db not $conn
Put conditions into db connection
put FreshPorts in the title of the cached file.
first commit
Let's put it all together. Looking good for graphs.
html fix
fix HTML
oops, messed that up didn't I. fix table.
First commit
Move Netscape button down.
remove extra </P>
These are the post W3C HTML validation commits
Almost there.
first commit
This commit was manufactured by cvs2svn to create tag 'preW3C_HTML_validation'.
Use our own style stuff.
Add news feeds
let's not use fp-refresh.sh
This commit was manufactured by cvs2svn to create tag 'preW3C_HTML_validation'.
move netscape add button down a bit
Add date/time loaded.
add / to image
Add "Add tab to Netscape 6" button
Add "Add tab to NetScape 6" button.
Call our copyright function
Put the existing copyright into the function and remove the commented out code.
First commit. Used for netscape 6
Used for sidebar.php
use DOCTYPE 4.01 Transitional and call htmlspecialchars
Don't show revision if it is zero
Remove references to the phorum, which is gone.
Mention forgotten logins can be recovered too
Add committer to message
update version
Use onwatchlist not watch
use port-> not myrow[
mention FreeBSD
add links to ocuug
Don't show the description link
slight whitespace changes
Let's use play instead of a bullet for long commits
Use a graphic for the bullet on long commits
Icon tweaking.
Tweak the linking for large ports.
Show only the first 10 ports of a commit. Then link to the commits.php page.
Renamed pr2html to htmlify attribute code
add $ to pr2html functions so "http://example.org" is converted to an HREF
remove extraneous brackets
Add status to ports_all
remove commented out code
Pass watch lists id to call to files.php
Change Refresh icon to Deleted
Add some missing elements to the commit, including watch list support.
new htmlify code remove some TITLE from graphics which are links so the URL appears in the status bar and not the title.
Add some missing fields and standardize date/time format to get encoding_losses running.
add encoding_losses
cater for older xml encodings without EncodingLosses
cast to boolean to cater for default values of 0
tag the file as UTF-9
add EncodingLosses
Add EncodingLosses
add encoding_losses
This commit was manufactured by cvs2svn to create tag 'preW3C_HTML_validation'.
This commit was manufactured by cvs2svn to create tag 'FreshPorts2_Launch'.
Add EncodingLosses TRUE - characters were changed to conform to UTF-8. FALSE - otherwise
make long URLs shorter.
commit out debugging
Add latest pr2html functions which will trim long URLs.
Add link to BSDMall
Print the commit message using the correct function
Add watch and watch add icons.
Start using icons for watch add and remove
Add TITLE strings to images Add pr2html
Make the main table 100%
Add ports_all to permissions
allow for non-logged in users
include commit link within the files page
Adding link to commit.php from most places.
Allow searching by message_id
use the full path to the image
globalize that variable so we can get to the CVSWeb page
Lets all use the deleted function.
urls are now transparent.
fix more typos
fix typo
Center the table
Start using the new deleted and refresh icons.
Don't link to the FreeBSD mailing list archive for older messages which do not contain a valid message id.
Add domain renewal time
Fix a typo and put Helvetica in front of Verdana.
Add commits_latest_tmp.message_id so we can link from the webpage to the mailing list archive.
first commit
call freshports_Email_Link
add freshports_Email_Link which provides a link to the mail archives
call freshports_Email_Link fix typo in SystemTimeAdjust()
tidy up HTML
oops, reverse the sign on SystemTimeAdjust()
add FetchByName
Grab port_id and adjust the time using SystemTimeAdjust()
remove GLOBAL CVSTimeAdjustment
Use SystemTimeAdjust()
sort by category and port to ensure consistency
Tidy up the interval.
Cater better for the Revision line...
Remember to use the system time adjustment
Add permissions for new table.
merge from branch
Merge to branch
merge to branch
commit to head
Add new caching functions to keep track of updating the cache
move RefreshMainPage and GetMaxCommitLogPortId to cache.pm
if commiting a port, call DailySummaryDateAdd
also check the daily_refreshes file
- update copyright
- remove mistakenly copied routines
- ReadFile
- FetchFile
- InitSyslog
- ReportError
- SendEmailNotice
reflect new location of CreateDailySummary in cache.pm
move CreateDailySummary to new cache.pm module
Oops, checked in with debug on
moves this file around.
add and use freshports_CommitFilesLink to create links to files
white space changes only
- add a few globals - needed for URL of /category/ports/files.php?commitid
Allow URL of /category/ports/files.php?commitid to show files affected by said commit it
- Add DailySummaries back to the front page (and include more of them) - use freshports_CommitFilesLink to create links to files
remove ports2, categories2, and element2 no idea where they came from
Add Daily_Refreshes table
Add Daily_Refreshes table and function for adding stuff to and removing entries from.
add link to traffic pages
No longer needed
This commit was manufactured by cvs2svn to create tag 'beta'.
First import
Standard project directories initialized by cvs2svn.
doh, change the right line
change Changes to CVSWeb
Upgrade to latest on FreshPorts2
Move freshports_ConvertPortPathToStandardLocation to port.pm
spelling mistake changes, etc.
clean up the file
Make the functions previously in sp-config.txt.sample data driven and move them back into sp.txt
- add committer to commits_latest - set users.emailbouncecount default to zero - add view ports_all
Add committer to front page.
Add a BR after the port description and do not show the category
put category after the port and smaller.
Move the commit time to a line by itself Put the description at the end of the line
Fix a broken </B> tag
do a syslog if they change their email address, just an audit trail
If the email test fails, set the flag.
if they change the email address, validated it.
Use Combined logs not Common (so we can see the referer)
print the file name on a file action error
Get the URL right
Add link to freshports test website
This commit was manufactured by cvs2svn to create branch 'FreshPorts2'.
Split functions into two parts. One which requires configuration for local use. The other does not.
Put this on the branch
Be a little more specific about the start of the files section
This is a great port for installing ports needed by FreshPorts
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.