Important phpBB Migrator: Looking for phpBB3 users that want to convert their data to Kunena 1.6

<?php /* * This is a script that will retrieve the user uploaded avatar names and puts them in the Kunena database * You need to manually move these images to the Kunena avatars folder. * Adjust to your own needs when needed */ /* * Generates avatar filename from the database entry */ function get_avatar_filename($avatar_entry, $avatar_salt) { global $config; $avatar_group = false; $ext = substr(strrchr($avatar_entry, '.'), 1); $avatar_entry = intval($avatar_entry); return $avatar_salt . '_' . (($avatar_group) ? 'g' : '') . $avatar_entry . '.' . $ext; } /* 1. Set some variables */ $dbhost = 'localhost'; $dbuser = 'your_db_username'; $dbpass = 'your_db_password'; $dbname = 'your_db_name'; $phpbb_prefix = "phpbb3_"; $joomla_prefix = "jos_"; /* 2. Connect to DB */ $db = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db($dbname); /* 3. Get the avatar salt (say what??) from phpbb3_config */ $sql = "SELECT config_value FROM `{$phpbb_prefix}config` WHERE config_name = 'avatar_salt'"; $result = mysql_query($sql); $avatar_salt = mysql_fetch_row($result); $avatar_salt = $avatar_salt[0]; /* 4. Get the information we need from the corresponding tables */ $sql = "SELECT user_avatar, user_avatar_type, a.username as u_name, b.id as juserid FROM `{$phpbb_prefix}users` as a LEFT JOIN `{$joomla_prefix}users` as b ON a.username = b.username WHERE a.user_avatar_type = 1"; $result = mysql_query($sql); /* Create an array with all objects in it */ while ($row = mysql_fetch_object($result)) { $array[] = $row; } /* 5. Update the table jos_kunena_user with the right entries */ foreach ($array as $entry) { if ($entry->juserid > 0) { /* Create the real name for the avatar file */ $avatar_name = get_avatar_filename($entry->user_avatar, $avatar_salt); $sql2 = "UPDATE `{$joomla_prefix}kunena_users` SET avatar = 'users/$avatar_name' WHERE userid = '$entry->juserid' "; $action = mysql_query($sql2) or die('Could not update database for '.$avatar_name); } } /* 6. Copy the avatars from the PHPBB3 folder(/phpbb3/images/avatars/upload) to the kunena folder (/media/avatars/users) * This is a manual action, but I know there are some smartypants out there that can script this as well. */ echo "Please copy al the avatars from <span style=\"font-weight:bold;\">phpBB3/images/avatars/upload</span> to <span style=\"font-weight:bold;\">media/avatars/users</span>";