[PHP] Top Ranked 3 Class..

[ToXiC L33T]

I know most of ya know how its done.. so whatever xD.. This post is for the newbies or the people that dont know php.

<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>

SS: http://forum.ragezone.com/attachment...king-ranks.jpg

Play around with it and it can look nice :)
If you want to add it to your ranks page then open your ranks.php file with notepad or whatever and look for at the top:

<?php

under it just add this line:

Include 'your_top_3_file_name.php';

-------------
This was something I found on my old website, so put it up here :) its not great nor the best php xD

[MentaL]

[lotje]

nice realease max, it would make ranking give a better look =)

[DeathArt]

Here are some better quality images for a top3, if anyone wants.







Screenshotted by ZenTiX.

[Stup]

g60 golden would be better :D

and zentix is a faggot, scammed eliot on hanin >_>

[DeathArt]

and zentix is a faggot, scammed eliot on hanin >_>

No...
ZenTiX always been playing fair, and a good friend of mine. He never spend money on kalcash items either. He just know how to play the game :)
And opposit to me , he never cheated/hacked either.

[11:14] <TheDeathArt> http://forum.ragezone.com/f315/php-top-ranked-3-class-314804/#post2729882
[11:14] <TheDeathArt> ZenTiX scammed somebody :o
[11:14] <ZenTiX> ?!
[11:14] <ZenTiX> oh wow
[11:14] <ZenTiX> I scammed Elliot? :D
[11:15] <ZenTiX> dude wtf :D
[11:15] <ZenTiX> we quit kal together
[11:15] <ZenTiX> then moved on to lost soul thing
[11:15] <ZenTiX> haven't seen him since
[11:15] * ZenTiX giggles
[11:15] <TheDeathArt> hehe
[11:16] <ZenTiX> wonder how he got that idea
[11:16] <TheDeathArt> so I figured

[ToXiC L33T]

ty for the images DeathArt :-)

[knast183]

I made g60 pics for the ranking, i hope someone likes it:)

[lotje]

looking nice ;) much better then g55

[2Kxx]

Thx MaX! nice work :) now the ranking looks better.

[alin2008]

Any one can upload a full ranking please ??? because this dont work for me :| i'm changed all mssql ling password connection but dont work

[2Kxx]

then it isnt wrong with the ranking.php..
maybe you make something wrong?

[Flohle]

if you just copy all an inser the SQL IP, User and PW it works fine ^.^

I think he changed something and now he don'T know what

[ObuolYs]

Can you make ranking with online status player ? ^^

[Raiz3n]

I got error when i want use that:

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'admin'. (severity 16) in C:\xampp\htdocs\fusion\files\rank3.php on line 12

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\fusion\files\rank3.php on line 12

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\fusion\files\rank3.php on line 16

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'admin'. (severity 16) in C:\xampp\htdocs\fusion\files\rank3.php on line 55

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\fusion\files\rank3.php on line 55

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\fusion\files\rank3.php on line 57

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'admin'. (severity 16) in C:\xampp\htdocs\fusion\files\rank3.php on line 97

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\fusion\files\rank3.php on line 97

Warning: mssql_fetch_array(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\fusion\files\rank3.php on line 99

can someone help?

[GT2143]

Can you make ranking with online status player ? ^^

yes please :P

[2Kxx]

Learn the basics of php the whole day and you'll manage to create on by yourself.