Problem with a ranking page

Results 1 to 12 of 12
  1. 12-06-10 #1
    lolislol111
    Enthusiast lolislol111 is offline
    MemberRank
    Apr 2010 Join Date
    30Posts

    Problem with a ranking page

    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">&nbsp;</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">&nbsp;</td>
											<td width="436">
											<img border="0" src="images/inf/individualranking.png"></td>
											<td width="8">&nbsp;</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>
                                    &nbsp;
                                    <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">&nbsp;</td>
										</tr>
										<tr>
											<td width="434">
											&nbsp;</td>
											<td width="8">&nbsp;</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">&nbsp;</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">&nbsp;</td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											&nbsp;</center></td>
											<td width="8" height="24">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td>
															<td width="128">
															<div align="center">
															<font color="#FF00FF">
															<b>1ST | '.$firstclanname0.'</b></font></td>
															<td width="10">&nbsp;</td>
															<td width="126">
															<div align="center">
															<b>2ND | '.$firstclanname1.'</b></td>
															<td width="7">&nbsp;</td>
															<td width="122">
															<div align="center">
															<b>3RD | '.$firstclanname2.'</b></td>
															<td width="11">&nbsp;</td>
														</tr>';
                                echo $toprank;                                ?>
									<table border="0" style="border-collapse: collapse" width="454" height="100%">
										<tr>
											<td width="434">
											&nbsp;</td>
											<td width="8">&nbsp;</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>
                                    &nbsp;
                                    <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">&nbsp;</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">&nbsp;</td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											&nbsp;</center></td>
											<td width="8" height="24">&nbsp;</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">&nbsp;</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">&nbsp;</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">&nbsp;</td>
											<td width="436">
											<img border="0" src="images/inf/Halloffame.png"></td>
											<td width="8">&nbsp;</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">&nbsp;</td>
								</tr>
										<tr>
											<td width="434">
											&nbsp;</td>
											<td width="8">&nbsp;</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">&nbsp;</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">&nbsp;</td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											&nbsp;</center></td>
											<td width="8" height="24">&nbsp;</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">&nbsp;</td>
							</tr>
						</table>
					</div>
    <?
} }
?>
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    Problem with a ranking page
  3. 13-06-10 #2
     Phoenix 
      Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: Problem with a ranking page

    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.
    Reply With Quote Reply With Quote
  4. 13-06-10 #3
    lolislol111
    Enthusiast lolislol111 is offline
    MemberRank
    Apr 2010 Join Date
    30Posts

    Re: Problem with a ranking page

    Quote Originally Posted by phoenix_147 View Post
    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?
    Last edited by lolislol111; 13-06-10 at 11:03 AM.
    Reply With Quote Reply With Quote
  5. 13-06-10 #4
    eele
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Re: Problem with a ranking page

    Quote Originally Posted by lolislol111 View Post
    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/simpl...-pages-668183/

    You can use my query and some variables ;)
    Reply With Quote Reply With Quote
  6. 13-06-10 #5
    lolislol111
    Enthusiast lolislol111 is offline
    MemberRank
    Apr 2010 Join Date
    30Posts

    Re: Problem with a ranking page

    Quote Originally Posted by eele View Post
    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/simpl...-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.
    Reply With Quote Reply With Quote
  7. 13-06-10 #6
    eele
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Re: Problem with a ranking page

    Quote Originally Posted by lolislol111 View Post
    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.
    Reply With Quote Reply With Quote
  8. 13-06-10 #7
    lolislol111
    Enthusiast lolislol111 is offline
    MemberRank
    Apr 2010 Join Date
    30Posts

    Re: Problem with a ranking page

    Quote Originally Posted by eele View Post
    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. ;(
    Attached Thumbnails Attached Thumbnails item-shop-glitched.jpg   item-shop-working.jpg  
    Last edited by lolislol111; 13-06-10 at 11:32 PM.
    Reply With Quote Reply With Quote
  9. 13-06-10 #8
    eele
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Re: Problem with a ranking page

    Quote Originally Posted by lolislol111 View Post
    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:P
    Reply With Quote Reply With Quote
  10. 13-06-10 #9
    lolislol111
    Enthusiast lolislol111 is offline
    MemberRank
    Apr 2010 Join Date
    30Posts

    Re: Problem with a ranking page

    Quote Originally Posted by eele View Post
    Sorry but I'm to lazy to fix that page, you should ask the makers of it:P
    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?
    Last edited by lolislol111; 14-06-10 at 12:01 AM.
    Reply With Quote Reply With Quote
  11. 14-06-10 #10
    eele
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Re: Problem with a ranking page

    PHP Code:
    $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 Code:
    $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"; 
    Last edited by eele; 14-06-10 at 12:11 AM.
    Reply With Quote Reply With Quote
  12. 14-06-10 #11
    lolislol111
    Enthusiast lolislol111 is offline
    MemberRank
    Apr 2010 Join Date
    30Posts

    Re: Problem with a ranking page

    With that no ranking shows up, the ranking page is empty, the players are not listed. :/
    Reply With Quote Reply With Quote
  13. 14-06-10 #12
    eele
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Re: Problem with a ranking page

    Quote Originally Posted by lolislol111 View Post
    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.
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement