User login

Fragment

List taxonomy terms that belong to nodes that belong to another taxonomy term

The SQL for this is a little tricky. I know I wrote down what needed to be done for Christophe to tackle but I can't find it now.

In short:

Select all nodes that belong to the taxonomy term being passed into the Place page.

node -- in drupal 6 node_revision -- but in any case it comes from the taxonomy table.

Select all taxonomy terms that are in a given vocabulary that belong to those nodes.

This requires also a look at {term_data} which stores vocab information (as vid).

Record process of checking out code of a Drupal site so it can be played back

Agaric wants a way to say to our servers, keep track of every svn checkout done here, so we can do it again in an instant for test sites etc.

Resolution

Select rows in a MySQL table that have no corresponding rows in another table using IS NULL

If there is no matching row for the right table in the ON or USING part in a LEFT JOIN, a row with all columns set to NULL is used for the right table. You can use this fact to find rows in a table that have no counterpart in another table:

Making a random number

PWGD will need solid and fast randomization to make the jury pools. (With those who have already served pulled out, but that's another detail.)

It's well known that computers aren't good at random.

Does combined random make something more random? Use the number of milliseconds into the current second as the seed to generate a random number and the decimal part of the CPUs exact temperature to act as the seed for generating another random number and the two are used to pick a page from the virtual big book of random numbers and pick a line on that page.

Setting up a fresh Drupal installation from the Agaric repository.

For a new version of Drupal

From a computer with a local checkout of the subversion repository:

cd ~/workspace/repos/agaric/drupal-core/
wget http://ftp.drupal.org/files/projects/drupal-5.5.tar.gz
tar -xzf drupal-5.5.tar.gz
rm drupal-5.5.tar.gz
svn add drupal-5.5
svn commit -m "latest and greatest Drupal"

Agaric Drupal Podcast Remixes: Notes

middle-to-end of Drupal podcast (#3?) - interview with Moshe Weitzman - Jeff goes on a glorious rant about time zones.

a little later:

help_edit module
drop help text right onto a page

using the help_hook

under-appreciated and underused

(Good reason-- it doesn't exist as a Drupal project at help_edit, helpedit, edit_help, or edithelp. But if Agaric can find it in CVS perhaps we can rescue it and bring it to Drupal 5 and 6 from the depths of time.)

Resolution

Business practices: collecting payment, tracking time

Veronica says:

don't go more than 30 days past implementation (without collecting)

Keep track of hours you work on pro bono projects
You can donate that

Resolution

Why you should run your own blog (or join a trusted community)

(Also, why you should support the EFF.)

* Between Friends: The Perils of Centralized Blogging

Plotting Making Journalism That Matters, the Silicon Valley sessions, a place of doing

kara andrade 40:17
basically, we need to create our own space in there

40:42
they have NO young people involved

benjamin melançon 4:44
well we have at least one ally in making the gathering in general a place for *doing* not just discussing

kara andrade 4:45
we do

45:08
we have a few

45:14
it's our responsibility to make it a place of doing

benjamin melançon 4:46
so what have you agreed to do for Densmore or proposed to him so far?

Figuring out User-based Node Access in Drupal (again), some notes

Simply looking at this function is one of the most useful things you can do to understand node access control in Drupal. From the 5.3 version of node.module

Syndicate content