We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

About 600 mysql queries when learn skills...

Find the proper support area, Saga-Version.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
Silv3rMoon
Posts: 96
Joined: Wed May 30, 2012 12:46 am

About 600 mysql queries when learn skills...

Post by Silv3rMoon » Fri Jun 14, 2013 2:47 am

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
Image

User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4198
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

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

Post by UnAfraid » Fri Jun 14, 2013 10:54 am

It was fixed in few commits that's not the only one.
Image

User avatar
Silv3rMoon
Posts: 96
Joined: Wed May 30, 2012 12:46 am

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

Post by Silv3rMoon » Fri Jun 14, 2013 9:38 pm

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

User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4198
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

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

Post by UnAfraid » Sat Jun 15, 2013 12:40 pm

Here's the list of changes related to that problem.
Changeset 5764
Changeset 5765
Changeset 5766
Changeset 5883
Changeset 5899
Image

User avatar
Silv3rMoon
Posts: 96
Joined: Wed May 30, 2012 12:46 am

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

Post by Silv3rMoon » Sun Jun 16, 2013 1:29 am

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

User avatar
JMD
Advanced User
Advanced User
Posts: 1416
Joined: Wed Apr 15, 2009 10:07 am
Contact:

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

Post by JMD » Sun Jun 16, 2013 1:41 am

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.

User avatar
UnAfraid
L2j Veteran
L2j Veteran
Posts: 4198
Joined: Mon Jul 23, 2007 4:25 pm
Location: Bulgaria
Contact:

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

Post by UnAfraid » Sun Jun 16, 2013 11:07 am

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

User avatar
Silv3rMoon
Posts: 96
Joined: Wed May 30, 2012 12:46 am

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

Post by Silv3rMoon » Sun Jun 16, 2013 5:49 pm

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

Post Reply