mikl

-- Start with the session CCK table
SELECT u.mail, n.title FROM content_type_session AS cts
-- JOIN the node table to get users.uid.
INNER JOIN node AS n ON (cts.vid = n.vid AND n.status = 1)
-- JOIN the users table to get e-mail, name, etc.
INNER JOIN users AS u ON (n.uid = u.uid)
-- LEFT JOIN the user role filtering on the DrupalCon attendee role.
-- This means that users WITHOUT this role will have a null value in the result set.
LEFT JOIN users_roles AS ur ON (u.uid = ur.uid AND rid = 5)
-- Filter on accepted sessions and a NULL value in the rid field.

mikl

SELECT n2.title, n1.title FROM content_field_session_presenters AS cfsp
INNER JOIN node AS n1 ON cfsp.field_session_presenters_nid = n1.nid
INNER JOIN node AS n2 ON cfsp.nid = n2.nid;

mikl

#
# Based upon the NCSA server configuration files originally by Rob McCool.
#
# This is the main Apache server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See http://httpd.apache.org/docs/2.2/ for detailed information about
# the directives.
#
# Do NOT simply read the instructions in here without understanding
# what they do.  They're here only as hints or reminders.  If you are unsure

mikl

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.

mikl

From 8c40a37f625ac0c7ba9811628f49c5ff540954e9 Mon Sep 17 00:00:00 2001
From: Mikkel Hoegh <[email protected]>
Date: Thu, 25 Dec 2008 16:27:41 +0100
Subject: [PATCH] Display time now only displays minutes and hours.

---
 apps/tracker/models.py |   10 +++-------
 1 files changed, 3 insertions(+), 7 deletions(-)

diff --git a/apps/tracker/models.py b/apps/tracker/models.py