barao45

Thanks bro!! solved.

Hello! i'm trying to show info from database into CommunityBoard. I would like to show, if the clan has ClanHall or Fortress, etc. I write this but its getting an error and i dont know why. java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:935) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:924) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:870) at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:781) at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5239) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5162) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5201) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:263) at l2r.gameserver.model.L2Clan.getHideOutName(L2Clan.java:3014) at l2r.gameserver.communitybbs.Managers.ClanBBSManager.clanhome(ClanBBSManager.java:253) at l2r.gameserver.communitybbs.Managers.ClanBBSManager.clanhome(ClanBBSManager.java:234) at l2r.gameserver.communitybbs.Managers.ClanBBSManager.cbByPass(ClanBBSManager.java:50) at l2r.gameserver.communitybbs.BoardsManager.handleCommands(BoardsManager.java:80) at l2r.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:251) at l2r.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:71) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) This is the backEnd. public String getHideOutName(int ownerId) { String x = null; try (Connection con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement ps = con.prepareStatement("SELECT DISTINCT name FROM `clanhall` cl INNER JOIN `clan_data` c ON cl.ownerId = ?");) { ps.setInt(1, ownerId); ResultSet rs = ps.executeQuery(); x = rs.getString("name"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if (x == null) { return "None"; } return x; } Please, someone can give me a hand with this?. Thanks!!

People. does anyone tryed to reload the ui using this interface?. i have tested it but there was a problem in RefOptWnd that crashes when use ///reloadui. I have detected when the RefOptWnd has RefineryWnd as a OwnerWindows value and you try to reload that interface explotes and L2Client closes.

Hello guys. have anyone this interface updated and would like to share it?. Its cracked?. i used a older version and crashes when i use reloadui.

Thanks. I tested the folder and i saw that this error becomes from conflicts between interface.u and xdat. there is a posibility to check errors between them or its time to read all interface.u and check witch windows is getting errors.

Interface Exilium. Chronicle High Five. I just added systemtextures, system and sound fouldes from scratch.

Hi guys, could you helpme with this?. I used a interface that i have downloaded but i get this error when i reload UI in game, i dont know which window is getting this error.

thanks bro. i will check it

Hi guys, i wanna implements this systemmessages like this video but i dont now how can do it. i think using a textures and editing systemmsg?. https://www.youtube.com/watch?v=S_ul4tVjBjQ

alguien lo ha utilizado con sunrise?. No he podido unificar el tema del BBSTOPS y EL SERVICES. ya que para que se vean los stats como lvl, class etc requiere una instancia de Tops y para utilizar el teleport y buffer no funciona ya que estas dentro de una instancia top.

THanks for your answers frinds. i could implement my voiced command. But. a question. In the constructor shows something like this, but how it is posible to run others comands like .online or .repair if the are not added in this Class VoicedCommandHandler?. public class VoicedCommandHandler implements IHandler<IVoicedCommandHandler, String> { private final Map<String, IVoicedCommandHandler> _datatable; protected VoicedCommandHandler() { _datatable = new HashMap<>(); registerHandler(new SevenRB()); registerHandler(new RaidVCmd()); } @Override public void registerHandler(IVoicedCommandHandler handler) { String[] ids = handler.getVoicedCommandList(); for (String id : ids) { _datatable.put(id, handler); } } @Override public synchronized void removeHandler(IVoicedCommandHandler handler) { String[] ids = handler.getVoicedCommandList(); for (String id : ids) { _datatable.remove(id); } } @Override public IVoicedCommandHandler getHandler(String voicedCommand) { String command = voicedCommand; if (voicedCommand.contains(" ")) { command = voicedCommand.substring(0, voicedCommand.indexOf(" ")); } return _datatable.get(command); } @Override public int size() { return _datatable.size(); } public static VoicedCommandHandler getInstance() { return SingletonHolder._instance; } private static class SingletonHolder { protected static final VoicedCommandHandler _instance = new VoicedCommandHandler(); } }

Do you know if its required another think to implements this voice comander?. im using L2jSunrise. When i enter .7rb its nothing happen.

Hi people. Does have anyone a decompiled source files from L2Jsunrise 986 files? i wanna edit engine. jar to implement new things.

Solved!

it didnt work :S

Doesnt working. Could be the java version?. In my libraries im using jdk 11.

