Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Muemu s8 error en el modulo para ranking de gens  (Visto 2206 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline jigokush Posteado: November 21, 2016, 11:08:49 PM

  • 0 puntos por ventas
  • *
  • Rank: Avanzado
  • Posts: 127
  • Gracias recibida: 92
  • pe
Buen dia uso files muemu s8 estoy usando los modulos de rank gens de marlon2d el detalle es q no me aparece los puntos para q figure el ranking le dejo la foto y el script q pienso q a de ser para q alguien me lo fixee, gracias uso mucore 1.0.8




Citar
<table width="500" height="206" align="center">

<tr>

<?
                     
$duprian_points=mssql_fetch_row(mssql_query("Select sum(Contribution) from Gens_Rank where Family=1"));
$vanert_points=mssql_fetch_row(mssql_query("Select sum(Contribution) from Gens_Rank where Family=2"));
                    
?>


<td height="23" class="crhis">
            <div class="body"  style="position: relative;top:30px; left:100px"  ><?=$duprian_points[0];?></div>
               <div class="body1" style="position: relative;top:15px; left:390px"  ><?=$vanert_points[0];?></div>
            </td>


</tr>

</table >

<?
$duprian = mssql_query("Select TOP 10 Name,Contribution from Gens_Rank where Family=1 order by Contribution desc");
$vanert = mssql_query("Select TOP 10 Name,Contribution from Gens_Rank where Family=2 order by Contribution desc");

$pocd = mssql_fetch_array(mssql_query("Select Count(*) from Gens_Rank where Family=1"));
$pocv = mssql_fetch_array(mssql_query("Select Count(*) from Gens_Rank where Family=2"));
?>

Ahi el script si falta modificar algo por favor me lo hacen saber muchas gracias :)

Gracias:


Offline ZabiinoOo #1 Posteado: November 21, 2016, 11:11:11 PM

  • MAESTRO

  • US. DE HONOR

  • LEYENDA

  • Administrador
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 7.270
  • Gracias recibida: 125166
  • pe



Prohibido pedir soporte via MP
Leer las reglas de cada seccion
we trust god

Offline jigokush #2 Posteado: November 21, 2016, 11:13:55 PM

  • 0 puntos por ventas
  • *
  • Rank: Avanzado
  • Posts: 127
  • Gracias recibida: 92
  • pe

Offline ZabiinoOo #3 Posteado: November 22, 2016, 12:35:50 AM

  • MAESTRO

  • US. DE HONOR

  • LEYENDA

  • Administrador
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 7.270
  • Gracias recibida: 125166
  • pe
@jigokush para mu emu no hay modulos tendrias que adaptarlo




Prohibido pedir soporte via MP
Leer las reglas de cada seccion
we trust god

Offline comoxs #4 Posteado: November 22, 2016, 07:42:54 AM

  • 0 puntos por ventas
  • *
  • Rank: Dedicado
  • Posts: 41
  • Gracias recibida: 18
  • ve
Buen dia uso files muemu s8 estoy usando los modulos de rank gens de marlon2d el detalle es q no me aparece los puntos para q figure el ranking le dejo la foto y el script q pienso q a de ser para q alguien me lo fixee, gracias uso mucore 1.0.8




Citar
<table width="500" height="206" align="center">

<tr>

<?
                     
$duprian_points=mssql_fetch_row(mssql_query("Select sum(Contribution) from Gens_Rank where Family=1"));
$vanert_points=mssql_fetch_row(mssql_query("Select sum(Contribution) from Gens_Rank where Family=2"));
                    
?>


<td height="23" class="crhis">
            <div class="body"  style="position: relative;top:30px; left:100px"  ><?=$duprian_points[0];?></div>
               <div class="body1" style="position: relative;top:15px; left:390px"  ><?=$vanert_points[0];?></div>
            </td>


</tr>

</table >

<?
$duprian = mssql_query("Select TOP 10 Name,Contribution from Gens_Rank where Family=1 order by Contribution desc");
$vanert = mssql_query("Select TOP 10 Name,Contribution from Gens_Rank where Family=2 order by Contribution desc");

$pocd = mssql_fetch_array(mssql_query("Select Count(*) from Gens_Rank where Family=1"));
$pocv = mssql_fetch_array(mssql_query("Select Count(*) from Gens_Rank where Family=2"));
?>

Ahi el script si falta modificar algo por favor me lo hacen saber muchas gracias :)

podrias dejar el modulo completo para revisarlo porque se ve bien la sentencia sql


Offline jigokush #5 Posteado: November 22, 2016, 10:57:12 AM

  • 0 puntos por ventas
  • *
  • Rank: Avanzado
  • Posts: 127
  • Gracias recibida: 92
  • pe
el original es este

Citar
<style type="text/css">

.crhis {
   background: url(template/<?=$core['config']['template']?>/images/gensranlkingu.png);
  background-size:500px 143px;
  background-repeat:no-repeat;
      color: #FF6600;
   font-weight: bold;
    font-size: 20px;
   -moz-border-radius: 8px 8px 8px 8px;
}

.body {
    color: white;
   font-weight: bold;
    font-size: 14px;

}

.body1 {
    color: white;
   font-weight: bold;
    font-size: 14px;

}


