[ABD]Multiple Descriptions 1.0.3 ( further to 1.0.5)

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
User avatar
Sr X
Registered User
Posts: 202
Joined: Wed Feb 07, 2007 9:25 am

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by Sr X »

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)
(...)
------------------------

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
i have done the two steps ( add the sql and modify files phpBB2) that you say, after i have install a forum test phpBB3 gold and i have added the sql of your mod:

Code: Select all

ALTER TABLE phpbb_topics ADD topic_description VARCHAR( 255 ) NOT NULL DEFAULT '';
ALTER TABLE phpbb_drafts ADD draft_description varchar(100) NOT NULL default '';
ALTER TABLE phpbb_posts ADD post_description VARCHAR( 100 ) NOT NULL DEFAULT '';
ALTER TABLE phpbb_privmsgs ADD message_description varchar(100) NOT NULL default '';
after i have converted the forum phpBB2 to phpBB3 gold but the portion in DB topic_description have not any date... :(

i use mysql4, i supposed that i should edit any file of install folder to export the dates? can you (or other person) help me?
User avatar
Sr X
Registered User
Posts: 202
Joined: Wed Feb 07, 2007 9:25 am

Convert topic description phpBB2 to Multiple Descriptions

Post by Sr X »

dzodzuyengood wrote:
murnauvsbuñuel wrote: this is the direct link to donwload "Topic Description MOD 1.0.5" (mod to phpBB2): http://www.phpbb.com/mods/db/download/1585/
thanks.

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:

Code: Select all

t.topic_desc,
inline replace with:

Code: Select all

t.topic_description,
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:

Code: Select all

, $topic_desc
inline replace with :

Code: Select all

, $topic_description
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:

Code: Select all

, &$topic_desc
inline replace with:

Code: Select all

, &$topic_description
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:

Code: Select all

, &$topic_desc
inline replace with :

Code: Select all

, &$topic_description
find:

Code: Select all

$sql  = ($mode != "editpost") ? "INSERT INTO " . TOPICS_TABLE . " (topic_title,
inline find :

Code: Select all

topic_desc,
inline replace with : [code]topic_description,[/code]

find :

Code: Select all

VALUES ('$post_subject',
inline find :

Code: Select all

'$topic_desc',
inline replace with :

Code: Select all

'$topic_description',
find :

Code: Select all

"UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject',
inline find :

Code: Select all

topic_desc = '$topic_desc',
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
http://www.phpbb.com/community/viewtopi ... a&start=45
http://www.phpbb.com/community/viewtopi ... 5&t=647315

Hi, i need convert the topic description mod to phpBB2 to phpBB3. I dont want lose the dates in topic_desc

i have read and try your post but i dont know this dont work. Can you help me please :oops:
I am a little desperate, thanks and merry christmas :(
User avatar
dzodzuyengood
Registered User
Posts: 87
Joined: Wed Mar 02, 2005 1:33 am
Contact:

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by dzodzuyengood »

sorry for my laterly answering ! because of some home works , i had not time to present you a new version of my mod

For now , i will further develop my mods .

please let me time to test my mod with phpbb3 gold .and other ways i will present you a new version soon as soon
My phpBB3 MODs Queue : Click Here
drazgo
Registered User
Posts: 52
Joined: Tue Jun 12, 2007 8:52 pm

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by drazgo »

any chance of knowing the ETA of this mod to be tested on phpbb gold?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by D¡cky »

To keep phpBB2 Topic Descriptions when you convert to phpBB3:
  1. Add Multiple Descriptions 0.3.2 to 0.3.3 phpBB3 before you convert
  2. OPEN install/convertors/convert_phpbb20.php
  3. FIND

    Code: Select all

    array('topic_title',			'topics.topic_title',				'phpbb_set_encoding'),
  4. AFTER, ADD

    Code: Select all

    array('topic_description',			'topics.topic_desc',				'phpbb_set_encoding'),
    If you did the change suggested above by dzodzuyengood,

    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'
    you will have to add instead

    Code: Select all

    array('topic_description',			'topics.topic_description',				'phpbb_set_encoding'),
Now the Topic Descriptions will be carried over from phpBB2 to phpBB3.
Last edited by D¡cky on Thu Jan 03, 2008 4:43 pm, edited 1 time in total.
Have you hugged someone today?
User avatar
dzodzuyengood
Registered User
Posts: 87
Joined: Wed Mar 02, 2005 1:33 am
Contact:

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by dzodzuyengood »

D¡cky wrote:To keep phpBB2 Topic Descriptions when you convert to phpBB3:
  1. Add Multiple Descriptions 0.3.2 to 0.3.3 phpBB3 before you convert
  2. OPEN install/convertors/convert_phpbb20.php
  3. FIND

    Code: Select all

    array('topic_title',			'topics.topic_title',				'phpbb_set_encoding'),
  4. AFTER, ADD

    Code: Select all

    array('topic_description',			'topics.topic_desc',				'phpbb_set_encoding'),
    If you did the change suggested above by dzodzuyengood,

    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'
    you will have to add instead

    Code: Select all

    array(array('topic_description',			'topics.topic_description',				'phpbb_set_encoding'),
Now the Topic Descriptions will be carried over from phpBB2 to phpBB3.
very good , thank you very much
My phpBB3 MODs Queue : Click Here
User avatar
Sr X
Registered User
Posts: 202
Joined: Wed Feb 07, 2007 9:25 am

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by Sr X »

D¡cky, a lot of thanks. It is so Easy, simple, this seems work. :)
moustafamin
Registered User
Posts: 230
Joined: Thu Aug 30, 2007 8:10 am

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by moustafamin »

hi guys,,, I want to know something...
is this mod stable enough to run on live forum???
does it work on phpBB3??
soulruins
Registered User
Posts: 3
Joined: Mon Jan 07, 2008 7:35 pm

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by soulruins »

Image
It's right? Blank?
User avatar
dzodzuyengood
Registered User
Posts: 87
Joined: Wed Mar 02, 2005 1:33 am
Contact:

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by dzodzuyengood »

I have tested my MOD with phpbb 3.0.0 , and it works perfect
there is not Bug momentarily

But I develop it to new version to corect blank sentence !
Please you have some patiences ,
my new version MOD comes soon .
My phpBB3 MODs Queue : Click Here
Balero
Registered User
Posts: 145
Joined: Tue Dec 18, 2007 10:57 am

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by Balero »

dzodzuyengood, When intends to release the new version?

Thanks and Bye ;)
User avatar
Sr X
Registered User
Posts: 202
Joined: Wed Feb 07, 2007 9:25 am

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by Sr X »

Balero wrote:dzodzuyengood, When intends to release the new version?

Thanks and Bye ;)
The typical answer is always "as soon as possible"
I suppose that is not easy, we should be patiences.

dzodzuyengood, thanks for your work!
soulruins
Registered User
Posts: 3
Joined: Mon Jan 07, 2008 7:35 pm

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by soulruins »

dzodzuyengood wrote:But I develop it to new version to corect blank sentence !
Please you have some patiences ,
my new version MOD comes soon .
Ok. No problem. Thx for excellence mod.
User avatar
dzodzuyengood
Registered User
Posts: 87
Joined: Wed Mar 02, 2005 1:33 am
Contact:

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by dzodzuyengood »

new version comes to 30 Jan 2008
Multiple Descriptions version 1.0.0a :

-Fix : blank sentence under Topic title
-add : smiles in Topic & PM Descriptions
-add : multiple descriptions to viewtopic_print.html
Compatiable with phpbb 3.0 Gold

Please , let´s me know , which function do want to have for MOD Multiple Descriptions
My phpBB3 MODs Queue : Click Here
moustafamin
Registered User
Posts: 230
Joined: Thu Aug 30, 2007 8:10 am

Re: [BETA]Multiple Descriptions 0.3.2 to 0.3.3

Post by moustafamin »

dzodzuyengood wrote:new version comes to 30 Jan 2008
Multiple Descriptions version 1.0.0a :

-Fix : blank sentence under Topic title
-add : smiles in Topic & PM Descriptions
-add : multiple descriptions to viewtopic_print.html
Compatiable with phpbb 3.0 Gold

Please , let´s me know , which function do want to have for MOD Multiple Descriptions
that's one of the greatest news today :D
BTW
Image
I think there shouldn't be this wide space between the topic title and the discription,, what do you see???
or was it fixed before?

I this the space exists between the discription and the sentence "by User on date"
Locked

Return to “[3.0.x] Abandoned MODs”