Merhabalar,
QPersonelde Üstteki Yolu Gizlemek İstiyorum.Şu ev resminin falan olduğu yolu gizlemek istiyorum. Mümkünmüdür, nasıl yapabilirim bunu?

image.JPG

[Hasan]

personel.php dosyasındaki

Kod: Tümünü seç

<a href="<?php echo sefRelToAbs($blink) ?>">
    <img src="<?php echo $mosConfig_live_site."/components/".$com_bilesen; ?>/images/anasayfa.gif" hspace="6" border="0" align="left" alt="Q-Personel bir Q-Proje yapimidir."/><?php echo _HE_ANASAYFA ?></a>


buresi ve

Kod: Tümünü seç

if ($katid <> "") {
        echo KategoriYolLink($katid);
    } else if ($id) {
        $database->setQuery("SELECT a.*, cc.name AS category "
             . " \nFROM $sql_bilesen AS a, $sql_bilesen_kat AS cc "
             . " \nWHERE a.katid=cc.katid AND a.id=$id "
             . " \n AND cc.erisim<='$gid'");
        $rows = $database->loadObjectList();
        $row = &$rows[0];
        echo KategoriYolLink($row->katid);
    }


burasini silerseniz görünmez.

Tam olarak böyle.

<?php

/*************************************************\
** Q-Personel Bileþeni **
** Copyright (C) 2008 by Q-Proje **
** Quality Joomla Projects Team Members! **
** Hasan ERZI - Umut KOL - Firat GÖKALP **
** Version : 1.0 **
** Homepage : http://www.qproje.com **
** License : GNU GPL Lisans **
\*************************************************/

defined( '_VALID_MOS' ) or die( 'KISITLI ALAN' );
error_reporting(E_ALL ^ E_NOTICE);

global $database, $my, $mosConfig_live_site, $mosConfig_absolute_path;
require_once($mainframe->getPath('front_html'));
require_once($mainframe->getPath('class'));

$katid = intval(mosGetParam($_REQUEST, 'katid', 0));
$id = intval(mosGetParam($_REQUEST, 'id', 0));
$arama_katid = intval(mosGetParam($_REQUEST, 'arama_katid', 0));
$did = intval(mosGetParam($_REQUEST, 'did', 0));
$yrmid = intval(mosGetParam($_REQUEST, 'yrmid', 0));
$yrm_id = intval(mosGetParam($_REQUEST, 'yrm_id', 0));
$yayin_durum = intval(mosGetParam($_REQUEST, 'yayin_durum', 0));
$yayinda = intval(mosGetParam($_REQUEST, 'yayinda', 0));
$oy_derece = intval(mosGetParam($_REQUEST, 'oy_derece', 0));
$baslik = mosGetParam($_REQUEST, 'baslik', '');
$metin = mosGetParam($_REQUEST, 'metin', '');
$gorev = mosGetParam($_REQUEST, 'gorev', '');
$unvan = mosGetParam($_REQUEST, 'unvan', '');
$dtarih = mosGetParam($_REQUEST, 'dtarih', '');
$ogr_durum = mosGetParam($_REQUEST, 'ogr_durum', '');
$eposta = mosGetParam($_REQUEST, 'eposta', '');
$grv_baslangic = mosGetParam($_REQUEST, 'grv_baslangic', '');
$dyeri = mosGetParam($_REQUEST, 'dyeri', '');
$ekleyen = mosGetParam($_REQUEST, 'ekleyen', '');
$etarih = mosGetParam($_REQUEST, 'etarih', null);
$mresim = mosGetParam($_REQUEST, 'mresim', '');
$resim = $_FILES['resim']['tmp_name'];
$resim_name = $_FILES['resim']['name'];
$yayinda = mosGetParam($_REQUEST, 'yayinda', '');
$kontrol_etti = mosGetParam($_REQUEST, 'kontrol_etti', '');
$kontrol_zamani = mosGetParam($_REQUEST, 'kontrol_zamani', '');
$y_adi = mosGetParam($_REQUEST, 'y_adi');
$y_yorum = mosGetParam($_REQUEST, 'y_yorum', null);
$kpdetay = mosGetParam($_REQUEST, 'kpdetay', null);
$aranan_kelime = mosGetParam($_REQUEST, 'aranan_kelime', null);
$personel_sira = mosGetParam($_REQUEST, 'personel_sira', null);


$moderator = (strtolower($my->usertype) == 'editor' || strtolower($my->uertype) == 'administrator' || strtolower($my->usertype) == 'super administrator');

$blink = "index.php?option=".$com_bilesen;
$ek_link = "index.php?option=com_comprofiler&task=userProfile&user=";
$siralama_linki = "index.php?option=".$com_bilesen."&amp;task=sirala&amp;personel_sira=";
$dizin = $mosConfig_live_site . "/components/" . $com_bilesen;
$inc_ayarlar = $mosConfig_absolute_path . "/administrator/components/" . $com_bilesen . "/ayar.".$analink.".php";


