Problem with a ranking page

lolislol111 · Jun 12, 2010

Searching for an individual from players or clans shows up a blank page, and the ranking pages, only the first one shows 20 players, but the next 20 are not shown if i click the next page of rankings. I wish someone can help me with this. IP is censured on purpose (xxx.xxx.xxx.xxx).

Here's the ranking page code:

Code:

<?
if ($_GET['expand'] == 1){
?>
				<tr>
					<td width="917" colspan="5" height="26" style="background-image: url('images/subbar.png'); background-repeat: no-repeat; background-position: center top">
					<p align="center">
					<a href="index.php?do=ranking&sub=individual&expand=1">
					<img border="0" src="images/subbar/individualranking.jpg" width="99" height="13"></a><a href="index.php?do=ranking&sub=clan&expand=1"><img border="0" src="images/subbar/clanranking.jpg" width="99" height="13"></a></td>
				</tr>

<? }

if($_GET['expand'] == 0){

switch($_GET['sub']){
    case "individual";
        ShowIndividualRanking();
    break;
    case "clan";
        ShowClanRanking();
    break;
    case "hof";
        ShowHalloffame();
    break;
}
}


if(!function_exists("ShowIndividualRanking")){
function ShowIndividualRanking(){
    ?>


<head>
<meta http-equiv="Content-Language" content="es">
<link rel="stylesheet" type="text/css" href="images/style.css">
</head>

	<body bgcolor="#312F30">

					<div align="center">
						<table border="0" width="456" style="border-collapse: collapse">
							<tr>
								<td background="images/cont_up.jpg"> </td>
							</tr>
							<tr>
								<td background="images/cont_bg.jpg">
								<div align="center">
									<table border="0" style="border-collapse: collapse" width="454" height="100%">
										<tr>
											<td width="4" rowspan="6"> </td>
											<td width="436">
											<img border="0" src="images/inf/individualranking.png"></td>
											<td width="8"> </td>
										</tr>
								<tr>
									<td style="background-repeat: repeat; background-position: center top" width="590" valign="top"><p>
									<div align="center">
                                    <form method="GET" name="indsearch" action="index.php">
                                    <input type="hidden" name="do" value="ranking" />
                                    <p align="center">
                                    <select name="sub">
                                    <option value="individual">Character Name</option>
                                    <select name="expand">
                                    <option value="1">=</option>
                                    </select>
                                     
                                    <input type="text" name="name" />
                                    <input type="submit" value="Search" />
                                    </p>
					                </form></div></td>
								</tr>
										<tr>
											<td width="434">
											<img border="0" src="images/ranking_legend.jpg" width="437" height="30"></td>
											<td width="8"> </td>
										</tr>
										<tr>
											<td width="434">
											 </td>
											<td width="8"> </td>
										</tr>
										<tr>
											<td width="434">
											<div align="center">
												<table border="0" width="421" style="border-collapse: collapse; background-image: url('images/rankinglist.jpg'); background-repeat: no-repeat; background-position: center top">
													<tr>
														<td>
														<table border="0" style="border-collapse: collapse" width="100%" height="100%">
															<tr>
																<td height="30"> </td>
															</tr>
															<tr>
																<td style="background-image: url('images/rankinlist_bg.gif'); background-repeat: repeat; background-position: center top">
																<table border="0" style="border-collapse: collapse" width="417" height="100%">
                                                                <?
                                                        if( isset($_GET['expand']) && isset($_GET['name']) )
                                                        {
                                                            $search = 1;
                                                            $name = clean($_GET['name']);
                                                        }
                                                            if($search == 1)
                                                            {
                                                                $squery = "SELECT CID, Level, XP, Ranking, KillCount, DeathCount FROM Character(nolock) WHERE Name = '$name' AND (DeleteFlag=0 OR DeleteFlag=NULL)";
                                                            }
                                                            else
                                                            {
                                                                $search = 0;
                                                            }


                                                        if($search == 0 )
                                                        {
                                                        switch( clean($_GET['page']) )
                                                        {
                                                            case "":
                                                                $ranks = "Ranking >= 1 AND Ranking <= 20";
                                                            break;
                                                            case "2":
                                                                $ranks = "Ranking > 20 AND Ranking <= 40";
                                                            break;
                                                            case "3":
                                                                $ranks = "Ranking > 40 AND Ranking <= 60";
                                                            break;
                                                            case "4":
                                                                $ranks = "Ranking > 60 AND Ranking <= 80";
                                                            break;
                                                            case "5":
                                                                $ranks = "Ranking > 80 AND Ranking <= 100";
                                                            break;
                                                            default:
                                                                $ranks = "Ranking <= 20";
                                                            break;
                                                        }
                                                        $res = mssql_query_logged("SELECT TOP 20 CID, Level, XP, Ranking, KillCount, DeathCount FROM Character(nolock) WHERE $ranks AND (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY XP DESC");
                                                           $count0;
                                                            }
                                                            else
                                                            {
                                                                $res = mssql_query_logged($squery);
                                                            }
                                                              if(mssql_num_rows($res) <> 0)
                                                              {
                                                               }
                                                                while($r = mssql_fetch_assoc($res)){
                                                                    $count++;
                                                        ?>								<tr>
																		<td width="45">
																		<p align="center">
																		<?=$count?></td>
																		<td width="88">
																		<p align="center">
																		<b>
																		<span class="guild_name">
																		<?=FormatCharName($r['CID'])?></span></b>
																		</td>
																		<td width="33">
																		<p align="center">
																		<?=$r['Level']?></td>
																		<td width="127">
																		<p align="center">
																		<?=number_format($r['XP'],0,'','.');?></td>
																		<td width="114">
																		<p align="center">
																		<span style="font-size: 7pt">
																		<?=GetKDRatio($r['KillCount'], $r['DeathCount'])?></span></td>
																	</tr> <?}?>
																</table>
																</td>
															</tr>
														</table>
														</td>
													</tr>
												</table>
											</div>
											</td>
											<td width="8"> </td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											 </center></td>
											<td width="8" height="24"> </td>
										</tr>
									</table>
                                    <p align="center"><a href="index.php?do=ranking&sub=individual&expand=1">[1-20]</a> - <a href="index.php?do=ranking&sub=individual&expand=1&page=2">[21-40]</a> - <a href="index.php?do=ranking&sub=individual&expand=1&page=3">[41-60]</a>
									- <a href="index.php?do=ranking&sub=individual&expand=1&page=4">[61-80]</a> - <a href="index.php?do=ranking&sub=individual&expand=1&page=5">[81-100]</a></p>
								</div>
								</td>
							</tr>
							<tr>
								<td background="images/cont_top.jpg" height="27"> </td>
							</tr>
						</table>
					</div>
    <?
} }

