Autor Topic: Ayuda con tops de ranking mucore + muemu  (Visto 91 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline Nexus on: July 25, 2018, 09:01:32 PM

  • *
  • Rank: Puto amo
  • Posts: 265
  • Gracias recibida: 208
Hola mi gente bella, hoy vengo a hacerles una pregunta que me ha matado la cabeza, necesito poner que en mi ranking mucore, el orden de los tops, tambien dependa del masterlevel, uso un ranking aportado aqui mismo en tuservermu y files muemu,  la query es la siguiente

Select ToP 25 name,clevel,class,resetcount,accountid,grand_resets from character where CtlCode = '0' order by resetcount desc, clevel desc, grand_resets desc

pero como saben, (MasterLevel from MasterSkillTree) la columna masterlevel se encuentra en la tabla masterskilltree y no puedo llamarla para que me organice los tops de no solo por  resets o nivel si no tambien por masterlevel



quisiera que alguien me pudiera indicar que puedo hacer para poder lograr que tambien me organice el top por el masternivel de mayor a menor, muchas gracias


dejo el codigo por si alguien sabe como ayudarme.


Code: [Select]
$topq = mssql_query("Select ToP 25 name,clevel,class,resetcount,accountid,grand_resets from character where CtlCode = '0' order by resetcount 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);

$vipquery="Select AccountLevel from MEMB_INFO where memb___id='$row[4]'";
$vpquery=mssql_query($vipquery);
$country_vip = mssql_fetch_row($vpquery);

$masterlevel = "select MasterLevel from MasterSkillTree where name = '$row[0]'";
$busca_ml = mssql_query($masterlevel);
$busco_ml = mssql_fetch_row($busca_ml);

if ($country_vip[0] == '0') {
            $country_vip[0] = 'X';
        }
if ($country_vip[0] == '1') {
            $country_vip[0] = '<img src="template/'.$core['config']['template'].'/images/vip/bronze.png" align="absmiddle" alt="VIP Bronze" title="VIP Bronze" />';
        }
if ($country_vip[0] == '2') {
            $country_vip[0] = '<img src="template/'.$core['config']['template'].'/images/vip/silver.png" align="absmiddle" alt="VIP Plata" title="VIP Plata" />';
        }
if ($country_vip[0] == '3') {
            $country_vip[0] = '<img src="template/'.$core['config']['template'].'/images/vip/gold.png" align="absmiddle" alt="VIP Gold" title="VIP Gold" />';
        }

    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/9.gif"/>';
    }
    if ($country[0] == '0') {
        $country[0] = '<img src="template/'.$core['config']['template'].'/images/flags/9.gif"/>';
    }
« Ultima edicion: July 25, 2018, 09:09:14 PM by Nexus »

 

Related Topics

  Subject / Started by Replies Last post
3 Replies
509 Views
Last post October 16, 2016, 02:53:08 PM
by comoxs
1 Replies
214 Views
Last post May 24, 2017, 07:05:18 PM
by FrancoB
9 Replies
521 Views
Last post July 29, 2017, 04:14:03 PM
by unico
1 Replies
534 Views
Last post May 02, 2018, 09:49:54 AM
by skarious
2 Replies
107 Views
Last post July 16, 2018, 09:34:53 PM
by OneMU