Skill Enchant Success Rate

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Skill Enchant Success Rate

Post 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
Kriogen
Posts: 65
Joined: Mon May 11, 2009 11:38 am

Re: Skill Enchant Success Rate

Post 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;
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Skill Enchant Success Rate

Post by momo61 »

hmm ... are you 100% sure ? Because i will be changing this on live with 500+ ingame.
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Skill Enchant Success Rate

Post 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
Kriogen
Posts: 65
Joined: Mon May 11, 2009 11:38 am

Re: Skill Enchant Success Rate

Post 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 :)
You do not have the required permissions to view the files attached to this post.
StevenP
Posts: 90
Joined: Mon Jun 09, 2008 1:31 pm

Re: Skill Enchant Success Rate

Post by StevenP »

User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Skill Enchant Success Rate

Post 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
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Skill Enchant Success Rate

Post by momo61 »

wow Kriogen ... thanks so much ... you saved me so much time.

THANK YOU !!!
Kriogen
Posts: 65
Joined: Mon May 11, 2009 11:38 am

Re: Skill Enchant Success Rate

Post by Kriogen »

momo61 wrote:wow Kriogen ... thanks so much ... you saved me so much time.

THANK YOU !!!
Np. :)
park1nson
Posts: 9
Joined: Fri May 22, 2009 6:24 pm

Re: Skill Enchant Success Rate

Post 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 :(
rockkth
Posts: 196
Joined: Sat Jul 04, 2009 8:54 am

Re: Skill Enchant Success Rate

Post by rockkth »

nevermind i fugerd it out :>
NoX
Posts: 189
Joined: Mon Oct 05, 2009 4:31 am

Re: Skill Enchant Success Rate

Post 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.
lj2Black Hands : have something en mente + look around + copy +paste + try to improve it :S without knowlege -.-

Image
Post Reply