[教學] 讓會員的文章數在刪文後不減

[Mac]

Stop Post Count Decreasing（讓文章數不減）
Stop Post Count Decreasing when deleting "posts"（刪除文章後讓會員文章總數不減）

functions_post.php
找到下面的字串:

代碼: 選擇全部

//
// Update post stats and details
//
function update_post_stats(&$mode, &$post_data, &$forum_id, &$topic_id, &$post_id, &$user_id)
{
	global $db;

	$sign = ($mode == 'delete') ? '- 1' : '+ 1';

把它替換成:

代碼: 選擇全部

//
// Update post stats and details
//
function update_post_stats(&$mode, &$post_data, &$forum_id, &$topic_id, &$post_id, &$user_id)
{
	global $db;

	$sign = ($mode == 'delete') ? '- 1' : '+ 1';
///
/// Begin edit
///
	$edited_sign = ($mode == 'delete') ? '0' : '+ 1';

///
/// End edit
///

然後找到下面這一串字

代碼: 選擇全部

	if ($mode != 'poll_delete')
	{
	
		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $sign 
			WHERE user_id = $user_id";
			

		
			
		if (!$db->sql_query($sql, END_TRANSACTION))

把它替換成（把 $sign 換成 $edited_sign）:

代碼: 選擇全部

	if ($mode != 'poll_delete')
	{
	
		$sql = "UPDATE " . USERS_TABLE . "
			SET user_posts = user_posts $edited_sign 
			WHERE user_id = $user_id";
			

		
			
		if (!$db->sql_query($sql, END_TRANSACTION))

===============================================
Stop Post Count Decreasing when deleting "Topics"（刪除主題後讓會員文章總數不減）

modcp.php

把下面的字串移除\r

代碼: 選擇全部

			while ( $row = $db->sql_fetchrow($result) )
			{
				$count_sql[] = "UPDATE " . USERS_TABLE . " 
					SET user_posts = user_posts - " . $row['posts'] . " 
					WHERE user_id = " . $row['poster_id'];
			}

P.S. 具 phpbb 官方指出，如果一個版面的設定為自動刪文（auto prune）
會員的文章數不會減少

~Mac