';
mysql_connect("localhost","BBLOG_DB_USERNAME","PASSWORD");
$data = mysql_query("SELECT * FROM BBLOG_DATABASE.bB2_posts");
// set this to the current value of nid in the drupal db's "sequences" table.
// will be "1" for an empty drupal db.
$nid="1";
echo 'got '.mysql_num_rows($data).' posts from bb
';
if (mysql_connect("localhost","DRUPAL_DB_USERNAME","PASSWORD")) {
while ($d = mysql_fetch_array($data)) {
echo 'inserting '. $d["title"] . '
';
mysql_query("INSERT INTO DRUPAL_DATABASE.node SET
vid='".$nid."',
type='story',
title='".addslashes($d["title"])."',
uid='1',
status='1',
created='".$d["posttime"]."',
changed='".$d["modifytime"]."',
comment='2',
promote='1',
moderate='0',
sticky='0'")
or die($d["title"]);
mysql_query("INSERT INTO DRUPAL_DATABASE.node_revisions SET
nid='".$nid."',
vid='".$nid."',
uid='1',
title='".addslashes($d["title"])."',
body='".addslashes($d["body"])."',
teaser='".addslashes($d["body"])."',
log='',
timestamp='".$d["modifytime"]."',
format='1'")
or die($d["title"]);
$nid++;
}
mysql_query("UPDATE DRUPAL_DATABASE.sequences SET node_nid='".$nid."', node_revisions_vid='".$nid."'");
echo 'done!
';
} else {
echo 'no connection!
';
}
?>