} $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}'"); }