Beste iturrietako aipamenak

<?php

$iturriak = array(
'AA ArrasEus' => 'AA[^\)]*ArrasEus',
'AA BergEus' => '\(AA[^\)]*BergEus\)',
'AAG Eibes' => '\(AAG[^\)]*Eibes\)',
'Aran Gatz' => '\(Aran[^\)]*Gatz\)',
'Etxba Eib' => '\(Etxba[^\)]*Eib\)',
'Izag Antz' => '\(Izag[^\)]*Antz\)',
'Izag Oñ' => '\(Izag[^\)]*Oñ\)',
'Lar Antz' => '\(Lar[^\)]*Antz\)',
'Orm Aram' => '\(Orm[^\)]*Aram\)',
'Saras Hegaz' => '\(Saras[^\)]*Hegaz\)',
'SB Eibetno' => '\(SB[^\)]*Eibetno\)',
'SM' => '\(SM[^\)]*\)',
'SM Burdin' => '\(SM[^\)]*Burdin\)',
'SM Ezten' => '\(SM[^\)]*Ezten\)',
'SM Zirik' => '\(SM[^\)]*Zirik\)',
'TSE Berb' => '\(TSE[^\)]*Berb\)',
'Zuaz Deb' => '\(Zuaz[^\)]*Deb\)',
);

if(isset($_POST['zeregin'])){
//print sprintf('UPDATE node SET body = "%s" WHERE nid = %d', $_POST['body'], $_POST['nid']);
db_query('UPDATE node SET body = "%s" WHERE nid = %d', $_POST['body'], $_POST['nid']);
//print sprintf('UPDATE berba SET aipu = "%s", checked = 1 WHERE nid = %d', $_POST['aipu'], $_POST['nid']);
db_query('UPDATE berba SET aipu = "%s", checked = 1 WHERE nid = %d', $_POST['aipu'], $_POST['nid']);
}

theme_add_style(drupal_get_path('module', 'berba').'/style.css');

foreach($iturriak as $k => $v){
$links[] = l($k, 'node/202050', array(), "iturri=$k");
}
$output = join($links, ' | ');

$iturri = !isset($_REQUEST['iturri']) ? 'AA ArrasEus' : $_REQUEST['iturri'];
$pattern = $iturriak[$iturri];
$result = db_query('SELECT n.nid, n.title, b.aurrekoa, n.body, n.teaser, b.aipu FROM node n LEFT JOIN berba b ON n.nid = b.nid WHERE b.checked != 1 AND b.aurrekoa RLIKE "'.$pattern.'" LIMIT 0, 25');

if($total = db_num_rows($result)){
while($row = db_fetch_object($result)){
unset($zaku);
ereg('.*“(.*)<i>(.*)” ?\((.*)\).*', $row->aurrekoa, $zaku);
print_r($zaku);
$output .= '<form action="" method="post">';
$output .= '<fieldset><legend>'.$row->title.'</legend>';
$output .= '<p>'.$row->teaser.'</p>';
$output .= '<p style="color:gray">'.$row->aurrekoa.'</p>';
$output .= '<input type="hidden" name="nid" value="'.$row->nid.'" />';
$output .= '<input type="hidden" name="iturri" value="'.$iturri.'" />';
$output .= '<div style="text-align:right"><input type="submit" name="zeregin" value="eguneratu" /></div>';
$output .= '<label>Esanahia</label><br /><textarea name="body" rows="3" cols="60">'.$row->body.'</textarea><br />';
$output .= '<label>Aipu</label><br /><textarea name="aipu" rows="3" cols="60">'.$row->aipu.'</textarea>';
$output .= '</fieldset></form>';
}
$output .= '<p>'.$total.' sarrera ageri dira.</p>';
} else {
$output .= '<p>Ez dago dagoeneko halakorik zuzentzeko.</p>';
}
print $output;
?>