?> &pageNum_eoUsers=<?php echo $aa1; ?> "> <?php echo $row_eoUsers['active'] == "0" ? "<img src='img/unchecked.gif' border='0'/>" : "<img src='img/checked.gif' border='0' />"; ?> </a></td> <td align="left" title="<?php echo $row_eoUsers['comment']; ?> " <?php echo "style=\"background-color: {$row_color};\""; ?> ><?php echo araKalin(smileAdd(smartShort($row_eoUsers['comment'], 45))); ?> </td> <td nowrap="nowrap" <?php echo "style=\"background-color: {$row_color};\""; ?> ><?php echo tarihOku2($row_eoUsers['commentDate']); ?> </td> <td align="center" nowrap="nowrap" valign="middle" ><a href="<?php echo $currentPage; ?> ?id=<?php echo $row_eoUsers['id']; ?>
function sonBilgileriGetir($tablo, $userID) { global $yol1, $metin, $_uploadFolder; $sonuc = ""; $humanRelativeDate = new HumanRelativeDate(); if (!empty($userID)) { $kisiAdi = getUserName($userID); $kisiFiltre2 = " WHERE eo_shoutbox.name = '{$kisiAdi}' "; $kisiFiltre = " WHERE eo_users.id = '{$userID}' "; } else { $kisiFiltre2 = ""; $kisiFiltre = ""; } 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\r\n\t\t\t\t\t {$kisiFiltre}\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_rating.rateDate DESC limit 0," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($gelen = @mysql_fetch_array($result1)) { $insansi = $humanRelativeDate->getTextForSQLDate($gelen[4]); if (empty($userID)) { $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 . "<br/>"; } else { $sonuc .= "<a href='dersBilgisi.php?ders={$gelen['14']}' rel='facebox'>" . $gelen[15] . "</a>, " . yildizYap($gelen[3]) . ", " . $insansi . "<br/>"; } } } break; case "yorum": if (empty($kisiFiltre)) { $aramaFiltre = " WHERE active='1' "; } else { $aramaFiltre = " {$kisiFiltre} and active='1' "; } $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 {$aramaFiltre}\r\n\t\t\t\t\t ORDER BY eo_comments.commentDate DESC limit 0," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($gelen = @mysql_fetch_array($result1)) { $insansi = $humanRelativeDate->getTextForSQLDate($gelen[4]); if (empty($userID)) { $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 . "<br/>"; } else { $sonuc .= "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . $insansi . "<br/>"; } } } 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 {$kisiFiltre2}\r\n\t\t\t\t\t ORDER BY eo_shoutbox.date DESC limit 0," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($gelen = @mysql_fetch_array($result1)) { $insansi = $humanRelativeDate->getTextForSQLDate($gelen[5]); if (empty($userID)) { $sonuc .= "<a href='profil.php?kim={$gelen['6']}' rel='facebox'>" . $gelen[1] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . odaGetir($gelen[4]) . ", " . $insansi . "<br/>"; } else { $sonuc .= smileAdd(smartShort($gelen[3])) . ", " . odaGetir($gelen[4]) . ", " . $insansi . "<br/>"; } } } 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," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($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 . "<br/>"; } } 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\r\n\t\t\t\t\t {$kisiFiltre}\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_userworks.calismaTarihi DESC limit 0," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($gelen = @mysql_fetch_array($result1)) { $insansi = $humanRelativeDate->getTextForSQLDate($gelen[5]); if (empty($userID)) { $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 . "<br/>"; } else { $sonuc .= "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . Sec2Time2($gelen[3]) . ", " . $gelen[4] . ", " . $insansi . "<br/>"; } } } break; case "soru": $sql1 = "SELECT *,\r\n\t\t\t (select count(id) from eo_askanswer where soruID=eo_askquestion.id) as say \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 {$kisiFiltre}\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_askquestion.eklenmeTarihi DESC limit 0," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($gelen = @mysql_fetch_array($result1)) { $insansi = $humanRelativeDate->getTextForSQLDate($gelen[3]); if (empty($userID)) { $sonuc .= "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[7] . "</a>, " . "<a href='readAnswer.php?oku={$gelen['0']}' rel=\"shadowbox;height=400;width=800\" title='Cevap Oku'>" . smartShort($gelen['question'], 30) . "</a>, " . $gelen["say"] . ", " . $insansi . "<br/>"; } else { $sonuc .= "<a href='readAnswer.php?oku={$gelen['0']}' rel=\"shadowbox;height=400;width=800\" title='Cevap Oku'>" . smartShort($gelen['question'], 30) . "</a>, " . $gelen["say"] . ", " . $insansi . "<br/>"; } } } 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 {$kisiFiltre}\r\n\t\t\t\t\t ORDER BY eo_files.id DESC limit 0," . ayarGetir("ayar2int"); $result1 = mysql_query($sql1, $yol1); if ($result1 && @mysql_num_rows($result1) >= 1) { while ($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]))); if (empty($userID)) { $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 . "<br/>"; } else { $sonuc .= "<a href='fileDownload.php?id={$gelen['0']}&file={$gelen['2']}'>" . $gelen[2] . "</a>, " . $gelen[3] . ", " . $insansi . "<br/>"; } } } } break; } return $sonuc; }
?> ><a href="profil.php?kim=<?php echo getUserID2($row_eoUsers['name']); ?> " rel="facebox"><?php echo araKalin($row_eoUsers['name']); ?> </a></td> <td <?php echo "style=\"background-color: {$row_color};\""; ?> title="<?php echo $row_eoUsers['message']; ?> "><?php echo araKalin(smileAdd(smartShort($row_eoUsers['message'], 45))); ?> </td> <td <?php echo "style=\"background-color: {$row_color};\""; ?> ><?php echo odaGetir($row_eoUsers['ip']); ?> </td> <td nowrap="nowrap" <?php echo "style=\"background-color: {$row_color};\""; ?> ><?php echo tarihOku2($row_eoUsers['date']); ?>
$sql1 = "select id from eo_webref_rss_items ORDER BY pubDate DESC LIMIT 0," . ayarGetir("ayar1int"); $result1 = @mysql_query($sql1, $yol1); $i = 0; if (@mysql_numrows($result1) > 0) { while ($i < @mysql_numrows($result1)) { ?> <li> <?php echo "<strong>", haberGetir($i, "title"), "</strong> "; $humanRelativeDate = new HumanRelativeDate(); $insansi = $humanRelativeDate->getTextForSQLDate(haberGetir($i, "pubDate")); echo "<font size='-2'>{$insansi}</font>"; ?> <br /> <p> <?php echo smileAdd(haberGetir($i, "description")); ?> <?php if (trim(haberGetir($i, "link")) != "") { echo "<strong><a href='" . haberGetir($i, "link") . "' class='more'>"; echo $metin[162]; echo "</a></strong>"; } ?> </p> </li> <?php $i++; } } else { echo "<li>{$metin['405']}</li>";