";
//$game :: Articles
$diajogo2 = $diajogo-2;
$newsa = mysqli_query($con, "SELECT * FROM artigos WHERE diahpublo>='$diajogo2' ORDER BY votos DESC LIMIT 5");
while($row=mysqli_fetch_array($newsa)){
$titulo = $row['titulo'];
$autor = $row['user'];
$diahpublo = $row['diahpublo'];
$ida = $row['id'];
$votos = $row['votos'];
echo " | ";
}
echo"
|
| User | Shout | ";
$shouts = mysqli_query($con, "SELECT * FROM shouts WHERE date='$hj' AND ok=1 ORDER BY data DESC LIMIT 10");
while($row=mysqli_fetch_array($shouts)){
$usa = $row['user'];
$sta = $row['shout'];
echo "| $usa | $sta | ";
}
echo
"
| ";
echo"
| | | ";
/*$guerras = mysqli_query($con, "SELECT * FROM guerras WHERE gan=0 AND (lado1='$ps' OR lado2='$ps') LIMIT 3");
while($row=mysqli_fetch_array($guerras)){
$lado1 = $row['lado1'];
$lado2 = $row['lado2'];
$dano1 = $row['dano1'];
$dano2 = $row['dano2'];
$danototal = $dano1 + $dano2;
if($danototal != 0){
$por1 = ($dano1*100)/$danototal/1.8;
$por2 = ($dano2*100)/$danototal/1.8;
}else{
$por1 = 50/1.8;
$por2 = 50/1.8;
}
echo "
|
  |  | ";
}
*/
$aliados = mysqli_query($con, "SELECT * FROM aliancas WHERE tipo>0 AND (pais1='$ps' OR pais2='$ps')");
while($a=mysqli_fetch_array($aliados)){
$p1 = $a['pais1'];
$p2 = $a['pais2'];
if($p2 == $ps){
$al = $p1;
}else{
$al = $p2;
}
$guerras = mysqli_query($con, "SELECT * FROM batalhas WHERE gan=0 AND (lado1='$al' OR lado2='$al') LIMIT 2");
while($row=mysqli_fetch_array($guerras)){
$lado1 = $row['lado1'];
$lado2 = $row['lado2'];
$dano1 = $row['dano1'];
$dano2 = $row['dano2'];
$danototal = $dano1 + $dano2;
if($danototal != 0){
$por1 = (($dano1*100)/$danototal)/1;
$por2 = (($dano2*100)/$danototal)/1;
}else{
$por1 = 50/1;
$por2 = 50/1;
}
$por1 = round($por1, 2);
$por2 = round($por2, 2);
echo "
|
$por1 x $por2 |  | ";
}
}
//
echo " ";
?> |