랭킹 스크립트

/*
제작자 : ljw5992@naver.com / dbg_yeane@nate.com
주석 삭제 금지
수정자 : 츠니군
*/

 

importPackage(java.mysql);
importPackage(java.lang);
importPackage(Packages.database);

 

var rank = MYSQL.getConnection().prepareStatement("SELECT * FROM characters WHERE gm = 0 ORDER BY level DESC LIMIT 5").executeQuery();

 

function start() {
var i = 0;
        var print = new StringBuilder();
        while (rank.next()) {
            i++;
            switch(rank.getInt("job")){
                case 3600:
                case 3610:
                case 3611:
                case 3612:
                    job = "제논";
                    break;
                case 2001:
                case 2200:
                case 2210:
                case 2211:
                case 2212:
                case 2213:
                case 2214:
                case 2215:
                case 2216:
                case 2217:
                case 2218:
                    job = "에반";
                    break
                case 6001:
                case 6500:
                case 6510:
                case 6511:
                case 6512:
                    job = "엔젤릭버스터";
                    break;
                case 6000:
                case 6100:
                case 6110:
                case 6111:
                case 6112:
                    job = "카이저";
                    break;
                case 6001:
                case 6500:
                case 6510:
                case 6511:
                case 6512:
                    job = "엔젤릭버스터";
                    break;
                case 2004:
                case 2700:
                case 2710:
                case 2711:
                case 2712:
                    job = "루미너스";
                    break;
                case 3001:
                case 3100:
                case 3110:
                case 3111:
                case 3112:
                    job = "데몬슬레이어";
                    break;
                case 3002:
                case 3101:
                case 3120:
                case 3121:
                case 3122:
                    job = "데몬어벤져";
                    break;
                case 3001:
                case 3100:
                case 3110:
                case 3111:
                case 3112:
                    job = "데몬슬레이어";
                    break;
                case 2002:
                case 2300:
                case 2310:
                case 2311:
                case 2312:
                    job = "메르세데스";
                    break;
                case 430:
                    job = "세미듀어러";
                    break;
                case 431:
                    job = "듀어러";
                    break;
                case 432:
                    job = "듀얼마스터";
                    break;
                case 433:
                    job = "슬래셔";
                    break;
                case 434:
                    job = "듀얼블레이드";
                    break;
                case 2003:
                case 2400:
                case 2410:
                case 2411:
                case 2412:
                    job = "팬텀";
                    break;
                case 5000:
                case 5100:
                case 5110:
                case 5111:
                case 5112:
                    job = "미하일";
                    break;
                case 3500:
                case 3512:
                case 3511:
                case 3512:
                    job = "메카닉";
                    break;
                case 1500:
                case 1510:
                case 1511:
                case 1512:
                    job = "스트라이커";
                    break;
                case 1100:
                case 1110:
                case 1111:
                case 1112:
                    job = "소울마스터";
                    break;
                case 1200:
                case 1210:
                case 1211:
                case 1212:
                    job = "플레임위자드";
                    break;
                case 1400:
                case 1410:
                case 1411:
                case 1412:
                    job = "나이트워커";
                    break;
                case 1300:
                case 1310:
                case 1311:
                case 1312:
                    job = "윈드브레이커";
                    break;
                case 3300:
                case 3310:
                case 3311:
                case 3312:
                    job = "와일드 헌터";
                    break;
                case 2500:
                case 2510:
                case 2511:
                case 2512:
                    job = "은월";
                    break;
                case 100:
                    job = "검사";
                    break;
                case 200:
                    job = "마법사";
                    break;
                case 300:
                    job = "궁수";
                    break;
                case 400:
                    job = "도적";
                    break;
                case 500:
                    job = "해적";
                    break;
                case 501:
                    job = "해적(캐논슈터)";
                    break;
                case 110:
                    job = "파이터";
                    break;
                case 111:
                    job = "크루세이더";
                    break;
                case 112:
                    job = "히어로";
                    break;
                case 120:
                    job = "페이지";
                    break;
                case 121:
                    job = "나이트";
                    break;
                case 122:
                    job = "팔라딘";
                    break;
                case 130:
                    job = "스피어맨";
                    break;
                case 131:
                    job = "버서커";
                    break;
                case 132:
                    job = "다크나이트";
                    break;
                case 210:
                    job = "위자드(불, 독)";
                    break;
                case 211:
                    job = "메이지(불, 독)";
                    break;
                case 212:
                    job = "아크메이지(불, 독)";
                    break;
                case 220:
                    job = "위자드(썬, 콜)";
                    break;
                case 221:
                    job = "메이지(썬, 콜)";
                    break;
                case 222:
                    job = "아크메이지(썬, 콜)";
                    break;
                case 230:
                    job = "클레릭";
                    break;
                case 231:
                    job = "프리스트";
                    break;
                case 232:
                    job = "비숍";
                    break;
                case 310:
                    job = "헌터";
                    break;
                case 311:
                    job = "레인저";
                    break;
                case 312:
                    job = "보우마스터";
                    break;
                case 320:
                    job = "사수";
                    break;
                case 321:
                    job = "저격수";
                    break;
                case 322:
                    job = "신궁";
                    break;
                case 410:
                    job = "어쌔신";
                    break;
                case 411:
                    job = "허밋";
                    break;
                case 412:
                    job = "나이트로드";
                    break;
                case 420:
                    job = "시프";
                    break;
                case 421:
                    job = "시프마스터";
                    break;
                case 422:
                    job = "섀도어";
                    break;
                case 510:
                    job = "인파이터";
                    break;
                case 511:
                    job = "버커니어";
                    break;
                case 512:
                    job = "바이퍼";
                    break;
                case 520:
                    job = "건슬링거";
                    break;
                case 521:
                    job = "발키리";
                    break;
                case 522:
                    job = "캡틴";
                    break;
                case 530:
                    job = "캐논슈터";
                    break;
                case 531:
                    job = "캐논블래스터";
                    break;
                case 532:
                    job = "캐논마스터";
                    break;
     case 10112:
  job = "제로";
  break;
                default:
                    job = "미확인";
            }
            print.append(Integer(i)).append("위  #e#b").append(rank.getString("name")).append("   \r\n#k#n#b레벨 :#r ").append(Integer(rank.getInt("level"))).append("#k#b　직업#k : ").append(job).append("\r\n");
    }
    cm.sendOk("#fn굴림#현재 서버 내 환생 랭킹 순위입니다. \r\n순위는 #r5위#k 까지만 표시됩니다.\r\n\r\n"+print.toString());
    cm.dispose();
}