Register for your free account! | Forgot your password?

Go Back   elitepvpers › MMORPGs › Dekaron › Dekaron Private Server
any1 got PHP script for online users,top pk top pvp? any1 got PHP script for online users,top pk top pvp?
You last visited: Today at 07:17

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

any1 got PHP script for online users,top pk top pvp?

Discussion on any1 got PHP script for online users,top pk top pvp? within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 1/0/0
Join Date: Jan 2010
Posts: 31
Received Thanks: 3
Question any1 got PHP script for online users,top pk top pvp?

If yes pls sent me
freddan222 is offline  
Old   #2
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 275
Received Thanks: 14
Quote:
Originally Posted by freddan222 View Post
If yes pls sent me
i am have only for pvp top ant pk top i am need to for online player
yahoo5000 is offline  
Old   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Aug 2010
Posts: 126
Received Thanks: 7
PvP



Code:
<?php
//--------------------------------------
//      Written by Janvier123
//      Made for DK servers
//--------------------------------------

        $msconnect = mssql_connect("localhost","sa","pass");
        $msdb = mssql_select_db("character", $msconnect);
        $plist = "SELECT TOP 100 character_name, dwPVPpoint FROM [user_character] WHERE dwPVPpoint > '0'order by dwPVPpoint desc";
        $pplist = mssql_query($plist);

        echo "<table width='400' height='1'><tr valign='top'>";
        echo "<td width='5%'><b></b></td><td width='5%'><b>Name</b></td><td width='5%'><b>Points</b></td></tr><tr valign='top'>";

        while($list = mssql_fetch_array($pplist)){
        if($list[''] == "0"){
        $char = "t";
        }
        elseif($list[''] == "1"){
        $char = "";
        }
        else
        $char = "Archer";
        echo "<td width='5%'>";

        echo "</td>";   
        echo "<td width='5%'>";
        echo $list['character_name'];
        echo "</td>";
        echo "<td width='5%'>";
        echo $list['dwPVPpoint'];
        echo "</td></tr><tr>";
        }
        echo "</tr></table>";



PK

Code:
<?php
//--------------------------------------
//      Written by Janvier123
//      Made for DK servers
//--------------------------------------

        $msconnect = mssql_connect("localhost","sa","pass");
        $msdb = mssql_select_db("character", $msconnect);
        $plist = "SELECT TOP 100 character_name, wPKCount FROM [user_character] WHERE wPKCount > '0'order by wPKCount desc";
        $pplist = mssql_query($plist);

        echo "<table width='400' height='1'><tr valign='top'>";
        echo "<td width='5%'><b></b></td><td width='5%'><b>Name</b></td><td width='5%'><b>Points</b></td></tr><tr valign='top'>";

        while($list = mssql_fetch_array($pplist)){
        if($list[''] == "0"){
        $char = "t";
        }
        elseif($list[''] == "1"){
        $char = "";
        }
        else
        $char = "Archer";
        echo "<td width='5%'>";

        echo "</td>";   
        echo "<td width='5%'>";
        echo $list['character_name'];
        echo "</td>";
        echo "<td width='5%'>";
        echo $list['wPKCount'];
        echo "</td></tr><tr>";
        }
        echo "</tr></table>";
?>



Players Online

Code:
<center>
<?php
//      if (ALLOW_OPEN != 1){
//      exit("<br><img src='images/error_access.png'>");
//      }
include "../config/mssql.conf.php";
/* -------------{The New and improved online users script}------------- */ 
//        The base was made by janvier123 but had alot of issues
//                      This one goes alot deeper and even ignores the bugged way
//                      dekaron stores logout_dates. A whole new approach exclusve for DK-Underground!
//       Henkie2 a.k.a. Pieter or [GM] KissMyBow from Abnormal-Dekaron - April 4th 2010 (11:30 GMT+1)


