유저커멘드 인벤템 보여주기
} else if (cmd.equalsIgnoreCase("인벤")) {
search_inven(pc, param) ;
private void search_inven( L1PcInstance pc, String param ) {
try {
StringTokenizer tok = new StringTokenizer(param) ;
String name = tok.nextToken() ;
search_inven2(pc, name) ;
} catch (Exception e) {
pc.sendPackets(new S_SystemMessage(".인벤 케릭아이디를 적어주시기 바랍니다.")) ;
}
}
private void search_inven2( L1PcInstance pc, String param ) {
try {
String accountname = null ;
String S_objid = null ;
String S_itemname = null ;
String S_count = null ;
String S_enchanlvl = null ;
int count2 = 0 ;
Connection c = L1DatabaseFactory.getInstance().getConnection();
PreparedStatement Query_objid = null ;
Query_objid = c
.prepareStatement("select objid,account_name from characters where char_name = '"+ param + "'") ;
ResultSet rs0 = Query_objid.executeQuery() ;
while (rs0.next()) {
S_objid = rs0.getString(1) ;
//accountname = rs0.getString(2) ;
pc.sendPackets(new S_SystemMessage("캐릭명:" + param + " objic:" + S_objid)) ;
}
PreparedStatement Query_personInven = null ;
Query_personInven = c.prepareStatement("select item_name,count,enchantlvl from character_items where char_id = '"+ S_objid + "' ORDER BY 'enchantlvl' DESC, 'item_name' LIMIT 180") ;
ResultSet rs1 = Query_personInven.executeQuery() ;
pc.sendPackets(new S_SystemMessage("--------------------<<케릭터 인벤>>--------------------")) ;
while (rs1.next()) {
S_itemname = rs1.getString(1) ;
S_count = rs1.getString(2) ;
S_enchanlvl = rs1.getString(3) ;
pc.sendPackets(new S_SystemMessage("+" + S_enchanlvl +" "+ S_itemname + "[" + S_count + "]")) ;
count2++ ;
}
SQLUtil.close(rs1);
SQLUtil.close(Query_personInven);
SQLUtil.close(rs0);
SQLUtil.close(Query_objid);
SQLUtil.close(c);
pc.sendPackets(new S_SystemMessage("<<개인인벤>>:" + count2 + "개의 아이템 검색을 완료 하였습니다.")) ;
} catch (Exception e) {}
}
// .인벤

이드1 님의 최근 댓글
db는 2015년 2월 입니다 2016 09.28 접속기만있습니다 2016 04.27 이건 어디에 사용하는거에요 ?? 2016 04.26 ㅎㅇㅎㅇ 2016 04.26 다운이 안됨 ㅠ.ㅠ 2016 04.25