{source}
<?php

if (!(defined('_JEXEC') || defined('_VALID_MOS'))) {
die('Direct Access to this location is not allowed.');
}

$db =&JFactory::getDBO();

//$db->setQuery("SELECT * FROM bcos_content where (id=60 ) or (id=61)" );
// selection des articles de type massif
$db->setQuery("SELECT * FROM bcos_content where introtext like '%FROM bcos_f_massifs%'");
$rows = $db->loadObjectList();
// boucle sur les records
foreach ($rows as $row) {
$id=$row->id;
/*
// pour remettre where massif='massif courant' !
$alias= $row->alias;
$requete='update bcos_content set introtext =replace(introtext,\'recree-massifs\',\''.$alias.'\') where id= '.$id;
*/
// remplacement systematique de chaine
$requete='update bcos_content set introtext =replace(introtext,\'view=list id=3\',\'view=list id=3\') where id= '.$id;
echo '<br/>'.$requete;
$db->setQuery($requete);
$db->query();
};

//fin boucle records}


?>
{/source}