?>
</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;
}
