PHPBB3 to Vbulletin avatar problem

[hgumus]

Hello, I am unable to use avatars with vbullettin e impex. I wonder how to do this in a way helps to watch, do you need? Impex avatars with a reputation to attract phpbb3 wonder what needs to write the file path?

[Steve Machol]

Use the full and complete path to the directory containing those phpBB avatars. On Unix/Linux systems you can find the complete path name by telnetting or sshing into your server, going to that directory and typing:

pwd

[MagnusT]

I've tried impex from phpbb 3.09 to VB 4.19 on both a Linux and windows server. Everything else seems fine but avatars don't convert over to the new forum. On both test servers I entered the full path "/var/www/site1/phpbb3/images/avatars/upload" and "G:\www root\site1\phpBB3\images\avatars\upload" resepectively but no avatars were copied over. I was unsure if it was prevented by file system write rights so I made sure everyone/other had full write rights everywhere (this is a testsite not reachable from the outside ;-)

- Is there anything I've missed? Write rights fixed. What else?
- Should i have a trailing slash/backslash in the paths I enter?
- Should I use forward slashes instead of backslashes on the windows server?
- Heeeeeeelp! ;-)

[Zachery]

It is likely avatars not importing is a bug, it happens, in the grand scheme of things avatars not importing is not a high priority to get fixed. REporting the bug in the impex project will be the fastest way to get it resolved.

[Trevor Hannant]

W

• Import usergroup
• Import user
• Import forum
• Import thread
• Import smilie
• Import post
• Import Private messages
• Import attachment
• Import moderator

https://www.vbulletin.com/docs/html/impex_phpBB3

e don't import avatars from phpBB:

[espacioprofundo]

It's rather simple. Vbulletin is trying to get the avatars with the correct name from the phpbb avatars table, but phpbb 3.0.7 has a "salt" on the filename, like;

459d8127e4cc07e98ba026b94d334d56_3107.jpg

where 459d8127e4cc07e98ba026b94d334d56_ (with an underscore) is the salt and 3107.jpg is the avatar filename. If you remove the SALT on the filenames (pretty simple with excel) and point Impex to the directory with the renamed files avatars will be imported without problem.

Keep in mind that the salt varies on each phpbb install and you should perform the renaming on a new directory, just in case things go wrong. I've did that and worked. Another forum software asks during a migration for the SALT on avatars filenames, it should be included on IMPEX for phpbb version 3.0.x migrations.

Best Regards!

Rick

[user-1231235234532]

Thanks for the help Wayne !

[Hartmut]

Any idea what I need to write in this box ?:
"What is the full path to your avatars directory ? (make sure the web server has access to read them)."

Guess this:

The old phpbb3 avatar directory is located here:
/domains/xyz.com/public_html/images/avatars

Make sure you followed espacioprofundo his hint with the avatars.

[user-1231235234532]

Thanks for the help Wayne !

[Trevor Hannant]

It should be the full server path you use. To make sure you have the full path, upload this file to the directory, navigate to it in your browser then copy and paste the contents into that field

[user-1231235234532]

Thanks for the help Wayne !

[Trevor Hannant]

Don't edit the filenames as Impex reads the data in the database - it will reference the file s as they're named on your server. By changing the file names, they now won't be refereneced correctly.

[user-1231235234532]

Thanks for the help Wayne !

[Pogo]

This explains in more detail why it can't work in the current ImpEx version:

https://www.vbulletin.com/forum/showthread.php/344591-ImpEx-does-not-handle-PHPBB3-avatars-correctly

Just removing the salt from the filename might not be enough because the user_avatar field in the phpbb3 users database includes a timestamp in many cases.
So espacioprofundo is correct but will leave some avatars unimported.


It would be easier to modify the 004.php ImpEx file, remove the dateline from user_avatar value and add the hash to the filename ImpEx is trying to import.
Ok, it's not really that easy.

Find this code in impex/systems/phpbb3/004.php

            if ($sessionobject->get_session_var('get_avatars') AND $data['user_avatar'] != NULL AND $data['user_avatar'] != '/')
            {
                if(strstr($data['user_avatar'],'http://'))
                {
                    //Its a url
                    $try->set_value('nonmandatory', 'avatar',trim($data['user_avatar']));
                }
                else
                {
                    // Its going to be in the images/avatars/ dir somewhere hopefully.
                    $ava_path = $sessionobject->get_session_var('get_avatars_path');

                    if(substr($data['user_avatar'],-1) == '/')
                    {
                        $try->set_value('nonmandatory', 'avatar',$ava_path . trim($data['user_avatar']));

                    }
                    else
                    {
                        $try->set_value('nonmandatory', 'avatar',$ava_path . '/' . trim($data['user_avatar']));
                    }
                }
            } 

and change it to

            if ($sessionobject->get_session_var('get_avatars') AND $data['user_avatar'] != NULL AND $data['user_avatar'] != '/')
            {
                $data['user_avatar'] = preg_replace("#(\_[0-9]{10}\.)#si", '.', $data['user_avatar']); #pogo
                if(strstr($data['user_avatar'],'http://'))
                {
                    //Its a url
                    $try->set_value('nonmandatory', 'avatar',trim($data['user_avatar']));
                }
                else
                {
                    // Its going to be in the images/avatars/ dir somewhere hopefully.
                    $ava_path = $sessionobject->get_session_var('get_avatars_path');

                    if(substr($data['user_avatar'],-1) == '/')
                    {
                        #$try->set_value('nonmandatory', 'avatar',$ava_path . trim($data['user_avatar'])); #pogo
                        $try->set_value('nonmandatory', 'avatar',$ava_path . '10e5449b06ef6c68d68881f1170bd2cf_' . trim($data['user_avatar'])); #pogo

                    }
                    else
                    {
                        #$try->set_value('nonmandatory', 'avatar',$ava_path . '/' . trim($data['user_avatar'])); #pogo
                        $try->set_value('nonmandatory', 'avatar',$ava_path . '/' . '10e5449b06ef6c68d68881f1170bd2cf_' . trim($data['user_avatar'])); #pogo
                    }
                }
            } 

Obviously replace 10e5449b06ef6c68d68881f1170bd2cf_ with your hash you find in every filename of your PHPB3 avatars.

This will import a lot more avatars but probably not all of them because it doesn't handle gallery avatars.