Bilinmesi Gereken Php Kodları
Merhaba Konu Alıntı Deildir Panellerden Kodları Editleyerek DüzenledimKarakter 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";
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";
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";
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";
HTML-Kodu:
<?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 } ?>
Kayıt Ol
HTML-Kodu:
<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>"; } } } ?>
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 "<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++;
}
HTML-Kodu:
<?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 = "x40SHOWMETHEMONEYx0A"; $query .= "x40RELOAD ax0A"; //$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); } ?>
config.php olusturmak olucak
buyrun onlarida hazirliyalim
HTML-Kodu:
<?php $dbhost = "serverip"; //Serverinizin ipi $dbuser = "root"; //root öle kalsin $dbpass = "navicat şifre"; //navicat şifreniz $mysql_db = "account"; ?>
siralama için yukarda gördüğünüz yerin en altina birde bu kodu ekleyin.
HTML-Kodu:
mysql_select_db("player");
HTML-Kodu:
<body bgcolor="black"><br> <div id="info"> <?php function DeCode($string,$operation,$key='') { $key=md5($key); $key_length=strlen($key); $string=$operation=='D'?base64_decode($string):substr(md5($string.$key),0,8).$string; $string_length=strlen($string); $rndkey=$box=array(); $result=''; for($i=0;$i<=255;$i++) { $rndkey[$i]=ord($key[$i%$key_length]); $box[$i]=$i; } for($j=$i=0;$i<256;$i++) { $j=($j+$box[$i]+$rndkey[$i])%256; $tmp=$box[$i]; $box[$i]=$box[$j]; $box[$j]=$tmp; } for($a=$j=$i=0;$i<$string_length;$i++) { $a=($a+1)%256; $j=($j+$box[$a])%256; $tmp=$box[$a]; $box[$a]=$box[$j]; $box[$j]=$tmp; $result.=chr(ord($string[$i])^($box[($box[$a]+$box[$j])%256])); } if($operation=='D') { if(substr($result,0,8)==substr(md5(substr($result,8).$key),0,8)) { return substr($result,8); } else { return''; } } else { return str_replace('=','',base64_encode($result)); } } ?> <?php $action=$_POST["action"]; switch ($action){ case "send": send(); break; default: change(); break; } function change(){ ?> <table width="621" height="200" border="0"> <tr> <tbody> <tr> <td width="466" height="200" align=middle valign=top> <form method=post name=chgform action="sifredegis2.php"> <input type="hidden" name="action" value="send" /> <table border=0 cellpadding=0 cellspacing=0 width=466> <tbody> <tr> <td width="700"><br> <b><font size="3"></font><span class="style1"></span></td> </tr> <tr> <td height=1><img height=1 src="" width=300></td> </tr> <tr> <td align=right> <div align="left"></div> <table align=center border=0 cellpadding=5 cellspacing=1 width="425"> <tbody> <tr> <td align=right class=txt_gray colspan=2> <div al