Add EXP Ranking [BabyRan Panel]

[Ninja300]

Add Experience (EXP) at BabyRan Panel Rankings.


Download the file and extract it at your panel directory.

To change and sort the rankings, go to paneldirectory\lib\dao\ChaInfo.class.php
and rearrange this code

[/COLOR]function rankList($character,$hideGM,$rankLimit,$chaSchool)
{	 $rankListResult = $this->conn->SelectLimit
("SELECT P.ChaName, P.ChaLevel, P.ChaClass, P.ChaSchool, P.ChaExp, P.ChaReborn, P.GuNum, P.ChaNum 
FROM RanGame1.dbo.ChaInfo P, RanUser.dbo.UserInfo U 
WHERE P.UserNum = U.UserNum ".$hideGM." 
AND P.ChaDeleted != 1".$chaSchool." 
ORDER BY [B][COLOR=#ff0000]P.ChaReborn DESC, P.ChaLevel DESC,P.ChaRebornDate ASC,P.ChaExp DESC[/COLOR][/B]",$rankLimit);
if(!$rankListResult){	 return $this->conn;	 }
	 for($r=0;$r<$rankListResult->RecordCount();$r++)
{	 	$result = $this->getFromResult($character, $rankListResult);
		$lblNo++;		$characterList[] = array($lblNo,$result->chaName,$result->chaLevel,$result->chaReborn,$result->chaClass,$result->chaSchool,$result->chaExp);
		$rankListResult->movenext();	 }	  return $characterList;   }[COLOR=#000000]

And

[/COLOR]function top5Character($character,$hideGM){
   	 $top5Character = $this->conn->SelectLimit
("Select P.ChaName FROM RanGame1.dbo.ChaInfo P, RanUser.dbo.UserInfo U 
Where P.UserNum = U.UserNum ".$hideGM." And P.ChaDeleted != 1 
Order by [B][COLOR=#ff0000]P.ChaReborn DESC, P.ChaLevel DESC,P.ChaRebornDate ASC, P.ChaExp DESC[/COLOR][/B]",5);
	 if(!$top5Character){	 return $this->conn;	 }
	 for($i=0;$i<$top5Character->RecordCount();$i++)
{	 $result = $this->getFromResult($character, $top5Character);
	 $top5Result[] = array($result->chaName,);	 $top5Character->movenext();	 }	 return $top5Result;   }[COLOR=#000000]

You can also remove P.ChaRebornDate ASC from this two codes to have ranking only based by Level and Highest Exp and not who reached max reborn first.