// Dil dosyasini kontrol et - check language file
if (file_exists($mosConfig_absolute_path . '/components/' . $com_bilesen . '/languages/' . $mosConfig_lang . '.php')) {
include ($mosConfig_absolute_path . '/components/' . $com_bilesen . '/languages/' . $mosConfig_lang . '.php');
} else {
include ($mosConfig_absolute_path . '/components/' . $com_bilesen . '/languages/turkish.php');
}
require_once($inc_ayarlar);


$database->setQuery("SELECT a.*, c.isim AS kategori"
. "\n FROM $sql_bilesen AS a "
. "\n left join $sql_bilesen_kat as c on c.katid=a.katid "
. "\n WHERE a.yayinda = 1");
$katbas = $database->loadobjectList();

$mainframe->setPageTitle (_HE_BILESEN . ' -:- ' . $katbas[0]->kategori);



switch ($task) {

case 'ekle':
BilesenBaslik();
Ekle(0, $option);
break;

case 'detay':
BilesenBaslik();
include('components/'.$com_bilesen.'/detaylar.php');
break;

case 'kaydet':
Kaydet($option, $id, $mresim, $resim, $resim_name);
break;

case 'sil':
require_once($inc_ayarlar);
if (!$my->username) {
mosRedirect(sefRelToAbs("$blink", _HE_GIRISYAP));
die();
}
Sil($option, $id);
break;

case 'duzenle':
require_once($inc_ayarlar);
if (!$my->username) {
mosRedirect(sefRelToAbs("$blink", _HE_GIRISYAP));
die();
}
BilesenBaslik();
Yeni($id);
break;

case 'yayinkont':
require_once($inc_ayarlar);
if (!$moderator) {
mosRedirect(sefRelToAbs("$blink", _HE_UYARYETKIYOK));
die();
}
BilesenBaslik();
YayinKontrol($id, $katid, $yayin_durum, $option, $blink);
break;

// Kategori Detayi - Category Details

case 'qpListele':
BilesenBaslik();
PListele($option, $katid);
break;

// Harfe Göre Siralama Yap
case 'sirala':
BilesenBaslik();
HarfSirala($option, $personel_sira);
break;


// ARAMA - SEARCH
case 'arama':
BilesenBaslik();
AramaYap($option, $aranan_kelime, $arama_katid);
break;

case 'yorumla':
Yorum_Ekle ($option, $did, $y_id, $y_yorum, $y_adi, $katid);
break;

case 'yorumsil':
BilesenBaslik();
global $blink, $dizin, $id, $katid;
$submit = trim(mosGetParam($_POST, 'submit', ''));
if (@$_REQUEST['moderator']) {
print "<script>document.location.href='../../index.php'</script>\n";
exit();
}
if ($moderator) {
if ($submit) {
$database->setQuery("DELETE FROM $sql_bilesen_yorumlar WHERE id = '$yrm_id'");
$database->query();
echo "<script>alert('" . _HE_YRM_UYARSILINDI . "'); document.location.href='" . sefRelToAbs("$blink&task=detay&id=$id&katid=$katid") . "';</script>";
} else {
echo '<br />';
echo '<table width="100%" border="0" cellspacing="1" cellpadding="4">';
echo '<tr>';
echo '<td class="sectiontableheader" width="10%" >' . _HE_YRM_YAZAR . '</td>';
echo '<td class="sectiontableheader" >' . _HE_YRM_MSJ . '</td>';
echo '</tr>';
$database->setQuery("SELECT id, did, y_ip, y_id, y_adi, y_yrm , y_tarih FROM $sql_bilesen_yorumlar WHERE id = '$yrmid'");
$result1 = $database->query();
list($id, $did, $y_ip, $y_id, $y_adi, $y_yrm, $y_tarih) = mysql_fetch_row($result1);
echo '<tr class="sectiontableentry1">';
echo '<td valign="top" ><div align="center" style="border:#ccc 1px dotted;"><strong>';
echo $y_adi;
echo '<br />';
echo '</strong>';

if ($qp_cbetkin) {
$link = sefRelToAbs(ek_link . $y_id);
} else {
$link = "#";
}

$user_avatar_path = 'images/comprofiler';

$query = "SELECT DISTINCT avatar FROM #__comprofiler WHERE user_id = '$y_id'";
$database->setQuery($query);
$avatar = $database->loadResult();

if ($avatar != "" and file_exists($user_avatar_path . "/tn" . $avatar)) {
echo "<a href = '$link'><img src=$user_avatar_path/tn" . $avatar . " /></a>";
} else {
$cb_trizin = "components/com_comprofiler/images/turkish/nophoto.jpg";
$cb_engizin = "components/com_comprofiler/images/english/nophoto.jpg";
$resimyok = $dizin."/images/resimyok.jpg";
$link = sefRelToAbs($orj_link . $y_id);
$ds_kontr = file_exists ($cb_trizin);
$ds_konteng = file_exists ($cb_engizin);
if ($ds_kontr) {
echo '<a href ="' . $link . '"><img src="' . $cb_trizin . '" style="border: #ccc 1px solid;" /></a>';
} else if ($ds_konteng) {
echo '<a href ="' . $link . '"><img src="' . $cb_engizin . '" style="border: #ccc 1px solid;" /></a>';
} else {
echo '<a href ="' . $link . '"><img src="' . $resimyok . '" style="border: #ccc 1px solid;" /></a>';
}
}

echo "<br>" . _HE_IP . ':' . $y_ip;
echo '</div></td>';
$ektarih = strftime("%c", $y_tarih);
$yorumlar = $y_yrm;
echo '<td valign="top"><span class="small">' . _HE_TARIH . ':' . $ektarih;
echo '<hr>';
echo '</span>';
echo $yorumlar;
echo '</td>';
echo '</tr>';
echo '<tr class="sectiontableentry2">';
echo '<td valign="top"><form method="post" action="' . sefRelToAbs($blink . '&task=yorumsil&yrm_id=' . $id . '&id=' . $id) . '">';
echo '<input class="button" type="submit" name="submit" value="' . _HE_BUTON_SIL . '">';
echo '</form>';
echo '</td>';
echo '<td valign="top">&nbsp;</td>';
echo '</tr>';
echo '</table>';
}
} else {
echo "<p><a href='" . sefRelToAbs("$blink") . "'>" . _HE_BUTON_GERIDON . "</a>";
}
break;

default:
require_once($inc_ayarlar);
BilesenBaslik();

// ################# Bilesen Anasayfa - Component Home Page #################
?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="<? echo $qp_katsutun; ?>" class="sectiontableheader" width="100%"><?php echo _HE_KATEGORILER; ?></td>

<?php
$query1 = "SELECT * FROM $sql_bilesen_kat WHERE yayinda = 1 and ustkat = 0 and erisim <= $my->gid order by ordering ASC";
$database->setQuery($query1);
$rows = $database->loadObjectList();
$cizgi = 1;
?>

</tr>
<tr>
<?php
$sutunlar = 0;
foreach ($rows as $row1) {
if (($sutunlar % $qp_katsutun == 0) AND ($sutunlar <> 0))
echo "</tr>\n<tr>\n";
?>
<td style="padding:10px;" width="50%" align="left" valign="top">
<div align="left">
<a href="<?php echo sefRelToAbs($blink . '&task=qpListele&katid=' . $row1->katid); ?>">
<b><?php echo $row1->isim;?> </b></a><font size="-7">( <?php echo LinkleriNumarala($row1->katid) ." ". _HE_ADET; ?> )</font>
<br />
</div>
<?php if (@$row1->katresim <> "") { ?>
<a href="<?php echo sefRelToAbs("$blink&task=qpListele&katid=$row1->katid"); ?>">
<img src="images/stories/<?php echo $row1->katresim; ?>" width="120" vspace="5" hspace="3" style="border: #ccc 1px solid; padding:3px;" /><br /></a
><?php
}

echo $row1->aciklama;

$database->setQuery("SELECT count(id) FROM $sql_bilesen WHERE yayinda = 1 AND katid = '" . $row1->katid . "'" . "");
$count = $database->loadResult();

echo '</td>';
$sutunlar++;
}
?>

</tr>
</table>
<br>
<?
break;
}


