önemli PHP kodları (mt2'de bilinmesi gereken pHp kodları)

CoatesKING · 16 Haz 2011

Merhaba arkadaşlar

Başlıktanda anlaşilacagi gibi eger sitenizi kendiniz tasarlamak istiyosanız , ama pHp kod bilmiyosanız
bu konuya göz atmanız önemle rica olunur.

not : HTML de çalişmz eğer ona eklerseniz açik çikar!!

Şimdi başliyoruz ...

Karakter Sayısı ;

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 "Charaktere : $charanzahl";

Kullanıcı hesap sayısı ;

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 "Account : $accszahl";

İtem Sayisi :

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 "Items : $itemanzahl";

Lonca Sayisi :

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 "Gilden : $guildanzahl";

Online Karakterler/oyuncular Sayısı :

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 "Spieler Online : $online_count";

Siralama (gm ler yoktur) :

PHP:

<?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***91;'max'***93;) { 
$get = $_GET***91;'max'***93;; 
} 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 '***91;GA***93;%' and name NOT LIKE '***91;GM***93;%' 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***91;"name"***93; . "</font></th> 
<th width=\"150\"><font color=\"black\">" . $array***91;"level"***93; . "</font></th> 
<th width=\"150\"><font color=\"black\">" . $array***91;"exp"***93; . "</font></th>"; 



$reich = "SELECT empire from player_index where id = " . $array***91;account_id***93; . ""; 
$query2 = mysql_query($reich); 
$array2 = mysql_fetch_array($query2); 


if($array2***91;"empire"***93; == 1) { 
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.de/forum/images/red.jpg\"></th></tr>"; 
} elseif($array2***91;"empire"***93; == 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 


} 
?>

Kayıt ol pHp kodu :

PHP:

<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&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> 

</body> 
</html> 

<?php 


include('config.php'); 

if(isset($_POST***91;'submit'***93;) && $_POST***91;'submit'***93; == 'Register') { 
$username = mysql_real_escape_string($_POST***91;'username'***93;); 
$passwd = mysql_real_escape_string($_POST***91;'passwd'***93;); 
$passwd2 = mysql_real_escape_string($_POST***91;'passwd2'***93;); 
$rl_name = mysql_real_escape_string($_POST***91;'rl_name'***93;); 
$email = mysql_real_escape_string($_POST***91;'email'***93;); 
$social_id = mysql_real_escape_string($_POST***91;'social_id'***93;); 

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 :

PHP:

img/offline.gif

yeşil okun adi :

PHP:

img/online.gif

olsun. sonra çalişir.

Online Statüs :

PHP:

$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***91;$i***93;.""; 
$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:

<?php 
$IP = "EUERE IP HIER EINTRAGEN"; 
//Port = $_GET***91;'port'***93;; 
//$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***91;'query'***93;; 

$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:

<?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.

PHP:

mysql_select_db("player");

hadi ba'alım :m08: herkese kolay gelsin...

so.gen.tr'den alintidir.

waRoSh · 17 Haz 2011

http://www.turkmmo.com/metin2-pvp-panel-web/638576-bilinmesi-gereken-php-kodlari.html

Verildi.
üstelik sabitte

Kilit//

önemli PHP kodları (mt2'de bilinmesi gereken pHp kodları)

CoatesKING

Level 5

waRoSh

Level 8

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

Benzer konular