I'm trying to make it so that I can use an external payment system with CB, but in order to do that, I have to be able to sync the main users DB with CB's. I have successfully gotten the sync, but I'm not having any luck with getting things like join date and some of the other details to sync.
Here is the CRON script I've enacted, can anyone suggest more to build a complete CB profile? I'd appreciate it.
[code:1]<?php
// connect and select a database
$link = mysql_connect("localhost", "user", "pw"«»)
or die ("Couldn't connect"«»);
$db = "tsed";
mysql_select_db($db) or die("Could not select the database '" . $db
. "'. Are you sure it exists?"«»);
// perform the first SQL query
$query = "INSERT IGNORE INTO mjos_comprofiler(id,user_id) SELECT
id,id
FROM mjos_users";
$result = mysql_query($query) or die("Query failed"«»);
// perform the second SQL query
$query = "SELECT c.id FROM mjos_comprofiler c LEFT JOIN mjos_users u
ON
u.id = c.id WHERE u.id IS NULL";
$result = mysql_query($query) or die("Query failed"«»);
// close the connection
mysql_close($link);
?>[/code:1]
I'm getting a successful link of usernames, but am not getting any other details. Can someone suggest some other options?
