";
echo "Select node for export comments, or type \"ALL\" for export of all comments";
echo "";
echo "
";
echo "";
//===============================================
$nodenum = $_POST['nodenum'];
if ($nodenum == 'ALL')
{
$mynid = db_query("SELECT n.nid FROM {node} n LEFT JOIN {vb_thread} vb ON vb.dr_nid = n.nid WHERE vb.vb_thread IS NULL");
while ($mynid0 = db_fetch_object($mynid))
{
vbexport($mynid0->nid);
}
}
if ($nodenum > 0)
{
vbexport($nodenum);
}
echo "Not exported nodes with comments
================================================================
";
mydbfetch(0);
echo "
";
echo "Exported nodes with comments
================================================================
";
mydbfetch(1);
function mydbfetch($mymode)
{
if ($mymode == 0) $mymode = "IS NULL";
if ($mymode == 1) $mymode = "> 0";
$mynode = db_query("SELECT n.nid, n.title, c.comment_count AS replays, FROM_UNIXTIME(n.created) AS date FROM {node} n LEFT JOIN {vb_thread} vb ON vb.dr_nid = n.nid, {node_comment_statistics} c WHERE c.nid = n.nid AND c.comment_count > 0 AND vb.dr_nid ".$mymode." ORDER BY n.created");
while ($mynodes = db_fetch_object($mynode))
{
$myres = "node number: ";
$myres .= $mynodes->nid;
$myres .= "...";
$myres .= "nid;
$myres .= "\">";
$myres .= $mynodes->title;
$myres .= "";
$myres .= "...";
$myres .= " created: ";
$myres .= $mynodes->date;
$myres .= " comments: ";
$myres .= $mynodes->replays;
$myres .= "
";
echo $myres;
}
$nodenum = 0;
}
function vbexport($nid0)
{
if (db_result(db_query("SELECT vb_thread FROM {vb_thread} WHERE dr_nid = %d", $nid0)) == 0 )
{
$myedit0 = db_query("SELECT c.nid, c.pid, c.subject, c.comment, 0 AS status, c.timestamp, c.uid, c.hostname AS ipaddress, c.name, 1 AS export, c.mail, c.homepage c.cid AS cid_backup FROM {comments} c WHERE c.nid = %d ORDER BY c.timestamp, c.pid ASC", $nid0);
while ($myedit = db_fetch_array($myedit0))
{
if ($myedit['pid'] == 0)
{
$myedit['pid'] = db_result(db_query('SELECT vb_thread FROM {vb_thread} WHERE dr_nid = %d', $edit['nid']));
}
else
{
$myedit['pid'] = $pidarray[$myedit['pid']]
}
comment_save($myedit);
$pidarray[$myedit['cid_backup']] = db_result(db_query("SELECT p.postid FROM "._vb_prefix()."post p WHERE p.dateline = %d", $myedit['timestamp']));
}
}
}