Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2011
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.29 KB | None | 0 0
  1.         if (commandLabel.equalsIgnoreCase("bclist")) {
  2.             if (CanUnlock((Player) sender)) {
  3.                 String query6 = "SELECT * FROM unlock WHERE unlock = '0';";
  4.                 ResultSet result = null;
  5.                 result = manageSQLite.sqlQuery(query6);
  6.  
  7.                 try {
  8.  
  9.                     if (result != null && result.next()) {
  10.                         int id = result.getInt("id");
  11.                         String reqname = result.getString("guestname");
  12.                         String reqtime = result.getString("reqtime");
  13.                         String pass = result.getString("password");
  14.                         Boolean unlock = result.getBoolean("unlock");
  15.  
  16.                         player.sendMessage(ChatColor.GREEN + logPrefix + "ID: " + ChatColor.RED + id + ChatColor.GREEN + " Gast: " + ChatColor.RED + reqname + ChatColor.GREEN + " Zeit: " + ChatColor.RED + reqtime + ChatColor.GREEN + " Passwort: " + ChatColor.RED + pass);
  17.                     } else {
  18.                         player.sendMessage(ChatColor.RED + logPrefix + "Keine Gäste zum freischalten");
  19.                     }
  20.                 } catch (SQLException e) {
  21.                     // TODO Auto-generated catch block
  22.                     e.printStackTrace();
  23.                 }
  24.             }
  25.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement