update users set pass=md5('NEWPASS') where uid = 1;
This piece of code is to generate a menu or list of links to taxonomy pages. I used it inside a block. I created a view that shows all items under certain taxonomy term.
It is basically a taxonomy menu but you can customized an place it anywhere.
Good link to learn more about embedding your own views: http://groups.drupal.org/node/10129
This is an example on how you can create a custom search box for your drupal site. The code below renders a text box and a button. When you perform a search, drupal will only look for the keyword inside the node types specified below (page, recipe, product, blog_article). You can just copy and paste this code into a block.
This php snippet is useful for customizing the behavior of the "My account" link. Sometimes you want to place a login link in one of the menus. It might be confusing sometimes because after you login, the link won't show as "Logout" but as "My account". This is not ideal so you can use the snippet to make it show as "Logout".
Place this code inside your template.php file.