// Bilesen Üst ve Alt Kisimlar - Component Header and Footer

function BilesenAlt ()
{
global $mosConfig_absolute_path, $yapim, $yapimci;
if ($yapimci) {
echo "<br><div align='right'>".$yapim."</div>";
}

return;
}

function BilesenBaslik ()
{
global $database, $my, $gid, $acl, $katid, $yapimci, $blink, $com_bilesen, $sql_bilesen, $sql_bilesen_kat, $dizin, $moderator, $qp_gid, $qp_aramakut, $qp_harfler, $qp_harfcikar, $siralama_linki, $mosConfig_live_site;

?>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" class="componentheading"><?php echo _HE_BILESEN ?></td>
</tr>
<tr align="left">
<td rowspan="2" align="left" valign="top">


<?php

$query = "SELECT a.*, g.name AS grup_adi, g.group_id as grup_id"
. "\n FROM #__users AS a"
. "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id" // map user to aro
. "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id" // map aro to group
. "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = gm.group_id"
. "\n WHERE a.id = '$my->id'"
. "\n GROUP BY a.id" ;
$database->setQuery($query);
$gruplar = $database->loadObjectList();


$Listele["kategoriler"] = AcKapaKategoriListesi("$row->ustkat", "arama_katid");



?> </td>
</tr>
<tr align="left">
<td align="right">
<?
if ($gruplar[0]->grup_id >= $qp_gid or $qp_gid == 29) { ?>
<input type = "button" name = "Button" value="<?php echo _HE_BUTON_EKLE ?>" onclick ="javascript:location.href='<?php echo sefRelToAbs("$blink&task=ekle") ?>';" class="button"> <? } ?>
<?php if ($qp_aramakut) { ?>
<form action="index.php" name="aramaformu" target="_top" method="post">
<input type="hidden" name="task" value="arama" />
<input type="hidden" name="option" value="<? echo $com_bilesen ?>" />
<input type="text" name="aranan_kelime" style="background:url(<?php echo $dizin ?>/images/arama.png); background-position:right; background-repeat:no-repeat;" class="inputbox" onblur="if(this.value=='') this.value='';" onfocus="if(this.value=='<?php echo _HE_BUTON_ARAMA ?>') this.value='';" value="<?php echo _HE_BUTON_ARAMA ?>" title="<?php echo _HE_BUTON_ARAMA ?>" />

<?php echo $Listele["kategoriler"]; ?>
<input name="git" class="button" type="submit" value="<?php echo _HE_BUTON_ARA ?>" />
</form>
<?php } ?>
</td>
</tr>
<tr>
<td colspan="2">
<?php

if ($qp_harfcikar) {

echo '<div id="qp_harfler">';


echo '<div class="small" align="center" style=" padding:5px; border-bottom:1px solid;">' . _HE_ON_HARFEGORELISTELE;
echo '<b> &raquo; [ ';

if ($qp_harfler) $tum_harfler = split(",", $qp_harfler);

foreach ($tum_harfler as $deger) {
echo ' <a href="' . sefRelToAbs($siralama_linki.$deger).'" title="';
printf(_HE_ON_HARFLISTELEPERS, $deger);
echo '">' . $deger . '</a>';
echo $harf_listesi;
}
echo ' ] &laquo;</b> </div>';


echo '</div>';

}
?>


</td>
</tr>
<tr>
<td colspan="2">
<?
return;
}