if(!function_exists("ShowClanRanking")){
function ShowClanRanking(){                                                           
    ?>
<body bgcolor="#312F30">		
					<div align="center">
						<table border="0" width="456" style="border-collapse: collapse">
							<tr>
								<td background="images/cont_up.jpg"> </td>
							</tr>
							<tr>
								<td background="images/cont_bg.jpg">
								<div align="center">
										<table border="0" style="border-collapse: collapse" width="100%">
										<tr>
									                 
											<td width="4" rowspan="6"> </td>
											<img border="0" src="images/inf/clanranking.png" width="413" height="17">
										</tr>
                                        <?
                                            $res = mssql_query_logged("SELECT TOP 3 * FROM Clan WHERE (DeleteFlag=0 OR DeleteFlag=NULL) AND Ranking != 0 ORDER BY POINT DESC");

                                            $Count = 0;

                                            while($resa = mssql_fetch_object($res))
                                            {
                                                $FirstClan[$Count][Name]        = $resa->Name;
                                                $FirstClan[$Count][EmblemURL]   = ($resa->EmblemUrl == "") ? "images/no_emblem.png" : $resa->EmblemUrl;

                                            if($Count == 3)
                                                break;
                                            else
                                                $Count++;
                                            }

                                            $firstclanemb0 = ($FirstClan[0][EmblemURL] == "") ? "images/no_emblem.png" : $FirstClan[0][EmblemURL];
                                            $firstclanemb1 = ($FirstClan[1][EmblemURL] == "") ? "images/no_emblem.png" : $FirstClan[1][EmblemURL];
                                            $firstclanemb2 = ($FirstClan[2][EmblemURL] == "") ? "images/no_emblem.png" : $FirstClan[2][EmblemURL];

                                            $firstclanname0 = ($FirstClan[0][Name] == "") ? "No Data" : $FirstClan[0][Name];
                                            $firstclanname1 = ($FirstClan[1][Name] == "") ? "No Data" : $FirstClan[1][Name];
                                            $firstclanname2 = ($FirstClan[2][Name] == "") ? "No Data" : $FirstClan[2][Name];


                                            $toprank = '
											<tr>
												<td width="144" valign="bottom" height="80">
												<div  align="center">
												<img src="http://xxx.xxx.xxx.xxx/website/'.$firstclanemb0.'" width="50" height="50"></td>
												<td width="135" valign="bottom" height="80">
												<div align="center">
												<img src="http://xxx.xxx.xxx.xxx/website/'.$firstclanemb1.'" width="50" height="50"></td>
												<td width="126" valign="bottom" height="80">
												<div align="center">
												<img src="http://xxx.xxx.xxx.xxx/website/'.$firstclanemb2.'" width="50" height="50"></td>
											</tr>
<table border="0" style="border-collapse: collapse" width="100%">
														<tr>
															<td width="5"> </td>
															<td width="128">
															<div align="center">
															<font color="#FF00FF">
															<b>1ST | '.$firstclanname0.'</b></font></td>
															<td width="10"> </td>
															<td width="126">
															<div align="center">
															<b>2ND | '.$firstclanname1.'</b></td>
															<td width="7"> </td>
															<td width="122">
															<div align="center">
															<b>3RD | '.$firstclanname2.'</b></td>
															<td width="11"> </td>
														</tr>';
                                echo $toprank;                                ?>
									<table border="0" style="border-collapse: collapse" width="454" height="100%">
										<tr>
											<td width="434">
											 </td>
											<td width="8"> </td>
                                                                                </tr>
								<tr>
									<td style="background-repeat: repeat; background-position: center top" width="590" valign="top"><p>
									<div align="center">
                                    <form method="GET" name="indsearch" action="index.php">
                                    <input type="hidden" name="do" value="ranking" />
                                    <p align="center">
                                    <select name="sub">
                                    <option value="clan">Clan Name</option>
                                    <select name="expand">
                                    <option value="1">=</option>
                                    </select>
                                     
                                    <input type="text" name="name" />
                                    <input type="submit" value="Search" />
                                    </p>
					                </form></div></td>
								</tr>
										<tr>
											<td width="434">
											<div align="center">
												<table border="0" width="421" style="border-collapse: collapse; background-image: url('images/clanranking_list.jpg'); background-repeat: no-repeat; background-position: center top">
													<tr>
														<td>
														<table border="0" style="border-collapse: collapse" width="100%" height="100%">
															<tr>
																<td height="30"> </td>
															</tr>
															<tr>
																<td style="background-image: url('images/clanranking_list_bg.gif'); background-repeat: repeat; background-position: center top">
																<table border="0" style="border-collapse: collapse" width="417" height="100%">
                                                               <?
                                                        if( isset($_GET['expand']) && isset($_GET['name']) )
                                                        {
                                                            $search = 1;
                                                            $name = clean($_GET['name']);
                                                        }
                                                            if($search == 1)
                                                            {
                                                                $squery = "SELECT * FROM Clan(nolock) WHERE Name = '$name' AND (DeleteFlag=0 OR DeleteFlag=NULL)";
                                                            }
                                                            else
                                                            {
                                                                $search = 0;
                                                            }


                                                        if($search == 0 )
                                                        {
                                                        switch( clean($_GET['page']) )
                                                        {
                                                            case "":
                                                                $ranks = "Ranking >= 1 AND Ranking <= 20";
                                                            break;
                                                            case "2":
                                                                $ranks = "Ranking > 20 AND Ranking <= 40";
                                                            break;
                                                            case "3":
                                                                $ranks = "Ranking > 40 AND Ranking <= 60";
                                                            break;
                                                            case "4":
                                                                $ranks = "Ranking > 60 AND Ranking <= 80";
                                                            break;
                                                            case "5":
                                                                $ranks = "Ranking > 80 AND Ranking <= 100";
                                                            break;
                                                            default:
                                                                $ranks = "Ranking <= 20";
                                                            break;
                                                        }
                                                        $res = mssql_query_logged("SELECT TOP 20 * FROM Clan WHERE $ranks AND (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY POINT DESC");
                                                            }
                                                            else
                                                            {
                                                                $res = mssql_query_logged($squery);
                                                            }
                                                              if(mssql_num_rows($res) <> 0)
                                                              {
                                                               }
                                                                while($r = mssql_fetch_assoc($res)){
                                                        ?>

                                                                    <tr>
																		<td width="45">
																		<p align="center">
																		<?=$r['Ranking']?></td>
																		<td width="40">
																		<p align="center">
																		<img src="http://xxx.xxx.xxx.xxx/website/<?=($r['EmblemUrl'] == "") ? "images/no_emblem.png" : $r['EmblemUrl'];?>" width="50" height="50"></td>
																		<td width="90">
																		<p align="center">
																		<b><?=$r['Name']?></b></td>
																		<td width="76">
																		<p align="center">
																		<? $res3 = mssql_query_logged("SELECT * FROM Character WHERE CID = '".$r['MasterCID']."'");
                                                                            $c = mssql_fetch_assoc($res3);
                                                                            echo FormatCharName($c['CID']);
                                                                        ?></td>
																		<td width="71">
																		<p align="center">
																		<?=$r['Wins']?>/<?=$r['Losses']?> (<?=GetClanPercent($r['Wins'], $r['Losses'])?>)</td>
																		<td width="83">
																		<p align="center">
																		<?=$r['Point']?></td>
																	</tr>  <?}?>
																</table>
																</td>
															</tr>
														</table>
														</td>
													</tr>
												</table>
											</div>
											</td>
											<td width="8"> </td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											 </center></td>
											<td width="8" height="24"> </td>
										</tr>
									</table>
                                                <p align="center"><a href="index.php?do=ranking&sub=clan&expand=1">[1-20]</a> - <a href="index.php?do=ranking&sub=clan&expand=1&page=2">[21-40]</a> - <a href="index.php?do=ranking&sub=clan&expand=1&page=3">[41-60]</a>
									- <a href="index.php?do=ranking&sub=clan&expand=1&page=4">[61-80]</a> - <a href="index.php?do=ranking&sub=clan&expand=1&page=5">[81-100]</a></p>
								</div>
								</td>
							</tr>
							<tr>
								<td background="images/cont_top.jpg" height="27"> </td>
							</tr>
						</table>
					</div>
    <?
} }
if(!function_exists("ShowHalloffame")){
function ShowHalloffame(){                                                           
       ?>
	<body bgcolor="#312F30">

					<div align="center">
						<table border="0" width="456" style="border-collapse: collapse">
							<tr>
								<td background="images/cont_up.jpg"> </td>
							</tr>
							<tr>
								<td background="images/cont_bg.jpg">
								<div align="center">
									<table border="0" style="border-collapse: collapse" width="454" height="100%">
										<tr>
											<td width="4" rowspan="6"> </td>
											<td width="436">
											<img border="0" src="images/inf/Halloffame.png"></td>
											<td width="8"> </td>
										</tr>
								<tr>


									<td style="background-repeat: repeat; background-position: center top" width="583" align="left" valign="top">
                                    <form method="GET" name="honorrank" action="index.php">
                                    <input type="hidden" name="do" value="halloffame" />
                                    <table align="center">
                                    <tr>
                                    <td align="left" width="50%">
                                    <option>Viewing ranking from</option>
                                    <?
                                    $listq = mssql_query_logged("SELECT TOP 1 Month, Year FROM ClanHonorRanking(nolock) GROUP BY Month, Year ORDER BY Year DESC, Month DESC");
                                    while($halldata = mssql_fetch_assoc($listq))
									{
										echo '<option value="'.$halldata[Month].'-'.$halldata[Year].'">'.$halldata[Month].'/'.$halldata[Year].'</option>';
									}
                                $querydate = mssql_query_logged("SELECT TOP 1 Month, Year FROM ClanHonorRanking(nolock) GROUP BY Month, Year ORDER BY Year DESC, Month DESC");
                                $ddata = mssql_fetch_row($querydate);
                                $month = $ddata[0];
                                $year = $ddata[1];
                                $date = ( isset($month) && isset($year) ) ? $month."-".$year : "";
                                    ?>
                                    </select>
									</td>
									</tr>
									</table>
									</form>
                                    
                                    </td>
									<td style="background-repeat: repeat; background-position: center top" width="7" rowspan="5"> </td>
								</tr>
										<tr>
											<td width="434">
											 </td>
											<td width="8"> </td>
										</tr>
										<tr>
											<td width="434">
											<div align="center">
												<table border="0" width="421" style="border-collapse: collapse; background-image: url('images/clanranking_list.jpg'); background-repeat: no-repeat; background-position: center top">
													<tr>
														<td>
														<table border="0" style="border-collapse: collapse" width="100%" height="100%">
															<tr>
																<td height="30"> </td>
															</tr>
															<tr>
																<td style="background-image: url('images/clanranking_list_bg.gif'); background-repeat: repeat; background-position: center top">
																<table border="0" style="border-collapse: collapse" width="417" height="100%">
<?
 switch( clean($_GET['page']) )
                                                            {
                                                                case "":
                                                                    $ranks = "Ranking <= 20";
                                                                break;
                                                                case "2":
                                                                    $ranks = "Ranking > 20 AND Ranking <= 40";
                                                                break;
                                                                case "3":
                                                                    $ranks = "Ranking > 40 AND Ranking <= 60";
                                                                break;
                                                                case "4":
                                                                    $ranks = "Ranking > 60 AND Ranking <= 80";
                                                                break;
                                                                case "5":
                                                                    $ranks = "Ranking > 80 AND Ranking <= 100";
                                                                break;
                                                                default:
                                                                    $ranks = "Ranking <= 20";
                                                                break;
                                                            }
$res2 = mssql_query_logged("SELECT TOP 20 * FROM ClanHonorRanking WHERE Month = '$month' AND Year = '$year' AND $ranks ORDER BY RANKING DESC");
$count = 0;                                                                 
while($r = mssql_fetch_assoc($res2)){
                                                                       $clanemburl = ($clan->EmblemUrl == "") ? "images/no_emblem.png" : $clan->EmblemUrl;?>

                                                                    <tr>
																		<td width="45">
																		<p align="center">
																		<?=$r['Ranking']?></td>
																		<td width="40">
																		<p align="center">
																		<img src="http://xxx.xxx.xxx.xxx/website/<?=($r['EmblemUrl'] == "") ? "images/no_emblem.png" : $r['EmblemUrl'];?>" width="50" height="50"></td>
																		<td width="90">
																		<p align="center">
																		<b><?=$r['ClanName']?></b></td>
																		<td width="76">
																		<p align="center">
																		<? $res3 = mssql_query_logged("SELECT * FROM Character WHERE CID = '".$r['MasterCID']."'");
                                                                            $c = mssql_fetch_assoc($res3);
                                                                            echo FormatCharName($c['CID']);
                                                                        ?></td>
																		<td width="71">
																		<p align="center">
																		<?=$r['Wins']?>/<?=$r['Losses']?> (<?=GetClanPercent($r['Wins'], $r['Losses'])?>)</td>
																		<td width="83">
																		<p align="center">
																		<?=$r['Point']?></td>
																	</tr>  <?}?>
																</table>
																</td>
															</tr>
														</table>
														</td>
													</tr>
												</table>
											</div>
											</td>
											<td width="8"> </td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											 </center></td>
											<td width="8" height="24"> </td>
										</tr>
									</table>
                                                <p align="center"><a href="index.php?do=ranking&sub=hof&expand=1">[1-20]</a> - <a href="index.php?do=ranking&sub=hof&expand=1&page=2">[21-40]</a> - <a href="index.php?do=ranking&sub=hof&expand=1&page=3">[41-60]</a>
									- <a href="index.php?do=ranking&sub=hof&expand=1&page=4">[61-80]</a> - <a href="index.php?do=ranking&sub=hof&expand=1&page=5">[81-100]</a></p>
								</div>
								</td>
							</tr>
							<tr>
								<td background="images/cont_top.jpg" height="27"> </td>
							</tr>
						</table>
					</div>
    <?
} }
?>

