Metin2 Panelleri PHP Kodları # Herkes PHP Kodunu Açıksız Kullanabilsi # Fenomen

<?php 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 "Karakter Sayısı: $charanzahl";  ?>

 <?php 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 "Hesap Sayısı: $accszahl"; ?>

<?php 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 "İtem Sayısı: $itemanzahl";   ?>

 <?php 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 "Lonca Sayısı:$guildanzahl";   ?>

<?php 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 "Online Sayısı: $online_count";   ?>

 <?php
 echo "<center>";
include('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">Sira</th>
        <th width="150">Nick</th>
        <th width="150">Level</th>
        <th width="150">Exp</th>
        <th width="150">Bayrak</th>
    </tr>
</table></center>
 
 <?php
 include("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 20";
 $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.turkmmo.com/images/kirmizi.jpg"></th></tr>";
                } elseif($array2["empire"] == 2) {
                echo "<th width=\"150\"><img src=\"http://www.turkmmo.com/images/sari.jpg"></th></tr>";
                } else {
                echo "<th width=\"150\"><img src=\"http://www.turkmmo.com/images/mavi.jpg"></th></tr>";
                }
                }
    echo "</table></center><br>"; // close table
 }
 ?>

             <div id="Felder">
            <form action="kayit.php" method="post" >
            Kullanici Adi<br />
            <input type="text" name="username" size="30"  /><br />
            Sifre<br />
            <input type="password" name="passwd" size="30" /><br />
            Sifre Tekrar<br />
            <input type="password" name="passwd2" size="30" /><br />
            Gercek Adiniz<br />
            <input type="text" name="rl_name" size="30"  /><br />
            Email<br />
            <input type="text" name="email" size="30" /><br />
            L&ouml;schcode<br />
            <input type="text" maxlength="7" name="social_id" size="30" /><br />
            <br />
            <input type="submit" name="submit" value="Kayit Ol" />
            </form>
            </div>
 
 <?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>Hesap  Basariyla Olusturuldu!</b></font>"; } else { echo "<font  color=\"red\"><b>Kayit Basarisiz!!lutfen tekrar  deneyin!</b></font>"; }
                }
                    } ?>

<?php $serverip = "eure_server_ip";
 $ip = gethostbyname($serverip);
 $portlist=array(3306, 11003, 13000, ); // serverinizin portlarini girin
 $status=array("Login Server","Char Server","World Server");  // port adlarini girin
 $i=0;
 
    foreach  ($portlist as $port){
    echo "".$status[$i]."";
 $online = @fsockopen($ip, $port, $errno, $errstr, 1);
    if (!$online)
    {
        echo "<td><img src=images/off.png width=16 height=12 /></td>"; #
 
 }
    else
    {
        echo "<td><img src=images/on.png width=16 height=12 /></td>";
    }
        @fclose($online);
 $i++;
    }  ?>