Kyberia v2.3 - 1st revision from SVN (Without patches of kyberia.sk team)

[mirrors/Kyberia-bloodline.git] / scripts / fix_db.php

diff --git a/scripts/fix_db.php b/scripts/fix_db.php
new file mode 100644 (file)
index 0000000..91a6eae
--- /dev/null
+++ b/scripts/fix_db.php
@@ -0,0 +1,30 @@
+<?
+require('config/config.inc');
+require('node_types.php');
+require(SYSTEM_ROOT.'inc/log.inc');
+require(SYSTEM_ROOT.'inc/nodes.inc');
+require(SYSTEM_ROOT.'inc/database.inc');
+
+$db=new CLASS_DATABASE();
+
+$q = "select distinct parent.node_id as parent_node_id from nodes left join nodes as parent on parent.node_id = nodes.node_parent where nodes.node_system_access = 'public' and parent.node_system_access = 'private' order by parent_node_id";
+
+$set = $db->query($q);
+echo "Updating security access for ".$set->getNumRows()." nodes ...<br>";
+while($set->next())
+{
+       $parents[] = $set->getString('parent_node_id');
+}
+
+foreach($parents as $parent)
+{
+       echo "Updating node $parent ... ";
+       $query = "update nodes set node_system_access = 'private' where node_system_access = 'public' and node_parent = '$parent'";
+       $set = $db->query($query);
+//     echo $query;
+       echo "done<br>";
+}
+
+//print_r($parents);
+
+?>