<?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);
}
}
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 FROM node n LEFT JOIN berba b ON n.nid = b.nid WHERE n.type = "berba" AND n.body LIKE "%&middot;%&middot;%"');
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 .= '<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;
?>

<?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;
?>

<?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;
?>

<?php
print '<p>Orri honetan sarrera zaharrean ageri diren antonimoak bereizi eta dagoeneko eginda dauden loturak erakusten dira.</p>';

$abbr = 'Ant';
$result = db_queryd('SELECT b.nid, b.berba, b.aurrekoa, n.nid rnid, n.title rtitle FROM berba b LEFT JOIN node_relations r ON b.nid = r.pnid AND r.type = "Antonimo" LEFT JOIN node n ON r.nid = n.nid WHERE b.aurrekoa LIKE "%'.$abbr.'.%" AND b.aurrekoa REGEXP "[[:<:]]'.$abbr.'[[:>:]]" ORDER BY b.zki ASC');

while($row = db_fetch_object($result)){
$nodes[$row->nid] = $row;
$related[$row->nid][] = l($row->rtitle, "node/$row->rnid");
}
print '<dl>';
foreach($nodes as $node){
unset($zaku);
ereg("$abbr\.([^\.]*)\.", $node->aurrekoa, $zaku);
//$sin = explode(',', eregi_replace('\([^\)]*\)', '', strip_tags($zaku[1])));
$berba = l($node->berba, "node/$node->nid/related");
$aurrekoan = strip_tags($zaku[1]);
$beste = join($related[$node->nid], ', ');
print "<dt>$berba</dt><dd>{$aurrekoan} => $beste</dd>\n";
}
print '</dl>';

?>

<?php
print '<p>Orri honetan sarrera zaharrean ageri diren sinonimoak bereizi eta dagoeneko eginda dauden loturak erakusten dira.</p>';

$abbr = 'Sin';
$result = db_queryd('SELECT b.nid, b.berba, b.aurrekoa, n.nid rnid, n.title rtitle FROM berba b LEFT JOIN node_relations r ON b.nid = r.pnid AND r.type = "Sinonimo" LEFT JOIN node n ON r.nid = n.nid WHERE b.aurrekoa LIKE "%'.$abbr.'.%" AND b.aurrekoa REGEXP "[[:<:]]'.$abbr.'[[:>:]]" ORDER BY b.zki ASC');

while($row = db_fetch_object($result)){
$nodes[$row->nid] = $row;
$related[$row->nid][] = l($row->rtitle, "node/$row->rnid");
}
print '<dl>';
foreach($nodes as $node){
unset($zaku);
ereg("$abbr\.([^\.]*)\.", $node->aurrekoa, $zaku);
//$sin = explode(',', eregi_replace('\([^\)]*\)', '', strip_tags($zaku[1])));
$berba = l($node->berba, "node/$node->nid/related");
$aurrekoan = strip_tags($zaku[1]);
$beste = join($related[$node->nid], ', ');
print "<dt>$berba</dt><dd>{$aurrekoan} => $beste</dd>\n";
}
print '</dl>';

?>

<?php
print '<p>Orri honetan sarrera zaharrean ageri diren ikustekoak bereizi eta dagoeneko eginda dauden loturak erakusten dira.</p>';

$abbr = 'Ik';
$result = db_queryd('SELECT b.nid, b.berba, b.aurrekoa, n.nid rnid, n.title rtitle FROM berba b LEFT JOIN node_relations r ON b.nid = r.pnid AND r.type = "Ikusteko" LEFT JOIN node n ON r.nid = n.nid WHERE b.aurrekoa LIKE "%'.$abbr.'.%" AND b.aurrekoa REGEXP "[[:<:]]'.$abbr.'[[:>:]]" ORDER BY b.zki ASC');

while($row = db_fetch_object($result)){
$nodes[$row->nid] = $row;
$related[$row->nid][] = l($row->rtitle, "node/$row->rnid");
}

print '<dl>';
foreach($nodes as $node){
unset($zaku);
ereg("$abbr\.([^\.]*)\.", $node->aurrekoa, $zaku);
//$sin = explode(',', eregi_replace('\([^\)]*\)', '', strip_tags($zaku[1])));
$berba = l($node->berba, "node/$node->nid/related");
$aurrekoan = strip_tags($zaku[1]);
$beste = join($related[$node->nid], ', ');
print "<dt>$berba</dt><dd>{$aurrekoan} => $beste</dd>\n";
}
print '</dl>';
?>

<?php
$result = db_query('SELECT n.title, n.teaser, n.nid FROM `node` n LEFT JOIN term_node tn ON n.nid = tn.nid LEFT JOIN term_data td ON tn.tid = td.tid WHERE n.nid IN(156994, 157011, 157319, 157320, 157504, 157886, 158563, 159082, 159150, 159320, 159718, 159779, 159793, 159801, 160056, 160057, 160232, 160537, 160574, 161084, 161198, 161282, 161329, 161515, 161952, 162158, 162336, 162363, 162537, 162619, 162774, 162785, 162802, 162918, 162978, 162979, 163114, 163198, 163262, 163292, 163315, 163349, 163416, 163446, 163725, 163726, 163729, 163793, 163837, 163854, 163855, 163913, 164024, 164097, 164350, 164447, 164591, 164592, 164595, 164640, 164647, 164736, 164770, 164903, 165311, 165343, 165357, 165397, 165449, 165684, 165764, 165822, 165913, 165937, 166009, 166304, 166341, 166359, 166371, 166437, 166459, 166544, 166668, 166899, 167089, 167173, 167188, 167201, 167257, 167918, 167924, 167958, 168044, 168141, 168275, 168285, 168478, 168523, 168581, 168952, 169105, 169353, 169497, 169498, 169502, 169525, 169526, 169546, 169827, 169831, 169982, 170490, 170922, 170979, 171088, 171391, 171425, 171572, 171576, 171578, 171730, 171943, 171965, 171966, 171967, 172099, 172107, 172122, 172157, 172219, 172244, 172556, 172999, 173204, 173388, 173462, 173692, 173989, 174050, 174141, 174307, 174351, 174390, 174397, 174427, 174571, 174639, 174776, 174777, 174784, 174921, 175010, 175150, 175355, 175364, 201864, 201880) GROUP BY n.nid');

$output = '';
while($row = db_fetch_object($result)){
$output .= '<p>'.$row->teaser.'</p>';
}
print $output;
?>

<?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;
?>

<?php
if(isset($_POST['zeregin'])){
foreach($_POST['aldaerak'] as $k => $v){
db_queryd('UPDATE berba SET aldaerak = "%s" WHERE nid = %d', $v, $k);
}
}
$output = '';
$result = db_queryd('SELECT n.nid, n.title, n.teaser, b.aldaerak FROM {node} n LEFT JOIN {berba} b ON n.nid = b.nid WHERE n.type = "berba" AND b.aldaerak LIKE CONCAT("%", n.title, "%")');
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 .= '<input type="text" name="aldaerak['.$row->nid.']" size="50" value="'.$row->aldaerak.'" />';
$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(!user_access('administer content')){
drupal_access_denied();
} else {
print 'Konponketak egiteko erraztasunak emateko sortutako orria da hau.';
}
?>