[RELEASE] Loads of php scripts for DK servers!

Page 1 of 2 1 2
11/27/2009 12:51 janvier123#1
PHP SCRIPTS

files can be downloaded at
[Only registered and activated users can see links. Click Here To Register...]

PHP Code:
//--------------------------------------
//      Written by Janvier123
//      Made for DK servers
//-------------------------------------- 
Total Players Doing There Quest(s)
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM User_Quest_Doing";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Players Doing There Quest(s): $sad"; 
Total Players Finished There Quest(s)
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM User_Quest_Done";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Players Finished There Quest(s): $sad"; 
Total Characters
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM user_character";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Characters: $sad"; 
Total Deleted Characters
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM user_character_secede";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Deleted Characters: $sad"; 
Total Characters In Guild
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q2 = "SELECT * FROM GUILD_CHAR_INFO";
        $r2 = mssql_query($q2);
        $sad2 = mssql_num_rows($r2);
        echo "Total Characters In Guild: $sad2"; 
Total Dead Fronts
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM CM_BCD_ITEM";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Dead Fronts: $sad"; 
Total Costumes
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM user_suit";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Costumes: $sad"; 
Total Unread Mails
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM USER_POSTBOX";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Unread Mails: $sad"; 
Total Deleted Mails
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM USER_POSTBOX_SECEDE";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Deleted Mails: $sad"; 
Top 100 PVP
PHP Code:
    $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>"; 
Total Used Skills
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM user_skill";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Used Skills: $sad"; 
Total Storage Items
PHP Code:
        $msconnect = mssql_connect("localhost","sa","pass");;
        $msdb = mssql_select_db("character", $msconnect);

        $q = "SELECT * FROM user_storage";
        $r = mssql_query($q);
        $sad = mssql_num_rows($r);
        echo "Total Storage Items: $sad"; 
Top 1 PK
PHP Code:
    $msconnect = mssql_connect("localhost","sa","pass");
    $msdb = mssql_select_db("character", $msconnect);
    $plist = "SELECT TOP 1 character_name, wPKCount FROM [user_character] WHERE wPKCount > '0'order by wPKCount desc";
    $pplist = mssql_query($plist);


    while($list = mssql_fetch_array($pplist)){
    if($list[''] == "0"){
    $char = "";
    }
    echo $list['character_name'];
    } 
Top 1 PVP
PHP Code:
    $msconnect = mssql_connect("localhost","sa","pass");
    $msdb = mssql_select_db("character", $msconnect);
    $plist = "SELECT TOP 1 character_name, dwPVPpoint FROM [user_character] WHERE dwPVPpoint > '0'order by dwPVPpoint desc";
    $pplist = mssql_query($plist);

    while($list = mssql_fetch_array($pplist)){
    if($list[''] == "0"){
    $char = "";
    }
    echo $list['character_name'];
    } 
Top 1 Reborn
PHP Code:
// THIS ONLY WORKS IF THERE IS A TABLE IN "USER_CHARACTER" CALLED "REBORN"



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

    while($list = mssql_fetch_array($pplist)){
    if($list[''] == "0"){
    $char = "";
    }
    elseif($list[''] == "1"){
    $char = "";
    }
    else
    $char = "";
    echo $list['character_name'];
    } 
Top 100 PK
PHP Code:
    $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>"; 
