竹貓星球

問題外掛：Attachment Mod 240a
參考連結：N/A
使用版本：phpBB 2.0.18
網站位置：自行架設測試.無法公開
狀況描述： 乾淨的phpBb 2.0.18 裝Attachment Mod 240a 後測試所發生的問題

1.我上傳依張圖片後要回覆主題卻發生錯誤
Parse error: syntax error, unexpected $end in c:\appserv\www\phpbb2\includes\topic_review.php on line 243

我按照install.doc安裝的.也重裝好幾次了.都無法解決問題~

我的 topic_review.php程式碼如下(紅色字為我修改的部份)
<?php
/***************************************************************************
* topic_review.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : support@phpbb.com
*
* $Id: topic_review.php,v 1.5.2.3 2004/11/18 17:49:45 acydburn Exp $
*
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
*
***************************************************************************/

function topic_review($topic_id, $is_inline_review)
{
global $db, $board_config, $template, $lang, $images, $theme, $phpEx, $phpbb_root_path;
global $userdata, $user_ip;
global $orig_word, $replacement_word;
global $starttime;

if ( !$is_inline_review )
{
if ( !isset($topic_id) || !$topic_id)
{
message_die(GENERAL_MESSAGE, 'Topic_post_not_exist');
}

//
// Get topic info ...
//
$sql = "SELECT t.topic_title, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f
WHERE t.topic_id = $topic_id
AND f.forum_id = t.forum_id";
$tmp = '';
attach_setup_viewtopic_auth($tmp, $sql);
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
}

if ( !($forum_row = $db->sql_fetchrow($result)) )
{
message_die(GENERAL_MESSAGE, 'Topic_post_not_exist');
}
$db->sql_freeresult($result);

$forum_id = $forum_row['forum_id'];
$topic_title = $forum_row['topic_title'];

//
// Start session management
//
$userdata = session_pagestart($user_ip, $forum_id);
init_userprefs($userdata);
//
// End session management
//

$is_auth = array();
$is_auth = auth(AUTH_ALL, $forum_id, $userdata, $forum_row);

if ( !$is_auth['auth_read'] )
{
message_die(GENERAL_MESSAGE, sprintf($lang['Sorry_auth_read'], $is_auth['auth_read_type']));
}
}

//
// Define censored word matches
//
if ( empty($orig_word) && empty($replacement_word) )
{
$orig_word = array();
$replacement_word = array();

obtain_word_list($orig_word, $replacement_word);
}

//
// Dump out the page header and load viewtopic body template
//
if ( !$is_inline_review )
{
$gen_simple_header = TRUE;

$page_title = $lang['Topic_review'] . ' - ' . $topic_title;
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
'reviewbody' => 'posting_topic_review.tpl')
);
}

