\n"; echo "\n"; $q_user = mysqli_query($con, "SELECT username FROM user WHERE id = $r[user];"); $r_user = mysqli_fetch_array($q_user); echo "\n\n\n"; } ?>

Titulo	Texto	Detalles	Traducciones	Accion
" . cutText($r['title_es'], 35, '', '') . "	" . str_replace(' ', ' ', cutText($r['text_es'], 60, '', '')) . "\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 "	$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"; //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 \n"; echo ""; echo " \n\n "; echo "