Blog Archives

Sorting ActiveCollab tasks

Our company has been using ActiveCollab for years. It’s a great project management tool and has improved considerably over the years. We have managed hundreds of projects and more than 12,000 tasks using ActiveCollab. Occasionally we want a little more

Tagged with: ,
Posted in Tech Tips

Proximity by City or Zip Code in Drupal 6 with Location and Views

The location module for Drupal 6 is a robust module. On most projects, it gives us 100 percent of what we need. Proximity searching based on zip code is built-in and fairly painless to setup. I’ve recently been tasked to also allow

Tagged with: , , , , , , ,
Posted in Development

db_query() and db_placeholders() example #1

Have you ever wondered how to properly build a query like this in Drupal:

This requires the use of db_placeholders() to create the placeholder ‘ ‘, ‘ ‘, etc.

where $node_types is an array of node types.

Tagged with: , , , , ,
Posted in Development

Views Taxonomy: Get Terms with Associated Nodes

This example serves as both an example of how to alter a Views2 query, as well as how to use the get_terms_by_count() function I’ve written. Unfortunately there is not (at present) a Views2 taxonomy filter that lets you “Get only terms with

Tagged with: , , , , ,
Posted in Development

Taxonomy Menus for Custom Views

Note: If you’re looking to just output a list of taxonomy terms that link to a custom view, please see PHP Code to Output a List of Terms Linked to a Custom View. If you need actual Drupal menu items for

Tagged with: , , , , ,
Posted in Development

Cache-related WSOD! Help!

UPDATE: You can do this stuff with Drush (setting the variable with vset). It’s much faster! Well, you’ve probably all had a White Screen Of Death a time or two while dealing with Drupal or PHP. They can be very

Tagged with: , , , , ,
Posted in Development

Delete comments and disable commenting on all nodes of a particular content type

Please TEST these queries before running them on a live site! I do not want to be held responsible if something goes wrong. Here is how a colleague explained his situation (the solution follows): The trap is that if you

Tagged with: , , , ,
Posted in Development