PaneL PHP KodLari | İndirmeye Gerek YoK | Siteni YaP

DoqanUmuT · 16 Eki 2011

Başliktaki gibi eğer panelinizi kendiniz tasarlamak istiyorsaniz lütfen bu konuya göz atiniz.

uzatmadan geçeyim konuya işte sizlere PHP kodlari
not : HTML de çalişmz eğer ona eklerseniz açik çikar!!

Karakter Sayisi

_____________________________________
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";

Kullanici ( ID - HESAP) Sayisi

__________________________________
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";

İtem Sayisi :

_____________________________________
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";

Lonca Sayisi

________________________________________
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";

Online Karakterler/oyuncular :

_________________________________________________
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";

Siralama (gm ler yoktur)

<?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">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('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.de/forum/images/red.jpg\"></th></tr>";
} elseif($array2["empire"] == 2) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.de/forum/images/yellow.jpg\"></th></tr>";
} else {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.de/forum/images/blue.jpg\"></th></tr>";
}
}
echo "</table></center><br>"; // close table

}
?>

Kayit Ol

___________________________________________
<body>
<div id="Felder">
<form action="regi.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öschcode<br />
<input type="text" maxlength="7" name="social_id" size="30" /><br />
<br />
<input type="submit" name="submit" value="Kayit ol" />
</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>Hesap Basariyla Olusturuldu!</b></font>"; } else { echo "<font color=\"red\"><b>Kayit Basarisiz!!lutfen tekrar deneyin!</b></font>"; }
}
}

?>
_______________________________________________

Online Statüs
not: bunun çalişmasi için panelin bulundugu dosyaya
img adinda klasör olusturun.
ve içine 2 adet kirmizi ok ve yeşil ol ekleyin.

kirmizi okun adi : img/offline.gif
yeşil okun adi : img/online.gif

olsun. sonra çalişir.

Online Statüs

_____________________________________
$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=img/offline.gif width=16 height=12 /></td>"; #

}
else
{
echo "<td><img src=img/online.gif width=16 height=12 /></td>";
}
@fclose($online);
$i++;
}
_________________________________________________

Panelden oyuna reboot atma : ( admincp ye ekleyip şifre koyunuz)

_________________________________________________
<?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);
}
?>
___________________________________________________

evet arkadaşlar şimdi bunlari hazirladik bize lazim olan bunlari çaliştirmak için
config.php olusturmak olucak
buyrun onlarida hazirliyalim

Config.php
_______________________________________________
<?php
$dbhost = "serverip"; //Serverinizin ipi
$dbuser = "root"; //root öle kalsin
$dbpass = "navicat şifre"; //navicat şifreniz
$mysql_db = "account";
?>

Not :
siralama için yukarda gördüğünüz yerin en altina birde bu kodu ekleyin.

mysql_select_db("player");

waRoSh · 16 Eki 2011

Sabitte Mevcut.

PaneL PHP KodLari | İndirmeye Gerek YoK | Siteni YaP

DoqanUmuT

waRoSh

Şu an konuyu görüntüleyenler (Toplam : 0, Üye: 0, Misafir: 0)

Benzer konular