function anaMetniOku($gelen, $sayfaNo)
{
global $yol1;
global $metin;
if (empty($gelen)) {
return "<font id='uyari'>{$metin['176']}</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
if (empty($sayfaNo)) {
return "<font id='uyari'>{$metin['176']}</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
$sql1 = "select \r\n\t eo_5sayfa.id,eo_5sayfa.anaMetin as ana,eo_5sayfa.cevap as cevap,\r\n\t\t\t\teo_5sayfa.eklenmeTarihi as tarih,\t\t\t\t\r\n\t\t\t\teo_5sayfa.slideGecisSuresi as sgSuresi,\r\n\t\t\t\teo_5sayfa.cevapSuresi as cSuresi,\r\n\t\t\t\teo_users.userName as user, \r\n\t\t\t\teo_4konu.konuAdi as konuAdi,eo_4konu.konuyuKilitle as konuyuKilitle,\t\t\r\n\t\t\t\teo_4konu.oncekiKonuID as oncekiKonuID, eo_4konu.calismaHakSayisi as calismaHakSayisi,\t\r\n\t\t\t\teo_4konu.calismaSuresiDakika as calismaSuresiDakika,\r\n\t\t\t\teo_4konu.sinifaDahilKullaniciGorebilir as sinifaDahilKullaniciGorebilir,\r\n\t\t\t\teo_4konu.bitisTarihi as bitisTarihi, eo_4konu.sadeceKayitlilarGorebilir as skg, \r\n\t\t\t\teo_4konu.id as aktifKonuNo\r\n\t\t\t\tfrom eo_5sayfa, eo_users, eo_4konu \r\n\t\t\t\twhere eo_5sayfa.konuID='{$gelen}' and \r\n\t\t\t\t(eo_users.id=eo_5sayfa.ekleyenID) and (eo_4konu.id=eo_5sayfa.konuID) \r\n\t\t\t\torder by eo_5sayfa.sayfaSirasi";
$result1 = mysql_query($sql1, $yol1);
if ($result1) {
mysql_fetch_row($result1);
$kayitSayisi = @mysql_numrows($result1);
if ($sayfaNo < 0) {
$sayfaNo = 0;
} else {
if ($sayfaNo > $kayitSayisi) {
$sayfaNo = $kayitSayisi - 1;
} else {
$sayfaNo = $sayfaNo - 1;
}
}
//0 index kayit baslangicidir
$humanRelativeDate = new HumanRelativeDate();
$insansi = $humanRelativeDate->getTextForSQLDate(@mysql_result($result1, $sayfaNo, "tarih"));
$tarih = $insansi;
$user = @mysql_result($result1, $sayfaNo, "user");
$cevap = @mysql_result($result1, $sayfaNo, "cevap");
$konuAdi = @mysql_result($result1, $sayfaNo, "konuAdi");
$konuyuKilitle = @mysql_result($result1, $sayfaNo, "konuyuKilitle");
$bitisTarihi = @mysql_result($result1, $sayfaNo, "bitisTarihi");
$sKayitlilarG = @mysql_result($result1, $sayfaNo, "skg");
$aktifKonuNo = @mysql_result($result1, $sayfaNo, "aktifKonuNo");
$oncekiKonuID = @mysql_result($result1, $sayfaNo, "oncekiKonuID");
$calismaHakS = @mysql_result($result1, $sayfaNo, "calismaHakSayisi");
$sgSuresi = temizle(@mysql_result($result1, $sayfaNo, "sgSuresi"));
$cSuresi = temizle(@mysql_result($result1, $sayfaNo, "cSuresi"));
$calismaSuresiD = $sKayitlilarG ? @mysql_result($result1, $sayfaNo, "calismaSuresiDakika") : "0";
$sinifOgreK = $sKayitlilarG ? @mysql_result($result1, $sayfaNo, "sinifaDahilKullaniciGorebilir") : "0";
$oncekiKonuAdi = getOncekiKonuAdi($oncekiKonuID);
$sonrakiKonuID = getSonrakiKonu($gelen, "id");
$sonrakiKonuAdi = getSonrakiKonu($gelen, "konuAdi");
if ($bitisTarihi != "0000-00-00") {
$gunFarki = getDayCount(date("Y-n-j"), $bitisTarihi);
} else {
$gunFarki = 1;
}
$adi = temizle(substr(isset($_SESSION["usern"]) ? $_SESSION["usern"] : "", 0, 15));
$par = temizle(isset($_SESSION["userp"]) ? $_SESSION["userp"] : "");
$tur = checkRealUser($adi, $par);
if ($kayitSayisi > 0) {
if ($sKayitlilarG == "1" && !in_array($tur, array("1", "2", "0"))) {
//login olmamýþ
return "<font id='hata'>'{$konuAdi}' " . $metin[181] . "<br/><a href='newUser.php'><img src='img/user_manager.gif' border=\"0\" style=\"vertical-align: middle;\" alt='" . $metin[149] . "' title='" . $metin[149] . "' />{$metin['3']}!</a> <a href='index.php'><img src=\"img/home.png\" border=\"0\" style=\"vertical-align: middle;\" alt=\"main\"/> {$metin['2']}</a></font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
if ($sKayitlilarG == "1" && in_array($tur, array("1", "2", "0"))) {
if (kullaniciHakSayisi($gelen, $adi, $par) >= $calismaHakS && $calismaHakS > 0) {
return "<font id='hata'>'{$konuAdi}', " . $metin[208] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
}
if ($sKayitlilarG == "1" && $tur == "0") {
if (ogrenciSinifaDahil($adi, $par, $gelen) == 0 && $sinifOgreK == 1) {
return "<font id='hata'>'{$konuAdi}', " . $metin[214] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
}
if ($konuyuKilitle == "1") {
return "<font id='hata'><img src='img/lock.png' border=\"0\" style=\"vertical-align: middle;\" alt='" . $metin[179] . "' title='" . $metin[179] . "' /> '{$konuAdi}' " . $metin[179] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
if ($gunFarki <= 0) {
return "<font id='hata'>'{$konuAdi}' " . $metin[180] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
$cevaplanmisMi = @array_key_exists(mysql_result($result1, $sayfaNo, "id"), $_SESSION["cevaplar"]);
if (($cevap != "" || is_numeric($cevap)) && !$cevaplanmisMi) {
$cevap = mysql_result($result1, $sayfaNo, "id");
} else {
$cevap = "-";
}
return html_entity_decode(@mysql_result($result1, $sayfaNo, "ana")) . "|" . $tarih . "|" . $user . "|" . $kayitSayisi . "|" . $sayfaNo . "|" . $konuAdi . "|" . $oncekiKonuID . "|" . $oncekiKonuAdi . "|" . $sonrakiKonuID . "|" . $sonrakiKonuAdi . "|" . $calismaSuresiD . "|" . $cevap . "|" . $aktifKonuNo . "|" . $cSuresi . "|" . $sgSuresi;
} else {
return "<font id='hata'><img src='img/empty.png' border=\"0\" style=\"vertical-align: middle;\" alt='" . $metin[209] . "' title='" . $metin[209] . "' />" . $metin[182] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
} else {
return "<font id='hata'>" . $metin[183] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
return "<font id='hata'>" . $metin[184] . "</font>|-|-|-|-|-|-|-|-|-|-|-|-|-|-";
}
function sonGiris($id)
{
global $yol1;
$id = substr(temizle2($id), 0, 15);
$sql1 = "SELECT dateTime FROM eo_usertrack where userName='******' and processName='login.php' and otherInfo='success,Login' order by dateTime DESC limit 0,1";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && mysql_numrows($result1) == 1) {
$humanRelativeDate = new HumanRelativeDate();
$insansi = $humanRelativeDate->getTextForSQLDate(mysql_result($result1, 0, "dateTime"));
return $insansi;
} else {
return "";
}
}
$sOutput .= '"aaData": [ ';
while ($aRow = mysql_fetch_array($rResult)) {
$sOutput .= "[";
$kayNo = $aRow[$aColumns[0]];
for ($i = 0; $i < count($aColumns); $i++) {
if ($aColumns[$i] == "fileName") {
/* Special output formatting */
$sOutput .= '"<a href=\\"fileDownload.php?id=' . $aRow[$aColumns[0]] . '&file=' . $aRow[$aColumns[$i]] . '\\" class=\\"external\\">' . $aRow[$aColumns[$i]] . '</a> ';
if (in_array(file_ext($aRow[$aColumns[$i]]), array("jpg", "jpeg", "png", "gif"))) {
$sOutput .= ' <a href=\\"fileDownload.php?id=' . $aRow[$aColumns[0]] . '&file=' . $aRow[$aColumns[$i]] . '&islem=goster\\" target=\\"_blank\\"><img src=\\"img/preview.png\\" border=\\"0\\" style=\\"vertical-align:middle\\" alt=\\"207\\"/></a> ';
}
if (in_array(file_ext($aRow[$aColumns[$i]]), $_filesToPlay)) {
$sOutput .= ' <a href=\\"fileDownload.php?id=' . $aRow[$aColumns[0]] . '&file=' . $aRow[$aColumns[$i]] . '&islem=goster\\" target=\\"_blank\\"><img src=\\"img/preview.png\\" border=\\"0\\" style=\\"vertical-align:middle\\" alt=\\"??\\"/></a> ';
}
$sOutput .= " <font size='-2'>" . getSizeAsString(@filesize($_uploadFolder . '/' . $aRow[$aColumns[$i]]));
$humanRelativeDate = new HumanRelativeDate();
$sOutput .= " " . iconv("ISO-8859-9", "UTF-8", $humanRelativeDate->getTextForSQLDate(date("Y-m-d H:i:s", @filemtime($_uploadFolder . '/' . $aRow[$aColumns[$i]])))) . '</font>",';
} else {
if ($aColumns[$i] == 'userID') {
$sOutput .= ' "' . $aRow[4] . '",';
} else {
if ($aColumns[$i] != ' ') {
/* General output */
$sOutput .= '"' . str_replace('"', '\\"', $aRow[$aColumns[$i]]) . '",';
} else {
if ($aColumns[$i] == ' ') {
/* Delete */
if (($aRow[4] == $_SESSION["usern"] or getUserType($_SESSION["usern"]) == "2") and (preg_match("/777/", decoct(@fileperms($_uploadFolder))) or preg_match("/766/", decoct(@fileperms($_uploadFolder))))) {
$sOutput .= '"<img src=\\"img/cross.png\\" alt=\\"delete\\" width=\\"16\\" height=\\"16\\" border=\\"0\\" style=\\"vertical-align: middle;cursor:pointer;\\" onclick=\\"javascript:delWithCon(' . $kayNo . ')\\" title=\\"' . $metin[102] . '\\"/>",';
} else {
$sOutput .= '"",';
title='Dil seçiniz Choose a language'
onmouseover="mopen('dilSecimi');"
onmouseout="mclosetime();" />
<div id="dilSecimi" onmouseover="mcancelclosetime()" onmouseout="mclosetime()"> <a href='index.php?lng=EN&oldPath=<?php
echo $currentFile;
?>
' ><img src='img/turkish.png' border='0' alt='Dil' style='vertical-align: middle;'/></a> <a href='index.php?lng=TR&oldPath=<?php
echo $currentFile;
?>
'> <img src='img/english.png' border='0' alt='Language' style='vertical-align: middle;'/></a> </div>
<?php
}
if ($seceneklerimiz[3] == "1" and $kullaniciSecen[3] == "1") {
echo " " . $metin[155] . " " . round(getmicrotime() - $time, 3) . "s";
}
$humanRelativeDate2 = new HumanRelativeDate();
$insansi = $humanRelativeDate2->getTextForSQLDate(date("Y-m-d H:i:s", filemtime($currentFile)));
if ($seceneklerimiz[4] == "1" and $kullaniciSecen[4] == "1") {
echo " | <font size='-3'>" . $metin[217] . " " . $insansi . "</font>";
}
?>
<strong> <?php
echo $metin[68];
?>
:</strong> <?php
echo ayarGetir("versiyon");
?>
</form>
</div>
<?php
mysql_close($yol);
echo $gecerliKullID;
?>
);return false;"><img src="img/cross.png" alt="delete" width="16" height="16" border="0" style="vertical-align: middle;" title="<?php
echo $metin[102];
?>
"/></a>
<?php
}
?>
<?php
echo cevapOyToplami($cevap_bilgileri["id"]);
?>
</div>
<div class="cevapTarihi">
<?php
$humanRelativeDate = new HumanRelativeDate();
$insansi = $humanRelativeDate->getTextForSQLDate($cevap_bilgileri["eklenmeTarihi"]);
echo $insansi;
?>
</div>
<div class="temizle"></div>
</div>
<?php
}
//while
} else {
echo "<strong>{$metin['654']}</strong>";
}
?>
<div id="kapsayiciEkle">
<form>
function tamamlanmisEtkinlikListesi()
{
global $yol1, $metin;
$lmt = 3;
//geçmiþ 3 etkinlik
$sql = "SELECT *,DATE_FORMAT(dateWhen, '%d-%m-%Y %H:%i') as dt FROM eo_livelesson\r\n\t\t WHERE \r\n\t\t (unix_timestamp(now()) - unix_timestamp(dateWhen) )/3600/24 > 0 \r\n\t\t order by dateWhen DESC\r\n\t\t LIMIT 0,{$lmt}";
$result = mysql_query($sql, $yol1);
$data = "";
while ($row = mysql_fetch_assoc($result)) {
$humanRelativeDate = new HumanRelativeDate();
$tarihi = $humanRelativeDate->getTextForSQLDate($row['dateWhen']);
$data .= "<li>" . getUserName($row['userID']) . ", " . getDersAdi($row['dersID']) . ", " . $row["length"] . " dakika <strong>" . $row["yontem"] . "</strong>" . "<br/><span style='font-size:13px;font-style:italic;'>" . $row['dt'] . " (" . $tarihi . ")</span></li>";
}
if ($data == "") {
return "<li>{$metin['586']}</li>";
} else {
return $data;
}
}
echo " | <a href='rss.php' target='_blank' class='external'>{$metin['480']}</a>";
?>
</div>
<ul>
<?php
if ($seceneklerimiz[11] == "1" and $kullaniciSecen[11] == "1") {
$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>
function sonGuncellenmeTarihi($id)
{
global $yol1;
$id = substr(temizle2($id), 0, 15);
$sql1 = "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 " . "and eo_4konu.id={$id} " . "GROUP BY kadi " . "order by tarih desc,kadi ";
$result1 = mysql_query($sql1, $yol1);
if ($result1 && mysql_numrows($result1) == 1) {
$humanRelativeDate = new HumanRelativeDate();
$insansi = $humanRelativeDate->getTextForSQLDate(mysql_result($result1, 0, "tarih"));
return $insansi;
} else {
return "";
}
}
echo $metin[647];
?>
</th>
<th ><?php
echo $metin[363];
?>
</th>
<th width="20%"><?php
echo $metin[129];
?>
</th>
</tr>
<?php
$satirRenk = 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>";
?>
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;
}