Skip to main content

Taxonomiako informazioa nodoen taulatan jaso (grabaketa)

<p>
<br />
<?php
if(!user_access('administer nodes')){
drupal_access_denied();
exit;
}

if(isset($_GET['ekin'])){
ekin();
} else {
print '<p>Script honek taxonomian jasotako informazioa edukien taulan eransten du:'. l('ekin', $_GET['q'], array('query' => 'ekin=1')) .'</p>';
}

function ekin(){
$nodes = array();
$result = db_query('SELECT n.nid, tn.tid FROM node n LEFT JOIN term_node tn ON n.nid = tn.nid WHERE n.type = "grabaketa"');
while($row = db_fetch_object($result)){
$nodes[$row->nid][] = $row->tid;
}
// print_r($nodes);
foreach($nodes as $nid => $tids){
db_query('UPDATE grabaketa SET tids = "%s" WHERE nid = %d', join($tids,','), $nid);
}
}

?></p>