Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2014
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. //If first argument is "unvote"
  2. }else if(args[0].equalsIgnoreCase("unvote")){
  3.     try {
  4.        
  5.         //Establish database connection and generate statement
  6.         Statement st = SQLConnect.sqlConnection();
  7.         //Retrieve specified users database info
  8.         ResultSet rs = st.executeQuery("Select playername,voted,lastvote,groups FROM users WHERE playername='"+args[1]+"';");
  9.         //Get the users group count
  10.         int groups = rs.getInt("groups");
  11.         //Remove VIP or sub VIP rank from player depending on group size
  12.         if(groups == 1){
  13.             plugin.getServer().dispatchCommand(Bukkit.getConsoleSender(), "manudel " + args[1]);
  14.         }else{
  15.             plugin.getServer().dispatchCommand(Bukkit.getConsoleSender(), "manudelsub "+args[1]+" VIP");
  16.         }
  17.        
  18.         //Delete user from db
  19.         rs.rowDeleted();
  20.        
  21.         //Close ResultSet and statement
  22.         rs.close();
  23.         st.close();
  24.     } catch (Exception e) {
  25.         e.printStackTrace();
  26.     }
  27.  
  28.  
  29. //If first argument is "check"
  30. }else if(args[0].equalsIgnoreCase("check")){
  31.     try {
  32.         //Establish database connection and generate statement
  33.         Statement st = SQLConnect.sqlConnection();
  34.         //Retrieve specified users database info
  35.         ResultSet rs = st.executeQuery("Select * FROM users WHERE playername='"+args[1]+"' AND voted='false';");
  36.        
  37.        
  38.         //Display result
  39.         if(rs.getBoolean("voted")){
  40.             sender.sendMessage("This player has voted within the past 24 hours");
  41.         }else{
  42.             sender.sendMessage("This player has not voted within the past 24 hours");
  43.         }
  44.         //Close ResultSet & Statement
  45.         rs.close();
  46.         st.close();
  47.     } catch (Exception e) {
  48.         e.printStackTrace();
  49.     }
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement