Wie postet man deas :D?
epvp hab ich auch keine ahnung
PHP Code:
<div style="float:left; margin-left:20px;">
<?PHP
mysql_select_db("player");
$output = mysql_query("SELECT COUNT(*) as count FROM player WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < last_play;");
$online_count = mysql_fetch_object($output)->count+1;
echo "<font style=font-size:12px;>Es sind</font> <font style=font-size:20px; color=yellow>$online_count</font> <font style=font-size:12px;>Spieler Online</font>";
?>
</div>
<div style="font-size:12px; text-transform:uppercase; ">
<?php
$serverip = "localhost";
$ip = gethostbyname($serverip);
$portlist=array(11002, 13000, 13003, 3306);
$status=array("login: ", "world: ", "char:", "mysql:");
$i=0;
foreach ($portlist as $port){
$online = @fsockopen($ip, $port, $errno, $errstr, 1);
if (!$online)
{
echo "".$status[$i]." <font color=red>Offline </font>";
}
else
{
echo "".$status[$i]." <font color=#669e33>Online </font>";
}
@fclose($online);
$i++;
}
?>
<input style="margin-top:5px;" type="submit" onclick="reloadstatus()" class="btn" value="Neuladen" href="#" name="submit">
</div>
__________________________________________________ ___________
PHP Code:
<?PHP
$CPSeite = 50;
$markierteZeile=0;
if(isset($_GET['p'])) {
if(!checkInt($_GET['p']) || !($_GET['p']>0)) $aSeite = 1;
else $aSeite = $_GET['p'];
}
else { $aSeite = 1; }
if(isset($_POST['suche']) && $_POST['suche']=='suchen') {
if(!empty($_POST['charakter'])) {
$sqlCmd="SELECT id, name, level, exp, empire, guild_name, rang
FROM (
SELECT id, name, level, exp, empire, guild_name, @num := @num +1 AS rang
FROM (
SELECT player.id, player.name, player.level, player.exp, player_index.empire, guild.name AS guild_name, @num :=0
FROM player.player
LEFT JOIN player.player_index ON player_index.id = player.account_id
LEFT JOIN player.guild_member ON guild_member.pid = player.id
LEFT JOIN player.guild ON guild.id = guild_member.guild_id
INNER JOIN account.account ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC , player.exp DESC
) AS t1
) AS t2
WHERE name LIKE '".mysql_real_escape_string($_POST['charakter'])."' LIMIT 1";
$sqlQry=mysql_query($sqlCmd,$sqlServ);
if(mysql_num_rows($sqlQry)>0) {
$getRang = mysql_fetch_object($sqlQry);
$aSeite = ceil($getRang->rang/$CPSeite);
$markierteZeile = $getRang->rang;
}
}
}
$sqlCmd = "SELECT COUNT(*) as summeChars
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$getSum = mysql_fetch_object($sqlQry);
$cSeite = calcPages($getSum->summeChars,$aSeite,$CPSeite);
?>
<?PHP
$maxRange = 10;
$maxStep = 15;
if(($aSeite-$maxRange)>0) $sStart = $aSeite-$maxRange;
else $sStart = 1;
if(($aSeite+$maxRange)<=$cSeite[0]) $sEnde = $aSeite+$maxRange;
else $sEnde = $cSeite[0];
?>
<table style="width:180px; font-size:12px;">
<tr>
<th width=75 align=center>Platz</th>
<th width=75 align=center>Name</th>
<th width=75 align=center>Level</th>
</tr>
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC
LIMIT ".$cSeite[1].",".$CPSeite;
//echo $sqlCmd;
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$x=$cSeite[1]+1;
while($getPlayers = mysql_fetch_object($sqlQry)) {
if($x == "1")
{
echo "<tr>";
echo '<td width=75 align=center><img src="./bilder/'.$x.'_platz.png" title="Gold" alt="Gold"/></td>';
echo "<td width=75 align=center><a style='color:#d5aa00' href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center><a style='color:#d5aa00'>".$getPlayers->level."</a></td>";
}
elseif($x == "2")
{
echo "<tr>";
echo '<td width=75 align=center><img src="./bilder/'.$x.'_platz.png" title="Silber" alt="Silber"/></td>';
echo "<td width=75 align=center><a style='color:#999999' href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center><a style='color:#999999'>".$getPlayers->level."</a></td>";
}
elseif($x == "3")
{
echo "<tr>";
echo '<td width=75 align=center><img src="./bilder/'.$x.'_platz.png" title="Bronze" alt="Bronze"/></td>';
echo "<td width=75 align=center><a style='color:#663300' href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center><a style='color:#663300'>".$getPlayers->level."</a></td>";
}
elseif($x == "4")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
elseif($x == "5")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
elseif($x == "6")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
elseif($x == "7")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
elseif($x == "8")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
elseif($x == "9")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
elseif($x == "10")
{
echo "<tr>";
echo "<td width=75 align=center>".$x."</td>";
echo "<td width=75 align=center><a href=\"index.php?s=view_char&id=".$getPlayers->id."\">".$getPlayers->name."</a></td>";
echo "<td width=75 align=center>".$getPlayers->level."</td>";
}
$x++;
}
?>
</table>
.
Was mus ich jetz da dran ändern?