?>
><a href="profil.php?kim=<?php
echo $row_eoUsers['davetEdenID'];
?>
" rel="facebox"><?php
echo araKalin($row_eoUsers['userName']);
?>
</a></td>
<td <?php
echo "style=\"background-color: {$row_color};\"";
?>
><a href="profil.php?kim=<?php
echo $row_eoUsers['davetEdilenID'];
?>
" rel="facebox"><?php
echo kullAdi($row_eoUsers['davetEdilenID']);
?>
</a></td>
<td nowrap="nowrap" align="right" <?php
echo "style=\"background-color: {$row_color};\"";
?>
><?php
echo tarihOku($row_eoUsers['davetTarihi']);
?>
</td>
<td nowrap="nowrap" align="right" <?php
echo "style=\"background-color: {$row_color};\"";
?>
><?php
echo tarihOku($row_eoUsers['kabulTarihi']);
?>
function sonSatirGetir($tablo)
{
global $yol1, $metin, $_uploadFolder;
$sonuc = "";
$humanRelativeDate = new HumanRelativeDate();
switch ($tablo) {
case "oy":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_rating\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id = eo_rating.userID\t\t\t\t\t \r\n\t\t\t\t\t INNER JOIN eo_4konu \r\n\t\t\t\t\t ON eo_4konu.id = eo_rating.konuID\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_rating.rateDate DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[4]);
$sonuc = "<a href='profil.php?kim={$gelen['5']}' rel='facebox'>" . $gelen[6] . "</a>, " . "<a href='dersBilgisi.php?ders={$gelen['14']}' rel='facebox'>" . $gelen[15] . "</a>, " . yildizYap($gelen[3]) . ", " . $insansi;
}
break;
case "yorum":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_comments\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id = eo_comments.userID\t\t\t\t\t \r\n\t\t\t\t\t INNER JOIN eo_4konu \r\n\t\t\t\t\t ON eo_4konu.id = eo_comments.konuID\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_comments.commentDate DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[4]);
$sonuc = "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[7] . "</a>, " . "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . $insansi;
}
break;
case "sohbet":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_shoutbox\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.userName = eo_shoutbox.name\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_shoutbox.date DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[5]);
$sonuc = "<a href='profil.php?kim={$gelen['6']}' rel='facebox'>" . $gelen[1] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . odaGetir($gelen[4]) . ", " . $insansi;
}
break;
case "soru":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_askquestion\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id = eo_askquestion.userID\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_askquestion.eklenmeTarihi DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[3]);
$sonuc = "<a href='profil.php?kim={$gelen['6']}' rel='facebox'>" . $gelen[7] . "</a>, " . smileAdd(smartShort($gelen[2], 20)) . ", " . $insansi;
}
break;
case "uye":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_users\r\n\t\t\t\t\t ORDER BY requestDate DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[7]);
$sonuc = "<a href='profil.php?kim={$gelen['0']}' rel='facebox'>" . $gelen[1] . "</a>, <span style='text-transform: capitalize;'>" . strtolower($gelen[3]) . "</span>, " . $insansi;
}
break;
case "ders":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_userworks\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id = eo_userworks.userID\t\t\t\t\t \r\n\t\t\t\t\t INNER JOIN eo_4konu \r\n\t\t\t\t\t ON eo_4konu.id = eo_userworks.konuID\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_userworks.calismaTarihi DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[5]);
$sonuc = "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[7] . "</a>, " . "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . Sec2Time2($gelen[3]) . ", " . $gelen[4] . ", " . $insansi;
}
break;
case "arkadas":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_friends\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id = eo_friends.davetEdenID\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_friends.id DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
$insansi = $humanRelativeDate->getTextForSQLDate($gelen[3]);
$sonuc = "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[8] . "</a>, " . "<a href='profil.php?kim={$gelen['2']}' rel='facebox'>" . kullAdi($gelen[2]) . "</a>, " . $gelen[5] . ", " . $insansi;
}
break;
case "dosya":
$sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_files\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id = eo_files.userID\t\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_files.id DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && @mysql_num_rows($result1) == 1) {
$gelen = @mysql_fetch_array($result1);
if (file_exists($_uploadFolder . "/" . $gelen[2])) {
$insansi = $humanRelativeDate->getTextForSQLDate(date("Y-m-d H:i:s", filemtime($_uploadFolder . "/" . $gelen[2])));
$sonuc = "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[5] . "</a>, " . "<a href='fileDownload.php?id={$gelen['0']}&file={$gelen['2']}'>" . $gelen[2] . "</a>, " . $gelen[3] . ", " . $insansi;
}
}
break;
}
return $sonuc;
}
function girisSayisiRank($id, $grafikli, $sadeYuzde = false)
{
global $yol1;
$id = substr(temizle2($id), 0, 15);
$sql1 = "SELECT userName ,count(eo_usertrack.id) as say \r\n\t\tFROM eo_usertrack\r\n\t\twhere processName='login.php' and otherInfo='success,Login' \r\n\t\tgroup by userName\r\n\t\torder by say DESC, userName";
$result1 = mysql_query($sql1, $yol1);
if ($result1) {
$rank = 0;
for ($i = 0; $i < @mysql_numrows($result1); $i++) {
$rank = $i + 1;
if (mysql_result($result1, $i, "userName") == kullAdi($id)) {
break;
}
}
if ($grafikli) {
rankGrafik(@mysql_numrows($result1) - $rank, @mysql_numrows($result1));
}
if ($sadeYuzde and @mysql_numrows($result1) > 0) {
return 100 - round($rank * 100 / @mysql_numrows($result1));
}
return "{$rank} /" . @mysql_numrows($result1);
} else {
return 0;
}
return 0;
}
while ($satir = mysql_fetch_assoc($veriSonuc)) {
$humanRelativeDate = new HumanRelativeDate();
$insansi = $humanRelativeDate->getTextForSQLDate($satir['eklenmeTarihi']);
$satirRenk++;
if ($satirRenk & 1) {
$row_color = "#CCC";
} else {
$row_color = "#ddd";
}
?>
<tr>
<td <?php
echo "style=\"background-color: {$row_color};\"";
?>
><?php
echo "<a href='profil.php?kim=" . $satir['userID'] . "' rel='facebox'>" . (kullAdi($satir['userID']) == "" ? "<font class=bosVeri title='Kayıt yok veya bir hata meydana geldi!'>###</font>" : kullAdi($satir['userID'])) . "</a>";
?>
</td>
<td <?php
echo "style=\"background-color: {$row_color};\"";
?>
><?php
if ($tur == "2" or $satir['userID'] == getUserID($_SESSION["usern"], $_SESSION["userp"])) {
?>
<a href="#" onclick="javascript:delWithCon('<?php
echo $currentPage;
?>
',<?php
echo $satir['id'];
?>
,'<?php