Guest User

Untitled

a guest
Aug 29th, 2018
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.83 KB | None | 0 0
  1. $c = 10;
  2. $k_post = $db->rows("SELECT COUNT(*) FROM `messages` WHERE `user_id` = '".$user['id']."'");
  3. $k_page = k_page($k_post,$c);
  4. $page = page($k_page);
  5. $start = $c*$page-$c;
  6.  
  7. $db->offEmulate();
  8. $mail_groups = $db->fetchAll("SELECT `user_send`, `time`
  9. FROM `messages` WHERE `user_id` = '".$user['id']."'
  10. AND (`user_send`, `time`) IN (SELECT `user_send`, MAX(`time`) FROM `messages` WHERE `user_id` = '".$user['id']."' GROUP BY `user_send`)
  11. ORDER BY `time`
  12. DESC LIMIT $start,$c");
  13. foreach($mail_groups as $mg){
  14.        
  15.         $us = $db->fetch('SELECT `id`,`login`,`sex` FROM `users` WHERE `id` = "'.$mg['user_send'].'" LIMIT 1');
  16.         $mail = $db->fetch("SELECT * FROM `message` WHERE `user_id` = '".$user['id']."' AND `user` = '".$us['id']."' OR `user_id` = '".$us['id']."' AND `user` = '".$user['id']."' ORDER BY `time` DESC LIMIT 1");
Advertisement
Add Comment
Please, Sign In to add comment