竹貓星球

因為不想他們灌水

Unincrement User Posts
http://www.phpbbhacks.com/download/2155

這個外掛有二個地方要修正
1.SQL語法 請將zeta換成你資料表的prefix
例如 phpbb

2.admin/admin_forums.php 這樣才能正常運作

~倉木麻衣~ 寫:Unincrement User Posts
http://www.phpbbhacks.com/download/2155

這個外掛有二個地方要修正
1.SQL語法

代碼: 選擇全部

# 
#-----[ SQL ]------------------------------------------ 
# 
ALTER TABLE `[color=blue]zeta[/color]_forums` ADD `forum_count_posts` TINYINT( 1 ) DEFAULT '1' NOT NULL AFTER `forum_last_post_id`;

請將zeta換成你資料表的prefix
例如 phpbb

2.admin/admin_forums.php

代碼: 選擇全部

# 
#-----[ FIND ]----------
# 

         $sql = "UPDATE " . FORUMS_TABLE . " 
            SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . " 
            WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]); 

# 
#-----[ IN-LINE FIND ]---------- 
# 
intval($HTTP_POST_VARS['forumstatus']) . ", 

# 
#-----[ IN-LINE AFTER, ADD ]---------- 
# 
forum_count_posts = " . intval($HTTP_POST_VARS['count_posts']) . ",

# 
#-----[ SAVE/CLOSE ALL FILE ]---------- 
#
# EoM

這樣才能正常運作

sql那裏加入?

gz2909 寫:sql那裏加入?

當然到你的 phpmyadmin 加入