[RELEASE] Loads of php scripts for DK servers!

janvier123 · 11/27/2009, 12:51

PHP SCRIPTS

files can be downloaded at

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>";

~~nobleman80~~ · 11/27/2009, 13:04

What happened to your DK download site?? i cant download at all.

janvier123 · 11/27/2009, 14:21

nothing, everything works here, must be your pc

gedimazs · 11/27/2009, 22:50

darnus84 say when your next program will be released?

Looks awsome

gedimazs · 12/02/2009, 14:34

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?

~~~Kakkarot~~~ · 12/02/2009, 20:29

+#4-5 reported at 2/12/09 GMT +1 20:29 cause double post

~~trane.~~ · 12/02/2009, 21:16

Quote:

Originally Posted by ~Kakkarot~

+#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.

~~~Kakkarot~~~ · 12/02/2009, 21:58

Quote:

Originally Posted by trane.

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

~~bagiman~~ · 12/04/2009, 05:54

kakarot fail

gedimazs · 12/04/2009, 06:53

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?

janvier123 · 12/04/2009, 10:57

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

gedimazs · 12/04/2009, 12:27

Quote:

Originally Posted by janvier123

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.

Decima · 12/04/2009, 21:47

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 . . .

Nosferatu. · 12/13/2009, 16:32

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>"; 

?>

gedimazs · 12/14/2009, 09:20

Quote:

Originally Posted by darnus84

Spoiler

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>"; ?>

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?