게임존 - 게임정보 커뮤니티

메이플스토리 소스자료실 ()

65 경매장

- 박인성
- 2017.02.01 - 11:30 214

importPackage(Packages.database);
importPackage(java.lang);
importPackage(java.sql);
importPackage(Packages.client.items);
importPackage(Packages.server.items);
importPackage(Packages.provider);
importPackage(java.io);

var threedays = 1000 * 60 * 60 * 24 * 3; // 3일
var star = "#fUI/UIWindow2.img/ToolTip/Equip/Star/Star#";

function createAuction() {
        var ins = MYSQL.getConnection().prepareStatement("INSERT INTO auctionmeso(name,meso) VALUES(?,?)");
        ins.setString(1,cm.getName());
        ins.setLong(2,0);
        ins.executeUpdate();
}

function haveAuction() {
    var isExist = false;
    var ps = MYSQL.getConnection().prepareStatement("SELECT * FROM auctionmeso WHERE name = ?");
    ps.setString(1,cm.getName());
    var rs = ps.executeQuery();
    if (rs.next()) {
        isExist = true;
    }
    return isExist;
}

function start() {
    if (!haveAuction()) {
    createAuction();
    }
    status = -1;
cm.sendSimple("안녕하세요? 경매 시스템을 운영하고 있는 #b클라라#k입니다. 등록하신 아이템은 3일 동안 저장되며, 중간에 아이템을 회수할 수 있습니다. 무엇을 도와드릴까요?\r\n#b#L1#아이템 등록하기\r\n#L2#등록된 아이템 보기\r\n#L3#등록된 아이템 조회\r\n#L4#메소 찾기\r\n\r\n#L100##d잠재능력 옵션 검색\r\n#L200#경매 용어 살펴보기\r\n\r\n#r#L1000#아이템 회수\r\n#L1001#구매한 아이템 리스트");
}

function setSale(uniqueid) {
        var ps = MYSQL.getConnection().prepareStatement("UPDATE inventoryitems SET issale = 0 WHERE uniqueid = ?");
        ps.setInt(1,uniqueid);
        ps.executeUpdate();
}

function deleteAuction(uniqueid) {
        var del = MYSQL.getConnection().prepareStatement("DELETE FROM auction WHERE uniqueid = ?");
        del.setInt(1,uniqueid);
        del.executeUpdate();
}

function searchItem(name) {
var ps = MYSQL.getConnection().prepareStatement("SELECT * FROM auction WHERE name LIKE CONCAT('%',?,'%')");
ps.setString(1,name);
var rs = ps.executeQuery();
var i = 0;
while (rs.next()) {
i++;
name = rs.getString("name");
}
return getAuctionList(name,null,null,null);
}

function getPrice(uniqueid,type) {
    var ps = MYSQL.getConnection().prepareStatement("SELECT * FROM auction WHERE uniqueid = ?");
    ps.setInt(1,uniqueid);
    var rs = ps.executeQuery(); rs.next();
    price = rs.getString("price").split(",");
    return type == 1 ? price[0] : price[1];
}

function getInvId(uniqueid) {
    var ps = MYSQL.getConnection().prepareStatement("SELECT * FROM inventoryitems WHERE uniqueid = ?");
    ps.setInt(1,uniqueid);
    var rs = ps.executeQuery();
    rs.next(); return rs.getInt("inventoryitemid");
}

function getItemInfo(uniqueid,type) {
    var ps = MYSQL.getConnection().prepareStatement("SELECT * FROM auction WHERE uniqueid = ?");
    ps.setInt(1,uniqueid);
    var rs = ps.executeQuery();
    rs.next();
    return type == "owner" || type == "buyer" || type == "type" ? rs.getString(type) : rs.getLong(type);
}

function gainOwnerMeso(meso,owner) {
    meso = Long.parseLong(meso);
    var upd = MYSQL.getConnection().prepareStatement("UPDATE auctionmeso SET meso = ? WHERE name = ?");
    upd.setLong(1,(getAuctionMeso(owner) + meso));
    upd.setString(2,owner);
    upd.executeUpdate();
}

function getItem(type,slot) {
return cm.getPlayer().getInventory(type).getItem(slot);
}

