PHP nodes::getNodeByOldId Examples

Example #1

File: articles2node.php Project: Kyberia/Kyberia-bloodline

$db_old = new CLASS_DATABASE("kyberia", "kyberia", "cyb3ry", "127.0.0.1");
$q = "select * from articles";
$set = $db_old->query($q);
$db->query("set autocommit=0");
while ($set->next()) {
    $q = "insert into nodes set ";
    if (!is_numeric($set->getString('autor'))) {
        $node_name = $set->getString('autor') . "::" . $set->getString('nazov');
    } else {
        $node_name = $set->getString('nazov');
    }
    $node_name = addslashes(strip_tags($node_name));
    $q .= "node_name='{$node_name}'";
    $q2 = "select * from nodes where node_type='2' and old_id='" . $set->getString('id_rubrika') . "'";
    $res2 = $db->query($q2);
    $res2->next();
    $q .= ",node_parent='" . $res2->getString('node_id') . "'";
    $q .= ",node_thread_vector='" . $res2->getString('node_thread_vector') . ";" . $res2->getString('node_id') . "'";
    if (is_numeric($set->getString('autor'))) {
        $autor = nodes::getNodeByOldId($set->getString('autor'));
        $q .= ",node_creator='" . $autor['node_id'] . "'";
    } else {
        $q .= ",node_creator='548'";
    }
    $q .= "\n,node_type='5'\n,node_created='" . $set->getString('datum') . "'\n,node_views='" . $set->getString('hits') . "'\n,node_system_access='public'\n,node_external_access='yes'\n,node_children_count='" . $set->getString('prispevky') . "'\n,old_id_diskuse='" . $set->getString('id_diskuse') . "'\n,old_id='" . $set->getString('id_article') . "'";
    $db->query($q);
    echo $q;
    $q = "insert into node_content set node_content='" . AddSlashes($set->getString('short_desc')) . ":::" . AddSlashes($set->getString('text1')) . "',node_id=LAST_INSERT_ID()";
    $db->query($q);
    $db->query("commit");
}