Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Modulo/Ranking no muestra los Reset/MRreset  (Visto 1496 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline humito Posteado: May 27, 2017, 09:57:12 PM

  • 0 puntos por ventas
  • *
  • Rank: Liga mayor
  • Posts: 194
  • Gracias recibida: 348
  • ar
Hola buenas noches!
Alguien me podria ayudar eh colocado un modulo Ranking pero no muestra los reset ni mrreset alguien me podria ayudar porfavor.

Gracias:


Offline Xysad #1 Posteado: May 27, 2017, 11:12:26 PM

  • Php Coder
  • 0 puntos por ventas
  • *
  • *
  • Rank: Puto amo
  • Posts: 280
  • Gracias recibida: 1294
  • ar
Que web usas? pasame tu modulo .php y decime que base de datos usas, veo si puedo arreglarlo y luego te comento que modificaciones hice.

Gracias:


Offline humito #2 Posteado: May 27, 2017, 11:35:45 PM

  • 0 puntos por ventas
  • *
  • Rank: Liga mayor
  • Posts: 194
  • Gracias recibida: 348
  • ar
Que web usas? pasame tu modulo .php y decime que base de datos usas, veo si puedo arreglarlo y luego te comento que modificaciones hice.


MuCore.
Code: [Select]
<style type="text/css">
h1.entrarmodulos {
height:33px;
margin-left: 1px;
font-family: verdana;
font-size: 17px;
line-height:28px;
color: #ffffff;
position:relative;
background-color: #000000;
opacity: 0.7;
filter:alpha(opacity=70);
padding-top: 3px;
border: 1px solid #535353;
margin-bottom:3px;
border-radius:5px;
}
.themain {
 background-image:url("template/<?=$core['config']['template'] ?>/images/menu_content.jpg");
font-size:11px;
    border: 1px solid #2a2a2a;
    border-radius: 5px;
}

.topp2 {
font-size:11px;
color: #FFFFFF;
font-weight: bold;
background-color: #000000;
    opacity: 0.8;
    filter: alpha(opacity=80);
}

.trhover1 {
    background: #292929;
    color: #b5b5b5;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
.trhovereventos {
    background: #292929;
    color: #FFFFFF;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
.trhover2 {
    background: #393939;
    color: #b5b5b5;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
.trhover3 {
    background: #494949;
    color: #b5b5b5;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
a:link   
{   
 text-decoration:none;   

</style>
<?
////////////////////////////////////////////////////////////////////////////////
//////////////////////////////NOMBRE DE TU SERVIDOR/////////////////////////////
////////////////////////////////////////////////////////////////////////////////
$BrianRoldan['NombreMU'] =  'Mu-Volcan';
////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////FIN///////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////

 if (!isset($_GET['rank'])) {
        $rank_type = 'characters';
    } elseif (isset($_GET['rank'])) {
        $rank_type = safe_input($_GET['rank'], '');
    }
    if (!isset($_GET['class'])) {
        if ($_GET['rank'] == 'guilds') {
            $rank_class_type = 'no_rank_type';
        }
   
echo ' <table align="center" width="69%" border="0" cellspacing="0" cellpadding="0">
  <tr>
  <td><h1 class="entrarmodulos" align="center" style="margin-top: 2px;">RANKING DEL SERVIDOR</h1></td>
  </tr>
  </table>
  <table class="themain" align="center" cellpadding="2" cellspacing="1" width="70%">
<tr><td>
          <table  width="100%" border="0" cellspacing="1" cellpadding="2">
  <tr>';
    switch ($rank_type) {
        case 'characters':
            echo '<td width="50%" align="center" class="trhover3"><span style="color: #999999;">RANKING DE PERSONAJES</span></td>
<td width="50%" align="center" class="trhover3"><a href="' . $core_run_script . '&rank=guilds">RANKING DE CLANES</a></td>

    </tr></table></td></tr></table>';
            break;
        case 'guilds':
            echo ' <td width="50%" align="center" class="trhover3"><a href="' . $core_run_script . '&rank=characters">RANKING DE PERSONAJES</a></td>
<td width="50%" align="center" class="trhover3"><span style="color: #999999;">RANKING DE CLANES</span></td>

    </tr></table></td></tr></table>';
            break;
    }

 switch ($rank_type) {
        case 'characters':
//-------------------------------------------------//
echo "

<table class=\"themain\" align=\"center\" cellpadding=\"2\" cellspacing=\"1\" width=\"70%\">
<tr><td>

          <table  width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">
<tr>
<td width='3%' align='center' class='topp2'>#</td>
<td width='10%' align='center' class='topp2'>Nombre</td>
<td width='15%' align='center' class='topp2'>Raza</td>
<td width='8%' align='center' class='topp2'>Nivel</td>
<td width='7%' align='center' class='topp2'>Resets|GR</td>
<td width='6%' align='center' class='topp2'>Pais</td>
<td width='3%' align='center' class='topp2'>Estado</td>
</tr>";
 //-------------------------------------------------//
$topq = mssql_query("Select ToP 15 name,clevel,class,resets,accountid,grand_resets from character where CtlCode = '0' order by resets desc, clevel desc, grand_resets desc");
for ($i = 0;$i < mssql_num_rows($topq);++$i) {
    $rank = $i + 1;
    $row = mssql_fetch_row($topq);
    if ($row[2] == 0) {
        $row[2] = "Dark Wizard";
    }
    if ($row[2] == 1) {
        $row[2] = "Soul Master";
    }
    if ($row[2] == 2) {
        $row[2] = "Grand Master";
    }
    if ($row[2] == 16) {
        $row[2] = "Dark Knight";
    }
    if ($row[2] == 17) {
        $row[2] = "Blade Knight";
    }
    if ($row[2] == 18) {
        $row[2] = "Blade Master";
    }
    if ($row[2] == 32) {
        $row[2] = "Elf";
    }
    if ($row[2] == 33) {
        $row[2] = "Muse Elf";
    }
    if ($row[2] == 34) {
        $row[2] = "High Elf";
    }
    if ($row[2] == 48) {
        $row[2] = "Magic Gladiator";
    }
    if ($row[2] == 49) {
        $row[2] = "Duel Master";
    }
    if ($row[2] == 50) {
        $row[2] = "Duel Master";
    }
    if ($row[2] == 64) {
        $row[2] = "Dark Lord";
    }
    if ($row[2] == 65) {
        $row[2] = "Lord Emperor";
    }
    if ($row[2] == 66) {
        $row[2] = "Lord Emperor";
    }
    if ($row[2] == 81) {
        $row[2] = "Blood Summoner";
    }
    if ($row[2] == 82) {
        $row[2] = "Dimesion Master";
    }
    if ($row[2] == 96) {
        $row[2] = "Rage Fighter";
    }
    if ($row[2] == 97) {
        $row[2] = "Rage Fighter";
    }
    if ($row[2] == 98) {
        $row[2] = "First Master";
    }
    $statusaq = mssql_query("select * from MEMB_STAT where memb___id='$row[4]' and connectstat='1'");
    $statusa = mssql_num_rows($statusaq);
    if ($statusa != 0) {
        $statusq = mssql_query("select GameIDC From AccountCharacter where Id='$row[4]'");
        $statusr = mssql_fetch_row($statusq);
        if ($statusr[0] == $row[0]) {
            $status = '<img src="template/'.$core['config']['template'].'/images/online.png" align="absmiddle" alt="Conectado" title="Conectado" />';
        }
    } else {
        $status = '<img src="template/'.$core['config']['template'].'/images/offline.png" align="absmiddle" alt="Desconectado" title="Desconectado" />';
    }
    $country_check = "Select country from MEMB_INFO where memb___id='$row[4]'";
    $country_reults = mssql_query($country_check);
    $country = mssql_fetch_row($country_reults);
    for ($numpais = 1;$numpais <= 240;$numpais++) {
        if ($country[0] == $numpais) {
            $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/' . $numpais . '.gif">';
        }
    }
    if ($country[0] == '') {
        $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/desco.png"/>';
    }
    if ($country[0] == '0') {
        $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/desco.png"/>';
    }
//-------------------------------------------------//
    echo "
<tr>
<td width='3%' align='center' class='trhover2'>$rank</td>
<td width='10%' align='center' class='trhover1'>$row[0]</td>
<td width='15%' align='center' class='trhover2'>$row[2]</td>
<td width='8%' align='center' class='trhover1'>$row[1]</td>
    <td width='7%' align='center' class='trhover2'>$row[3]|$row[5]</td>
<td width='6%' align='center' class='trhover1'>$country[0]</td>
<td width='3%' align='center' class='trhover2'>$status</td>
</tr>
";
}
?>
  </table>
  </td></tr>
</table>
<br />
<table class="themain" align="center" cellpadding="2" cellspacing="1" width="70%"><tr>
<td align="left"><img src="template/<?=$core['config']['template'] ?>/images/00CD8000.gif" align="absmiddle" /></td>
<td align="left"><span class="Estilo3">Aqui tienes una lista de los mejores jugadores de <?=$BrianRoldan['NombreMU'];?>. <br />
No te quedes atras, y ve por el primer puesto del ranking!</b></a><br />
</span></td>
</tr></table>
<br />
<center>

</center>
               
           <?php
            break;
        case 'guilds':
echo "<table class=\"themain\" align=\"center\" cellpadding=\"2\" cellspacing=\"1\" width=\"70%\">
<tr><td>

          <table  width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">
<tr>
<td width='3%' align='center' class='topp2'>#</td>
<td width='13%' align='center' class='topp2'>Clan</td>
<td width='13%' align='center' class='topp2'>Master</td>
<td width='10%' align='center' class='topp2'>Scores</td>
<td width='6%' align='center' class='topp2'>Logo</td>
</tr>";
//-------------------------------------------------//
$sql = ("select TOP 15 * from MuOnline.dbo.guild order by G_Score desc");
$ranki_i=0;
$resultado = mssql_query($sql);
while ($mostrar = mssql_fetch_assoc($resultado)){
$logo=urlencode(bin2hex($mostrar['G_Mark']));
$ranki_i++;
if($mostrar['G_Score'] == ''){ $mostrar['G_Score'] = '0'; }
//-------------------------------------------------//
    echo "
<tr>
<td width='3%'align='center' class='trhover2'>$ranki_i</td>
<td width='13%' align='center' class='trhover1'>".$mostrar['G_Name']."</td>
<td width='13%' align='center' class='trhover2'>".$mostrar['G_Master']."</td>
    <td width='10%' align='center' class='trhover1'>".$mostrar['G_Score']."</td>
<td width='6%' align='center' class='trhover2'><img src='Fix BrianDesign/logo.php?decode=".$logo."' alt='Logo del Clan' title='Logo del Clan' width='17' height='17' style='border: 1px solid #2a2a2a; background-color:#000000;' align='absmiddle' /></td>
</tr>
";
}
?>
  </table>
  </td></tr>
</table>
<br />
<table class="themain" align="center" cellpadding="2" cellspacing="1" width="70%"><tr>
<td align="left"><img src="template/<?=$core['config']['template'] ?>/images/00CD8000.gif" align="absmiddle" /></td>
<td align="left"><span class="Estilo3">Aqui tienes una lista de los mejores clanes de <?=$BrianRoldan['NombreMU'];?>.<br />
No te quedes atras, y ve por el primer puesto del ranking!</b></a><br />
</span></td>
</tr></table><br />
<center>

</center>

            <?php break;
    }   
}
?>

Gracias:


Offline Xysad #3 Posteado: May 28, 2017, 03:01:49 AM

  • Php Coder
  • 0 puntos por ventas
  • *
  • *
  • Rank: Puto amo
  • Posts: 280
  • Gracias recibida: 1294
  • ar
toma, proba esto, voy a asumir que usas files muemu. Lo unico que hice fue cambiar las filas resets y master_resets por resetcount y masterresetcount

Code: [Select]
<style type="text/css">
h1.entrarmodulos {
height:33px;
margin-left: 1px;
font-family: verdana;
font-size: 17px;
line-height:28px;
color: #ffffff;
position:relative;
background-color: #000000;
opacity: 0.7;
filter:alpha(opacity=70);
padding-top: 3px;
border: 1px solid #535353;
margin-bottom:3px;
border-radius:5px;
}
.themain {
 background-image:url("template/<?=$core['config']['template'] ?>/images/menu_content.jpg");
font-size:11px;
    border: 1px solid #2a2a2a;
    border-radius: 5px;
}

.topp2 {
font-size:11px;
color: #FFFFFF;
font-weight: bold;
background-color: #000000;
    opacity: 0.8;
    filter: alpha(opacity=80);
}

.trhover1 {
    background: #292929;
    color: #b5b5b5;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
.trhovereventos {
    background: #292929;
    color: #FFFFFF;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
.trhover2 {
    background: #393939;
    color: #b5b5b5;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
.trhover3 {
    background: #494949;
    color: #b5b5b5;
    opacity: 0.8;
    filter: alpha(opacity=80);
}
a:link   
{   
 text-decoration:none;   

</style>
<?
////////////////////////////////////////////////////////////////////////////////
//////////////////////////////NOMBRE DE TU SERVIDOR/////////////////////////////
////////////////////////////////////////////////////////////////////////////////
$BrianRoldan['NombreMU'] =  'Mu-Volcan';
////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////FIN///////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////

 if (!isset($_GET['rank'])) {
        $rank_type = 'characters';
    } elseif (isset($_GET['rank'])) {
        $rank_type = safe_input($_GET['rank'], '');
    }
    if (!isset($_GET['class'])) {
        if ($_GET['rank'] == 'guilds') {
            $rank_class_type = 'no_rank_type';
        }
   
echo ' <table align="center" width="69%" border="0" cellspacing="0" cellpadding="0">
  <tr>
  <td><h1 class="entrarmodulos" align="center" style="margin-top: 2px;">RANKING DEL SERVIDOR</h1></td>
  </tr>
  </table>
  <table class="themain" align="center" cellpadding="2" cellspacing="1" width="70%">
<tr><td>
          <table  width="100%" border="0" cellspacing="1" cellpadding="2">
  <tr>';
    switch ($rank_type) {
        case 'characters':
            echo '<td width="50%" align="center" class="trhover3"><span style="color: #999999;">RANKING DE PERSONAJES</span></td>
<td width="50%" align="center" class="trhover3"><a href="' . $core_run_script . '&rank=guilds">RANKING DE CLANES</a></td>

    </tr></table></td></tr></table>';
            break;
        case 'guilds':
            echo ' <td width="50%" align="center" class="trhover3"><a href="' . $core_run_script . '&rank=characters">RANKING DE PERSONAJES</a></td>
<td width="50%" align="center" class="trhover3"><span style="color: #999999;">RANKING DE CLANES</span></td>

    </tr></table></td></tr></table>';
            break;
    }

 switch ($rank_type) {
        case 'characters':
//-------------------------------------------------//
echo "

<table class=\"themain\" align=\"center\" cellpadding=\"2\" cellspacing=\"1\" width=\"70%\">
<tr><td>

          <table  width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">
<tr>
<td width='3%' align='center' class='topp2'>#</td>
<td width='10%' align='center' class='topp2'>Nombre</td>
<td width='15%' align='center' class='topp2'>Raza</td>
<td width='8%' align='center' class='topp2'>Nivel</td>
<td width='7%' align='center' class='topp2'>Resets|GR</td>
<td width='6%' align='center' class='topp2'>Pais</td>
<td width='3%' align='center' class='topp2'>Estado</td>
</tr>";
 //-------------------------------------------------//
$topq = mssql_query("Select ToP 15 name,clevel,class,resetcount,accountid,masterresetcount from character where CtlCode = '0' order by resetcount desc, clevel desc, masterresetcount desc");
for ($i = 0;$i < mssql_num_rows($topq);++$i) {
    $rank = $i + 1;
    $row = mssql_fetch_row($topq);
    if ($row[2] == 0) {
        $row[2] = "Dark Wizard";
    }
    if ($row[2] == 1) {
        $row[2] = "Soul Master";
    }
    if ($row[2] == 2) {
        $row[2] = "Grand Master";
    }
    if ($row[2] == 16) {
        $row[2] = "Dark Knight";
    }
    if ($row[2] == 17) {
        $row[2] = "Blade Knight";
    }
    if ($row[2] == 18) {
        $row[2] = "Blade Master";
    }
    if ($row[2] == 32) {
        $row[2] = "Elf";
    }
    if ($row[2] == 33) {
        $row[2] = "Muse Elf";
    }
    if ($row[2] == 34) {
        $row[2] = "High Elf";
    }
    if ($row[2] == 48) {
        $row[2] = "Magic Gladiator";
    }
    if ($row[2] == 49) {
        $row[2] = "Duel Master";
    }
    if ($row[2] == 50) {
        $row[2] = "Duel Master";
    }
    if ($row[2] == 64) {
        $row[2] = "Dark Lord";
    }
    if ($row[2] == 65) {
        $row[2] = "Lord Emperor";
    }
    if ($row[2] == 66) {
        $row[2] = "Lord Emperor";
    }
    if ($row[2] == 81) {
        $row[2] = "Blood Summoner";
    }
    if ($row[2] == 82) {
        $row[2] = "Dimesion Master";
    }
    if ($row[2] == 96) {
        $row[2] = "Rage Fighter";
    }
    if ($row[2] == 97) {
        $row[2] = "Rage Fighter";
    }
    if ($row[2] == 98) {
        $row[2] = "First Master";
    }
    $statusaq = mssql_query("select * from MEMB_STAT where memb___id='$row[4]' and connectstat='1'");
    $statusa = mssql_num_rows($statusaq);
    if ($statusa != 0) {
        $statusq = mssql_query("select GameIDC From AccountCharacter where Id='$row[4]'");
        $statusr = mssql_fetch_row($statusq);
        if ($statusr[0] == $row[0]) {
            $status = '<img src="template/'.$core['config']['template'].'/images/online.png" align="absmiddle" alt="Conectado" title="Conectado" />';
        }
    } else {
        $status = '<img src="template/'.$core['config']['template'].'/images/offline.png" align="absmiddle" alt="Desconectado" title="Desconectado" />';
    }
    $country_check = "Select country from MEMB_INFO where memb___id='$row[4]'";
    $country_reults = mssql_query($country_check);
    $country = mssql_fetch_row($country_reults);
    for ($numpais = 1;$numpais <= 240;$numpais++) {
        if ($country[0] == $numpais) {
            $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/' . $numpais . '.gif">';
        }
    }
    if ($country[0] == '') {
        $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/desco.png"/>';
    }
    if ($country[0] == '0') {
        $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/desco.png"/>';
    }
//-------------------------------------------------//
    echo "
<tr>
<td width='3%' align='center' class='trhover2'>$rank</td>
<td width='10%' align='center' class='trhover1'>$row[0]</td>
<td width='15%' align='center' class='trhover2'>$row[2]</td>
<td width='8%' align='center' class='trhover1'>$row[1]</td>
    <td width='7%' align='center' class='trhover2'>$row[3]|$row[5]</td>
<td width='6%' align='center' class='trhover1'>$country[0]</td>
<td width='3%' align='center' class='trhover2'>$status</td>
</tr>
";
}
?>
  </table>
  </td></tr>
</table>
<br />
<table class="themain" align="center" cellpadding="2" cellspacing="1" width="70%"><tr>
<td align="left"><img src="template/<?=$core['config']['template'] ?>/images/00CD8000.gif" align="absmiddle" /></td>
<td align="left"><span class="Estilo3">Aqui tienes una lista de los mejores jugadores de <?=$BrianRoldan['NombreMU'];?>. <br />
No te quedes atras, y ve por el primer puesto del ranking!</b></a><br />
</span></td>
</tr></table>
<br />
<center>

</center>
               
           <?php
            break;
        case 'guilds':
echo "<table class=\"themain\" align=\"center\" cellpadding=\"2\" cellspacing=\"1\" width=\"70%\">
<tr><td>

          <table  width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"2\">
<tr>
<td width='3%' align='center' class='topp2'>#</td>
<td width='13%' align='center' class='topp2'>Clan</td>
<td width='13%' align='center' class='topp2'>Master</td>
<td width='10%' align='center' class='topp2'>Scores</td>
<td width='6%' align='center' class='topp2'>Logo</td>
</tr>";
//-------------------------------------------------//
$sql = ("select TOP 15 * from MuOnline.dbo.guild order by G_Score desc");
$ranki_i=0;
$resultado = mssql_query($sql);
while ($mostrar = mssql_fetch_assoc($resultado)){
$logo=urlencode(bin2hex($mostrar['G_Mark']));
$ranki_i++;
if($mostrar['G_Score'] == ''){ $mostrar['G_Score'] = '0'; }
//-------------------------------------------------//
    echo "
<tr>
<td width='3%'align='center' class='trhover2'>$ranki_i</td>
<td width='13%' align='center' class='trhover1'>".$mostrar['G_Name']."</td>
<td width='13%' align='center' class='trhover2'>".$mostrar['G_Master']."</td>
    <td width='10%' align='center' class='trhover1'>".$mostrar['G_Score']."</td>
<td width='6%' align='center' class='trhover2'><img src='Fix BrianDesign/logo.php?decode=".$logo."' alt='Logo del Clan' title='Logo del Clan' width='17' height='17' style='border: 1px solid #2a2a2a; background-color:#000000;' align='absmiddle' /></td>
</tr>
";
}
?>
  </table>
  </td></tr>
</table>
<br />
<table class="themain" align="center" cellpadding="2" cellspacing="1" width="70%"><tr>
<td align="left"><img src="template/<?=$core['config']['template'] ?>/images/00CD8000.gif" align="absmiddle" /></td>
<td align="left"><span class="Estilo3">Aqui tienes una lista de los mejores clanes de <?=$BrianRoldan['NombreMU'];?>.<br />
No te quedes atras, y ve por el primer puesto del ranking!</b></a><br />
</span></td>
</tr></table><br />
<center>

</center>

            <?php break;
    }   
}
?>

Gracias:


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
5 Replies
2407 Views
Last post January 25, 2017, 12:28:52 AM
by ZabiinoOo
13 Replies
2341 Views
Last post February 25, 2022, 12:24:15 AM
by rexarjdp
5 Replies
1180 Views
Last post June 15, 2020, 05:50:35 PM
by saikano2020
0 Replies
524 Views
Last post August 09, 2020, 10:01:33 AM
by chuvito
0 Replies
350 Views
Last post November 02, 2022, 01:31:49 AM
by Neodiller