function getType(type) {
return type == 1 ? BelowInventoryType.EQUIP : type == 2 ? BelowInventoryType.USE : type == 3 ? BelowInventoryType.SETUP : type == 4 ? BelowInventoryType.ETC : BelowInventoryType.CASH;
}

function gainEquip(invid,itemid) {
    var equip = ItemInformation.getInstance().getEquipById(itemid);
    var inv = MYSQL.getConnection().prepareStatement("SELECT * FROM inventoryequipment WHERE inventoryitemid = ?");
    inv.setInt(1,invid);
    var rs = inv.executeQuery();
        var item = "";
    rs.next();
        var option = new Array("upgradeslots","level","str","dex","int","luk","hp","mp","watk","matk","wdef","mdef","acc","avoid","hands","speed","jump","ringid","ViciousHammer","itemLevel","itemEXP","durability","enhance","state","lines","potential1",
"potential2","potential3","potential4","potential5","potential6","anvil","hpR","mpR","potential7","fire","kanghwa","soonsak","downlevel","bossdmg","alldmgp","allstatp","IgnoreWdef","soulenchanter","soulname","soulskill");
    for (var i = 0; i < option.length; i++) {
        item += rs.getInt(option[i])+",";
    }
        item = item.split(",");
        equip.setUpgradeSlots(item[0]);        equip.setLevel(item[1]);
        equip.setStr(item[2]);        equip.setDex(item[3]);        equip.setInt(item[4]);        equip.setLuk(item[5]);
        equip.setHp(item[6]);        equip.setMp(item[7]);        equip.setWatk(item[8]);        equip.setMatk(item[9]);
        equip.setWdef(item[10]);        equip.setMdef(item[11]);        equip.setAcc(item[12]);        equip.setAvoid(item[13]);
        equip.setHands(item[14]);        equip.setSpeed(item[15]);        equip.setJump(item[16]);        equip.setRingId(item[17]);
        equip.setViciousHammer(item[18]);        equip.setItemLevel(item[19]);          equip.setItemEXP(item[20]);
        equip.setDurability(item[21]);        equip.setEnhance(item[22]);        equip.setState(item[23]);          equip.setLines(item[24])
        equip.setPotential1(item[25]);        equip.setPotential2(item[26]);        equip.setPotential3(item[27]);
        equip.setPotential4(item[28]);        equip.setPotential5(item[29]);        equip.setPotential6(item[30]);
        equip.setanvil(item[31]);        equip.setHpR(item[32]);        equip.setMpR(item[33]);         equip.setPotential7(item[34]);
        equip.setFire(item[35]);        equip.setKangHwa(item[36]);       equip.setsoonsak(item[37]);       equip.setDownLevel(item[38]);
        equip.setBossDamage(item[39]);        equip.setAllDamageP(item[40]);      equip.setAllStatP(item[41]);          equip.setIgnoreWdef(item[42]);
        equip.setSoulEnchanter(item[43]);       equip.setSoulName(item[44]);        equip.setSoulSkill(item[45]);
        InventoryManipulator.addFromDrop(cm.getC(), equip, false);
}

function 정렬(text,color) {
    if (text < 10) {
        text = "#Cgray#0000"+color+""+text;
    } else if (text >= 10 && text < 100) {
        text = "#Cgray#000"+color+""+text;
    } else if (text >= 100 && text < 1000) {
        text = "#Cgray#00"+color+text;
    } else if (text >= 1000 && text < 10000) {
        text = "#Cgray#0"+color+text;
    }
    return color+text;
}

function 잠재능력(option) {
return option == 17 ? "#b레어잠재" : option == 18 ? "#d에픽잠재" : option == 19 ? "#Cyellow#유니크해" : option == 20 ? "#g레전드리" : option == 4 ? "#r정체불명" : "#k아예없음";
}

Attached file

이 게시물을..

1.2.65 아트 소스오빠는요

3

박인성

글쓴이의 서명작성글 감추기

댓글 쓰기 에디터 사용하기 닫기

view_headline 목록

SEARCH

65 경매장

박인성 님의 최근 글

박인성 님의 최근 댓글