In order to reset the root or superadmin password on a drupal system, login into the database by looking at the settings.php. You can use phpMyAdmin or any other MySQL utilities like SQLYog, or MySQL command line.

Run the following query to reset the password.

UPDATE users SET pass = MD5('password') WHERE uid = 1 

The user id of administrator is always 1.
Password field in drupal is stored as MD5 of the actual string password. So running the above query would set your password as password of the superadmin user.

Here's a list of sites for drupal developers to play around with.

HTML Comments without moderation

• www.themallblog.com
• www.eatsleepandcode.com
• www.layt.net

Anonymous node editing

• mature-ip.eu/node/115/edit
• drupal.kldp.net (Its all Korean I dont know what all is possible)
• drupal.x73.ch
• proves2.iws.es/drupal
• emusic.mozdev.org/drupal
• www.news7newslinc.net
• futuregrid.org
• www.aidsvancouver.org
• jennycrumiller.com

When you want to alter a form on Drupal, it is useful to detect if the form being submitted is to add a new node or edit an existing node. To detect if a form is being added or submitted, check the
$form[<content-type>]['nid']['#value'].
Example :
$form['book']['nid']['#value'].
If the value is new, the node is being added.
If the value is numeric, the node with nid as the number is being edited.

Anyone got better ideas ?

To show similar content nodes on drupal you have to install the similar module. After installing the similar module

• goto admin/build/block
• Drag the Similar Entries module

OR

If you want to integrate the similar content to the node body, call the similar_content theme function.  print theme('similar_content', $node); on node.tpl.php

This was supposed to be obvious, but I couldnt find easily how to integrate Google Adsense and Analytics to track your Adsense Ad performance on google analytics. Make sure you display ads on your page and the analytics tracking code. Make sure you have linked the adsense and analytics together before doing this. The following is to add one more site to track adsense.

And then Getting straight to the answer, put the following script on the head.

<script type="Text/javascript">window.google_analytics_uacct = "UA-XXXXXX-X";</script>

If you use AddThis module on drupal, you might have noticed that a 1px by 1px flash object is created which sets tracking cookies on your pages. This is transparent to the user most time and you will see it only under generated source view. The flash button is added dynamically by the addThis module on the top of the page. This sometimes can be annoying since a white bar can appear at the top of the page due to this.

In drupal 6, the flash tracking can be disabled. In drupal 5 the tracking can be disabled by adding the following line of code to addthis.module