Thread: Compiler Error

Results 1 to 8 of 8
  1. #1 Compiler Error 
    Registered Member krisnka's Avatar
    Join Date
    May 2011
    Posts
    201
    Thanks given
    50
    Thanks received
    11
    Rep Power
    0
    Compiling Error



    Sql.java

    Code:
    public static boolean saveHighScore(client clientToSave) {
    		try {
    			query("DELETE FROM `skills` WHERE playerName = '"+clientToSave.playerName+"';");
    			query("DELETE FROM `skillsoverall` WHERE playerName = '"+clientToSave.playerName+"';");
    			query("INSERT INTO `skills` (`playerName`,`Attacklvl`,`Attackxp`,`Defencelvl`,`Defencexp`,`Strengthlvl`,`Strengthxp`,`Hitpointslvl`,`Hitpointsxp`,`Rangelvl`,`Rangexp`,`Prayerlvl`,`Prayerxp`,`Magiclvl`,`Magicxp`,`Cookinglvl`,`Cookingxp`,`Woodcuttinglvl`,`Woodcuttingxp`,`Fletchinglvl`,`Fletchingxp`,`Fishinglvl`,`Fishingxp`,`Firemakinglvl`,`Firemakingxp`,`Craftinglvl`,`Craftingxp`,`Smithinglvl`,`Smithingxp`,`Mininglvl`,`Miningxp`,`Herblorelvl`,`Herblorexp`,`Agilitylvl`,`Agilityxp`,`Thievinglvl`,`Thievingxp`,`Slayerlvl`,`Slayerxp`,`Farminglvl`,`Farmingxp`,`Runecraftlvl`,`Runecraftxp`) VALUES ('"+clientToSave.playerName+"',"+clientToSave.playerLevel[0]+","+clientToSave.playerXP[0]+","+clientToSave.playerLevel[1]+","+clientToSave.playerXP[1]+","+clientToSave.playerLevel[2]+","+clientToSave.playerXP[2]+","+clientToSave.playerLevel[3]+","+clientToSave.playerXP[3]+","+clientToSave.playerLevel[4]+","+clientToSave.playerXP[4]+","+clientToSave.playerLevel[5]+","+clientToSave.playerXP[5]+","+clientToSave.playerLevel[6]+","+clientToSave.playerXP[6]+","+clientToSave.playerLevel[7]+","+clientToSave.playerXP[7]+","+clientToSave.playerLevel[8]+","+clientToSave.playerXP[8]+","+clientToSave.playerLevel[9]+","+clientToSave.playerXP[9]+","+clientToSave.playerLevel[10]+","+clientToSave.playerXP[10]+","+clientToSave.playerLevel[11]+","+clientToSave.playerXP[11]+","+clientToSave.playerLevel[12]+","+clientToSave.playerXP[12]+","+clientToSave.playerLevel[13]+","+clientToSave.playerXP[13]+","+clientToSave.playerLevel[14]+","+clientToSave.playerXP[14]+","+clientToSave.playerLevel[15]+","+clientToSave.playerXP[15]+","+clientToSave.playerLevel[16]+","+clientToSave.playerXP[16]+","+clientToSave.playerLevel[17]+","+clientToSave.playerXP[17]+","+clientToSave.playerLevel[18]+","+clientToSave.playerXP[18]+","+clientToSave.playerLevel[19]+","+clientToSave.playerXP[19]+","+clientToSave.playerLevel[20]+","+clientToSave.playerXP[20]+");");
    			query("INSERT INTO `skillsoverall` (`playerName`,`lvl`,`xp`) VALUES ('"+clientToSave.playerName+"',"+(clientToSave.getLevelForXP(clientToSave.playerXP[0]) + clientToSave.getLevelForXP(clientToSave.playerXP[1]) + clientToSave.getLevelForXP(clientToSave.playerXP[2]) + clientToSave.getLevelForXP(clientToSave.playerXP[3]) + clientToSave.getLevelForXP(clientToSave.playerXP[4]) + clientToSave.getLevelForXP(clientToSave.playerXP[5]) + clientToSave.getLevelForXP(clientToSave.playerXP[6]) + clientToSave.getLevelForXP(clientToSave.playerXP[7]) + clientToSave.getLevelForXP(clientToSave.playerXP[8]) + clientToSave.getLevelForXP(clientToSave.playerXP[9]) + clientToSave.getLevelForXP(clientToSave.playerXP[10]) + clientToSave.getLevelForXP(clientToSave.playerXP[11]) + clientToSave.getLevelForXP(clientToSave.playerXP[12]) + clientToSave.getLevelForXP(clientToSave.playerXP[13]) + clientToSave.getLevelForXP(clientToSave.playerXP[14]) + clientToSave.getLevelForXP(clientToSave.playerXP[15]) + clientToSave.getLevelForXP(clientToSave.playerXP[16]) + clientToSave.getLevelForXP(clientToSave.playerXP[17]) + clientToSave.getLevelForXP(clientToSave.playerXP[18]) + clientToSave.getLevelForXP(clientToSave.playerXP[19]) + clientToSave.getLevelForXP(clientToSave.playerXP[20]))+","+((clientToSave.playerXP[0]) + (clientToSave.playerXP[1]) + (clientToSave.playerXP[2]) + (clientToSave.playerXP[3]) + (clientToSave.playerXP[4]) + (clientToSave.playerXP[5]) + (clientToSave.playerXP[6]) + (clientToSave.playerXP[7]) + (clientToSave.playerXP[8]) + (clientToSave.playerXP[9]) + (clientToSave.playerXP[10]) + (clientToSave.playerXP[11]) + (clientToSave.playerXP[12]) + (clientToSave.playerXP[13]) + (clientToSave.playerXP[14]) + (clientToSave.playerXP[15]) + (clientToSave.playerXP[16]) + (clientToSave.playerXP[17]) + (clientToSave.playerXP[18]) + (clientToSave.playerXP[19]) + (clientToSave.playerXP[20]))+");");
    		} catch (Exception e) {
    			e.printStackTrace();
    			return false;
    		}
    		return true;
    	}
    }

    Code:
    	SQL.createConnection();
    		SQL.saveHighScore(this);
    		SQL.destroyConnection();
    Reply With Quote  
     

  2. #2  
    Registered Member
    Join Date
    Nov 2010
    Posts
    93
    Thanks given
    8
    Thanks received
    0
    Rep Power
    6
    just comment all of it out.
    Reply With Quote  
     

  3. #3  
    Registered Member krisnka's Avatar
    Join Date
    May 2011
    Posts
    201
    Thanks given
    50
    Thanks received
    11
    Rep Power
    0
    thats not fixing the error though and if i do that my highscores wont work...
    Reply With Quote  
     

  4. #4  
    Registered Member
    Join Date
    Nov 2010
    Posts
    93
    Thanks given
    8
    Thanks received
    0
    Rep Power
    6
    Oh, you're actually using SQL. I thought you just wanted to run it.
    Reply With Quote  
     

  5. #5  
    Registered Member krisnka's Avatar
    Join Date
    May 2011
    Posts
    201
    Thanks given
    50
    Thanks received
    11
    Rep Power
    0
    i still need HELP~!!!!!!!!!!



    ILL REP AND THANK
    Reply With Quote  
     

  6. #6  
    Registered Member

    Join Date
    Oct 2011
    Age
    28
    Posts
    1,880
    Thanks given
    311
    Thanks received
    557
    Rep Power
    703
    Make sure you're importing your SQL class in Client.java
    Reply With Quote  
     

  7. Thankful user:


  8. #7  
    Registered Member krisnka's Avatar
    Join Date
    May 2011
    Posts
    201
    Thanks given
    50
    Thanks received
    11
    Rep Power
    0
    whats the import?????
    Reply With Quote  
     

  9. #8  
    Registered Member

    Join Date
    Oct 2011
    Age
    28
    Posts
    1,880
    Thanks given
    311
    Thanks received
    557
    Rep Power
    703
    import server.model.mobile.players.SQL;
    Reply With Quote  
     

  10. Thankful user:



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. Compiler error
    By Cyradis in forum Help
    Replies: 3
    Last Post: 05-21-2011, 11:55 AM
  2. Compiler Error
    By kiwishaun in forum Help
    Replies: 0
    Last Post: 07-08-2010, 03:51 AM
  3. Compiler Error.
    By Ghimroid in forum Help
    Replies: 4
    Last Post: 02-24-2010, 08:31 AM
  4. [HELP] Compiler error [HELP]
    By happyisbackk in forum Help
    Replies: 6
    Last Post: 07-06-2009, 12:16 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •