[Request] top3 ranking

[lotje]

Hi,

On few servers i seen something like top 3 ranking above the top 100 with mage,knight and archer picture with the name of the 3 highest off all 3 chars bellow that picture,

could someone give me the php code for it? (aint that perfect with making php etc.)

[MentaL]

[custre]

yes, I like that very much too;)

I got a script from DeathArt, which is the only script that works for me. Its nice, but doesn't show a picture of the best archer etc. But he is a great coder so its the best scripts:P
But I wanna try that script too

[lotje]

those picture need to be uploaded also with the top3 php

[ToXiC L33T]

try this.. its from my old site :)

<center>
<?php
	echo "<table width='500' align='center' height='1' cellspacing='0' border='0'>";
	echo "<tr valign='top'>";
	echo "<td width='5%'><center><b>Top Knight</b></center></td><td width='5%'><center><b>Top Mage</b></center></td><td width='5%'><center><b>Top Archer</b></center></td><tr valign='top'>";

	$msconnect = mssql_connect("*****" ,"***" ,"******");
	$msdb = mssql_select_db("kal_db", $msconnect);
	
	$plist =  $plist = "SELECT TOP 1 * FROM [Player] WHERE [Class] = '0' ORDER BY 
	[Admin], [Level] Desc, [Exp] Desc";
	$pplist = mssql_query($plist);


	
	while($list = mssql_fetch_array($pplist)){


	if($list['Class'] == "0"){
	echo "<td><center>";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/knight.jpg\"><br>";
	}
	elseif($list['Class'] == "1"){
	echo "<td><center>";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/mage.jpg\"><br>";
	}
	elseif($list['Class'] == "2"){
	echo "<td><center>";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/archer.jpg\"><br>";
	}

	echo "$cha";
	echo "$list[Name]";
	echo ":";
	echo "&nbsp;";
	echo "&nbsp;";
	echo "$list[Level]";
	echo "</center></td>";	
	}
//	echo "<br><br>";
//	echo "</tr></table>";

	
	


	
;/////////////new field\\\\\\\\\\\\\\\\

	$msconnect = mssql_connect("*****" ,"****" ,"******");
	$msdb = mssql_select_db("kal_db", $msconnect);
	
	$plist =  $plist = "SELECT TOP 1 * FROM [Player] WHERE [Class] = '1' ORDER BY 
	[Admin], [Level] Desc, [Exp] Desc";
	$pplist = mssql_query($plist);
	
	while($list = mssql_fetch_array($pplist)){

	if($list['Class'] == "0"){
	echo "<td><center>";
//	$char = "Knight";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/knight.jpg\"><br>";
	}
	elseif($list['Class'] == "1"){
	echo "<td><center>";
//	$char = "Mage";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/mage.jpg\"><br>";
	}
	elseif($list['Class'] == "2"){
	echo "<td><center>";
//	$char = "Archer";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/archer.jpg\"><br>";
	}
	
	echo "$cha";
	echo "$list[Name]";
	echo ":";
	echo "&nbsp;";
	echo "&nbsp;";
	echo "$list[Level]";
	echo "</center></td>";	
	}
//	echo "<br><br>";
//	echo "</tr></table>";

	
	
	
	
;///////////////////// new field \\\\\\\\\\\\\\\\\\\\\\\

	$msconnect = mssql_connect("*****" ,"****" ,"*****");
	$msdb = mssql_select_db("kal_db", $msconnect);
	
	$plist =  $plist = "SELECT TOP 1 * FROM [Player] WHERE [Class] = '2' ORDER BY 
	[Admin], [Level] Desc, [Exp] Desc";
	$pplist = mssql_query($plist);
	
	while($list = mssql_fetch_array($pplist)){
	if($list['Class'] == "0"){
	echo "<td><center>";
//	$char = "Knight";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/knight.jpg\"><br>";
	}
	elseif($list['Class'] == "1"){
	echo "<td><center>";
//	$char = "Mage";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/mage.jpg\"><br>";
	}
	elseif($list['Class'] == "2"){
	echo "<td><center>";
//	$char = "Archer";
	echo "<img src=\"http://i3.photobucket.com/albums/y63/mattylongden/archer.jpg\"><br>";
	}
	
	echo "$cha";
	echo "$list[Name]";
	echo ":";
	echo "&nbsp;";
	echo "&nbsp;";
	echo "$list[Level]";
	echo "</center></td>";	

	}
//	echo "<br><br>";
	echo "</table>";	
?>
</center>

[lotje]

thanks max <3

[Goobed]

:) been looking for this

[DeathArt]

Unsecure i believe

How? :p No user input ;-)

[TrueDarKZONE]

thats what i was going say like wdf O.o?

[SIN982]

nice this will be most use full.. it be easy to change the pictures using adob dreamweaver.. if you go to regular kal website and copy those pictures. put them up on like photobucket , and replace it with the ones in there currently.. you will have your ranking .. then maybe change background then center it it will be very nice.. hehehe

[ToXiC L33T]

yep you are right.. I give this code away cos its lame xD thats why its not center and need work but its is what this topic needed.. so enjoy!