$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 -->
$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'";