09/27/01 automatic generation of archives and CD images for download if our database or the code frontend changes (once a day) 09/25/01 put up links to the rock properties database at Canada Geological Survey 08/19/01 simplified main page fixed broken HTML in about.cgi added links in links.cgi 08/10/01 fixed some broken links 07/06/01 added a favicon.ico for IE and Konqueror users cleanup up and extended list of known sample types(i.e. SS=Sandstone) 02/06/01 ask advisory board for feedback and data 01/06/01 make a specific datatype "map". example is fluid types that are numbers, but those numbers are just indices into a table, that looks like 0 : CO2 1 : Water 2 : Brine This generalization will make future extensions easier. In the "map" type, added "BADDATA" which flags datapoints to be believed bad. 01/5/19 revamped internals to allow for setting up of mirrors. in computer speak: "made commonground relocatable" Also got rid of the ugly redirection from http://commonground.mines.edu/ to http://commonground.mines.edu/cgi-bin/index 01/5/5 explain_category and all_definitions, especially sample type for stuff like QTZ nicer handling of generation of new windows with the explain_category and context_help functions. Now we generate less new windows. 01/3/28 more cleanup, esp graphics nicer histograms 01/3/27 mix of units: ft/s and m/s for velocities max vel 6000m/s if <=6 it is in km/s -> multiply by 1000 if >6000 it is in ft/s -> divide by 10/3 for both vs, vp if one of them fits MPa and psi for pressures mpa=psi/145 if anything is>300 -> is psi for all of sample name -> divide by 145 more histogram clearification 01/3/25 histograms 01/3/24 better+faster redirection handling scripts to monitor and view the hardware health of the server (turns out two of our three fans are broken!) docu: ask people for donations of data 01/3/21 easy reordering of samples out of the result screen many links to explain_category interspersed. maybe that will bring me to implement it use more icons instead of text preliminary work on explain_category help on how to download to excel 01/3/19 set up automated validating via www.htmlhelp.com's validator. this is _not_ easy to do since we chain documents together via submit buttons (validators don't follow that, even in spider mode) and due to different options we have so many documents that the validator refuses to check 'em all. it doesn't have to, either because most of them are similar. Anyway, everything is in /static and the result in static/validator_output.html lots of bugfixes (as always), especially making everything html 4.01 compliant 01/3/17 got rid of frames. now we use a main table instead. 01/3/11 people behind it (more on links page?) direct download of text files - not via submit button, but link On Fri, 2 Mar 2001, Chris Liner wrote: > It would be useful to be able to > have plain text results either omit > the sample name or put it in the > last column. This would *greatly* > facilitate importing the text data > into other programs (e.g., excel). my reply: As a quick fix, have you tried giving sample name the lowest sort weight of all columns? This should put it in the last column. There should probably be a "display" button for sample name to disable it being displayed. -> it now possible to _not_ display the sample name updates page (this changelog) 01/3/10 major redesign - frame on top, nicer backgrounds, beginner- and expert mode in the result-screens, make the titles clickable, to reorder results more intelligent calculation of results/screen: if we have 104 possible results and 100 results/screen, it automatically changes it to 104 made the syntax for substring search more understandable (like people are used from search engines) don't ask for number of results/screen if we only have a few results expert and beginner mode. beginner as wizard-dialog main page less text, more colors, bigger font background less dark and intrusive CSS thousands of bugfixes backup system cleanup system 00/7/16 image output as PNG or JPEG or Postscript 00/6/21 include link to this file into help 00/6/17 include whole stackframe and CGI parameters in error logging (fill out util.pl::stackTrace) complete (as far as I can see) security checks in CGI parameters logging of attempts to thwart security (like putting " in CGI parameters) 00/6/14 fixed bug that does not display units in searchresults 00/6/13 added help for timeformat, download, download batch, search general, select general, put many cross references into the context help made the error logging (to data/errors.log) bigger+more comprehensive 00/6/12 remove dir /help and references of it in docu start of some error logging 00/6/11 context help to graph options more graph options - log scale, dots bigger? gnuplot output recognices and formats times nicely (kind of) stringsearch: *ss etc (wildcards), lists are still OR. This is not really satisfying but multilevel ((A and B) or (C and (D or E))) is more difficult than its worth user may choose field delimiter for text mode default displayed categories so its easier for beginners refine searching button into output table 00/6/10 context_help. The ugly long help text at the bottom is now gone. unloop references. Take away the business of %REF_NAME choice for distinct/not distinct output 00/6/09 display only distinct entries in output 01/3/00-00/6/08 rewrite all the variables and stuff to take care of arbitrary databases. Much easier to customize if columnnames or table contents change view references, descriptions, photos not only out of search results but also just by themselves. search for references search for descriptions search for photos general table output general sql-selector the possibility to ask only for datapoints which have _not_ defined a category make search for samplename using wildcards and specify like/not like sort do the initial searching in request via seek, not counting graph from selection have a textual output so people can download data easily before 00/3/01 I need permission to see the database: change into /usr/local/var and call mysql and look directly at the data rm -rf /home/cg/t become the webmaster What is the relation of /usr/local/var/* and /usr/local/data/* ? what is /usr/local/mysql? ask for references.pl ask for fluidtypes. can a datapoint have several fluidtypes? ask SS, LS, ... ask erklaerung graphit/sql.eps ask : which databases, which tables in each, which columns in each table ask sorting in sql?? ask text interface? ask fluidtypes - what is the real meaning of the numbers? what about those variables in "composition"? Xray, P-count, NMR what about reference and description? are there more values in mineral, maybe? the exact path to the databases, how to ask sql which tables are in which database and which columns they have the exact meaning of each column