Hi guys. i started creating new stuff again... and i am getting this error when i m trying to use the build.xml. L2J_SunriseProject_Core\dist\libs\mmocore.jar; java.net.URISyntaxException: Illegal character in path at index 111: file:/F:/DISCOVIEJO/SERVER/L2JSUNRISE/Sunrise%20986-878%20Clean%20No%20Keys/L2J_SunriseProject_Core/dist/libs/${manifest.libs} do you know wich is the problem?.

} Thanks Root, i have exported source from engine.jar, i have created a Java Project with java 11 because Sunrise use that. then i copy the files to the project and imported a library of l24j. That error has been resolved, but tha source has an error because cant find de l2r.DatabaseFactory and L2PCInstance. i share the images. If i export that source i think that it wouldnt work. https://ibb.co/z28XxKg https://ibb.co/TvZbYf8

Hi Friends. I am learning a little how to edit jar files from the Core, i Need to modify the engine.jar to add some lines in donatemanager class for the classes changer but i got an error when i import the jar file to my proyecto,for example error in imports Like log4j. Could you explain the Steps to modify and import this files to our project?.

Thanks Arm, but my interest is to add a tab link in community to show the Player Skills Learn Windows. I think that you shared the class to implement a Skill Enchanter. Do you know how to show the Skills Learn?

Hi Guys, do you know how can i implement a button in my communityboard that when you click in that button, a skilltrainer windows opens?. I hope you can help me. Im using L2jsunrise THanks!

I wanna add some pictures to a interface file .u for my community board. Have anyone any idea that wath app must y use to create it?. THanks

