<?php
/*
Template Name: Resoconto Utenti per "Mi Piace"
*/
$uri = $_SERVER['REQUEST_URI'];
//$totalPosts = str_replace("/","",str_replace("/ultime-news-","",$uri));
$totalPosts = $_GET['num'];
$current_user = wp_get_current_user();
$bannerLaterale =  $wpdb->get_var( "SELECT immagine FROM wp_plugin_atalantini_banner where tipo = 'QUADRATO'" );

?>
<?php get_header(); ?>
	<div class="page-content">
		<div class="row clearfix">
				<div class="grid_12 alpha">
					<div class="grid_9 omega posts">
		<?php
                $sql = "select username as user_login, likes as conteggio from wp_plugin_likedislike order by likes desc";
                $players = $wpdb->get_results($sql);
		?>
                <div class="row clearfix">
                    <div class="grid_4 omega">
			<h1>Utenti per "Mi piace": </h1>
                    </div>
                </div><!-- /post day --> 
                <div class="row clearfix">
		<?php
		$pos = 1;
                foreach ( $players as $player )  {
			$likes =  $player->conteggio;
		?>
                    <div class="grid_12">
			 <div class="title_bucomment" style="height:51px;">
			       <b><div style="float:left;margin-left:10px; margin-top:10px; font-size:23px;"><a href="/commenti-per-utente/?user_login=<?= $player->user_login ?>"><span class="authorcomment"><?= $pos ?>) <?= $player->user_login ?> - Piace: <?= $likes ?></span></a></div></b> <br>
			    </div>
		    </div>
		<?php
			$pos++;
		}
		?>
		</div><!-- /post day -->
					</div><!-- /grid11 -->
				</div><!-- /grid12 -->
			</div><!-- /row -->
		</div><!-- /end page content -->
<?php get_footer(); ?>

<script>

function seePlayer(id) {
	<?= $javascript ?>
	jQuery('#player_' + id).css('display','block');
	location.href = "#player_" + id; 
}

</script>