Ich mache hier mal ein paar kleine SQL abfragen für eure homepage *public*.
Ihr könnt sie ganz einfach in eure Homepage einbauen.
Mitwierkende :
Purusha
0x1338_#
SoNiice
AciDDreaM
iKyroja :>
Login Script :
PHP Code:
<?php
if(isset($_POST['submit']) && $_POST['submit'] == 'Einloggen') {
$account = mysql_real_escape_string($_POST['account']); // Das ist der Account Input
$password = mysql_real_escape_string($_POST['password']); // Das ist der Passwort Input
$select = "SELECT * FROM account.account WHERE login = '".$account."' AND password = '".$password."'";
$query = mysql_query($select);
$result = mysql_num_rows($query);
if($result > 0) {
echo 'Sie haben sich erfolgreich eingeloggt !'; // Du hast dich eingeloggt
} else {
echo 'Login fehlgeschlagen !'; // Du konntest dich nicht einloggen
}
}
?>
<form action="login.php" method="post">
<input type="text" name="account" onFocus="if(this.value=='Account') this.value='';" onBlur="if(this.value=='') this.value='Account';" value="Account"><br>
<input type="password" name="password" onFocus="if(this.value=='password') this.value='';" onBlur="if(this.value=='') this.value='password';" value="password"><br>
<input type="submit" name="submit" value="Einloggen">
<input type="submit" value="Registrieren">
</form>
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$chars = "SELECT * from player";
$charsquery = mysql_query($chars);
$charszahl = mysql_num_rows($charsquery);
echo "Charaktere : $charanzahl";
Account Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("account");
$accs = "SELECT * from account";
$accsquery = mysql_query($accs);
$accszahl = mysql_num_rows($accsquery);
echo "Account : $accszahl";
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$items = "SELECT * FROM item ";
$itemsquery = mysql_query($items);
$itemanzahl = mysql_num_rows($itemsquery);
echo "Items : $itemanzahl";
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$guilds ="SELECT * FROM guild";
$guildsquery = mysql_query($guilds);
$guildanzahl = mysql_num_rows ($guildsquery);
echo "Gilden : $guildanzahl";
Spieler online :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
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 "Spieler Online : $online_count";
Ranking ohne GMs GAs :
PHP Code:
<?php
echo "<center>";
include('inc/config.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
$test = "SELECT * from player";
$testquery = mysql_query($test);
$num2 = mysql_num_rows($testquery);
if($_GET['max']) {
$get = $_GET['max'];
} else {
$get = '0';
$max = $get + 20;
$max2 = $get - 20;
if($get > $num2) {
}
elseif($get >= 20 && $get < $num2) { }
elseif ($num2 <= 20) { echo ""; }
else { }
echo "</center><br>";
?>
<center><table border="0">
<tr>
<th width="150">Platz</th>
<th width="150">Name</th>
<th width="150">Level</th>
<th width="150">Exp</th>
<th width="150">Reich</th>
</tr>
</table></center>
<?php
include('inc/config.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
// Select player etc from db //
$rank = "SELECT * from player WHERE name NOT LIKE '[GA]%' and name NOT LIKE '[GM]%' order by level desc limit 10";
$query = mysql_query($rank);
echo "<center><table border=\"0\">"; // Open table
$i = 0;
while($array = mysql_fetch_array($query)) {
$i = $i + 1;
echo "
<tr>
<th width=\"150\"><font color=\"black\">" . $i . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["name"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["level"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["exp"] . "</font></th>";
$reich = "SELECT empire from player_index where id = " . $array[account_id] . "";
$query2 = mysql_query($reich);
$array2 = mysql_fetch_array($query2);
if($array2["empire"] == 1) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/red.jpg\"></th></tr>";
} elseif($array2["empire"] == 2) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/yellow.jpg\"></th></tr>";
} else {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/blue.jpg\"></th></tr>";
}
}
echo "</table></center><br>"; // close table
}
?>
PHP Code:
<body>
<div id="Felder">
<form action="regi.php" method="post" >
Benutzername<br />
<input type="text" name="username" size="30" /><br />
Passwort<br />
<input type="password" name="passwd" size="30" /><br />
Passwort Wiederholen<br />
<input type="password" name="passwd2" size="30" /><br />
Name<br />
<input type="text" name="rl_name" size="30" /><br />
Email<br />
<input type="text" name="email" size="30" /><br />
Löschcode<br />
<input type="text" maxlength="7" name="social_id" size="30" /><br />
<br />
<input type="submit" name="submit" value="Register" />
</form>
</div>
</body>
</html>
<?php
include('config.php');
if(isset($_POST['submit']) && $_POST['submit'] == 'Register') {
$username = mysql_real_escape_string($_POST['username']);
$passwd = mysql_real_escape_string($_POST['passwd']);
$passwd2 = mysql_real_escape_string($_POST['passwd2']);
$rl_name = mysql_real_escape_string($_POST['rl_name']);
$email = mysql_real_escape_string($_POST['email']);
$social_id = mysql_real_escape_string($_POST['social_id']);
if($passwd == $passwd2) {
$sql = "INSERT INTO account SET login = '".$username."', password = PASSWORD('".$passwd."'), real_name = '".$rl_name."', email = '".$email."', social_id = '".$social_id."'";
$result = mysql_query($sql);
if($result) { echo "<font color=\"green\"><b>Sie haben erfolgreich einen Account erstellt!</b></font>"; } else { echo "<font color=\"red\"><b>Registrierung Fehlgeschlagen!</b></font>"; }
}
}
?>
Online-Status des Server ohne "Blackout-gaming"
PHP Code:
$serverip = "eure_server_ip";
$ip = gethostbyname($serverip);
$portlist=array(3306,11003, 13000, ); // Den port den ihr sehen wollt
$status=array("Login Server", "Char Server", "World Server"); // Bezeichnung
$i=0;
foreach ($portlist as $port){
echo "".$status[$i]."";
$online = @fsockopen($ip, $port, $errno, $errstr, 1);
if (!$online)
{
echo "<td><img src=img/offline.gif width=16 height=12 /></td>"; #
}
else
{
echo "<td><img src=img/online.gif width=16 height=12 /></td>";
}
@fclose($online);
$i++;
}
Admin rechte ohne Reboot by SOD666
PHP Code:
<?php
$IP = "EUERE IP HIER EINTRAGEN";
//Port = $_GET['port'];
//$Port = "";
$Port = "EUEREN PORT HIER EINTRAGEN";
if($IP && $Port)
{
$socket = socket_create (AF_INET, SOCK_STREAM, SOL_TCP);
$result = socket_connect ($socket, $IP, $Port);
$query = "\x40SHOWMETHEMONEY\x0A";
$query .= "\x40RELOAD a\x0A";
//$query .= $_GET['query'];
$query_size = strlen($query);
$write_res = socket_write($socket, $query, $query_size);
$recv_res = socket_recv($socket, $output, 5056, 0);
echo $output;
socket_close($socket);
}
?>
-Apache22 auf dem Root
-Fähigkeit lesen+schreiben
-Einen Browser, Editor
Und wie mach ich das jetzt?:
1. Ihr öffnet den Spoiler, kopiert das ganze in eueren Editor
2. Ihr ergänzt euere IP/Port, dahin wo es hingehört
3. Ihr Speichert die Datei und ladet sie auf den Root
4. Ihr öffnet mit dem Browser den Pfard und drückt F5
5. Reloggen+Freuen
Das Passwort SHOWMETHEMONEY klappt nur wenn das Passwort in der game Datei nicht geändert wurde ! & wenn es geändert wurde muss es natürlich angepasst werden!
Kleine erklärung :
Config.php
PHP Code:
<?php
$dbhost = "localhost"; //ServerDB Host
$dbuser = "root"; //Datenbank Benutzer
$dbpass = ""; //Passwort
$mysql_db = "account";
?>
PHP Code:
mysql_select_db("player");
Wieviele sind Online
PHP Code:
<?php
mysql_connect("localhost", "root", "123456");
mysql_select_db("player");
$exe = mysql_query("SELECT COUNT(*) as count FROM player WHERE name like '[%]%' AND DATE_SUB(NOW(), INTERVAL 30 MINUTE) < last_play;");
$teamler = mysql_fetch_object($exe)->count;
echo "Es sind momentan $teamler Teamler online.."
?>
PHP Code:
<?php
mysql_connect("localhost", "root", "123456");
mysql_select_db("player");
$result = mysql_query("SELECT * FROM player WHERE name LIKE '[%]%' AND DATE_SUB(NOW(), INTERVAL 30 MINUTE) < last_play;");
while ($row = mysql_fetch_object($result)) {
echo "$row->name <br>";
}
mysql_free_result($result);
?>
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '0' AND skill_group = '1'");
$manaura = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$manaura</u></b> Männliche Körperkrieger";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '0' AND skill_group = '2'");
$mansk = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$mansk</u></b> Männliche Mentalkrieger";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '4' AND skill_group = '1'");
$frauaura = mysql_num_rows($result);
echo "zurzeit gibt es <b><u>$frauaura</u></b> Weibliche Körperkrieger";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '4' AND skill_group = '2'");
$frausk = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$frausk</u></b> Weibliche Mentalkrieger";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '5' AND skill_group = '1'");
$mannah = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$mannah</u></b> Männlich Nahninjas";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '5' AND skill_group = '2'");
$manfern = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$manfern</u></b> Männliche Fernninjas";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '1' AND skill_group = '1'");
$fraunah = mysql_num_rows($result);
echo "zurzeit gibt es <b><u>$fraunah</u></b> Weibliche Nahninjas";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '1' AND skill_group = '2'");
$fraufern = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$fraufern</u></b> Weibliche Fernninjas";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '2' AND skill_group = '1'");
$manwaffen = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$manwaffen</u></b> Männliche Waffensuras";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '2' AND skill_group = '2'");
$manmagie = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$manmagie</u></b> Männliche magiesuras";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '6' AND skill_group = '1'");
$frauwaffen = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$frauwaffen</u></b> Weibliche Waffensuras";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '6' AND skill_group = '2'");
$fraumagie = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$fraumagie</u></b> Weibliche Magiesuras";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '7' AND skill_group = '1'");
$mankrit = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$mankrit</u></b> männliche Drachenschamanen";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '7' AND skill_group = '2'");
$manheil = mysql_num_rows($result);
echo "zurzeit gibt es <b><u>$manheil</u></b> Männliche Heilschamanen";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '3' AND skill_group = '1'");
$fraukrit = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$fraukrit</u></b> Weibliche Drachenschamanen";
PHP Code:
$result = mysql_query("SELECT * FROM player WHERE job = '3' AND skill_group = '2'");
$frauheil = mysql_num_rows($result);
echo "Zurzeit gibt es <b><u>$frauheil</u></b> Weibliche Heilschamanen";
PHP Code:
$rots = "Select * from player_index WHERE empire NOT LIKE '2%' and empire NOT LIKE '3%';";
$rotquery = mysql_query($rots);
$rotanzahl = mysql_num_rows($rotquery);
echo "<b><u>$rotanzahl</u></b> Charaktere";
PHP Code:
$gelbs = "Select * from player_index WHERE empire NOT LIKE '1%' and empire NOT LIKE '3%';";
$gelbquery = mysql_query($gelbs);
$gelbanzahl = mysql_num_rows($gelbquery);
echo "<b><u>$gelbanzahl</u></b> Charaktere";
PHP Code:
$blaus = "Select * from player_index WHERE empire NOT LIKE '1%' and empire NOT LIKE '2%';";
$blauquery = mysql_query($blaus);
$blauanzahl = mysql_num_rows($blauquery);
echo "<b><u>$blauanzahl</u></b> Charaktere";
PHP Code:
<?php $mysqlabfr = "SELECT SUM(gold) FROM player";
$mysqlerg = mysql_query($mysqlabfr) or die (mysql_error());
while ($row = mysql_fetch_array($mysqlerg))
{
$aktuell= $row[0];
$gesamt = $gesamt+$aktuell;
}
$gesamt = number_format($gesamt,0,',','.');
echo "<b><u>$gesamt</u></b>";
?>