- 0
-
Posts
-
By SmurfMania · Posted
Over 800 accounts in stock! https://Smurfmania.com https://www.g2g.com/SmurfMania -
By UTCHIHAmkt · Posted
DISCORD : utchiha_market telegram : https://t.me/utchiha_market SELLIX STORE : https://utchihamkt.mysellix.io/ Join our server for more products : https://discord.gg/hood-services https://campsite.bio/utchihaamkt -
-
-
hello everyone ! I need help with a l2script Rev H5-Salvation/Classic build. I compiled the project, installed everything but I can't log in to the server, it won't log me in. I tried a thousand ways without good results. I leave you the error when logging in either with the H5-Salvation Client. ERROR ---> WARN: IPBANMANAGER ---> IP !!!! I'm waiting for help! Thank you!
-
-
-
-
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.