실시간 랭킹 스크립트
importPackage(Packages.client);importPackage(java.sql);importPackage(java.lang);importPackage(Packages.database);importPackage(Packages.constants);
var status = 0;
var txt = new StringBuilder();
var no = 1;
function start() { status = -1; action(1, 0, 0); }
function action(mode, type, selection) { if (mode == -1) { cm.dispose(); } else { if (mode == 0) { cm.dispose(); return; }
if (mode == 1) status++; else status--;
if (status == 0) {
cm.sendSimple("어떤 랭킹을 보시겠습니까?\r\n#b#L0#레벨 랭킹\r\n#L2#길드 랭킹");
} else if (status == 1) {
if (selection == 0) {
var con = MYSQL.getConnection().prepareStatement("SELECT * FROM characters WHERE gm = 0 ORDER BY level DESC LIMIT 5").executeQuery();
while(con.next()) {
switch(con.getInt("job")){
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:
case 431:
case 432:
case 433:
case 434:
job = "듀얼블레이드";
break;
case 3500:
case 3512:
case 3511:
case 3512:
job = "메카닉";
break;
case 1500:
case 1510:
case 1511:
case 1512:
job = "스트라이커";
break;
case 1300:
case 1310:
case 1311:
case 1312:
job = "윈드브레이커";
break;
case 3300:
case 3310:
case 3311:
case 3312:
job = "와일드 헌터";
break;
case 100:
job = "검사";
break;
case 200:
job = "마법사";
break;
case 300:
job = "궁수";
break;
case 400:
job = "도적";
break;
case 500:
job = "해적";
break;
case 110:
case 111:
case 112:
job = "히어로";
break;
case 120:
case 121:
case 122:
job = "팔라딘";
break;
case 130:
case 131:
case 132:
job = "다크나이트";
break;
case 210:
case 211:
case 212:
job = "마법사(불,독)";
break;
case 220:
case 221:
case 222:
job = "마법사(썬,콜)";
break;
case 230:
case 231:
case 232:
job = "클레릭";
break;
case 310:
case 311:
case 312:
job = "헌터";
break;
case 320:
case 321:
case 322:
job = "사수";
break;
case 410:
case 411:
case 412:
job = "어쌔신";
break;
case 420:
case 421:
case 422:
job = "시프";
break;
case 430:
case 431:
case 432:
case 434:
job = "듀얼블레이드";
break;
case 510:
case 511:
case 512:
job = "인파이터";
break;
case 520:
case 521:
case 522:
job = "건슬링거";
break;
case 530:
case 531:
case 532:
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 2100:
case 2110:
case 2111:
case 2112:
job = "아란";
break;
case 2200:
case 2210:
case 2211:
case 2212:
case 2213:
case 2214:
case 2215:
case 2216:
case 2217:
case 2218:
job = "에반";
break;
case 3101:
case 3120:
case 3121:
case 3122:
job = "데몬어벤져";
break;
case 3600:
case 3610:
case 3611:
case 3612:
job = "제논";
break;
case 2700:
case 2710:
case 2711:
case 2712:
job = "루미너스";
break;
case 6100:
case 6110:
case 6111:
case 6112:
job = "카이저";
break;
case 6500:
case 6510:
case 6511:
case 6512:
job = "엔젤릭버스터";
break;
case 5100:
case 5110:
case 5111:
case 5112:
job = "미하일";
break;
case 2400:
case 2410:
case 2411:
case 2412:
job = "팬텀";
break;
case 2500:
case 2510:
case 2511:
case 2512:
job = "은월";
break;
default:
job = "초보자";
}
if (no == 2) {
txt.append("#b랭킹 1위를 축하드립니다! 하지만, 언제 ?아올지 모르는 2위를 피해 멀리 도망가시길..\r\n");
} else if (no == 3) {
txt.append("#b조금만 더! 이제 한 발자국이면 1위를 쟁탈 할 수 있습니다!\r\n");
}
txt.append("\r\n#e#rTop. ").append(Integer(no));
no++;
txt.append("#n\r\n#Cgray#이름 : #k").append(con.getString("name"))
.append(" / #Cgray#직업 : #k").append(job)
.append(" / #Cgray#포인트 : #k").append(Integer(con.getInt("spiritp"))).append("\r\n");
}
if (no == 1) {
cm.sendOk("아직까지 성배포인트를 획득하신분은 계시지 않습니다. " + cm.getPlayer().getName() + "님께서 1위를 차지 해 보시는게 어떠세요?");
cm.dispose();
} else {
cm.sendOk(txt.toString());
cm.dispose();
}
}
}
}
}
메이플레이 님의 최근 댓글