Joomla Extensions

Here is a simple and useful SQL that can help you batch operation in Joomla.

UPDATE jos_content SET `fulltext` = replace(`fulltext`,"OldWord","NewWord"); 

You can execute the SQL in phpmyAdmin or any other Mysql client.

In Joomla, you can't delete or block a Super administrator user directly.

When you try to delete or block Super Administrator user, the Joomla system will give a warning " You cannot delete (block) a Super Administrator".

However, you can do as follows:

1. In theUser Manage, change the user's group from " Super Administrator" to "Registered", save your changes.

2. Delete or block the user.

To turn off cache, you need to do two things:

1.  Global Configuration--> System-->Cache Settings-->Cache
   Please select 'No';
2. Extensions-->Plugin Manager-->System - Cache 
     Please disable the plugin-"System-Cache" .

Delight your users with mass mailings.

As cynical as this may sound in our age of mass email spamming, it is the best way
for contacting registered users. The Mass Mail component gives you the tool to
do this.
Mail To Child Groups: If you check this, the subgroups of the selected user group
also get mail.
Send in HTML mode: Check this if you want the mass mailing to be sent in HTML
format. HTML mail is getting more and more popular. Keep in mind, however, that
many email clients can deactivate HTML display and that some recipients don't like
HTML mail for various reasons.
Group: Here you select which user group you want to target with the mass mailing.
Subject: The subject matter of your email
Message: The actual text
In order to be able to send your mass mailing, the mail settings in Site | Global
Configuration | Server | Mail Settings have to be set correctly. If you want to send a
mass mailing from your local environment, but you don't have a mail server, you can
enter the settings of your mail provider's SMTP server.