|
You last visited: Today at 17:48
Advertisement
[RELEASE] Loads of php scripts for DK servers!
Discussion on [RELEASE] Loads of php scripts for DK servers! within the Dekaron Private Server forum part of the Dekaron category.
11/27/2009, 12:51
|
#1
|
elite*gold: 20 
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
[RELEASE] Loads of php scripts for DK servers!
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>";
|
|
|
|
11/27/2009, 13:04
|
#2
|
elite*gold: 0
Join Date: Jan 2009
Posts: 397
Received Thanks: 66
|
What happened to your DK download site?? i cant download at all.
|
|
|
|
|
11/27/2009, 14:21
|
#3
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
nothing, everything works here, must be your pc 
|
|
|
|
|
11/27/2009, 22:50
|
#4
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
darnus84 say when your next program will be released?  Looks awsome
|
|
|
|
|
12/02/2009, 14:34
|
#5
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
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
|
#6
|
elite*gold: 35
Join Date: Aug 2009
Posts: 5,822
Received Thanks: 1,958
|
+#4-5 reported at 2/12/09 GMT +1 20:29 cause double post
|
|
|
|
|
12/02/2009, 21:16
|
#7
|
elite*gold: 0
Join Date: Aug 2008
Posts: 8,097
Received Thanks: 3,355
|
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.
|
|
|
|
|
12/02/2009, 21:58
|
#8
|
elite*gold: 35
Join Date: Aug 2009
Posts: 5,822
Received Thanks: 1,958
|
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 
|
|
|
|
|
12/04/2009, 05:54
|
#9
|
elite*gold: 0
Join Date: Oct 2008
Posts: 142
Received Thanks: 7
|
kakarot fail
|
|
|
|
|
12/04/2009, 06:53
|
#10
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
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
|
#11
|
elite*gold: 20
Join Date: Nov 2007
Posts: 2,853
Received Thanks: 1,876
|
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
|
#12
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
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.
|
|
|
|
|
12/04/2009, 21:47
|
#13
|
elite*gold: 0
Join Date: Aug 2009
Posts: 1,297
Received Thanks: 928
|
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
|
#14
|
elite*gold: 22
Join Date: Jan 2008
Posts: 743
Received Thanks: 450
|
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
|
#15
|
elite*gold: 0
Join Date: May 2008
Posts: 863
Received Thanks: 197
|
Quote:
Originally Posted by darnus84
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?
|
|
|
|
All times are GMT +2. The time now is 17:48.
|
|
![[RELEASE] Loads of php scripts for DK servers!](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/release-loads-php-scripts-dk-servers_ltr.gif){kind=small}
