Help Console Error related to something i deleted.

[Guarder]

I have added that "Death Message" code but after that,i only deleted the Column "message" from database and now it keeps showing me this in GS console. where else should i delete? i have something related to that in L2Pcinstance,should i just delete that from L2PcInstance? i'll share it 

 

1.The error in GS:

java.sql.SQLException: Column 'message' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
        at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.doDie(L2PcInstance.java:7479)
        at com.l2jfrozen.gameserver.model.actor.status.CharStatus.reduceHp(CharStatus.java:284)
        at com.l2jfrozen.gameserver.model.actor.status.PlayableStatus.reduceHp(PlayableStatus.java:51)
        at com.l2jfrozen.gameserver.model.actor.status.PcStatus.reduceHp(PcStatus.java:136)
        at com.l2jfrozen.gameserver.model.actor.status.PcStatus.reduceHp(PcStatus.java:52)
        at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.reduceCurrentHp(L2PcInstance.java:15990)
        at com.l2jfrozen.gameserver.handler.skillhandlers.Mdam.useSkill(Mdam.java:155)
        at com.l2jfrozen.gameserver.model.L2Character.callSkill(L2Character.java:9290)
        at com.l2jfrozen.gameserver.model.L2Character.onMagicHitTimer(L2Character.java:8547)
        at com.l2jfrozen.gameserver.model.L2Character$MagicUseTask.run(L2Character.java:3354)
        at com.l2jfrozen.gameserver.thread.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:95)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

 

 

2. L2PcInstance on doDie:

				//Death Message Mod By Pauler
				
				if (killer instanceof L2PcInstance) {
					
					L2PcInstance dolofonos = (L2PcInstance) killer;
					
					java.sql.Connection con = null;
					
					try {
						
						con = L2DatabaseFactory.getInstance().getConnection(false);
						
						PreparedStatement statement = con.prepareStatement("SELECT * FROM characters WHERE char_name=?");
						statement.setString(1, dolofonos.getName());
						
						ResultSet rs = statement.executeQuery();
						
						String message = "";
						
						while (rs.next()) {
							
							message = rs.getString("message");
							
						}
						
						if (!message.equals("")) {
							message = message.replace("p1", dolofonos.getName());
							message = message.replace("p2", getName());
						
							Announcements.getInstance().announceToAll(message);
						}
						
						statement.close();
						
					}catch(Exception e) {
						
						e.printStackTrace();
						
					}
					
				}

 

[Tryskell]

Yes.

 

And if you bought this code from someone, or if you paid someone to do it, consider to never hire this person again.

[Kara]

24 minutes ago, Tryskell said:

Yes.

 

And if you bought this code from someone, or if you paid someone to do it, consider to never hire this person again.

L2PcInstance dolofonos = (L2PcInstance) killer;

dolofonos in greek means killer. Whoever wrote this code must be handicapped

or this:
 

 

[Kara]

@KIDutz give me the name of the person who did this code plz. (mostly cause he is Greek and it offend me)

[Guarder]

 

:D :D :D

 

[Kara]

You used a 2011 code. I dont know which one should be banned the uploader who made this crap or you who use 2011 code in 2019 server. I'm out of here. Done. Log-out. @SweeTs I leave you alone byee, can't deal with it anymore.

[SweeTs]

@Kara` thank you for marking me. I needed such topic.

 

Nha, drop only the table and you are okay. Npe in console is a feature.

 

[Kara]

1 hour ago, SweeTs said:

@Kara` thank you for marking me. I needed such topic.

 

Nha, drop only the table and you are okay. Npe in console is a feature.

 

I'm sorry but is too much weight for me, we must share it. After the guy on skype who asked why aCis pack does not start with pride's database i think i'm done. SweetS after i'm completely banished by these :'( you have to handle on your own.