![[PHP] Code Sammlung](https://www.elitepvpers.com/forum/iconimages/wow-private-server/php-code-sammlung_ltr.gif){kind=small}
[PHP] Code Sammlung
Ihr könnt diese für eure Website verwenden, bearbeiten oder sonstiges.
Wenn ihr diese aber weiter verbreitet bitte mich als Ersteller vermerken.
Config
PHP Code:
<?php
$host = "127.0.0.1"; //MySQL Ip
$user = "root";//MYSQL Benutzer
$pass = "trinity"; //MySQL Passwort
$char_data = "characters"; //Characters Datenbank
$acc_data = "realmd"; //Account Datenbank
error_reporting(0); //Verhindert das ausgeben von Fehlern
$conn = mysql_connect($host, $user, $pass) or (mysql_error());
mysql_select_db($char_data, $conn);
?>
Spieler die online sind
PHP Code:
<?php
include('config.php');
$sql = "SELECT SUM(online) FROM characters";
$sqlquery = mysql_query($sql) or die(mysql_error());
$memb = mysql_result($sqlquery,0,0);
echo($memb);
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
$asql = "SELECT SUM(online) FROM characters WHERE race IN(1,3,4,7,11)";
$asqlquery = mysql_query($asql) or die(mysql_error());
$amemb = mysql_result($asqlquery,0,0);
echo($amemb);
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
$hsql = "SELECT SUM(online) FROM characters WHERE race IN(2,5,6,8,10)";
$hsqlquery = mysql_query($hsql) or die(mysql_error());
$hmemb = mysql_result($hsqlquery,0,0);
echo($hmemb);
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
$crea = "SELECT * FROM characters";
$creat = mysql_query($crea) or die(mysql_error());
$created = mysql_num_rows($creat);
echo($created);
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
$tic = "SELECT * FROM gm_tickets WHERE closed = 0";
$tick = mysql_query($tic);
$ticket = mysql_num_rows($tick);
echo($ticket);
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
mysql_select_db ($acc_data);
$uptime_query = mysql_query("SELECT * FROM uptime WHERE realmid = 1 ORDER BY starttime DESC LIMIT 1") or die(mysql_error());
$row = mysql_fetch_array($uptime_query);
$tag = floor($row['uptime'] / 86400);
$stunde = floor($row['uptime'] / 3600) - $day * 24;
$minute = floor($row['uptime'] / 60 / 60);
$uptime_string = $tag.'T '.$stunde.'S '.$minute.'M';
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
$acc = mysql_query("Select * FROM account") or die(mysql_error());
$account = mysql_num_rows($acc);
$echo($account);
mysql_close($conn);
?>
PHP Code:
<?php
include('config.php');
$accb = mysql_query("SELECT SUM(active) FROM account_banned WHERE active=1");
$account_banned = mysql_result($accb,0,0);
echo($account_banned);
mysql_close($conn);
?>
PHP Code:
<html>
<head>
<title>Top kills</title>
</head>
<body>
<table>
<tr>
<th width="248"><strong><font color="#FF0000" size="+1">Name</font></strong></th>
<th width="237"><strong><font color="#00FF00" size="+1">Kills</font></strong></th>
</tr>
<?php
include('config.php');
mysql_query( "SET NAMES 'utf8'" );
$query = mysql_query("SELECT * FROM characters ORDER BY `totalKills` DESC LIMIT 0,20");
while($row=mysql_fetch_array($query)){
$name = $row['name'];
$kills = $row['totalKills'];
echo('
<tr>
<td><center><font color="#00FFFF">'.$name.'</font></center></td>
<td><center><font color="#CC6600">'.$kills.'</font></center></td>
</tr>');
}
mysql_close($conn);
?>
</table>
</body>
</html>
Wenn ich noch mehr erstelle und diese Public stellen will werde ich diese hier posten.
P.S. Bei Fragen oder sonstiges einfach einen Post hier erstellen.
