Here is the code to be used in the theme's template.php file that will override Drupal's search form. If no template.php is available, just go ahead and create one.

Quick notes on Drush, while on a Drupal installation folder: To create an archive of the current Drupal site: drush archive-dump --destination=/backups/mysite.tar To restore the files and databases for all sites in the archive. drush archive-restore /backups/mysite.tar To create a mysql dump of the current Drupal database: drush sql-dump --result-file= /mydb.sql To drop all tables of the current Drupal database: drush sql-drop To import a new db file in the current Drupal database:

There is a very handy php function that allows us to quickly check all the available variables in a tpl file (e.g. html.tpl.php). Assuming that the devel module is installed, the following line should do the trick: Alternatively, a print_r should work just fine: More info: http://php.net/manual/en/function.get-defined-vars.php

There are many solutions out there to reset User 1's password in a Drupal 7 website. A really convenient way is to use Drush, to generate a one time login URL - no mails involved. The output would be directly on the console, and it is simple to just copy and paste it in a browser. 

The drush command is the following:

 

drush php-eval 'echo user_pass_reset_url(user_load(1));

 

and once logged in, the password can be easily changed in the user edit screen. 

The code below goes in your template.php and removes the "More information about formatting options" link.

Please remember to clear the cache in order for the changes to trigger.

I recently had the requirement to hide a horizontal tab in node display depending on the value of a checkbox i.e. Show tab X. For the horizontal tabs I was using the excellent Fieldgroup module. In order to achieve the above, I created a little custom module and used the newly introduced in drupal 7 hook, hook_node_view_alter.

Here is some code to be used in a custom module in Drupal 7 in order to create a custom link in the admin menu.

Here is a handy, general function for Drupal 6 that takes as an argument a file id and returns the file for downloading. <?php function MYMODULE_send_file($fid) { $file = db_fetch_object(db_query("SELECT * FROM {files} WHERE fid = %d", $fid)); if ($file) { $my_path = $_SERVER['DOCUMENT_ROOT'] .'/'.$file->filepath; header("Pragma: public"); header("Expires: 0"); header('Cache-Control: no-store, no-cache, must-revalidate'); header('Cache-Control: pre-check=0, post-check=0, max-age=0', false); header('Last-Modified: '.gmdate('D, d M Y H:i:s') .?>

Here is the code that changes the default select list of "Select a product" element of Drupal Commerce to radio buttons, for a standalone product list. The following goes in a custom module (tested in Drupal 7).

In a custom module, I needed to get the latest node that each user published. It is fairly easy to goup by users, but it needs a little something to actually accomplish the sorting. The following query worked for me, we need to do the sorting in a nested select: In case the following error comes up:

Error: 1248 - SQLSTATE: 42000 ER_DERIVED_MUST_HAVE_ALIAS