- 0
-
Posts
-
By iamcommand · Posted
WTS: TH 45 Necro 46 PP 46 SE 46 BD 44 All with mails. Adena Eminence bow Any top C luxor weapon discord : xeenthekeen -
ADENA 500 K = 40e 1kk = 70e 3kk = 190e ITEMS staff of life = 150e karmian set = 90e elven jewls top D = 30e Orcish Poleaxe+1 best C pole = 680e any D grade armor on demand discord wiz0642_81242 -
By Endarielle · Posted
clean email , pm with full details as message and then we talk -
-
By Constellation · Posted
❖Items that are sent by physical delivery are sent using someone else's data. That is, if you are not able to accept the parcel, we will not be able to return it. Please keep this in mind. READY IN STOCK PAYMENT SYSTEMS 4x4 io, Weststein, Paysafecard, Paysend, Genome, Conotoxia, Mybrocard, Payz Silver, Pockit UK, NagaPay, Volet com, SpectroCoin, SwissMoney, Yuh, Lydia / Sumeria, Ka.App, Wittix, Western Union, MyGuava, Xapo Bank, Bunq on emulator (DE, NL, FR, ES, IE ibans), Revolut on emulator (UK/EU), ICard, BlackCatCard, Vivid DE, Bankera, Bitsa, Wise EU/UK, N26 DE/ES on emulator, Skrill, Neteller, Trasta, Wirex, Lama, Paysera, Moneyjar CRYPTOEXCHANGE BINGX com, Bybit LVL 2, KuCoin, Binance LVL 2, Mexc, Latoken, Poloniex, Bitmart, Kraken, WhiteBit, Quppy, Nexo, Gate, OKX, Paybis, Paxful, Huobi (HTX), xcoins com, Bit2Me BUSINESS ACCOUNTS Stripe, Payoneer EU, Wise Business UK/EU, Revolut Business EU/UK, N26 Business DE, Wallester Business EU, Kraken Business Pro, Monzo Business, Vivid Business, Zen Business EU, Millennium Business PL, AirWallex EU/UK, Finom business, PayPal business, Payset business NATIONAL BANKS / BANKS BBVA, CommerzBank, ING, Santander, Kaspi Bank, Sberbank, AlfaBank, Tbank, Raiffeisen, mBank, Paribas, Bereke Bank, Kapital Bank
-
-
-
-
Topics
-
Question
L2shaken
someone help me with this code? this error in the SQL database that collects information. "SELECT boss_id FROM raidboss_spawnlist ORDER BY boss_id ASC LIMIT "+ stpoint + Config.RAID_LIST_RESULTS);"
original code: "SELECT id, name, level FROM npc WHERE type='L2RaidBoss' AND EXISTS (SELECT * FROM raidboss_spawnlist WHERE raidboss_spawnlist.boss_id = npc.id) ORDER BY `level` " + sort + " Limit " + stpoint + ", " + Config.RAID_LIST_RESULTS);
code for ACIS
entire code.
package net.sf.l2j.gameserver.communitybbs; import net.sf.l2j.Config; import net.sf.l2j.L2DatabaseFactory; import net.sf.l2j.gameserver.datatables.NpcTable; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.logging.Level; import java.util.logging.Logger; public class RaidList { protected static final Logger _log = Logger.getLogger(RaidList.class.getName()); private final StringBuilder _raidList = new StringBuilder(); public RaidList(String rfid) { loadFromDB(rfid); } private void loadFromDB(String rfid) { int type = Integer.parseInt(rfid); int stpoint = 0; int pos = 0; for (int count = 1; count != type; count++) { stpoint += Config.RAID_LIST_RESULTS; } try { Connection con = L2DatabaseFactory.getInstance().getConnection();Throwable localThrowable3 = null; try { PreparedStatement statement = con.prepareStatement("SELECT boss_id FROM raidboss_spawnlist ORDER BY boss_id ASC LIMIT "+ stpoint + Config.RAID_LIST_RESULTS); ResultSet result = statement.executeQuery(); pos = stpoint; while (result.next()) { int npcid = result.getInt("boss_id"); String npcname = NpcTable.getInstance().getTemplate(npcid).getName(); byte rlevel = NpcTable.getInstance().getTemplate(npcid).getLevel(); PreparedStatement statement2 = con.prepareStatement("SELECT respawn_time, spawn_time, random_time FROM raidboss_spawnlist WHERE boss_id=" + npcid); ResultSet result2 = statement2.executeQuery(); while (result2.next()) { pos++; boolean rstatus = false; long respawn = result2.getLong("respawn_time"); if (respawn == 0L) { rstatus = true; } int mindelay = result2.getInt("spawn_time"); int maxdelay = result2.getInt("random_time"); mindelay = mindelay / 60 / 60; maxdelay = maxdelay / 60 / 60; addRaidToList(pos, npcname, rlevel, mindelay, maxdelay, rstatus); } result2.close(); statement2.close(); } result.close(); statement.close(); } catch (Throwable localThrowable1) { localThrowable3 = localThrowable1;throw localThrowable1; } finally { if (con != null) { if (localThrowable3 != null) { try { con.close(); } catch (Throwable localThrowable2) { localThrowable3.addSuppressed(localThrowable2); } } else { con.close(); } } } } catch (Exception e) { _log.log(Level.WARNING, "Failed to load Raid List"); e.printStackTrace(); } } private void addRaidToList(int pos, String npcname, byte rlevel, int mindelay, int maxdelay, boolean rstatus) { _raidList.append("<table border=0 cellspacing=0 cellpadding=2 width=610 height=" + Config.RAID_LIST_ROW_HEIGHT + ">"); _raidList.append("<tr>"); _raidList.append("<td FIXWIDTH=5></td>"); _raidList.append("<td FIXWIDTH=25>" + pos + "</td>"); _raidList.append("<td FIXWIDTH=270>" + npcname + "</td>"); _raidList.append("<td FIXWIDTH=50>" + rlevel + "</td>"); _raidList.append("<td FIXWIDTH=120 align=center>" + mindelay + " - " + maxdelay + "</td>"); _raidList.append("<td FIXWIDTH=50 align=center>" + (rstatus ? "<font color=99FF00>Alive</font>" : "<font color=CC0000>Dead</font>") + "</td>"); _raidList.append("<td FIXWIDTH=5></td>"); _raidList.append("</tr>"); _raidList.append("</table>"); _raidList.append("<img src=\"L2UI.Squaregray\" width=\"610\" height=\"1\">"); } public String loadRaidList() { return _raidList.toString(); } }code for ACIS
16 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.