?>

</td></tr><tr><td colspan="2"><? BilesenAlt(); ?></td></tr></table>

<?

// LISTELE - LIST
function PListele($option, $katid)
{
global $database, $my, $mainframe, $mosConfig_list_limit, $mosConfig_absolute_path, $com_bilesen, $sql_bilesen, $sql_bilesen_kat, $inc_ayarlar;

$limit = trim(mosGetParam($_REQUEST, 'limit', 30));
$limitstart = trim(mosGetParam($_REQUEST, 'limitstart', 0));

$database->setQuery("SELECT count(id) FROM $sql_bilesen as a "
. "\n left join $sql_bilesen_kat as c on c.katid=a.katid "
. "\n WHERE a.yayinda = 1 "
. "\n AND a.katid = '$katid'"
. "\n AND c.erisim<='$gid' ");
$toplam = $database->loadResult();

require_once("includes/pageNavigation.php");
$SayfaIsl = new mosPageNav($toplam, $limitstart, $limit);


$database->setQuery("SELECT count(katid) FROM $sql_bilesen_kat"
. "\n WHERE katid = '" . $katid . "'"
. "\n AND erisim<='$gid'");
$veri_kontrol = $database->loadResult();

if ($veri_kontrol < 1) {
echo "<script>alert("._HE_UYARYETKIYOK."); document.location.href='" . sefRelToAbs("$blink") . "';</script>";
die();
}

$database->setQuery("SELECT isim FROM $sql_bilesen_kat WHERE katid = '$katid' ORDER BY isim");
$katadi = $database->loadResult();


$database->setQuery("SELECT * FROM $sql_bilesen as a "
. "\n left join $sql_bilesen_kat as c on c.katid=a.katid "
. "\n WHERE a.yayinda=1 AND a.katid = '$katid' "
. "\n AND c.erisim<='$gid' "
. "\n ORDER BY a.id $qp_sirala"
. "\n limit $limitstart, $limit");
$rows = $database->loadObjectList();

HTML_bilesen::PListele($option , $rows, $SayfaIsl, $toplam, $klistele);

}

// Harf Siralamasi

function HarfSirala($option, $personel_sira)
{
global $database, $my, $gid, $mainframe, $mosConfig_list_limit, $mosConfig_absolute_path, $com_bilesen, $sql_bilesen, $sql_bilesen_kat, $inc_ayarlar;

$limit = trim(mosGetParam($_REQUEST, 'limit', 30));
$limitstart = trim(mosGetParam($_REQUEST, 'limitstart', 0));
$database->setQuery("SELECT count(id) FROM $sql_bilesen as a "
. "\n WHERE a.baslik regexp '^$personel_sira'"
. "\n AND a.yayinda=1");
$toplam = $database->loadResult();

require_once("includes/pageNavigation.php");
$SayfaIslem = new mosPageNav($toplam, $limitstart, $limit);


$query = "SELECT a.*, k.isim AS kategori, s.name AS ekleyen"
. "\n FROM $sql_bilesen AS a"
. "\n LEFT JOIN $sql_bilesen_kat AS k ON k.katid=a.katid"
. "\n LEFT JOIN #__users AS s ON s.id=a.ekleyen"
. "\n WHERE a.baslik REGEXP ('^".$personel_sira."')"
. "\n AND a.yayinda=1 AND k.erisim<='$gid'"
. "\n Order by a.baslik $qp_sirala LIMIT $limitstart, $limit";
$database->setQuery($query);
$rows = $database->loadObjectList();

HTML_bilesen::HarfSirala($option , $rows, $SayfaIslem, $toplam);

}


