Joey Schulze [Tue, 5 Oct 2004 07:58:42 +0000 (07:58 +0000)]
Widen the textarea
Joey Schulze [Sun, 3 Oct 2004 06:33:34 +0000 (06:33 +0000)]
Added support for displaying the usage of a component
Joey Schulze [Sun, 3 Oct 2004 06:31:25 +0000 (06:31 +0000)]
Strip the start/end time if possible.
Why can't I use something like:
$row['starttime'] = (explode (" ", $row['starttime']))[0];
Joey Schulze [Sun, 3 Oct 2004 06:21:24 +0000 (06:21 +0000)]
Nah, it's strlen() not length(), also added support for changed usage
in same compound, i.e. /dev/hda moved to /dev/hdb or something.
Joey Schulze [Sun, 3 Oct 2004 06:01:55 +0000 (06:01 +0000)]
Change the screw connector also if the usage is changed, if there is a
usage stored already.
Joey Schulze [Sun, 3 Oct 2004 05:54:21 +0000 (05:54 +0000)]
Added support for a usage during history (i.e. /dev/hda as /var;
/dev/hdb as /boot etc.)
Joey Schulze [Sun, 3 Oct 2004 05:53:14 +0000 (05:53 +0000)]
Name and serial number should not be unique indices
Joey Schulze [Sun, 3 Oct 2004 04:11:59 +0000 (04:11 +0000)]
No need to display the end of lifetime if it hasn't been come yet
Joey Schulze [Sat, 2 Oct 2004 18:02:05 +0000 (18:02 +0000)]
Move the list of fields into an array, thus removing the * field so
that name is not duplicate anymore.
Joey Schulze [Sat, 2 Oct 2004 18:01:28 +0000 (18:01 +0000)]
Add a link to the compound in the component history
Joey Schulze [Fri, 1 Oct 2004 15:25:21 +0000 (15:25 +0000)]
List former components as well
Joey Schulze [Fri, 1 Oct 2004 07:43:31 +0000 (07:43 +0000)]
. Enclose component updates in a transaction
. Actually query the database for the last oid *sigh*
. Fixed a typo -> parse error
Joey Schulze [Thu, 30 Sep 2004 06:06:27 +0000 (06:06 +0000)]
Filter out an empty price -> n/a
Add second argument to die_query()
Joey Schulze [Thu, 30 Sep 2004 05:56:08 +0000 (05:56 +0000)]
Don't fiddle with the time zone twice
Joey Schulze [Wed, 29 Sep 2004 17:30:26 +0000 (17:30 +0000)]
Added kyllikki as valid hostname including a new destination path
Joey Schulze [Wed, 29 Sep 2004 17:29:48 +0000 (17:29 +0000)]
Use \t instead of a tab char and since we've switched to using .php3
as base suffix the dependency generator needs to be adjusted as well.
Joey Schulze [Wed, 29 Sep 2004 17:28:46 +0000 (17:28 +0000)]
Added the hardware database and kyllikki as valid host
Joey Schulze [Wed, 29 Sep 2004 17:28:27 +0000 (17:28 +0000)]
Added the hardware database
Joey Schulze [Wed, 29 Sep 2004 17:28:18 +0000 (17:28 +0000)]
First implementation of the hardware database
Joey Schulze [Wed, 29 Sep 2004 17:28:06 +0000 (17:28 +0000)]
Functions copied (and improved in case of <row_select>) from LTP
Joey Schulze [Tue, 24 Aug 2004 14:36:43 +0000 (14:36 +0000)]
Link to the new projects page
Joey Schulze [Tue, 17 Aug 2004 18:14:22 +0000 (18:14 +0000)]
It's only a new entry and not a new log
Joey Schulze [Sun, 8 Aug 2004 21:04:22 +0000 (21:04 +0000)]
Use my other address
Joey Schulze [Sat, 7 Aug 2004 06:45:26 +0000 (06:45 +0000)]
Use the two-digit day of month
Joey Schulze [Fri, 6 Aug 2004 11:07:37 +0000 (11:07 +0000)]
Preserve the original name so that cncoding/escape changes only go
into the database but not into the HTML response
Joey Schulze [Thu, 5 Aug 2004 06:19:26 +0000 (06:19 +0000)]
Should not convert \ and ' twice
Joey Schulze [Mon, 19 Jul 2004 07:28:27 +0000 (07:28 +0000)]
Hook to the proper database
Joey Schulze [Sun, 18 Jul 2004 14:38:39 +0000 (14:38 +0000)]
Capitalisation
Joey Schulze [Sun, 18 Jul 2004 10:31:52 +0000 (10:31 +0000)]
Output all logbook items
Joey Schulze [Sun, 18 Jul 2004 10:31:29 +0000 (10:31 +0000)]
Limit the list to the most recent 50 items
Joey Schulze [Sat, 17 Jul 2004 17:54:41 +0000 (17:54 +0000)]
Update for 2005
Joey Schulze [Sat, 17 Jul 2004 17:52:22 +0000 (17:52 +0000)]
Import the 2004 version of ltp.conf so we can properly start 2005
Joey Schulze [Sat, 17 Jul 2004 17:51:20 +0000 (17:51 +0000)]
Support for new database design, i.e. person.id as foreign key for
nili.person
Joey Schulze [Sat, 17 Jul 2004 17:50:24 +0000 (17:50 +0000)]
Support for new database design, i.e. person.id as foreign key for
workshop.person (which replaces workshop.speaker). Speakers that
don't belong to a supported project need to be added to a pseudo
project named 'Speaker'.
Joey Schulze [Sat, 17 Jul 2004 17:48:47 +0000 (17:48 +0000)]
Support for new database design, i.e. person.id as foreign key for
workshop.person (which replaces workshop.speaker)
Joey Schulze [Sat, 17 Jul 2004 17:45:51 +0000 (17:45 +0000)]
Support for new database design, i.e. person.id as foreign key
Joey Schulze [Sat, 17 Jul 2004 17:44:55 +0000 (17:44 +0000)]
Added support for the terrestrial and mobile phone numbers
Joey Schulze [Sat, 17 Jul 2004 17:41:57 +0000 (17:41 +0000)]
Err... we cannot only edit the availability... where did this menu
line come from?
Joey Schulze [Sat, 17 Jul 2004 17:40:26 +0000 (17:40 +0000)]
Always display the comment the person added (such as additional phone
numbers, irc nicknames or whatever)
Joey Schulze [Sat, 17 Jul 2004 17:38:14 +0000 (17:38 +0000)]
Added support for the terrestrial and mobile phone number
Joey Schulze [Sat, 17 Jul 2004 17:33:32 +0000 (17:33 +0000)]
Support for new database design, i.e. person.id as foreign key
Joey Schulze [Sat, 17 Jul 2004 17:33:03 +0000 (17:33 +0000)]
Added support for the terrestrial and mobile phone number
Joey Schulze [Sat, 17 Jul 2004 17:32:17 +0000 (17:32 +0000)]
Looks like the default setting for infomails for supporters were
forgotton before.
Joey Schulze [Sat, 17 Jul 2004 17:25:30 +0000 (17:25 +0000)]
Support for new database design, i.e. person.id as foreign key
Joey Schulze [Sat, 17 Jul 2004 17:12:25 +0000 (17:12 +0000)]
We need to check whether the pseudo project 'Supporter' exists since
person.project uses project.name as foreign key. If the project does
not exist yet it needs to be created on the fly. It'll be ignored by
other parts of the program but the foreign key constraint requires it
to exist.
Joey Schulze [Sat, 17 Jul 2004 12:53:18 +0000 (12:53 +0000)]
Support for new database design, i.e. person.id as foreign key
Joey Schulze [Sat, 17 Jul 2004 12:42:08 +0000 (12:42 +0000)]
Reworked the logic for adding a new person (or not). If the realname
and the mail address are the same, it is assumed to be the same
person. If one of them differs, it is assumed to be a different
person.
This will probably lead to some confusion with people who are a member
of different projects and use different mail addresses, such as
foo@debian.org and foo@kde.org. They will be treated as different
people until the person notices this and gets one of them removed.
Joey Schulze [Sat, 17 Jul 2004 12:35:11 +0000 (12:35 +0000)]
Support for the subproject attribute
Joey Schulze [Sat, 17 Jul 2004 12:32:32 +0000 (12:32 +0000)]
Updated the "real" name
Joey Schulze [Sat, 17 Jul 2004 12:30:12 +0000 (12:30 +0000)]
Support for new database design, i.e. person.id as foreign key
Joey Schulze [Sat, 17 Jul 2004 12:29:37 +0000 (12:29 +0000)]
Display the sub-project if this project will be part of another booth.
Joey Schulze [Sat, 17 Jul 2004 12:24:34 +0000 (12:24 +0000)]
Display the booth title if one is defined, and only display the
description if there is one.
Joey Schulze [Sat, 17 Jul 2004 12:21:51 +0000 (12:21 +0000)]
Support for new database design, i.e. person.id as foreign key
Joey Schulze [Sat, 17 Jul 2004 12:18:03 +0000 (12:18 +0000)]
Added support for the terrestrial and mobile phone number
Joey Schulze [Fri, 16 Jul 2004 18:33:05 +0000 (18:33 +0000)]
Support for being a sub-project of another project (or a sub-exhibitor
of another exhibitor).
Joey Schulze [Fri, 16 Jul 2004 18:18:52 +0000 (18:18 +0000)]
Use a more sophisticated limit report mechanism / string
Joey Schulze [Fri, 16 Jul 2004 18:17:28 +0000 (18:17 +0000)]
Code change to reflect the new database structure, i.e. use person.id
as foreign key for several other tables
Joey Schulze [Fri, 16 Jul 2004 18:15:08 +0000 (18:15 +0000)]
Preserve the selection the user has made instead of blindly resetting
it with each new page loading.
Joey Schulze [Fri, 16 Jul 2004 18:08:49 +0000 (18:08 +0000)]
Added the missing day
Joey Schulze [Fri, 9 Jul 2004 20:11:01 +0000 (20:11 +0000)]
Modified fixsuffix that copes with the new default being .php3 so most
of the pages won't be rebuilt all the time.
Joey Schulze [Fri, 9 Jul 2004 20:10:43 +0000 (20:10 +0000)]
Modified Makefile that defaults to .php3 so most of the pages won't be
rebuilt all the time.
Joey Schulze [Sun, 4 Jul 2004 17:16:32 +0000 (17:16 +0000)]
Start of LTP for 2005, file copied from ../2004/
Joey Schulze [Sun, 4 Jul 2004 15:31:28 +0000 (15:31 +0000)]
Use the 2005 style/include file
Joey Schulze [Sun, 4 Jul 2004 15:28:46 +0000 (15:28 +0000)]
Added support for kyllikki
Joey Schulze [Sun, 4 Jul 2004 15:28:31 +0000 (15:28 +0000)]
Start of LTP for 2005, file copied from 2004
Joey Schulze [Sun, 4 Jul 2004 15:26:41 +0000 (15:26 +0000)]
Start of LTP for 2005, file copied from ../2004/
Joey Schulze [Sun, 4 Jul 2004 15:25:52 +0000 (15:25 +0000)]
Start of LTP for 2005
Joey Schulze [Sun, 4 Jul 2004 15:25:21 +0000 (15:25 +0000)]
LinuxTag is over, hence no more altering of data permitted
Joey Schulze [Mon, 14 Jun 2004 07:13:22 +0000 (07:13 +0000)]
Ensure that there is a title character so the link will work
Joey Schulze [Fri, 4 Jun 2004 19:34:08 +0000 (19:34 +0000)]
This year the show starts at 9:00, so workshops may start early as
well, of course.
Joey Schulze [Fri, 28 May 2004 17:09:08 +0000 (17:09 +0000)]
The comment is no integer field
Joey Schulze [Fri, 28 May 2004 16:27:53 +0000 (16:27 +0000)]
Widen the <textarea> so that it fits the needs better
Joey Schulze [Fri, 21 May 2004 10:03:16 +0000 (10:03 +0000)]
Adjusted the mailing list
Joey Schulze [Fri, 7 May 2004 14:42:44 +0000 (14:42 +0000)]
Widen the text area to fit better for the text
Joey Schulze [Thu, 6 May 2004 14:47:51 +0000 (14:47 +0000)]
Try to avoid sending ^Ms in the mail, also remove lt2k-email since the
list doesn't exist anymore
Joey Schulze [Thu, 6 May 2004 14:45:57 +0000 (14:45 +0000)]
Try to avoid sending ^Ms in the mail
Joey Schulze [Thu, 6 May 2004 08:57:47 +0000 (08:57 +0000)]
Don't believe that lt2k-email still exists.
Joey Schulze [Thu, 1 Apr 2004 13:54:53 +0000 (13:54 +0000)]
Added a missing comma and reorganised the query fields
Joey Schulze [Wed, 31 Mar 2004 09:55:33 +0000 (09:55 +0000)]
Ouch, forgot to update the public flag
Joey Schulze [Mon, 29 Mar 2004 16:20:27 +0000 (16:20 +0000)]
Added a missing space
Joey Schulze [Mon, 29 Mar 2004 07:15:47 +0000 (07:15 +0000)]
Added search facility
Joey Schulze [Sat, 27 Mar 2004 08:31:03 +0000 (08:31 +0000)]
No id required for the public listing
Joey Schulze [Thu, 18 Mar 2004 09:17:09 +0000 (09:17 +0000)]
Added a list of public log entries
Joey Schulze [Wed, 10 Mar 2004 14:30:27 +0000 (14:30 +0000)]
For some reason format 'j' was easier to find than format 'd' which is
the proper two-digit format. *sigh* Some references are broken or at
least strange now. Well... Documentation: http://www.php.net/date
Joey Schulze [Wed, 10 Mar 2004 14:24:16 +0000 (14:24 +0000)]
Ouch, maybe the id is too large to fit into a normal integer...
*blush* This is not an oid
Joey Schulze [Tue, 9 Mar 2004 15:33:29 +0000 (15:33 +0000)]
Use the weekday name from the configuration and don't hardcode it
Joey Schulze [Mon, 8 Mar 2004 20:10:11 +0000 (20:10 +0000)]
Ouchi, should include the file to make it useful... pity me
Joey Schulze [Mon, 8 Mar 2004 11:26:15 +0000 (11:26 +0000)]
Use the id as index for the index instead of the (only internally used) oid
Joey Schulze [Wed, 25 Feb 2004 17:57:20 +0000 (17:57 +0000)]
Newlines aren't evil, are they?
Joey Schulze [Wed, 25 Feb 2004 17:55:15 +0000 (17:55 +0000)]
Hmm, should close the tags to take effect...
Joey Schulze [Wed, 25 Feb 2004 13:40:27 +0000 (13:40 +0000)]
Properly aligh the date
Joey Schulze [Wed, 25 Feb 2004 08:05:08 +0000 (08:05 +0000)]
Display the log entry instead of always directly editing it.
Joey Schulze [Mon, 23 Feb 2004 19:01:13 +0000 (19:01 +0000)]
Oh dear, stupid as stupid can...
Joey Schulze [Mon, 23 Feb 2004 17:21:59 +0000 (17:21 +0000)]
Ensure that the non-modified version will be displayed
Joey Schulze [Mon, 23 Feb 2004 17:15:21 +0000 (17:15 +0000)]
Looks like the quoting needs to be done differently
Joey Schulze [Mon, 23 Feb 2004 17:01:26 +0000 (17:01 +0000)]
Corrected the HTML code
Joey Schulze [Mon, 23 Feb 2004 17:01:14 +0000 (17:01 +0000)]
Finally added a weblog like thingy, but keep it off the public for the moment.
Joey Schulze [Mon, 23 Feb 2004 17:01:07 +0000 (17:01 +0000)]
Finally added a weblog like thingy, but keep it off the public for the moment.
CREATE TABLE logbook (
id TEXT,
teaser TEXT,
body TEXT,
public INT2 NOT NULL DEFAULT 0,
created TIMESTAMP WITH TIME ZONE DEFAULT '1980-01-01 00:00' NOT NULL
);
CREATE UNIQUE INDEX "logbook_id" on "logbook" using btree ( "id" );
Joey Schulze [Wed, 18 Feb 2004 18:15:19 +0000 (18:15 +0000)]
Adjusted the date
Joey Schulze [Wed, 18 Feb 2004 18:14:25 +0000 (18:14 +0000)]
This years' adjusted configuration for LinuxTag