Fill the template data using the database page information texts in Opencart.

opencart_controllers_common_footer.php

<?php

// @author standa | 2013-09-15 | get the text_seal straight from the database

// information page title to template variables mappings
$title_map = array(
	'Customer Testimonials'  => 'text_testimonial2',
	'Kundenstimmen'     => 'text_testimonial2',
	'Customer Videos'   => 'text_testimonial3',
	'Kunden-Videos'     => 'text_testimonial3',

	'Customer Support'  => 'text_footer1',
	'Kundendienst'      => 'text_footer1',
	'Delivery'          => 'text_footer2',
	'Lieferung'         => 'text_footer2',
	'Secure Checkout'   => 'text_footer3',
	'Sichere Zahlung'   => 'text_footer3',

	'Copyright'         => 'copyright',

	'Designed in Davos' => 'text_seal'
);

$this->load->model('catalog/information');

$this->data['informations'] = array();

foreach ($this->model_catalog_information->getInformations() as $result) {
	if ($result['bottom']) {
		$this->data['informations'][] = array(
			'title' => $result['title'],
			'href'  => $this->url->link('information/information', 'information_id=' . $result['information_id'])
		);
	}

	foreach ($title_map as $t => $p) {
		if (strtolower($result['title']) == strtolower($t)) {
			$this->data[$p] = html_entity_decode($result['description']);
		}
	}
	
}