[Only registered and activated users can see links. Click Here To Register...]
11/27/2009 13:04 nobleman80#2
What happened to your DK download site?? i cant download at all.
11/27/2009 14:21 janvier123#3
nothing, everything works here, must be your pc :D
11/27/2009 22:50 gedimazs#4
darnus84 say when your next program will be released? :) Looks awsome
12/02/2009 14:34 gedimazs#5
janvier123 is it possible to write a script that you can check to what players was connected with 1 IP.
for example I enter IP address and press find. And it shows me charnames wich were played using that IP.
Is it possible? :)
12/02/2009 20:29 ~Kakkarot~#6
+#4-5 reported at 2/12/09 GMT +1 20:29 cause double post
12/02/2009 21:16 trane.#7
Quote:
Originally Posted by ~Kakkarot~ View Post
+#4-5 reported at 2/12/09 GMT +1 20:29 cause double post
It's not double post, there are four deleted posts between those two.
12/02/2009 21:58 ~Kakkarot~#8
Quote:
Originally Posted by trane. View Post
It's not double post, there are four deleted posts between those two.
That is why I asked in the "silent action" thread that when you mods do something that you post it so something like this would not happen ;)
12/04/2009 05:54 bagiman#9
kakarot fail :)
12/04/2009 06:53 gedimazs#10
hey cmon guys you have hided my post with your useless posts.Please don't say anything if you can't answear to the question.So sorry for moderators but I will repeat my question again.
janvier123 is it possible to write a script that you can check to what players was connected with 1 IP.
for example I enter IP address and press find. And it shows me charnames wich were played using that IP.
Is it possible?
12/04/2009 10:57 janvier123#11
There is a IP table in account DB but its a "<binary data>" and still from today i cant seem to extract the code from it
if i can extract it it should be very easy
maybe Silkbotter or zombe knows
12/04/2009 12:27 gedimazs#12
Quote:
Originally Posted by janvier123 View Post
There is a IP table in account DB but its a "<binary data>" and still from today i cant seem to extract the code from it
if i can extract it it should be very easy
maybe Silkbotter or zombe knows
here is the code how to extract it maybe this will help you.
Code:
"SELECT account.dbo.FN_IpBinToStr(user_ip_addr) FROM character.dbo.user_character WHERE ...
but I don't know how to make all script what I'm asking for.
12/04/2009 21:47 Decima#13
if you make the query in query analyser you can see the IP, but its in hex, so u will have to convert the hex IP to normal . . .
12/13/2009 16:32 Nosferatu.#14
PHP Code:

<?

/* by Darnus84, have fun... */

$mapid = array
(
0 => "Braiken" ,
1 => "North Ares",
2 => "Norak 1",
3 => "Denebe",
4 => "Easte Ares",
5 => "Heiharp",
6 => "Parca" ,
7 => "Loa" ,
8 => "North Morte",
10 => "Castor 1",
11 => "Frozen" ,
12 => "Crespo",
13 => "Draco" ,
14 => "Norak 2",
15 => "Castor 2",
16 => "Jail",
17 => "Requies" ,
18 => "Avalon" ,
19 => "Python",
20 => "Tomb" ,
21 => "Maze",
22 => "Undo Stadium [PVP Arena]",
23 => "Genoa Castle [Seige]",
26 => "Aquarius",
39 => "Dead Front [Rabble]",
40 => "Dead Front [Common]",
41 => "Dead Front [Baron]",
42 => "Dead Front [Earl]",
43 => "Dead Front [Duke]",
44 => "Dead Front [Arc]",
45 => "Chain of Fire",
46 => "Ruins",
47 => "Space",
62 => "loa agency",
61 => "Braiken agency",
51 => "Qulanes",
52 => "Karon C",
53 => "Karon B",
54 => "Karon A",
55 => "Karon S",
48 => "Space" ,
63 => "DeathLands",
64 => "HAXOR JAIL",
65 => "plane of pilgrimage",
67 => "egutt",
68 => "egutt base",
66 => "Death Land",
71 => "Crespo Base [ABYS]",
71 => "Crespo 1 [ABYS]",
73 => "Crespo 2 [ABYS] ",
74 => "Crespo 3 [ABYS]",
75 => "Crespo 4 [ABYS]"
)


?>
PHP Code:
<?php 
include "mapindex.php";


$mssql = array( 
        'host' => "192.168.123.130", 
        'user' => "sa", 
        'pass' => "1234" 
    ); 
     
echo "<center>Player Online List<br><br>"; 
echo "<table border='1'> 
    <tr> 
        <td align='center'>Character Name</td> 
        <td align='center'>Level</td> 
        <td align='center'>Map</td> 
        <td align='center'>Login</td> 

    </tr>"; 

$con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']); 

$result1 = mssql_query("SELECT user_no FROM account.dbo.USER_PROFILE WHERE login_flag = '1100'",$con); 


while($row1 = mssql_fetch_row($result1)) { 
     
    $result2 = mssql_query("SELECT character_name,wLevel,wMapIndex,login_time FROM character.dbo.user_character WHERE user_no = '".$row1[0]."' ORDER by login_time DESC",$con); 
    $row2 = mssql_fetch_row($result2); 

        echo "<tr> 
            <td align='left'>".$row2[0]."</td> 
            <td align='center'>".$row2[1]."</td> 
            <td align='center'>".$mapid[$row2[2]]."</td> 
            <td align='center'>".$row2[3]."</td> 

        </tr>"; 

} 
echo "</table></center>"; 
?>
12/14/2009 09:20 gedimazs#15
Quote:
Originally Posted by darnus84 View Post
What is it ? :) Showing players online and in what map they are? :) I don't think this thing is usefull anymore, cause the same script was released long time ago. Or maybe I'm wrong?
Page 1 of 2 1 2