l2topzone.com
l2topzone.com
l2topzone.com
l2topzone.com
l2topzone.com
l2topzone.com
l2topzone.com

Author Topic: [Share] Top PvP/Pk For Site  (Read 5864 times)

0 Members and 1 Guest are viewing this topic.

OfflineDownUnder

  • Hero Member
  • *****
  • Posts: 1486
  • L2topzone Votes: 6
  • Servers reviews: 0
  • Reputation: +3236/-0
  • http://www.L2Drug.com
    • Join Us
[Share] Top PvP/Pk For Site
« on: February 07, 2011, 10:22:09 AM »
Hello L2TopZone Members Because We Don't Have Design Section I Add This Share Here:

config.php
Code: [Select]
<?php
$database_info = array(
'host' => 'localhost',  
'user' => 'root',
'password' => 'some_password',
'l2jdb' => 'l2jdb'
);


?>


databaseinfo.php
Code: [Select]
<?php


@mysql_connect($database_info['host'], $database_info['user'], $database_info['password']) or die(mysql_error());
@mysql_select_db($database_info['l2jdb']) or die(mysql_error());
?>


toppvp.php
Code: [Select]
<?php
// Connection
include 'config.php';
include 'databaseinfo.php';
?>


<?php
echo "<table>";

$query "SELECT * FROM characters WHERE accesslevel = 0 ORDER BY pvpkills DESC limit 10"//change 10 to whatever amount you want to show on your website.
//Connection CMD
$result mysql_query($query) or die(mysql_error());

// loops results
while ($row mysql_fetch_array($result)) 

{
//Adding Variables like a boss!
$name $row['char_name'];
$level $row['level'];
$pvpscore $row['pvpkills']; 
$pkscore $row['pkkills'];



// Inserting data into the table
echo "

<tr>
<td>
$name</td>
<td>
$level</td>
    <td>
$pvpscore</td>
<td>
$pkscore</td>
</tr>"
;

}

echo 
"</table>";

//closing mysql connection
mysql_close();
?>


You will need to add the HTML table yourself, it is all set up though, it displays as NAME LEVEL PVP PK

Enjoy.
Credits : L2CYBER TEAM


Linkback: https://l2topzone.com/forum/index.php?topic=2365.0

l2topzone.com
l2topzone.com
l2topzone.com
l2topzone.com
l2topzone.com

OfflineEglezakioc

  • Full Member
  • ***
  • Posts: 205
  • L2topzone Votes: 0
  • Servers reviews: 4
  • Reputation: +661/-0
    Re: [Share] Top PvP/Pk For Site
    « Reply #1 on: February 07, 2011, 01:46:49 PM »
    i have seen this before...

    OfflineTiTaNiUm

    • Hero Member
    • *****
    • Posts: 552
    • L2topzone Votes: 243
    • Servers reviews: 2
    • Reputation: +880/-0
    • ][TiTaNiUm][
      Re: [Share] Top PvP/Pk For Site
      « Reply #2 on: February 08, 2011, 09:09:24 AM »
      nice share downuner !!

      OfflineBoOmBoOm

      • Full Member
      • ***
      • Posts: 145
      • L2topzone Votes: 0
      • Servers reviews: 0
      • Reputation: +446/-1
      • ★MaxCheaters★
        Re: [Share] Top PvP/Pk For Site
        « Reply #3 on: February 13, 2011, 01:15:25 PM »
        English section

        Post Merge: February 13, 2011, 02:06:07 PM
        very nC guide
        « Last Edit: February 13, 2011, 02:06:07 PM by MrAnGeL »

        OfflineDownUnder

        • Hero Member
        • *****
        • Posts: 1486
        • L2topzone Votes: 6
        • Servers reviews: 0
        • Reputation: +3236/-0
        • http://www.L2Drug.com
          • Join Us
        Re: [Share] Top PvP/Pk For Site
        « Reply #4 on: February 13, 2011, 03:05:48 PM »
        i have seen this before...
        what do you mean?
        « Last Edit: May 05, 2011, 07:59:22 AM by DownUnder™ »

        OfflinePl4yM4keR

        • Newbie
        • *
        • Posts: 30
        • L2topzone Votes: 0
        • Servers reviews: 0
        • Reputation: +65/-0
          Re: [Share] Top PvP/Pk For Site
          « Reply #5 on: July 27, 2011, 11:58:21 AM »
          Can somebody tell me where to add there codes if I have html site? :D
          Thanks!

           

          Sitemap