L2J Server

Posted: **Wed Oct 14, 2009 11:56 am**

06:17 Changeset [3620] by _DS_
Shields can't be augmented, thanks devo. Also little optimisations.

How do i remove the augments from shields??
Anyone can help me??

Thxx...

Posted: **Thu Oct 15, 2009 3:00 pm**

Look in item_attributes table.

Posted: **Thu Oct 15, 2009 5:16 pm**

DELETE FROM item_attributes WHERE itemId IN (SELECT object_id FROM items WHERE item_id IN (SELECT item_id FROM weapon WHERE weaponType IN ('none')));

Posted: **Thu Oct 15, 2009 5:42 pm**

Thxxx... Devo...

Posted: **Fri Oct 16, 2009 9:27 am**

JFYI: removing augments from rods:

DELETE FROM item_attributes WHERE itemId IN (SELECT object_id FROM items WHERE item_id IN (SELECT item_id FROM weapon WHERE weaponType IN ('rod')));

Posted: **Fri Oct 16, 2009 11:31 am**

Thxx.... DS...

It was a great help.

Augumented Shields