Jump to content
  • 0

Help Console Error related to something i deleted.


KIDutz
 Share

Question

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

 

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0

Yes.

 

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

Link to comment
Share on other sites

  • 0
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:
 

 

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

@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.

 

you-cant-see-me.jpg

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disbaled AdBlock