Esempio n. 1
0
            $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 -->