<td>En Fazla - (bos) Oy'a Sahip Yazarlar:</td>
<p>
<?php
echo "<table border='0'>";
$cachetime = 60 * 12 * 60;
include "cache.php";
cache_check('enfazlabos');
$sorgu = mysql_query("select entry_sahibi,count(id) as sayi from oylar where oy='0' group by entry_sahibi order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td><a href='sozluk.php?process=word&q={$oku['entry_sahibi']}' target=main>{$oku['entry_sahibi']}</a> : {$oku['sayi']} oy</td>\n </tr>\n ";
}
echo "</table>";
?>
<?
cache_save('enfazlabos');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('endaginik');
?>
En daðýnýk, en üþengeç, en pasaklý yazarlar:
<table border="0">
<?php
$sorgu = mysql_query("select kime,count(id) as sayi from privmsg group by kime order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td>{$oku['kime']} - {$oku['sayi']}</td>\n </tr>\n ";
}
?>
</table>
<?
cache_save('endaginik');
?>
<?
$cachetime = (5*60);
include "cache.php";
cache_check('onlinespanel');
?>
<META http-equiv=Content-Type content="text/html; charset=windows-1254"><LINK href="css/default/default.css" type=text/css rel=stylesheet>
<SCRIPT language=javascript src="sozluk.js"></SCRIPT>
</HEAD>
<BODY>
<?
if ($statu) {
if ($statu != "disarida" and $statu != "mesgul" and $statu != "yemekte" and $statu != "iceride") {
die;
}
else {
$snerde = $statu;
session_register("snerde");
}
}
$snerde = $_SESSION['snerde'];
$listele = mysql_query("SELECT okundu,id FROM privmsg WHERE `kime`='$verified_user'");
while ($kayit=mysql_fetch_array($listele)) {
$okundu=$kayit["okundu"];
$id=$kayit["id"];
if ($okundu != 0) {
$okunmayan++;
}
if ($okundu == 2) {
<td></td>
<p>
<?php
echo "<table border='0'>";
$cachetime = 60 * 12 * 60;
include "cache.php";
cache_check('encokokunan');
$sorgu = mysql_query("select baslik, (hit) as sayi from konucuklar group by baslik order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td><a href='{$oku['baslik']}.html' target=main>{$oku['baslik']}</a> - {$oku['sayi']} Okuma</td>\n </tr>\n ";
}
?>
<?
cache_save('encokokunan');
?>
</table>
<td>En Faz + (hos) Oyu Veren Yazarlar (Cömertler): </td>
<p>
<?php
echo "<table border='0'>";
$cachetime = 60 * 12 * 60;
include "cache.php";
cache_check('enfazlahosveren');
$sorgu = mysql_query("select nick,count(id) as sayi from oylar where oy='1' group by nick order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n<td><a href='sozluk.php?process=word&q={$oku['nick']}' target=main>{$oku['nick']}</a> : {$oku['sayi']} oy</td>\n </tr>\n ";
}
echo "</table>";
?>
<?
cache_save('enfazlahosveren');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('yazarayx');
?>
<table border="0" width="60%">
<?
$sorgu=mysql_query("select entry_sahibi,count(id) as sayi from oylar where oy='1' group by entry_sahibi order by sayý desc limit 0,10");
$toplam=mysql_num_rows(mysql_query("select entry_sahibi from oylar "));
?>
<tr>
<td nowrap>toplam</td><td nowrap width="100%"><div class=highlight style='text-align:right; width:100%'><?php
echo $toplam;
?>
</td>
</tr>
<?
$say=0;
while ($oku=mysql_fetch_array($sorgu)) {
$say++;
$oran=$toplam/$oku['sayi'];
$yoran=100/$oran;
$kes=substr($yoran,0,1);
echo "<tr>
<td nowrap>$say. <a href='sozluk.php?process=word&q=$oku[entry_sahibi]' target=main>$oku[entry_sahibi]</a></td><td nowrap width='100%'><div class=highlight style='text-align:right; width:$kes%'>$oku[sayi]</td>
<td>";
}
?>
</table>
<?
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('bugunyazan');
?>
<td>Günün çalýþkan yazarlarý:</td>
<p>
<table border="0" width="100%">
<?
$bugun=date("d");
$ay=date("m");
$yil=date("Y");
$sorgu=mysql_query("select yazar,count(id) as sayi from mesajciklar gun='$bugun' and ay='$ay' and yil='$yil' group by yazar order by sayi desc limit 10");
while ($oku=mysql_fetch_array($sorgu)) {
echo "
<tr>
<td>$oku[yazar] - $oku[sayi]</td>
</tr>
";
}
?>
<?
cache_save('bugunyazan');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('satatukuz');
?>
<?php
echo "<table border='0'>";
$sorgu = mysql_query("select baslik,count(id) as sayi from konular by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td>{$oku['baslik']} - {$oku['sayi']} statu</td>\n </tr>\n ";
}
echo "</table>";
?>
<?
cache_save('satatukuz');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('encokentrykasan');
?>
sözlükte 10 kaplan gücünde olan, klavyelerinin tuþlarý okunmayan yazarlar:<p>
<table border="0" width="60%">
<?
$sorgu=mysql_query("select yazar,count(id) as sayi from mesajciklar group by yazar order by sayi desc limit 0,15");
$toplam=mysql_num_rows(mysql_query("select id from mesajciklar"));
?>
<tr>
<td nowrap>toplam</td><td nowrap width="100%"><div class=highlight style='text-align:right; width:100%'><?php
echo $toplam;
?>
</td>
</tr>
<?
$say=0;
while ($oku=mysql_fetch_array($sorgu)) {
$say++;
$oran=$toplam/$oku['sayi'];
$yoran=70/$oran;
$kes=substr($yoran,0,1);
echo "<tr>
<td nowrap>$say. <a href='sozluk.php?process=word&q=$oku[yazar]' target=main>$oku[yazar]</a></td><td nowrap width='100%'><div class=highlight style='text-align:right; width:$kes%'>$oku[sayi]</td>
<td>";
}
?>
</table>
<?
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('enfazlaukde');
?>
<small>utanmadan!</small>en fazla ukde verenler:
<table border="0">
<?php
$sorgu = mysql_query("select yazar,count(id) as sayi from ukde group by yazar order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "<tr>\n <td>{$say}. <a href='sozluk.php?process=word&q={$oku['yazar']}' tarhet=main>{$oku['yazar']}</a> - {$oku['sayi']}</td>\n <td>";
}
?>
</table>
<?
cache_save('enfazlaukde');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('encokultema');
?>
En fazla asindirilan temalar:<p>
<?
$sorgu1 = "SELECT * FROM temalar";
$sorgu2 = mysql_query($sorgu1);
echo "<table align=center width=200 border=0 cellSpacing=0 cellPadding=0>";
while ($oku=mysql_fetch_array($sorgu2)) {
$tsrg=mysql_query("select * from user where tema='$oku[tema]'");
$kactsrg=@mysql_num_rows($tsrg);
?>
<tr>
<td><a href="sozluk.php?process=word&q=<?php
echo $oku[tema];
?>
" target="main"><?php
echo $oku[tema];
?>
</a></td>
<td><?php
echo $kactsrg;
?>
</td>
</tr>
<?
}
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('encokgun');
?>
<?
echo "<table border='0'>";
$sorgu=mysql_query("select gun,ay,yil,count(id) as say from mesajciklar group by gun,ay,yil order by say desc limit 0,10");
while ($oku=mysql_fetch_array($sorgu)) {
echo "<tr><td><b>Tarih:</b>$oku[gun].$oku[ay].$oku[yil]</td><td><b>Entry Sayisi:</b>$oku[say]</td>
</tr>";
}
echo "</table>";
?>
<?
cache_save('encokgun');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('toplantisehirx');
?>
<td width="100%"> yazarlar hangi þehirlerde toplaþmýþ, toplantý yapmasý muhtemel yazarlar</td><p>
<table border="0" width="100%">
<?
$sorgu=mysql_query("select sehir,count(id) as sayi from user group by sehir order by sayi desc limit 0,10");
$toplam=mysql_num_rows(mysql_query("select id from user"));
?>
<?
$say=0;
while ($oku=mysql_fetch_array($sorgu)) {
$say++;
$oran=$toplam/$oku['sayi'];
$yoran=100/$oran;
echo "<tr>
<td>$say. <a href='sozluk.php?process=word&q=$oku[sehir]' target=main>$oku[sehir]</a>($oku[sayi])</td>
<td>";
}
?>
</table>
<?
cache_save('toplantisehirx');
?>
<?
$cachetime = (1*5);
include "cache.php";
cache_check("hepsi".$_GET[sayfa]);
?>
<?
if ((isset($_GET["sayfa"])) && ($_GET["sayfa"] <= "0")) {
echo "vaaay akilli!!!";
die();
}
include "hayvanara.php";
if ($verified_user) {
$osorgu=mysql_query("select * from online where nick='$verified_user'");
$ono=@mysql_num_rows($osorgu);
$oip = getenv('REMOTE_ADDR');
if ($ono==0) {
$zaman=time();
mysql_query("insert into online values('$verified_user','$zaman','$oip','on')");
} else if ($ono>=2) {
mysql_query("delete from online where nick='$verified_user'");
}
}
?>
<STYLE TYPE="text/css">
BODY
{
scrollbar-base-color: orange;
scrollbar-arrow-color: green;
scrollbar-DarkShadow-Color: blue;
}
</STYLE>
<?
$cachetime = (30*60) * 1;
include "cache.php";
cache_check('bugungelenler');
?>
<td>Bugün bu bataga düþenler</td>
<p>
<table border="0" width="100%">
<?php
$today = date("Y/m/d");
$sorgu = mysql_query("select nick from user where regtarih='{$today}%' group by nick desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "<tr>\n <td><a href='sozluk.php?process=word&q={$oku['nick']}' tarhet=main>{$oku['nick']}</a></td>\n <td>";
}
?>
<?
cache_save('bugungelenler');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('encokbaslik');
$sorgu=mysql_query("select sira,count(id) as sayi from mesajciklar group by sira order by sayi desc limit 0,20");
echo "<table border=0>";
echo "<tr><td colspan=2>en çok entry girilen baþlýklar</td></tr>";
while ($oku=mysql_fetch_array($sorgu)) {
$baslik=@mysql_result(mysql_query("select baslik,id from konucuklar where id='$oku[sira]'"),0,'baslik');
if (!empty($baslik)) {
echo "
<tr>
<td><a href='sozluk.php?process=word&q=$baslik' target=main>$baslik</a></td>
<td>$oku[sayi]</td>
</tr>
";
}
}
echo "</table>";
?>
<?
cache_save('encokbaslik');
?>
<?
$cachetime = (10*60) * 1;
include "cache.php";
cache_check('saatista');
?>
<td width="100%">hangi saatlerde entry girilmiþ:</td><p>
<table border="0" width="100%">
<?
$sorgu=mysql_query("select saat,count(id) as sayi from mesajlar group by saat order by sayi desc limit 0,10");
$toplam=mysql_num_rows(mysql_query("select id from user"));
?>
<?
$say=0;
while ($oku=mysql_fetch_array($sorgu)) {
$say++;
$oran=$toplam/$oku['sayi'];
$yoran=100/$oran;
echo "<tr>
<td>$say. <a href='sozluk.php?process=word&q=$oku[saat]' target=main>$oku[saat]</a>($oku[sayi])</td>
<td>";
}
?>
</table>
<?
cache_save('saatista');
?>
<?
$cachetime = (1*5);
include "cache.php";
cache_check("wordtoday".$_GET[sayfa]);
?>
<?
$bugun = date("d");
$ay = date("m");
$yil=date("Y");
// idyi yakaliyoruz
// echo "baslik: $q";
$q = urldecode($q);
$q = trim($q);
$q = kucultuver($q);
if($conv == 1) {
$q = iconv("UTF-8","ISO-8859-9",($q));
}
$kac = count($q);
$q = substr($q, 0, 80);
$sor = mysql_query("select yazar,statu from mesajciklar WHERE `yazar`='$verified_user' and `statu` = 'silindi' and `gun` = '$bugun' and `ay` = '$ay' and yil='$yil' ");
$kac = mysql_num_rows($sor);
if ($kac > 0) {$pbin='pbinhi';} else
{$pbin='pbin';}
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('enpopbolum');
?>
En fazla okunan bölümler:<p>
<table border="0">
<?
$sorgu=mysql_query("select bolum,count(id) as sayi from user group by bolum order by sayi desc limit 0,10");
while ($oku=mysql_fetch_array($sorgu)) {
echo "
<tr>
<td>$oku[bolum] - $oku[sayi] kiþi</td>
</tr>
";
}
echo "</table>";
?>
<?
cache_save('enpopbolum');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('katilimsehir');
?>
<table border="0">
<?php
$sorgu = mysql_query("select sehir,count(id) as sayi from user group by nick order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td>{$oku['sehir']} - {$oku['sayi']}</td>\n </tr>\n ";
}
?>
</table>
<?
cache_save('katilimsehir');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('fikirdegistirenmod');
?>
Çabuk fikir deðiþtirenler ve beðenmeyenler (Modlar diðer entryleri düzenleyebilmektedir):
<table border="0">
<?php
$sorgu = mysql_query("select updater,count(id) as sayi from mesajciklar group by updater order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td>{$oku['updater']} - {$oku['sayi']}</td>\n </tr>\n ";
}
?>
</table>
<?
cache_save('fikirdegistirenmod');
?>
<?
$cachetime = (60*24) * 180;
include "cache.php";
cache_check('ilkkullanici');
?>
bu ibiþler sözlügün ilk kullanýcýlarýdýr,<br>
ibreti alem için sergilenmektedir;<br>
<?
$sorgu2 = "SELECT nick FROM user desc limit 10";
$sorgulama2 = @mysql_query($sorgu2);
if (@mysql_num_rows($sorgulama2)>0){
while ($kayit2=@mysql_fetch_array($sorgulama2)){
$nick=$kayit2["nick"];
echo "<table>
<tr>
<td><a class='link' href='sozluk.php?process=word&q=$nick'>$nick</a></td></tr></table>";
}
}
?>
<?
cache_save('ilkkullanici');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('encokmesajlasanlar');
?>
Sosyallesme top 10:<br>
<small>(yemeyip, içmeyip mesajlasanlar)</small>
<p>
<table border="0">
<?php
$sorgu = mysql_query("select gonderen,count(id) as sayi from privmsg group by gonderen order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "<tr>\n <td>{$say}. <a href='sozluk.php?process=word&q={$oku['gonderen']}' tarhet=main>{$oku['gonderen']}</a> - {$oku['sayi']}</td>\n <td>";
}
?>
</table>
<?
cache_save('encokmesajlasanlar');
?>
<td>En Fazla + (hos) Oy'a Sahip Yazarlar:</td>
<p>
<?php
echo "<table border='0'>";
$cachetime = 60 * 12 * 60;
include "cache.php";
cache_check('enfazlahos');
$sorgu = mysql_query("select entry_sahibi,count(id) as sayi from oylar where oy='1' group by entry_sahibi order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td><a href='sozluk.php?process=word&q={$oku['entry_sahibi']}' target=main>{$oku['entry_sahibi']}</a> : {$oku['sayi']} oy</td>\n </tr>\n ";
}
echo "</table>";
?>
<?
cache_save('enfazlhos');
?>
<?
$cachetime = (5*60) * 1;
include "cache.php";
cache_check('duyuru');
?>
Duyduk duymadýk demeyenler:
<br>
<table border="0">
<?php
$sorgu = mysql_query("select yazar,count(id) as sayi from haberler group by yazar order by sayi desc limit 10");
while ($oku = mysql_fetch_array($sorgu)) {
echo "\n <tr>\n <td>{$oku['yazar']} - {$oku['sayi']}</td>\n </tr>\n ";
}
?>
</table>
<?
cache_save('duyuru');
?>
<?
session_start();
include("rgt.config.php");
include("rgt.functions.php");
include("rgt.functions.cache.php");
set_exception_handler('error_exception');
set_error_handler('error_err');
setBusy();
switch ($_GET["cmd"]) {
case "cache_setup": cache_setup(); die();
case "cache_check": cache_check(); die();
}
// ----------------------------------------------------------------------------
$imgFile = $_GET["f"];
if ($_GET["src"]) { $imgFile = $_GET["src"]; }
$imgFile = stripslashes($imgFile);
// Some minor checking & stuff
$realImgFile = $imgFile; // Save actual imgFile (imgFile itself may be modified later on..)
if (strpos($imgFile,"ttp://")==1 || strpos($imgFile,"ttps://")==1) { $imgIsRemote=true; }
// ----------------------------------------------------------------------------
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('idarikadro');
?>
<table border="0" width="70%">
<div align="center">
<p><strong>Adminler</strong></p>
<p><font color="#FF0000"><?
$sorgu = "SELECT nick,durum,email,id,isim FROM user WHERE `yetki` = 'admin'";
$sorgulama = @mysql_query($sorgu);
if (@mysql_num_rows($sorgulama)>0){
while ($kayit=@mysql_fetch_assoc($sorgulama)){
echo "<tr>
<td nowrap><div><strong><em><a href='$kayit[nick].html' target=main>$kayit[nick]</a></em></strong></div></td>
<td>";
}
}
?></font></p>
</div>
<div align="center">
<p><strong>Moderatörler</strong></p>
<p><font color="#0000FF">
<?
$sorgu = "SELECT nick,durum,email,id,isim FROM user WHERE `yetki` = 'mod'";
$sorgulama = @mysql_query($sorgu);
if (@mysql_num_rows($sorgulama)>0){
<p><strong>En kötü 10 entry:</strong></p>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check('enkotuentryler');
$sorgu=mysql_query("select entry_id,count(entry_id) as sayi from oylar where oy='0' group by entry_id order by sayi desc limit 0,10");
$kac=0;
while($oku=mysql_fetch_array($sorgu)) {
$kac++;
$id=$oku['entry_id'];
$say=$oku['sayi'];
echo "<p><td>$kac. <a href='sozluk.php?process=eid&eid=$oku[entry_id]' target='main'>#$oku[entry_id]</a> ($say oy)</td></tr>";
}
?>
<?
cache_save('enkotuentryler');
?>
<?
$cachetime = (10*60) * 1;
include "cache.php";
cache_check('eforgun');
?>
<?
$toplam=mysql_query("select id from mesajciklar order by id desc limit 1");
$id=mysql_result($toplam,0,'id');
$sorgu=mysql_query("select gun,ay,yil,count(id) as sayi from mesajciklar group by gun,ay,yil order by sayi desc limit 0,100");
?>
<table border="0">
<tr>
<td colspan=2>en çok erfor sarfedilen günler</td>
</tr>
<?
$say=0;
while ($oku=mysql_fetch_array($sorgu)) {
$say++;
$oran=$id/$oku[sayi];
$oran=100/$oran;
$oran=$oran*25;
$oran=ceil($oran);
$format=number_format($oku[sayi]);
echo "<tr><td nowrap>$say. <a href='sozluk.php?process=word&q=$oku[gun]' target='main'>$oku[gun]</a>.<a href='sozluk.php?process=word&q=$oku[ay]' target='main'>$oku[ay]</a>.<a href='sozluk.php?process=word&q=$oku[yil]' target='main'>$oku[yil]</a></td><td nowrap width='100%'><div class=highlight style='text-align:right; width:$oran%'>$format</td></tr>";
}
?>
</table>
<?
cache_save('eforgun');
?>
<?
$cachetime = (60*12) * 60;
include "cache.php";
cache_check("gecenay".$_GET[sayfa]);
?>
<STYLE TYPE="text/css">
BODY
{
scrollbar-base-color: orange;
scrollbar-arrow-color: green;
scrollbar-DarkShadow-Color: blue;
}
</STYLE>
<?
$bugun = date("d");
$ay = date("m");
$ay = $ay - 1;
$ay = "0$ay";
if ($verified_user)
echo "<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"300;URL=sozluk.php?process=lastmonth\">";
$btarih = date ("d/$ay/Y");
$max = 40;
if (!$_GET["sayfa"]) { $_GET["sayfa"]=1; }
$alt = ($_GET["sayfa"] - 1) * $max;
$sor = mysql_query("select id from konucuklar WHERE statu='' and `gun` = '$bugun' and `ay` = '$ay' ORDER BY 'tarih'");
