- 0
-
Posts
-
Good afternoon, dear members of the forum, I have been looking for a geodata for l2scripts classic 2.9.5 for a long time! Someone can share? since the resource has not been available for a long time and cannot be downloaded from old links. p.s sorry for my English. -
I haven't spent a dime either, but there are those who lineage2 is their life and they must have a hero on a 1 lvl character. -
To celebrate the update to Chronicle 5 on the Teon server, which will take place at 11th of January, we’ve prepared special bonuses to help new players get started easily in the world of Lineage II! What’s included? - Starter gear for a smooth beginning — talk to Miss Queen to receive coupons that can be exchanged for equipment. - Runes to speed up your character’s progression — usable up to level 49. - Newbie buffs are now available up to level 39. - Newbie guides have been added to the towns of Heine, Oren, Giran, and Dion. Start: January 11 at 09:00 (GMT +1) End: February 1 at 04:00 (GMT +1) This offer is available for a limited time, so don’t miss your chance to start with an advantage! Registration Download Teon client Contact us: >Discord >Telegram -
-
-
-
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.