Page 1 of 1

Skill Enchant Success Rate

Posted: Thu Jun 04, 2009 11:28 pm
by momo61
L2J Revision Number:3137
L2JDP Revision Number:6211

Hello guys,

I upgraded my server from 2.2 to 2.3 Gracia Final and apparently the enchant success rate is way too high ^^
People can obtain Giant's Codex fairly simple on the server since its a mid rate, and then enchant ++++++ skills.

What I want to do is run an SQL query to set all skills above +13 back to +13 and then change the success rate of skills like they were in Gracia 2.2.

Could anyone maybe tell me the best way to proceed ? Where to look ? What to change ?

thanks in advance,


Mow Mow Sixti Wan

Re: Skill Enchant Success Rate

Posted: Fri Jun 05, 2009 12:18 pm
by Kriogen
Look in the enchant skill trees table. If you want lower chance to enchant, you should change the chance in the table.
Example:

Code: Select all

update `enchant_skills` set `success76`=20 where `level`=116;

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 12:27 am
by momo61
hmm ... are you 100% sure ? Because i will be changing this on live with 500+ ingame.

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 1:43 am
by momo61
hmm ... ok u are right ... ^^ would be good to have all the necessary queries :S or i will just do it manually.

thanks to anyone willing to help further

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 7:31 am
by Kriogen
momo61 wrote:hmm ... ok u are right ... ^^ would be good to have all the necessary queries :S or i will just do it manually.

thanks to anyone willing to help further
Here you go :)

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 7:59 am
by StevenP

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 9:33 am
by momo61
Kriogen wrote:
momo61 wrote:hmm ... ok u are right ... ^^ would be good to have all the necessary queries :S or i will just do it manually.

thanks to anyone willing to help further
Here you go :)
o.O wuuut ? omg I will try this out O.o

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 12:37 pm
by momo61
wow Kriogen ... thanks so much ... you saved me so much time.

THANK YOU !!!

Re: Skill Enchant Success Rate

Posted: Sat Jun 06, 2009 2:32 pm
by Kriogen
momo61 wrote:wow Kriogen ... thanks so much ... you saved me so much time.

THANK YOU !!!
Np. :)

Re: Skill Enchant Success Rate

Posted: Sat Jun 13, 2009 3:31 pm
by park1nson
op pls tell me te id for skill enchanter pls or sher 1 custom skill enchanter i cant find 1 or give me a link thx :(

Re: Skill Enchant Success Rate

Posted: Fri Jul 17, 2009 3:13 pm
by rockkth
nevermind i fugerd it out :>

Re: Skill Enchant Success Rate

Posted: Sun Nov 22, 2009 7:27 am
by NoX
Kriogen wrote:
momo61 wrote:hmm ... ok u are right ... ^^ would be good to have all the necessary queries :S or i will just do it manually.

thanks to anyone willing to help further
Here you go :)

momo61 or kriogen will this sql setup the enchant skill like gracia 2.2?? wich is the chance on it??

thank you a lot

sorry about my bad english and grammar.