Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--

Rank Pvp System 3.8.9 [Il - H5]

<< Masterio >>
 Share

Recommended Posts

arrer Newbie

arrer

Posted
Posted
Hello, I have a problem with MySQL query.
Everything was installed correctly, but then came
 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'charI
d' in 'where clause'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2281)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
        at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.updateTo
pTable(TopTable.java:206)
        at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.load(Top
Table.java:98)
        at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.<init>(T
opTable.java:52)
        at com.l2jfrozen.gameserver.masteriopack.rankpvpsystem.TopTable.getInsta
nce(TopTable.java:60)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:501)

Tried to change "charId" on "obj_id" here

private static final String SQL_PLAYER_DATA = "SELECT char_name as name, base_class as base_class, level as level FROM characters WHERE charId=?";

and got this

Multiply prepared statement! SELECT char_name as name, base_class as base_class, level as level FROM characters WHERE obj_Id=?

Please help in solving this problem.

Core: L2JFrozen [iT] latest revision

O_o Newbie

O_o

Posted
Posted

One more idea : to display players rank at title and for them to can't remove or change it

Will you do and this ?

SweeTs Rookie

SweeTs

Posted
Posted

It's sad to see such replies.. Just add it by hand. You won't find "apply patch -> select -> finish" codes. Deal with it :)

badriniki Newbie

badriniki

Posted
Posted

It's sad to see such replies.. Just add it by hand. You won't find "apply patch -> select -> finish" codes. Deal with it :)

It's sad to do not understund what i wrote(even if i have bad English), applyed by hands, specially to do not have errors and such comments.

Amida Nguyen Newbie

Amida Nguyen

Posted
Posted

I get error with new version in Freya:

 

 

Exception in thread "Thread-50" Exception in thread "Thread-51" java.lang.NullPointerException

at com.l2jserver.gameserver.masteriopack.rankpvpsystem.KillerPvpStats.updateDailyStats(KillerPvpStats.java:274)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.PvpTable.getKillerPvpStats(PvpTable.java:229)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.RankPvpSystem.doPvp(RankPvpSystem.java:64)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.RankPvpSystemPc$RankPvpSystemPvpTask.run(RankPvpSystemPc.java:43)
at java.lang.Thread.run(Thread.java:724)
java.lang.NullPointerException
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.KillerPvpStats.updateDailyStats(KillerPvpStats.java:274)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.PvpTable.getKillerPvpStats(PvpTable.java:229)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.RankPvpSystem.doPvp(RankPvpSystem.java:64)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.RankPvpSystemPc$RankPvpSystemPvpTask.run(RankPvpSystemPc.java:43)
at java.lang.Thread.run(Thread.java:724)
Exception in thread "GeneralSTPool-11" java.lang.NullPointerException
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.PvpTable.updateDB(PvpTable.java:325)
at com.l2jserver.gameserver.masteriopack.rankpvpsystem.PvpTable$PvpTableSchedule.run(PvpTable.java:420)
at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:86)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
<< Masterio >> Newbie

<< Masterio >>

Posted
  • Author
Posted (edited)

The best way to remove old code is:

 

1. Remove old classes. It is mean remove masteriopack and imageconverter package from core.

2. Restore from repository all required classes. Class names are the same like the diff patch names (Of course with out version info).

3. If you have no repository access, then remove old code taged with: "// Rank PvP System by Masterio" (I prefer 2 solution). (Eclipse: Ctrl+H help you find this code).

 

You can compare original classes with edited by me and manualy replace to original.

 

Then you can install it again from new patches or raw files.

 

Remember, if you install it on other l2j pack, or to older revision, you should install it manually.

Edited by << Masterio >>
Guest
This topic is now closed to further replies.
 Share
Go to topic listing
×
×
  • Create New...