Jump to content

ak4n1

Members
  • Posts

    7
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

About ak4n1

Profile Information

  • Gender
    Male
  • Country
    Argentina

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

ak4n1's Achievements

Apprentice

Apprentice (3/16)

  • One Year In Rare
  • First Post Rare
  • One Month Later Rare
  • Week One Done Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hello, I can't find l2phx to download. I will continue looking for the error. thank you!
  2. Hello everyone, I hope you're all having a good afternoon. I wanted to ask for your help with an issue I've been having while trying to create a community board for the Interlude chronicle using the L2JMobius CT 0 Interlude datapack. My goal is to make a top PvP and PK ranking and implement it into the custom community board that comes with this datapack. I've adapted some code that works with the Interlude datapack from L2JMobius which I found in this link: Link. The creator of this code is "StinkyMadness". Continuing on, I've created the RankingsBoard class and added it into the MasterHandlers, but the client throws a critical error. No errors are shown in the game server. One idea that occurred to me is to implement this method in HomeBoard.java, but it also encounters the same error in the client. Since there are no errors shown in the game server, I'm having trouble finding a solution. I would greatly appreciate any help or suggestions you can offer. Thank you in advance! Here class RankingsBoard * This file is part of the L2J Mobius project. * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package handlers.communityboard; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.stream.IntStream; import org.l2jmobius.commons.database.DatabaseFactory; import org.l2jmobius.commons.util.StringUtil; import org.l2jmobius.gameserver.cache.HtmCache; import org.l2jmobius.gameserver.handler.CommunityBoardHandler; import org.l2jmobius.gameserver.handler.IParseBoardHandler; import org.l2jmobius.gameserver.model.World; import org.l2jmobius.gameserver.model.actor.Player; /** */ public class RankingsBoard implements IParseBoardHandler { private static final StringBuilder PVP = new StringBuilder(); private static final StringBuilder PKS = new StringBuilder(); private static final int PAGE_LIMIT_15 = 15; private long _nextUpdate; public RankingsBoard() { } private static final String[] COMMANDS = { "_bbsranking", }; @Override public boolean parseCommunityBoardCommand(String command, Player player) { try { if (command.equals("_bbsranking")) { showRakingList(player); return true; } } catch (Exception exc) { System.out.println(exc); } return false; } public void showRakingList(Player player) { if (_nextUpdate < System.currentTimeMillis()) { PVP.setLength(0); PKS.setLength(0); try (Connection con = DatabaseFactory.getConnection();) { try (PreparedStatement ps = con.prepareStatement("SELECT char_name, pvpkills FROM characters WHERE pvpkills > 0 ORDER BY pvpkills DESC LIMIT " + PAGE_LIMIT_15); ResultSet rs = ps.executeQuery()) { int index = 1; while (rs.next()) { final String name = rs.getString("char_name"); final Player databasePlayer = World.getInstance().getPlayer(name); final String status = "L2UI_CH3.msnicon" + ((databasePlayer != null) && databasePlayer.isOnline() ? "1" : "4"); StringUtil.append(PVP, "<table width=300 bgcolor=000000><tr><td width=20 align=right>", getColor(index), String.format("%02d", index), "</td>"); StringUtil.append(PVP, "<td width=20 height=18><img src=", status, " width=16 height=16></td><td width=160 align=left>", name, "</td>"); StringUtil.append(PVP, "<td width=100 align=right>", StringUtil.formatNumber(rs.getInt("pvpkills")), "</font></td></tr></table><img src=L2UI.SquareGray width=296 height=1>"); index++; } IntStream.range(index - 1, PAGE_LIMIT_15).forEach(x -> applyEmpty(PVP)); } try (PreparedStatement ps = con.prepareStatement("SELECT char_name, pkkills FROM characters WHERE pkkills > 0 ORDER BY pkkills DESC LIMIT " + PAGE_LIMIT_15); ResultSet rs = ps.executeQuery()) { int index = 1; while (rs.next()) { final String name = rs.getString("char_name"); final Player databasePlayer = World.getInstance().getPlayer(name); final String status = "L2UI_CH3.msnicon" + ((databasePlayer != null) && databasePlayer.isOnline() ? "1" : "4"); StringUtil.append(PKS, "<table width=300 bgcolor=000000><tr><td width=20 align=right>", getColor(index), String.format("%02d", index), "</td>"); StringUtil.append(PKS, "<td width=20 height=18><img src=", status, " width=16 height=16></td><td width=160 align=left>", name, "</td>"); StringUtil.append(PKS, "<td width=100 align=right>", StringUtil.formatNumber(rs.getInt("pkkills")), "</font></td></tr></table><img src=L2UI.SquareGray width=296 height=1>"); index++; } IntStream.range(index - 1, PAGE_LIMIT_15).forEach(x -> applyEmpty(PKS)); } } catch (Exception e) { } _nextUpdate = System.currentTimeMillis() + 60000L; } String content = HtmCache.getInstance().getHtm(player, "data/html/CommunityBoard/Custom/ranking/rankinglist.html"); if (content != null) { content = content.replaceAll("%name%", player.getName()); content = content.replaceAll("%pvp%", PVP.toString()); content = content.replaceAll("%pks%", PKS.toString()); content = content.replaceAll("%time%", String.valueOf((_nextUpdate - System.currentTimeMillis()) / 1000)); CommunityBoardHandler.separateAndSend(content, player); } else { } } public String getColor(int index) { switch (index) { case 1: return "<font color=FFFF00>"; case 2: return "<font color=FFA500>"; case 3: return "<font color=E9967A>"; } return ""; } @Override public String[] getCommunityBoardCommands() { return COMMANDS; } public void applyEmpty(StringBuilder sb) { sb.append("<table width=300 bgcolor=000000><tr>"); sb.append("<td width=20 align=right><font color=B09878>--</font></td><td width=20 height=18></td>"); sb.append("<td width=160 align=left><font color=B09878>----------------</font></td>"); sb.append("<td width=100 align=right><font color=FF0000>0</font></td>"); sb.append("</tr></table><img src=L2UI.SquareGray width=296 height=1>"); } public static RankingsBoard getInstance() { return SingletonHolder.INSTANCE; } private static class SingletonHolder { protected static final RankingsBoard INSTANCE = new RankingsBoard(); } } Here the method implemented in the HomeBoard.java class in an else if, I do not put the entire class because it is very large and I think it is unnecessary, but the constants it uses constanst private static final StringBuilder PVP = new StringBuilder(); private static final StringBuilder PKS = new StringBuilder(); private static final int PAGE_LIMIT_15 = 15; private long _nextUpdate; else if (command.startsWith("_bbsranking")) { if (_nextUpdate < System.currentTimeMillis()) { PVP.setLength(0); PKS.setLength(0); try (Connection con = DatabaseFactory.getConnection();) { try (PreparedStatement ps = con.prepareStatement("SELECT char_name, pvpkills FROM characters WHERE pvpkills > 0 ORDER BY pvpkills DESC LIMIT " + PAGE_LIMIT_15); ResultSet rs = ps.executeQuery()) { int index = 1; while (rs.next()) { final String name = rs.getString("char_name"); final Player databasePlayer = World.getInstance().getPlayer(name); final String status = "L2UI_CH3.msnicon" + ((databasePlayer != null) && databasePlayer.isOnline() ? "1" : "4"); StringUtil.append(PVP, "<table width=300 bgcolor=000000><tr><td width=20 align=right>", getColor(index), String.format("%02d", index), "</td>"); StringUtil.append(PVP, "<td width=20 height=18><img src=", status, " width=16 height=16></td><td width=160 align=left>", name, "</td>"); StringUtil.append(PVP, "<td width=100 align=right>", StringUtil.formatNumber(rs.getInt("pvpkills")), "</font></td></tr></table><img src=L2UI.SquareGray width=296 height=1>"); index++; } IntStream.range(index - 1, PAGE_LIMIT_15).forEach(x -> applyEmpty(PVP)); } try (PreparedStatement ps = con.prepareStatement("SELECT char_name, pkkills FROM characters WHERE pkkills > 0 ORDER BY pkkills DESC LIMIT " + PAGE_LIMIT_15); ResultSet rs = ps.executeQuery()) { int index = 1; while (rs.next()) { final String name = rs.getString("char_name"); final Player databasePlayer = World.getInstance().getPlayer(name); final String status = "L2UI_CH3.msnicon" + ((databasePlayer != null) && databasePlayer.isOnline() ? "1" : "4"); StringUtil.append(PKS, "<table width=300 bgcolor=000000><tr><td width=20 align=right>", getColor(index), String.format("%02d", index), "</td>"); StringUtil.append(PKS, "<td width=20 height=18><img src=", status, " width=16 height=16></td><td width=160 align=left>", name, "</td>"); StringUtil.append(PKS, "<td width=100 align=right>", StringUtil.formatNumber(rs.getInt("pkkills")), "</font></td></tr></table><img src=L2UI.SquareGray width=296 height=1>"); index++; } IntStream.range(index - 1, PAGE_LIMIT_15).forEach(x -> applyEmpty(PKS)); } } catch (Exception e) { } _nextUpdate = System.currentTimeMillis() + 60000L; } final String customPath = Config.CUSTOM_CB_ENABLED ? "Custom/" : ""; final String path = command.replace("_bbsranking;", ""); String content = HtmCache.getInstance().getHtm(player, "data/html/CommunityBoard/" + customPath + path); if (content != null) { content = content.replaceAll("%name%", player.getName()); content = content.replaceAll("%pvp%", PVP.toString()); content = content.replaceAll("%pks%", PKS.toString()); content = content.replaceAll("%time%", String.valueOf((_nextUpdate - System.currentTimeMillis()) / 1000)); CommunityBoardHandler.separateAndSend(content, player); } } Critical Error:
  3. Hola, como abro los archivos .u y .xdat ? quiero editar el community board de mi l2 (alt + b) y no se como abrirlo, vi que esta en interface, despues en la data del game server (html) y no se como arrancar
  4. Hola como estas, yo tambien los estoy buscando, si los encuentro te los comparto por aca y si lo encontras me lo pasas por aca? gracias
  5. Buenas noches, tengo un problema y queria ver si alguien podia ayudarme. soy un novato en esto y voy aprendiendo con lo poco que se encuentra en internet (unreal engine 3). la cuestion es la siguiente, quiero editar el mapa de giran 22_22.unr, pero cuando guardo el archivo sin hacer ningun cambio el suelo se vuelve negro. alguien sabra porque? dejo una imagen para que vean. solamente el piso afuera de la ciudad se vuelve negro. gracias Good evening, I have a problem and I wanted to see if someone could help me. I'm a novice at this and I'm learning with what little is on the internet (unreal engine 3). the question is the following, I want to edit the map of giran 22_22.unr, but when I save the file without making any changes the ground turns black. someone know why? I leave a picture for you to see. only the ground outside the city turns black. thxs
  6. Hola buenas noches, queria hacerles una consulta sobre como sacar el auto create account de mi server... Estoy empezando con servidores de l2, tengo algo de conocimiento en java y queria ver que onda con los servers de l2 porque siempre me gusto este juego. mi server(datapack) es l2jFrozen Hice una pagina web en php para agregar cuentas a la tabla account y me gustaria quitar que no se creen mas cuentas desde el cliente. Si mi publicacion esta mal en este lugar diganme, la coloque aca por sentido comun xd Buenas noches y gracias. ------------------------------------------ Hello good evening, I wanted to ask you a question about how to remove the auto create account from my server... I'm starting with l2 servers, I have some knowledge in java and I wanted to see about l2 servers because I always liked this game my server(datapack) is l2jFrozen I made a web page in php to add accounts to the account table and I would like to remove that no more accounts are created from the client. If my publication is wrong in this place, tell me, I'll put it here for common sense xd Good night and thank you.
×
×
  • Create New...