예제 #1
0
    if ($soru_bilgileri["question"] != "") {
        ?>
<div id="kapsayici">
  <div id="soruMetni">
    <pre><?php 
        echo $soru_bilgileri["question"];
        ?>
</pre>
  </div>
  <div id="soruSoran"><?php 
        echo getUserName($soru_bilgileri["userID"]);
        ?>
</div>
  <div class="temizle"></div>
  <div id="dersAdi"><?php 
        echo getDersAdi($soru_bilgileri["dersID"]);
        ?>
</div>
  <div id="soruTarihi">
    <?php 
        $humanRelativeDate = new HumanRelativeDate();
        $insansi = $humanRelativeDate->getTextForSQLDate($soru_bilgileri["eklenmeTarihi"]);
        echo $insansi;
        ?>
  </div>
  <div class="temizle"></div>
</div>
<?php 
        $soruID = $soru_bilgileri["id"];
        $srgCev = "select *,(\r\n\t \t\t\t\t\tselect sum(eo_askanswerrate.degeri) from eo_askanswerrate\r\n\t\t\t\t\t\twhere cevapID=eo_askanswer.id\r\n\t\t\t\t\t\t) as totalOy from eo_askanswer \r\n\t \t\t\twhere eo_askanswer.soruID='{$soruID}' \r\n\t\t\t\torder by totalOy DESC, eo_askanswer.eklenmeTarihi DESC";
        $sorguCev = mysql_query($srgCev);
예제 #2
0
파일: kursDetay.php 프로젝트: ergun805/eOgr
            <div class="Post-bc">
              <div>&nbsp;</div>
            </div>
            <div class="Post-cl">
              <div>&nbsp;</div>
            </div>
            <div class="Post-cr">
              <div>&nbsp;</div>
            </div>
            <div class="Post-cc"></div>
            <div class="Post-body">
              <div class="Post-inner">
                <div class="PostContent">
                  <div class='printMe' style="margin:3px;">
                    <?php 
    echo "<h4 align='center'>{$metin['363']} : " . getDersAdi($dersID) . " (" . getDerstekiKonuSay($dersID) . ")</h4>";
    echo "<h5>{$metin['17']} : " . getUserName($uID) . "</h5>";
    echo getKursTablo($dersID, $uID);
    ?>
                  </div>
                  <hr noshade="noshade">
                  <p> <a href="#" class="yazdir external" style="background-color:white"><?php 
    echo $metin[462];
    ?>
</a> </p>
                </div>
                <div class="cleared"></div>
              </div>
            </div>
          </div>
          <?php 
예제 #3
0
파일: conf.php 프로젝트: ergun805/eOgr
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;
    }
}