Example #1
0
                ?>
&amp;pageNum_eoUsers=<?php 
                echo $aa1;
                ?>
"> <?php 
                echo $row_eoUsers['active'] == "0" ? "<img src='img/unchecked.gif' border='0'/>" : "<img src='img/checked.gif' border='0' />";
                ?>
 </a></td>
                        <td align="left" title="<?php 
                echo $row_eoUsers['comment'];
                ?>
" <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
><?php 
                echo araKalin(smileAdd(smartShort($row_eoUsers['comment'], 45)));
                ?>
</td>
                        <td nowrap="nowrap" <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
><?php 
                echo tarihOku2($row_eoUsers['commentDate']);
                ?>
</td>
                        <td align="center" nowrap="nowrap" valign="middle" ><a href="<?php 
                echo $currentPage;
                ?>
?id=<?php 
                echo $row_eoUsers['id'];
                ?>
Example #2
0
</label>
                                  <br />
                                  <label>
                                    <input type="checkbox" name="ayar5char17" 
            id="ayar5char17" value="1" <?php 
if ($secenekler[16] == "1") {
    echo " checked='checked'";
} else {
    echo "";
}
?>
/>
                                    <img src="img/lessons.gif" alt="imp" border="0" style="vertical-align: middle;" /> <?php 
echo $metin[529];
echo "</td></tr><tr><td colspan='2'>";
printf($metin[534], smartShort($_siteUnlockPwd, 0));
?>
</label></td>
                              </tr>
                              <tr>
                                <td colspan="2" align="center"  class="tabloAlt"><input type="hidden" name="MM_settings" value="form5" />
                                  <input type="submit" value="<?php 
echo $metin[121];
?>
" />
                                  &nbsp;
                                  <input type="button" value="<?php 
echo $metin[246];
?>
" onclick="getDefaults();" /></td>
                              </tr>
Example #3
0
</td>
                        <td align="center" <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
><?php 
                echo arkadasKabulDurumu($row_eoUsers['kabul']);
                ?>
</td>
                        <td <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
 title="<?php 
                echo $row_eoUsers['duvarYazisi'];
                ?>
"><?php 
                echo araKalin(smartShort($row_eoUsers['duvarYazisi']));
                ?>
</td>
                        <td align="center" valign="middle" nowrap="nowrap"><a href="<?php 
                echo $currentPage;
                ?>
?id=<?php 
                echo $row_eoUsers['id'];
                ?>
&amp;upd=1&amp;pageNum_eoUsers=<?php 
                echo $pageNum_eoUsers;
                ?>
"><img src="img/edit.png" alt="edit" width="16" height="16" border="0" style="vertical-align: middle;" title="<?php 
                echo $metin[103];
                ?>
"/></a>&nbsp;|&nbsp;<a href="#" onclick="javascript:delWithCon('<?php 
Example #4
0
                ?>
><a href="profil.php?kim=<?php 
                echo getUserID2($row_eoUsers['name']);
                ?>
" rel="facebox"><?php 
                echo araKalin($row_eoUsers['name']);
                ?>
</a></td>
                        <td <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
 title="<?php 
                echo $row_eoUsers['message'];
                ?>
"><?php 
                echo araKalin(smileAdd(smartShort($row_eoUsers['message'], 45)));
                ?>
</td>
                        <td <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
><?php 
                echo odaGetir($row_eoUsers['ip']);
                ?>
</td>
                        <td nowrap="nowrap" <?php 
                echo "style=\"background-color: {$row_color};\"";
                ?>
><?php 
                echo tarihOku2($row_eoUsers['date']);
                ?>
