1 package forum; 2 3 import java.io.*; 4 import javax.servlet.*; 5 import javax.servlet.http.*; 6 import java.util.*; 7 8 9 public class ChangeMessage extends HttpServlet { 10 11 DBConnectie db = new DBConnectie(Variable.getDb(),Variable.getDbLogin(),Variable.getDbPassword()); 12 13 public void doPost(HttpServletRequest request, HttpServletResponse response) 14 throws ServletException, IOException{ 15 16 PrintWriter out = response.getWriter(); 17 18 try{ 19 20 HttpSession session = request.getSession(true); 21 String sessionUsername = (String )session.getAttribute("username"); 22 String sessionType = (String )session.getAttribute("type"); 23 24 String forum_id = request.getParameter("forum_id"); 25 String start = request.getParameter("start"); 26 String reqThread_id = request.getParameter("thread_id"); 27 String reqReply_id = request.getParameter("reply_id"); 28 String message = request.getParameter("message"); 29 message = Filter.filterAll(message); 30 31 int changeDifference = (((100 * message.length()) / Utilities.getMessageLength(forum_id,reqThread_id,reqReply_id))); 32 33 34 java.util.Date date_time = new java.util.Date (); 35 36 37 message += "<!-- begin --!><BR><BR><I>Edited by " + sessionUsername + " - " + date_time + " (" + changeDifference + "%)</I><!-- end --!>"; 38 39 db.connect(); 40 41 if(sessionType.equals("Admin")){ 42 db.query( 43 "UPDATE forum_message " + 44 "SET message =\"" + message + "\"" + 45 "WHERE forum_id=\"" + forum_id + "\" AND thread_id =\"" + reqThread_id + "\" AND reply_id=\"" + reqReply_id + "\""); 46 }else{ 47 db.query( 48 "UPDATE forum_message " + 49 "SET message =\"" + message + "\"" + 50 "WHERE forum_id=\"" + forum_id + "\" AND thread_id =\"" + reqThread_id + "\" AND reply_id=\"" + reqReply_id + "\" AND user=\""+ sessionUsername + "\""); 51 } 52 53 response.sendRedirect(Variable.getForumPath() + "index.jsp?page=message&forum_id=" + forum_id + "&thread_id=" + reqThread_id +"&start=" + start); 54 55 db.close(); 56 }catch(Exception e){out.println(e);} 57 } 58 } | Popular Tags |