Just started a family blog at http://brettandlana.com

Not sure if I'll actually use it, but if anybody's interested, hop on over and leave a comment or two.

Brett

I recently partnered with a lawyer to produce DocketMonitor.com, a website which will keep you up to date on certain court dockets. It currently supports all of the state level and federal level courts, including appellate courts, excluding bankruptcy courts. We are currently looking for lawyers interested in trying out the service for free. Please use the user registration form on http://docketmonitor.com to sign up and try it out.

Functions include automated checking of dockets, as well as email notifications.

I hope its a useful service that saves lots of time and effort.

This module enables you to use Drupal as a front end for creating, tracking, and reporting functional behavior reports.

This is useful in education where as a school psychologist you want to track and report on the behavior of a student.

Example Site: http://www.fbasoftware.com

PREREQUISITES:

Drupal 6.x

Charts Module (http://www.drupal.org/project/charts) (this is for the reports)
Google Charts Module (comes with Charts)

You must create a content type called "student". This will be the content type that when you are viewing it, is loaded with the behavior tracking widget.

This module lets you select a field in the admin interface, and when a person is subscribed to a node of that type, and content is created with a node reference to that node, they will get subscription notifications.

I haven't tested this a bunch. Anyone using it?

This module takes information from text files with the format UID-APPID.txt in a specific folder (managed by admin area) and on the cron cycle, pulls that information into a database table, and has a menu item on the user's page that displays that information. There are specific permissions for seeing your own module, and seeing other people's as well.

So I had a question while optimizing some Mysql queries. What is the right order for the 3 commands I needed in this query: GROUP BY, ORDER BY, and LIMIT?

Well, in school we talked so much about tuning, I even took a class that devoted part of it to MySQL tuning, but I had yet to see a need for it until today. We have a site that wanted an area to each video page that pulled in content like Amazon.com. We titled the area "People who viewed this also viewed" and we were pulling in content that was seen by other users and highly rated. So, here's the sql I came up with:

SELECT path, COUNT(path) as count FROM accesslog WHERE uid IN (SELECT uid FROM accesslog WHERE path='*****' AND uid !=0) GROUP BY path ORDER BY count

I had a client ask me to put the visitor's IP address onto the page, and here's the process I went through to do it:

This is based off this page http://drupal.org/node/138374 where everyone wanted checkboxes instead of a multi select for exposed filters. I have some custom stuff in there, too.

I'm also putting the spviewfix module on, as it is similar in that id modifies the exposed filters to checkboxes for a specific view. If someone really wants this, we could make an admin interface to tell it what view to do it on.