Forum PHP.pl

[PHP] pobierz, plaintext 
<?php
$date = $_GET['data'];
 
if($_SESSION['vip'] == 2)
{
	$tr_naglowek = '<td class="itemnazwa">Delete</td>';
}
 
echo '<table class="itemy">
	<tr class="c" onMouseOver="this.className=\'d\'" onMouseOut="this.className=\'c\'">
		<td class="itemnazwa">L.p</td>
		<td class="itemnazwa">Nick</td>
		<td class="itemnazwa">Level</td>
		<td class="itemnazwa">Punkty</td>
		<td class="itemnazwa">Data</td>
		'.$tr_naglowek.'
	</tr>';
$l = 1;
$p = 0;
 
$zapytanie['logs_players'] = "SELECT a.`name`,b.`level`,b.`points`,b.`time` FROM `list_of_players` a LEFT JOIN `rank_points` b ON a.`id` = b.`id_char` WHERE a.`server` = '".mysql_real_escape_string($world)."' AND a.`name` = '".mysql_real_escape_string($nick)."' AND b.`date` = '".mysql_real_escape_string($date)."' ORDER BY b.`date`,b.`time` DESC LIMIT 1000";
//echo $zapytanie['logs_players'];
$wykonano_zapytanie['logs_players'] = mysql_query($zapytanie['logs_players']) or die(mysql_error());
 
 
$qn = 0;
while($dane = mysql_fetch_assoc($wykonano_zapytanie['logs_players']))
{
	$tablica_level[$qn] = $dane['level'];
	$tablica_points[$qn] = $dane['points'];
	$tablica_points_mieszane[$qn] = $dane['points'];
	$tablica_time[$qn] = $dane['time'];
	$tablica_nick = $dane['name'];
	++$qn;
}
 
$liczba_rekordow = ($qn-1);
 
$tablica_odwrocona = ($tablica_points_mieszane);
 
//echo $tablica_odwrocona[0],' / ',$tablica_points[0],'<br>';
 
for($v=0;$v <= $liczba_rekordow;$v++)
{
	if($_SESSION['vip'] == 2)
	{
		$tr_tresc = '<td class="itemy"><a href="index.php?page=profil_punkty&s='.$world.'&nick='.$nick.'&id_del='.$dane_acc['id'].'">X</a></td>';
	}
 
 
	$obliczenie = number_format($tablica_odwrocona[$v]-$tablica_odwrocona[$v+1],0,0,'');
 
	echo $tablica_odwrocona[$v],' - ',$tablica_odwrocona[$v-1],' = ',$obliczenie,' ['.$v.']<br>';
 
	if($obliczenie >= 0)
	{
		$img = '<img src="style/up.jpg" alt="Wzrost" height="8" width="9" />';
	}
	else
	{
		$img = '<img src="style/down.jpg" alt="Spadek" height="8" width="9" />';
	}
 
	++$p;
 
	echo '
<tr class="c" onMouseOver="this.className=\'b\'" onMouseOut="this.className=\'c\'">
<td class="itemy"><i><b>'.$l.'</b></i></td>
<td class="itemy">'.$tablica_nick.'</td>
<td class="itemy">'.$tablica_level[$v].'</td>
<td class="itemy">'.number_format($tablica_points[$v],0,0,'.').' ['.$img.']</td>
<td class="itemy">'.$tablica_time[$v].'</td>
'.$tr_tresc.'
</tr>';
	++$l;
}
echo '</table>';
 
$wynik1 = $tablica_points[0] - $tablica_points[$liczba_rekordow];
$wynik2 = ($wynik1*100)/$tablica_points[$liczba_rekordow];
$wynik2 = round($wynik2,5);
 
if($wynik2 < 0)
{
	$klasa = 'procent2';
	$img = '<img src="style/down.jpg" alt="Spadek" height="8" width="9" />';
}
else
{
	$klasa = 'procent';
	$img = '<img src="style/up.jpg" alt="Wzrost" height="8" width="9" />';
}
 
echo '
<table class="itemy" style="margin-top: 20px;">	
	<tr class="c" onMouseOver="this.className=\'b\'" onMouseOut="this.className=\'c\'">
		<td class="itemy">Przyrost: '.number_format($wynik1,0,0,'.').' Punktów</td>
		<td class="itemy">(<span class="'.$klasa.'">'.$wynik2.'</span>%) ['.$img.']</td>
	</tr>
</table>';
[PHP] pobierz, plaintext