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.
$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"/>';
}