Its a global enchant decrease issue.

[Bru7aL]

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?

[rigid]

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

[Probe]

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;

[Bru7aL]

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 )

[Probe]

the query will find all these items for you

[janiii]

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.

[Probe]

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

[Bru7aL]

Seems like its working. Thank you VERY much!

[janiii]

i would be more cautious and run this query (checking if the item is a weapon):

Code: Select all

UPDATE items SET enchant_level = 16 WHERE enchant_level > 16 AND item_id IN (SELECT item_id FROM weapon);

//too late.. poor players with pets..

[BiggBoss]

//too late.. poor players with pets..

[Probe]

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

Code: Select all

UPDATE items SET enchant_level = 16 WHERE enchant_level > 16 AND item_id IN (SELECT item_id FROM weapon,armor);