|
You last visited: Today at 15:43
Advertisement
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.
08/29/2010, 17:09
|
#1
|
elite*gold: 0 
Join Date: Jan 2010
Posts: 31
Received Thanks: 3
|
any1 got PHP script for online users,top pk top pvp?
If yes pls sent me 
|
|
|
|
08/29/2010, 17:40
|
#2
|
elite*gold: 0
Join Date: Mar 2010
Posts: 275
Received Thanks: 14
|
Quote:
Originally Posted by freddan222
If yes pls sent me |
i am have only for pvp top ant pk top i am need to for online player
|
|
|
|
|
08/29/2010, 17:59
|
#3
|
elite*gold: 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> 
<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
|
|
|
|
|
08/29/2010, 18:07
|
#4
|
elite*gold: 0
Join Date: Mar 2010
Posts: 275
Received Thanks: 14
|
Quote:
Originally Posted by Blunt420
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> 
<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
|
|
|
|
|
08/29/2010, 18:08
|
#5
|
elite*gold: 0
Join Date: Aug 2010
Posts: 126
Received Thanks: 7
|
sorry  Ill try to get you a working one
|
|
|
|
|
08/29/2010, 20:09
|
#6
|
elite*gold: 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 
|
|
|
|
|
08/30/2010, 12:36
|
#7
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,450
Received Thanks: 833
|
PHP is the easiest language I know...
Make a script yourself, it's not hard if your IQ is a 2 digit number...
|
|
|
|
|
08/30/2010, 14:29
|
#8
|
elite*gold: 0
Join Date: Mar 2010
Posts: 275
Received Thanks: 14
|
Quote:
Originally Posted by Zombe
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 
|
|
|
|
 |
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 +2. The time now is 15:43.
|
|
