Jump to content

Recommended Posts

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;

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

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

 

Posted

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

which is 54).

 

You facked up statement part in l2pcinstance. :P

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Posts

    • aCis (“another Crappy interlude server”) is a commercial project I would not use even if paid. l2jfrozen yes, a 10 year old, effectively dead project produces more reliable results and at least works. l2jhellas also works. aCis might as well be renamed KPMIS (“Keep Paying My Interlude Server”): endless fixes, freemium, and no realistic path to true L2OFF parity, but its recommended like hell. lucera is even better the downside is you just need to dive into code and no sources   lets leave it at that
    • Download Here: https://sitehunterus.blogspot.com/2025/12/exelo-combo-tool-v2.html VirusTotal https://www.virustotal.com/gui/file/2acd067847ee092c7986f55c9f77620d89505d1c0bda34a0ee8f55b9c2905c11?nocache=1 Visit my Blogger list to download 100% free software https://www.freetoolss.com/ https://blackhat8.blogspot.com/ https://hack-crack9.blogspot.com/ https://hackernoons.blogspot.com/ https://sharetools99.blogspot.com/
    • Care to detail why ?   L2JHellas probably got the same issue, it's inherent to L2J if you don't rework Player intentions (and solving it with a Config < 500 attack is stupid, if it works for attack it works for other types of desires), also last time I checked L2JHellas he was using my changesets to fix its own stuff (which is ok, copy-paste my knownlist system which is 10y old is fine, but don't say it will act different since it's literally the same sub-system).   About Lucera code source isn't available so it's easy to say it's better, internally you got no clue what is happening and RU forks got the "feeling" to get everything, but everything is half done, everytime I put an eye on such sources (whatever based on l2ru, they only know how to copy-paste each other).   In the other hand, you seem to use aCis since years (I think I see your name since a decade, and you still use it since you made this topic :   Be a little more appreciative about the work done, it's not only mine but my community aswell, and if you find something, consider to report rather than getting such an idiotic behavior.   I understand you're not forced to share any type of fixes, and than people tend to feel superior when they fix something than aCis didn't yet fix. The thing is, for each bug you found, I found and fixed 10x more than you.   409 is way beyond 382 in all possible ways, if you believe the versus good for you, but don't make ppl believe it's the case, because it's not. There's at least 400+ fixed issues (and that's counting 10 issues by revision, which is kinda low) and entire new systems (spawns, SCHs, pathfind, whole AI implemented, Desire system,...).
    • better than using 409... Search for L2jHellas or Lucera and you won't have any headaches.
  • 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