Phoenix · Jun 13, 2010

I see you are using the Euro web's ranking page.

Search should work. There's no script modification needed for it.
To show more than 20 players in the ranking, change the count in the MSSQL query.

lolislol111 · Jun 13, 2010

phoenix_147 said:
I see you are using the Euro web's ranking page.

Search should work. There's no script modification needed for it.
To show more than 20 players in the ranking, change the count in the MSSQL query.

Actually it's nolifes' mpog website, which i've edited quite alot to get it function in a way pleasant to me. But what do you mean by that database edit? Since in the dbo.character i have everything correctly for all i know, but the Ranking field, on every field it shows 1, since the default value is 1 and when the character is created it sets that to 1, and there's the problem, if everybody is ranked 1 and the second and third and etc. ranking pages load the ranks 21 - 40 and 41 - 60 there's nothing to load except on the first page which is 1 - 20. So if you could tell a little bit more? And would there be a function, that checks the TOP 40, but only takes the TOP 21 - 40 from that query?

eele · Jun 13, 2010

lolislol111 said:
Actually it's nolifes' mpog website, which i've edited quite alot to get it function in a way pleasant to me. But what do you mean by that database edit? Since in the dbo.character i have everything correctly for all i know, but the Ranking field, on every field it shows 1, since the default value is 1 and when the character is created it sets that to 1, and there's the problem, if everybody is ranked 1 and the second and third and etc. ranking pages load the ranks 21 - 40 and 41 - 60 there's nothing to load except on the first page which is 1 - 20. So if you could tell a little bit more? And would there be a function, that checks the TOP 40, but only takes the TOP 21 - 40 from that query?

