[Share] League Of Elo (reworked)

[marwan]

  On 1/26/2013 at 2:02 AM, borntobeahero said:

the sql part is correct? :S

try this

CREATE TABLE `rankedteams` (
  `name` text,
  `leader` text,
  `member1` text,
  `member2` text,
  `member3` text,
  `member4` text,
  `wins` int,
  `loses` int
) ENGINE=InnoDB AUTO_INCREMENT=43  DEFAULT CHARSET=latin1;

[Napster321]

when im at character select screen

 

Failed loading character.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'rank'
in 'field list'
        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:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
        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.l2jserver.gameserver.model.actor.instance.L2PcInstance.restore(L2
PcInstance.java:7574)
        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.load(L2PcI
nstance.java:1375)
        at com.l2jserver.gameserver.network.L2GameClient.loadCharFromDisk(L2Game
Client.java:564)
        at com.l2jserver.gameserver.network.clientpackets.CharacterSelect.runImp
l(CharacterSelect.java:103)
        at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:62)
        at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1
001)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)

could not restore in slot: 0

[marwan]

forgot to say you have to create new column ranked in character.sql

[Napster321]

i wonder if you tested that  :S

[marwan]

  On 1/26/2013 at 8:46 AM, borntobeahero said:

i wonder if you tested that  :S

I did working prefectly , any problems ?

[Napster321]

  On 1/26/2013 at 10:13 AM, marwan said:

I did working prefectly , any problems ?

try to create a team ,you propably forgot to add bypasshandlers

 

[marwan]

tb.append("<br><br><center><button value=\"Post\" action=\"bypass -h _pc_" + this.getObjectId() + "_create $name\" width=160 height=32 back=\"L2UI_CT1.Button_DF_Down\" fore=\"L2UI_ct1.button_df\"></center>");

 

 

change pc to npc , dont know why da fack this happend

 

http://pastebin.com/jKdPQDLK

[PoRnosJH]

Just Added your code in my hi5 l2j last rev...

many little warning-errors that i fixed..

 

but this error..after i logged in then talked to the L2League Npc and clicked on button : Create Team

 

  Quote

[Character: PoRnosJH[268483933] - Account: pornosjh - IP: 192.168.1.1] sent not

handled RequestBypassToServer: [createt]

And after some minutes :

 

  Quote

Could not store char base data: L2PcInstance:PoRnosJH[268483933] - Parameter ind

ex out of range (55 > number of parameters, which is 54).

java.sql.SQLException: Parameter index out of range (55 > number of parameters,

which is 54).

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)

        at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3

813)

        at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3

795)

        at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3

840)

        at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3784)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setInt(NewProxyPre

paredStatement.java:607)

        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.storeCharB

ase(L2PcInstance.java:8783)

        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2Pc

Instance.java:8685)

        at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.store(L2Pc

Instance.java:8704)

        at com.l2jserver.gameserver.network.L2GameClient.saveCharToDisk(L2GameCl

ient.java:376)

        at com.l2jserver.gameserver.network.L2GameClient$AutoSaveTask.run(L2Game

Client.java:901)

        at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(Thread

PoolManager.java:93)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)

 

        at java.util.concurrent.FutureTask.runAndReset(Unknown Source)

        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.

access$301(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)

 

[SweeTs]

  Quote

Parameter index out of range (55 > number of parameters,

which is 54).

 

You facked up statement part in l2pcinstance. :P

[iitmtii]

works for frozen?

[xdem]

nc work marwan, but what happens if there are 2 matches takin place on the same time?? full bugs... the variables are the same for blue teams and for the red teams making this code sooooooooooooo buggy and faulty... it needs diffrent structure.

For example if 20 players are participated then 10 will be on team1 and 10 on team2... but team1 uses specific variables like points, kills from diffrent team1 will be always the same with points from other team1, so .............................

[tonysbelet]

i think guys maxcheaters member should pray  for u sharing this awsome code !

[ProfessionalGeodata]

One of the nicest things I've seen shared in a while : )

 

Seems amazing!

 

Thanks for your contribute!

[Jeremy_]

  On 3/1/2013 at 8:25 PM, ProfessionalGeodata said:

One of the nicest things I've seen shared in a while : )

 

Seems amazing!

 

Thanks for your contribute!

You have test it and work ? :S couse i am sure i test it and dont work.......

[xdem]

  On 4/9/2013 at 3:07 PM, paokara2009 said:

You have test it work ? :S couse i am sure i test it and dont work.......

Try mine ^^