Bilingual site : implementing "Duplicate tree as translation"

<?php

// This code works fine. Run it once and no more before duplicating the node corresponding
// to the original language.

// Prior running the code, save your MODx database for security reasons.
// Also set the correct table prefix by replacing the dbprefix string in the code.
// Also replace the number 22 with the id that was given by MODx to your match_id TV.
   
/* include connexion parameters */
require("db_connexion_params.inc.php");

/* connect the MySql server */
$connexion = mysql_connect($server, $login, $password) or
die("Impossible to connect server $server");
echo "$server server connected<br>";

/* connect the database */
mysql_select_db($db,$connexion) or die("Impossible to connect the $bd database");
echo "$db database connected<br>";

/* select identifiers of all MODx documents */
$table = "dbprefix_site_content";
$field = "id";
$request= "SELECT $field FROM $table";
echo $request;
echo "<br/>";
$result = mysql_query($request);

$table = "dbprefix_site_tmplvar_contentvalues";

while ($row = mysql_fetch_array($result) ) {
  $id = $row["id"];
  $request = "INSERT INTO $table VALUES (DEFAULT, 22, $id, $id)";
  // 22 is here the number of the TV the document identifier shared by all translations of the document
  // for the document with id $id, set value for TV #22 to $id.
  mysql_query($request) or die("Impossible to insert new row in tabale $table");;
  echo "New row inserted with match_id = ".$id ;
  echo "<hr />";
}

echo "Closing MySQL connexion<br>";
mysql_close($connexion) or die("Impossible to close the MySQL connexion.");
echo "MySql connexion closed.";

?>

<?php

$startId='0';
$level='1';

$outerTpl='@CODE:<div class="langbar" align="right">[+wf.wrapper+]</div>';

$rowTpl='@CODE:<a href="Snippet_Output_Here.html" title="[+wf.linktext+]" >[+wf.linktext+]</a>';

$cssTpl = '@CODE:<link rel="stylesheet" media="all" type="text/css" href="assets/snippets/wayfinder/css/LangBar.css" />';

?>

<?php
function ReturnTranslationId ($match_id, $destLang_id) {
  // match_id : value of the match_id TV linking the current document and the translation
  // destLand_id : id of the root document of the destination language
  // match_id_TV : id of the match_id TV 
  
  // 1) Find the id of the match_id TV
  $req = "SELECT id FROM alti_site_tmplvar WHERE name=='match_id';
  $res = mysql_query($req); // return only 1 record
  $match_id_TV = mysql_fetch_row($res); // read the record
  
  // 2) Find all documents with the same match_id value, i.e. known translations.
  $req="SELECT contentid FROM alti_site_tmplvar_contentvalues WHERE (tmplvarid==$match_id_TV AND value==$match_id)";
  $res = mysql_query($req); // return the document identifiers of all known translations.

  // 3) Select the document that is in the language the user expects, i.e. the translation.
  while ($id = mysql_fetch_row($result) ) {
	  // Here we must test if the destination document with id $id
	  // is a child of the destination language root specified by $destLang_id.
	  // In this case, the translation was found, return $id as target $id. (This quits the loop.)
	  // Else loop.
  }
  
  // 4) If no translation was found for the current document$, 
  //    return the id of the homepage for the translation.
  //    This could be improved by checking that $destLang_id is at the first
  //	level of the hierarchy in the document tree.
  return $destLang_id;
  
} 
?>