";
}
function build_end_tag($tag) {
return "";
}
// Conversion texte -> xml (ajout d'entites)
if ($flag_str_replace) {
function text_to_xml($string) {
return str_replace('<', '<', str_replace('&', '&', $string));
}
}
else {
function text_to_xml($string) {
return ereg_replace('<', '<', ereg_replace('&', '&', $string));
}
}
//
// Exportation generique d'objets (fichier ou retour de fonction)
//
function export_objets($query, $type, $file = 0, $gz = false, $etape_en_cours="", $etape_actuelle="", $nom_etape="") {
global $debut_limit;
if ($etape_en_cours < 1 OR $etape_en_cours == $etape_actuelle){
if ($etape_en_cours > 0) {
echo "$nom_etape";
}
$result = spip_query($query);
if ($etape_en_cours > 0){
if ($type == "forum"){
$total = mysql_num_rows($result);
if ($total > 5000){
$result = spip_query($query." LIMIT $debut_limit, 5000");
$debut_limit = $debut_limit + 5000;
if ($debut_limit > $total) {
$debut_limit = 0;
echo " [tous les résultats sont enregistrés]";
}
else {
echo " [$debut_limit premiers résultats sur $total]";
}
}
else {
$debut_limit = 0;
}
}
if ($type == "article"){
$total = mysql_num_rows($result);
if ($total > 500){
$result = spip_query($query." LIMIT $debut_limit, 500");
$debut_limit = $debut_limit + 500;
if ($debut_limit > $total) {
$debut_limit = 0;
echo " [tous les résultats sont enregistrés]";
}
else {
echo " [$debut_limit premiers résultats sur $total]";
}
}
else {
$debut_limit = 0;
}
}
}
$_fputs = ($gz) ? gzputs : fputs;
$nfields = mysql_num_fields($result);
// Recuperer les noms des champs
for ($i = 0; $i < $nfields; ++$i) $fields[$i] = mysql_field_name($result, $i);
while ($row = mysql_fetch_row($result)) {
$string .= build_begin_tag($type) . "\n";
// Exporter les champs de la table
for ($i = 0; $i < $nfields; ++$i) {
$string .= '<'.$fields[$i].'>' . text_to_xml($row[$i]) . '' . "\n";
}
// Exporter les relations
if ($type == 'article') {
$query = 'SELECT id_auteur FROM spip_auteurs_articles WHERE id_article='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_auteur'] . '' . "\n";
}
mysql_free_result($res2);
$query = 'SELECT id_document FROM spip_documents_articles WHERE id_article='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_document'] . '' . "\n";
}
mysql_free_result($res2);
}
else if ($type == 'message') {
$query = 'SELECT id_auteur FROM spip_auteurs_messages WHERE id_message='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_auteur'] . '' . "\n";
}
mysql_free_result($res2);
}
else if ($type == 'breve') {
$query = 'SELECT id_document FROM spip_documents_breves WHERE id_breve='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_document'] . '' . "\n";
}
mysql_free_result($res2);
}
else if ($type == 'rubrique') {
$query = 'SELECT id_document FROM spip_documents_rubriques WHERE id_rubrique='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_document'] . '' . "\n";
}
mysql_free_result($res2);
$query = 'SELECT id_auteur FROM spip_auteurs_rubriques WHERE id_rubrique='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_auteur'] . '' . "\n";
}
mysql_free_result($res2);
}
else if ($type == 'auteur') {
$query = 'SELECT id_rubrique FROM spip_auteurs_rubriques WHERE id_auteur='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_rubrique'] . '' . "\n";
}
mysql_free_result($res2);
}
else if ($type == 'mot') {
$query = 'SELECT id_article FROM spip_mots_articles WHERE id_mot='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_article'] . '' . "\n";
}
mysql_free_result($res2);
$query = 'SELECT id_breve FROM spip_mots_breves WHERE id_mot='.$row[0];
$res2 = spip_query($query);
while($row2 = mysql_fetch_array($res2)) {
$string .= '' . $row2['id_breve'] . '' . "\n";
}
mysql_free_result($res2);
$query = 'SELECT id_forum FROM spip_mots_forum WHERE id_mot='.$row[0];
$res3 = spip_query($query);
while($row3 = mysql_fetch_array($res3)) {
$string .= '' . $row3['id_forum'] . '' . "\n";
}
mysql_free_result($res3);
$query = 'SELECT id_rubrique FROM spip_mots_rubriques WHERE id_mot='.$row[0];
$res4 = spip_query($query);
while($row4 = mysql_fetch_array($res4)) {
$string .= '' . $row4['id_rubrique'] . '' . "\n";
}
mysql_free_result($res4);
$query = 'SELECT id_syndic FROM spip_mots_syndic WHERE id_mot='.$row[0];
$res4 = spip_query($query);
while($row4 = mysql_fetch_array($res4)) {
$string .= '' . $row4['id_syndic'] . '' . "\n";
}
mysql_free_result($res4);
}
$string .= build_end_tag($type) . "\n\n";
if ($file) {
$_fputs($file, $string);
$string = '';
}
}
mysql_free_result($result);
if (!$file) return $string;
}
else if ($etape_actuelle < $etape_en_cours) {
echo " $nom_etape";
} else {
echo " $nom_etape";
}
}
?>