【XenForo】为Forum列表中最新的贴子加上NEW标记

PHP：

<?php 
 
//连接数据库
$connect = @mysqli_connect('','','');
if(!$connect){
    echo '数据库连接失败'.mysqli_error($connect);
}
mysqli_select_db( $connect, 'hairloss' );
$result = mysqli_query($connect,
						"select post_id,thread_id 
						from xf_post  
						where thread_id in(
						select thread_id from 
						(select thread_id from xf_thread 
						ORDER BY last_post_date desc LIMIT 5 ) 
						as top_five_thread_ids
						) 
						ORDER BY post_id desc;"
) or die(mysqli_error($connect));
$newMembers = [];
$i=0;
while($tr=mysqli_fetch_row($result)){
	$newMembers[$i++] = $tr[0];
}
print_r(json_encode($newMembers));

node_list_forum：

<div class="{$extras.last_post_id}"></div>
<a href="{{ link('posts', {'post_id': $extras.last_post_id}) }}" class="node-extra-title" title="{$extras.last_thread_title}">{$extras.last_thread_title}</a></div>
<div class="node-extra-row">
	<div style="display:none;" id="{$extras.last_post_id}">{$extras.last_post_id}</div>
	<script src="/js/vendor/jquery/jquery-3.2.1.min.js"></script>
	<script>
		$.get('/custom/latest_posts.php', function (s) {
			var latestpostsids = JSON.parse(s);
			var post_id = $('#{$extras.last_post_id}').html();
			for(var i=0;i<latestpostsids.length;i++){
				if(latestpostsids[i]== post_id){
					$(".{$extras.last_post_id}").append('<div class="new">NEW</div>');
				}
			} 
		})		
	</script>

最终效果图：