<?php
if(!user_access('administer nodes')){
drupal_access_denied();
exit;
} elseif(isset($_GET['ekin'])){
doit();
} else {
print l('Ekin', $_GET['q'], array('query' => 'ekin=1'));
}
function doit(){
$result = db_query('SELECT tn.nid, tn.tid, td.vid FROM term_node tn LEFT JOIN term_data td ON tn.tid = td.tid LEFT JOIN node n ON tn.nid = n.nid WHERE n.type = "toponimo"');
while($row = db_fetch_array($result)){
$r[$row['nid']][$row['vid']][] = $row['tid'];
}
$vids = array(5, 6, 7);
foreach($r as $k => $sail){
foreach($sail as $kk => $v){
if(in_array($kk, $vids)){
db_query('UPDATE toponimo SET s'.$kk.' = "'. join($v, ',') .'" WHERE nid = %d', $k);
}
}
}
}
?>
