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;
}
<td <?php
echo "style=\"background-color: {$row_color};\"";
?>
><a href="dersBilgisi.php?ders=<?php
echo $row_eoUsers['konuID'];
?>
" rel="facebox">
<?php
echo $row_eoUsers['konuAdi'] ? araKalin($row_eoUsers['konuAdi']) : "<span class=bosVeri>###</span>";
?>
</a></td>
<td align="left" nowrap="nowrap" <?php
echo "style=\"background-color: {$row_color};\"";
?>
><?php
echo yildizYap($row_eoUsers['value']);
?>
</td>
<td nowrap="nowrap" <?php
echo "style=\"background-color: {$row_color};\"";
?>
><?php
echo tarihOku2($row_eoUsers['rateDate']);
?>
</td>
<?php
if ($tur == "2") {
?>
<td align="center" nowrap="nowrap" valign="middle" ><a href="#" onclick="javascript:delWithCon('<?php
echo $currentPage;
?>
echo "<strong>{$metin['329']} :</strong> " . sayfaSayisi($_GET["ders"]) . "<br/>";
}
if (sonGuncellenmeTarihi($_GET["ders"]) != "") {
echo "<strong>{$metin['331']} :</strong> " . sonGuncellenmeTarihi($_GET["ders"]) . "<br/>";
}
if (calisilmaSay($_GET["ders"]) > 0) {
echo "<strong>{$metin['332']} :</strong> " . calisilmaSay($_GET["ders"]) . "<br/>";
}
if (calisilmaSureToplam($_GET["ders"]) > 0) {
echo "<strong>{$metin['333']} :</strong> " . calisilmaSureToplam($_GET["ders"]) . "<br/>";
}
if (calisilmaBitmeOrt($_GET["ders"]) > 0) {
echo "<strong>{$metin['334']} :</strong> " . round(calisilmaBitmeOrt($_GET["ders"]), 1) . "%<br/>";
}
if (oyOrani($_GET["ders"]) > 0) {
echo "<strong>{$metin['335']} :</strong> <font title='{$metin['341']} : " . oySay($_GET["ders"]) . ", {$metin['323']} : " . round(oyOrani($_GET["ders"]), 1) . "'>" . yildizYap(round(oyOrani($_GET["ders"]))) . "</font><br/>";
}
if (yorumSay($_GET["ders"]) > 0) {
echo "<strong>{$metin['336']} :</strong> " . yorumSay($_GET["ders"]) . "<br/>";
}
if (yorumPasifSay($_GET["ders"]) > 0) {
echo "<strong>{$metin['337']} :</strong> " . yorumPasifSay($_GET["ders"]) . "<br/>";
}
if (konuKisitlamalari($_GET["ders"]) != "") {
echo "<strong>{$metin['338']} :</strong> <i>" . konuKisitlamalari($_GET["ders"]) . "</i><br/>";
}
if (!isset($_GET['set']) or $_GET['set'] != "1") {
echo "<br/>";
echo "<a href=\"lessons.php?konu=" . $_GET["ders"] . "\" ><img src=\"img/lessons.gif\" border=\"0\" style=\"vertical-align: middle;\" alt=\"lessons\"/> {$metin['339']}</a>";
echo "</p>";
}
