<?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;
?>
<?php
if(isset($_POST['eguneratu'])){
db_queryd('UPDATE berba SET aipu = "%s", jakingarri = "%s" WHERE nid = %d', $_POST['aipu'], $_POST['jakingarri'], $_POST['nid']);
db_queryd('UPDATE node SET body = "%s" WHERE nid = %d', $_POST['body'], $_POST['nid']);
}
theme_add_style(drupal_get_path('module', 'berba').'/style.css');
$output = '';
$sql = '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 "%“%" AND (b.jakingarri LIKE "%"%" OR b.jakingarri LIKE "%\"%")) OR (b.jakingarri LIKE "%”%" AND (b.jakingarri LIKE "%"%" OR b.jakingarri LIKE "%\"%")) OR (b.jakingarri LIKE "%»%" AND (b.jakingarri LIKE "%"%" OR b.jakingarri LIKE "%\"%")) OR (b.jakingarri LIKE "%”%" AND (b.jakingarri LIKE "%"%" OR b.jakingarri LIKE "%\"%"))) OR ((n.body LIKE "%“%" AND (n.body LIKE "%"%" OR n.body LIKE "%\"%")) OR (n.body LIKE "%”%" AND (n.body LIKE "%"%" OR n.body LIKE "%\"%")) OR (n.body LIKE "%»%" AND (n.body LIKE "%"%" OR n.body LIKE "%\"%")) OR (n.body LIKE "%”%" AND (n.body LIKE "%"%" OR n.body LIKE "%\"%")))';
$result = db_query($sql .' LIMIT 0, 25');
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>'.l($row->title, "node/$row->nid").'</p>';
$output .= '<p>'.$row->teaser.'</p>';
$output .= '<input type="hidden" name="nid" value="'.$row->nid.'" />';
$output .= '<label>Esanahia</label><br /><textarea name="body" rows="4" cols="60">'.$row->body.'</textarea>';
$output .= '<label>Aipua</label><br /><textarea name="aipu" rows="4" cols="60">'.$row->aipu.'</textarea>';
$output .= '<label>Jakingarri</label><br /><textarea name="jakingarri" rows="4" cols="60">'.$row->jakingarri.'</textarea>';
$output .= '<input type="submit" name="eguneratu" value="eguneratu" />';
$output .= '</fieldset></form>';
}
$total = db_num_rows(db_query($sql));
$output .= '<p>'.$total.' sarrera ageri dira.</p>';
} else {
$output .= '<p>Ez dago dagoeneko halakorik zuzentzeko.</p>';
}
print $output;
?>
