[Share] Repair clientcrash on character enter

xXxJimPowerxXx · August 3, 2010

I think you have realistic depth on in the settings (it's below shaders)

To those who ask for IL: this is for IL, if you know what to do; it's replacement at lobby.unr and stuff, I think it's explained at the share or else the author should explain it here :)

edit

error fixed

SoRa · August 3, 2010

Useful share,thank you my friend. ;)

beenery · October 8, 2010

some modifications must be made

Repair.java

-package handlers.voicedcommandhandlers;
+ package com.l2jserver.gameserver.handler.voicedcommandhandlers;
-private static final String[]	 _voicedCommands	=
+private static final String[] VOICED_COMMANDS =

-return _voicedCommands;
+return VOICED_COMMANDS;

Config.java

public static boolean ENABLE_REPAIR;

VoicedCommanderHandler.java

if (Config.ENABLE_REPAIR)
		registerVoicedCommandHandler(new Repair());

metropol81 · October 8, 2010

good work...

Tested & work 100% on epilogue last revision

+cs.tribal · October 8, 2010

wow!

Really useful code, i'm gonna add it in my project for sure!

BUT

If someone has karma and he is afraid of loosing his items, may use it to escape and save his item once the items are going in warehouse!

:/ any ideas to avoid it???

metropol81 · October 8, 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;
}
}

beenery · October 8, 2010

metropol81, ai shows how you left your MasterHandler.java please

metropol81 · October 8, 2010

he?

beenery · October 8, 2010

gameserver error

Loaded : 2 cursed weapon(s).
------------------------------------------------------------------=[ Scripts ]

AirShipManager: Loaded 0 private airships

BotManager: Loaded 0 bot reports

Loading Server Scripts

----------

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

{

^

Syntax error on token "{", { expected after this token

----------

2. ERROR in \MasterHandler.java (at line 26)

if (Config.REPAIR_ALLOW_REPAIR)

VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new Rep

air());

}

private static void loadAdminHandlers()

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

^^^^^^^^^^^^^^^^^

Syntax error on token(s), misplaced construct(s)

----------

3. ERROR in \MasterHandler.java (at line 28)

}

^

Syntax error on token "}", delete this token

----------

4. ERROR in \MasterHandler.java (at line 30)

private static void loadAdminHandlers()

^^^^

Syntax error on token "void", @ expected

----------

4 problems (4 errors)Failed executing script

MasterHandler.java

/*
* 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
{
   if (Config.REPAIR_ALLOW_REPAIR)
        VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new Repair());
}

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 8, 2010

/*
* 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
{
   if (Config.REPAIR_ALLOW_REPAIR)
+      {
        VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new Repair());
}

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();
}
}

beenery · October 8, 2010

HELP

Loaded : 2 cursed weapon(s).
------------------------------------------------------------------=[ Scripts ]

AirShipManager: Loaded 0 private airships

BotManager: Loaded 0 bot reports

Loading Server Scripts

----------

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

{

^

Syntax error on token "{", { expected after this token

----------

2. ERROR in \MasterHandler.java (at line 26)

if (Config.REPAIR_ALLOW_REPAIR)

{

VoicedCommandHandler.getInstance().registerVoicedCommandHandler(new Rep

air());

}

private static void loadAdminHandlers()

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

^^^^^^^^^^^^^^^^^^^^^^^^

Syntax error on token(s), misplaced construct(s)

----------

3. ERROR in \MasterHandler.java (at line 31)

private static void loadAdminHandlers()

^^^^

Syntax error on token "void", @ expected

----------

3 problems (3 errors)Failed executing script

HellboundManager: Initializing

not have to put something on config.java?

Matim · October 8, 2010

Read error log, there is CLEAN ENGLISH DESCRIPTION about whats wrong, lol!

Use brain a bit!

Dariuse · October 9, 2010

Good Man Keep Doing Useful things.

beenery · October 9, 2010

unfortunately I could not change the MasterHandler.java

if anyone can help me thank

metropol81 · October 9, 2010

unfortunately I could not change the MasterHandler.java

if anyone can help me thank

pm me & send me masterhandler.java

to fix it....

[Share] Repair clientcrash on character enter

Recommended Posts

xXxJimPowerxXx

SoRa

beenery

metropol81

+cs.tribal

metropol81

beenery

metropol81

beenery

metropol81

beenery

Matim

Dariuse

beenery

metropol81

Join the conversation

Posts

Topics

Browse

Activity

Store