<?php
if(isset($_POST['berrituta'])){
db_query('UPDATE berba SET berritu = 1 WHERE nid IN ('. join($_POST['nid'],',').')');
drupal_set_message(count($_POST['nid']).' sarrera eguneratu dira.');
}
$gld = 'SELECT n.teaser, p.nid, p.gako, k.gako FROM node_relations r LEFT JOIN berba p ON r.pnid = p.nid LEFT JOIN berba k ON r.nid = k.nid LEFT JOIN node n ON p.nid = n.nid WHERE p.gako != k.gako AND r.type = "Adiera" AND p.berritu = 0 ORDER BY p.zki ASC';
$count = db_num_rows(db_query($gld));
$output = '<p>'.$count.' sarrera guztira.</p><form method="post">';
$result = db_query($gld.' LIMIT 0, 50');
while($row = db_fetch_object($result)){
$output .= '<p><input type="checkbox" name="nid[]" value="'.$row->nid.'" />'.$row->teaser.'</p>';
}
$output .= '<input type="submit" name="berrituta" value="Berritu" /></form>';
print $output;
?>