$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
                $a2c = "SELECT * FROM account.dbo.user_profile where login_flag = '1100'";
                $a2r = mssql_query($a2c);
                $playerson = mssql_num_rows($a2r);

    echo " 
        <center> 
        <b><font size = 5> ($playerson)Players online:</font><b><br><table border='1'><p>&nbsp 
        <tr> 
        <td align='center'><b>Account</b></td> 
        <td align='center'><b>Character</b></td> 
        <td align='center'><b>Level</b></td>
        <td align='center'><b>Reborn</b></td> 
        <td align='center'><b>Class</b></td> 
        <td align='center'><b>MapID</b></td> 
        </tr> 
    "; 
     
    // Exclusive fixed query written by Pieter a.k.a. Henkie2 or [GM] KissMyBow for DK-Underground Forums!
    // Please do NOT post this elsewhere, just redirect ppl that ask for it to the thread on DK-Underground! 
    $result = mssql_query("select p.user_id as uid, c.character_name as cnm, c.wlevel as clvl, c.reborn as crbn, c.wmapindex cmapi, c.bypcclass as ccls, c.login_time FROM character.dbo.user_character c join account.dbo.user_profile p ON c.user_no = p.user_no WHERE c.login_time IN (SELECT max(login_time) FROM character.dbo.user_character GROUP BY user_no) AND p.login_flag = '1100' and c.login_time is not null order by c.wmapindex desc",$ms_con);  
    while ($record = mssql_fetch_array($result)) 
    { 
        if ($record[ccls] == 0) $class = 'Knight'; 
        if ($record[ccls] == 1) $class = 'Hunter'; 
        if ($record[ccls] == 2) $class = 'Mage'; 
        if ($record[ccls] == 3) $class = 'Summy'; 
        if ($record[ccls] == 4) $class = 'Seggy'; 
        if ($record[ccls] == 5) $class = 'Bagi'; 
        if ($record[ccls] == 6) $class = 'Aloken'; 
        // ps did u know u could also use the above trick for maps?
        // just make a row like that with mapid - mapname
        // example
        if ($record[mapi] == 0) $map = 'Braiken'; 
        if ($record[mapi] == 2) $map = 'Norak'; 
        if ($record[mapi] == 6) $map = 'Parca'; 
        if ($record[mapi] == 12) $map = 'Crespo'; 
        if ($record[mapi] == 13) $map = 'Draco'; 
        if ($record[mapi] == 19) $map = 'Python'; 
        if ($record[mapi] == 21) $map = 'Maze'; 
        echo " 
            <tr> 
            <td align=center>$record[uid]</td> 
            <td align=center>$record[cnm]</td> 
            <td align=center>$record[clvl]</td> 
            <td align=center>$record[crbn]</td> 
            <td align=center>$class</td> 
            <td align=center>$record[cmapi]</td> // replace $record[mapi] with $map incase u do the above trick
            </tr> 
        "; 
    } 
    echo '</center>';  
?>
Credits To Janvier
~PsychoPathic~ is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 275
Received Thanks: 14
Quote:
Originally Posted by Blunt420 View Post
PvP



Code:
<?php
//--------------------------------------
//      Written by Janvier123
//      Made for DK servers
//--------------------------------------

        $msconnect = mssql_connect("localhost","sa","pass");
        $msdb = mssql_select_db("character", $msconnect);
        $plist = "SELECT TOP 100 character_name, dwPVPpoint FROM [user_character] WHERE dwPVPpoint > '0'order by dwPVPpoint desc";
        $pplist = mssql_query($plist);

        echo "<table width='400' height='1'><tr valign='top'>";
        echo "<td width='5%'><b></b></td><td width='5%'><b>Name</b></td><td width='5%'><b>Points</b></td></tr><tr valign='top'>";

        while($list = mssql_fetch_array($pplist)){
        if($list[''] == "0"){
        $char = "t";
        }
        elseif($list[''] == "1"){
        $char = "";
        }
        else
        $char = "Archer";
        echo "<td width='5%'>";

        echo "</td>";   
        echo "<td width='5%'>";
        echo $list['character_name'];
        echo "</td>";
        echo "<td width='5%'>";
        echo $list['dwPVPpoint'];
        echo "</td></tr><tr>";
        }
        echo "</tr></table>";



PK

Code:
<?php
//--------------------------------------
//      Written by Janvier123
//      Made for DK servers
//--------------------------------------

        $msconnect = mssql_connect("localhost","sa","pass");
        $msdb = mssql_select_db("character", $msconnect);
        $plist = "SELECT TOP 100 character_name, wPKCount FROM [user_character] WHERE wPKCount > '0'order by wPKCount desc";
        $pplist = mssql_query($plist);

        echo "<table width='400' height='1'><tr valign='top'>";
        echo "<td width='5%'><b></b></td><td width='5%'><b>Name</b></td><td width='5%'><b>Points</b></td></tr><tr valign='top'>";

        while($list = mssql_fetch_array($pplist)){
        if($list[''] == "0"){
        $char = "t";
        }
        elseif($list[''] == "1"){
        $char = "";
        }
        else
        $char = "Archer";
        echo "<td width='5%'>";

        echo "</td>";   
        echo "<td width='5%'>";
        echo $list['character_name'];
        echo "</td>";
        echo "<td width='5%'>";
        echo $list['wPKCount'];
        echo "</td></tr><tr>";
        }
        echo "</tr></table>";
