public String ranking(String job) {
        try {
          int int1 = 0;
          int int2 = 0;
          Connection con = DatabaseConnection.getConnection();
          PreparedStatement ps = con.prepareStatement("SELECT reborns, level, world, characters.name name, job, guilds.name guildname,COUNT(eventstats.characterid) wins FROM accounts, characters LEFT JOIN guilds ON guilds.guildid = characters.guildid LEFT JOIN eventstats ON characters.id=eventstats.characterid WHERE characters.gm < 3 AND characters.job >= ? AND characters.job <= ? AND characters.world = "+getPlayer().getWorld()+" AND accountid = accounts.id AND banned = 0  GROUP BY characters.id DESC ORDER BY reborns desc, level DESC, exp DESC LIMIT 50");
               if (job.equals("warrior")) {
                    int1 = 100;
                   int2 = 132;
                 } else if (job.equals("magician")) {
                    int1 = 200;
                    int2 = 232;
                 }  else if (job.equals("bowman")) {
                    int1 = 300;
                     int2 = 322;
                 } else if (job.equals("thief")) {
                     int1 = 400;
                     int2 = 422;
                 } else if (job.equals("pirate")) {
                     int1 = 500;
                     int2 = 522;
                 } else if (job.equals("beginner")) {
                     int1 = 0;
                     int2 = 0;
                 } else if (job.equals("nobless")) {
                     int1 = 1000;
                     int2 = 1000;
                 } else if (job.equals("cyg1")) {
                     int1 = 1100;
                     int2 = 1199;
                 } else if (job.equals("cyg2")) {
                     int1 = 1200;
                     int2 = 1299;
                 } else if (job.equals("cyg3")) {
                     int1 = 1300;
                     int2 = 1399;
                 } else if (job.equals("cyg4")) {
                     int1 = 1400;
                     int2 = 1499;
                 } else if (job.equals("cyg5")) {
                     int1 = 1500;
                     int2 = 1599;
                 } else if (job.equals("aran")) {
                     int1 = 2000;
                     int2 = 2199;
                 } else if (job.equals("total")) {
                     int1 = 0;
                     int2 = 9999;

                 } else if (job.equals("me")) {
             ps = con.prepareStatement("SELECT name FROM characters WHERE world = "+getPlayer().getWorld()+" AND gm = 0 ORDER BY reborns, level DESC");
             ResultSet rs = ps.executeQuery();
                 int i = 0;
                 int lol = 0;
                 while (rs.next()) {
            i++;
            if (rs.getString("name").equals(c.getPlayer().getName())) {
                lol = i;
            }
        }
        ps.close();
        rs.close();
        if (getPlayer().isDead()){
        return ("Dude! View this when your alife kay?");
        }else{
        return ("Your current rank is number " + lol +" in this world.");
        }
    } else {
        return "";
    }
    ps.setInt(1, int1);
    ps.setInt(2, int2);
    ResultSet rs = ps.executeQuery();
    int i = 0;
    String lulul = "";
    while (rs.next()) {
        i++;
        lulul += (i + ") #e" + rs.getString("name") + "#n  ,  Reborns :  #b" + rs.getInt("reborns") +"#k  ,  Level : #r" + rs.getInt("level") + "#k \r\n");
    }
    ps.close();
    rs.close();
    return lulul;
} catch (SQLException e) {
    return "Unknown error, please report this to the admin";
}
    }