// Arama Fonksiyonu

function AramaYap($option, $aranan_kelime, $arama_katid) {
global $database, $gid, $mainframe, $mosConfig_list_limit, $mosConfig_absolute_path, $com_bilesen, $sql_bilesen, $sql_bilesen_kat, $inc_ayarlar;


$aranan_kelime = trim(strtolower($aranan_kelime));
$surda = array();

if ($aranan_kelime) {
if($arama_katid<>0) {
$surda[] = "(LOWER(a.baslik) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%' OR LOWER(a.unvan) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%' OR LOWER(a.gorev) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%' OR LOWER(a.metin) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%') and a.katid='$arama_katid'";
}
else {
$surda[] = "LOWER(a.baslik) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%' OR LOWER(a.unvan) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%' OR LOWER(a.gorev) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%' OR LOWER(a.metin) LIKE '%" . $database->getEscaped(trim(strtolower($aranan_kelime))) . "%'";
}
}

$limit = trim(mosGetParam($_REQUEST, 'limit', 30));
$limitstart = trim(mosGetParam($_REQUEST, 'limitstart', 0));

$database->setQuery("SELECT count(*) FROM $sql_bilesen as a "
. "\n LEFT JOIN $sql_bilesen_kat as c ON c.katid=a.katid "
. (count($surda) ? "\n WHERE a.yayinda =1 AND " . implode(' AND ', $surda) :"")
. "\n AND c.erisim<='$gid' ");
$toplam = $database->loadResult();

require_once("includes/pageNavigation.php");
$SayfaIslem = new mosPageNav($toplam, $limitstart, $limit);
// toplam kayit bul - find total items


$query = "SELECT a.*, cc.isim AS kategori, s.name AS ekleyen_kisi "
. "\n FROM $sql_bilesen AS a"
. "\n LEFT JOIN $sql_bilesen_kat AS cc ON cc.katid = a.katid"
. "\n LEFT JOIN #__users AS s ON s.id = a.ekleyen"
. (count($surda) ? "\n WHERE a.yayinda=1 AND " . implode(' AND ', $surda) :"")
. "\n ORDER BY a.katid LIMIT $limitstart , $limit";
$database->setQuery($query);
$rows = $database->loadObjectList();

HTML_bilesen::AramaListesi($option , $rows, $SayfaIslem, $toplam);


}

// Ekleme Islemi - Adding Function
function Ekle($uid = 0)
{
global $database, $my, $mosConfig_absolute_path, $mainframe, $sql_bilesen;

if ($uid) {
$row->checkout($my->id);
$query = "SELECT id"
. "\n FROM $sql_bilesen"
. "\n WHERE id = " . (int) $uid
. "\n ORDER BY id" ;
$database->setQuery($query);
$options = $database->loadObjectList();
} else {
$row->yayinda = 1;
}

$query = "SELECT a.*, g.name AS grup_adi, g.group_id as grup_id"
. "\n FROM #__users AS a"
. "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id" // map user to aro
. "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id" // map aro to group
. "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = gm.group_id"
. "\n WHERE a.id = '$my->id'"
. "\n GROUP BY a.id" ;
$database->setQuery($query);
$gruplar = $database->loadObjectList();

// Evet Hayir Seçim Listesi - YES NO SELECT BOX
$evethayir[] = mosHTML::makeOption('1', _HE_EVET);
$evethayir[] = mosHTML::makeOption('0', _HE_HAYIR);

// listeden yayinlama durumunu gözet
$Listeler["yayinlama"] = mosHTML::selectList($evethayir, 'yayinda', 'class="inputbox" size="1"', 'value', 'text', $row->yayinda);

$klistele = AcKapaKategoriListesi($row->katid , 'katid', 'size="1"');


HTML_bilesen::Duzenle(&$row, &$options, &$klistele, &$gruplar, &$Listeler);
}




