1 頁 (共 1 頁)

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

發表於 : 2003-04-22 00:13
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