Banana-Coding.com - Java Knuddels Emulator

Java-Quelltext

import tools.*;
import knuddels.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import tools.database.ConnectionPool;
import tools.database.PoolConnection;
import java.text.DecimalFormat;
import java.util.Random;
 
public class ping {
   
    private static DecimalFormat df;
   static {
               df = new DecimalFormat("0.0000");
    }
   
   public static void make(String arg, Client client, Channel channel) {
    if (arg.equals("null")) {
       
         PoolConnection pcon9 = ConnectionPool.getConnection();
             PreparedStatement ps9 = null;
             
        try {
            Connection con = pcon9.connect();
            ps9 = con.prepareStatement("SELECT * FROM accounts where pinguser = '"+client.getName()+"'");
            ResultSet rs9 = ps9.executeQuery();
            while(rs9.next()) {
             
              float lol = (float)((float)(System.currentTimeMillis() - rs9.getLong("pingstart")) / 1000);
              float time = Float.parseFloat(df.format(lol).replace(",", "."));
                   
              String ausgabe = df.format(time);
              ausgabe = ausgabe.replace(",",".");
if (rs9.getString("name").equals(client.getName())) {
     client.sendButlerMessage(channel.getName(), String.format("...Pong von Dir! ("+ausgabe+" Sekunden)"));
          tools.query.update("update accounts set pinguser='', pingstart='' where name='"+client.getName()+"'");
   
            } else {
            String nicknamen = KCodeParser.escape(rs9.getString("name"));
            Client target;
            boolean online = true;
            target = Server.get().getClient(nicknamen);
               if (target == null) {
                    online = false;
                    target = new Client(null);
                    target.loadStats(nicknamen);
 
               }
               nicknamen = target.getName();
        target.sendButlerMessage(channel.getName(), String.format("...Pong von "+client.getName()+"! ("+ausgabe+" Sekunden)"));
          tools.query.update("update accounts set pinguser='', pingstart='' where name='"+target.getName()+"'");
    }
             }
        }catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (ps9 != null) {
                try {
                    ps9.close();
                } catch (SQLException e) {
                }
            }
 
            pcon9.close();
        }
       
    } else {
if (arg.isEmpty()) {
    arg = client.getName();
}
       
            String nicknamen = KCodeParser.escape(arg);
            Client target;
            boolean online = true;
            target = Server.get().getClient(nicknamen);
               if (target == null) {
                    online = false;
                    target = new Client(null);
                    target.loadStats(nicknamen);
 
               }
               nicknamen = target.getName();
               
       
          if (nicknamen == null) {
                client.sendButlerMessage(channel.getName(), GlobalMessages.UserNotFound(arg));
                return;
         }
 
          if (!online) {
              client.sendButlerMessage(channel.getName(), GlobalMessages.UserIsOffline(target));
              return;
          }

     client.sendButlerMessage(channel.getName(), String.format("Ping %s...", target.getName()));
//und zwar hier
     tools.query.update("update accounts set pinguser='"+target.getName()+"', pingstart='"+System.currentTimeMillis()+"' where name='"+client.getName()+"'");  
    //und zwar hier
     knuddels.CommandParser.parse("/ping null", target,channel);
   }}}