> debug user
$q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
left join users on nodes.node_creator=users.user_id where node_name='request for access' and node_parent=2091448 and
k>=5";
/*
$q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
left join users on nodes.node_creator=users.user_id where node_name!='request for access' and node_parent=2091448 and
k>=3 and user_id=2110364";
*/
$set=$db->query($q);
while ($set->next()) {
$noda=$set->getString('node_id');
$login=$set->getString('login');
echo "User ";
echo $set->getString('login');
echo "
Jeho noda:: ";
echo $set->getString('node_id');
echo "
";
echo " pocet hlasov:: ";
echo $set->getString('k');
echo "
";
$q="update users set header_id=0 where user_id=$noda";
echo $q;
$db->update($q);
echo "
";
$q="update nodes set node_name='$login' where node_id=$noda";
echo $q;
$db->update($q);
echo "
";
$q="update nodes set external_link='db://user' where node_id=$noda";
echo $q;
$db->update($q);
echo "
";
$q="update nodes set template_id=7 where node_id=$noda";
echo $q;
$db->update($q);
echo "
";
$q="update nodes set node_parent=0 where node_id=$noda";
echo $q;
$db->update($q);
echo "
";
$q="update nodes set node_vector='0$noda' where node_id=$noda";
echo $q;
$db->update($q);
echo "
";
$q="select node_id from nodes where node_vector like '020914480$noda%'";
echo $q;
echo "
";
$subset=$db->query($q);
while ($subset->next()) {
$subnoda=$subset->getString('node_id');
$q="update nodes set node_vector='0$noda"."0$subnoda' where node_id=$subnoda";
echo " ";echo $q;echo '
';
$db->update($q);
}
echo "
";
echo "