// Yorum Ekle - Adding Comment
function Yorum_Ekle($option, $did, $y_id, $y_yorum, $y_adi, $katid)
{
global $database, $mosConfig_absolute_path, $my, $inc_ayarlar, $sql_bilesen_yorumlar;
require_once($inc_ayarlar);

$y_ip = getenv('REMOTE_ADDR');
$y_tarih = time();

$y_yorum = strip_tags($y_yorum);
$y_id = strip_tags($y_id);

$did = mysql_escape_string($did);
$y_adi = mysql_escape_string($y_adi);
$y_yorum = mysql_escape_string($y_yorum);
// Yorumlari ekle - Add Comment
$query = "INSERT INTO $sql_bilesen_yorumlar SET did='$did', y_ip ='$y_ip', y_id = '$y_id', y_adi ='$y_adi', y_yrm='$y_yorum', y_tarih='$y_tarih', yayinda='$qp_yotoyayin' ";
$database->setQuery($query);
$database->query();

$yonlendir = "index.php?option=" . $option . "&task=detay&id=" . $did . "&katid=" . $katid;

if ($qp_yotoyayin) {

mosRedirect(sefRelToAbs($yonlendir), _HE_YRM_YORUMKAYDET);
} else {
mosRedirect(sefRelToAbs($yonlendir), _HE_YRM_YORUMASKIDA);
}
}



function Yeni($id) {
global $database, $my, $acl, $mosConfig_absolute_path, $com_bilesen;

$row = new bilesen_sorgu($database);
$row->load((int)$id);

$options = array();

if ($id) {
$row->checkout($my->id);
$query = "SELECT id, baslik"
. "\n $sql_bilesen"
. "\n WHERE id = " . (int) $id
. "\n ORDER BY id" ;
$database->setQuery($query);
$options = $database->loadObjectList();
} else {
$row->yayinda = 1;
}
$query = "SELECT a.*, g.name AS grup_adi, g.group_id as grup_id"
. "\n FROM #__users AS a"
. "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id" // map user to aro
. "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id" // map aro to group
. "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = gm.group_id"
. "\n WHERE a.id = '$my->id'"
. "\n GROUP BY a.id" ;
$database->setQuery($query);
$gruplar = $database->loadObjectList();

// Evet Hayir Seçim Listesi - YES NO SELECT BOX
$evethayir[] = mosHTML::makeOption('1', _HE_EVET);
$evethayir[] = mosHTML::makeOption('0', _HE_HAYIR);

// listeden yayinlama durumunu gözet
$Listeler["yayinlama"] = mosHTML::selectList($evethayir, 'yayinda', 'class="inputbox" size="1"', 'value', 'text', $row->yayinda);
$klistele = AcKapaKategoriListesi($row->katid , 'katid', 'size="1"');

HTML_bilesen::Duzenle($row, $options, $klistele, $gruplar, $Listeler);
}




// KAYIT SORGUSU - QUERY
function Kaydet($option, $id, $mresim, $resim, $resim_name)
{
global $database, $my, $analink, $mosConfig_absolute_path, $blink, $moderator, $com_bilesen, $qp_otoyayinla, $qp_kresim, $qp_kresim, $qp_oresim,$qp_orjgen, $qp_orjuzun, $qp_reskalite, $qp_cetvel;

require_once($mosConfig_absolute_path . "/administrator/components/".$com_bilesen."/ayar.".$analink.".php");
require_once($mosConfig_absolute_path . "/administrator/components/".$com_bilesen."/islemler.php");

// Resim Silme Islemi -> Eger yeni resim yüklenirse bi önceki resmi kaldir.
$mevcut_dosya = $mosConfig_absolute_path . $qp_kresim ."/kck_". $mresim;

if ($resim) {
if (file_exists($mevcut_dosya)) {

if (removeFile("kck_" . $mresim, $mosConfig_absolute_path . $qp_kresim)) {
if (!removeFile($mresim, $mosConfig_absolute_path . $qp_oresim)) {
die(_KB_SILINEMIYOR);
}
} else {
die(_KB_KCKSILINEMIYOR);
}
} else {
echo "<script> alert('" . $database->getErrorMsg() . "'); window.history.go(-1); </script>\n";
}
}


// Resim Silme Islemi Sonu
// Resim iþleme
if ($resim) {
mt_srand ((double) microtime() * 1000000);
$resimnumara = mt_rand(0, 100000000);
$ilave = strtolower(substr(strrchr($resim_name, '.'), 1));
$resim_name = $resimnumara . '.' . $ilave;

if (strlen($resim) > 0 and $resim != "") {
$rsm_bilgi = getimagesize($resim);
if ($rsm_bilgi[0] > $qp_orjgen or $rsm_bilgi[1] > $qp_orjuzun) {
resize_image($resim, $mosConfig_absolute_path . $qp_oresim . "/$resim_name", "$qp_orjgen", "$qp_reskalite");
} else {
copy($resim, $mosConfig_absolute_path . $qp_oresim . "/$resim_name");
}
}
if ($resim) {
if ($qp_cetvel == "kirp") {
tHEmb($resim, $mosConfig_absolute_path . $qp_kresim . "/kck_$resim_name", $qp_orjuzun, $qp_kckuzun, $qp_reskalite);
} else {
resize_image($resim, $mosConfig_absolute_path . $qp_kresim . "/kck_$resim_name", "$qp_orjuzun", "$qp_reskalite");
}
}
}
// Resim Ýþleme Sonu
$row = new bilesen_sorgu ($database);
if (!$row->bind($_POST)) {
echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n";
exit();
}
$kYeni = ($row->id == 0);


// Editör Kontrol
if ($qp_editor == "editor_joomla"){
if (get_magic_quotes_gpc()) {
if (ini_get('magic_quotes_sybase')) {
$metin = str_replace("''", "'", $_POST['metin']);
} else {
$metin = stripslashes($_POST['metin']);
}
}
} else {

$metin = strip_tags($_POST['metin'], $qp_html_izin);
$metin = mysql_escape_string($metin);
$metin = str_replace('\r\n', '<br />', $metin);
$metin;
}

if ($moderator) {
$row->yayinda = 1;
}else {
$row->yayinda = $qp_otoyayinla;
}
$row->tarih = mktime();
if ($resim =="") {
$row->resim = $mresim;
} else {
$row->resim = $resim_name;
}

if (!$row->check()) {
echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n";
exit();
}

if (!$row->store()) {
echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n";
exit();
}

if ($row->yayinda) {
$msj_sonuc = _HE_UYARYAYINDA;
} else {
$msj_sonuc = _HE_UYARASKIDA;
}

if ($moderator) {
mosRedirect(sefRelToAbs("$blink&task=detay&id=$row->id&katid=$row->katid"), $msj_sonuc);
} else {
mosRedirect(sefRelToAbs("$blink&task=katid=$row->katid"), $msj_sonuc);
}
}


