Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Modulo Salon de la Fama  (Visto 735 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline humito Posteado: May 28, 2017, 07:09:07 PM

  • 0 puntos por ventas
  • *
  • Rank: Liga mayor
  • Posts: 194
  • Gracias recibida: 349
  • ar
Buenas noches!.
Alguien me podria ayudar para modificar el Modulo salon de la Fama para que sea acumulativo y no se resetee.
Desde ya muchas gracias.
MuCore
MuEmu.
Code: [Select]
<html>
<head>
<style type="text/css">
.marco1 {
    margin: 10px 0px 0px 0px;
border-radius:8px;
border: 1px solid #2a2a2a;
background-color: #000000;
opacity: 0.7;
padding: 5px;
color: #ffffff;
padding-bottom: 24px;
}
.encabezadin {
background-color: #0f0f0f;
padding:1px;
border-radius: 5px;
border:1px solid #2a2a2a;
}
h3 {
font-size: 12px;
}
h2 {
font-size: 15px;
}
h5.anubisrank {
font-size:15px;
}
.posted {
float: right;
font-size:9px;
background-color: #0f0f0f;
padding:2px 3px 1px 3px;
border-radius: 5px;
border:1px solid #2a2a2a;
}
.encabezaditu {
background-color: #0f0f0f;
padding:5px;
border-radius: 5px;
border:1px solid #2a2a2a;
margin: 0px auto;
}
.encabezaditu2 {
background-color: #0f0f0f;
padding:1px;
border-radius: 5px;
border:1px solid #2a2a2a;
margin: 3px auto;
text-align:center;
}
.halloffame {
border: 1px solid #2a2a2a;
border-radius: 6px;
padding:3px;
background-color: #000000;
margin-top:10px;
}
.colspan_hall {
background-color: #171515;
border:1px solid #2a2a2a;
border-radius:6px;
text-align:center;
font-size:16px;
}
.colspan_hallss {
background-color: #171515;
border:1px solid #2a2a2a;
border-radius:6px;
}
.anubis_crown {
background-image:url("template/<?=$core['config']['template'] ?>/images/anubis_crown.png");
background-repeat: no-repeat;
width: 100px;
height:67px;
margin: 3px auto;
}
</style>
</head>
<body>
<div class="marco1">
<div class="encabezaditu">
<!--- <h3 class="encabezaditu2" style="margin-bottom:10px;">"The Hall of Fame" o "El Salon de la Fama"</h3> --->
<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">PERSONAJE CON MAS RESETS:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$querys=mssql_query("select TOP 1 * from MuOnline.dbo.Character Where ctlcode !='32' and ctlcode !='8' order by Resets desc, cLevel desc");
while($row=mssql_fetch_assoc($querys)){
$names=$row['Name'];
$resets=$row['Resets'];
?>
<h5 class="anubisrank">Nombre del Personaje: <?=$names;?></h5>
<h5 class="anubisrank">Cantidad de Resets: <?=$resets; } ?></h5>
</td>
</tr>
</table>
<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">GUILD CON MAS PUNTOS:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$consulta=mssql_query("select TOP 1 * from MuOnline.dbo.Guild order by G_Score desc");
while($row=mssql_fetch_assoc($consulta)){
$nombre=$row['G_Name'];
$score=$row['G_Score'];
$master=$row['G_Master']
?>
<h5 class="anubisrank">Nombre del Guild: <?=$nombre;?></h5>
<h5 class="anubisrank">Master del Guild: <?=$master;?></h5>
<h5 class="anubisrank">Cantidad de Puntos: <?=$score; } ?></h5>
</td>
</tr>
</table>

<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">PERSONAJE MAS ASESINO:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$consultita=mssql_query("select TOP 1 * from MuOnline.dbo.Character order by PkCount desc");
while($row=mssql_fetch_assoc($consultita)) {
$namepj=$row['Name'];
$muertes=$row['PkCount'];
?>
<h5 class="anubisrank">Nombre del Asesino: <?=$namepj;?></h5>
<h5 class="anubisrank">Cantidad de Muertes: <?=$muertes; } ?></h5>
</td>
</tr>
</table>
<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">PERSONAJE MAS RICO:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$ricachon=mssql_query("select TOP 1 * from MuOnline.dbo.Character order by Money desc");
while($row=mssql_fetch_assoc($ricachon)){
$millonario=$row['Name'];
$dinero=$row['Money'];
?>
<h5 class="anubisrank">Nombre del Millonario: <?=$millonario;?></h5>
<h5 class="anubisrank">Cantidad de Dinero: <?=$dinero; } ?></h5>
</td>
</tr>
</table>
</div>
 <br>
<h6 class="posted">Mu Volcan</h6>
</div>
</body>
</html>


Offline Xysad #1 Posteado: May 28, 2017, 08:21:27 PM

  • Php Coder
  • 0 puntos por ventas
  • *
  • *
  • Rank: Puto amo
  • Posts: 280
  • Gracias recibida: 1296
  • ar
Mmm, fijate de no estar reseteando vos tu db manualmente (Y).
Code: [Select]
<html>
<head>
<style type="text/css">
.marco1 {
    margin: 10px 0px 0px 0px;
border-radius:8px;
border: 1px solid #2a2a2a;
background-color: #000000;
opacity: 0.7;
padding: 5px;
color: #ffffff;
padding-bottom: 24px;
}
.encabezadin {
background-color: #0f0f0f;
padding:1px;
border-radius: 5px;
border:1px solid #2a2a2a;
}
h3 {
font-size: 12px;
}
h2 {
font-size: 15px;
}
h5.anubisrank {
font-size:15px;
}
.posted {
float: right;
font-size:9px;
background-color: #0f0f0f;
padding:2px 3px 1px 3px;
border-radius: 5px;
border:1px solid #2a2a2a;
}
.encabezaditu {
background-color: #0f0f0f;
padding:5px;
border-radius: 5px;
border:1px solid #2a2a2a;
margin: 0px auto;
}
.encabezaditu2 {
background-color: #0f0f0f;
padding:1px;
border-radius: 5px;
border:1px solid #2a2a2a;
margin: 3px auto;
text-align:center;
}
.halloffame {
border: 1px solid #2a2a2a;
border-radius: 6px;
padding:3px;
background-color: #000000;
margin-top:10px;
}
.colspan_hall {
background-color: #171515;
border:1px solid #2a2a2a;
border-radius:6px;
text-align:center;
font-size:16px;
}
.colspan_hallss {
background-color: #171515;
border:1px solid #2a2a2a;
border-radius:6px;
}
.anubis_crown {
background-image:url("template/<?=$core['config']['template'] ?>/images/anubis_crown.png");
background-repeat: no-repeat;
width: 100px;
height:67px;
margin: 3px auto;
}
</style>
</head>
<body>
<div class="marco1">
<div class="encabezaditu">
<h3 class="encabezaditu2" style="margin-bottom:10px;">"The Hall of Fame" o "El Salon de la Fama"</h3> --->
<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">PERSONAJE CON MAS RESETS:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$querys=mssql_query("select TOP 1 * from MuOnline.dbo.Character Where ctlcode !='32' and ctlcode !='8' order by Resets desc, cLevel desc");
while($row=mssql_fetch_assoc($querys)){
$names=$row['Name'];
$resets=$row['Resets'];
?>
<h5 class="anubisrank">Nombre del Personaje: <?=$names;?></h5>
<h5 class="anubisrank">Cantidad de Resets: <?=$resets; } ?></h5>
</td>
</tr>
</table>
<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">GUILD CON MAS PUNTOS:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$consulta=mssql_query("select TOP 1 * from MuOnline.dbo.Guild order by G_Score desc");
while($row=mssql_fetch_assoc($consulta)){
$nombre=$row['G_Name'];
$score=$row['G_Score'];
$master=$row['G_Master']
?>
<h5 class="anubisrank">Nombre del Guild: <?=$nombre;?></h5>
<h5 class="anubisrank">Master del Guild: <?=$master;?></h5>
<h5 class="anubisrank">Cantidad de Puntos: <?=$score; } ?></h5>
</td>
</tr>
</table>

<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">PERSONAJE MAS ASESINO:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$consultita=mssql_query("select TOP 1 * from MuOnline.dbo.Character order by PkCount desc");
while($row=mssql_fetch_assoc($consultita)) {
$namepj=$row['Name'];
$muertes=$row['PkCount'];
?>
<h5 class="anubisrank">Nombre del Asesino: <?=$namepj;?></h5>
<h5 class="anubisrank">Cantidad de Muertes: <?=$muertes; } ?></h5>
</td>
</tr>
</table>
<table border="0" cellspacing="5" cellpadding="4" width="100%" class="halloffame">
<tr>
 <td colspan="2" class="colspan_hall">PERSONAJE MAS RICO:</td>
</tr>
<tr>
<td class="colspan_hallss" width="110"><div class="anubis_crown"></div></td>
<td class="colspan_hallss">
<?
$ricachon=mssql_query("select TOP 1 * from MuOnline.dbo.Character order by Money desc");
while($row=mssql_fetch_assoc($ricachon)){
$millonario=$row['Name'];
$dinero=$row['Money'];
?>
<h5 class="anubisrank">Nombre del Millonario: <?=$millonario;?></h5>
<h5 class="anubisrank">Cantidad de Dinero: <?=$dinero; } ?></h5>
</td>
</tr>
</table>
</div>
 <br>
<h6 class="posted">Mu Volcan</h6>
</div>
</body>
</html>


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
5 Replies
3759 Views
Last post January 25, 2018, 08:32:37 PM
by -Rastaa.TSM☢
4 Replies
5231 Views
Last post April 20, 2019, 04:00:14 PM
by muarcontes
9 Replies
1913 Views
Last post May 23, 2019, 08:04:50 PM
by milkaritas
2 Replies
1054 Views
Last post November 22, 2021, 05:06:51 PM
by theexpo2
0 Replies
300 Views
Last post September 04, 2020, 07:24:02 PM
by LuciferXT