Page 1 of 1

About 600 mysql queries when learn skills...

Posted: Fri Jun 14, 2013 2:47 am
by Silv3rMoon
L2J Revision 6059:
L2JDP Revision 9801:

So i'm using lastest revision of L2J Freya...
Since i was asking too why does it lag/delay when autolearn skills... since i'm using L2J to "develop" high rate server... its kinda instant level and from 1-85 when autolearn it lags... alot when recieve class...
I've used search like most of you would advice me to... i found solution ...i was going to adapt it but since i'm not so skilled i decide to request someone from you guys to help...
There are some differences between this here:
http://trac.l2jserver.com/changeset/5764
And my source...
For me the differences are big... anyway... if anyone is able to advice me what to do.. or to help...
Thanks in advance.



Related Topic: (from search)
viewtopic.php?f=103&t=24052&p=158773&hi ... ag#p158773

Re: About 600 mysql queries when learn skills...

Posted: Fri Jun 14, 2013 10:54 am
by UnAfraid
It was fixed in few commits that's not the only one.

Re: About 600 mysql queries when learn skills...

Posted: Fri Jun 14, 2013 9:38 pm
by Silv3rMoon
UnAfraid wrote:It was fixed in few commits that's not the only one.
Is it possible to make patch or smth so users like me, who doesn't update to chronicle and use Lastest Freya one... can apply it w/o problems...

Re: About 600 mysql queries when learn skills...

Posted: Sat Jun 15, 2013 12:40 pm
by UnAfraid
Here's the list of changes related to that problem.
Changeset 5764
Changeset 5765
Changeset 5766
Changeset 5883
Changeset 5899

Re: About 600 mysql queries when learn skills...

Posted: Sun Jun 16, 2013 1:29 am
by Silv3rMoon
UnAfraid wrote:Here's the list of changes related to that problem.
Changeset 5764
Changeset 5765
Changeset 5766
Changeset 5883
Changeset 5899
Thats pretty much to apply and adapt...

Re: About 600 mysql queries when learn skills...

Posted: Sun Jun 16, 2013 1:41 am
by JMD
Silv3rMoon wrote:
UnAfraid wrote:Here's the list of changes related to that problem.
Changeset 5764
Changeset 5765
Changeset 5766
Changeset 5883
Changeset 5899
Thats pretty much to apply and adapt...
not really just start copy pasting and whatever error you get ask for help here.

Re: About 600 mysql queries when learn skills...

Posted: Sun Jun 16, 2013 11:07 am
by UnAfraid
Most of changesets contains few lines change it should be no problem to apply it for 5 mins max.
If you have live server then you gotta be able to fix bugs by yourself or at least when there's a patch provided to apply it by yourself otherwise don't even bother opening live server.

Re: About 600 mysql queries when learn skills...

Posted: Sun Jun 16, 2013 5:49 pm
by Silv3rMoon
UnAfraid wrote:Most of changesets contains few lines change it should be no problem to apply it for 5 mins max.
If you have live server then you gotta be able to fix bugs by yourself or at least when there's a patch provided to apply it by yourself otherwise don't even bother opening live server.
I'm not going to open live server... anyway i'm doing project... for myself...
Howeva... i'm going to check everything and will reply as soon as i get error or smth if i can't apply the changesets...