| Nombre | Fecha | Ingles | Euskera |
|---|
\n";
while ($r = mysqli_fetch_array($q)){
echo "
| $r[title_es] | ";
echo("$r[dat] | ");
$total = 2; //Title and text are mandatory
$translated_en = 0;
$translated_eu = 0;
//Calculate field number
if ($r['title_en'] != $r['title_es']){
$translated_en ++;
}
if ($r['title_eu'] != $r['title_es']){
$translated_eu ++;
}
if ($r['text_en'] != $r['text_es']){
$translated_en ++;
}
if ($r['text_eu'] != $r['text_es']){
$translated_eu ++;
}
if (strlen($r['after_es']) > 0){
$total ++;
if ($r['after_en'] != $r['after_es']){
$translated_en ++;
}
if ($r['after_eu'] != $r['after_es']){
$translated_eu ++;
}
}
$q_i = mysqli_query($con, "SELECT * FROM activity_itinerary WHERE activity = $r[id]");
while ($r_i = mysqli_fetch_array($q_i)){
$total ++;
if ($r_i['title_en'] != $r_i['title_es']){
$translated_en ++;
}
if ($r_i['title_eu'] != $r_i['title_es']){
$translated_eu ++;
}
if (strlen($r_i['description_es']) > 0){
$total ++;
if ($r_i['description_en'] != $r_i['description_es']){
$translated_en ++;
}
if ($r_i['description_eu'] != $r_i['description_es']){
$translated_eu ++;
}
}
}
//Calculate percents
echo "" . intval($translated_en * 100 / $total) . "% | " . intval($translated_eu * 100 / $total) . "% |
\n";
}
echo "\n";
?>