Example #5
0
function sonBilgileriGetir($tablo, $userID)
{
    global $yol1, $metin, $_uploadFolder;
    $sonuc = "";
    $humanRelativeDate = new HumanRelativeDate();
    if (!empty($userID)) {
        $kisiAdi = getUserName($userID);
        $kisiFiltre2 = " WHERE eo_shoutbox.name = '{$kisiAdi}' ";
        $kisiFiltre = " WHERE eo_users.id = '{$userID}' ";
    } else {
        $kisiFiltre2 = "";
        $kisiFiltre = "";
    }
    switch ($tablo) {
        case "oy":
            $sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_rating\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id  = eo_rating.userID\t\t\t\t\t \r\n\t\t\t\t\t INNER JOIN eo_4konu \r\n\t\t\t\t\t ON eo_4konu.id  = eo_rating.konuID\t\r\n\t\t\t\t\t {$kisiFiltre}\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_rating.rateDate DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    $insansi = $humanRelativeDate->getTextForSQLDate($gelen[4]);
                    if (empty($userID)) {
                        $sonuc .= "<a href='profil.php?kim={$gelen['5']}' rel='facebox'>" . $gelen[6] . "</a>, " . "<a href='dersBilgisi.php?ders={$gelen['14']}' rel='facebox'>" . $gelen[15] . "</a>, " . yildizYap($gelen[3]) . ", " . $insansi . "<br/>";
                    } else {
                        $sonuc .= "<a href='dersBilgisi.php?ders={$gelen['14']}' rel='facebox'>" . $gelen[15] . "</a>, " . yildizYap($gelen[3]) . ", " . $insansi . "<br/>";
                    }
                }
            }
            break;
        case "yorum":
            if (empty($kisiFiltre)) {
                $aramaFiltre = " WHERE active='1' ";
            } else {
                $aramaFiltre = " {$kisiFiltre} and active='1' ";
            }
            $sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_comments\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id  = eo_comments.userID\t\t\t\t\t \r\n\t\t\t\t\t INNER JOIN eo_4konu \r\n\t\t\t\t\t ON eo_4konu.id  = eo_comments.konuID\t\t\t\t\t \r\n\t\t\t\t\t {$aramaFiltre}\r\n\t\t\t\t\t ORDER BY eo_comments.commentDate DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    $insansi = $humanRelativeDate->getTextForSQLDate($gelen[4]);
                    if (empty($userID)) {
                        $sonuc .= "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[7] . "</a>, " . "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . $insansi . "<br/>";
                    } else {
                        $sonuc .= "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . $insansi . "<br/>";
                    }
                }
            }
            break;
        case "sohbet":
            $sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_shoutbox\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.userName  = eo_shoutbox.name\t\t\t\t\t \r\n\t\t\t\t\t {$kisiFiltre2}\r\n\t\t\t\t\t ORDER BY eo_shoutbox.date DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    $insansi = $humanRelativeDate->getTextForSQLDate($gelen[5]);
                    if (empty($userID)) {
                        $sonuc .= "<a href='profil.php?kim={$gelen['6']}' rel='facebox'>" . $gelen[1] . "</a>, " . smileAdd(smartShort($gelen[3])) . ", " . odaGetir($gelen[4]) . ", " . $insansi . "<br/>";
                    } else {
                        $sonuc .= smileAdd(smartShort($gelen[3])) . ", " . odaGetir($gelen[4]) . ", " . $insansi . "<br/>";
                    }
                }
            }
            break;
        case "uye":
            $sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_users\r\n\t\t\t\t\t ORDER BY requestDate DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    $insansi = $humanRelativeDate->getTextForSQLDate($gelen[7]);
                    $sonuc .= "<a href='profil.php?kim={$gelen['0']}' rel='facebox'>" . $gelen[1] . "</a>, <span style='text-transform: capitalize;'>" . strtolower($gelen[3]) . "</span>, " . $insansi . "<br/>";
                }
            }
            break;
        case "ders":
            $sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_userworks\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id  = eo_userworks.userID\t\t\t\t\t \r\n\t\t\t\t\t INNER JOIN eo_4konu \r\n\t\t\t\t\t ON eo_4konu.id  = eo_userworks.konuID\t\r\n\t\t\t\t\t {$kisiFiltre}\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_userworks.calismaTarihi DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    $insansi = $humanRelativeDate->getTextForSQLDate($gelen[5]);
                    if (empty($userID)) {
                        $sonuc .= "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[7] . "</a>, " . "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . Sec2Time2($gelen[3]) . ", " . $gelen[4] . ", " . $insansi . "<br/>";
                    } else {
                        $sonuc .= "<a href='dersBilgisi.php?ders={$gelen['2']}' rel='facebox'>" . $gelen[16] . "</a>, " . Sec2Time2($gelen[3]) . ", " . $gelen[4] . ", " . $insansi . "<br/>";
                    }
                }
            }
            break;
        case "soru":
            $sql1 = "SELECT *,\r\n\t\t\t             (select count(id) from eo_askanswer where soruID=eo_askquestion.id) as say \r\n\t\t\t\t\t FROM eo_askquestion\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id  = eo_askquestion.userID\t\t\t\t\t \r\n\t\t\t\t\t {$kisiFiltre}\t\t\t\t \r\n\t\t\t\t\t ORDER BY eo_askquestion.eklenmeTarihi DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    $insansi = $humanRelativeDate->getTextForSQLDate($gelen[3]);
                    if (empty($userID)) {
                        $sonuc .= "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[7] . "</a>, " . "<a href='readAnswer.php?oku={$gelen['0']}' rel=\"shadowbox;height=400;width=800\" title='Cevap Oku'>" . smartShort($gelen['question'], 30) . "</a>, " . $gelen["say"] . ", " . $insansi . "<br/>";
                    } else {
                        $sonuc .= "<a href='readAnswer.php?oku={$gelen['0']}' rel=\"shadowbox;height=400;width=800\" title='Cevap Oku'>" . smartShort($gelen['question'], 30) . "</a>, " . $gelen["say"] . ", " . $insansi . "<br/>";
                    }
                }
            }
            break;
        case "dosya":
            $sql1 = "SELECT * \r\n\t\t\t\t\t FROM eo_files\r\n\t\t\t\t\t INNER JOIN eo_users \r\n\t\t\t\t\t ON eo_users.id  = eo_files.userID\t\t\t\t\t \r\n\t\t\t\t\t {$kisiFiltre}\r\n\t\t\t\t\t ORDER BY eo_files.id DESC limit 0," . ayarGetir("ayar2int");
            $result1 = mysql_query($sql1, $yol1);
            if ($result1 && @mysql_num_rows($result1) >= 1) {
                while ($gelen = @mysql_fetch_array($result1)) {
                    if (file_exists($_uploadFolder . "/" . $gelen[2])) {
                        $insansi = $humanRelativeDate->getTextForSQLDate(date("Y-m-d H:i:s", filemtime($_uploadFolder . "/" . $gelen[2])));
                        if (empty($userID)) {
                            $sonuc .= "<a href='profil.php?kim={$gelen['1']}' rel='facebox'>" . $gelen[5] . "</a>, " . "<a href='fileDownload.php?id={$gelen['0']}&file={$gelen['2']}'>" . $gelen[2] . "</a>, " . $gelen[3] . ", " . $insansi . "<br/>";
                        } else {
                            $sonuc .= "<a href='fileDownload.php?id={$gelen['0']}&file={$gelen['2']}'>" . $gelen[2] . "</a>, " . $gelen[3] . ", " . $insansi . "<br/>";
                        }
                    }
                }
            }
            break;
    }
    return $sonuc;
}
Example #6
0
                ?>
',<?php 
                echo $satir['id'];
                ?>
,'<?php 
                echo $metin[104];
                ?>
');"><img src="img/cross.png" alt="delete" width="16" height="16" border="0" style="vertical-align: middle;"  title="<?php 
                echo $metin[102];
                ?>
"/></a>&nbsp;
                        <?php 
            }
            ?>
                        <?php 
            echo "<a href='readAnswer.php?oku=" . $satir['id'] . "'  rel=\"shadowbox;height=400;width=800\" title='{$metin['649']}'>" . smartShort($satir['question'], 30) . "</a> " . cevapSayisiGetir($satir['id']) . "";
            ?>
</td>
                      <td <?php 
            echo "style=\"background-color: {$row_color};\"";
            ?>
><?php 
            echo dersAdiGetir($satir['dersID']) == "" ? "<font class=bosVeri title='Kay&#305;t yok veya bir hata meydana geldi!'>###</font>" : dersAdiGetir($satir['dersID']);
            ?>
</td>
                      <td <?php 
            echo "style=\"background-color: {$row_color};\"";
            ?>
><?php 
            echo $insansi;
            ?>