Berbatako azpisarrerak antolatu

<?php
if(isset($_GET['ekin'])){
$result = db_queryd('SELECT nr.nid, nr.type, b.berba FROM node_relations nr LEFT JOIN berba b ON nr.nid = b.nid LEFT JOIN node_relations nr2 ON nr.pnid = nr2.nid WHERE nr.type = "adiera" OR (nr.type = "Esamolde" AND nr2.type = "adiera")');
while($row = db_fetch_object($result)){
$r[$row->nid] = $row->type;
$b[$row->nid] = array('nid' => $row->nid, 'berba' => $row->berba);
}

ksort($r);

foreach($r as $k => $v){
if($v == "adiera"){
$last_parent = $k;
} else {
$nr[$last_parent][] = $k;
}
}

foreach($nr as $k => $v){
foreach($v as $n){
//db_queryd('UPDATE node_relations SET pnid = %d WHERE nid = %d AND type = "Esamolde"', $k, $b[$n]['nid']);
print sprintf('UPDATE node_relations SET pnid = %d WHERE nid = %d AND type = "Esamolde"', $k, $b[$n]['nid']).';<br />';
}
}
} else {
print l('ekin', 'node/201921', array(), 'ekin=1');
}
?>