News:

Wondering if this will always be free?  See why free is better.

Main Menu

[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 ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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 ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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 ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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 ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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 ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

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 ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ThorstenE

#492
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

#493
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

#495
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

#499
I have they in php_post (not text)
I show you an image.


Advertisement: