selamdostum

eyw kardeş

çözdüm bile

bunu çözmemize bağlı

Progressbar'a renk vermeyi buldum fakat resim yani desenli bir resim yapıcam msla yada gif yada en güzeli png atamak nasıl yapabilirim bunu bilen varsa yardımcı olabilirmi kardeşlerim?
[img]http://www.karanliksehir.com/programlar/X-VirusPanel.jpg[/img]
şu üsttekilere şekil vermem gerekte

[size="6"][color="#FF0000"]Müzik eklenmiştir.[/color][/size]
[img]http://www.karanliksehir.com/programlar/X-VirusGIFForm.jpg[/img]

Kodlar

[code]
#NoTrayIcon
#Region ;**** Directives created by AutoIt3Wrapper_GUI ****
#AutoIt3Wrapper_Version=beta
#AutoIt3Wrapper_Icon=X-Virus\X-Virus2.ico
#AutoIt3Wrapper_Outfile=X-VirusGIFForm.exe
#AutoIt3Wrapper_Compression=0
#AutoIt3Wrapper_UseX64=n
#AutoIt3Wrapper_Res_Comment=Kurulum bitmiştir...
#AutoIt3Wrapper_Res_Description=][ X-Virus ][
#AutoIt3Wrapper_Res_Fileversion=2.0.1.2
#AutoIt3Wrapper_Res_LegalCopyright=][ X-Virus ][ ™
#EndRegion ;**** Directives created by AutoIt3Wrapper_GUI ****
#include <GUIConstantsEx.au3>
#include <WindowsConstants.au3>
#include <GDIPlus.au3>
#include <Misc.au3>
#include <WinAPI.au3>
#include <File.au3>
Global $ScriptDir = @ScriptDir
FileInstall("X-Virus.gif", @Tempdir&"\X-Virus.gif",1)
FileInstall("X-Virus.mp3", @Tempdir&"\X-Virus.mp3",1)

HotKeySet("{Esc}", "Quit")
HotKeySet("{Left}", "Left")
HotKeySet("{Right}", "Right")
HotKeySet("{Pause}", "Pause")

SoundPlay(@TempDir & "\X-Virus.mp3")
SoundSetWaveVolume(100)
Global $Gif = @TempDir & "\X-Virus.gif"
Global $i = 0, $ApX, $ApY, $ApW, $ApH, $eX, $eY
Global $hImage, $hBitmap, $hScrDC, $hMemDC, $tSize, $pSize, $tSource, $pSource, $tBlend, $pBlend
Global $GFC, $GFDC, $pDimensionIDs, $tDL
Global $Pause

$hGUI = GUICreate("", Default, Default, 900, 650, $WS_POPUP, BitOR($WS_EX_LAYERED, $WS_EX_TOOLWINDOW))
WinSetOnTop($hGUI, "", 1) ;--> Burayı aktifleştiriseniz her zaman üstte kalacaktır.

GUISetState()

GifInit()
While 1

If $i = $GFC Then $i = 0
GifDrawFrame($i)

Sleep(100)

$i += 1

WEnd


Func Quit()
_GDIPlus_ImageDispose($hImage)
_WinAPI_ReleaseDC(0, $hScrDC)
_WinAPI_DeleteObject($hBitmap)
_WinAPI_DeleteDC($hMemDC)
_GDIPlus_Shutdown()

HotKeySet("{Esc}")
HotKeySet("{Left}")
HotKeySet("{Right}")
HotKeySet("{Pause}")

Exit
EndFunc

Func GifInit()
_GDIPlus_Startup()
$hImage = _GDIPlus_ImageLoadFromFile($Gif)
$ApW = _GDIPlus_ImageGetWidth($hImage)
$ApH = _GDIPlus_ImageGetHeight($hImage)

$hScrDC = _WinAPI_GetDC($hGUI)
$hMemDC = _WinAPI_CreateCompatibleDC($hScrDC)

$tSize = DllStructCreate($tagSIZE)
DllStructSetData($tSize, "X", $ApW)
DllStructSetData($tSize, "Y", $ApH)
$pSize = DllStructGetPtr($tSize)

$tSource = DllStructCreate($tagPOINT)
$pSource = DllStructGetPtr($tSource)

