Banana-Coding.com - Java Knuddels Emulator

Java-Quelltext

package handler;   
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import knuddels.Client;
import knuddels.Server;
import tools.KCodeParser;
import tools.database.ConnectionPool;
import tools.database.PoolConnection;
import tools.popup.Popup;
     
    /**
     *
     * @author uncopyable
     */
    public class MessageHandler {
        public static void handle(String[] tokens, Client client) {

               if (tokens[1].equals("msent")) { 
                   
                String empfänger = tokens[3];
                String sender = client.getName();
                String betreff = tokens[4];
                String message = tokens[5];
                String wert;
              
                message = KCodeParser.parse(message,client.isModerator(), 5, 10, 20);
                message = Server.get().parseSmileys(message); 
               
                wert = sender + " " + betreff + " " + message + " ";
              
                
                
                
                
                PoolConnection pcon = ConnectionPool.getConnection();
                PreparedStatement ps = null;

                try {
                Connection con = pcon.connect();
                ps = con.prepareStatement("UPDATE `accounts` SET `message` = ? WHERE `name` = ?");
                ps.setString(1, wert);
                ps.setString(2, empfänger);
                ps.executeUpdate();
                } catch (SQLException e) {
                             e.printStackTrace();
                }
                finally {
                    if (ps != null) {
                try {
                   ps.close();
                } catch (SQLException e) {

                   }
                }

               pcon.close();
               }
                
             client.sendButlerMessage(client.getChannel().getName(), String.format("Ich werde es nicht vergessen und _°>_h%s|/serverpp "<r°_ schnellstmöglich ausrichten.", empfänger));   
      
         
            String recipient = empfänger;
            String[] recipients = recipient.split(",");
            List<Client> targets = new ArrayList<Client>();
            Client target;
            for (String rcp : recipients) {
                rcp = KCodeParser.escape(rcp);

                if (rcp.isEmpty()) {
                    continue;
                }

              target   = Server.get().getClient(rcp);
                
                if (target == null) {
                } else if (!targets.contains(target)) {
                    targets.add(target);
                }
            }

            if (targets.isEmpty()) {
                return;
            }
         
            Server.get().getButler().sendPrivateMessage(targets, String.format("_°>_h%s|/serverpp "<r°_ hat dir gerade Post geschrieben. Du kannst sie mit _°BB>finger.b.gif<>/m|/m<r°_ abholen.", sender), Server.get().getClient(empfänger).getChannel(), false);
              
     }
            
        }
  
            }

Java-Quelltext

 } else if (cmd.equals("m")) {
            
            if (arg.equals("")) {
                client.wait = false; 
         
                PoolConnection pcon = ConnectionPool.getConnection();
        PreparedStatement ps = null;
      

        try {
            Connection con = pcon.connect(); 
      
            ps = con.prepareStatement("SELECT * FROM `accounts` WHERE `name` = ?");
            ps.setString(1, client.getName());
            ResultSet rs = ps.executeQuery();
			
            if (rs.next()) {
                String wert = rs.getString("message");  
                
                if (wert.isEmpty()){
                
                    client.sendButlerMessage(client.getChannel().getName(), "Es liegen leider keine Nachrichten für dich vor.");   
      
                } else {
                    

                    
                String temp[];
                temp = wert.split(" "); 
                String sender = temp[0];
                String betreff =temp[1];
                String messag = temp[2];
                

                
                
               
                StringBuilder whois = new StringBuilder();
                
                messag = KCodeParser.parse(messag,client.isModerator(), 5, 10, 20);
                messag = Server.get().parseSmileys(messag); 
                
                whois.append("Eine Nachricht wurde für dich hinterlegt:##");
                whois.append(String.format("_Von_:°%%25°°>_h%s|/serverpp "<r°°%%00#°", sender));
                whois.append(String.format("_Gesendet_:°%%25°%s°%%00°#", "01.08.2011")); // datum 
                whois.append(String.format("_Betreff_:°%%25°%s°%%00°##", betreff));
                whois.append(messag);
               
               // hier noch antworten, antworten mit zitat weiterleiten usw..
                
                String popup = Popup.create("Dein Briefkasten", "Dein Briefkasten", whois.toString(), 550, 400);
                client.send(popup);
                
                 PoolConnection pcon1 = ConnectionPool.getConnection();
                PreparedStatement ps1 = null;

                try {
                Connection con1 = pcon1.connect();
                ps1 = con.prepareStatement("UPDATE `accounts` SET `message` = ? WHERE `name` = ?");
                ps1.setString(1, "");
                ps1.setString(2, client.getName());
                ps1.executeUpdate();
                } catch (SQLException e) {
                             e.printStackTrace();
                }
                finally {
                    if (ps != null) {
                try {
                   ps.close();
                } catch (SQLException e) {

                   }
                }

               pcon.close();
               }
                
                
               } 
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (ps != null) {
                try {
                    ps.close();
                } catch (SQLException e) {
                }
            }

            pcon.close();
        }
                      
                  
     
                
                
                 }
            if (!arg.isEmpty()) {
            Popup popup = new Popup("Eine /m schreiben", "Eine /m schreiben", "", 430, 16);
            Panel panel1 = new Panel();
            TextField textField = new TextField(53,arg);
            TextArea textArea = new TextArea(15,65,"");
            TextField textField1 = new TextField(53,"Re");

            panel1.addComponent(new Label("An (Nick):"));
            panel1.addComponent(textField);
            popup.addPanel(panel1);
            
            Panel panel2 = new Panel();
            panel2.addComponent(new Label("Betreff:    "));
            panel2.addComponent(textField1);
            popup.addPanel(panel2);
            
            Panel panel3 = new Panel();
            panel3.addComponent(new Label("Nachricht:                                                                                                    "));
            popup.addPanel(panel3);
            
            Panel panel4 = new Panel();
            panel4.addComponent(textArea);
            popup.addPanel(panel4);

            Panel panel5 = new Panel();
            Button button = new Button("Senden");
            button.enableAction();
            panel5.addComponent(button);
            panel5.addComponent(new Button("Schließen"));
            popup.addPanel(panel5);
            popup.setOpcode(ReceiveOpcode.MMessage.getValue(), "msent");
            client.send(popup.toString()); 
            
            }