Code Rank Pvp System 3.8.9 [Il - H5]

[arrer]

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

[ExCaLiBuR®]

add the new version 3.7.8 for interlude 

[<< Masterio >>]

new release, have fun.

 

arrer

try to update mysql database to 5.5+

[O_o]

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

Will you do and this ?

[<< Masterio >>]

O_o, on 07 Nov 2013 - 12:18 PM, said:

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

Will you do and this ?

maybe :)

[Andrew™]

+1 from me for this great work!

[badriniki]

Very good share but unfortunately only working with latest aCis files and not with older ones .. too many errors, it's sad

[SweeTs]

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]

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]

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 >>]

Thanks for raport Amida Nguyen.

 

New release have null checkers. Problem appeared after ConcurrentHashMap implementation, now should works.

[dodelez]

how i need to install if i have the old version?

[<< Masterio >>]

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 November 22, 2013 by << Masterio >>

[<< Masterio >>]

DO NOT DOWNLOAD 3.7.6+, it is wrong calculate the ranks. sorry for this missing. It will be fixed ASAP.

[DeathSpank287]

Hey Masterio, I have a question about the Top Ranks on CB. How can I make it ignore players with Access Level > 0?