function removeFile($srcFilename, $srcFilePath)
{
$removeFilename = $srcFilePath . '/' . $srcFilename;
if (unlink($removeFilename)) {
return true;
} else {
return false;
}
}





function Sil ($option, $id)
{
global $database, $my, $mosConfig_absolute_path, $blink, $moderator, $sql_bilesen, $sql_bilesen, $sql_bilesen_yorumlar;

$database->setQuery("select ekleyen from $sql_bilesen where id=" . intval($id));
$ekleyen_kisi = $database->loadResult();

if (!$moderator) {
mosRedirect(sefRelToAbs("$blink"), _HU_UYARSILINMEDI);
die();
}

if ($id) {
$database->setQuery("DELETE FROM $sql_bilesen_yorumlar WHERE did=$id");

if (!$database->query()) {
echo "<script> alert('" . $database->getErrorMsg() . "'); window.history.go(-1); </script>\n";
}

$database->setQuery("DELETE FROM $sql_bilesen WHERE id=$id");

if (!$database->query()) {
echo "<script> alert('" . $database->getErrorMsg() . "'); window.history.go(-1); </script>\n";
}
} else {
die("Silme islemi basarisiz!");
}
echo "<script>alert('" . _HE_UYARSILINDI . "'); document.location.href='" . sefRelToAbs("$blink") . "';</script>";
}

function YayinKontrol($id, $katid, $yayin_durum, $option, $blink)
{
global $database, $my, $blink, $sql_bilesen;

if (!$yayin_durum) {
$yayinlama = "1";
$msj = _HE_YAYINAL;
} else {
$yayinlama = "0";
$msj = _HE_YAYINKALDIR;
}

$query = "UPDATE $sql_bilesen SET yayinda='$yayinlama' where id = '$id' ";
$database->setQuery($query);
$database->query();

mosRedirect(sefRelToAbs("$blink&task=qpListele&katid=$katid"), $msj);
}



// Alt Kategorileri Çikar - Sub Category
function AltKategoriler ($katid)
{
global $database, $task, $gid, $blink, $sql_bilesen_kat;

$database->setQuery("SELECT d.* "
. " \n FROM $sql_bilesen_kat AS d "
. " \n WHERE d.ustkat=$katid and d.yayinda=1 and erisim<='" . $gid . "'"
. " \n ORDER BY d.ordering DESC ");
$rows = $database->loadObjectList();
$num_rows = ceil(count($rows) / 3);
$index = 0;
$cikti = '<table cellspacing="1" cellpadding="4" border="0" width="100%" class="dizinler">';
if (!$num_rows) {
$cikti .= '<tr><td></td></tr>';
} else {
$cikti .= '<tr>';
$cikti .= '<td align="left" colspan="3" class="sectiontableheader">';
$cikti .= _HE_KATEGORIALT;
$cikti .= '</td>';
$cikti .= '</tr>';
}
for ($row_count = 0; $row_count < $num_rows; $row_count++) {
$cikti .= '<tr>';
for ($col_count = 0; $col_count < 3; $col_count++) {
$cikti .= '<td width="' . floor(100 / 3) . '%" class="sectiontableentry1" height="100" valign="top">';
$qp_ad = @$rows[$index];

if (trim($qp_ad->isim)) {
$cikti .= '&raquo;&nbsp;<a href="' . sefRelToAbs("$blink&task=qpListele&katid=$qp_ad->katid") . '">' . $qp_ad->isim . ' (' . LinkleriNumarala($qp_ad->katid) . ')</a>';
}
if (@$qp_ad->katresim <> "") {
$cikti .= "<a href='" . sefRelToAbs("$blink&task=qpListele&katid=$qp_ad->katid") . "'>";
$cikti .= "<img src='images/stories/$qp_ad->katresim' align='left' width='90' vspace='5' hspace='3' style='border: #ccc 1px solid; padding:3px;' /></a>";
}

$index++;

$cikti .= '<br />' . @$qp_ad->aciklama . '</td>';
}

$cikti .= '</tr>';
}

$cikti .= '</table>';
return $cikti;
}