.duprian {
   background: url(template/<?=$core['config']['template']?>/images/Papyrus.png);
  background-size:520px 940px;
  background-repeat:no-repeat;
  height: 800px;
  padding-top:120px;
  padding-left: 20px;
  color: black;
  font-weight:bold;
  display:none;
   
}

.vanert {
   background: url(template/<?=$core['config']['template']?>/images/Papyrus.png);
  background-size:520px 940px;
  background-repeat:no-repeat;
  height: 800px;
  padding-top:120px;
   padding-left: 20px;
  color: black;
  font-weight:bold;
  display:none;
}

</style>

<head>
 <script type="text/javascript">
  top.visible_div_id = 'vanert';
  function toggle_visibility(id) {
     var old_e = document.getElementById(top.visible_div_id);
     var new_e = document.getElementById(id);
     if(old_e) {
        console.log('old', old_e, 'none');
        old_e.style.display = 'none';
     }
    console.log('new', new_e, 'block');
     new_e.style.display = 'block';   
     top.visible_div_id = id;         
  }
  </script>
 
 <? function rank($typ)
    {
      $rank[1]="Grand Duke";
      $rank[2]="Duke";
      $rank[3]="Marquis";
      $rank[4]="Count";
      $rank[5]="Viscount";
      $rank[6]="Baron";
      $rank[7]="Knight Commander";
      $rank[8]="Super Knight";
      $rank[9]="Knight";
      $rank[10]="Guard Perfect";
      $rank[11]="Officer";
      $rank[12]="Lieutenant";
      $rank[13]="Sergeant";
      $rank[14]="Private";
     
      return $rank[$typ];
    }
 
 ?>
 
 
</head>

<body>

<table width="500" height="206" align="center">

<tr>

<?
                     
$duprian_points=mssql_fetch_row(mssql_query("Select sum(Points) from IGC_Gens where Influence=1"));
$vanert_points=mssql_fetch_row(mssql_query("Select sum(Points) from IGC_Gens where Influence=2"));
                    
?>


<td height="23" class="crhis">
            <div class="body"  style="position: relative;top:39px; left:100px"  ><?=$duprian_points[0];?></div>
               <div class="body1" style="position: relative;top:15px; left:390px"  ><?=$vanert_points[0];?></div>
            </td>


</tr>

</table >

<?
$duprian = mssql_query("Select TOP 10 Name,Class,Points from IGC_Gens where Influence=1 order by Points desc");
$vanert = mssql_query("Select TOP 10 Name,Class,Points from IGC_Gens where Influence=2 order by Points desc");

$pocd = mssql_fetch_array(mssql_query("Select Count(*) from IGC_Gens where Influence=1"));
$pocv = mssql_fetch_array(mssql_query("Select Count(*) from IGC_Gens where Influence=2"));
?>

<center>
<span onClick="toggle_visibility('duprian');">
 <img src='gensrank_images/dup.png' />
</span>
&nbsp;
<span onClick="toggle_visibility('vanert');" >
 <img src='gensrank_images/van.png' />
</span>
</center>

<div id="duprian" class="duprian" align="center">
   
          <img src='gensrank_images/duprian.png'/>
          <center>Total Members: <?echo $pocd[0]?></center><br>
          <table width="70%" align="center">
          <tr>
          <td align="center" width="15">#</td>
          <td align="center" width="100">Name</td>
          <td align="center" width="100">Points</td>
          <td align="center" width="100" colspan="2">Rank</td>
          </tr>
          <?
          $i=0;
          while ($row = mssql_fetch_array($duprian))
          {
           $i++;
           echo "
           <tr>
           <td align='center' >".$i."</td>
           <td align='center'>".$row[0]."</td>
           <td align='center'>".$row[2]."</td>
           <td align='right'>".rank($row[1])."</td>
           <td align='left'><img src='gensrank_images/d".$row[1].".png' width='32' height='50'/></td>
           </tr>";
          }
          ?>
          </table>
          </div>
         
       
 <div id="vanert" class="vanert" align="center">         
          <img src='gensrank_images/vanert.png'/>
          <center>Total Members: <?echo $pocv[0]?></center><br>
          <table width="70%" align="center">
          <tr>
          <td align="center"width="15">#</td>
          <td align="center"width="100">Name</td>
          <td align="center"width="100">Points</td>
          <td align="center"width="100" colspan="2">Rank</td>
          </tr>
          <?
          $i=0;
          while ($row1 = mssql_fetch_array($vanert))
          {
           $i++;
           echo "
           <tr>
           <td align='center'>".$i."</td>
           <td align='center'>".$row1[0]."</td>
           <td align='center'>".$row1[2]."</td>
           <td align='right'>".rank($row1[1])."</td>
           <td align='left'><img src='gensrank_images/v".$row1[1].".png' width='32' height='50'/></td>
           </tr>";
          }
          ?>
          </table>
</div>
</body>
</html>



Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
2 Replies
1865 Views
Last post November 21, 2016, 11:05:32 PM
by jigokush
5 Replies
2159 Views
Last post April 09, 2018, 10:45:38 PM
by Stanly
6 Replies
3194 Views
Last post February 20, 2020, 05:59:44 PM
by SaintZeus
2 Replies
1108 Views
Last post November 09, 2018, 07:57:38 AM
by skarious
4 Replies
414 Views
Last post April 09, 2023, 03:29:33 PM
by ZabiinoOo