RubenAlonso

Hi all im trying to adapt a community buffer to h5 the problem is some class l2skill and skilltable doesnt exist i tryied to change l2skill for skill, getinfo for getskill and skilltable for skilldata but still error i think it is more complicated than that /* * 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://l2jpsproject.eu/>. */ package com.l2jserver.gameserver.communitybbs.Managers; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.l2jserver.Config; import com.l2jserver.L2DatabaseFactory; import com.l2jserver.gameserver.datatables.SkillTable; import com.l2jserver.gameserver.model.actor.instance.L2PcInstance; import com.l2jserver.gameserver.model.skills.L2Skill; /** * @RobikBobik */ public class BuffBBSManager extends BaseBBSManager { private static BuffBBSManager _instance = new BuffBBSManager(); public int allskillid_1[][]; public BuffBBSManager() { Load(); } public static BuffBBSManager getInstance() { if (_instance == null) { _instance = new BuffBBSManager(); } return _instance; } public void Load() { Connection connn = null; try { connn = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement count = connn.prepareStatement("SELECT COUNT(*) FROM communitybuff"); ResultSet countt = count.executeQuery(); countt.next(); allskillid_1 = new int[countt.getInt(1)][4]; PreparedStatement table = connn.prepareStatement("SELECT * FROM communitybuff"); ResultSet skills = table.executeQuery(); for (int i = 0; i < allskillid_1.length; i++) { skills.next(); allskillid_1[i][0] = skills.getInt(2); allskillid_1[i][1] = skills.getInt(3); allskillid_1[i][2] = skills.getInt(4); allskillid_1[i][3] = skills.getInt(5); } count.close(); countt.close(); skills.close(); table.close(); connn.close(); } catch (Exception ignored) { } } @Override public void parsecmd(String command, L2PcInstance activeChar) { String[] parts = command.split("_"); boolean petbuff = false; if (!(parts[2].startsWith("buff"))) { return; } if ((parts[4] != null) && parts[4].startsWith(" Player")) { petbuff = false; } if ((parts[4] != null) && parts[4].startsWith(" Pet")) { petbuff = true; } if (parts[3].startsWith("FIGHERLIST")) { FIGHERLIST(activeChar, petbuff); } if (parts[3].startsWith("MAGELIST")) { MAGELIST(activeChar, petbuff); } /* * if (parts[3].startsWith("SAVE")) { SAVE(activeChar, petbuff); } */ if (parts[3].startsWith("BUFF")) { BUFF(activeChar, petbuff); } if (parts[3].startsWith("CANCEL")) { CANCEL(activeChar, petbuff); } if (parts[3].startsWith("REGMP")) { REGMP(activeChar, petbuff); } if (parts[3].startsWith("REGHP")) { REGHP(activeChar, petbuff); } if (parts[3].startsWith("REGCP")) { REGCP(activeChar, petbuff); } for (int key = 0; key < allskillid_1.length; key++) { L2Skill skill; int skilllevel; skilllevel = SkillTable.getInstance().getMaxLevel(allskillid_1[key][0]); skill = SkillTable.getInstance().getInfo(allskillid_1[key][0], skilllevel); if (parts[3].startsWith(skill.getName())) { SKILL(activeChar, petbuff, key, skill); } } } private void FIGHERLIST(L2PcInstance activeChar, boolean petbuff) { int arr$[][] = allskillid_1; int len$ = arr$.length; for (int i$ = 0; i$ < len$; i$++) { int aSkillid[] = arr$[i$]; if ((aSkillid[1] != 1) && (aSkillid[1] != 3)) { continue; } L2Skill skill; int skilllevel; if (Config.BUFF_COST) { if (activeChar.destroyItemByItemId(null, aSkillid[3], aSkillid[2], activeChar, true)) { skilllevel = SkillTable.getInstance().getMaxLevel(aSkillid[0]); skill = SkillTable.getInstance().getInfo(aSkillid[0], skilllevel); if (!petbuff) { skill.applyEffects(activeChar, activeChar); } else { skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } else { activeChar.sendMessage("You don't have adena for using service."); } continue; } skilllevel = SkillTable.getInstance().getMaxLevel(aSkillid[0]); skill = SkillTable.getInstance().getInfo(aSkillid[0], skilllevel); if (!petbuff) { skill.applyEffects(activeChar, activeChar); } else { skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } } private void MAGELIST(L2PcInstance activeChar, boolean petbuff) { int arr$[][] = allskillid_1; int len$ = arr$.length; for (int i$ = 0; i$ < len$; i$++) { int aSkillid[] = arr$[i$]; if ((aSkillid[1] != 2) && (aSkillid[1] != 3)) { continue; } L2Skill skill; int skilllevel; if (Config.BUFF_COST) { if (activeChar.destroyItemByItemId(null, aSkillid[3], aSkillid[2], activeChar, true)) { skilllevel = SkillTable.getInstance().getMaxLevel(aSkillid[0]); skill = SkillTable.getInstance().getInfo(aSkillid[0], skilllevel); if (!petbuff) { skill.applyEffects(activeChar, activeChar); } else { skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } else { activeChar.sendMessage("You don't have adena for using service."); } continue; } skilllevel = SkillTable.getInstance().getMaxLevel(aSkillid[0]); skill = SkillTable.getInstance().getInfo(aSkillid[0], skilllevel); if (!petbuff) { skill.applyEffects(activeChar, activeChar); } else { skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } } private void BUFF(L2PcInstance activeChar, boolean petbuff) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement statement = con.prepareStatement("SELECT * FROM community_skillsave WHERE charId=?;"); statement.setInt(1, activeChar.getObjectId()); ResultSet rcln = statement.executeQuery(); rcln.next(); if (!petbuff) { char allskills[] = rcln.getString(2).toCharArray(); if (allskills.length == allskillid_1.length) { for (int i = 0; i < allskillid_1.length; i++) { if (allskills[i] == '1') { if (Config.BUFF_COST) { if (activeChar.destroyItemByItemId(null, allskillid_1[i][3], allskillid_1[i][2], activeChar, true)) { int skilllevel = SkillTable.getInstance().getMaxLevel(allskillid_1[i][0]); L2Skill skill = SkillTable.getInstance().getInfo(allskillid_1[i][0], skilllevel); skill.applyEffects(activeChar, activeChar); activeChar.getLevel(); } else { activeChar.sendMessage("You don't have adena for using service."); } } else { int skilllevel = SkillTable.getInstance().getMaxLevel(allskillid_1[i][0]); L2Skill skill = SkillTable.getInstance().getInfo(allskillid_1[i][0], skilllevel); skill.applyEffects(activeChar, activeChar); } } } } } else { char petskills[] = rcln.getString(3).toCharArray(); if (petskills.length == allskillid_1.length) { for (int i = 0; i < allskillid_1.length; i++) { if (petskills[i] != '1') { continue; } if (Config.BUFF_COST) { if (activeChar.destroyItemByItemId(null, allskillid_1[i][3], allskillid_1[i][2], activeChar, true)) { int skilllevel = SkillTable.getInstance().getMaxLevel(allskillid_1[i][0]); L2Skill skill = SkillTable.getInstance().getInfo(allskillid_1[i][0], skilllevel); skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } else { activeChar.sendMessage("You don't have adena for using service."); } } else { int skilllevel = SkillTable.getInstance().getMaxLevel(allskillid_1[i][0]); L2Skill skill = SkillTable.getInstance().getInfo(allskillid_1[i][0], skilllevel); skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } } } rcln.close(); statement.close(); } catch (Exception ignored) { try { if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } try { if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } private void CANCEL(L2PcInstance activeChar, boolean petbuff) { if (!petbuff) { activeChar.stopAllEffects(); } else { activeChar.getSummon().stopAllEffects(); } } private void REGMP(L2PcInstance activeChar, boolean petbuff) { if (!petbuff) { activeChar.setCurrentMp(activeChar.getMaxMp()); } else { activeChar.getSummon().setCurrentMp(activeChar.getSummon().getMaxMp()); } } private void REGHP(L2PcInstance activeChar, boolean petbuff) { if (!petbuff) { activeChar.setCurrentHp(activeChar.getMaxHp()); } else { activeChar.getSummon().setCurrentHp(activeChar.getSummon().getMaxHp()); } } private void REGCP(L2PcInstance activeChar, boolean petbuff) { if (!petbuff) { activeChar.setCurrentCp(activeChar.getMaxCp()); } else { activeChar.getSummon().setCurrentCp(activeChar.getSummon().getMaxCp()); } } private void SKILL(L2PcInstance activeChar, boolean petbuff, int key, L2Skill skill) { if (Config.BUFF_COST) { if (activeChar.destroyItemByItemId(null, allskillid_1[key][3], allskillid_1[key][2], activeChar, true)) { if (!petbuff) { skill.applyEffects(activeChar, activeChar); } else { skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } else { activeChar.sendMessage("You don't have adena for using service."); } } else if (!petbuff) { skill.applyEffects(activeChar, activeChar); } else { skill.applyEffects(activeChar.getSummon(), activeChar.getSummon()); } } /* * private void SAVE(L2PcInstance activeChar, boolean petbuff) { Connection con = null; try { con = L2DatabaseFactory.getInstance().getConnection(); PreparedStatement stat = con.prepareStatement("SELECT COUNT(*) FROM community_skillsave WHERE charId=?;"); stat.setInt(1, * activeChar.getObjectId()); ResultSet rset = stat.executeQuery(); rset.next(); String allbuff = ""; if (!petbuff) { L2Effect skill[] = activeChar.getAllEffectsCB(); boolean flag = true; int arr$[][] = allskillid_1; int len$ = arr$.length; for (int i$ = 0; i$ < len$; i$++) { int aSkillid[] = * arr$[i$]; for (int j = 0; j < skill.length; j++) { if (aSkillid[0] == skill[j].getId()) { allbuff = (new StringBuilder()).append(allbuff).append(1).toString(); flag = false; } if ((j == (skill.length - 1)) && flag) { allbuff = (new StringBuilder()).append(allbuff).append(0).toString(); } } * flag = true; } if (rset.getInt(1) == 0) { PreparedStatement statement1 = con.prepareStatement("INSERT INTO community_skillsave (charId,skills) values (?,?)"); statement1.setInt(1, activeChar.getObjectId()); statement1.setString(2, allbuff); statement1.execute(); statement1.close(); } else { * PreparedStatement statement = con.prepareStatement("UPDATE community_skillsave SET skills=? WHERE charId=?;"); statement.setString(1, allbuff); statement.setInt(2, activeChar.getObjectId()); statement.execute(); statement.close(); } } else { L2Effect skill[] = * activeChar.getSummon().getAllEffectsCB(); boolean flag = true; int arr$[][] = allskillid_1; int len$ = arr$.length; for (int i$ = 0; i$ < len$; i$++) { int aSkillid[] = arr$[i$]; for (int j = 0; j < skill.length; j++) { if (aSkillid[0] == skill[j].getId()) { allbuff = (new * StringBuilder()).append(allbuff).append(1).toString(); flag = false; } if ((j == (skill.length - 1)) && flag) { allbuff = (new StringBuilder()).append(allbuff).append(0).toString(); } } flag = true; } if (rset.getInt(1) == 0) { PreparedStatement statement1 = * con.prepareStatement("INSERT INTO community_skillsave (charId,pet) values (?,?)"); statement1.setInt(1, activeChar.getObjectId()); statement1.setString(2, allbuff); statement1.execute(); statement1.close(); } else { PreparedStatement statement = * con.prepareStatement("UPDATE community_skillsave SET pet=? WHERE charId=?;"); statement.setString(1, allbuff); statement.setInt(2, activeChar.getObjectId()); statement.execute(); statement.close(); } } rset.close(); stat.close(); } catch (Exception ignored) { try { if (con != null) { * con.close(); } } catch (SQLException e) { e.printStackTrace(); } } try { if (con != null) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } */ @Override public void parsewrite(String s, String s1, String s2, String s3, String s4, L2PcInstance l2pcinstance) { } } Thank You For Your Help

okey thank you

hello guys now l2jserver has been closed which svn is a good alternative for a h5 server

good share man and ty someone can get from this db the auction from community in a patch mode to put in others database?

Gamserver error

i cannot make it work

nice share i was searching for something like that

there are a lot of skills to do same with all of them

this sound interesting im going to try it

they are codes missing

and how i can make for l2jserver

if you put anti dualbox pvp perfect

i dont have zone_vertices how i can do it

but how it work plis post a bit of info

I have l2jserver and I dont have zone_vertices someone can tell me how I can apply this patch plis