}
$q = "select * from prispevky where id_diskuse='" . $bigset->getString('old_id_diskuse') . "' order by id_prispevku";
$set = $db_old->query($q);
while ($set->next()) {
$set_array[] = $set->getRecord();
$prispevky[$set->getString('thread')] = $set->getString('id_prispevku');
}
foreach ($prispevky as $thread_vector => $prispevok_id) {
if (strlen($thread_vector) > 4) {
$prispevky_old_array[$prispevok_id] = $prispevky[substr($thread_vector, 0, strlen($thread_vector) - 5)];
}
}
foreach ($set_array as $set_array_item) {
$q = "insert into nodes set\nnode_name='" . addslashes($set_array_item['jmeno']) . "::" . $set_array_item['vlozeno'] . "',node_type='4'\n,old_id='" . $set_array_item['id_prispevku'] . "'\n,old_type='article'\n,node_created='" . $set_array_item['vlozeno'] . "'\n,old_id_diskuse='" . $set_array_item['id_diskuse'] . "'\n,node_creator='" . $users[$set_array_item['jmeno']] . "'";
$db->query($q);
$lid = $db->getLastInsertId();
$k = "insert into node_content set node_content='" . addslashes($set_array_item['telo']) . "',node_id='{$lid}'";
$db->query($k);
$oldidz[$set_array_item['id_prispevku']] = true;
echo $k;
}
print_r($prispevky_old_array);
foreach ($oldidz as $key => $value) {
echo "wantin key {$key}";
if ($prispevky_old_array[$key]) {
$q23 = "select node_id from nodes where old_id=" . $prispevky_old_array[$key] . " and node_type='4'";
$lal = $db->query($q23);
$lal->next();
print_r($lal);
$g = "update nodes set node_parent='" . $lal->getString('node_id') . "' where old_id={$key} and node_type='4'";
} else {
<?php
//requiring main config file with path/database etc. constants
require '../config/config.inc';
//connecting to database and creating universal $db object
require SYSTEM_ROOT . '/inc/log.inc';
require SYSTEM_ROOT . '/inc/database.inc';
$db = new CLASS_DATABASE();
$db_old = new CLASS_DATABASE("kyberia", "kyberia", "cyb3ry", "127.0.0.1");
$userset = $db->query("select old_id,node_id from nodes where node_type='7'");
while ($userset->next()) {
$old_id = $userset->getString('old_id');
$user_id = $userset->getString('node_id');
$db->query("update mail set mail_user_new='yes',mail_user='******' where mail_user='******' and mail_user_new='no'");
$db->query("update mail set mail_from_new='yes',mail_from='{$user_id}' where mail_from='{$old_id}' and mail_from_new='no'");
$db->query("update mail set mail_to_new='yes',mail_to='{$user_id}' where mail_to='{$old_id}' and mail_to_new='no'");
}
$db->query("create index uf on mail (mail_user,mail_from)");
$db->query("create index ut on mail (mail_user,mail_to)");
$userset = $db->query("select old_id,node_id from nodes where node_type='7'");
while ($userset->next()) {
$old_id = $userset->getString('old_id');
$user_id = $userset->getString('node_id');
$db->query("insert into mail_folders set user_id='{$user_id}',folder_name='sent'");
$sent_id = $db->getLastInsertId();
$db->query("insert into mail_folders set user_id='{$user_id}',folder_name='received'");
$received_id = $db->getLastInsertId();
$db->query("insert into mail_folders set user_id='{$user_id}',folder_name='trash'");
$db->query("update users set folder_id='{$sent_id}' where mail_user='******' and mail_from='{$user_id}'");
$db->query("update users set folder_id='{$received_id}' where mail_user='******' and mail_to'{$user_id}'");
}
