axsaminiz xeyirli olsun demeli bele bir problemle qarsilasmisam mesaj bolmunede deyekki men fuad nicata mesaj yaziramki salam mesaj gedir oda bunu gorur burakimi hersey qaydasindadi memmed mesaj bolmunde nicata daxil olurki mesaj yazsin ve memmed gorurki fuad nicata salam yazib )) bunu nece aradan qaldirim ki memmed gormesin menim nicata yazdigim mesaji??

SQL where clause ile qadaga qurmalisiniz.
Kodlari paylasin z.olmasa baxaq.

GameKing said:

SQL where clause ile qadaga qurmalisiniz.
Kodlari paylasin z.olmasa baxaq.

Genişləndirmək üçün klikləyin...

insallah sabah burda olsaz paylasacam kodlari baxarsiz gozlerim agridi deye sondurdum kampi

Salam. Mesajları where id=? ilə yazdırmalısan id = ? yerinə mesajı kimə göndərmisənsə onun id’sini çəkib yazdırmalısan ki yalnız iki şəxs bir birinin mesajını görsün. Bu qadağanı qoymasan bütün şəxslər bir birinin mesajını görə biləcək

MSRnick said:

Salam. Mesajları where id=? ilə yazdırmalısan id = ? yerinə mesajı kimə göndərmisənsə onun id’sini çəkib yazdırmalısan ki yalnız iki şəxs bir birinin mesajını görsün. Bu qadağanı qoymasan bütün şəxslər bir birinin mesajını görə biləcək

Genişləndirmək üçün klikləyin...

whare ile yazilib ama tapa bilmirem beynim tormuzlayib uje hazir scriptin icinde olan sehvide tapa bilmedim

