View file users/account/mail/group_messages_search.php

File size: 2.03Kb
<?php  
$mg = db::get_string("SELECT * FROM `MAIL` WHERE (`USERS` LIKE ? OR `ADM_ID` = ?) AND `ID` = ? LIMIT 1", ['%:'.user('ID').':%', user('ID'), intval(get('id'))]);
acms_header(lg('Групповая беседа %s - поиск сообщений', tabs($mg['NAME'])), 'users');

define('GROUP_NAME', tabs($mg['NAME']));
define('GROUP_ID', $mg['ID']);
define('GROUP_ADM', $mg['ADM_ID']);
define('GROUP_AVATAR', $mg['AVATAR']);
define('GROUP_USERS', tabs($mg['USERS']));
define('GROUP_PRINTS', tabs($mg['PRINT']));

if (!isset($mg['ID'])) {
  
  error('Неверная директива');
  redirect('/account/mail/');
  
}

if (post('search')){
  
  session('gmsearch', esc(post('search')));
  
}

define('SEARCH', tabs(session('gmsearch')));

?>
<div class='search-main-optimize'>
<form method='post' class='ajax-form2' action='/account/mail/group_messages_search/?id=<?=GROUP_ID?>&get=go'>
<input type='text' name='search' class='search-main' placeholder='<?=lg('Введите содержание письма')?>' value='<?=SEARCH?>'> 
<button class="search-main-button ajax-button-search" name="ok"><?=icons('search', 20)?></button>
</form>
</div>
<?

if (get('get') == 'go') {
  
  $id = 0;
  $data = db::get_string_all("SELECT * FROM (SELECT * FROM `MAIL_GROUPS_MESSAGE` WHERE `MESSAGE` LIKE ? AND `USERS` LIKE ? AND `GROUP_ID` = ? ORDER BY `TIME` DESC LIMIT 200) A ORDER BY `TIME`", ['%'.SEARCH.'%', '%:'.user('ID').':%', GROUP_ID]);
  while ($list = $data->fetch()){
    
    require (ROOT.'/users/account/mail/plugins/list_group_mess.php');
    echo $mess;
    $id = $list['ID'];
  
  }
  
  if ($id == 0){
    
    html::empty('Ничего не найдено', 'times');
  
  }
  
}else{
  
  html::empty('Начните искать сообщения', 'search');
  
}
  
?> 
</div>
<button class='mail-message-scrollheight' id='OnBottom'><?=icons('angle-down', 20)?></button>
<div class='scroll bottom'></div>
<div id='body-top-comments' id_post='0' pixel='0'></div>
<?

back('/account/mail/messages_group/?id='.GROUP_ID.'&'.TOKEN_URL);
acms_footer();