限制200条

lty628 · Dec 15, 2023 · 76867f5 · 76867f5
1 parent 4c501f7
commit 76867f5
Showing 1 changed file with 3 additions and 3 deletions.
diff --git a/application/chat/libs/ChatDbHelper.php b/application/chat/libs/ChatDbHelper.php
@@ -63,7 63,7 @@ public static function getChatFriendHistory($data)
  {
  $result = Db::name('chat_friends_history')->alias('chat')->join([getPrefix() . 'user' => 'user'], 'user.uid=chat.fromuid')->where('fromuid', 'in', [$data['touid'], $data['fromuid']])
  ->where('touid', 'in', [$data['touid'], $data['fromuid']])
- ->limit(1000)
  ->limit(200)
  ->order('chat_id', 'desc')
  ->field('user.head_image,user.nickname,chat.*')->select();
  Db::name('chat_friends_history')->where('fromuid', $data['touid'])->where('touid', $data['fromuid'])->where('send_status', 0)->update([
@@ -79,7 79,7 @@ public static function getChatPrivateLetterHistory($data)
  {
  $result = Db::name('chat_private_letter_history')->alias('chat')->join([getPrefix() . 'user' => 'user'], 'user.uid=chat.fromuid')->where('fromuid', 'in', [$data['touid'], $data['fromuid']])
  ->where('touid', 'in', [$data['touid'], $data['fromuid']])
- ->limit(1000)
  ->limit(200)
  ->order('chat_id', 'desc')
  ->field('user.head_image,user.nickname,chat.*')->select();
  Db::name('chat_private_letter_history')->where('fromuid', $data['touid'])->where('touid', $data['fromuid'])->where('send_status', 0)->update([
@@ -96,7 96,7 @@ public static function getChatGroupHistory($data)
  $result = Db::name('chat_group_history')->alias('chat')
  ->join([getPrefix() . 'user' => 'user'], 'user.uid=chat.fromuid')
  ->where('groupid', $data['groupid'])
- ->limit(1000)
  ->limit(200)
  ->order('chat_id', 'desc')
  ->field('user.head_image,user.nickname,chat.*')->select();
  Db::name('chat_group_user')->where('uid', $data['uid'])->where('groupid', $data['groupid'])->update([