Jump to content

Sıralama Scriptinden Yöneticileri Gizleme ?


Recommended Posts

Bu sıralama sayfam

[img]http://karanliksehir.com/sirius.png[/img]

][GM][ ve ][GA][ olanlar

şöyle bir kod buldum ama işe yaramıyor

$rank = "SELECT * from player WHERE name NOT LIKE '][GA][%' and name NOT LIKE '][GM][%' order by level desc limit 10";
$query = mysql_query($rank);

[spoiler]
[php]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php include "ayarlarim159.php"; ?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9" />
<title>Karakter Sıralaması | <?=$title?></title>
<meta name="Keywords" content="<?=$keywords?>" />
<meta name="Description" content="<?=$descs?>" />
<link rel="shortcut icon" href="favicon.ico" />
<link rel="icon" type="image/gif" href="favicon_ani.gif" />
<link rel="stylesheet" type="text/css" media="screen" href="css/style.css" />
<!--[if lte IE 7]><link rel="stylesheet" type="text/css" media="screen" href="css/ie7.css" /><![endif]-->
<!--[if IE 6]><link rel="stylesheet" type="text/css" media="screen" href="css/ie6.css" /><![endif]-->

<script type="text/javascript" src="scripts/util-functions.js"></script>
<script type="text/javascript" src="scripts/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="scripts/clear-default-text.js"></script>
<script type="text/javascript" src="scripts/easySlider1.7.js"></script>
<script type="text/javascript">
var RecaptchaOptions = {
theme : 'blackglass'
};
</script>
<script type="text/javascript">
$(document).ready(function(){
$("#slider").easySlider({
auto: true,
continuous: true,
numeric: true,
});
});
</script>


</head>

<body id="home">

<div id="b2">
<div id="b3">
<div id="b4">
<div id="wrapper"><div id="header"><div id="logo">
</div><div id="navbar">
<center> <a class="link2" href="index.php">Anasayfa</a>
<?php @session_start();
if($_SESSION["hesapadi"] == "") { echo '<a class="link2" href="kayit.php">Kayıt Ol</a>'; }
else { echo '<a class="link2" href="hesapyonetimi.php">Üye Paneli</a>'; } ?>
<a class="link2" href="indir.php">İndir</a>
<a class="link1" href="siralama.php">Sıralama</a>
<a class="link5" href="<?=$marketlink?>">Market</a>
<a class="link6" href="<?=$forumlink?>">Forum</a>
<a class="link2" href="takim.php">Oyun Takımı</a>
<a class="link6" href="<?=$desteklink?>">Destek</a> </center>
</div>

</div>

<div id="page">
<div id="pagetop" class="pui">
</div>

<div id="pagecon" class="pui">
<?php include "solmenu.php"; ?>
<div id="content">
<div class="cui ctitle"><h2>Karakter Sıralaması</h2></div>
<div class="cui ccon">
<div class="clearfix"></div>
<?php $servernedir = $_GET["sw"];
if ($servernedir == "") { $servernedir = $defaultserver; }
if ($serverlist[$servernedir] == "") { echo '<meta http-equiv=Refresh content="0; url=?" />';}
?>
<div id="gBar">
<a href="siralama.php?sw=<?=$servernedir?>"><font color="red">Karakter Sıralaması</font></a>
<a href="loncasiralama.php?sw=<?=$servernedir?>">Lonca Sıralaması</a>
<select class="dattiridit" name="rankserver" onchange="javascript:window.location.href=this.value;">
<?php foreach($serverlist AS $aKey => $aValue) {
if ($servernedir==$aKey) {
echo'<option value="?sw='.$aKey.'" selected="selected">'.$aValue.'</option>';
} else {
echo'<option value="?sw='.$aKey.'">'.$aValue.'</option>';
}
}
?>
</select>
<select class="dattiridit" name="oyuncu" onchange="javascript:window.location.href=this.value;">
<option value="siralama.php?sw=<?=$servernedir?>" selected="selected">Savaşçı</option>
<option value="siralama1.php?sw=<?=$servernedir?>" >Sura</option>
<option value="siralama2.php?sw=<?=$servernedir?>">Ninja</option>
<option value="siralama3.php?sw=<?=$servernedir?>">Şaman</option>
</select>
<div class="clear"></div>
</div>
<?

$filename = "siralama1-".$servernedir.".html";
$cachefile = "cacheler999/".$filename;
$cachetime = 60 * 60; // Cache Süresi
if (!(file_exists($cachefile)) || time() - $cachetime > filemtime($cachefile))
{
ob_start();
serverbaglan($servernedir);
include "baglandimbak28.php";
mysql_select_db("player");
?>
<div id="rankingTable">

<div class="rankingload" id="rankingload"><table width="604">
<tbody><tr class="rank_head">
<td width="34">Sıra</td>
<td width="100">İsim</td>
<td width="36">Level</td>
<td width="81">EXP</td>
<td width="111">Lonca</td>
<td width="111">Karakter</td>
<td width="85">Bayrak</td>
<?php
$query = mysql_query("SELECT player.id,player.name,player.job,player.level,player.exp,player_index.empire,guild.name AS guild_name
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK' AND player.job='0' or player.job='4'
ORDER BY player.level DESC, player.exp DESC
LIMIT 20");
$sira = 1;
while($saydirmoruk = mysql_fetch_object($query)) {
if ($saydirmoruk->guild_name == ""){ $loncasi = "<b>YOK<b>"; } else { $loncasi = $saydirmoruk->guild_name; }

echo '</tr><tr class="rank_player"><td>'.$sira++.'</td><td>'.$saydirmoruk->name.'</td><td>'.$saydirmoruk->level.'</td><td>'.$saydirmoruk->exp.'</td><td>'.$loncasi.'</td><td><img src="images/karakter/'.$saydirmoruk->job.'.jpg"></td><td><img src="images/lonca/'.$saydirmoruk->empire.'.jpg"></td></tr>
';


} ?> </tbody></table>
<div align="center">
</div>
</div>

</div>

<?
$fp = fopen($cachefile, 'w+');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush();
mysql_close($sqlServ);
}
else
{
readfile($cachefile);
}
?>
<div class="clearfix"></div>
</div>
<div class="cui cft"></div>



</div>

<?php include "sagmenu.php"; ?>
<div id="pagebottom" class="pui">
</div>
</div>
<div id="footer">
<center><p><?=$altyazi?></p></center>
<div class="clear"></div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>[/php]
[/spoiler]


Burası sağ menü
içinde sıralama var ve yöneticiler ordada gözüküyor

[spoiler]
[php]<div id="sb-right">

<div class="sbui sbtitle">
<h4>ÝSTATÝSTÝKLER</h4>
</div>
<div class="sbui sbcontent">

<div class="servstatser">

<style type="text/css">
<!--
.stil1 {
color: #FF0000;
font-weight: bold;
font-size: 16px;
}
-->
</style>
<span class="stil1"> <font color="FF0000"><?php
require_once("baglandimbaksiteye28.php");
mysql_select_db("player");
$exe = mysql_query("SELECT COUNT(*) as count FROM player WHERE name like '%' AND DATE_SUB(NOW(), INTERVAL 1 MINUTE) < last_play;");
$teamler = mysql_fetch_object($exe)->count;
echo "Online Oyuncu: $teamler"
?></font>
<br /></span>
<?php
require_once("baglandimbaksiteye28.php");
@mysql_select_db("common") OR die(mysql_error());$query = @mysql_query("SELECT * FROM gmlist") OR die(mysql_error());$gmsayisi = @mysql_num_rows($query);echo "<font color=white>GM Sayýsý : <b>$gmsayisi</b></font>";echo "<br>"; ?>
<?php
require_once("baglandimbaksiteye28.php");
@mysql_select_db("account") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM account") OR die(mysql_error());
$hesapsay = @mysql_num_rows($query);
echo "<font color=white>Hesap Sayisi: <b>$hesapsay</b></font>";
echo "<br>";

@mysql_select_db("player") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM player") OR die(mysql_error());
$karaktersay = @mysql_num_rows($query);
echo "<font color=white>Karakter Sayisi: <b>$karaktersay</b></font>";
echo "<br>";
@mysql_select_db("account") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM banlist") OR die(mysql_error());
$cezaevindekiler = @mysql_num_rows($query);
echo "<font color=white>Banli Hesap: <b>$cezaevindekiler</b></font>";
echo "<br>";
@mysql_select_db("player") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM item") OR die(mysql_error());
$esyasay = @mysql_num_rows($query);
echo "<font color=white>Ýtem Sayýsý: <b>$esyasay</b></font>";
echo "<br>";


?>

</div>
</div>
<div class="sbui sbend"></div>



<div class="sbui sbtitle">
<h4>BOSS Avcýlarý</h4>
</div>
<div class="sbui sbcontent">

<div class="servstat">
<a href="bossavcilari.php" style="padding-right:10px;"><img src="images/ui/boss.gif"/></a>
</div>
</div>
<div class="sbui sbend"></div>



<div class="sbui sbtitle">
<h4>SIRALAMA</h4>
</div>
<div class="sbui sbcontent">
<div id="rankslider">
<ul>

<li>
<h5>Karakter Sýralamasý</h5>
<?
[/spoiler]


[spoiler]
$filenamesag = "sagmenu-karakter.html";
$cachefilesag = "cacheler999/".$filenamesag;
$cachetimesag = 60 * 60; // Cache Süresi
if (!(file_exists($cachefilesag)) || time() - $cachetimesag > filemtime($cachefilesag))
{
ob_start();
serverbaglan($sagmenuserver);
include "baglandimbak28.php";
mysql_select_db("player");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">

<span class="stil2"> <tr class="head">
<td>Sýra  </td>
<td>Karakter Adý</td>
<td>Level</td>
</tr></span>


<?php
yanlama();
$sira = 1;
while($sagmenusaydir = mysql_fetch_object($sagmenusirala)) {
if ($sira%2==0) { echo "<tr class='rank_player'><td><font color='#ff9000'>".$sira++."</td><td><font color='#ff9000'>".$sagmenusaydir->name."</td><td><font color='#ff9000'>".$sagmenusaydir->level."</font></td></tr>"; }
else { echo "<tr class='rank_player'><td>".$sira++."</td><td>".$sagmenusaydir->name."</span></td><td>".$sagmenusaydir->level."</td></tr>"; }
} ?>
</table>
<?
$fp = fopen($cachefilesag, 'w+');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush();
mysql_close($sqlServ);
}
else
{
readfile($cachefilesag);
}
?>
</li>
<li>
<h5>Lonca Sýralamasý</h5>
<?
$filenamelonca = "sagmenu-lonca.html";
$cachefilelonca = "cacheler999/".$filenamelonca;
$cachetimelonca = 60 * 60; // Cache Süresi
if (!(file_exists($cachefilelonca)) || time() - $cachetimelonca > filemtime($cachefilelonca))
{
ob_start();
serverbaglan($sagmenuserver);
include "baglandimbak28.php";
mysql_select_db("player");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="head">
<td>Sýra  </td>
<td>Lonca Adý</td>

<td>Puan</td>
</tr>
<?php
$loncasaydir = mysql_query("SELECT * FROM guild ORDER BY ladder_point DESC, level DESC limit 5");
$sira = 1;
while($saydirloncayi = mysql_fetch_object($loncasaydir)) {
if ($sira%2==0) { echo "<tr><td>".$sira++."</td><td><font color='#ff9000'>".$saydirloncayi->name."</font></td><td><font color='#ff9000'>".$saydirloncayi->ladder_point."</font></td></tr>"; }
else { echo "<tr><td>".$sira++."</td><td>".$saydirloncayi->name."</td><td>".$saydirloncayi->ladder_point."</td></tr>"; }

} ?>
</table>
<?
$fp = fopen($cachefilelonca, 'w+');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush();
mysql_close($sqlServ);
}
else
{
readfile($cachefilelonca);
}
?>

</li>
</ul>
</div> <div class="clear"></div>
<a class="slink" href="siralama.php">Tüm Sýralama</a>
</div>
<div class="sbui sbend"></div>







</div>
<div class="clear"></div>


</div>[/php]
[/spoiler] Edited by selamdostum
SAYFA DÜZENİ!
Link to comment
Share on other sites

[quote name='Lastman' date='02 August 2012 - 23:02 ' timestamp='1343941320' post='1226917']
veritabanında karakterin oyuncu mu yönetici mi olduğunu belirten sütun yok mu?
[/quote]

var common/gmlist.sql da var mName kısmında mevcut

resim
[img]http://karanliksehir.com/sirius2.png[/img]

Edited by selamdostum
Link to comment
Share on other sites

Bu kodları örnek olsun diye yazdım sen listeleme yaparken isimleri yazdırdığın yerde aşağıdaki kodları kendine göre uyarla if içerisinde preg_match fonksiyonunu örnekte olduğu gibi kullan

[code]
$test = array(
'][GM][Deneme',
'][GM][Deneme2',
'Deneme',
'][GM][Deneme3',
'][GM][Test1',
'Test',
'][GM][Test2',
'][GA][Deneme4',
'][GA][Test4',
'][GA][Deneme5',
'][GA][Tes3'
);


foreach($test as $player) {
if(!preg_match('/\]\[GA\]\[/', $player) and !preg_match('/\]\[GM\]\[/', $player)) {
echo $player.'<br>';
}
}
[/code]

Edited by carysma1
Link to comment
Share on other sites

Bu kodları bul ve
[code]
echo '</tr><tr class="rank_player"><td>'.$sira++.'</td><td>'.$saydirmoruk->name.'</td><td>'
.$saydirmoruk->level.'</td><td>'.$saydirmoruk->exp.'</td><td>'.$loncasi.'</td><
td><img src="images/karakter/'.$saydirmoruk->job.'.jpg"></td><td><img src="images/lonca/'.$saydirmoruk->empire.'.jpg"></td></tr>
';
[/code]

Bunlarla değiştir
[code]
if(!preg_match('/\]\[GA\]\[/', $saydirmoruk->name) and !preg_match('/\]\[GM\]\[/', $saydirmoruk->name))
{

echo '</tr><tr class="rank_player"><td>'.$sira++.'</td><td>'.$saydirmoruk->name.'</td><td>'
.$saydirmoruk->level.'</td><td>'.$saydirmoruk->exp.'</td><td>'.$loncasi.'</td><
td><img src="images/karakter/'.$saydirmoruk->job.'.jpg"></td><td><img src="images/lonca/'.$saydirmoruk->empire.'.jpg"></td></tr>
';

}
[/code]
Dene bakalım sıkıntı olacakmı

Link to comment
Share on other sites

eyw kardeşim valla çok güzel oldu ellerine sağlık bu kodu sağ menüye uygulayamadım bir zahmet yardım edermisin kardeşim

Sağ Menü

[code]
[php]

<div id="sb-right">

<div class="sbui sbtitle">
<h4>ÝSTATÝSTÝKLER</h4>
</div>
<div class="sbui sbcontent">

<div class="servstatser">

<style type="text/css">
<!--
.stil1 {
color: #FF0000;
font-weight: bold;
font-size: 16px;
}
-->
</style>
<span class="stil1"> <font color="FF0000"><?php
require_once("baglandimbaksiteye28.php");
mysql_select_db("player");
$exe = mysql_query("SELECT COUNT(*) as count FROM player WHERE name like '%' AND DATE_SUB(NOW(), INTERVAL 1 MINUTE) < last_play;");
$teamler = mysql_fetch_object($exe)->count;
echo "Online Oyuncu: $teamler"
?></font>
<br /></span>
<?php
require_once("baglandimbaksiteye28.php");
@mysql_select_db("common") OR die(mysql_error());$query = @mysql_query("SELECT * FROM gmlist") OR die(mysql_error());$gmsayisi = @mysql_num_rows($query);echo "<font color=white>GM Sayýsý : <b>$gmsayisi</b></font>";echo "<br>"; ?>
<?php
require_once("baglandimbaksiteye28.php");
@mysql_select_db("account") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM account") OR die(mysql_error());
$hesapsay = @mysql_num_rows($query);
echo "<font color=white>Hesap Sayisi: <b>$hesapsay</b></font>";
echo "<br>";

@mysql_select_db("player") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM player") OR die(mysql_error());
$karaktersay = @mysql_num_rows($query);
echo "<font color=white>Karakter Sayisi: <b>$karaktersay</b></font>";
echo "<br>";
@mysql_select_db("account") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM banlist") OR die(mysql_error());
$cezaevindekiler = @mysql_num_rows($query);
echo "<font color=white>Banli Hesap: <b>$cezaevindekiler</b></font>";
echo "<br>";
@mysql_select_db("player") OR die(mysql_error());
$query = @mysql_query("SELECT * FROM item") OR die(mysql_error());
$esyasay = @mysql_num_rows($query);
echo "<font color=white>Ýtem Sayýsý: <b>$esyasay</b></font>";
echo "<br>";


?>

</div>
</div>
<div class="sbui sbend"></div>



<div class="sbui sbtitle">
<h4>BOSS Avcýlarý</h4>
</div>
<div class="sbui sbcontent">

<div class="servstat">
<a href="bossavcilari.php" style="padding-right:10px;"><img src="images/ui/boss.gif"/></a>
</div>
</div>
<div class="sbui sbend"></div>



<div class="sbui sbtitle">
<h4>SIRALAMA</h4>
</div>
<div class="sbui sbcontent">
<div id="rankslider">
<ul>

<li>
<h5>Karakter Sýralamasý</h5>
<?
$filenamesag = "sagmenu-karakter.html";
$cachefilesag = "cacheler999/".$filenamesag;
$cachetimesag = 60 * 60; // Cache Süresi
if (!(file_exists($cachefilesag)) || time() - $cachetimesag > filemtime($cachefilesag))
{
ob_start();
serverbaglan($sagmenuserver);
include "baglandimbak28.php";
mysql_select_db("player");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">

<span class="stil2"> <tr class="head">
<td>Sýra &nbsp;</td>
<td>Karakter Adý</td>
<td>Level</td>
</tr></span>


<?php
yanlama();
$sira = 1;
while($sagmenusaydir = mysql_fetch_object($sagmenusirala)) {
if ($sira%2==0) {
echo "<tr class='rank_player'><td><font color='#ff9000'>".$sira++."</td><td><font color='#ff9000'>".$sagmenusaydir->name."</td><td><font color='#ff9000'>".$sagmenusaydir->level."</font></td></tr>"; }

else { echo "<tr class='rank_player'><td>".$sira++."</td><td>".$sagmenusaydir->name."</span></td><td>".$sagmenusaydir->level."</td></tr>"; }
}

?>
</table>
<?
$fp = fopen($cachefilesag, 'w+');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush();
mysql_close($sqlServ);
}
else
{
readfile($cachefilesag);
}
?>
</li>
<li>
<h5>Lonca Sýralamasý</h5>
<?
$filenamelonca = "sagmenu-lonca.html";
$cachefilelonca = "cacheler999/".$filenamelonca;
$cachetimelonca = 60 * 60; // Cache Süresi
if (!(file_exists($cachefilelonca)) || time() - $cachetimelonca > filemtime($cachefilelonca))
{
ob_start();
serverbaglan($sagmenuserver);
include "baglandimbak28.php";
mysql_select_db("player");
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="head">
<td>Sýra &nbsp;</td>
<td>Lonca Adý</td>

<td>Puan</td>
</tr>
<?php
$loncasaydir = mysql_query("SELECT * FROM guild ORDER BY ladder_point DESC, level DESC limit 5");
$sira = 1;
while($saydirloncayi = mysql_fetch_object($loncasaydir)) {
if ($sira%2==0) { echo "<tr><td>".$sira++."</td><td><font color='#ff9000'>".$saydirloncayi->name."</font></td><td><font color='#ff9000'>".$saydirloncayi->ladder_point."</font></td></tr>"; }
else { echo "<tr><td>".$sira++."</td><td>".$saydirloncayi->name."</td><td>".$saydirloncayi->ladder_point."</td></tr>"; }

} ?>
</table>
<?
$fp = fopen($cachefilelonca, 'w+');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush();
mysql_close($sqlServ);
}
else
{
readfile($cachefilelonca);
}
?>

</li>
</ul>
</div> <div class="clear"></div>
<a class="slink" href="siralama.php">Tüm Sýralama</a>
</div>
<div class="sbui sbend"></div>







</div>
<div class="clear"></div>


</div>


[/php]
[/code]

Edited by selamdostum
Link to comment
Share on other sites

[code]

if(!preg_match('/\]\[GA\]\[/', $sagmenusaydir->name) and !preg_match('/\]\[GM\]\[/', $sagmenusaydir->name)) {



}
[/code]

kodu olacak dimi bunu ekliyorum belkide yanlış yere ekliyorum bilmiyorum ama kabul etmiyor hiç bir değişiklik yok


şu şekilde yaptım olmadı

[code]
<?php

yanlama(); $sira = 1;while($sagmenusaydir = mysql_fetch_object($sagmenusirala)) {
if ($sira%2==0)
{
if(!preg_match('/\]\[GA\]\[/', $sagmenusaydir->name)
and !preg_match('/\]\[GM\]\[/', $sagmenusaydir->name))
{
echo "<tr class='rank_player'><td>
<font color='#ff9000'>".$sira++."</td><td>
<font color='#ff9000'>".$sagmenusaydir->name."</td><td>
<font color='#ff9000'>".$sagmenusaydir->level."</font></td></tr>";
}
else { echo "<tr class='rank_player'><td>".$sira++."</td>
<td>".$sagmenusaydir->name."</span></td><td>".$sagmenusaydir->level."</td></tr>"; }
}
}
?>[/code]

Edited by selamdostum
Link to comment
Share on other sites

Bu şekilde denermisin
[code]$sira = 1;
while($sagmenusaydir = mysql_fetch_object($sagmenusirala)) {
if(!preg_match('/\]\[GA\]\[/', $sagmenusaydir->name)
and !preg_match('/\]\[GM\]\[/', $sagmenusaydir->name))
{
if ($sira%2==0)
{
echo "<tr class='rank_player'><td>
<font color='#ff9000'>".$sira++."</td><td>
<font color='#ff9000'>".$sagmenusaydir->name."</td><td>
<font color='#ff9000'>".$sagmenusaydir->level."</font></td></tr>";
}
else
{
echo "<tr class='rank_player'><td>".$sira++."</td>
<td>".$sagmenusaydir->name."</span></td><td>".$sagmenusaydir->level."</td></tr>";
}
}
} [/code]

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...