Hello Friends, i wanna add to my home community board a buttons, for example (buffer, gatekeeper). I write in the BoardsManager.java the command and in the ServicesBBSManager.java the command but in the game i am getting the message "the command _bbspipin;gatekeeper is not implemented yet. I dont know how can add this addons, has anyone the possibility to help me please?. public class BoardsManager { public void handleCommands(L2GameClient client, String command) { L2PcInstance activeChar = client.getActiveChar(); if (activeChar == null) { return; } if (SunriseEvents.cbBypass(activeChar, command)) { return; } if (CommunityDonateConfigs.COMMUNITY_DONATE_ALLOW && command.startsWith(CommunityDonateConfigs.BYPASS_COMMAND)) { DonateBBSManager.getInstance().cbByPass(command, activeChar); return; } if (!Config.ENABLE_COMMUNITY) { activeChar.sendPacket(SystemMessageId.CB_OFFLINE); return; } if (command.startsWith(ServicesBBSManager.getInstance()._servicesBBSCommand)) { ServicesBBSManager.getInstance().cbByPass(command, activeChar); return; } if (command.startsWith("_bbspipin")) { ServicesBBSManager.getInstance().cbByPass(command, activeChar); } if (command.startsWith("_bbsclan")) { ClanBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbsmemo")) { // TopicBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbstopics")) { TopicBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbsposts")) { PostBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbstop")) { TopBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbshome")) { TopBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_maillist")) { MailBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_friendlist_0_") || command.startsWith("_bbs_friends") || command.startsWith("_bbsfriends")) { } else if (command.startsWith("_bbsloc")) { // RegionBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbsgetfav") || command.startsWith("bbs_add_fav") || command.startsWith("_bbsdelfav_")) { FavoriteBBSManager.getInstance().cbByPass(command, activeChar); } else if (command.startsWith("_bbslink")) { // RegionBBSManager.getInstance().cbByPass(command, activeChar); } else { ShowBoard sb = new ShowBoard("<html><body><br><br><center>the command: " + command + " is not implemented yet</center><br><br></body></html>", "101"); activeChar.sendPacket(sb); activeChar.sendPacket(new ShowBoard(null, "102")); activeChar.sendPacket(new ShowBoard(null, "103")); } } public void handleWriteCommands(L2GameClient client, String url, String arg1, String arg2, String arg3, String arg4, String arg5) { L2PcInstance activeChar = client.getActiveChar(); if (activeChar == null) { return; } if (url.equals("Topic")) { TopicBBSManager.getInstance().parsewrite(url, arg1, arg2, arg3, arg4, arg5, activeChar); } else if (url.equals("Post")) { PostBBSManager.getInstance().parsewrite(url, arg1, arg2, arg3, arg4, arg5, activeChar); } else if (url.equals("Region")) { // Future usage // RegionBBSManager.getInstance().parsewrite(url, arg1, arg2, arg3, arg4, arg5, activeChar); } else if (url.equals("Friends")) { // Future usage // FriendsBBSManager.getInstance().parsewrite(url, arg1, arg2, arg3, arg4, arg5, activeChar); } else if (url.equals("Notice")) { ClanBBSManager.getInstance().parsewrite(url, arg1, arg2, arg3, arg4, arg5, activeChar); } else if (url.equals("Mail")) { MailBBSManager.getInstance().parsewrite(url, arg1, arg2, arg3, arg4, arg5, activeChar); } else { // no nothing } return; } // This will be used for favorite bbs manager /** The bypasses used by the players. */ private final Map<Integer, String> _bypasses = new ConcurrentHashMap<>(); /** * Sets the last bypass used by the player. * @param player the player * @param title the title * @param bypass the bypass */ public void addBypass(L2PcInstance player, String title, String bypass) { _bypasses.put(player.getObjectId(), title + "&" + bypass); } /** * Removes the last bypass used by the player. * @param player the player * @return the last bypass used */ public String removeBypass(L2PcInstance player) { return _bypasses.remove(player.getObjectId()); } public static BoardsManager getInstance() { return SingletonHolder._instance; } private static class SingletonHolder { protected static final BoardsManager _instance = new BoardsManager(); } } // CLASS SERVICESBBSManager public class ServicesBBSManager extends BaseBBSManager { public String _servicesBBSCommand = CommunityServicesConfigs.BYPASS_COMMAND; @Override public void cbByPass(String command, L2PcInstance activeChar) { if (!CommunityServicesConfigs.COMMUNITY_SERVICES_ALLOW) { activeChar.sendMessage("This function is disabled by admin."); return; } String path = "data/html/CommunityBoard/services/"; String filepath = ""; String content = ""; if (command.equals(_servicesBBSCommand + "")) { BoardsManager.getInstance().addBypass(activeChar, "Service Command", command); filepath = path + "main.htm"; content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), filepath); separateAndSend(content, activeChar); } else if (command.startsWith("_bbspipin" + ";gatekeeper")) { BoardsManager.getInstance().addBypass(activeChar, "Service Command", command); filepath = path + "main.htm"; content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), filepath); separateAndSend(content, activeChar); } else if (command.startsWith(_servicesBBSCommand + ";gatekeeper")) { BoardsManager.getInstance().addBypass(activeChar, "Service Gatekeeper", command); StringTokenizer st = new StringTokenizer(command, ";"); st.nextToken(); st.nextToken(); String file = st.nextToken(); path = "data/html/CommunityBoard/services/gatekeeper/"; sendHtm(activeChar, filepath, path, file, command); } else if (command.startsWith(_servicesBBSCommand + ";")) { StringTokenizer st = new StringTokenizer(command, ";"); st.nextToken(); String file = st.nextToken(); sendHtm(activeChar, filepath, path, file, command); } else if (command.startsWith(_servicesBBSCommand + "_sendMultisell")) { BoardsManager.getInstance().addBypass(activeChar, "Service Multisell", command); if (!CommunityServicesConfigs.COMMUNITY_SERVICES_SHOP_ALLOW) { activeChar.sendMessage("This function is disabled by admin."); return; } if (!CommunityServicesConfigs.COMMUNITY_SERVICES_SHOP_NONPEACE && !activeChar.isInsideZone(ZoneIdType.PEACE)) { activeChar.sendMessage("You cannot use this function outside peace zone."); } else { try { String multisell = commandSeperator(command); int multi = Integer.valueOf(multisell); switch (multi) { case 90525: content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), "data/html/CommunityBoard/services/symbolMaker.htm"); break; case 90526: content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), "data/html/CommunityBoard/services/warehouse.htm"); break; case 90539: case 90540: case 90541: content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), "data/html/CommunityBoard/services/exclusiveShop.htm"); break; default: content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), "data/html/CommunityBoard/services/gmshop.htm"); break; } if ((multi == 90527) || (multi == 90528) || (multi == 90529) || (multi == 90530) || (multi == 90531) || (multi == 90532) || (multi == 90533) || (multi == 90534) || (multi == 90535) || (multi == 90536) || (multi == 90537) || (multi == 90538)) { content = HtmCache.getInstance().getHtm(activeChar, activeChar.getHtmlPrefix(), "data/html/CommunityBoard/services/blacksmith.htm"); } separateAndSend(content, activeChar); if (CommunityServicesConfigs.MULTISELL_LIST.contains(multi)) { activeChar.setIsUsingAioMultisell(true); MultisellData.getInstance().separateAndSend(multi, activeChar, null, false); } else { SecurityActions.startSecurity(activeChar, SecurityType.COMMUNITY_SYSTEM); } } catch (Exception e) { SecurityActions.startSecurity(activeChar, SecurityType.COMMUNITY_SYSTEM); } } } and continues

Hi, i am creating a custom communityboard but i am stuck when i want to add a gatekeeper or a buffer into the community. I am using datapack Sunrise and for example i wanna put the buffer into de community but i dont know how bypasses works. Can anybody bring me some help plis?. THanks!

which is the community board selector?. i want to modify tabs and colors or add images.