Drupal 6

Often you can see if drupal site is bloated with modules if you just check how many of them are enabled, you can do this quickly with mysql command.

I used revisions and almost emidietly regreted. Revisions are just like other nodes. So if you use views to display them, then you will have by default both original nodes and their revisions displayed. What you could probably do is use content revision type of view, but you still get all the nodes there. I tried with some relationships but no luck. Then finally I installed revisioning module and there was one new filter that counted number of revisions. So you add "Content: Revisions (> 1)" and you will get all the new revisions.

So you bring your site on localhost for some testing or faster developing and then you get not accessable admin section? Somehow drupal has problem with this and "check update module", so what you need to do is disable it.

To disable the Check Update module without, go to your mySQL database page (phpmyadmin) and select system table. Select the record which filename field="modules/update/update.module". Change the value of status field to 0.

This is more or less what you need

http://library.linode.com/security/sftp-jails

Just add user before with useradd and then add this as on the link before.

Adding colorobox to link is not so hard. You need to follow module instructions and it will work, just be careful to add EMBED code to URL, not just plain link. For example when adding You Tube video do this

As views and even more panels are not perfect when it comes to translations if you need to have some fixed label with translation for some view/panel. You can create custom token for it and then just translate it over translation interface. Token creation is simple, just use this guide

1. Go to Admin > Structure > Custom Token, click on Add Token
2. Enter a Token Name and Description
3. Choose "Custom Tokens" for the Token Type or "Nodes Token" if you want it to be available on for example node panels overide.
4. In the PHP Replacement text area enter something like this:

I just installed mysql tuner to try and tune mysql,

http://www.ubuntugeek.com/mysqltuner-check-your-mysql-server-performance...

Hopeing it helps with drupal and hogging of apache.

Well the year is 2012 and you must use microdata, there is a microdata module for drupal 7, but if you are still at drupal 6 you will need to customize. I have been using vote up/down module for my ratings so I needed to change template file of the module to add this microformats to node display so I added this code at the end of widget.tpl.php

I often forget this one, if you need to see what available variables are in some specific template file of any contributed module you will write this on top of the tpl file

and will get a nice list of variables you can use.

Go to phpmyadmin and start this 2 commands

depending what you need, if you have drush you could also do that with drush.