I made a rankingpage with pages for first 1-20, 21-40, 41-60, etc
You'll find the source in the link below
http://forum.ragezone.com/f245/simple-ranking-page-odbc-pages-668183/

You can use my query and some variables

lolislol111 · Jun 13, 2010

eele said:
I made a rankingpage with pages for first 1-20, 21-40, 41-60, etc
You'll find the source in the link below
http://forum.ragezone.com/f245/simple-ranking-page-odbc-pages-668183/

You can use my query and some variables

Thank you! I was really annoyed by the ranking page since i tried to figure it out for so long time, oh, and there's another question i have in mind, would there be any way to make the nolife mpog web event and donator shop show more than 8 items correctly? Ask for more info if you need.

eele · Jun 13, 2010

lolislol111 said:
Thank you! I was really annoyed by the ranking page since i tried to figure it out for so long time, oh, and there's another question i have in mind, would there be any way to make the nolife mpog web event and donator shop show more than 8 items correctly? Ask for more info if you need.

I never used the mpog web so I don't know how it's coded, but ofcourse it's possible.

lolislol111 · Jun 13, 2010

eele said:
I never used the mpog web so I don't know how it's coded, but ofcourse it's possible.

Well could you say anything based on these pictures? For me it seems that due to something it's trying to recreate the website on the right hand side.

