<?php
if(isset($_POST['phid'])){
db_query('DELETE FROM photo_node WHERE phid = %d', $_POST['phid']);
db_query('INSERT INTO photo_node(phid, nid) VALUES(%d, %d)', $_POST['phid'], $_POST['nid']);
db_query('UPDATE photo SET rating = 1 WHERE phid = %d', $_POST['phid']);
}
$result = db_query('SELECT p.*, n.title, n.nid, n.teaser FROM `photo` p LEFT JOIN photo_node pn ON p.phid = pn.phid LEFT JOIN node n ON pn.nid = n.nid LEFT JOIN berba b ON n.nid = b.nid WHERE pn.nid = 0 AND ISNULL(rating) = 1 ORDER BY b.gako LIMIT 0, 50');
$output .= '<style>table.marko{border:1px dotted gray; margin:5px;}</style>';
while($row = db_fetch_object($result)){
$path = "argazki/$row->node_type/thumb/$row->path";
$output .= '<table class="marko">';
$output .= '<tr>
<td>'.l('<img src="'.$path.'" width="'.$row->thumb_width.'" height="'.$row->thumb_height.'" />', "photo/$row->phid", NULL, NULL, NULL, FALSE, TRUE).'</td>
<td>
Sarrera: '.$row->alt.'<br />
Egilea:'.$row->author.'<br />
Oraingo sarrera: '.$row->title.' ['.$row->nid.']<br />
Ezabatu: '.l('ezabatu', "photo/$row->phid/confirm").'
<form method="post">
<input type="hidden" name="phid" value="'.$row->phid.'" />
<input type="text" name="nid" value="'.$row->nid.'" size="12" /><input type="submit" value="bidali" /></form>
</td>
</tr>';
$output .= '<tr><td colspan="2">'.$row->teaser.'</td></tr>';
$output .= '</table>';
}
print $output;
?>
