Номериране в класация

K

k0kytak

Registered
Може ли да ми помогнете да направа номериране на класация напримерно 1 място еди си кое име и така защото сега показва само имената пробвах да направа номериране обаче ми изкарва само 1,1,1,1,1 :cry:


Код: 
<script type="text/javascript" src="overlib.js"></script>
<?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();
$broinastranica = 25;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = " SELECT * FROM users ORDER BY points DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=450 align=center>";
echo '
<td><a href="index.php?a=ranking" class="mainlevel">Точки</a></td>
<td><a href="index.php?a=rankpower" class="mainlevel">Опит</a></td>
<table width="100%" bgcolor="#343434" border="2" bordercolor="#343434" cellpadding="1" cellspacing="1">
<tbody><tr align="center" bgcolor="#313131">
<tr><td width="20%"><center>Име</td><td><center>Съюз</td><td><center>Пол</td><td><center><font color="green"><b>Точки</b></font></td><td><center>Опит</td><td><center>Дай Точка</td></tr>';
while($row = mysql_fetch_array($result))
{
$firm = ($row[firm]) ? $row[firm] : "<font color=red>Няма съюз</font>";
if($row['namepro'] == '1'){$prouser = '<font color="red"><b> PRO</b></font>';}else{$prouser = ' ';}
?>
<tr><td><center><a href="<? echo $path;?>=<? echo $row['id'];?>" onmouseover="return overlib('<b>Потребител - <? echo $row['name'];?> <br>Точки - <? echo $row['points'];?>                            <br>Мангизи - <? echo $row['money'];?>             <br>Храна - <? echo $row['food'];?>                    <br>Дърво - <? echo $row['wood'];?>                                   <br>Метал - <? echo $row['metal'];?>                                            <br>Кредити - <? echo $row['credits'];?>');" onmouseout="return nd();"><? echo $row['name'];?></a><? echo $prouser ;?></td><td><center><? echo $firm; ?></td><td><center><img src="/images/<? echo $row['sex'];?>.gif" alt="" /> </td><td><center><? echo $row['points'];?></td><td><center><? echo $row['power']; ?></td><td><center><a href="index.php?a=vote&id=<? echo $row['id'];?>">Давам</a></td></tr>
<?} ?>
</table>
<?
 
Код: 
<script type="text/javascript" src="overlib.js"></script>
<?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();
$broinastranica = 25;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = " SELECT * FROM users ORDER BY points DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=450 align=center>";
echo '
<td><a href="index.php?a=ranking" class="mainlevel">Точки</a></td>
<td><a href="index.php?a=rankpower" class="mainlevel">Опит</a></td>
<table width="100%" bgcolor="#343434" border="2" bordercolor="#343434" cellpadding="1" cellspacing="1">
<tbody><tr align="center" bgcolor="#313131">
<tr><td width="20%"><center>Име</td><td><center>Съюз</td><td><center>Пол</td><td><center><font color="green"><b>Точки</b></font></td><td><center>Опит</td><td><center>Дай Точка</td></tr>';
$i = 1;
while($row = mysql_fetch_array($result))
{
$firm = ($row[firm]) ? $row[firm] : "<font color=red>Няма съюз</font>";
if($row['namepro'] == '1'){$prouser = '<font color="red"><b> PRO</b></font>';}else{$prouser = ' ';}
?>
<tr><td><center><?= $i; ?><a href="<? echo $path;?>=<? echo $row['id'];?>" onmouseover="return overlib('<b>Потребител - <? echo $row['name'];?> <br>Точки - <? echo $row['points'];?>                            <br>Мангизи - <? echo $row['money'];?>             <br>Храна - <? echo $row['food'];?>                    <br>Дърво - <? echo $row['wood'];?>                                   <br>Метал - <? echo $row['metal'];?>                                            <br>Кредити - <? echo $row['credits'];?>');" onmouseout="return nd();"><? echo $row['name'];?></a><? echo $prouser ;?></td><td><center><? echo $firm; ?></td><td><center><img src="/images/<? echo $row['sex'];?>.gif" alt="" /> </td><td><center><? echo $row['points'];?></td><td><center><? echo $row['power']; ?></td><td><center><a href="index.php?a=vote&id=<? echo $row['id'];?>">Давам</a></td></tr>
<? $i++; } ?>
</table>
<?
 
Добре сичко е окей но като отида на друга страница пак започва от начало да брой.
 
Код: 
<script type="text/javascript" src="overlib.js"></script>
<?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();
$broinastranica = 25;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = " SELECT * FROM users ORDER BY points DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
echo "<table border=1 width=450 align=center>";
echo '
<td><a href="index.php?a=ranking" class="mainlevel">Точки</a></td>
<td><a href="index.php?a=rankpower" class="mainlevel">Опит</a></td>
<table width="100%" bgcolor="#343434" border="2" bordercolor="#343434" cellpadding="1" cellspacing="1">
<tbody><tr align="center" bgcolor="#313131">
<tr><td width="20%"><center>Име</td><td><center>Съюз</td><td><center>Пол</td><td><center><font color="green"><b>Точки</b></font></td><td><center>Опит</td><td><center>Дай Точка</td></tr>';
$i = $redove + 1;
while($row = mysql_fetch_array($result))
{
$firm = ($row[firm]) ? $row[firm] : "<font color=red>Няма съюз</font>";
if($row['namepro'] == '1'){$prouser = '<font color="red"><b> PRO</b></font>';}else{$prouser = ' ';}
?>
<tr><td><center><?= $i; ?><a href="<? echo $path;?>=<? echo $row['id'];?>" onmouseover="return overlib('<b>Потребител - <? echo $row['name'];?> <br>Точки - <? echo $row['points'];?>                            <br>Мангизи - <? echo $row['money'];?>             <br>Храна - <? echo $row['food'];?>                    <br>Дърво - <? echo $row['wood'];?>                                   <br>Метал - <? echo $row['metal'];?>                                            <br>Кредити - <? echo $row['credits'];?>');" onmouseout="return nd();"><? echo $row['name'];?></a><? echo $prouser ;?></td><td><center><? echo $firm; ?></td><td><center><img src="/images/<? echo $row['sex'];?>.gif" alt="" /> </td><td><center><? echo $row['points'];?></td><td><center><? echo $row['power']; ?></td><td><center><a href="index.php?a=vote&id=<? echo $row['id'];?>">Давам</a></td></tr>
<? $i++; } ?>
</table>
<?
 
Сега ми излизат по следния начин на 1 страница до 25 и место на 2 страница да почнат от 26 почват от 50,51,52,53,54,55 и така на татък
 
Да сичко сега е на ред само има 1 малак проблем 1-вия потребител където е го показва 0 вместо да го вади на 1 място го вади 0 :lol:

Ако може да го оправиш това последно :)
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе