<?php
if(isset($_POST['zeregin'])){
foreach($_POST['aipu'] as $k => $v){
//print sprintf('UPDATE node SET body = "%s" WHERE nid = %d', $v, $k);
db_queryd('UPDATE berba SET aipu = "%s" WHERE nid = %d', $v, $k);
}
}
$output = '';
$result = db_query('SELECT n.*, b.* FROM node n LEFT JOIN berba b ON n.nid = b.nid WHERE n.type = "berba" AND n.title = "o" ORDER BY b.zki ASC');
if($total = db_num_rows($result)){
while($row = db_fetch_object($result)){
$previous = db_fetch_object(db_query('SELECT n.*, b.* FROM node n LEFT JOIN berba b ON n.nid = b.nid WHERE n.nid = %d', $row->nid-1));
$output .= '<form action="" method="post">';
$output .= '<fieldset><legend>'.$previous->nid.'</legend>';
$output .= '<p>'.$previous->teaser.'</p>';
$output .= '<p style="color:gray">'.$previous->aurrekoa.'</p>';
$output .= '<p>'.$row->teaser.'</p>';
$output .= '<label>Aipua</label><br /><textarea name="aipu['.$previous->nid.']" rows="4" cols="60">'.$previous->aipu.'</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;
?>
