Jump to content
The Best Lineage 2 Mods – Free & Custom
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

[Share] League Of Elo (reworked)

marwan

By marwan
in Server Shares & Files [L2J]

 Share

Recommended Posts

marwan Newbie

marwan

Posted
  • Author
Posted

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 Newbie

Napster321

Posted
Posted

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 Newbie

marwan

Posted
  • Author
Posted

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

  • 4 weeks later...
PoRnosJH Newbie

PoRnosJH

Posted
Posted

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

 

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

handled RequestBypassToServer: [createt]

And after some minutes :

 

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)

 

xdem Proficient

xdem

Posted
Posted

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

  • 2 weeks later...
  • 1 month later...
Jeremy_ Newbie

Jeremy_

Posted
Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   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
Go to topic listing


  • Posts

    • Celestine
      developer alert_GIANNIS

      By Celestine · Posted

      Even if I was reselling, as you claim, you got refunded down to the last penny. At least when I work with someone, I try to find a solution. Just because something didn’t work for you doesn’t mean it hasn’t worked for others. I’ve provided different kinds of services successfully, and I’ve even had several of your own clients come to me complaining about the mess you left behind, with unfinished code and ongoing issues.   Let’s be real. I supported you and always spoke positively about you until I realized that you only care about your wallet, not how your customers feel. That was disappointing. I don’t care much anymore, because some people change and some don’t. They stay comfortable being that way.   As for the family topic, I didn’t say anything bad or wrong. That was information I heard from a friend. And no, I won’t ban you. It’s not worth the energy to even open the admin panel. You can keep doing what you’re doing, but don’t claim you’re a good and clean person when you clearly don’t value other people’s time, money, or effort.   When you talk about being mature, your actions show the opposite. For once in your life, admit that you're still acting immature. Hopefully one day you'll understand how life really works and learn to move on. But until then, take responsibility and clean up the mess you've left behind.   TL;DR: I won’t be reading anything else, just grabbing popcorn and enjoying the show.
    • 911reg
      developer alert_GIANNIS

      By 911reg · Posted

      Gay whoever doesn't read it
    • Albert Scott
      L2j Orion help for epic raids stats

      By Albert Scott · Posted

      Hey everyone, I’m reaching out for urgent support with my NPC stats—specifically Baium, who on my server seems to have gone full god mode. Apparently, I’m the "crazy dreamer" who believes Baium shouldn’t have over 4 million HP, 30k+ P. Atk, attack speed faster than a dagger, and more M. Atk than seven Antharas combined 😅. My server's developer (VILMIS) refuses to provide proper support, claiming I have no idea about the "real stats" and that I’m imagining things. I’ve tried modifying the values through the admin console, but nothing takes effect. I’m desperate—the server launches on 04/10, and I really want these stats to be closer to official NCSOFT values or at least something balanced and realistic. If anyone with experience can lend a hand or point me in the right direction, please reach out. I’d truly appreciate it 🙏    
    • Meister
      WTS SCRYDE TOP PRICE

      By Meister · Posted

      Sure more parts from our discord conversation posted below. Please note that he blocked me while he is active on discord (he responded to a different discord account).   Could you please ban him @Atom?      
    • Atom
      Looking for a Specialist to Upgrade Lineage II Interlude PTS

      By Atom · Posted

      Take care from where and who you buy.

  • Topics

×
×
  • 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 Disabled AdBlock