Bilinmesi Gereken Php Kodları

Merhaba Konu Alıntı Deildir Panellerden Kodları Editleyerek Düzenledim

Karakter Sayısı


HTML-Kodu:

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

Kullanıcı Id Ve Hesap Sayısı


HTML-Kodu:

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 Sayısı


HTML-Kodu:

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 Sayısı


HTML-Kodu:

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 Karakter Ve Oyuncular


HTML-Kodu:

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

Sıralama (NOT:GMLER YAZILMAZ)


HTML-Kodu:

echo "";
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 "
";
?>

"0">

"150">Sira	"150">Nick	"150">Level	"150">Exp	"150">Bayrak

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 ""; // Open table
$i = 0;

while($array = mysql_fetch_array($query)) {
$i = $i + 1;


echo "




";



$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 "";
} elseif($array2["empire"] == 2) {
echo "";
} else {
echo "";
}
}
echo "

" . $i . "	" . $array["name"] . "	" . $array["level"] . "	" . $array["exp"] . "

"; // close table


}
?>


Kayıt Ol


HTML-Kodu:









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 "Hesap Basariyla Olusturuldu!"; } else { echo "Kayit Basarisiz!!lutfen tekrar deneyin!"; }
}
}

?>

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.



HTML-Kodu:

$serverip = "eure_server_ip";
$ip = gethostbyname($serverip);
$portlist=array(330611003 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 "