| Titulo | Texto | Detalles | Traducciones | Accion | " . cutText($r['title_es'], 35, '', '') . " | \n" . cutText($r['text_es'], 80, '', '') . "\n";
$q_image = mysqli_query($con, "SELECT image FROM post_image WHERE post = $r[id] ORDER BY idx;");
if (mysqli_num_rows($q_image) > 0){
echo " "; while ($r_image = mysqli_fetch_array($q_image)) echo "  \n";
}
echo " | \n";
$q_user = mysqli_query($con, "SELECT username FROM user WHERE id = $r[user];");
$r_user = mysqli_fetch_array($q_user);
echo "$r[ptime] Por $r_user[username] Comentarios:"; if ($r['comments'] == 1){ $q_comments = mysqli_query($con, "SELECT id FROM post_comment WHERE post = $r[id];"); echo "Si (" . mysqli_num_rows($q_comments) . ")"; } else echo "No"; echo " Visible: "; if ($r['visible'] == 1) echo "Si"; else echo "No"; echo " | \n\n"; //TODO percent
$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 ++;
}
//Calculate percents
echo "Inglés: " . intval($translated_en * 100 / $total) . "% Euskera: " . intval($translated_eu * 100 / $total) . "%\n"; echo "\n | \n\n\n"; echo ""; echo ""; echo ""; echo " | \n"; } ?>
|---|