create config.php and put
<?php
$L2JBS_config["mysql_host"]="localhost"; // MySQL Host ["localhost"]
$L2JBS_config["mysql_port"]="3306"; // MySQL Port ["3306"]
$L2JBS_config["mysql_db"]="l2jdb"; // MySQL Database ["l2jdb"]
$L2JBS_config["mysql_login"]="root"; // MySQL User ["root"]
$L2JBS_config["mysql_password"]="master"; // MySQL Password ["root"]
include("_config_procs.php");
error_reporting(0);
?>[/
create _config_procs.php and put
<?php
$link = mysql_connect($L2JBS_config['mysql_host'].":".$L2JBS_config['mysql_port'], $L2JBS_config['mysql_login'], $L2JBS_config['mysql_password']);
if (!$link)
die("Couldn't connect to MySQL");
@mysql_select_db($L2JBS_config['mysql_db'], $link);
error_reporting(0);
?>
create for example bobi.php and put this
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>GameMasters Script By Leki</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
<!--
body,td,th {
color: #CCCCCC;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
body {
background-color: #000000;
}
-->
</style>
</head>
<body>
<table style="border: 1px solid; border-color: #444444; background-color:#222222;" align="center" width="100%">
<tr>
<th class='Stil7' colspan="5" align="center" width="100%">Top 100 PK</th>
</tr>
<tr>
<th width="1%" style="border: 1px solid; border-color: #444444; background-color:#222222;">ID</th>
<th width="10%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Character Name </th>
<th width="2%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Class </th>
<th width="6%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> IP Address </th>
</tr>
<?php
require("Config.php");
$activity = mysql_query("SELECT
characters.char_name,
characters.obj_Id,
characters.char_name,
characters.level,
characters.classid,
characters.online,
char_templates.ClassId,
char_templates.ClassName,
accounts.login,
accounts.lastIP,
characters.account_name
FROM
characters ,
char_templates ,
accounts
WHERE
characters.online = 1 AND
char_templates.ClassId = characters.classid AND
characters.account_name = accounts.login
ORDER BY characters.char_name DESC
LIMIT 20
");
$i = 1;
while($row = mysql_fetch_array($activity))
{
if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";
else
echo "<tr bgcolor='#161616' align='center'>";
echo "<td>"."<center>".$i."</center>"."</td>";
echo "<td>"."<center>".$row['char_name']."</center>"."</td>";
echo "<td>"."<center>".$row['ClassName']."</center>"."</td>";
echo "<td>"."<center>".$row['lastIP']."</center>"."</td>";
$i++;
}
?>
</table>
</body>
</html>