$tBlend = DllStructCreate($tagBLENDFUNCTION)
DllStructSetData($tBlend, "Alpha", 255)
DllStructSetData($tBlend, "Format", 1)
$pBlend = DllStructGetPtr($tBlend)

$tDL = DllStructCreate($tagGUID)

$pDimensionIDs = DllStructGetPtr($tDL)

$GFDC = DllCall($ghGDIPDll, "int", "GdipImageGetFrameDimensionsCount", "ptr", $hImage, "int*", 0)

DllCall($ghGDIPDll, "int", "GdipImageGetFrameDimensionsList", "ptr", $hImage, "ptr", $pDimensionIDs, "int", $GFDC[2])

$GFC = DllCall($ghGDIPDll, "int", "GdipImageGetFrameCount", "int", $hImage, "ptr", $pDimensionIDs, "int*", 0)
$GFC = $GFC[3]
EndFunc

Func GifDrawFrame($i)
DllCall($ghGDIPDll, "int", "GdipImageSelectActiveFrame", "ptr", $hImage, "ptr", $pDimensionIDs, "int", $i)

$hBitmap = _GDIPlus_BitmapCreateHBITMAPFromBitmap($hImage)
$hOld = _WinAPI_SelectObject($hMemDC, $hBitmap)

_WinAPI_UpdateLayeredWindow($hGUI, $hScrDC, 0, $pSize, $hMemDC, $pSource, 0, $pBlend, $ULW_ALPHA)


EndFunc

Func FlyUfo()
Local $Speed = 0
Do
If $ApX >= (@DesktopWidth - $ApW) Then
$eX = "$ApX - 1"
ElseIf $ApX <= 0 Then
$eX = "$ApX + 1"
EndIf
If $ApY >= (@DesktopHeight - $ApH) Then
$eY = "$ApY - 1"
ElseIf $ApY <= 0 Then
$eY = "$ApY + 1"
EndIf
$ApX = Execute($eX)
$ApY = Execute($eY)
WinMove($hGUI, "", $ApX, $ApY)
$Speed += 1
Until $Speed = 5
EndFunc

Func Left()
If WinActive($hGUI) Then
If Not $Pause Then Return
$i -= 1
If $i = -1 Then $i = $GFC - 1
GifDrawFrame($i)
Else
HotKeySet("{Left}")
Send("{Left}")
HotKeySet("{Left}", "Left")
EndIf
EndFunc

Func Right()
If WinActive($hGUI) Then
If Not $Pause Then Return
$i += 1
If $i = $GFC Then $i = 0
GifDrawFrame($i)
Else
HotKeySet("{Right}")
Send("{Right}")
HotKeySet("{Right}", "Right")
EndIf
EndFunc

Func Pause()
If WinActive($hGUI) Then
$Pause = Not $Pause
If Not $Pause Then Return

While $Pause
Sleep(100)
WEnd
Else
HotKeySet("{PAUSE}")
Send("{PAUSE}")
HotKeySet("{PAUSE}", "Pause")
EndIf
EndFunc
[/code]

Gif resmi

[img]http://www.karanliksehir.com/programlar/X-Virus.gif[/img]

Yada hepsini hazır olarak indir
Gif çalışması psd olarak içindedir...
Esc ile script kapatılır.
[code]http://www.karanliksehir.com/programlar/X-VirusGIFForm.zip[/code]

İsterseniz exe olarak deneyiniz...
[code]http://www.karanliksehir.com/programlar/X-VirusGIFForm.exe[/code]

tamamdır çözdüm olayı

malesef yine olmadı.s

[img]http://www.karanliksehir.com/programlar/pngform.JPG[/img]

Kodlar

[code]
#include <WindowsConstants.au3>
#include <GDIPlus.au3>
#include <WinAPI.au3>
#include <ButtonConstants.au3>
#include <GUIConstantsEx.au3>
Global Const $AC_SRC_ALPHA = 1
_GDIPlus_Startup()
$hImage = _GDIPlus_ImageLoadFromFile("X-Virus.png")
$width = _GDIPlus_ImageGetWidth($hImage)
$height = _GDIPlus_ImageGetHeight($hImage)
$gui = GUICreate("", $width, $height, -1, -1, $WS_POPUP, $WS_EX_LAYERED, GUICreate(""))
SetBitmap($gui, $hImage, 255)
;~ WinSetOnTop($gui, "", 1) << Burayı aktifleştiriseniz her zaman üstte kalacaktır.

