- 0
-
Posts
-
📜 • Mass PVP – Craft – Progressive Server (ITEMS, ARMOR, WEAPONS, ETC) 🕹️ • Chronicles: Lineage 2 - Interlude (C6) 🛠️ • Retail status 🕒 • Server Time: GMT -3 🏙️ • Main Town: Giran ✨ • Teleportation for all Towns, Gk Global 🛡️ • NPC BUFFER - GMSHOP B-GRADE - DONATION SHOP - AUCTION MANAGER 🐉 • Epic Bosses: Chaotic Zones 🔁 • Protection respawn: 15 seconds ⏰ • Restart Server: 05:00 AM Today 💸 • RTM allowed between players (ask Staff if in doubt) 📊 SERVER RATES: • EXP: x8 • SP: x10 • Adena: x3 • Seal Stone: x3 • Drop: x3 • Spoil: x5 • Raid EXP/SP/Drop: x3 • Premium Rates: x2 🌐 Website: https://www.l2roosters.com 💬 Discord: https://discord.gg/cUyYXrfy 🔥 Join us now and forge your legacy at Roosters Gaming! -
Hello, lovely people, how are you? I just finished compiling the L2jFrozen project Rev: 1132 (very old). I don't mind it being too old, since the project is for me and my children. (LAN/Offline) it's not meant to be put online. I want to learn and give my children more comfort when playing. And for my part, I also experiment with the game. My problem is that I don't know much about the subject. I was able to make some basic configurations to my liking and that of my children, but it never compiles or anything like that... I would really need help from you, the community... I simply want to remove all subclass restrictions, remove the restriction on "Overlord, Warsmith, and Dark Elf subclasses with White Elves and vice versa." Thank you very much in advance! Greetings, community. -
Warriors, prepare for a new era! We are pleased to announce that on July 12, with the morning restart, Airin will be updated to Chronicle 4: Scions of Destiny. - Open Beta Testing (OBT) will begin on July 9. Everyone will be able to test the update in advance, including class mechanics, quests, and new content. - The Clan Hall Auction will take place on July 13. We’ve also prepared a traditional bonus start - details will be shared in the coming days. The full list of changes is available in the official patch notes. Thank you for your support and participation in the project. See you in Chronicle 4! The game client download will be available soon. -
By tomlondon12 · Posted
We are taking new orders. Kindly DM us on 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.