<?php
if(isset($_POST['zeregin'])){
foreach($_POST['body'] as $k => $v){
//print sprintf('UPDATE node SET body = "%s" WHERE nid = %d', $v, $k);
db_queryd('UPDATE node SET body = "%s" WHERE nid = %d', $v, $k);
}
}
$output = '';
$result = db_query('select n.nid, n.title, n.teaser, n.body, b.aipu from node n left join berba b on n.nid = b.nid where n.body like concat("%", b.aipu, "%") and b.aipu != ""');
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 .= '<label>Esanahia</label><br /><textarea name="body['.$row->nid.']" rows="4" cols="60">'.$row->body.'</textarea>';
$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;
?>
