[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 " ";
    echo " ";
    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 " ";
    echo " ";
    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 " ";
    echo " ";
    echo "$list[Level]";
    echo "</center></td>";    

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

SS: http://forum.ragezone.com/attachments/f388/45711d1192368135-request-top3-ranking-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

 

[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

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]

Re: g60 would be nice

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

 

[2Kxx]

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