L2J Server

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

I'd like to know how can i decrease all max enchanted weapons/armors/jewels automaticly. What i mean : I have a server with max enchant +24 but it was all about the Master Yogi Event, so now i'd like to take the MAX enchant back to +16 but there are already players with stuffs +24. So my question is how can i decrease all those over +16 enchanted items back to +16?

open " item " tables
find " enchant " = 24
change to 14

this SQL query should do the trick (run it on your database, make sure you back up before this!!!!)

Couldnt find any item enchanted to more then +10 ... and there are many items enchanted over +10 for example ... its pretty weird isnt it ?


p.s. lemme try your way, and tnx in advance )

the query will find all these items for you

Probe wrote:this SQL query should do the trick (run it on your database, make sure you back up before this!!!!)

Code: Select all

UPDATE `items` SET `enchant_level` = 16 WHERE `enchant_level` > 16;

imo this could damage some other data, as the enchant_level is used also for other things like lottery ticket or pet level.

you sure? isn't that what loc_data is for?
or does enchant level store pet level for pet collars?

Seems like its working. Thank you VERY much!

i would be more cautious and run this query (checking if the item is a weapon): //too late.. poor players with pets..

janiii wrote: //too late.. poor players with pets..

btw.. he wanted to put armor and jewelery to +16 as well
and since pet collars are etcitems, maybe best to do: