Beispiel #1
0
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";
}
Beispiel #2
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\)","\(:","):",":.\("," )","&#8217;");
$duzgun=array("<br>","i","þ","ç","ð","ö","ö","ü"," ","i","þ","þ","ý","ý","ð","ð","","","","","","","","","","","",")","'");
$deger=str_replace($turkce,$duzgun,$deger);
$deger = strtolower($deger);
return $deger;
}
?>
Beispiel #3
0
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 &ccedil;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 &ccedil;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'] . "&amp;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&uuml;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'] . "&amp;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;
}