Basic Points Stats v1.4.0 - Page 4

kwpd · 11-08-2014 , 13:28 Re: Basic Points Stats

Quote:

Originally Posted by kruger

I tried to compile your test version - 1.3.7 - and I received the following errors:

which version you are using amxmodx? and tested with version 1.8.2 and 1.8.3

http://i.imgur.com/dED2m0D.png

the version you are using is a test.
I would not recommend using it. because I and not yet made the problem arregrar stats doubles. with the image below and you will know what I mean.

kruger · 11-09-2014 , 05:05 Re: Basic Points Stats

You are right - I was using the old 1.8.1 version after an update now it compiles O.K.

About the duplicates as an workaround you can hide them in php or mysql as duplicate records based on steamid but, of course, this is just a dirty workaround and not a fix...

kruger · 11-11-2014 , 05:08 Re: Basic Points Stats (10/November/2014)

Could you please give an English explanation of what some of the columns in database means if not all of them???

For example: pug_rp, pug_adr, pug_a, tmp_group (what 1,2 ,6 means???), tmp_rp, tmp_a???

kwpd · 11-11-2014 , 12:26 Re: Basic Points Stats (10/November/2014)

Quote:

Originally Posted by kruger

Could you please give an English explanation of what some of the columns in database means if not all of them???

For example: pug_rp, pug_adr, pug_a, tmp_group (what 1,2 ,6 means???), tmp_rp, tmp_a???

pug_rp = Round Play
pug_adr = All Damage per Round
pug_a = Assistance
tmp_group = 1=Terroris 2=CSts 6=Spect

kruger · 11-11-2014 , 19:23 Re: Basic Points Stats (10/November/2014)

Quote:

Originally Posted by kwpd

pug_rp = Round Play
pug_adr = All Damage per Round
pug_a = Assistance
tmp_group = 1=Terroris 2=CSts 6=Spect

Thanks a lot!
You rock!

kruger · *Last edited by kruger; 11-14-2014 at 12:25.*

One thing that I noticed:

In your screenshots "pug_rws" is a floating point value but in the sql script for the database install you define pug_rws as integer: "pug_rws` int(11) DEFAULT NULL" - ???

gonzalosor · 11-14-2014 , 14:25 Re: Basic Points Stats (10/November/2014)

any update?

kwpd · 11-14-2014 , 20:43 Re: Basic Points Stats (10/November/2014)

Quote:

Originally Posted by kruger

One thing that I noticed:

In your screenshots "pug_rws" is a floating point value but in the sql script for the database install you define pug_rws as integer: "pug_rws` int(11) DEFAULT NULL" - ???

previously he had already tried to do. but I saw amxx engines are very limited. I'll try once more. "pug_rws` FLOAT(11,2)
would have to change all three files. sql php and sma

Quote:

Originally Posted by gonzalosor

any update?

The latest is 1.3.8
If I can write well chafing. "pug_rws` FLOAT (11,2)
version 1.3.9 is updated

gonzalosor · 11-15-2014 , 19:12 Re: Basic Points Stats (10/November/2014)

Is there a way you can change theese 3 values, it would look a bit nicer

.

Also, how would BSP plugin know when the match ends so it will popup the temp motd?

kwpd · *Last edited by kwpd; 11-18-2014 at 03:04.*

Quote:

Originally Posted by gonzalosor

Is there a way you can change theese 3 values, it would look a bit nicer

.

Also, how would BSP plugin know when the match ends so it will popup the temp motd?

no need to change the registry. That depends on how the query is done by php

next update web 1.0.4
change change change

