• Welcome to Simple Machines Community Forum. Please login or sign up.
September 17, 2021, 10:05:30 PM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

SleePy

what modification date?
When they edited the posts?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

allymcbeal

Yes, when they edited the posts.  :-[

SleePy

Do you have a snippet from the phpbb database showing this data?
I don't want to go download phpbb and get it installed (my local test site is very messed up right now).

For the most part, is it worth it? This minor detail isn't something I see as very important considering you got your members, boards, and data (ie posts/topics). The others are usually bonuses. :P
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

allymcbeal

Hi, thanks for the reply.
You are right the others are bonuses, but I'd like to see the modification of users... :(

I send you a snippet. ;)


SleePy

I meant from the database so I can look at things like the column names, and the type of text in these...

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

allymcbeal


allymcbeal

Is true this? Maybe I don't have understand very well. :)

SleePy

No.
I looked at the converter and it does have the column for converting the edited colums :|

I don't see where phpbb2 is holding who edited it though as that is not converted..
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

allymcbeal

I send you best photo, maybe you can find what you need to help me. :)

SleePy

Do you have a database dump you can email me?
It may help me better than my test database. As well if you could point out topics with these modified messages so it would help me during the conversion tests.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

ThorstenE

i have  tested with a new phpbb installation and it did not save any data in the related table fields (post_edit_time). do you have any hacks installed in your phpbb doing this?

SleePy

ThorstenE,

If you manually edit those values they show up in the post that you edited them. I just can't figure how where its keeping track of the user who edited it last..
SMF wont show a modified string if there is no user attached to it.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

ThorstenE

June 26, 2008, 04:08:28 AM #492 Last Edit: June 26, 2008, 12:37:24 PM by ThorstenE
Quote from: SleePy on June 26, 2008, 01:50:23 AM
If you manually edit those values they show up in the post that you edited them.
yes, after manual editing the fields phpbb shows:
QuoteLast edited by Test on Sat Oct 21, 2000 12:01 am; edited 1 time in total
The conversion-file takes the data correct to smf_messages, but does not display it because modifiedName column is empty. The primary problem is, that phpbb does not store the user who has modified the message.

IF (p.post_edit_time >0, SUBSTRING(IF(IFNULL(p.post_username, '') = '', u.username, p.post_username), 1, 255), '') AS modifiedName, should fix it. This is exactly what phpbb does..

allymcbeal, try the attached version..

Edit: Attachment removed, new version is here:
http://www.simplemachines.org/community/index.php?topic=142124.msg1592822#msg1592822

allymcbeal

June 26, 2008, 09:20:27 AM #493 Last Edit: June 26, 2008, 10:23:56 AM by allymcbeal
HI, thanks for the reply.
Sleepy I try to make a dump.

ThorstenE  sorry, I don't understand well, first I use convert.php and the your new file? Is it right?

Ah no it is sql...so I don't now how to use... :-[

ThorstenE

i updated the above file (sorry, my mistake)..

the phpbb2_to_smf.sql is part of the Conversion: Convert.php is the script used in Browser, it calls a myforum_to_smf.sql for conversion (phpbb_to_smf.sql for you). Replace the existing file with the one attached in my post above. this is a fixed version and should show the "edit by" information after conversion.

allymcbeal

June 26, 2008, 10:37:06 AM #495 Last Edit: June 26, 2008, 10:44:47 AM by allymcbeal
Ok, I did it, but now he give me this mistake:

Fatal error: Call to undefined function copy_dir() in /var/www/vhost/allymcbeal.it/home/html/smf1/convert.php(665) : eval()'d code on line 20

No, wait now I download again your update file.


Don't work, it give me this error.

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting avatar gallery images...
Fatal error: Call to undefined function copy_dir() in /var/www/vhost/allymcbeal.it/home/html/smf1/convert.php(665) : eval()'d code on line 20

ThorstenE

ok, i think you are using the outdated converter-files from the download-page. try the convert.php from this topic: http://www.simplemachines.org/community/index.php?topic=140741.0 (attachment at the end of the message)

allymcbeal

Thanks for your help. :)
yes I used the converter-file on the dowload-page.

Now it works, but the modify date threre aren't.

ThorstenE

is your phpbb customized and stores edit_dates in other columns than post_edit_time and post_edit_count or in a seperate table? browse table smf_messages with PHPMyAdmin and click on the column modifiedTime (for sorting). is there any data converted?

allymcbeal

June 26, 2008, 11:51:34 AM #499 Last Edit: June 26, 2008, 12:48:11 PM by allymcbeal
I have they in php_post (not text)
I show you an image.


Advertisement: