[insert_php]
function filtra($string) {
for ($i=0;$i48) {
break;
}
elseif ($org=48) {
$chr = » «;
$string{$i} = $chr;
}
}
return $string;
}
[/insert_php]

Valores totales

[insert_php]
global $wpdb;

$consulta = «SELECT SUM(winis) AS Winis, SUM(tickets) AS Tickets, SUM(lingotes) AS Lingotes, SUM(diamantes) AS Diamantes, SUM(fichas) AS Fichas, SUM(llaves) AS Llaves, SUM(maldiciones) AS Maldiciones, SUM(botes) AS Botes FROM usuarios»;
$resultados = $wpdb->get_results( $consulta );
foreach ( $resultados as $fila ) {
$winis = filtra($fila->Winis);
if ($winis > 0) {
$winis = number_format($winis, 0, ‘,’, ‘.’);
}
$tickets = filtra($fila->Tickets);
if ($tickets > 0) {
$tickets = number_format($tickets, 0, ‘,’, ‘.’);
}
$lingotes = filtra($fila->Lingotes);
if ($lingotes > 0) {
$lingotes = number_format($lingotes, 0, ‘,’, ‘.’);
}
$diamantes = filtra($fila->Diamantes);
if ($diamantes > 0) {
$diamantes = number_format($diamantes, 0, ‘,’, ‘.’);
}
$fichas = filtra($fila->Fichas);
if ($fichas > 0) {
$fichas = number_format($fichas, 0, ‘,’, ‘.’);
}
$llaves = filtra($fila->Llaves);
if ($llaves > 0) {
$llaves = number_format($llaves, 0, ‘,’, ‘.’);
}
$maldiciones = filtra($fila->Maldiciones);
if ($maldiciones > 0) {
$maldiciones = number_format($maldiciones, 0, ‘,’, ‘.’);
}
$botes = filtra($fila->Botes);
if ($botes > 0) {
$botes = number_format($botes, 0, ‘,’, ‘.’);
}
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
[/insert_php]

Tipo	Total
Wini€uros	‘.$winis.’
Tickets	‘.$tickets.’
Lingotes	‘.$lingotes.’
Diamantes	‘.$diamantes.’
Fichas	‘.$fichas.’
Llaves	‘.$llaves.’
Maldiciones	‘.$maldiciones.’
Botes	‘.$botes.’

Top 3 Wini€uros

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY winis DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$winis = filtra($fila->winis);
if ($winis > 0) {
$winis = number_format($winis, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Wini€ros
‘.$i.’	‘.$fila->username.’	‘.$winis.’

Top 3 Tickets

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY tickets DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$tickets = filtra($fila->tickets);
if ($tickets > 0) {
$tickets = number_format($tickets, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Tickets
‘.$i.’	‘.$fila->username.’	‘.$tickets.’

Top 3 Lingotes

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY lingotes DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$lingotes = filtra($fila->lingotes);
if ($lingotes > 0) {
$lingotes = number_format($lingotes, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Lingotes
‘.$i.’	‘.$fila->username.’	‘.$lingotes.’

Top 3 Diamantes

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY diamantes DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$diamantes = filtra($fila->diamantes);
if ($diamantes > 0) {
$diamantes = number_format($diamantes, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Diamantes
‘.$i.’	‘.$fila->username.’	‘.$diamantes.’

Top 3 Fichas

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY fichas DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$fichas = filtra($fila->fichas);
if ($fichas > 0) {
$fichas = number_format($fichas, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Fichas
‘.$i.’	‘.$fila->username.’	‘.$fichas.’

Top 3 Llaves

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY llaves DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$llaves = filtra($fila->llaves);
if ($llaves > 0) {
$llaves = number_format($llaves, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Llaves
‘.$i.’	‘.$fila->username.’	‘.$llaves.’

Top 3 Botes

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY botes DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$botes = filtra($fila->botes);
if ($botes > 0) {
$botes = number_format($botes, 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Botes
‘.$i.’	‘.$fila->username.’	‘.$botes.’

Top 3 Maldiciones

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM usuarios ORDER BY maldiciones DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$maldiciones = filtra($fila->maldiciones);
if ($maldiciones > 0) {
$maldiciones = number_format($maldiciones , 0, ‘,’, ‘.’);
}
echo ‘

‘;
}
[/insert_php]

#	Nick	Maldiciones
‘.$i.’	‘.$fila->username.’	‘.$maldiciones.’

Top 3 Canales

[insert_php]
global $wpdb;

$consulta = «SELECT * FROM canales ORDER BY lineas DESC LIMIT 3»;
$resultados = $wpdb->get_results( $consulta );
$i = 0;
foreach ( $resultados as $fila ) {
$i++;
$lineas = filtra($fila->lineas);
if ($lineas > 0) {
$lineas = number_format($lineas, 0, ‘,’, ‘.’);
}
echo ‘

#	Canal	Lineas	Estado
‘.$i.’	‘.utf8_decode($fila->canal).’	‘.$lineas.’	Los comentarios están cerrados.