- 0
-
Posts
-
Https://lineage2dex.com Discord link : https://discord.com/channels/786506979493281794/814778540893536307/1424434670690504874 ## Dexters! **Our x25 server is celebrating its first week!** 🔥 Online stays strong at peak levels! New players are joining every day, with 200+ new master accounts registered daily — amazing results! ✨ Tomorrow we launch a new episode along with the first event. Full details will be shared in the morning(October 6). 🎁 And for this little celebration, here’s a bonus code with a small gift for you! ## O05-IIW **Contains: ** * x3 - Training Potion 200% (20 min) * x200 - Mana Potions Loyatly (no weight) *The code will remain active until October 6, 7 AM(server time). And be sure, you have at less 20 slots free on inv before using a code.* **👉 How to redeem:** 1. Log in to your Master Account on site. 2. Click the Redeem Bonus Code button at the top of the panel, type code click redeem. 3. Select the account and character you want to receive the gift. **Codes work only 1 time for 1 Master Account!** ### Enjoy your adventure, Dexters! -
.thumb.jpg.df37ccc61247adee70593b8554a525b2.jpg)
Complete Server Pack + Source Files: C4 Scions Of Destiny: P656 Retail X1 L2OFF Server Pack + Source: Price: 70 EUR C4 Scions Of Destiny: P656 ESL2 Athena x45 L2OFF Server Pack + Source: Price: 90 EUR Screenshots: https://imgur.com/a/eternal-sin-l2-athena-x45-c4-WYCpbjl C6 Interlude: P746 ESL2 Athena x45 L2OFF Server Pack + Source: Price: 100EUR The same as C4 but in C6 Client so the Screenshots is the same: https://imgur.com/a/eternal-sin-l2-athena-x45-c4-WYCpbjl C6 Interlude: P746 L2Gold L2OFF Server Pack + Source: Price: 50EUR Screenshots: https://imgur.com/a/9kB3oA9 C6 - Classic Interlude: P110 ESL2 Athena x45 L2OFF Server Pack + Source: Price: 100EUR Screenshots: https://imgur.com/a/Z2kZxuv Contact me here via PM (only serious buyers). -
Where should I modify the IP to be able to put it online for testing? -
I had issues with Smart Guard to, there is not even support in many cases. -
https://github.com/MobiusDevelopment/L2ClientDat
-
-
-
-
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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now