//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
WHERE p.topic_id = $topic_id
AND p.poster_id = u.user_id
AND p.post_id = pt.post_id
ORDER BY p.post_time DESC
LIMIT " . $board_config['posts_per_page'];
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain post/user information', '', __LINE__, __FILE__, $sql);
}
init_display_review_attachments($is_auth);
//
// Okay, let's do the loop, yeah come on baby let's do the loop
// and it goes like this ...
//
if ( $row = $db->sql_fetchrow($result) )
{

$valid = FALSE;
if( $userdata['session_logged_in'] ) {
$sql = "SELECT u.user_id, u.user_level
FROM " . USERS_TABLE . " u
WHERE u.user_id = " . $userdata['user_id'] . "
AND u.user_posts >= 10";
$resultat = $db->sql_query($sql);
$valid = $db->sql_numrows($resultat) ? TRUE : FALSE;

$mini_post_img = $images['icon_minipost'];
$mini_post_alt = $lang['Post'];

$i = 0;
do
{
$poster_id = $row['user_id'];
$poster = $row['username'];

$post_date = create_date($board_config['default_dateformat'], $row['post_time'], $board_config['board_timezone']);

//
// Handle anon users posting with usernames
//
if( $poster_id == ANONYMOUS && $row['post_username'] != '' )
{
$poster = $row['post_username'];
$poster_rank = $lang['Guest'];
}
elseif ( $poster_id == ANONYMOUS )
{
$poster = $lang['Guest'];
$poster_rank = '';
}

$post_subject = ( $row['post_subject'] != '' ) ? $row['post_subject'] : '';

$message = $row['post_text'];
$bbcode_uid = $row['bbcode_uid'];

//
// If the board has HTML off but the post has HTML
// on then we process it, else leave it alone
//
if ( !$board_config['allow_html'] && $row['enable_html'] )
{
$message = preg_replace('#(<)([\/]?.*?)(>)#is', '<\2>', $message);
}

if ( $bbcode_uid != "" )
{
$message = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message);
$message = bbencode_third_pass($message, $bbcode_uid, $valid);
}

$message = make_clickable($message);

if ( count($orig_word) )
{
$post_subject = preg_replace($orig_word, $replacement_word, $post_subject);
$message = preg_replace($orig_word, $replacement_word, $message);
}

if ( $board_config['allow_smilies'] && $row['enable_smilies'] )
{
$message = smilies_pass($message);
}

$message = str_replace("
", '<br />', $message);

//
// Again this will be handled by the templating
// code at some point
//
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

$template->assign_block_vars('postrow', array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,

'MINI_POST_IMG' => $mini_post_img,
'POSTER_NAME' => $poster,
'POST_DATE' => $post_date,
'POST_SUBJECT' => $post_subject,
'MESSAGE' => $message,

'L_MINI_POST_ALT' => $mini_post_alt)
);
display_review_attachments($row['post_id'], $row['post_attachment'], $is_auth);

$i++;
}
while ( $row = $db->sql_fetchrow($result) );
}
else
{
message_die(GENERAL_MESSAGE, 'Topic_post_not_exist', '', __LINE__, __FILE__, $sql);
}
$db->sql_freeresult($result);

$template->assign_vars(array(
'L_AUTHOR' => $lang['Author'],
'L_MESSAGE' => $lang['Message'],
'L_POSTED' => $lang['Posted'],
'L_POST_SUBJECT' => $lang['Post_subject'],
'L_TOPIC_REVIEW' => $lang['Topic_review'])
);

if ( !$is_inline_review )
{
$template->pparse('reviewbody');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
}

?>

\r
2.進入後台管理 副檔名控制
一進去就有錯誤訊息\r
Warning: mysql_free_result(): 46 is not a valid MySQL result resource in c:\appserv\www\phpbb2\db\mysql4.php on line 318


有請各位大大能幫忙看看我哪裡改錯了~謝謝

經過初步檢視, 發現您貼的檔案, 並非是以原始的 phpbb 2.0.18 做修改.
因為裡頭出現了以下代碼: 第二個問題, 爬個文應該不難解決; 最近才有人提過類似的問題.

hi all,

first post here

I have upgrade my phpbb to 2.0.18, attachment mod to 2.4.0
(with old attachment mod language pack v 2.3.9)
but having problem in display chinese character correctly...

Is the new language pack for 2.4.0 going to release soon?
thanks

yes~~
u can go to the phpbb.com
it display these


Language & Image Packs
phpBB2 has been localised into several languages by a dedicated team of translators. All official packs are listed below, please note that we cannot support language sets downloaded from other sites.

Installation
To install a language pack simply decompress the downloaded package into the languages/ directory. It will immediately become available to all users.

Do not forget to download the related subSilver package, this contains localised button images for the default subSilver style. These should be decompressed in the templates/ directory. Support for these is automatic when the appropriate language is utilised.

Remember when decompressing the package that you must retain the directory or folder structure. If you are unsure how to do this with your software please check its documentation. Failure to retain the directory structure will result in the language not being available.

New Translations
If your language is not listed below and you have the time please feel free to start a new translation. It is not particularly difficult to do but will take some time. Before starting please first read our Knowledge Base article. There you can find whether an existing person is already working on your language. If not you will also find details of how to go about localising phpBB2.