GasteizkoMargolariak
/
GMWeb


			
				
					
						
						
							123456789101112131415161718192021
							<?php
	include("../functions.php");
	$con = startdb();
?>
<html>
	<head>
	</head>
	<body>
		<?php
			$res_post = mysqli_query($con, "SELECT id FROM post WHERE text_en = text_es OR text_eu = text_es OR text_en IS NULL OR text_eu IS null;");
			$res_activity = mysqli_query($con, "SELECT id FROM activity WHERE text_en = text_es OR text_eu = text_es OR text_en IS NULL OR text_eu IS null;");
			$res_gallery = mysqli_query($con, "SELECT id FROM photo WHERE description_en = description_es OR description_eu = description_es OR description_en IS NULL OR description_eu IS null;");
		?>
		<ul>
			<li><a href="post/">Traducir posts</a> (<?php echo mysqli_num_rows($res_post); ?> posts sin traduccion)</li>
			<li><a href="activities/">Traducir actividades</a> (<?php echo mysqli_num_rows($res_activity); ?> actividades sin traduccion)</li>
			<li><a href="gallery/">Traducir fotos</a> (<?php echo mysqli_num_rows($res_gallery); ?> fotos sin traduccion)</li>
		</ul>
	</body>
</html>