// ################ ISLEMLER - FUNCTIONS ############
function KategoriYolLink ($kat)
{
global $database, $mosConfig_lang, $gid, $blink, $dizin, $sql_bilesen_kat;
$kat = intval($kat);
$ust_id = 1000;

while ($ust_id) {
$query = "select * from $sql_bilesen_kat where katid=$kat and yayinda=1 \n AND erisim<='" . $gid . "'";

$database->setQuery($query);
$result = $database->query();
$ust_id = @mysql_result($result, 0, 'ustkat');
$katid = @mysql_result($result, 0, 'katid');
$adi = "<a href='" . sefRelToAbs("$blink&task=qpListele&katid=$kat") . "'>" . @mysql_result($result, 0, 'isim') . "</a>";

if (empty($path)) {
$yol = $adi;
} else {
$yol = $adi . ' &raquo; ' . $yol;
}
$kat = $ust_id;
}
$yolAdi = ' &raquo; ' . $yol . " ";
return $yolAdi;
}

function LinkleriNumarala ($kat)
{
global $database, $gid, $blink, $sql_bilesen, $sql_bilesen_kat;
$queue[] = intval($kat);
while (list($key, $kat) = each($queue)) {
$query = "select katid from $sql_bilesen_kat where ustkat=$kat and yayinda=1";

$database->setQuery($query);
$result = $database->query();
$total = mysql_num_rows($result);
$j = 0;

while ($j < $total) {
$val = mysql_fetch_row($result);
$queue[] = $val[0];
$j++;
}
}

reset($queue);
$query = "SELECT count(id) as count FROM $sql_bilesen where ( 0!=0";
while (list($key, $kat) = each($queue)) {
$query .= " or katid = $kat";
}
$query = $query . " ) and yayinda=1";

$database->setQuery($query);
$result = $database->query();
$val = mysql_fetch_row($result);
return $val[0];
}
// AÇ KAPA KATEGORI LISTESINI ÇIKAR - CATEGORY LIST ON OFF
function AcKapaKategoriListesi($kat, $kadi = "kat", $extra = null, $flag = 0)
{
global $database, $sql_bilesen_kat;

$kategori = "<select name=\"$kadi\" class=\"inputbox\" $extra>";
if ($flag == 1) {
$kategori_ekle = true;
}

if (@$kategori_ekle) {
$kategori .= "<OPTION VALUE=0></OPTION>";
} else {
$kategori .= "<OPTION VALUE='0'></OPTION>";
}

$query = "select * from $sql_bilesen_kat"
. "\nORDER BY isim asc";

$database->setQuery($query);
$sonuclar = $database->query();

$num_rows = mysql_num_rows($sonuclar);

$i = 0;
while ($i < $num_rows) {
$kategori_id = mysql_result($sonuclar, $i, 'katid');
$kategori_adi = mysql_result($sonuclar, $i, 'isim' . @$mosConfig_lang);

if ($kategori_id != @$hide) {
@$kategori_listesi .= "<OPTION VALUE='$kategori_id' ";

if ($kategori_id == $kat) {
$kategori_listesi .= " SELECTED";
}

$kategori_listesi .= ">" . KategoriYolu($kategori_id) . "</OPTION>\n";
}
$i++;
}
$kategoriler = explode("\n", $kategori_listesi);
asort($kategoriler);
$kategori .= implode("\n", $kategoriler);

$kategori .= "</select>";

return $kategori;
}
// KATEGORI ISIMLERI - CATEGORY FUNCTIONS
function KategoriYolu($kat)
{
global $database, $sql_bilesen_kat;

$kat = intval($kat);

$ustkat_id = 1000;

while ($ustkat_id) {
$query = "select * from $sql_bilesen_kat where katid=$kat";

$database->setQuery($query);
$result = $database->query();

$ustkat_id = @mysql_result($result, 0, 'ustkat');
$isim = @mysql_result($result, 0, 'isim');
if (empty($yol)) {
$yol = $isim;
} else {
$yol = $isim . ' >> ' . $yol;
}

$kat = $ustkat_id;
}
return $yol . " ";
}

?>

Çok teşekkürler

[Hasan]

rica ederim.