ecco il codice fatto in fretta ed in furia...
$idclona è il id del contenuto (in questo caso statico) da duplicare
<?
$hostname_assistenza = "localhost";
$database_assistenza = "xxxxxxxx";
$username_assistenza = "xxxxxxxx";
$password_assistenza = "xxxxxxxx";
$assistenza = mysql_connect($hostname_assistenza, $username_assistenza, $password_assistenza,true) or die(mysql_error());
mysql_select_db($database_assistenza, $assistenza);
$idclona=205;
mysql_query("INSERT INTO jos_content
(jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits)
SELECT
jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits
FROM jos_content where id='".$idclona."' ",$assistenza) or die ("Errore creazione nuovo".mysql_error());
echo "copia<br>";
$mod=mysql_query("SELECT * FROM jos_content order by id desc",$assistenza) or die ("Errore nel conteggio del forum".mysql_error());
$resc=mysql_fetch_array($mod);
$idmod=$resc[id];
echo $resc[id];
$titmod=$resc[title]." English";
echo $resc[title]."<br>";
mysql_query("UPDATE jos_content SET title='".$titmod."' WHERE id='".$idmod."'",$assistenza) or die ("Errore nella modifica".mysql_error());
echo "modificato inglese<br>";
/* FRANCESE */
mysql_query("INSERT INTO jos_content
(jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits)
SELECT
jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits
FROM jos_content where id='".$idclona."' ",$assistenza) or die ("Errore creazione nuovo".mysql_error());
$mod=mysql_query("SELECT * FROM jos_content order by id desc",$assistenza) or die ("Errore nel conteggio del forum".mysql_error());
$resc=mysql_fetch_array($mod);
$idmod=$resc[id];
echo $resc[id];
$titmod=$resc[title]." Français";
echo $resc[title]."<br>";
mysql_query("UPDATE jos_content SET title='".$titmod."' WHERE id='".$idmod."'",$assistenza) or die ("Errore nella modifica".mysql_error());
echo "modificato Français<br>";
/* TEDESCO */
mysql_query("INSERT INTO jos_content
(jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits)
SELECT
jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits
FROM jos_content where id='".$idclona."' ",$assistenza) or die ("Errore creazione nuovo".mysql_error());
$mod=mysql_query("SELECT * FROM jos_content order by id desc",$assistenza) or die ("Errore nel conteggio del forum".mysql_error());
$resc=mysql_fetch_array($mod);
$idmod=$resc[id];
echo $resc[id];
$titmod=$resc[title]." Deutsch";
echo $resc[title]."<br>";
mysql_query("UPDATE jos_content SET title='".$titmod."' WHERE id='".$idmod."'",$assistenza) or die ("Errore nella modifica".mysql_error());
echo "modificato Deutsch<br>";
/* SPAGNOLO */
mysql_query("INSERT INTO jos_content
(jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits)
SELECT
jos_content.title, jos_content.title_alias, jos_content.introtext, jos_content.fulltext, jos_content.state,
jos_content.sectionid, jos_content.mask, jos_content.catid,
jos_content.created, jos_content.created_by, jos_content.created_by_alias, jos_content.modified,
jos_content.modified_by, jos_content.checked_out, jos_content.checked_out_time,
jos_content.publish_up, jos_content.publish_down, jos_content.images, jos_content.urls,
jos_content.attribs, jos_content.version, jos_content.parentid, jos_content.ordering, jos_content.metakey,
jos_content.metadesc, jos_content.access, jos_content.hits
FROM jos_content where id='".$idclona."' ",$assistenza) or die ("Errore creazione nuovo".mysql_error());
$mod=mysql_query("SELECT * FROM jos_content order by id desc",$assistenza) or die ("Errore nel conteggio del forum".mysql_error());
$resc=mysql_fetch_array($mod);
$idmod=$resc[id];
echo $resc[id];
$titmod=$resc[title]." Español";
echo $resc[title]."<br>";
mysql_query("UPDATE jos_content SET title='".$titmod."' WHERE id='".$idmod."'",$assistenza) or die ("Errore nella modifica".mysql_error());
echo "modificato Español <br>";
?>