<?php
if(isset($_POST['zeregin'])){
foreach($_POST['aldaerak'] as $k => $v){
db_queryd('UPDATE berba SET aldaerak = "%s" WHERE nid = %d', $v, $k);
}
}
$output = '';
$result = db_queryd('SELECT n.nid, n.title, n.teaser, b.aldaerak FROM {node} n LEFT JOIN {berba} b ON n.nid = b.nid WHERE n.type = "berba" AND b.aldaerak LIKE CONCAT("%", n.title, "%")');
if($total = db_num_rows($result)){
while($row = db_fetch_object($result)){
$output .= '<form action="" method="post">';
$output .= '<fieldset><legend>'.$row->nid.'</legend>';
$output .= '<p>'.$row->teaser.'</p>';
$output .= '<input type="text" name="aldaerak['.$row->nid.']" size="50" value="'.$row->aldaerak.'" />';
$output .= '<input type="submit" name="zeregin" value="eguneratu" />';
$output .= '</fieldset></form>';
}
$output .= '<p>'.$total.' sarrera ageri dira.</p>';
} else {
$output .= '<p>Ez dago dagoeneko halakorik zuzentzeko.</p>';
}
print $output;
?>
