?> </td> <td nowrap="nowrap" <?php echo "style=\"background-color: {$row_color};\""; ?> ><?php echo tarihOku2($row_eoUsers['calismaTarihi']); ?> </td> </tr> <?php } while ($row_eoUsers = mysql_fetch_assoc($eoUsers)); ?> <tr> <td colspan="6" class="tabloAlt"><?php printf($metin[189], Sec2Time2(round(getStats(9)))); ?> </td> </tr> </table> <?php if ($totalRows_eoUsers > $maxRows_eoUsers) { ?> <table border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#CCCCCC" > <tr> <td><div align="center"> <a href="<?php printf("%s?pageNum_eoUsers=%d%s&yonU=dur", $currentPage, 0, $queryString_eoUsers); ?> "><img src="img/page-first.gif" border="0" alt="first" /></a> </div></td> <td><div align="center"> <a href="<?php printf("%s?pageNum_eoUsers=%d%s&yonU=dur", $currentPage, max(0, $pageNum_eoUsers - 1), $queryString_eoUsers);
} if (trim(getStats(17)) != "") { echo "<strong><img src=\"img/i_warn.png\" border=\"0\" style=\"vertical-align: middle;\" alt=\"ogrenci\"/> " . $metin[456] . " :</strong> " . getStats(17) . "<br/>"; } if (trim(getStats(3)) != "") { echo "<strong><img src=\"img/i_high.png\" border=\"0\" style=\"vertical-align: middle;\" alt=\"info\"/> " . $metin[201] . " :</strong> " . getStats(3) . "<br/>"; } // if (trim(getStats(4))!="") echo "<strong>".$metin[202]." :</strong> ".getStats(4)."<br/>"; if (trim(getStats(6)) != "") { echo "<strong><img src=\"img/ogrt_user.png\" border=\"0\" style=\"vertical-align: middle;\" alt=\"ogretmen\"/> " . $metin[203] . " :</strong> " . getStats(6) . "<br/>"; } if (trim(getStats(8)) != "") { echo "<strong>" . $metin[204] . " :</strong> " . Sec2Time2(round(getStats(8))) . "<br/>"; } if (trim(getStats(9)) != "") { echo "<strong>" . $metin[205] . " :</strong> " . Sec2Time2(round(getStats(9))) . "<br/>"; } if (trim(getStats(10)) != "") { echo "<strong>" . $metin[206] . " :</strong> %" . round(getStats(10)) . "<br/>"; } echo "</div>"; if (trim(getStats(13)) != "") { //son güncellenen echo "<div class='ikiKolon'>"; echo "<strong>" . $metin[84] . "</strong>" . getStats(13) . "</div>"; } if (trim(getStats(2)) != "") { //en fazla çalýþýlan echo "<div class='ikiKolon'><strong>" . $metin[200] . "</strong><br/>" . getStats(2) . "</div><div class=clear></div>"; } if (trim(getStats(14)) != "") {
function calisilmaSureToplam($id) { global $yol1; $id = substr(temizle2($id), 0, 15); $sql1 = "SELECT sum(toplamZaman) as toplam from eo_userworks \r\n\t where konuID={$id} "; $result1 = mysql_query($sql1, $yol1); if ($result1 && mysql_numrows($result1) == 1) { return Sec2Time2(mysql_result($result1, 0, "toplam")); } else { return ""; } }
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; }
function listeGetir($userID, $durum) { global $yol1; global $metin; $ekle = ""; if (!empty($durum) && !empty($userID)) { $num = (int) substr($durum, 0, 15); switch ($num) { case 2: //en fazla çalýþýlan konular $sql1 = "SELECT eo_4konu.id as id, eo_4konu.konuAdi as konuAdi, count(*) as toplam \r\n\t\t\t\t\t\t\t\t\t\tFROM eo_4konu,eo_userworks \r\n\t\t\t\t\t\t\t\t\t\tWHERE eo_4konu.id = eo_userworks.konuID\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY konuAdi\r\n\t\t\t\t\t\t\t\t\t\tORDER BY toplam DESC, konuAdi"; $result1 = mysql_query($sql1, $yol1); if ($result1) { if (mysql_num_rows($result1) == 0) { return ""; } $ekle = "<ul id='anythingSlider'><li>"; $donguSon = mysql_num_rows($result1); for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result1); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " <a href=\"lessons.php?konu=" . $data["id"] . "\" target='_parent'>" . $data["konuAdi"] . " </a> <font size='-3'>" . $data["toplam"] . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; echo $ekle; return $ekle; } else { return ""; } break; case 11: //þu anki kullanýcýnýn çalýþma konularý ve sayýlarý $sql1 = "SELECT eo_4konu.id as id, eo_4konu.konuAdi as konuAdi, \r\n\t\t\t\t\t\t\t\t\t\t\t\tcount(*) as toplam \r\n\t\t\t\t\t\t\t\t\t\tFROM eo_4konu,eo_userworks, eo_users \r\n\t\t\t\t\t\t\t\t\t\tWHERE eo_4konu.id = eo_userworks.konuID \r\n\t\t\t\t\t\t\t\t\t\t\t and eo_users.id = eo_userworks.userID\r\n\t\t\t\t\t\t\t\t\t\t\t and eo_users.id = '" . $userID . "'\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY konuAdi\r\n\t\t\t\t\t\t\t\t\t\tORDER BY toplam DESC, konuAdi"; $result1 = mysql_query($sql1, $yol1); if ($result1) { if (mysql_num_rows($result1) == 0) { return ""; } $ekle = "<ul id='anythingSlider'><li>"; $donguSon = mysql_num_rows($result1); for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result1); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " <a href=\"lessons.php?konu=" . $data["id"] . "\" target='_parent'>" . $data["konuAdi"] . " </a> <font size='-3'>" . $data["toplam"] . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; echo $ekle; return true; } else { return ""; } break; case 12: //þu anki kullanýcýnýn bitirdiði dersler if ($_GET["user"] != "") { //eðer baþka kullanýcý inceleniyor ise $userID = temizle($_GET["user"]); } $sql1 = "SELECT eo_3ders.dersAdi as dersAdi, eo_4konu.konuAdi as konuAdi, \r\n\t\t\t\t\t\t\t\t\t\t\t\teo_2sinif.sinifAdi as sinifAdi, eo_1okul.okulAdi as okulAdi,\r\n\t\t\t\t\t\t\t\t\t\t\t\teo_3ders.id as dersID, \r\n\t\t\t\t\t\t\t\t\t\t\t\tsum(eo_userworks.toplamZaman) as toplam \r\n\t\t\t\t\t\t\t\t\t\tFROM eo_1okul, eo_2sinif, eo_3ders, eo_4konu, eo_userworks, eo_users \r\n\t\t\t\t\t\t\t\t\t\tWHERE eo_4konu.id = eo_userworks.konuID and \r\n\t\t\t\t\t\t\t\t\t\t\t eo_users.id = eo_userworks.userID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_3ders.id = eo_4konu.dersID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_2sinif.id = eo_3ders.sinifID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_1okul.id = eo_2sinif.okulID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_users.id = '" . $userID . "'\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY dersAdi\r\n\t\t\t\t\t\t\t\t\t\tORDER BY toplam DESC"; $result1 = mysql_query($sql1, $yol1); if ($result1) { if (mysql_num_rows($result1) == 0) { return ""; } $ekle = "<ul id='anythingSlider'><li>"; $donguSon = mysql_num_rows($result1); for ($i = 0; $i < $donguSon; $i++) { $row_gelen = mysql_fetch_assoc($result1); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " " . $row_gelen['okulAdi'] . " " . $row_gelen['sinifAdi'] . " - <a href='kursDetay.php?kurs=" . $row_gelen['dersID'] . "&user={$userID}' target='_parent'>" . $row_gelen['dersAdi'] . "</a> <font size='-3'>" . Sec2Time2($row_gelen['toplam']) . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; echo $ekle; return $ekle; } else { return ""; } break; case 13: //son güncellenen konular $sql = "SELECT eo_5sayfa.konuID as idsi, eo_4konu.konuAdi as kadi," . "eo_3ders.dersAdi as dersAdi, max(eo_5sayfa.eklenmeTarihi) as tarih " . "from eo_5sayfa, eo_4konu, eo_3ders " . "where eo_5sayfa.konuID=eo_4konu.id " . "and eo_4konu.dersID=eo_3ders.id " . "GROUP BY kadi " . "order by tarih desc,kadi"; $result = mysql_query($sql, $yol1); if ($result) { if (@mysql_numrows($result) > 0) { $ekle = "<ul id='anythingSlider'><li>"; $donguSon = mysql_num_rows($result); for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result); if ($i % 19 == 0 and $i > 0) { $ekle .= "</li><li>"; } $humanRelativeDate = new HumanRelativeDate(); $insansi = $humanRelativeDate->getTextForSQLDate($data["tarih"]); if ($data["tarih"] == "0000-00-00 00:00:00") { $ekle .= "<a href=\"lessons.php?konu=" . $data["idsi"] . "\" target='_parent'>" . $data["kadi"] . " - " . $data["dersAdi"] . "</a><br/>"; } else { $ekle .= "<a href=\"lessons.php?konu=" . $data["idsi"] . "\" target='_parent'>" . $data["kadi"] . " - " . $data["dersAdi"] . "</a>" . " <font size='-3'>" . $insansi . "</font><br/>"; } } $ekle .= "</li>"; $ekle .= "</ul>"; } echo $ekle; return $ekle; } else { return ""; } break; case 14: //en fazla oy verilen konular $sql = "SELECT eo_4konu.id as idsi, eo_4konu.konuAdi as kadi," . " avg(eo_rating.value) as ortalama, count(eo_rating.value) as toplam " . "from eo_rating, eo_4konu " . "where eo_rating.konuID=eo_4konu.id " . "GROUP BY kadi " . "order by ortalama desc,toplam DESC,konuAdi"; $result = mysql_query($sql, $yol1); if ($result) { if (@mysql_numrows($result) > 0) { $donguSon = @mysql_numrows($result); $ekle .= "<ul id='anythingSlider'>"; $ekle .= "<li>"; for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " <a href=\"lessons.php?konu=" . $data["idsi"] . "\" target='_parent'>" . $data["kadi"] . "</a>" . " <font size='1' title='{$metin['273']} : " . $data["toplam"] . ", {$metin['274']} : " . round($data["ortalama"], 1) . "'>" . $data["toplam"] . "/" . round($data["ortalama"], 1) . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; } echo $ekle; return $ekle; } else { return ""; } break; case 15: //en fazla yorum eklenen konular $sql = "SELECT eo_4konu.id as idsi, eo_4konu.konuAdi as kadi," . " count(*) as toplam " . "from eo_comments, eo_4konu " . "where eo_comments.konuID=eo_4konu.id " . " and eo_comments.active=1 " . "GROUP BY kadi " . "order by toplam desc,kadi"; $result = mysql_query($sql, $yol1); if ($result) { if (@mysql_numrows($result) > 0) { $donguSon = @mysql_numrows($result); $ekle .= "<ul id='anythingSlider'>"; $ekle .= "<li>"; for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " <a href=\"lessons.php?konu=" . $data["idsi"] . "\" target='_parent'>" . $data["kadi"] . " </a> <font size='-3'>" . $data["toplam"] . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; } echo $ekle; return $ekle; } else { return ""; } break; case 16: //son demo çalýþmalarý $sql = "SELECT eo_4konu.id as idsi, eo_4konu.konuAdi as kadi," . " count(*) as toplam " . "from eo_userworks, eo_4konu " . "where eo_userworks.konuID=eo_4konu.id " . "GROUP BY kadi " . "order by toplam desc,kadi"; $result = mysql_query($sql, $yol1); if ($result) { if (@mysql_numrows($result) > 0) { $donguSon = @mysql_numrows($result); $ekle .= "<ul id='anythingSlider'>"; $ekle .= "<li>"; for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " <a href=\"lessons.php?konu=" . $data["idsi"] . "\" target='_parent'>" . $data["kadi"] . " </a> <font size='-3'>" . $data["toplam"] . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; } @mysql_free_result($result); echo $ekle; return $ekle; } else { return ""; } break; case 19: //þu anki kullanýcýnýn bitirdiði dersler if (isset($_SESSION["kursUser2"])) { //eðer baþka kullanýcý inceleniyor ise $userID = temizle($_SESSION["kursUser2"]); } $sql1 = "SELECT eo_3ders.dersAdi as dersAdi, eo_4konu.konuAdi as konuAdi, \r\n\t\t\t\t\t\t\t\t\t\t\t\teo_2sinif.sinifAdi as sinifAdi, eo_1okul.okulAdi as okulAdi,\r\n\t\t\t\t\t\t\t\t\t\t\t\teo_3ders.id as dersID, \r\n\t\t\t\t\t\t\t\t\t\t\t\tsum(eo_userworks.toplamZaman) as toplam \r\n\t\t\t\t\t\t\t\t\t\tFROM eo_1okul, eo_2sinif, eo_3ders, eo_4konu, eo_userworks, eo_users \r\n\t\t\t\t\t\t\t\t\t\tWHERE eo_4konu.id = eo_userworks.konuID and \r\n\t\t\t\t\t\t\t\t\t\t\t eo_users.id = eo_userworks.userID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_3ders.id = eo_4konu.dersID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_2sinif.id = eo_3ders.sinifID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_1okul.id = eo_2sinif.okulID and\r\n\t\t\t\t\t\t\t\t\t\t\t eo_users.id = " . $userID . "\r\n\t\t\t\t\t\t\t\t\t\tGROUP BY dersAdi\r\n\t\t\t\t\t\t\t\t\t\tORDER BY toplam DESC"; $result1 = mysql_query($sql1, $yol1); if ($result1) { if (mysql_num_rows($result1) == 0) { return ""; } $ekle = "<ul id='anythingSlider'><li>"; $donguSon = mysql_num_rows($result1); for ($i = 0; $i < $donguSon; $i++) { $row_gelen = mysql_fetch_assoc($result1); if ($i % 15 == 0 and $i > 0) { $ekle .= "</li><li>"; } $ekle .= $i + 1 . " " . $row_gelen['okulAdi'] . " " . $row_gelen['sinifAdi'] . " - <a href='kursDetay2.php?kurs=" . $row_gelen['dersID'] . "&kisi={$userID}' target='_parent'>" . $row_gelen['dersAdi'] . "</a> <font size='-3'>" . Sec2Time2($row_gelen['toplam']) . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; echo $ekle; return $ekle; } else { return ""; } break; case 20: //son çalýþýlan konular $sql1 = "SELECT eo_4konu.id as idsi, eo_4konu.konuAdi as kadi,\r\n\t\t\t\t\t \tMAX(eo_userworks.calismaTarihi) as tarih \r\n\t\t\t\t\t from eo_userworks, eo_4konu \r\n\t\t\t\t\t where eo_userworks.konuID=eo_4konu.id \r\n\t\t\t\t\t GROUP BY kadi \r\n\t\t\t\t\t order by tarih desc,konuAdi"; $yol1 = baglan(); $result = mysql_query($sql1, $yol1); if ($result) { if (@mysql_numrows($result) > 0) { $donguSon = @mysql_numrows($result); $ekle .= "<ul id='anythingSlider'>"; $ekle .= "<li>"; for ($i = 0; $i < $donguSon; $i++) { $data = mysql_fetch_assoc($result); if ($i % 19 == 0 and $i > 0) { $ekle .= "</li><li>"; } $humanRelativeDate = new HumanRelativeDate(); $insansi = $humanRelativeDate->getTextForSQLDate($data["tarih"]); $ekle .= "<a href=\"lessons.php?konu=" . $data["idsi"] . "\" target='_parent'>" . $data["kadi"] . " </a> <font size='-3'>" . $insansi . "</font><br/>"; } $ekle .= "</li>"; $ekle .= "</ul>"; } @mysql_free_result($result); echo $ekle; return $ekle; } else { return ""; } break; default: die(""); } //switch return ""; } return false; }