function ogrenciSinifaDahil($adi, $par, $gelen) { $ogrID = getUserID($adi, $par); $sql1 = "SELECT count(*) as toplam FROM eo_sinifogre where eo_sinifogre.userID='" . $ogrID . "' and eo_sinifogre.sinifID = " . getDersIDileSinif($gelen); $yol1 = baglan(); $result1 = mysql_query($sql1, $yol1); if ($result1) { return @mysql_result($result1, 0, "toplam"); } @mysql_free_result($result1); return "0"; }
<? // Fonksiyonlar Basliyor... // Baglaniyor... function baglan () { } // Baglandi baglan(); $ayar["upload"]["profil"]["klasor"]="inc/resimler/avatar/"; $ayar["upload"]["profil"]["yol"]= "inc/resimler/avatar/"; $ayar["upload"]["resim"]["maximum"]=102400; $ayar["upload"]["editor"]["domain"]="$site/inc"; //saat farki date_default_timezone_set('Europe/Istanbul'); //harf küçült function kucultuver($deger) { $turkce=array("\n","Ý","Þ","Ç","Ð","Ö","ö","Ü"," ","%u0130","%u015e","%u015f","%u0131","I","%u011e","%u011f",":)",":\(",":d",";)",":p",":s","\(A\)","\(6\)","\(:","):",":.\("," )","’"); $duzgun=array("<br>","i","þ","ç","ð","ö","ö","ü"," ","i","þ","þ","ý","ý","ð","ð","","","","","","","","","","","",")","'"); $deger=str_replace($turkce,$duzgun,$deger); $deger = strtolower($deger); return $deger; } ?>
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; }