PHP Code:


			
<?php 
require 'Ranking/config.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Stats pug</title>
<style type="text/css">
<!--
.style3 {
    font-size: 12px;
    color: #000000;
}
.style4 {
    font-size: 12px;
    color: #333333;
}
.style5 {
    font-size: 12px;
    color: #517099;
}
.style43 {font-size: 12px}
.style46 {font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 14; color: #000000; }
.style47 {font-size: 12px; color: #000000; }
.style1 {color: #666666}
.style44 {color: #148234;
    font-weight: bold;
    font-size: 12px;
}
.style48 {    font-size: 12px;
    color: #517099;
}
-->
</style>
</head>
<body>
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#B8B8B8">
  <tr>
    <td><table border="1" cellpadding="0" cellspacing="5" bordercolor="#F0F0F0">
      <tr>
        <td height="30" bgcolor="#F0F0F0"><strong class="style43">Match Awards:</strong></td>
      </tr>
      <tr>
        <td><table border="1" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0">
            <tr>
              <td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Deadly</span></td>
              <td align="left" valign="top">
<?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players1[]=$b;
}
?><table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players1 as $player1){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player1["nick"]?></span></td>
  </tr>
  <?php }?>
</table>
</td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Professional</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players2[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players2 as $player2){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player2["nick"]?></span></td>
  </tr>
  <?php }?>
</table>
</td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Most Honorable</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players3[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players3 as $player3){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player3["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style47">&nbsp;</td>
              <td width="400" align="left" valign="middle">&nbsp;</td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Most Dishonorable</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players4[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players4 as $player4){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player4["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Most Cowardly</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players5[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players5 as $player5){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player5["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Mostly Harmless</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players6[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players6 as $player6){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player6["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
        </table></td>
      </tr>
    </table>
      <table border="0" cellspacing="5" cellpadding="0">
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td><table border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td height="30"><span class="style43"><strong>Team  A Statistics</strong></span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
              <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
            </tr>
          </table>
            <table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
              <tr bordercolor="#F0F0F0">
                <th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
              </tr>
              <?php
$busca="1";
if($busca!="2"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
              <?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
            </table>
          <p></p></td>
        </tr>
        <tr>
          <td><table border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td height="30"><span class="style43"><strong>Team  B Statistics</strong></span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
              <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
            </tr>
          </table>
            <table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
              <tr bordercolor="#F0F0F0">
                <th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
              </tr>
              <?php
$busca="2";
if($busca!="1"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
              <?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
            </table>
            <p>&nbsp;</p></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html><?php 
require 'Ranking/config.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Stats pug</title>
<style type="text/css">
<!--
.style3 {
    font-size: 12px;
    color: #000000;
}
.style4 {
    font-size: 12px;
    color: #333333;
}
.style5 {
    font-size: 12px;
    color: #517099;
}
.style43 {font-size: 12px}
.style46 {font-family: "Times New Roman", Times, serif; font-weight: bold; font-size: 14; color: #000000; }
.style47 {font-size: 12px; color: #000000; }
.style1 {color: #666666}
.style44 {color: #148234;
    font-weight: bold;
    font-size: 12px;
}
.style48 {    font-size: 12px;
    color: #517099;
}
-->
</style>
</head>
<body>
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#B8B8B8">
  <tr>
    <td><table border="1" cellpadding="0" cellspacing="5" bordercolor="#F0F0F0">
      <tr>
        <td height="30" bgcolor="#F0F0F0"><strong class="style43">Match Awards:</strong></td>
      </tr>
      <tr>
        <td><table border="1" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0">
            <tr>
              <td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Deadly</span></td>
              <td align="left" valign="top">
<?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players1[]=$b;
}
?><table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players1 as $player1){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player1["nick"]?></span></td>
  </tr>
  <?php }?>
</table>
</td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43" abbr="NICK"><span class="style46">Most Professional</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players2[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players2 as $player2){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player2["nick"]?></span></td>
  </tr>
  <?php }?>
</table>
</td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Most Honorable</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a DESC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players3[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players3 as $player3){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player3["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style47">&nbsp;</td>
              <td width="400" align="left" valign="middle">&nbsp;</td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Most Dishonorable</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_rws ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players4[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players4 as $player4){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player4["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Most Cowardly</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_a ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players5[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players5 as $player5){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player5["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
            <tr>
              <td align="left" valign="middle" class="style43"><span class="style46">Mostly Harmless</span></td>
              <td align="left" valign="top"><?php
$sql="SELECT * FROM skillpoints_pug1 ORDER BY tmp_k ASC LIMIT 1";
$db=mysql_query($sql);
while($b=mysql_fetch_array($db, MYSQL_ASSOC)) {        
    $players6[]=$b;
}
?>
<table border="0" align="left" cellpadding="0" cellspacing="0" id="mytable">
  <tr></tr>
  <?php $i=0;foreach($players6 as $player6){$i++;?>
  <tr>
    <td align="left" valign="top"><span class="style5"><?php print $player6["nick"]?></span></td>
  </tr>
  <?php }?>
</table></td>
            </tr>
        </table></td>
      </tr>
    </table>
      <table border="0" cellspacing="5" cellpadding="0">
        <tr>
          <td>&nbsp;</td>
        </tr>
        <tr>
          <td><table border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td height="30"><span class="style43"><strong>Team  A Statistics</strong></span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
              <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
            </tr>
          </table>
            <table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
              <tr bordercolor="#F0F0F0">
                <th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
              </tr>
              <?php
$busca="1";
if($busca!="2"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
              <?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
            </table>
          <p></p></td>
        </tr>
        <tr>
          <td><table border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center" valign="middle" bgcolor="#F0F0F0"><table border="1" cellpadding="5" cellspacing="0" bordercolor="#F0F0F0">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="0">
                        <tr>
                          <td height="30"><span class="style43"><strong>Team  B Statistics</strong></span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
              <td align="center" valign="middle"><table border="0" cellspacing="0" cellpadding="5">
                  <tr>
                    <td align="center" valign="middle"><table border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td width="50" height="30" align="center" valign="middle" bgcolor="#ECFCE9"><span class="style44">Total</span></td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
            </tr>
          </table>
            <table border="1" align="left" cellpadding="3" cellspacing="0" bordercolor="#F0F0F0" id="tab">
              <tr bordercolor="#F0F0F0">
                <th width="250" align="left" valign="top" bgcolor="#F0F0F0" scope="col" abbr="NICK">&nbsp;</th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_k"><span class="style1">F</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_d"><span class="style1">D</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_a"><span class="style1">A</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bp"><span class="style1">BP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_bd"><span class="style1">BD</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_2k"><span class="style1">2K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_3k"><span class="style1">3K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_4k"><span class="style1">4K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_5k"><span class="style1">5K</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_adr"><span class="style1">ADR</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rp"><span class="style1">RP</span></th>
                <th align="center" valign="top" bgcolor="#F0F0F0" scope="col" abbr="tmp_rws"><span class="style1">RWS</span></th>
              </tr>
              <?php
$busca="2";
if($busca!="1"){
$busqueda=mysql_query("SELECT * FROM skillpoints_pug1 WHERE tmp_group LIKE '%".$busca."%'");
?>
              <?php
while($f=mysql_fetch_array($busqueda)){
echo '<tr>';
echo '<td align="left" class="style3">'.$f['nick'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_k'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_d'].'</td>';
echo '<td align="center" class="style4">'.$f['tmp_a'].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bp"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_bd"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_2k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_3k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_4k"].'</td>';
echo '<td align="center" class="style4">'.$f["tmp_5k"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_adr'] / max($f['tmp_k'] + $f['tmp_d'], 1)).'</td>';
echo '<td align="center" class="style4">'.$f["tmp_rp"].'</td>';
echo '<td align="center" class="style4">'. round($f['tmp_rws'] / max($f['tmp_d'] + $f['tmp_los'], 2)).'</td>';
echo '</tr>';
}

}
?>
            </table>
            <p>&nbsp;</p></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
</body>
</html>