[Share] Repair clientcrash on character enter

beenery · October 9, 2010

masterhandler.java clean my ta ai so later add the code please

/*
* 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;

import handlers.admincommandhandlers.*;
import handlers.donatorcommandhandlers.*;
import handlers.scripthandlers.*;
import handlers.voicedcommandhandlers.*;

import com.l2jserver.gameserver.handler.*;

public class MasterHandler
{
private static void loadAdminHandlers()
{
	AdminCommandHandler.getInstance().registerAdminCommandHandler(new AdminFile());
}

private static void loadDonatorHandlers()
{
	DonatorCommandHandler.getInstance().registerDonatorCommandHandler(new DonatorFile());
}

private static void loadScriptHandlers()
{
	ScriptHandler.getInstance().registerHandler(new EnterWorld());
	ScriptHandler.getInstance().registerHandler(new OnDeath());
	ScriptHandler.getInstance().registerHandler(new OnExit());
	ScriptHandler.getInstance().registerHandler(new OnKill());
	ScriptHandler.getInstance().registerHandler(new OnRess());
}

private static void loadVoicedHandlers()
{
	VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new VoicedFile());
}

public static void main(String[] args)
{
	loadAdminHandlers();
	loadDonatorHandlers();
	loadScriptHandlers();
	loadVoicedHandlers();
}
}

metropol81 · October 9, 2010

lol man...

/*
* 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;

import handlers.admincommandhandlers.*;
import handlers.donatorcommandhandlers.*;
import handlers.scripthandlers.*;
import handlers.voicedcommandhandlers.*;

import com.l2jserver.gameserver.handler.*;

public class MasterHandler
{

private static void loadAdminHandlers()
{
	AdminCommandHandler.getInstance().registerAdminCommandHandler(new AdminFile());
}

private static void loadDonatorHandlers()
{
	DonatorCommandHandler.getInstance().registerDonatorCommandHandler(new DonatorFile());
}

private static void loadScriptHandlers()
{
	ScriptHandler.getInstance().registerHandler(new EnterWorld());
	ScriptHandler.getInstance().registerHandler(new OnDeath());
	ScriptHandler.getInstance().registerHandler(new OnExit());
	ScriptHandler.getInstance().registerHandler(new OnKill());
	ScriptHandler.getInstance().registerHandler(new OnRess());
}

private static void loadVoicedHandlers()
{
	VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new VoicedFile());
+               if (Config.REPAIR_ALLOW_REPAIR)
+	 	     VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new Repair());
}

public static void main(String[] args)
{
	loadAdminHandlers();
	loadDonatorHandlers();
	loadScriptHandlers();
	loadVoicedHandlers();
}
}

+cs.tribal · October 9, 2010

+cs.Tribal®™ 's Request

/*
* 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.voicedcommandhandlers;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Logger;

import com.l2jserver.gameserver.cache.HtmCache;
import com.l2jserver.L2DatabaseFactory;
import com.l2jserver.gameserver.handler.IVoicedCommandHandler;
import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
import com.l2jserver.gameserver.network.serverpackets.NpcHtmlMessage;

/**
* <B><U>User Character .repair voicecommand - SL2 L2JEmu</U></B><BR><BR>
*
* 
* <U>NOTICE:</U> Voice command .repair that when used, allows player to
* try to repair any of characters on his account, by setting spawn
* to Floran, removing all shortcuts and moving everything equipped to
* that char warehouse.<BR><BR>
*
*
* (solving client crashes on character entering world)<BR><BR>
*
*
* @author szponiasty
* @version $Revision: 0.17.2.95.2.9 $ $Date: 2010/03/03 9:07:11 $
*/

public class Repair implements IVoicedCommandHandler
{
static final Logger _log = Logger.getLogger(Repair.class.getName());

private static final String[]	 _voicedCommands	=
	{ 
	"repair", 
	"startrepair"
	};

public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target)
{		
	if (activeChar==null)
		return false;

	String repairChar=null;

	try		
	{
		if(target != null)
			if(target.length() > 1)
			  {
			   String[] cmdParams = target.split(" ");
			   repairChar=cmdParams[0];
			  }
	}
	catch (Exception e)
	{
		repairChar = null;
	}						
	// Send activeChar HTML page
	if (command.startsWith("repair"))               
	{             
		String htmContent = HtmCache.getInstance().getHtm(activeChar.getHtmlPrefix(), "data/html/mods/repair/repair.htm");
		NpcHtmlMessage npcHtmlMessage = new NpcHtmlMessage(5);
		npcHtmlMessage.setHtml(htmContent);		
		npcHtmlMessage.replace("%acc_chars%", getCharList(activeChar));
		activeChar.sendPacket(npcHtmlMessage);	
		return true;
	}
	// Command for enter repairFunction from html
	if (command.startsWith("startrepair") && (repairChar != null))
	{
		//_log.warning("Repair Attempt: Character " + repairChar);
			if (checkAcc(activeChar,repairChar))
			{
				if (checkChar(activeChar,repairChar))
				{
					String htmContent = HtmCache.getInstance().getHtm(activeChar.getHtmlPrefix(), "data/html/mods/repair/repair-self.htm");
					NpcHtmlMessage npcHtmlMessage = new NpcHtmlMessage(5);
					npcHtmlMessage.setHtml(htmContent);
					activeChar.sendPacket(npcHtmlMessage);
					return false;
				}
				else if (checkJail(activeChar,repairChar))
				{
					String htmContent = HtmCache.getInstance().getHtm(activeChar.getHtmlPrefix(), "data/html/mods/repair/repair-jail.htm");
					NpcHtmlMessage npcHtmlMessage = new NpcHtmlMessage(5);
					npcHtmlMessage.setHtml(htmContent);
					activeChar.sendPacket(npcHtmlMessage);	
					return false;
				}
+                                      else if (checkKarma(activeChar,repairChar))
+		                        {
+			                        activeChar.sendMessage("Selected Char has Karma,Cannot be repaired!");
+			                        return false;
+		                        }
				else
				{
					repairBadCharacter(repairChar);
					String htmContent = HtmCache.getInstance().getHtm(activeChar.getHtmlPrefix(), "data/html/mods/repair/repair-done.htm");
					NpcHtmlMessage npcHtmlMessage = new NpcHtmlMessage(5);
					npcHtmlMessage.setHtml(htmContent);
					activeChar.sendPacket(npcHtmlMessage);
					return true;
				}
			}
			else
			{
				String htmContent = HtmCache.getInstance().getHtm(activeChar.getHtmlPrefix(), "data/html/mods/repair/repair-error.htm");
				NpcHtmlMessage npcHtmlMessage = new NpcHtmlMessage(5);
				npcHtmlMessage.setHtml(htmContent);
				activeChar.sendPacket(npcHtmlMessage);
				return false;
			}
	}
	//_log.warning("Repair Attempt: Failed. ");
	return false;
}

