Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $c = 10;
- $k_post = $db->rows("SELECT COUNT(*) FROM `messages` WHERE `user_id` = '".$user['id']."'");
- $k_page = k_page($k_post,$c);
- $page = page($k_page);
- $start = $c*$page-$c;
- $db->offEmulate();
- $mail_groups = $db->fetchAll("SELECT `user_send`, `time`
- FROM `messages` WHERE `user_id` = '".$user['id']."'
- AND (`user_send`, `time`) IN (SELECT `user_send`, MAX(`time`) FROM `messages` WHERE `user_id` = '".$user['id']."' GROUP BY `user_send`)
- ORDER BY `time`
- DESC LIMIT $start,$c");
- foreach($mail_groups as $mg){
- $us = $db->fetch('SELECT `id`,`login`,`sex` FROM `users` WHERE `id` = "'.$mg['user_send'].'" LIMIT 1');
- $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