And also with the ranking page how could i edit mine one to work? Since i tried but it didn't show the ranks at all after that. ;(

eele · Jun 13, 2010

lolislol111 said:
Well could you say anything based on these pictures? For me it seems that due to something it's trying to recreate the website on the right hand side.

And also with the ranking page how could i edit mine one to work? Since i tried but it didn't show the ranks at all after that. ;(

Sorry but I'm to lazy to fix that page, you should ask the makers of it

lolislol111 · Jun 13, 2010

eele said:
Sorry but I'm to lazy to fix that page, you should ask the makers of it

Well the question was asked in the thread many times but didn't find a good answer there...I wish no_life sees this or somebody else who would have a little time in their hands. x)

P.S If i change the ranking of my character in the database, the ranking field, to 21, it goes to the second page, since it says this in the ranking .php file:

Code:

case "":
                                                                $ranks = "Ranking >= 1 AND Ranking <= 20";
                                                            break;
                                                            case "2":
                                                                $ranks = "Ranking > 20 AND Ranking <= 40";
                                                            break;
                                                            case "3":
                                                                $ranks = "Ranking > 40 AND Ranking <= 60";
                                                            break;
                                                            case "4":
                                                                $ranks = "Ranking > 60 AND Ranking <= 80";
                                                            break;
                                                            case "5":
                                                                $ranks = "Ranking > 80 AND Ranking <= 100";
                                                            break;
                                                            default:
                                                                $ranks = "Ranking <= 20";
                                                            break;

