Hello & Welcome to our community. Is this your first visit? Register
Follow us on
Follow us on Facebook Follow us on Twitter Watch us on YouTube


MMOCoin

Likes Likes:  0
Results 1 to 5 of 5

Thread: Top PVP List

  1. #1
    Contributor
    StickyIcky's Avatar
    Join Date
    Jul 2008
    Location
    127.0.0.1
    Posts
    747
    Post Thanks / Like
    Rep Power
    19
    Reputation
    188

    Top PVP List


    Register to remove this ad
    This will list the Top PVPers of your realm



    Code:
    <?php
    
    $db_host='hostname';
    $db_db='dbname';
    $db_user='user';
    $db_pas='password';
    
    $connection = @mysql_connect($db_host, $db_user, $db_pass);
    $db_select = @mysql_select_db($db_db);
    
    $query = 'SELECT name, killsLifeTime FROM characters WHERE killsLifeTime > 0 ORDER BY killsLifeTime DESC LIMIT 10'; // Change the 10 to the number of results (10 for top 10, 100 for top 100, etc)
    $pvplist = @mysql_query($query);
    echo '<table>';
    while($pvp_row = mysql_fetch_assoc(($pvplist)))
    {
      echo '<tr><td>'. $pvp_row["name"] .'</td><td>'. $pvp_row["killsLifeTime"] .'</td></tr>';
    }
    
    echo '</table>';
    ?>



    › See More: Top PVP List



  2. Related Threads - Scroll Down after related threads if you are only interested to view replies for above post/thread

  3. #2
    Sergeant

    Join Date
    Jul 2008
    Location
    In Earth
    Posts
    84
    Post Thanks / Like
    Rep Power
    17
    Reputation
    11
    Dude i've never seen u do PHP or giving credits to anyone else :S
    Still for adding more stuff x1rep

  4. #3
    Succy
    Guest
    Haha, I like it :P +Rep for both this and your arena top :P

  5. #4
    Scout
    Xcynic's Avatar
    Join Date
    Aug 2008
    Location
    Sweden
    Posts
    29
    Post Thanks / Like
    Rep Power
    17
    Reputation
    25
    oO very nice, Will be used...Great job.

  6. #5
    Contributor
    LiLLeCarl's Avatar
    Join Date
    Jan 2009
    Posts
    106
    Post Thanks / Like
    Rep Power
    17
    Reputation
    84

    Register to remove this ad
    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\xampp\htdocs\test\pvprealmpage\php\killranker.p hp on line 14

 

 

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!
SEO Blog

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -5. The time now is 10:59 AM.
Powered by vBulletin® Copyright ©2000-2024, Jelsoft Enterprises Ltd.
See More links by ForumSetup.net. Feedback Buttons provided by Advanced Post Thanks / Like (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
vBulletin Licensed to: MMOPro.org