Thread: A Command

Results 1 to 7 of 7
  1. #1 A Command 
    Registered Member
    Join Date
    Feb 2010
    Posts
    63
    Thanks given
    0
    Thanks received
    0
    Rep Power
    1
    Hey guys i'm trying to make a command so that when you type it, it grabs information from a mysql database and then gives you the item you donated for.

    Code:
    if (playerCommand.startsWith("donated")) {
    			if (!Config.MYSQL_ACTIVE) {
    				c.sendMessage("Sorry this is currently disabled.");
    				return;
    			} else {
    				try {
    					String name2 = c.playerName.replaceAll(" ","_");
    					PreparedStatement ps = Database.getConnection().prepareStatement("SELECT * FROM `donation` WHERE `username` = '"+name2+"'");
    					ResultSet rs = ps.executeQuery();
    					boolean b = false;
    					if(rs.next()){
    						int prod = Integer.parseInt(rs.getString("productid"));
    						int price = Integer.parseInt(rs.getString("price"));
    							if(prod == 1 && price == 3.50){
    								c.playerRights = 4;
    								c.isDonator = 1;
    								b = true;
    							} else if(prod == 2 && price == 2.50){
    								c.getItems().addItem(15241,1);
    								c.getItems().addItem(15243,500);
    								b = true;
    							} else if(prod == 3 && price == 10.00){
    								c.getItems().addItem(13450,1);
    								b = true;
    							} else if(prod == 4 && price == 8.50){
    								c.getItems().addItem(13452,1);
    								b = true;
    							} else if(prod == 5 && price == 7.00){
    								c.getItems().addItem(13451,1);
    								b = true;
    							} else if(prod == 6 && price == 6.00){
    								c.getItems().addItem(13453,1);
    								b = true;
    							} else if(prod == 7 && price == 10.00){
    								c.getItems().addItem(13458,1);
    								c.getItems().addItem(13459,1);
    								c.getItems().addItem(13460,1);
    								b = true;
    							} else if(prod == 8 && price == 10.00){
    								c.getItems().addItem(13362,1);
    								b = true;
    							} else if(prod == 9 && price == 10.00){
    								c.getItems().addItem(13358,1);
    								b = true;
    							} else if(prod == 10 && price == 10.00){
    								c.getItems().addItem(13360,1);
    								b = true;
    							} else if(prod == 11 && price == 8.00){
    								c.getItems().addItem(13350,1);
    								b = true;
    							} else if(prod == 12 && price == 8.00){
    								c.getItems().addItem(13348,1);
    								b = true;
    							} else if(prod == 13 && price == 8.00){
    								c.getItems().addItem(13346,1);
    								b = true;
    							} else if(prod == 14 && price == 8.00){
    								c.getItems().addItem(13355,1);
    								b = true;
    							} else if(prod == 15 && price == 8.00){
    								c.getItems().addItem(13354,1);
    								b = true;
    							} else if(prod == 16 && price == 8.00){
    								c.getItems().addItem(13352,1);
    								b = true;
    							} else if(prod == 17 && price == 17.50){
    								c.getItems().addItem(1042,1);
    								b = true;
    							} else if(prod == 18 && price == 15.00){
    								c.getItems().addItem(1044,1);
    								b = true;
    							} else if(prod == 19 && price == 15.00){
    								c.getItems().addItem(1040,1);
    								b = true;
    							} else if(prod == 20 && price == 15.00){
    								c.getItems().addItem(1038,1);
    								b = true;
    							} else if(prod == 21 && price == 13.50){
    								c.getItems().addItem(1046,1);
    								b = true;
    							} else if(prod == 22 && price == 17.50){
    								c.getItems().addItem(1048,1);
    								b = true;
    							} else if(prod == 23 && price == 11.00){
    								c.getItems().addItem(1057,1);
    								b = true;
    							} else if(prod == 24 && price == 11.00){
    								c.getItems().addItem(1055,1);
    								b = true;
    							} else if(prod == 25 && price == 11.00){
    								c.getItems().addItem(1053,1);
    								b = true;
    							} else if(prod == 26 && price == 10.00){
    								c.getItems().addItem(1050,1);
    								b = true;
    							} else if(prod == 27 && price == 6.00){
    								c.getItems().addItem(1419,1);
    								b = true;
    							} else if(prod == 28 && price == 10.00){
    								c.getItems().addItem(1037,1);
    								b = true;
    							} else if(prod == 29 && price == 12.50){
    								c.getItems().addItem(18349,1);
    								b = true;
    							} else if(prod == 30 && price == 12.50){
    								c.getItems().addItem(18353,1);
    								b = true;
    							} else if(prod == 31 && price == 4.00){
    								c.getItems().addItem(11730,1);
    								b = true;
    							} else if(prod == 32 && price == 5.00){
    								c.getItems().addItem(11283,1);
    								b = true;
    							} else if(prod == 33 && price == 12.50){
    								c.getItems().addItem(13887,1);
    								c.getItems().addItem(13893,1);
    								c.getItems().addItem(13899,1);
    								b = true;
    							} else if(prod == 34 && price == 12.50){
    								c.getItems().addItem(13884,1);
    								c.getItems().addItem(13890,1);
    								c.getItems().addItem(13896,1);
    								c.getItems().addItem(13902,1);
    								b = true;
    							} else if(prod == 35 && price == 11.00){
    								c.getItems().addItem(13870,1);
    								c.getItems().addItem(13873,1);
    								c.getItems().addItem(13876,1);
    								b = true;
    							} else if(prod == 36 && price == 11.00){
    								c.getItems().addItem(13858,1);
    								c.getItems().addItem(13861,1);
    								c.getItems().addItem(13864,1);
    								c.getItems().addItem(13867,1);
    								b = true;
    							} else if(prod == 37 && price == 5.00){
    								c.getItems().addItem(8839,1);
    								c.getItems().addItem(8840,1);
    								c.getItems().addItem(8841,1);
    								c.getItems().addItem(8842,1);
    								c.getItems().addItem(11663,1);
    								c.getItems().addItem(11664,1);
    								c.getItems().addItem(11665,1);
    								b = true;
    							} else if(prod == 38 && price == 10.00){
    								c.getItems().addItem(10400,1);
    								c.getItems().addItem(10402,1);
    								b = true;
    							} else if(prod == 39 && price == 10.00){
    								c.getItems().addItem(10404,1);
    								c.getItems().addItem(10406,1);
    								b = true;
    							} else if(prod == 40 && price == 10.00){
    								c.getItems().addItem(10408,1);
    								c.getItems().addItem(10410,1);
    								b = true;
    							} else if(prod == 41 && price == 10.00){
    								c.getItems().addItem(10412,1);
    								c.getItems().addItem(10414,1);
    								b = true;
    							} else if(prod == 42 && price == 10.00){
    								c.getItems().addItem(10416,1);
    								c.getItems().addItem(10418,1);
    								b = true;
    							} else if(prod == 43 && price == 10.00){
    								c.getItems().addItem(10420,1);
    								c.getItems().addItem(10422,1);
    								b = true;
    							} else if(prod == 44 && price == 1.00){
    								c.getItems().addItem(1042,1);
    								b = true;
    							} 	
    					} else {
    						c.sendMessage("You haven't donated or we havn't received your payment.");
    					}
    					if(b){
    						ps = Database.getConnection().prepareStatement("DELETE FROM `donation` WHERE `username` = '"+name2+"';");
    					}
    					ps.close();
    				} catch (Exception e) {
    					e.printStackTrace();
    				}
    			}
    			return;
    			}
    It compiles and executes without an error but the player doesn't receive the item... Help please?
    Reply With Quote  
     

  2. #2  
    q.q


    Join Date
    Dec 2010
    Posts
    6,519
    Thanks given
    1,072
    Thanks received
    3,535
    Rep Power
    4752
    your parsing ints then checking for doubles
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Feb 2010
    Posts
    63
    Thanks given
    0
    Thanks received
    0
    Rep Power
    1
    Quote Originally Posted by Harlan View Post
    your parsing ints then checking for doubles
    How should it be then
    Reply With Quote  
     

  4. #4  
    q.q


    Join Date
    Dec 2010
    Posts
    6,519
    Thanks given
    1,072
    Thanks received
    3,535
    Rep Power
    4752
    double price = Double.parseDouble(rs.getString("price"));
    Reply With Quote  
     

  5. #5  
    Registered Member
    Join Date
    Feb 2010
    Posts
    63
    Thanks given
    0
    Thanks received
    0
    Rep Power
    1
    Still fails to give the item and also fails to delete from the database.
    Reply With Quote  
     

  6. #6  
    q.q


    Join Date
    Dec 2010
    Posts
    6,519
    Thanks given
    1,072
    Thanks received
    3,535
    Rep Power
    4752
    Quote Originally Posted by EliteScapePVP View Post
    Still fails to give the item and also fails to delete from the database.
    use outprints and find where its failing
    Reply With Quote  
     

  7. #7  
    Registered Member
    Join Date
    Feb 2010
    Posts
    63
    Thanks given
    0
    Thanks received
    0
    Rep Power
    1
    [11/10/11 2:54 AM]: TRY WORKS
    [11/10/11 2:54 AM]: rs.next Loads
    [11/10/11 2:54 AM]: SENT ITEM

    It fails on giving the user the item, and then deleting the row
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 50
    Last Post: 04-17-2014, 02:19 PM
  2. Replies: 3
    Last Post: 07-02-2011, 01:57 AM
  3. Replies: 4
    Last Post: 12-21-2010, 09:36 PM
  4. Replies: 4
    Last Post: 12-19-2010, 11:46 PM
  5. Replies: 4
    Last Post: 02-13-2009, 12:32 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •