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