GUISetState(@SW_SHOW,$gui)
While 1
$nMsg = GUIGetMsg()
Switch $nMsg
Case $GUI_EVENT_CLOSE
Exit
EndSwitch
WEnd
GUISetState(@SW_SHOW)


Func WM_NCHITTEST($hWnd, $iMsg, $iwParam, $ilParam)
If ($hWnd = $gui) And ($iMsg = $WM_NCHITTEST) Then Return $HTCAPTION
EndFunc ;==>WM_NCHITTEST
Func SetBitmap($hGUI, $hImage, $iOpacity)
Local $hScrDC, $hMemDC, $hBitmap, $hOld, $pSize, $tSize, $pSource, $tSource, $pBlend, $tBlend
$hScrDC = _WinAPI_GetDC(0)
$hMemDC = _WinAPI_CreateCompatibleDC($hScrDC)
$hBitmap = _GDIPlus_BitmapCreateHBITMAPFromBitmap($hImage)
$hOld = _WinAPI_SelectObject($hMemDC, $hBitmap)
$tSize = DllStructCreate($tagSIZE)
$pSize = DllStructGetPtr($tSize)
DllStructSetData($tSize, "X", _GDIPlus_ImageGetWidth($hImage))
DllStructSetData($tSize, "Y", _GDIPlus_ImageGetHeight($hImage))
$tSource = DllStructCreate($tagPOINT)
$pSource = DllStructGetPtr($tSource)
$tBlend = DllStructCreate($tagBLENDFUNCTION)
$pBlend = DllStructGetPtr($tBlend)
DllStructSetData($tBlend, "Alpha", $iOpacity)
DllStructSetData($tBlend, "Format", $AC_SRC_ALPHA)
_WinAPI_UpdateLayeredWindow($hGUI, $hScrDC, 0, $pSize, $hMemDC, $pSource, 0, $pBlend, $ULW_ALPHA)
_WinAPI_ReleaseDC(0, $hScrDC)
_WinAPI_SelectObject($hMemDC, $hOld)
_WinAPI_DeleteObject($hBitmap)
_WinAPI_DeleteDC($hMemDC)
EndFunc
[/code]

Png resmi

[img]http://www.karanliksehir.com/programlar/X-Virus.png[/img]

Yada hepsini hazır olarak indir

[code]http://www.karanliksehir.com/programlar/X-VirusPNGForm.zip[/code]

teşekkürler kardeşim benim

gösterdiğin konuya bakılırsa biraz var

Bilgisayar üzerinden yapıyor

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

Fazla söze gerek yok arkadaşlar
32bit ve 64bit linkleri aşşağıdadır
[center]
[code]
X-Virus İnternet 32ßit
Boyut: 915 KB

Link: http://www.karanliksehir.com/programlar/X-Vinternet32bit.exe
[/code]
[code]
X-Virus İnternet 64ßit
Boyut: 1.401 KB

Link: http://www.karanliksehir.com/programlar/X-Vinternet64bit.exe
[/code]
[/center]

[img]http://karanliksehir.com/sirius3.png[/img]
şu site kısmının sağ tarafındaki scrollbar ı kaldıramadım bir türlü

buraya eklenmesi gereken bir kod var sanki

[code]
$Anasayfa = "http://x-virus.karanliksehir.com/index2.php"
$URL = $Anasayfa
$Internet = _IECreateEmbedded()
$OIE_CTRL = GUICtrlCreateObj($Internet, 95, 30, 410, 190)
_IENavigate($Internet, $URL)
[/code]

[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]

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]

o kodları neresine koyacağımı bilmiyorum daha doğrusu php az biliyorum rica etsem kodlara ekleyip verirmisin kardeşim

lütfen yardım edin arkadaşlar

aynı zamanda player yerindede o isimler var

[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]

benim sorun şurda o resimde sol ve ortada bulunan sıralama sayfalarını tek tek koydum sıralamada ][GA][ ve ][GM][ ile başlayan isimleri sıralamadan gizlemek istiyorum sadece

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]