But the problem is that everybodys' Ranking is 1 in the database, since it's defaulted to that, and it seems that the php code doesn't change it to the correct one, or doesn't calculate it itself. So basically everybody is ranked 1, but it sorts the people by the exp and level and so on, would there be any way to just remove the Ranking field and get it to page out the sorted by exp and level ranks?

eele · Jun 13, 2010

PHP:

$res = mssql_query_logged("SELECT TOP 20 CID, Level, XP, Ranking, KillCount, DeathCount FROM Character(nolock) WHERE $ranks AND (DeleteFlag=0 OR DeleteFlag=NULL) ORDER BY XP DESC");

Hmm?

try this

PHP:

$max = 20; // Shows 20 per page

$page = clean($_GET['page']);
$selectmax = $page*$max-$max;

if(!$page OR $page <= 1 OR $page > 5){
$page = 1;
$selectmax = 0;
}

$res = "SELECT TOP $max * FROM Character where CID not in (select top $select CID from Character order by XP DESC) AND DeleteFlag='0' order by XP DESC";

lolislol111 · Jun 13, 2010

With that no ranking shows up, the ranking page is empty, the players are not listed. :/

eele · Jun 14, 2010

lolislol111 said:
With that no ranking shows up, the ranking page is empty, the players are not listed. :/

Lol, that's just a part of the code replace the veriables of your code with mine.

Problem with a ranking page

lolislol111

Newbie Spellweaver

Phoenix

Moderator

lolislol111

Newbie Spellweaver

eele

Status: Pooping

lolislol111

Newbie Spellweaver

eele

Status: Pooping

lolislol111

Newbie Spellweaver

Attachments

eele

Status: Pooping

lolislol111

Newbie Spellweaver

eele

Status: Pooping

lolislol111

Newbie Spellweaver

eele

Status: Pooping

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners