The code below may be placed within a block.

<? global $base_path; ?>

<h3>News
<a href="https://www.zerotouch.com/%3C?echo_%24base_path%3B_%3F%3Enews%2Frss_xml"><img alt="RSS News Feed " src="https://www.zerotouch.com/%3C?echo_%24base_path%3B_%3F%3Esites%2Fall%2Fthemes%2Feagle%2Fimages%2Ffeed_gif"/></a></h3>

However, to get it to reside within a block title customise the block.tpl.php file.

Please see FAQ describing how to customise block.tpl.php file by blockname and region.

[root@ukbweb1 ~]# vi /etc/cron.daily/drupal.cron
[root@ukbweb1 ~]# chmod +x /etc/cron.daily/drupal.cron
[root@ukbweb1 ~]# cat /etc/cron.daily/drupal.cron
#!/bin/bash

/usr/bin/wget -O - -q -t 1 http://www.zerotouch.com/cron.php

In order to ls by date or list Unix files in last modifed date order use the -t flag which is for 'time last modified'.

So for example, you might like to use:

ls -alt

or to ls by date in reverse date order use the -t flag as before but this time with the -r flag which is for 'reverse'.

On the mysql command line:

The following two commans are useful to determine current connections:

•   SHOW STATUS WHERE `variable_name` = 'Threads_connected';

•   SHOW PROCESSLIST;

Centos prompt

You may update the mysql configuration which is located under /etc/my.cnf.

Two variables you may like to review are:

If you have an array in ascending order and you require it to be in descending order you can use the array_reverse function as below.

  $terms = array_reverse($terms);

The code below shows how to iterate through an array and print the keys and values held within an array.

while (list($key, $val) = each($items)) {
  print $key . " -> " . $val;
}

To allocate within a new array simply:

while (list($key, $val) = each($items)) {
  $terms[] = $val . ") " . $key;
}

A string can be replaced within a unix file using the 'sed' command. For example, it may that you've created a MySQL dump and you want to update a string and then import it back into the database.

For example, let's say we have a string '/var/www/vhosts/intranet2' within a file named 'intranet.sql' and we want to replace it with '/var/www/vhosts/intranet' and save it into a new file named 'intranet-updated.sql'.

You simply need to enter:

This can be checked easily with 'top' on Unix or the Task Manager on Windows.

Here are some basic strategies for optimising Drupal's use of the database.

Enabling MySQL's Query Cache

To enable add the following lines to to your MySQL options file - the file is named my.cnf and specifies the variables and behaviour from your MySQL server.

# The MySQL Server
[mysqld]
query_cache_size=64M

The current cache size can be viewed as output of MySQL's SHOW VARIABLES command:

SHOW VARIABLES LIKE 'query_cache%';

query_cache_size | 67108864
query_cache_type | ON

• Mailchimp
• Eventbrite

Also are shopfront side:

• Shopify