Файл: public_html/mail.php
Строк: 46
<?
include './dev/db.php';
include './dev/functions.php';
include './dev/user.php';
if(!$user) {
header('location: /index.php');
exit;
}
$id = _string(_num($_GET['id']));
if($id) {
$ho = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = ''.$id.'''));
if(!$id OR !$ho OR $id == $user['id']) {
header('location: /mail.php');
exit;
}
$title = 'Почта '.$ho['login'];
include './dev/head.php';
if(mysql_result(mysql_query('SELECT COUNT(*) FROM `contacts` WHERE `user` = ''.$user['id'].'' AND `ho` = ''.$ho['id'].'''),0) == 0) {
mysql_query('INSERT INTO `contacts` (`user`,
`ho`,
`time`) VALUES (''.$user['id'].'',
''.$ho['id'].'',
''.time().'')');
}
if(mysql_result(mysql_query('SELECT COUNT(*) FROM `contacts` WHERE `ho` = "'.$user['id'].'" AND `user` = "'.$ho['id'].'"'),0) == 0) {
mysql_query('INSERT INTO `contacts` (`ho`,
`user`,
`time`) VALUES (''.$user['id'].'',
''.$ho['id'].'',
''.time().'')');
}
if(isset($_POST['text'])){
$text = _string($_POST['text']);
if(strlen($text) < 1 or strlen($text) > 1000) {
echo '<div class="block center">Длина сообщения 1-1000 символов!<br>Вернуться в <a href="/mail.php">Почту</a></div>';
include ('./dev/foot.php');
exit;
}
if($user['level'] < 5) {
echo '<div class="block center">Отправлять почту разрешено с 5 уровня!<br>Вернуться в <a href="/mail.php">Почту</a></div>';
include ('./dev/foot.php');
exit;
}
mysql_query('INSERT INTO `mail` (`from`,
`to`,
`text`,
`time`) VALUES (''.$user['id'].'',
''.$ho['id'].'',
''.$text.'',
''.time().'')');
mysql_query('UPDATE `contacts` SET `time` = ''.time().'' WHERE `user` = ''.$user['id'].'' AND `ho` = ''.$ho['id'].''');
mysql_query('UPDATE `contacts` SET `time` = ''.time().'' WHERE `ho` = ''.$user['id'].'' AND `user` = ''.$ho['id'].''');
header('location: /mail.php?id='.$ho['id'].'');
$_SESSION['result'] = 'Сообщение отправлено!';
exit();
}
echo '
<div class='block'>
<form action='/mail.php?id='.$ho['id'].'' method='post'>
<textarea name='text' style='width: 97%'></textarea>
<input type='submit' value='Отправить'> <a href='/smiles.php'>Смайлики</a>
</form>
</div>';
$max = 10;
$k_post = mysql_result(mysql_query('SELECT COUNT(*) FROM `mail` WHERE `from` = "'.$user['id'].'" AND `to` = "'.$ho['id'].'" OR `to` = "'.$user['id'].'" AND `from` = "'.$ho['id'].'"'),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
if($k_post > 0) {
$q = mysql_query('SELECT * FROM `mail` WHERE `from` = ''.$user['id'].'' AND `to` = ''.$ho['id'].'' OR `to` = ''.$user['id'].'' AND `from` = ''.$ho['id'].'' ORDER BY `time` DESC LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
$from = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = ''.$row['from'].'''));
echo '<div class='block'><img src='/img/race/sex/'.$from['race'].'.jpg'> <a href='/user/'.$from['id'].'/'>'.$from['login'].'</a>: '.smiles($row['text']).'</div>';
if($row['to'] == $user['id'] && $row['read'] == 0) mysql_query('UPDATE `mail` SET `read` = '1' WHERE `id` = ''.$row['id'].''');
}
if($k_page>1) echo str('?',$k_page,$page);
}
else
{
echo '<div class='block center'>Сообщений нет!</div>';
}
echo '
<a href='/mail.php' class='link'><img src='/img/arr.png'> Контакты</a>';
include './dev/foot.php';
}
else
{
$title = 'Почта';
include './dev/head.php';
$max = 10;
$k_post = mysql_result(mysql_query('SELECT COUNT(*) FROM `contacts` WHERE `user` = ''.$user['id'].'''),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
if($k_post > 0) {
$q = mysql_query('SELECT * FROM `contacts` WHERE `user` = ''.$user['id'].'' ORDER BY `time` DESC LIMIT '.$start.', '.$max.'');
while($row = mysql_fetch_array($q)) {
$ho = mysql_fetch_array(mysql_query('SELECT * FROM `users` WHERE `id` = ''.$row['ho'].'''));
$new = mysql_result(mysql_query('SELECT COUNT(*) FROM `mail` WHERE `from` = ''.$ho['id'].'' AND `to` = ''.$user['id'].'' AND `read` = '0''),0);
echo '<a href='/mail.php?id='.$row['ho'].'' class='link'><img src='/img/race/sex/'.$ho['race'].'.jpg'> '.$ho['login'].'';
if($new > 0) echo ' <img src='/img/mail.png'></a>';
if($new < 1) echo '</a>';
}
if($k_page>1) echo str('?',$k_page,$page);
}
else
{
echo '<div class='block center'>Контактов нет!</div>';
}
include './dev/foot.php';
}
?>