?>



Players Online

Code:
<center>
<?php
//      if (ALLOW_OPEN != 1){
//      exit("<br><img src='images/error_access.png'>");
//      }
include "../config/mssql.conf.php";
/* -------------{The New and improved online users script}------------- */ 
//        The base was made by janvier123 but had alot of issues
//                      This one goes alot deeper and even ignores the bugged way
//                      dekaron stores logout_dates. A whole new approach exclusve for DK-Underground!
//       Henkie2 a.k.a. Pieter or [GM] KissMyBow from Abnormal-Dekaron - April 4th 2010 (11:30 GMT+1)


$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
                $a2c = "SELECT * FROM account.dbo.user_profile where login_flag = '1100'";
                $a2r = mssql_query($a2c);
                $playerson = mssql_num_rows($a2r);

    echo " 
        <center> 
        <b><font size = 5> ($playerson)Players online:</font><b><br><table border='1'><p>&nbsp 
        <tr> 
        <td align='center'><b>Account</b></td> 
        <td align='center'><b>Character</b></td> 
        <td align='center'><b>Level</b></td>
        <td align='center'><b>Reborn</b></td> 
        <td align='center'><b>Class</b></td> 
        <td align='center'><b>MapID</b></td> 
        </tr> 
    "; 
     
    // Exclusive fixed query written by Pieter a.k.a. Henkie2 or [GM] KissMyBow for DK-Underground Forums!
    // Please do NOT post this elsewhere, just redirect ppl that ask for it to the thread on DK-Underground! 
    $result = mssql_query("select p.user_id as uid, c.character_name as cnm, c.wlevel as clvl, c.reborn as crbn, c.wmapindex cmapi, c.bypcclass as ccls, c.login_time FROM character.dbo.user_character c join account.dbo.user_profile p ON c.user_no = p.user_no WHERE c.login_time IN (SELECT max(login_time) FROM character.dbo.user_character GROUP BY user_no) AND p.login_flag = '1100' and c.login_time is not null order by c.wmapindex desc",$ms_con);  
    while ($record = mssql_fetch_array($result)) 
    { 
        if ($record[ccls] == 0) $class = 'Knight'; 
        if ($record[ccls] == 1) $class = 'Hunter'; 
        if ($record[ccls] == 2) $class = 'Mage'; 
        if ($record[ccls] == 3) $class = 'Summy'; 
        if ($record[ccls] == 4) $class = 'Seggy'; 
        if ($record[ccls] == 5) $class = 'Bagi'; 
        if ($record[ccls] == 6) $class = 'Aloken'; 
        // ps did u know u could also use the above trick for maps?
        // just make a row like that with mapid - mapname
        // example
        if ($record[mapi] == 0) $map = 'Braiken'; 
        if ($record[mapi] == 2) $map = 'Norak'; 
        if ($record[mapi] == 6) $map = 'Parca'; 
        if ($record[mapi] == 12) $map = 'Crespo'; 
        if ($record[mapi] == 13) $map = 'Draco'; 
        if ($record[mapi] == 19) $map = 'Python'; 
        if ($record[mapi] == 21) $map = 'Maze'; 
        echo " 
            <tr> 
            <td align=center>$record[uid]</td> 
            <td align=center>$record[cnm]</td> 
            <td align=center>$record[clvl]</td> 
            <td align=center>$record[crbn]</td> 
            <td align=center>$class</td> 
            <td align=center>$record[cmapi]</td> // replace $record[mapi] with $map incase u do the above trick
            </tr> 
        "; 
    } 
    echo '</center>';  
?>
Credits To Janvier
online script is dont work , and can you give some simple script who write only how mach player are online no need map ant other things
yahoo5000 is offline  
Old   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Aug 2010
Posts: 126
Received Thanks: 7
sorry Ill try to get you a working one
~PsychoPathic~ is offline  
Thanks
1 User
Old   #6
 
