Hi, thanks for your reply
We already tried the synchronize button but it doesn't work the way we wanted it. I build a small custom script to transfer our OSE membership first name and last name into the comprofiler table (could have been from Joomla user too). Here's the script :
Code:
<?php
$username = "";
$database = "";
$password = "";
$hostname = "";
$prefix = "";
//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
$selected = mysql_select_db($database,$dbhandle)or die("Could not select examples");
mysql_set_charset('utf8',$dbhandle);
$sql = "SELECT user_id,firstname,lastname FROM `".$prefix."_osemsc_billinginfo`";
$result = mysql_query($sql) or die( mysql_error() );
while($row = mysql_fetch_assoc($result)) {
mysql_query("UPDATE ".$prefix."_comprofiler SET firstname = '".addslashes($row['firstname'])."', lastname= '".addslashes($row['lastname'])."' WHERE user_id = ".$row['user_id'].";") or die( mysql_error() );
}
?>
Thanks for your help anyway.
krileon
