Как да показва на кое

H

haus

Registered
Искам да попитам как да направя да ми изважда мястото на което съм във класацията напримерно аз съм на 56 и до името ми пише
Username (#56)
Увеличете...
 
Ето го кода за класацията


Код: 
<?php
function selfURL() {
$s = empty($_SERVER["HTTPS"]) ? ''
: ($_SERVER["HTTPS"] == "on") ? "s"
: "";
 preg_match_all('/(.*)\//',$_SERVER['SCRIPT_NAME'],$lq);
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
: (":".$_SERVER["SERVER_PORT"]);
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$lq[0][0];
}
function strleft($s1, $s2) {
return substr($s1, 0, strpos($s1, $s2));
}
$url = selfURL();
$vote = "index.php?a=profile&id";
$battle = "index.php?a=battle&id";
$path = $url.$vote;
$broinastranica = 50;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = "SELECT * FROM users ORDER BY wins DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo '<table class="maintable" width="100%" cellspacing="0">
<tbody>
<tr>
<th scope="col" width="20"></th>
<th scope="col" width="20">Кола</th>
<th scope="col" width="80">Име</th>
<th scope="col" width="10">Пол</th>
<th scope="col" width="80">Съюз</th>
<th scope="col" width="50">Точки</th>
<th scope="col" width="10"><font color=green>Победи</font></th>
<th scope="col" width="80">Загуби</th>
<th scope="col" width="50">Ултиматум</th>
<th scope="col" width="50">Ниво</th>
<th scope="col" width="50">Състезание</th>
</tr>';
$i = $redove + 1;
while($row = mysql_fetch_array($result))
{
$firm = ($row[firm]) ? $row[firm] : "<font color=red>Няма съюз</font>";
if($row['namepro'] == '1'){$prouser = ' <span style="padding: 0px 3px; color: white; background-color: red; font-weight: bolder; font-size: 11px;">PRO</span>';}else{$prouser = ' ';}
?>

<?php
$name = $row['name'];
$speed = $row['speed'];
$acceleration = $row['acceleration'];
$stability = $row['stability'];
$bonus_turbo = $row['bonus_turbo'];
$bonus_nitrous = $row['bonus_nitrous'];
$bonus_wheels = $row['bonus_wheels'];
$bonus_spoilers = $row['bonus_spoilers'];
$bonus_generation = $row['bonus_generation'];
$bonus_dampers = $row['bonus_dampers'];
$bonus_abs = $row['bonus_abs'];
$power = $row['power'];
$lvl = $row['lvl'];
$namecolor = $row['namecolor'];
$burzinas = $speed + $bonus_spoilers + $bonus_generation;
$uskorenies = $acceleration + $bonus_turbo + $bonus_nitrous + $bonus_wheels;
$stabilnosts = $stability + $bonus_dampers + $bonus_abs;
$ultimatum = $power + $speed + $stability + $acceleration + $bonus_turbo + $bonus_nitrous + $bonus_wheels + $bonus_spoilers + $bonus_generation + $bonus_dampers + $bonus_abs;
?>
<tr class="d">
<td><center><h2><? echo $i; ?></h2></td></center>
                        <td><center>
<?
if ($row[cars] > 40)
{
echo "<img src='images/yes_cars.gif'>";
}
elseif ($row[cars] < 1)
{
echo "<img src='images/no_cars.gif'>";
}
?></center>
</td>
<td align="right"><nobr><center><a href="<? echo $path;?>=<? echo $row['id'];?>"<? echo "<font color='$namecolor'>$name</font></b> $prouser"; ?>
</a></center></nobr></td>
<td align="right"><span class="g"><center><img src="images/<? echo $row['sex'];?>.gif" alt="" /></center></span></td>
<td align="right"><span class="b"><center><b><? echo $firm; ?></b></center></span></td>
<td align="right"><nobr><center><b><? echo $row['points'];?></b></center></nobr></td>
<td align="right"><span class="g"><center><b><? echo $row['wins'];?></b></center></span></td>
<td align="right"><span class="b"><center><b><? echo $row['loses'];?></b></center></span></td>
<td align="right"><span class="g"><center><b><?echo "$ultimatum";?></b></center></span></td>
<td align="right"><span class="g"><center><b><? echo $row['lvl'];?></b></center></span></td>
<?php
if($_SESSION['name']) {
$name = $_SESSION['name'];
$mess=mysql_num_rows(mysql_query("SELECT * FROM pmessages WHERE touser='$_SESSION[name]' AND unread='unread'"));
echo (' 
<td align="right"><nobr><center><a href='.$battle.'='.$row['id'].'><img src=images/predizvikai.gif></a></center></nobr></td>
');
 } else {
echo ("<td align='right'><nobr><center><b><b>Нямаш Регистрация.</font></b></b></center></nobr></td>"); }
?>
</tr>
</tbody>
<? $i++; } ?>
</table>
<?
$query = "SELECT COUNT(name) AS numrows FROM users";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= "<a href=\"\" class='text_border'> $page</a>";
}
else
{
$nomeranastranici .= " <a href=\"?a=ranking&page=$page\" class='g3link_border'>$page</a> ";
}
}
if ($pageNum > 1)
[code]{
$page = $pageNum - 1;
$predishna = " <a href=\"?a=ranking&page=$page\" class='glink'> « </a> ";

$parva = " <a href=\"?a=ranking&page=1\"></a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"?a=ranking&page=$page\" class='glink'> » </a> ";
$posledna = " <a href=\"?a=ranking&page=$maxPage\"></a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<center>$parva $predishna $nomeranastranici $sledvashta $posledna</center>";
?>[/code]
 
преди цикъла си правиш една променлива $i=1;
където искаш да се показва на кое място слагаш кода
Username (#<?php echo$i; ?>)
Увеличете...
и преди да затвориш цикъла слагаш едно $i++;
 
<?php

$query = mysql_query("SELECT * FROM users ORDER BY wins DESC") or die(mysql_error());
$i = 1;
while ($row = mysql_fetch_object($query)) {
$show[$row->name] = $i;
$i++;
}

echo "Username " . $show['Името на потребителя'];
?>
Увеличете...
Промени name с полето за името на потребителя. По твоя код видях, че е така.
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе