Salón de la fama actúal

[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.