private String getCharList(L2PcInstance activeChar)
{
	String result="";
	String repCharAcc=activeChar.getAccountName();
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
		PreparedStatement statement = con.prepareStatement("SELECT char_name FROM characters WHERE account_name=?");
		statement.setString(1, repCharAcc);
		ResultSet rset = statement.executeQuery();
		while (rset.next())
		{
			if (activeChar.getName().compareTo(rset.getString(1)) != 0)
				result += rset.getString(1)+";";
		}
		//_log.warning("Repair Attempt: Output Result for searching characters on account:"+result);
		rset.close();
		statement.close();
	}
	catch (SQLException e)
	{
		e.printStackTrace();
		return result;
	}
	finally
	{
		try
		{
			if (con != null)
				con.close();
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	return result;	
}

private boolean checkAcc(L2PcInstance activeChar,String repairChar)
{
	boolean result=false;
	String repCharAcc="";
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
		PreparedStatement statement = con.prepareStatement("SELECT account_name FROM characters WHERE char_name=?");
		statement.setString(1, repairChar);
		ResultSet rset = statement.executeQuery();
		if (rset.next())
		{
			repCharAcc = rset.getString(1);
		}
		rset.close();
		statement.close();

	}
	catch (SQLException e)
	{
		e.printStackTrace();
		return result;
	}
	finally
	{
		try
		{
			if (con != null)
				con.close();
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	if (activeChar.getAccountName().compareTo(repCharAcc)==0)
		result=true;
	return result;
}

private boolean checkJail(L2PcInstance activeChar,String repairChar)
{
	boolean result=false;
	int repCharJail = 0;
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
		PreparedStatement statement = con.prepareStatement("SELECT punish_level FROM characters WHERE char_name=?");
		statement.setString(1, repairChar);
		ResultSet rset = statement.executeQuery();
		if (rset.next())
		{
			repCharJail = rset.getInt(1);
		}
		rset.close();
		statement.close();

	}
	catch (SQLException e)
	{
		e.printStackTrace();
		return result;
	}
	finally
	{
		try
		{
			if (con != null)
				con.close();
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	if (repCharJail > 1) // 0 norm, 1 chat ban, 2 jail, 3....
		result=true;
	return result;
}

+      private boolean checkKarma(L2PcInstance activeChar,String repairChar)
+	{
+		boolean result=false;
+		int repCharKarma = 0;
+		Connection con = null;
+		try
+		{
+			con = L2DatabaseFactory.getInstance().getConnection();
+			PreparedStatement statement = con.prepareStatement("SELECT karma FROM characters WHERE char_name=?");
+			statement.setString(1, repairChar);
+			ResultSet rset = statement.executeQuery();
+			if (rset.next())
+			{
+				repCharKarma = rset.getInt(1);
+			}
+			rset.close();
+			statement.close();
+		}
+		catch (SQLException e)
+		{
+			e.printStackTrace();
+			return result;
+		}
+		finally
+		{
+			try
+			{
+				if (con != null)
+					con.close();
+			}
+			catch (SQLException e)
+			{
+				e.printStackTrace();
+			}
+		}
+		if (repCharKarma > 0) 
+			result=true;
+		return result;
+	}

private boolean checkChar(L2PcInstance activeChar,String repairChar)
{
	boolean result=false;
	if (activeChar.getName().compareTo(repairChar)==0)
		result=true;
	return result;
}

private void repairBadCharacter(String charName)
{
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();

		PreparedStatement statement;
		statement = con.prepareStatement("SELECT charId FROM characters WHERE char_name=?");
		statement.setString(1, charName);
		ResultSet rset = statement.executeQuery();

		int objId = 0;
		if (rset.next())
		{
			objId = rset.getInt(1);
		}
		rset.close();
		statement.close();
		if (objId == 0)
		{
			con.close();
			return;
		}
		statement = con.prepareStatement("UPDATE characters SET x=17867, y=170259, z=-3503 WHERE charId=?");
		statement.setInt(1, objId);
		statement.execute();
		statement.close();
		statement = con.prepareStatement("DELETE FROM character_shortcuts WHERE charId=?");
		statement.setInt(1, objId);
		statement.execute();
		statement.close();
		statement = con.prepareStatement("UPDATE items SET loc=\"WAREHOUSE\" WHERE owner_id=? AND loc=\"PAPERDOLL\"");
		statement.setInt(1, objId);
		statement.execute();
		statement.close();
	}
	catch (Exception e)
	{
		_log.warning("GameServer: could not repair character:" + e);
	}
	finally
	{
		try
		{
			if (con != null)
				con.close();
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
}

public String[] getVoicedCommandList()
{
	return _voicedCommands;
}
}

thank you mate... this is exactly what i wanted!

i hope i'll work!

beenery · October 10, 2010

still gave the error gameserver see

Loading Server Scripts

----------

1. ERROR in \ MasterHandler.java (at line 49)

if (Config.REPAIR_ALLOW_REPAIR)

^^^^^^

Config can not be resolved

----------

1 problem (1 error) Failed executing script

that must be for something in config.java?

beenery · October 10, 2010

worked well in parts:

private static void loadVoicedHandlers()
{
	VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new VoicedFile());
-               if (Config.REPAIR_ALLOW_REPAIR)
+		    VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new Repair());
}

see image does not appear to select the char name is only empty space and it's impossible to enter nen. what I do now?

....

metropol81 · October 10, 2010

still gave the error gameserver see

Loading Server Scripts

----------

1. ERROR in \ MasterHandler.java (at line 49)

if (Config.REPAIR_ALLOW_REPAIR)

^^^^^^

Config can not be resolved

----------

1 problem (1 error) Failed executing script

that must be for something in config.java?

1.well you get error cause you havent registered Config.REPAIR_ALLOW_REPAIR in Config.java

2.Maybe you haven't other Char on this account? thats why is empty? lol man...

with the char that you load .repair he is not show in the list

beenery · October 11, 2010

thank you friends here finally got this all worked out thanks to all ...

conf18 · August 5, 2011

link off

ČυяŞŀŅğ · August 7, 2011

i like it :D but should be on npc i think

Over12 · August 8, 2011

nice idea no bad!! +1

gRfd` · August 12, 2011

It's already implented, on some l2j packs :)

danilo10 · August 15, 2011

Upload again plz

~~Darius~~ · August 31, 2011

http://www.speedyshare.com/files/30118617/repair_char.zip

Zake · September 1, 2011

link broken

marcose · September 12, 2011

Nice share, keep working. :P

[Share] Repair clientcrash on character enter

Recommended Posts

beenery

metropol81

+cs.tribal

beenery

beenery

metropol81

beenery

conf18

ČυяŞŀŅğ

Over12

gRfd`

danilo10

Darius

Zake

marcose

Join the conversation

Posts

Topics

Browse

Activity

Store