dzodzuyengood wrote:
So there is the solution to convert topic description phpbb2 to multiple descriptions phpbb3
Before you make a Converting to phpbb3 , you must some steps follow ( not forget to backup)
step one:
Please add this sql sentence to mysql :
Code: Select all
ALTER TABLE `phpbb_topics` CHANGE `topic_desc` `topic_description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default'
step two :
edit the Modify :
Open :posting.php
find:
Code: Select all
$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode,
inline find:
inline replace with:
find:
Code: Select all
$topic_desc = ( !empty($HTTP_POST_VARS['topic_desc']) ) ? trim($HTTP_POST_VARS['topic_desc']) : '';
replace with:
Code: Select all
$topic_description = ( !empty($HTTP_POST_VARS['topic_description']) ) ? trim($HTTP_POST_VARS['topic_description']) : '';
find:
Code: Select all
prepare_post($mode, $post_data, $bbcode_on, $html_on, $smilies_on,
inline find:
inline replace with :
find:
Code: Select all
submit_post($mode, $post_data, $return_message, $return_meta, $forum_id,
inline find:
Code: Select all
, str_replace("\'", "''", $topic_desc)
inline replace with :
Code: Select all
, str_replace("\'", "''", $topic_description)
find:
Code: Select all
$topic_desc = ( !empty($HTTP_POST_VARS['topic_desc']) ) ? htmlspecialchars(trim(stripslashes($HTTP_POST_VARS['topic_desc']))) : '';
replace with :
Code: Select all
$topic_description = ( !empty($HTTP_POST_VARS['topic_description']) ) ? htmlspecialchars(trim(stripslashes($HTTP_POST_VARS['topic_description']))) : '';
find:
Code: Select all
$topic_desc = $post_info['topic_desc'];
replace with:
Code: Select all
$topic_description = $post_info['topic_description'];
find:
Code: Select all
'TOPIC_DESCRIPTION' => $topic_desc,
replace with:
Code: Select all
'TOPIC_DESCRIPTION' => $topic_description,
open: includes/functions_post.php
find:
Code: Select all
function prepare_post(&$mode, &$post_data, &$bbcode_on, &$html_on,
inline find:
inline replace with:
find:
Code: Select all
// Check Topic Desciption
if ( !empty($topic_desc) )
{
$topic_desc = htmlspecialchars(trim($topic_desc));
}
replace with :
Code: Select all
// Check Topic Desciption
if ( !empty($topic_description) )
{
$topic_description = htmlspecialchars(trim($topic_description));
}
find:
Code: Select all
function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id,
inline find:
inline replace with :
find:
Code: Select all
$sql = ($mode != "editpost") ? "INSERT INTO " . TOPICS_TABLE . " (topic_title,
inline find :
inline replace with : [code
]topic_description,[/code]
find :
inline find :
inline replace with :
find :
Code: Select all
"UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject',
inline find :
inline replace with :
Code: Select all
topic_description = '$topic_description',
open : viewforum.php
find :
Code: Select all
if ( !empty($topic_rowset[$i]['topic_desc']))
{
$topic_desc = $topic_rowset[$i]['topic_desc'];
$template->assign_block_vars('topicrow.switch_topic_desc', array(
'TOPIC_DESCRIPTION' => smilies_pass($topic_desc))
);
}
replace with :
Code: Select all
if ( !empty($topic_rowset[$i]['topic_description']))
{
$topic_description = $topic_rowset[$i]['topic_description'];
$template->assign_block_vars('topicrow.switch_topic_description', array(
'TOPIC_DESCRIPTION' => $topic_description)
);
}
find and delete :
Code: Select all
include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);
open : language/lang_english/lang_main.php
find and delete :
Code: Select all
$lang['Description'] = 'Topic Description';
open: templates/subSilver/viewforum_body.tpl
find :
Code: Select all
<!-- BEGIN switch_topic_desc -->
{L_DESCRIPTION} : {topicrow.switch_topic_desc.TOPIC_DESCRIPTION}<br />
<!-- END switch_topic_desc -->
replace with :
Code: Select all
<!-- BEGIN switch_topic_description -->
{topicrow.switch_topic_description.TOPIC_DESCRIPTION}<br />
<!-- END switch_topic_description -->
------------------------
this is okie ! your phpbb3 board will be worked directly with multiple description, when you convert from phpbb2 to phpbb3 ( if your phpbb2 board has installed Topic Description from Morpheus2matrix)
-------------------------
the sql line of phpbb2 MOD:topicdescription by Morpheus2matrix is a portion of SQL default table prefix (phpbb_topics) .then you haven´t to fear to lose topic description , if you convert default prefix table phpbb_topics with .
Ich have also one question : which convert tool do you use ??? , whenit is possible , can you give me the link , maybe i will test it