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);
<div class="Post-bc"> <div> </div> </div> <div class="Post-cl"> <div> </div> </div> <div class="Post-cr"> <div> </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
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; } }