Sometimes we will have a list of string delimited by comma, e.g., a,b,c,d, and we would like to add quote or single quote around each element, e.g., 'a','b','c','d'. It is possible to do so in a line.

There are so many hash. SHA1 is one of them which is widely used in recent years even though it is not safe to use right now. By the way, it is still the default hash function for storing password in LDAP especially OpenLDAP. In order to develop a website with LDAP authentication manually against POSIX account, SSHA hash function or SHA1 is the easiest solution.

By default, Drupal will have only username and password for such a user. Whenever username is displayed, it will try to call a theme funtion namely username by specified $node. If you want to display user's fullname instead, you have to customize a little bit.

I found a good question regarding PHP snippet for Drupal. Usually, we will list nodes in multiple taxonomies using OR operator. However, you might need to list using AND operator which nodes must be in all specified taxonomies instead. It is not easy to do so using plain SQL. The straightforward solution is to use subquery.

Drupal provides powerful and flexible built-in table sort functionality. However, it will only work with database query through standard db_query() and pager_query(). In many cases, rows are fetched from external system, e.g., mailbox. We may add a few lines to get the same behavior.

Most of you may try to let servers run as long as possible to maximize availability in term of uptime. That is good. However, there is at least a side-effect originated by the nature of file system where as it is necessary to clean up something important. For example, ext2/ext3 should be checked for every 30 mounted or 180 days. It is fine to reboot a server once a year as long as the file system is not read/write too often, especially when there is very low free space. That's why you should force to run fsck sometimes.