快樂天堂: 【Java教學】排行榜

此排行榜須本身有寫入轉身系統才可使用，若無轉生系統必須另外修改

新增

l1j.william.Place

內容複製

/*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2, or (at your option)
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA
* 02111-1307, USA.
*
* http://www.gnu.org/copyleft/gpl.html
*/

package l1j.william;

import java.sql.*;

import l1j.server.L1DatabaseFactory;
import l1j.server.server.utils.SQLUtil;

public class Place {
public static String[] All() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";

PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 order by (reincarnationAmount*1800000000+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Crown() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";

PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 0 || class = 1) order by (reincarnationAmount*1800000000+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Elf() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";

PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 138 || class = 37) order by (reincarnationAmount*1800000000+exp) DESC limit 9,1;");


rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Wizard() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";

PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 1186 || class = 734) order by (reincarnationAmount*1800000000+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Knight() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";

PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 61 || class = 48) order by (reincarnationAmount*1800000000+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Darkelf() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";
PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 2786 || class = 2796) order by (reincarnationAmount+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Dragon() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";
PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6658 || class = 6661) order by (reincarnationAmount+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}
public static String[] Illusionist() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
String no16 = "空缺";
String no17 = "空缺";
String no18 = "空缺";
String no19 = "空缺";
String no20 = "空缺";
String no21 = "?";
String no22 = "?";
String no23 = "?";
String no24 = "?";
String no25 = "?";
String no26 = "?";
String no27 = "?";
String no28 = "?";
String no29 = "?";
String no30 = "?";
PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 4,1;");
pstm6 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 5,1;");
pstm7 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 6,1;");
pstm8 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 7,1;");
pstm9 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 8,1;");
pstm10 = con.prepareStatement("select char_name,level,reincarnationAmount from characters where accesslevel = 0 && (class = 6671 || class = 6650) order by (reincarnationAmount+exp) DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("level");
no11 = rs1.getString("reincarnationAmount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("level");
no12 = rs2.getString("reincarnationAmount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("level");
no13 = rs3.getString("reincarnationAmount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("level");
no14 = rs4.getString("reincarnationAmount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("level");
no15 = rs5.getString("reincarnationAmount");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no16 = rs6.getString("char_name");
no21 = rs6.getString("level");
no26 = rs6.getString("reincarnationAmount");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no17 = rs7.getString("char_name");
no22 = rs7.getString("level");
no27 = rs7.getString("reincarnationAmount");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no18 = rs8.getString("char_name");
no23 = rs8.getString("level");
no28 = rs8.getString("reincarnationAmount");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no19 = rs9.getString("char_name");
no24 = rs9.getString("level");
no29 = rs9.getString("reincarnationAmount");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no20 = rs10.getString("char_name");
no25 = rs10.getString("level");
no30 = rs10.getString("reincarnationAmount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)
, String.valueOf(no16), String.valueOf(no17), String.valueOf(no18), String.valueOf(no19), String.valueOf(no20)
, String.valueOf(no21), String.valueOf(no22), String.valueOf(no23), String.valueOf(no24), String.valueOf(no25)
, String.valueOf(no26), String.valueOf(no27), String.valueOf(no28), String.valueOf(no29), String.valueOf(no30)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}

public static String[] enchantlvl() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,item_name,enchantlvl from characters,character_items where accesslevel = 0 and enchantlvl > 9 and (item_id < 5000 or (item_id < 100215 and item_id > 100000)) and objid = char_id order by enchantlvl desc limit 0,30");
pstm2 = con.prepareStatement("select char_name,item_name,enchantlvl from characters,character_items where accesslevel = 0 and enchantlvl > 9 and (item_id < 5000 or (item_id < 100215 and item_id > 100000)) and objid = char_id order by enchantlvl desc limit 1,60");
pstm3 = con.prepareStatement("select char_name,item_name,enchantlvl from characters,character_items where accesslevel = 0 and enchantlvl > 9 and (item_id < 5000 or (item_id < 100215 and item_id > 100000)) and objid = char_id order by enchantlvl desc limit 2,90");
pstm4 = con.prepareStatement("select char_name,item_name,enchantlvl from characters,character_items where accesslevel = 0 and enchantlvl > 9 and (item_id < 5000 or (item_id < 100215 and item_id > 100000)) and objid = char_id order by enchantlvl desc limit 3,120");
pstm5 = con.prepareStatement("select char_name,item_name,enchantlvl from characters,character_items where accesslevel = 0 and enchantlvl > 9 and (item_id < 5000 or (item_id < 100215 and item_id > 100000)) and objid = char_id order by enchantlvl desc limit 4,150");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
no6 = rs1.getString("item_name");
no11 = rs1.getString("enchantlvl");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
no7 = rs2.getString("item_name");
no12 = rs2.getString("enchantlvl");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
no8 = rs3.getString("item_name");
no13 = rs3.getString("enchantlvl");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
no9 = rs4.getString("item_name");
no14 = rs4.getString("enchantlvl");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
no10 = rs5.getString("item_name");
no15 = rs5.getString("enchantlvl");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(con);
return levelresult;
}

public static String[] pk_UP() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "?";
String no7 = "?";
String no8 = "?";
String no9 = "?";
String no10 = "?";
String no11 = "?";
String no12 = "?";
String no13 = "?";
String no14 = "?";
String no15 = "?";
PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
pstm1 = con.prepareStatement("select char_name,PKcount from characters where accesslevel = 0 and PKcount > 1 order by (PKcount) DESC limit 0,1;");
pstm2 = con.prepareStatement("select char_name,PKcount from characters where accesslevel = 0 and PKcount > 1 order by (PKcount) DESC limit 1,1;");
pstm3 = con.prepareStatement("select char_name,PKcount from characters where accesslevel = 0 and PKcount > 1 order by (PKcount) DESC limit 2,1;");
pstm4 = con.prepareStatement("select char_name,PKcount from characters where accesslevel = 0 and PKcount > 1 order by (PKcount) DESC limit 3,1;");
pstm5 = con.prepareStatement("select char_name,PKcount from characters where accesslevel = 0 and PKcount > 1 order by (PKcount) DESC limit 4,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
// no6 = rs1.getString("level");
no11 = rs1.getString("PKcount");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
// no7 = rs2.getString("level");
no12 = rs2.getString("PKcount");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
// no8 = rs3.getString("level");
no13 = rs3.getString("PKcount");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
// no9 = rs4.getString("level");
no14 = rs4.getString("PKcount");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
// no10 = rs5.getString("level");
no15 = rs5.getString("PKcount");
}
levelresult = new String[] {"", String.valueOf(no1), String.valueOf(no2), String.valueOf(no3), String.valueOf(no4), String.valueOf(no5)
, String.valueOf(no6), String.valueOf(no7), String.valueOf(no8), String.valueOf(no9), String.valueOf(no10)
, String.valueOf(no11), String.valueOf(no12), String.valueOf(no13), String.valueOf(no14), String.valueOf(no15)};
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(con);
return levelresult;
}

// 老舊的石碑
public static String[] Cray() throws SQLException {
String no1 = "空缺";
String no2 = "空缺";
String no3 = "空缺";
String no4 = "空缺";
String no5 = "空缺";
String no6 = "空缺";
String no7 = "空缺";
String no8 = "空缺";
String no9 = "空缺";
String no10 = "空缺";
PreparedStatement pstm1 = null;
PreparedStatement pstm2 = null;
PreparedStatement pstm3 = null;
PreparedStatement pstm4 = null;
PreparedStatement pstm5 = null;
PreparedStatement pstm6 = null;
PreparedStatement pstm7 = null;
PreparedStatement pstm8 = null;
PreparedStatement pstm9 = null;
PreparedStatement pstm10 = null;
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rs3 = null;
ResultSet rs4 = null;
ResultSet rs5 = null;
ResultSet rs6 = null;
ResultSet rs7 = null;
ResultSet rs8 = null;
ResultSet rs9 = null;
ResultSet rs10 = null;
Connection con = null;
String[] levelresult = null;
con = L1DatabaseFactory.getInstance().getConnection();
// 主要內容有：GM不列入排序、篩選出幻術師男女CLASSID、經驗值由大到小排列。因為等級是依照經驗值來計算的，所以不搜尋等級，而搜尋經驗值，同等級經驗值高者名次較前。最後是從第一筆往下取一筆資料、從第二筆往下取一筆資料這樣。)
pstm1 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 0,1;");
pstm2 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 1,1;");
pstm3 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 2,1;");
pstm4 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 3,1;");
pstm5 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 4,1;");
pstm6 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 5,1;");
pstm7 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 6,1;");
pstm8 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 7,1;");
pstm9 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 8,1;");
pstm10 = con
.prepareStatement("select char_name from characters where accesslevel=0 order by Cray DESC limit 9,1;");

rs1 = pstm1.executeQuery();
if (rs1.next()) {
no1 = rs1.getString("char_name");
}
rs2 = pstm2.executeQuery();
if (rs2.next()) {
no2 = rs2.getString("char_name");
}
rs3 = pstm3.executeQuery();
if (rs3.next()) {
no3 = rs3.getString("char_name");
}
rs4 = pstm4.executeQuery();
if (rs4.next()) {
no4 = rs4.getString("char_name");
}
rs5 = pstm5.executeQuery();
if (rs5.next()) {
no5 = rs5.getString("char_name");
}
rs6 = pstm6.executeQuery();
if (rs6.next()) {
no6 = rs6.getString("char_name");
}
rs7 = pstm7.executeQuery();
if (rs7.next()) {
no7 = rs7.getString("char_name");
}
rs8 = pstm8.executeQuery();
if (rs8.next()) {
no8 = rs8.getString("char_name");
}
rs9 = pstm9.executeQuery();
if (rs9.next()) {
no9 = rs9.getString("char_name");
}
rs10 = pstm10.executeQuery();
if (rs10.next()) {
no10 = rs10.getString("char_name");
}
levelresult = new String[] { "", String.valueOf(no1),
String.valueOf(no2), String.valueOf(no3), String.valueOf(no4),
String.valueOf(no5), String.valueOf(no6), String.valueOf(no7),
String.valueOf(no8), String.valueOf(no9), String.valueOf(no10) };
SQLUtil.close(rs1);
SQLUtil.close(rs2);
SQLUtil.close(rs3);
SQLUtil.close(rs4);
SQLUtil.close(rs5);
SQLUtil.close(rs6);
SQLUtil.close(rs7);
SQLUtil.close(rs8);
SQLUtil.close(rs9);
SQLUtil.close(rs10);
SQLUtil.close(pstm1);
SQLUtil.close(pstm2);
SQLUtil.close(pstm3);
SQLUtil.close(pstm4);
SQLUtil.close(pstm5);
SQLUtil.close(pstm6);
SQLUtil.close(pstm7);
SQLUtil.close(pstm8);
SQLUtil.close(pstm9);
SQLUtil.close(pstm10);
SQLUtil.close(con);
return levelresult;
}

// end

}

C_NPCAction.java

宣告

import l1j.william.Place;

下方加入

/* 各大族群排名(排名系統) */
} else if (((L1NpcInstance) obj).getNpcTemplate().get_npcId() == 94404) {
if (s.equalsIgnoreCase("Crown")) { // 顯示王族等級排序前五名
htmldata = Place.Crown();
htmlid = "Crown";
}
if (s.equalsIgnoreCase("Elf")) { // 顯示妖精等級排序前五名
htmldata = Place.Elf();
htmlid = "Elf";
}
if (s.equalsIgnoreCase("Wizard")) { // 顯示法師等級排序前五名
htmldata = Place.Wizard();
htmlid = "Wizard";
}
if (s.equalsIgnoreCase("Knight")) { // 顯示騎士等級排序前五名
htmldata = Place.Knight();
htmlid = "Knight";
}
if (s.equalsIgnoreCase("Darkelf")) { // 顯示黑妖等級排序前五名
htmldata = Place.Darkelf();
htmlid = "Darkelf";
}
if (s.equalsIgnoreCase("Dragon")) { // 顯示龍騎士等級排序前五名
htmldata = Place.Dragon();
htmlid = "Dragon";
}
if (s.equalsIgnoreCase("Illusionist")) { // 顯示幻術師等級排序前五名
htmldata = Place.Illusionist();
htmlid = "Illusionist";

}

下方再繼續新增

} else if (((L1NpcInstance) obj).getNpcTemplate().get_npcId() == 97434) // 排行榜
// NPC
{
if (pc.hasSkillEffect(7906)) {
pc.sendPackets(new S_SystemMessage("避免服務器負擔請等待5分鐘過後再來觀看。"));
return;
}
if (s.equalsIgnoreCase("All")) { // 顯示全職等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
// pc.setSkillEffect(7906, 3000000);
htmldata = Place.All();
htmlid = "All";
}
if (s.equalsIgnoreCase("Crown")) { // 顯示王族等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Crown();
htmlid = "Crown";
}
if (s.equalsIgnoreCase("Knight")) { // 顯示騎士等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Knight();
htmlid = "Knight";
}
if (s.equalsIgnoreCase("Elf")) { // 顯示妖精等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Elf();
htmlid = "Elf";
}
if (s.equalsIgnoreCase("Wizard")) { // 顯示法師等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Wizard();
htmlid = "Wizard";
}
if (s.equalsIgnoreCase("Darkelf")) { // 顯示黑妖等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Darkelf();
htmlid = "Darkelf";
}
if (s.equalsIgnoreCase("Dragon")) { // 顯示龍騎士等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Dragon();
htmlid = "Dragon";
}
if (s.equalsIgnoreCase("Illusionist")) { // 顯示幻術師等級排序前10名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.Illusionist();
htmlid = "Illusionist";
}
if (s.equalsIgnoreCase("enchantlvl")) { // 顯示武器排序前五名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.enchantlvl();
htmlid = "enchantlvl";
}
if (s.equalsIgnoreCase("pk_UP")) { // 顯示武器排序前五名
if (!pc.isGm())
pc.setSkillEffect(7906, 500000);
htmldata = Place.pk_UP();
htmlid = "pk_UP";
}

}

快樂天堂

2013年6月11日星期二

【Java教學】排行榜

1 則留言:

2013年6月11日 星期二

【Java教學】排行榜

1 則留言:

2013年6月11日星期二