$bx->box_begin();
$bx->box_title($t->translate("Comment deleted"));
$bx->box_body_begin();
echo $t->translate("Selected Comment was deleted");
$bx->box_body_end();
$bx->box_end();
}
}
if (isset($modify)) {
if ($modify == 1) {
$query = "SELECT * FROM KOMMENTAR,DOKUMENT WHERE KOMMENTAR.DOKUMENTID='{$id}' AND DOKUMENT.ID = KOMMENTAR.DOKUMENTID AND DATUM='{$modification}'";
cmtmod($query);
}
if ($modify == 2) {
// We insert it into the DB
$db->query("UPDATE KOMMENTAR SET SUBJECT='{$subject}',KOMMENTAR='{$text}',DATUM='{$modification}' WHERE DATUM='{$modification}' AND DOKUMENTID='{$id}'");
if ($db->affected_rows() < 1) {
$be->box_full($t->translate("Error"), $t->translate("Database error"));
}
// We show what we've inserted
$query = "SELECT * FROM KOMMENTAR WHERE DATUM='{$modification}' AND DOKUMENTID='{$id}'";
cmtshow($query);
}
}
}
?>
<!-- end content -->
<?php
require "./include/footer.inc";
@page_close();
<?php
if (!isset($cnt)) {
$cnt = 0;
}
$prev_cnt = $cnt + $config_showfull_cmtperpage;
if ($cnt >= $config_showfull_cmtperpage) {
$next_cnt = $cnt - $config_showfull_cmtperpage;
} else {
$next_cnt = 0;
}
$query = cmtquery(0);
$db->query($query);
cmtsort($db, 0);
if ($db->num_rows() > 0) {
while ($db->next_record()) {
cmtshow($db, admin($db));
}
cmtnav($db, 0);
} else {
$be->box_full($t->translate("Attention!"), $t->translate("No more Comment exist") . ".");
}
?>
</td><td width=20%>
<?php
// Recent News at the right column
cmtidx($config_showshort_entperpage);
?>
</td></tr>
</table>
<!-- end content -->