Файл: pesn_voini/peseni_vojni/instalscript/engine/public/mail/index.php
Строк: 75
<?php
//
require_once($_SERVER['DOCUMENT_ROOT']."/instalscript/engine/_inc/sys.php");
//
head("Почта",$uid); # Голова
//
echo logs();
//
$r = rand(100000,999999);
//
if(isset($_GET['del'])){
//
$id_chmsg = abs(intval($_GET['id']));
//
//$sms1 = mysql_num_rows(mysql_query("SELECT * FROM `mail` WHERE `id_user` = '".$uid."' AND `id_ank`= '".$id_chmsg."'"));
//
$sms1 = fch("SELECT * FROM `mail` WHERE `id_ank` = ? AND `id_user` = ?LIMIT 1", array($id_chmsg,$uid));
//
$sms2 = fch("SELECT * FROM `mail` WHERE `id_ank` = ? AND `id_user` = ?LIMIT 1", array($uid,$id_chmsg));
//
//$sms2 = mysql_num_rows(mysql_query("SELECT * FROM `mail` WHERE `id_ank` = '".$uid."' AND `id_user` = '".$id_chmsg."'"));
//
if($sms1 > 0){
//mysql_query("UPDATE `mail` SET `del_user` = '".$uid."' WHERE `id_user` = '".$uid."' AND `id_ank`= '".$id_chmsg."'");
//
//mysql_query("UPDATE `contacts_mail` SET `del` = '".$uid."', `new_msg` = '0' WHERE `id_ank` = '".$id_chmsg."' AND `id_user` = '".$uid."'");
//
qry("UPDATE `mail` SET `del_user` = ? WHERE `id_user` = ? AND `id_ank` = ? LIMIT 1", array($uid,$uid,$id_chmsg));
//
qry("UPDATE `contacts_mail` SET `del` = ?, `new_msg` = ? WHERE `id_user` = ? AND `id_ank` = ? LIMIT 1", array($uid,0,$uid,$id_chmsg));
}
//
if($sms2 > 0){
//mysql_query("UPDATE `mail` SET `del_ank` = '".$uid."' WHERE `id_ank` = '".$uid."' AND `id_user` = '".$id_chmsg."'");
//
//mysql_query("UPDATE `contacts_mail` SET `del` = '".$uid."', `new_msg` = '0' WHERE `id_user` = '".$uid."' AND `id_ank` = '".$id_chmsg."'");
//
qry("UPDATE `mail` SET `del_ank` = ? WHERE `id_ank` = ? AND `id_user` = ? LIMIT 1", array($uid,$uid,$id_chmsg));
//
qry("UPDATE `contacts_mail` SET `del` = ?, `new_msg` = ? WHERE `id_user` = ? AND `id_ank` = ? LIMIT 1", array($uid,0,$uid,$id_chmsg));
}
err("Переписка удалена");
header('location:?r='.$r);
exit();
}
//
//$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `contacts_mail` WHERE `id_user` = '".$uid."' AND `del` != '".$uid."'"),0);
$count = $BaseConnect->query("SELECT (id) FROM `contacts_mail` WHERE `del` != '".$uid."' AND `id_user` = '".$uid."'")->rowCount();
$str = '10'; # кол-во записей для вывода
$url = "/contacts/"; # ссылка
$num = abs(is('1')); # текущая страница
$result = $count; # подсчёт
//$msg_q = mysql_query("SELECT * FROM `contacts_mail` WHERE `id_user` = '".$uid."' AND `del` != '".$uid."' ORDER BY `new_msg` DESC, `id` DESC LIMIT ".page($num,$str,$result).",$str ");
//
$msg_q = $BaseConnect->query("SELECT * FROM `contacts_mail` WHERE `del` != '".$uid."' AND `id_user` = '".$uid."' ORDER BY `new_msg` DESC, `id` DESC LIMIT ".page($num,$str,$result).",$str ");
//
//
if($count == 0)echo '<div class="message">Сообщений ещё нет</div>';
while($msg = $msg_q->fetch(PDO::FETCH_ASSOC)){
//
if($msg['new_msg'] == 0)$check = '';
else $check = '<font color="lime">(+)</font>';
//
//$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$msg['id_ank']."' LIMIT 1"));
$ank = fch("SELECT * FROM `users` WHERE `id` = ? LIMIT 1", array($msg['id_ank']));
//
//$message = mysql_fetch_assoc(mysql_query("SELECT * FROM `mail` WHERE `id_user` = '".$user['id']."' AND `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."' AND `id_ank` = '".$user['id']."' ORDER BY id DESC LIMIT 1"));
//
$message = fch("SELECT * FROM `mail` WHERE `id_user` = ? AND `id_ank` = ? OR `id_user` = ? AND `id_ank` = ? ORDER BY `id` DESC LIMIT 1", array($uid,$ank['id'],$ank['id'],$uid));
//
echo '<div class = "message"><a href="/mail/'.$msg['id_ank'].'/user">'.user_list2($msg['id_ank']).' '.$check.'</a><span style="float: right;"><a class href = "?del&id='.$msg['id_ank'].'">[Удалить]</a></span><br>'.bbcode(text_msg($message['text'])).'</div>';
//
}
//
ppage($url,$num,$str,$result);
//
//
echo '<div class="cntr"><a href="/black_list/">Черный список</a> - <a href="/friends/">Друзья</a></div>';
//
foot($uid);
//
?>