bu user.php sehifesidi baxin gorun burde neyi duzeltmey lazimdi melumaz ucun deyim xeberiniz olsun billingmaxneoskripti di belke kimse vaxinda istifade edib
<?php
if($_GET['type']=='statatistic'){
if($info['id']==0){
header("location: ".url."");
}
define('title','Hesab statistikas─▒');
@require_once("incfiles/header.php");
$myhosts=$db->query("select count(*) from `bought` where `uid`='".$info['id']."' and `type`='1'")->fetchColumn();
$myresel=$db->query("select count(*) from `bought` where `uid`='".$info['id']."' and `type`='2'")->fetchColumn();
$mydomains=$db->query("select count(*) from `bought` where `uid`='".$info['id']."' and `type`='3'")->fetchColumn();
$imsend=$db->query("select count(*) from `messages` where `send`='".$info['id']."'")->fetchColumn();
$mymail=$db->query("select count(*) from `messages` where `user`='".$info['id']."'")->fetchColumn();
$bloklist=$db->query("select count(*) from `blok` where `kim`='".$info['id']."'")->fetchColumn();
p4m3r4ik('<div class="title">'.title.'</div>
<div class="menu">
<li>Domainlerim: <b>'.$mydomains.'</b></li>
<li>Hostinglerim: <b>'.$myhosts.'</b></li>
<li>Resellerlerim: <b>'.$myresel.'</b></li>
</div>
<div class="title" style="padding:2px;"></div>
<div class="menu">
<li>Gelen mesaj: <b>'.$mymail.'</b></li>
<li>G├╢nderilen mesaj: <b>'.$imsend.'</b></li>
<li>Blok list: <b>'.$bloklist.'</b></li>
<li>Qeydiyyat tarxi: <b>'.data($info['regtime']).'</b></li>
</div>
<div class="menu2"><a href="'.url.'/user=cabinet">&laquo; Kabinet`e geri qayit</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if($_GET['type']=='transfer-money'){
define('title','Pul k├╢c├╝r');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">'.title.'</div>');
if(!empty($_POST['user']) and !empty($_POST['money'])){
$testlog=$db->query("select count(*) from `users` where `login`='".filter($_POST['user'])."'")->fetchColumn();
if($testlog==0){
$error.='* Istifade├зini bazada tap─▒lmad─▒!<br/>';
}
$money=filter($_POST['money']);
if($money<1){
$error.='* Minimum 1 azn k├╢c├╝re bilersiniz!<br/>';
}
if($money>$info['balans']){
$error.='* Balans─▒n─▒zda bu qeder pul yoxdur!<br/>';
}
if(empty($error)){
$minusbalans=$db->exec("update `users` set `balans`=`balans`-".$money." where `id`='".$info['id']."'");
$plusbalans=$db->exec("update `users` set `balans`=`balans`+".$money." where `login`='".$_POST['user']."'");
$infolog=$db->query("select `id` from `users` where `login`='".$_POST['user']."'")->fetch(PDO::FETCH_ASSOC);
$text='Balans─▒n─▒zdan '.$money.' azn ├з─▒x─▒ld─▒ ve '.$_POST['user'].' adl─▒ istifade├зinin hesab─▒na k├╢c├╝r├╝ld├╝!';
$text2='Balans─▒n─▒za '.$money.' azn elave olundu . Balans g├╢nderen: '.$info['login'].' adl─▒ istifade├зi';
$insertop=$db->exec("insert into `operations` set `uid`='".$info['id']."',`time`='".time()."',`text`='".$text."'");
$insertop2=$db->exec("insert into `operations` set `uid`='".$infolog['id']."',`time`='".time()."',`text`='".$text2."'");
p4m3r4ik('<div class="menu">&raquo; '.$text.'</div>');
}else{
p4m3r4ik('<div class="error">'.$error.'</div>');
}
}
p4m3r4ik('<div class="menu"><form method="POST">
Istifade├зi adi:<br/>
<input type="text" name="user" value="'.$_GET['login'].'"/><br/>
Megleb:<br/>
<input type="text" name="money" value="'.$info['balans'].'"/> Azn<br/>
<input type="submit" value="K├╢c├╝r"/></form></div>
');
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=cabinet">&laquo; Kabinet`e geri qayit</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if($_GET['type']=='balans'){
if(isset($_GET['portmanat_account'])){
define('title','Birbank ile balans art─▒r');
@require_once("incfiles/header.php");
echo '<div class="title">'.title.'</div>';

echo "<div class=\"menu\"><form action='https://www.az-hosting.ru' method='text'>
<input type='hidden' name='s_id' value='11773'>
<input type='hidden' name='o_id' value='".$info['id']."'>
<input type='hidden' name='uid' value='".$info['id']."'>
<input type='hidden' name='method' value='account'>
<br>BirBank ile hezabinizi artirmaq ucun (birbank hesabiniza daxil olun)</br> - Kocurmeler - istenilen bank kartina -<br> <b>KART:4169-7385-4420-1548</b></br>
<text>kommentariya bolnune <b> '". $info['login']."' </b> yazmagi unutmayin</text></br>
<big><b><text>DIQQETLI OLUN !!!</text></b></big></br>
<text>Kommentaria yazmadiginiz teqdirde pul balansiniza yuklenmir ve geri qaytarilmir</text>
</form></div>";
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=balans">&laquo; Balans art─▒r</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if(isset($_GET['portmanat_code'])){
define('title','Portmanat kodla balans art─▒r');
@require_once("incfiles/header.php");
echo '<div class="title">'.title.'</div>';

p4m3r4ik('<div class="menu"><form action="https://www.portmanat.az/checkout" method="post">
<input type="hidden" name="s_id" value="11773">
<input type="hidden" name="o_id" value="'.$info['id'].'">
<input type="hidden" name="uid" value="'.$info['id'].'">
<input type="hidden" name="method" value="code">
<input type="submit" value="Portmanat Kodla ├╢d╔Щ">
</form></div>');
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=balans">&laquo; Balans art─▒r</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if(isset($_GET['azercell'])){
$xidmetid=75; // Buraya wapmanatda yaratdiginiz xidmetin idini yazin. mes27)
define('title','Azercell ile balans art─▒r');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">Azercell ile balans art─▒r</div>');
echo "<div class=\"menu\"><form action=\"http://wapmanat.com/wap/index.php?step=kontur\" method=\"post\">
<input type=\"hidden\" name=\"info\" value=\"".$info['id']."\">
<input type=\"hidden\" name=\"xidmetid\" value=\"$xidmetid\">
<input type=\"submit\" value=\"Azercell konturla ├╢deni┼Я et\"/></div>";
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=balans">&laquo; Balans art─▒r</a></div>');
@require_once("incfiles/footer.php");
exit();
}
define('title','Balans art─▒r');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">'.title.'</div>');
# p4m3r4ik('<div class="menu"><a href="'.url.'/user=balans&amp;add_funt=azercell">&raquo; Azercell balans art─▒r (Online)</a></div>');
# p4m3r4ik('<div class="menu"><a href="'.url.'/user=balans&amp;add_funt=portmanat_code">&raquo; Portmanat kodla balans art─▒r (Online)</a></div>');
p4m3r4ik('<div class="menu"><a href="'.url.'/user=balans&amp;add_funt=portmanat_account">&raquo; BirBank (Online)</a></div>');
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=cabinet">&laquo; Kabinet`e geri qayit</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if($_GET['type']=='operations'){
if($info['id']==0){
header("location: ".url."");
}
define('title','Balans emeliyyatlar─▒');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">'.title.'</div>');
$page=(int)$_GET['page'];
if(empty($page)) $page=1;
$limit=5;
$all=$db->query("select count(*) from `operations` where `uid`='".$info['id']."'")->fetchColumn();
$sehife_s=ceil($all/$limit);
if($page > $sehife_s) $page=1;
$goster=$page*$limit-$limit;
if($all!=0){
$view=$db->query("select * from `operations` where `uid`='".$info['id']."' order by `id` desc limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
foreach($view as $v){
$i++;
$pamertext=mysql_escape_string($v['text']);
$pamertext=str_replace('\r\n','<br/>',$pamertext);
p4m3r4ik('<div class="'.style($i).'">Emeliyyat: '.$pamertext.'<br/>Tarix: '.data($v['time']).'</div>');
}
nav($all,$limit,$page,''.url.'/user=operations&amp;page=',$sehife_s);
}else{
p4m3r4ik('<div class="menu">He├з balans emeliyyat─▒ aparmam─▒s─▒n─▒z!</div>');
}
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=cabinet">&laquo; Kabinet`e geri qayit</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if($_GET['type']=='profile'){
if($info['id']==0){
header("location: ".url."");
}
if(empty($_GET['id'])){
$id=$info['id'];
}else{
$id=(int)$_GET['id'];
}
$test=$db->query("select count(*) from `users` where `id`='".filter($id)."'")->fetchColumn();
if($test==0){
define('title','Istifade├зi tap─▒lmad─▒');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">Sehv!</div>
<div class="error">* Istifade├зi tap─▒lmad─▒!</div>');
}else{
$infou=$db->query("select * from `users` where `id`='".filter($id)."'")->fetch(PDO::FETCH_ASSOC);
define('title','Anket: '.$infou['login'].'');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">
'.($infou['id']==$info['id'] ? '<table width="100%">
<tr><td>Menim anketim</td>' : '
<table width="100%">
<tr><td>
Anket: '.$infou['login'].'').'
</td>
'.($info['id']==1 ? '
<td width="10%">[<a href="'.url.'/user=profile&amp;id='.$id.'&amp;del">&times;</a>]</td>
</tr></table>
' : '').'</table></div>');
if($info['id']==1){
if($_GET['del']=='ok'){
$sil[1]=$db->exec("delete from `users` where `id`='".$id."'");
$sil[2]=$db->exec("delete from `contact` where `mid`='".$id."'");
$sil[3]=$db->exec("delete from `contact` where `uid`='".$id."'");
$sil[4]=$db->exec("delete from `messages` where `user`='".$id."'");
$sil[5]=$db->exec("delete from `messages` where `send`='".$id."'");
$sil[6]=$db->exec("delete from `blok` where `kim`='".$id."'");
$sil[7]=$db->exec("delete from `blok` where `kimi`='".$id."'");
$sil[8]=$db->exec("delete from `bought` where `uid`='".$id."'");
header("location: ".url."/user=profile&id=$id");
}
if(isset($_GET['del'])){
p4m3r4ik('<div class="menu2">
Istifade├зini silmek istediyinize eminsiniz ?<br/>
<b>Diqqet:</b> <u>Hesabi sildikde ona aid olan butun her┼Яey bazadan silinir!</u><br/>
[<a href="'.url.'/user=profile&amp;id='.$id.'&amp;del=ok">Beli</a>] /
[<a href="'.url.'/user=profile&amp;id='.$id.'">Xeyr</a>]
</div><div class="title" style="padding:2px;"></div>');
}
if(isset($_GET['enter'])){
setcookie('login',$infou['login'],time()+3600);
setcookie('password',$infou['password'],time()+3600);
header("location: ".url."");
}
}
p4m3r4ik('<div class="menu">
<li>ID: <b>'.$infou['id'].'</b>'.($info['id']==1 ? ' - <a href="'.url.'/user=profile&id='.$infou['id'].'&enter">Daxil ol</a>' : '').'</li>
<li>Istifade├зi ad─▒: <b>'.$infou['login'].'</b> <img src="'.url.'/cssfiles/icons/'.($infou['ontime']>time() ? 'on' : 'off').'.gif" alt="'.($v['ontime']>time() ? '' : 'off').'"/></li>
'.($info['id']==1 ? '<li>┼Юifre: <b>'.$infou['password'].'</b></li>' : '').'
'.($infou['name']!='' ? '<li>Ad / Soyad: <b>'.$infou['name'].'</b></li>' : '').'
<li>Cins: <b>'.($infou['sex']==1 ? 'Ki┼Яi' : 'Qad─▒n').'</b></li> </div>
<div class="title" style="padding:2px;"></div><div class="menu">
'.($infou['email']!='' ? '<li>Email: <a href="mailto:'.$infou['email'].'">'.$infou['email'].'</a></li>' : '').'
'.($infou['number']!='' ? '<li>Mobil n├╢mre: <b>'.$infou['number'].'</b></li>' : '').'
<li>'.($info['id']==1 ? '<a href="'.url.'/admin/user=upbalans&amp;id='.$infou['id'].'">Balans</a>' : 'Balans').': <b>'.$infou['balans'].'</b> Manat</li>
'.($info['id']==1 ? '
<li>IP: <b>'.$infou['ip'].'</b></li>
<li>UA: <b>'.substr($infou['ua'],0,11).'</b></li>
' : '').'
<li>Son giri┼Я: <b>'.($infou['ontime']>time() ? 'Hal-hazirda saytdadir' : ''.data($infou['ontime']-300).'').'</b></li>
<li>Qeydiyyat tarixi: <b>'.data($infou['regtime']).'</li></b>
</div>
');

if($_GET['type']=='profile'){
if($info['id']==0){
header("location: ".url."");
}
if(empty($_GET['id'])){
$id=$info['id'];
}else{
$id=(int)$_GET['id'];
}
$test=$db->query("select count(*) from `users` where `id`='".filter($id)."'")->fetchColumn();
if($test==0){
define('title','Istifade├зi tap─▒lmad─▒');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">Sehv!</div>
<div class="error">* Istifade├зi tap─▒lmad─▒!</div>');
}else{
$infou=$db->query("select * from `users` where `id`='".filter($id)."'")->fetch(PDO::FETCH_ASSOC);
define('title','Anket: '.$infou['login'].'');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">
'.($infou['id']==$info['id'] ? '<table width="100%">
<tr><td>Menim anketim</td>' : '
<table width="100%">
<tr><td>
Anket: '.$infou['login'].'').'
</td>
'.($info['id']==1 ? '
<td width="10%">[<a href="'.url.'/user=profile&amp;id='.$id.'&amp;del">&times;</a>]</td>
</tr></table>
' : '').'</table></div>');
if($info['id']==1){
if($_GET['del']=='ok'){
$sil[1]=$db->exec("delete from `users` where `id`='".$id."'");
$sil[2]=$db->exec("delete from `contact` where `mid`='".$id."'");
$sil[3]=$db->exec("delete from `contact` where `uid`='".$id."'");
$sil[4]=$db->exec("delete from `messages` where `user`='".$id."'");
$sil[5]=$db->exec("delete from `messages` where `send`='".$id."'");
$sil[6]=$db->exec("delete from `blok` where `kim`='".$id."'");
$sil[7]=$db->exec("delete from `blok` where `kimi`='".$id."'");
$sil[8]=$db->exec("delete from `bought` where `uid`='".$id."'");
header("location: ".url."/user=profile&id=$id");
}
if(isset($_GET['del'])){
p4m3r4ik('<div class="menu2">
Istifade├зini silmek istediyinize eminsiniz ?<br/>
<b>Diqqet:</b> <u>Hesabi sildikde ona aid olan butun her┼Яey bazadan silinir!</u><br/>
[<a href="'.url.'/user=profile&amp;id='.$id.'&amp;del=ok">Beli</a>] /
[<a href="'.url.'/user=profile&amp;id='.$id.'">Xeyr</a>]
</div><div class="title" style="padding:2px;"></div>');
}
if(isset($_GET['enter'])){
setcookie('login',$infou['login'],time()+3600);
setcookie('password',$infou['password'],time()+3600);
header("location: ".url."");
}
}
p4m3r4ik('<div class="menu">
<li>ID: <b>'.$infou['id'].'</b>'.($info['id']==1 ? ' - <a href="'.url.'/user=profile&id='.$infou['id'].'&enter">Daxil ol</a>' : '').'</li>
<li>Istifade├зi ad─▒: <b>'.$infou['login'].'</b> <img src="'.url.'/cssfiles/icons/'.($infou['ontime']>time() ? 'on' : 'off').'.gif" alt="'.($v['ontime']>time() ? '' : 'off').'"/></li>
'.($info['id']==1 ? '<li>┼Юifre: <b>'.$infou['password'].'</b></li>' : '').'
'.($infou['name']!='' ? '<li>Ad / Soyad: <b>'.$infou['name'].'</b></li>' : '').'
<li>Cins: <b>'.($infou['sex']==1 ? 'Ki┼Яi' : 'Qad─▒n').'</b></li> </div>
<div class="title" style="padding:2px;"></div><div class="menu">
'.($infou['email']!='' ? '<li>Email: <a href="mailto:'.$infou['email'].'">'.$infou['email'].'</a></li>' : '').'
'.($infou['number']!='' ? '<li>Mobil n├╢mre: <b>'.$infou['number'].'</b></li>' : '').'
<li>'.($info['id']==1 ? '<a href="'.url.'/admin/user=upbalans&amp;id='.$infou['id'].'">Balans</a>' : 'Balans').': <b>'.$infou['balans'].'</b> Manat</li>
'.($info['id']==1 ? '
<li>IP: <b>'.$infou['ip'].'</b></li>
<li>UA: <b>'.substr($infou['ua'],0,11).'</b></li>
' : '').'
<li>Son giri┼Я: <b>'.($infou['ontime']>time() ? 'Hal-hazirda saytdadir' : ''.data($infou['ontime']-300).'').'</b></li>
<li>Qeydiyyat tarixi: <b>'.data($infou['regtime']).'</li></b>
</div>
');
if($info['id']==1){
$u['host']=$db->query("select count(*) from `bought` where `uid`='".intval($infou['id'])."' and `type`='1'")->fetchColumn();
$u['resel']=$db->query("select count(*) from `bought` where `uid`='".intval($infou['id'])."' and `type`='2'")->fetchColumn();
$u['domain']=$db->query("select count(*) from `bought` where `uid`='".intval($infou['id'])."' and `type`='3'")->fetchColumn();
p4m3r4ik('<div class="title" style="padding:2px;"></div>
<table width="100%" style="text-align:center;">
<tr><td class="menu"><a href="'.url.'/useraccountadd=domain&amp;uid='.$infou['id'].'">Domain ver ('.$u['domain'].')</a></td>
<td class="menu"><a href="'.url.'/useraccountadd=hosting&amp;uid='.$infou['id'].'">Hosting ver ('.$u['host'].')</a></td>
<td class="menu"><a href="'.url.'/useraccountadd=reseller&amp;uid='.$infou['id'].'">Reseller ver ('.$u['resel'].')</a></td>
</tr></table>
');
}
$testblok=$db->query("select count(*) from `blok` where `kim`='".$info['id']."' and `kimi`='".$infou['id']."'")->fetchColumn();
$testblok2=$db->query("select count(*) from `blok` where `kim`='".$infou['id']."' and `kimi`='".$info['id']."'")->fetchColumn();
if($info['id']!=$infou['id']){
p4m3r4ik('<div class="title" style="padding:2px;"></div>
<div class="menu">
<li><a href="'.url.'/user=transfer-money?login='.$infou['login'].'">Pul g├╢nder (azn/0%)</a></li>');
if($testblok==0 and $testblok2==0){
p4m3r4ik('<li><a href="'.url.'/user=mail&view='.$infou['id'].'">Mektub g├╢nder</a></li>');
}elseif($testblok!=0 and $testblok2==0){
p4m3r4ik('<li>Istifade├зini blok etmisiniz,siz ona veya o,size yaza bilmez!</li>');
}elseif($testblok2!=0 and $testblok==0){
p4m3r4ik('<li>Istifade├зi sizi blok edib,siz ona yaza bilemezsiniz!</li>');
}elseif($testblok2!=0 and $testblok!=0){
p4m3r4ik('<li>Istifade├зi sizi blok edib,siz ona yaza bilemezsiniz!</li>');
}if($infou['id']!=1){
p4m3r4ik($testblok!=0 ? '<li><a href="'.url.'/user=mail&blok='.$infou['id'].'">Blokdan ├з─▒xart</a> (yaza bilsin)</li>' :
'<li><a href="'.url.'/user=mail&blok='.$infou['id'].'">Blok et</a> (yaza bilmesin)</li>');
}
p4m3r4ik('</div>');
}
}

p4m3r4ik('<div class="menu2"><a href="'.url.'">&laquo; Ana sehife</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if($_GET['type']=='bloklist'){
define('title','Blok list');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">'.title.'</div>');
$page=(int)$_GET['page'];
if(empty($page)) $page=1;
$limit=5;
$all=$db->query("select count(*) from `blok` where `kim`='".$info['id']."'")->fetchColumn();
$sehife_s=ceil($all/$limit);
if($page > $sehife_s) $page=1;
$goster=$page*$limit-$limit;
if($all!=0){
$view=$db->query("select * from `blok` where `kim`='".$info['id']."' order by `id` desc limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
foreach($view as $a){
$i++;
$v=$db->query("select * from `users` where `id`='".$a['kimi']."'")->fetch(PDO::FETCH_ASSOC);
p4m3r4ik('<div class="'.style($i).'">
<table width="100%">
<tr><td>
<a href="'.url.'/user=profile&amp;id='.$v['id'].'">
<img src="'.url.'/cssfiles/icons/'.($v['sex']==1 ? 'men.png' : 'women.png').'" title="'.$v['login'].'" alt="iconuser"/>
'.$v['login'].'</a> <img src="'.url.'/cssfiles/icons/'.($v['ontime']>time() ? 'on' : 'off').'.gif" alt="'.($v['ontime']>time() ? '' : 'off').'"/>
</td><td width="10%">
<a href="'.url.'/user=mail&amp;blok='.$v['id'].'">&times;</a>
</td></tr></table>
</div>');
}
nav($all,$limit,$page,''.url.'/user=bloklist&amp;page=',$sehife_s);
}else{
p4m3r4ik('<div class="menu">He├зkesi blok etmemisiniz!</div>');
}
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=cabinet">&laquo; Kabinet`e geri qayit</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if($_GET['type']=='mail'){
if(empty($info['id'])){
header("location: ".url."");
exit();
}
if(isset($_GET['blok'])){
define('title','Istifade├зi blok et');
@require_once("incfiles/header.php");
$testid=$db->query("select count(*) from `users` where `id`='".intval($_GET['blok'])."'")->fetchColumn();
if($testid==0){
$error.='* Istifade├зi tap─▒lmad─▒!<br/>';
}
if($info['id']==intval($_GET['blok'])){
$error.='* ├Цz├╝n-├╢z├╝n├╝ blok ede bilmezsen!<br/>';
}
if(intval($_GET['blok'])==1){
$error.='* Adminstratoru blok ede bilmezsiniz!<br/>';
}
if(empty($error)){
$testblok=$db->query("select count(*) from `blok` where `kim`='".$info['id']."' and `kimi`='".intval($_GET['blok'])."'")->fetchColumn();
if($testblok==0){
$insert=$db->exec("insert into `blok` set `kim`='".$info['id']."',`kimi`='".intval($_GET['blok'])."'");
$delcont=$db->exec("delete from `contact` where `mid`='".intval($_GET['blok'])."' and `uid`='".$info['id']."'");
}else{
$delblok=$db->exec("delete from `blok` where `kim`='".$info['id']."' and `kimi`='".$_GET['blok']."'");
}
header("location: ".$_SERVER['HTTP_REFERER']."");
}else{
p4m3r4ik('<div class="title">Sehv</div>
<div class="error">'.$error.'</div>');
}
p4m3r4ik('<div class="menu2"><a href="'.url.'">&laquo; Ana sehife</a></div>');
@require_once("incfiles/footer.php");
exit();
}
if(isset($_GET['view'])){
$id=(int)$_GET['view'];
$test=$db->query("select count(*) from `users` where `id`='".$id."'")->fetchColumn();
if($test==0){
define('title','─░stifade├зi tap─▒lmad─▒!');
@require("incfiles/header.php");
p4m3r4ik('<div class="title">Sehv!</div>
<div class="error">'.title.'</div>
<div class="menu2"><a href="'.url.'/user=mail">&laquo; Mektub qutusu</a></div>');
@require_once("incfiles/footer.php");
exit();
}
$iid=$db->query("select * from `users` where `id`='$id'")->fetch(PDO::FETCH_ASSOC);
if($info['id']==$id and $info['id']!=1){
define('title','├Цz├╝n-├╢z├╝ne yaza bilmezsen!');
@require("incfiles/header.php");
p4m3r4ik('<div class="title">Sehv</div>
<div class="error">'.title.'</div>
<div class="menu2"><a href="'.url.'/user=mail">&laquo; Mektub qutusu</a></div>');
@require_once("incfiles/footer.php");
exit();
}
define('title','Sohbet arxivi: '.$iid['login'].'');
$mes=''.$info['id'].'_'.$id;
$mes2=''.$id.'_'.$info['id']; ///RESOTQANI QALDIRDIQDA HERKES GORUR!!!
@require("incfiles/header.php");
p4m3r4ik('<div class="title">Mektub g├╢nder</div>');
$testblok=$db->query("select count(*) from `blok` where `kim`='".$info['id']."' and `kimi`='".$id."'")->fetchColumn();
$testblok2=$db->query("select count(*) from `blok` where `kim`='".$infou['id']."' and `kimi`='".$id."'")->fetchColumn();
if($testblok!=0 and $testblok2==0){
$error='<li>Istifade├зini blok etmisiniz,siz ona veya o,size yaza bilmez!</li>';
}elseif($testblok2!=0 and $testblok==0){
$error='<li>Istifade├зi sizi blok edib,siz ona yaza bilemezsiniz!</li>';
}elseif($testblok2!=0 and $testblok!=0){
$error='<li>Istifade├зi sizi blok edib,siz ona yaza bilemezsiniz!</li>';
}
if(empty($error)){
if(!empty($_POST['mesaj']) and !empty($_POST['ENTER'])){
$mesaj=filter($_POST['mesaj']);
if(strlen($mesaj)>400 or strlen($mesaj)<2){
if($info['id']!=1){
$error.='* Mesaj uzunlu─Яu 400 simvoldan b├╢y├╝k ve 2 simvolan ki├зik ola bilmez!<br/>';
}
}
if($_SESSION['mesajtime']>time()){
$error.='* Yeniden mesaj yazmaq ├╝├з├╝n '.($_SESSION['mesajtime']-time()).' saniye g├╢zleyin!<br/>';
}
if($_SESSION['token']==$_POST['token']){
if(empty($error)){
$sendmesaj=$db->exec("insert into `messages` set `mes`='".$mes."',`send`='".$info['id']."',`user`='".$id."',`text`='".$mesaj."',`time`='".time()."'");
$testcont=$db->query("select * from `contact` where `mid`='".$info['id']."' and `uid`='".$id."'")->fetchColumn();
$mytestcont=$db->query("select * from `contact` where `mid`='".$id."' and `uid`='".$info['id']."'")->fetchColumn();
if($testcont!=0){
$upcont=$db->exec("update `contact` set `status`='1',`time`='".time()."' where `mid`='".$info['id']."' and `uid`='".$id."'");
}else{
$insert=$db->exec("insert into `contact` set `time`='".time()."',`status`='1',`mid`='".$info['id']."',`uid`='".$id."'");
}
if($mytestcont!=0){
$upcont=$db->exec("update `contact` set `status`='0',`time`='".time()."' where `mid`='".$id."' and `uid`='".$info['id']."'");
}else{
$insert=$db->exec("insert into `contact` set `time`='".time()."',`status`='0',`mid`='".$id."',`uid`='".$info['id']."'");
}
$_SESSION['mesajtime']=time()+20;
header("location: ".url."/user=mail&view=$id");
}else{
p4m3r4ik('<div class="error">'.$error.'</div>');
}
}
}
$_SESSION['token']=rand(111111111,999999999);
p4m3r4ik('<div class="menu2"><form method="POST">
Mektub:<br/>
<textarea name="mesaj" maxlength="400" cols="29" rows="3"></textarea><br/>
<input type="hidden" name="token" value="'.$_SESSION['token'].'"/>
<input type="submit" name="ENTER" value="G├╢nder"/>
<a href="'.url.'/user=mail&view='.intval($_GET['view']).'"><input type="submit" value="Yenile"/></a>
</form></div>');
}else{
p4m3r4ik('<div class="error">'.$error.'</div>');
}

p4m3r4ik('<div class="title">Sohbet arxivi: <a href="'.url.'/user=profile&amp;id='.$info['id'].'">'.$info['login'].'</a> / <a href="'.url.'/user=profile&amp;id='.$iid['id'].'">'.$iid['login'].'</a></div>');
$page=(int)$_GET['page'];
if(empty($page)) $page=1;
$limit=5;
$all=$db->query("select count(*) from `messages` where `mes`='$mes' or `mes`='$mes2'")->fetchColumn();
$sehife_s=ceil($all/$limit);
if($page > $sehife_s) $page=1;
$goster=$page*$limit-$limit;
if($all!=0){
$archive=$db->query("select * from `messages` where `mes`='$mes' or `mes`='$mes2' order by `id` desc limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
foreach($archive as $a){
if($a['send']!=$info['id'] and $a['view']==0){
$upmes=$db->exec("update `messages` set `view`='1' where `id`='".$a['id']."'");
$upcont=$db->exec("update `contact` set `status`='0' where `mid`='".$id."' and `uid`='".$info['id']."'");
}
$i++;
$ilog=$db->query("select * from `users` where `id`='".$a['send']."'")->fetch(PDO::FETCH_ASSOC);
$pamermes=mysql_escape_string($a['text']);
$pamermes=str_replace('\r\n','<br/>',$pamermes);
$pamermes=str_replace('\n','<br/>',$pamermes);
p4m3r4ik('<div class="'.style($i).'">
<table width="100%"><tr><td>
'.($ilog['login']!='' ? '
<a href="'.url.'/user=profile&amp;id='.$ilog['id'].'">
<img src="'.url.'/cssfiles/icons/'.($ilog['sex']==1 ? 'men.png' : 'women.png').'" title="'.$ilog['login'].'" alt="iconuser"/>
'.$ilog['login'].'</a>
<img src="'.url.'/cssfiles/icons/'.($ilog['ontime']>time() ? 'on' : 'off').'.gif" alt="'.($ilog['ontime']>time() ? '' : 'off').'"/>
' : 'Leqeb_silinib').'<br/>
<small>'.data($a['time']).'</small><br/>
Mesaj: '.($a['text']!='' ? smiles($pamermes) : 'Mesaj yoxur!').'
</td>
<td width="10%">
<img src="'.url.'/cssfiles/icons/'.($a['view']==0 ? 'view0' : 'view1').'.png" alt=""/>
</td>
</tr>
</table>
</div>');
}
nav($all,$limit,$page,''.url.'/user=mail&view='.$id.'&amp;page=',$sehife_s);
}else{
p4m3r4ik('<div class="menu">Sohbet arxivi bo┼Яdur!</div>');
}
}else{
$all=$db->query("select count(*) from `contact` where `uid`='".$info['id']."'")->fetchColumn();
define('title','Mektub qutusu ('.$all.')');
@require_once("incfiles/header.php");
p4m3r4ik('<div class="title">'.title.'</div>');
$page=(int)$_GET['page'];
if(empty($page)) $page=1;
$limit=5;
$sehife_s=ceil($all/$limit);
if($page > $sehife_s) $page=1;
$goster=$page*$limit-$limit;
if($all!=0){
$view=$db->query("select * from `contact` where `uid`='".$info['id']."' order by `time` desc limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
foreach($view as $v){
$i++;
$newmes=$db->query("select count(*) from `messages` where `send`='".$v['mid']."' and `view`='0' and `mes`='".$v['mid']."_".$info['id']."'")->fetchColumn();
$lastm=$db->query("select `text`,`time`,`view` from `messages` where `mes`='".$v['mid']."_".$info['id']."' or `mes`='".$info['id']."_".$v['mid']."' order by `id` desc limit 1")->fetch(PDO::FETCH_ASSOC);
$ilog=$db->query("select * from `users` where `id`='".$v['mid']."'")->fetch(PDO::FETCH_ASSOC);
p4m3r4ik('<div class="'.style($i).'">
<table width="100%"><tr><td>
'.($ilog['login']!='' ? '<a href="'.url.'/user=mail&amp;view='.$ilog['id'].'">
<img src="'.url.'/cssfiles/icons/'.($ilog['sex']==1 ? 'men.png' : 'women.png').'" title="'.$ilog['login'].'" alt="iconuser"/>
'.$ilog['login'].'</a>
<img src="'.url.'/cssfiles/icons/'.($ilog['ontime']>time() ? 'on' : 'off').'.gif" alt="'.($ilog['ontime']>time() ? '' : 'off').'"/> ' : '
<a href="'.url.'/user=mail&amp;view='.$v['mid'].'">
<img src="'.url.'/cssfiles/icons/emptyuser.png" alt="emptyuser"> Leqeb silib</a>').'
'.($newmes!=0 ? '<font color="red"> +'.$newmes.'</font>' : '').'
<br/><font size="1%">'.substr($lastm['text'],0,30).'... - '.data($lastm['time']).'</font>
</td>
<td width="10%">
<img src="'.url.'/cssfiles/icons/'.($lastm['view']==0 ? 'view0' : 'view1').'.png" alt=""/>
</td>
</tr></table>
</div>');
}
nav($all,$limit,$page,''.url.'/user=mail&page=',$sehife_s);
}else{
p4m3r4ik('<div class="menu">Sizin he├з mesaj─▒n─▒z yoxdur!</div>');
}
}
p4m3r4ik('<div class="menu2"><a href="'.url.'/user=mail">&laquo; Mektub qutusu</a></div>');
@require_once("incfiles/footer.php");
exit();
}

devam

duzeltdim sehfliyi bilmek isteyen varsa harda idi deyim

fuad said:

axsaminiz xeyirli olsun demeli bele bir problemle qarsilasmisam mesaj bolmunede deyekki men fuad nicata mesaj yaziramki salam mesaj gedir oda bunu gorur burakimi hersey qaydasindadi memmed mesaj bolmunde nicata daxil olurki mesaj yazsin ve memmed gorurki fuad nicata salam yazib )) bunu nece aradan qaldirim ki memmed gormesin menim nicata yazdigim mesaji??

Genişləndirmək üçün klikləyin...

Problem hansi sayt uzerinde idi duzeltdin

elnar7575 said:

Problem hansi sayt uzerinde idi duzeltdin

Genişləndirmək üçün klikləyin...

heleki hecbir sayta qurasdirilmayib

fuad said:

heleki hecbir sayta qurasdirilmayib

Genişləndirmək üçün klikləyin...

He pgp kodlar tam plaraq ne kodudu Sende de loto script var?

elnar7575 said:

He pgp kodlar tam plaraq ne kodudu Sende de loto script var?

Genişləndirmək üçün klikləyin...

yox mende loto yoxdu