<?php
if(isset($_POST['zeregin'])){
extract($_POST);
db_query('UPDATE berba SET jakingarri = "%s", aipu = "%s" WHERE nid = %d', $jakingarri, $aipu, $nid);
}
theme_add_style(drupal_get_path('module', 'berba').'/style.css');
$output = '';
$result = db_query('SELECT n.nid, b.aurrekoa, n.teaser, n.title, n.body, b.aipu, b.jakingarri FROM node n LEFT JOIN berba b ON n.nid = b.nid WHERE n.type = "berba" AND ((b.jakingarri LIKE "%—-%" OR b.jakingarri LIKE "%-—%") OR ((b.aipu LIKE "%—-%" OR b.aipu LIKE "%-—%")))');
if($total = db_num_rows($result)){
while($row = db_fetch_object($result)){
$output .= '<form action="" method="post">';
$output .= '<input type="hidden" name="nid" value="'.$row->nid.'" />';
$output .= '<fieldset><legend>'.$row->nid.'</legend>';
$output .= '<p>'.l($row->title, "node/$row->nid").'</p>';
$output .= '<p>'.$row->teaser.'</p>';
$output .= '<label>Aipu</label><br /><textarea name="aipu" rows="4" cols="60">'. $row->aipu .'</textarea><br />';
$output .= '<label>Jakingarri</label><br /><textarea name="jakingarri" rows="4" cols="60">'. $row->jakingarri .'</textarea><br />';
$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;
?>
