<?php

define('_JEXEC', 1);

if (file_exists(__DIR__ . '/defines.php'))
{
  include_once __DIR__ . '/defines.php';
}

if (!defined('_JDEFINES'))
{
  define('JPATH_BASE', __DIR__);
  require_once JPATH_BASE . '/includes/defines.php';
}

require_once JPATH_BASE . '/includes/framework.php';

require_once JPATH_BASE . '/libraries/joomla/factory.php';

$db = JFactory::getDbo();

$query = $db->getQuery(true);

$qr_result = $db->setQuery("SELECT * FROM cxq09_content WHERE 1");

$list = $db->loadObjectList();

foreach($list as $article){ 
	$title = $article->title;
	echo $title . "\n";
	$replaceFrom = '<img';
	$replaceTo = '<img alt=\"' . $title . '\" ' . 'title=\"' . $title . '\"';
	$qr_result = $db->setQuery(
		'UPDATE ' . $db->quoteName('#__content') . 
		' SET ' . $db->quoteName('fulltext') . 
		' = REPLACE(' . $db->quoteName('fulltext') . ', ' . $db->quote($replaceFrom) . ', ' . $db->quote($replaceTo) . 
		') WHERE ' . $db->quoteName($title) . ' = ' . $title);
}



$result = $db->query();