Ejemplo n.º 1
0
            $db->query("DELETE FROM KOMMENTAR WHERE DATUM='{$modification}' AND ID='{$id}'");
            if ($db->affected_rows() < 1) {
                $be->box_full($t->translate("Error"), $t->translate("Database error"));
            }
            $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 -->
Ejemplo n.º 2
0
$be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align);
?>

<!-- content -->
<?php 
if (isset($id)) {
    $columns = "*";
    $tables = "comments,enterprise";
    $where = "enterprise.entid = comments.entid_cmt AND comments.cmtid = '{$id}'";
    if (!$db->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) {
        mysql_die($db);
    } else {
        $db->next_record();
        if ($db->f("user") == $auth->auth["uname"] || $perm->have_perm("admin")) {
            if (!isset($action)) {
                cmtmod($db);
            } else {
                $subject_cmt = trim($subject_cmt);
                $text_cmt = trim($text_cmt);
                $status_cmt = trim($status_cmt);
                if (!empty($subject_cmt)) {
                    if (!empty($text_cmt)) {
                        $tables = "comments";
                        $set = "subject_cmt='{$subject_cmt}',text_cmt='{$text_cmt}',creation_cmt='{$creation_cmt}'";
                        $where = "cmtid='{$id}'";
                        switch ($action) {
                            case "change":
                                $set = $set . ",status_cmt='{$status_cmt}'";
                                break;
                            case "delete":
                                $set = $set . ",status_cmt='D'";