<?php
######## PAGINADOR #########
$paginador=mysql_query("SELECT t1.slug AS slug, t1.term_id AS term_id, t2.object_id AS object_id, t2.term_taxonomy_id AS term_taxonomy_id, t3.ID AS ID, t3.post_title AS post_title, t3.post_date AS post_date, t3.post_name AS post_name, t3.post_type AS post_type, t4.meta_key AS meta_key, t4.meta_value AS meta_value, t4.post_id AS post_id FROM utf8terms AS t1 INNER JOIN utf8term_relationships AS t2 INNER JOIN utf8posts AS t3 INNER JOIN utf8postmeta AS t4 ON (t2.object_id = t3.ID && t2.term_taxonomy_id = t1.term_id && t3.post_type = 'post' && t3.ID = t4.post_id && t4.meta_key = 'thumbnail') WHERE post_status= 'publish' GROUP BY t3.post_name",$conexion);
$totalnoticas = mysql_num_rows($paginador);
$paginas= $totalnoticias/10;
$paginas = floor($paginas+1);
echo '<div class="wp-pagenavi">';
for ( $i = 1 ; $i <= $paginas ; $i ++) {
if ($i == 1) {
echo '<a href="http://midominio.com/">'.$i.'</a>';
} else {
if ($i == $pag) {
echo '<a title="Pagina '.$i.'" href="http://midominio.com/page/'.$i.'/">'.$i.'</a>'."\n";
} else {
echo '<a title="Pagina '.$i.'" href="http://midominio.com/page/'.$i.'/" class="page">'.$i.'</a>'."\n";
}
}
}
echo '</div>';
?>