gedimazs's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2008
Posts: 863
Received Thanks: 197
Players online only showing how many
Code:
<center> </h1>
<body>
<?php
include("config/odbc.conf.php");
	$msconnect = mssql_connect($odbc['IP'],$odbc['user'],$odbc['pass']);
	$msdb = mssql_select_db("account", $msconnect);
	$online="select count(*) from account.dbo.user_profile where login_flag = 1100";
$dk_character04_odbc = odbc_connect('account',$odbc['user'],$odbc['pass']); 
$dk_character04_result=odbc_do($dk_character04_odbc,$online);
odbc_fetch_row($dk_character04_result);
$allnumber04=odbc_result($dk_character04_result,1);
odbc_close($dk_character04_odbc); 
//moon
$dk_charactermoon_odbc = odbc_connect('account',$odbc['user'],$odbc['pass']); 
$dk_charactermoon_result=odbc_do($dk_charactermoon_odbc,$online);
odbc_fetch_row($dk_charactermoon_result);
$allnumbermoon=odbc_result($dk_charactermoon_result,1);

odbc_close($dk_charactermoon_odbc); 

$numberall=$allnumbermoon+$allnumber04;

?>	
	
<body>
<font color="#ffb019"><strong>  
<?php echo $allnumbermoon; ?> online </strong></font>
and config

Code:
<?php

$odbc = array(
		'IP' => 'xxxxxxxxxxx',		
		'user' => "xxxx",
		'pass' => "xxxx"
	);

?>
use it wisely
gedimazs is offline  
Thanks
2 Users
Old   #7
 
Zombe's Avatar
 
elite*gold: 20
The Black Market: 0/0/0
Join Date: Dec 2007
Posts: 1,451
Received Thanks: 841
PHP is the easiest language I know...

Make a script yourself, it's not hard if your IQ is a 2 digit number...
Zombe is offline  
Old   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 275
Received Thanks: 14
Quote:
Originally Posted by Zombe View Post
PHP is the easiest language I know...

Make a script yourself, it's not hard if your IQ is a 2 digit number...
i know how create but dont know how to make script how set all code in needed place for script is work
yahoo5000 is offline  
Reply

« DekaronCrash.exe | will this work? »

Similar Threads Similar Threads
Server is not online for other users
09/26/2011 - Shaiya Private Server - 4 Replies
Alright, so after months of trying I at last go server running, on hamachi of course. The problem is, I DO can play, however as I create the autopatcher for others, they cannot connect. Only an error pops out "Checking server, please try again later" I tried many ways from across the threads here on elitepvpers, however I still can't manage to make it so public, so others can play. Things to know: - We all have hamachi run and connected - The error persists after trying many ways ...
can any1 make new adresses for 12sky2 for CheatEngine script
11/16/2009 - 12Sky2 - 1 Replies
ok guys any can post here new adresses for 12sky2 cuz trainer dont work like old adresses for cheatengine. pls post here new adresses for speed atack and speed movement hack for CheatenginE gl and ty who post here :):handsdown::handsdown::handsdown::handsdown:
Script Users And Makers Read This
11/07/2009 - Grand Chase - 0 Replies
Ok To All The Script Users And Makers Please Dont Tell Anyone How To Make An Edited Script Since You Wont Know Who Will Go Back And Notify The Gms On GC About What Exactly It Is We Are Editing That Will Result In Them Patching It .. And To The Script Users Please Dont Abuse These Hacks Since It Can Result In An Investigation Which Can Lead To The Editing To Be Patched .. Thank You For Reading This Post
Brian~'s Script Users, Pls Read...
10/31/2009 - Grand Chase - 36 Replies
@all: Very Important I need to know if there were issues pertaining to usage of Brian~'s scripts, like pc crashed or got infected with any viruses or such that may tend your pc programs or pc itself to act weirdly or slowly....?? :confused: The reason why I am asking its because I received a report from a "GCPH Player-" and he complained that his 2 pc crashed after using Bri's scripts. Of course, I am one of Bri's scripts user and i already told him that i never experienced such thing,...
any1 know the web of script vessel?
07/04/2008 - Conquer Online 2 - 1 Replies
any1 can help me to dowloand script vessel? thanks.



All times are GMT +1. The time now is 07:18.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.