Augumented Shields

LaraCroft · Post by **LaraCroft** » 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...

lishawj · Post by **lishawj** » Thu Oct 15, 2009 3:00 pm

Look in item_attributes table.

devo · Post by **devo** » 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')));

LaraCroft · Post by **LaraCroft** » Thu Oct 15, 2009 5:42 pm

Thxxx... Devo...

Post by **_DS_** » 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')));

LaraCroft · Post by **LaraCroft** » Fri Oct 16, 2009 11:31 am

Thxx.... DS...

It was a great help.

L2J Server