public function getMsgsByMlid($mlid, $uid, $limit) { $list = array(); if (empty($mlid)) { return $list; } $mlist = MessageService::getListByMlid($mlid, $uid); if (empty($mlist) || $mlist['type'] != 1) { return $list; } $where = ''; if ($mlist['uid'] == $uid) { $where .= ' AND status IN (0,2)'; } else { $where .= ' AND status IN (0,1)'; } $query = FDB::query('SELECT * FROM ' . MessageService::getTablaName($mlid) . " \r\n\t\t\tWHERE mlid='{$mlid}' {$where} ORDER BY dateline DESC LIMIT {$limit}"); while ($data = FDB::fetch($query)) { $data['time'] = getBeforeTimelag($data['dateline']); $list[] = $data; } FDB::query("UPDATE " . FDB::table('user_msg_member') . " SET is_new=0 WHERE mlid='{$mlid}' AND uid='{$uid}' AND is_new=1"); return array_reverse($list); }