Remove Lapis Linked İtems

12/30/2012 19:51 [S]DipNot#1
Hello Everyone,

Me Want to Linked İtems in Lapis Removed or Changed. WH , Inventory and GuildWH Remove.

Example : Goddess Adams Boots , Slot 1 : Linked Life Lapis Lv7

How To Remove Goddess Adams Boots Slot 1 Life Lapis ?

or Game in All linked İtems Remove Life Lapis.

Have Sql Script ?


Thank You For Answer All.
12/30/2012 20:06 rempieremco153#2
You could search your item.sdata for the ID of Life Lapis
Once you got that, you can make an SQL like:

UPDATE CharItems SET Gem1 = '0' WHERE Gem1 = 'lapisid'
UPDATE CharItems SET Gem2 = '0' WHERE Gem2 = 'lapisid'
UPDATE CharItems SET Gem3 = '0' WHERE Gem3 = 'lapisid'
UPDATE CharItems SET Gem4 = '0' WHERE Gem4 = 'lapisid'
UPDATE CharItems SET Gem5 = '0' WHERE Gem6 = 'lapisid'
12/30/2012 20:14 [S]DipNot#3
Errors Give ...
12/30/2012 20:18 rempieremco153#4
Don't add the 30.
the correct lapis id should be 49.
So your code should be:

UPDATE CharItems SET Gem1 = '0' WHERE Gem1 = '49'
UPDATE CharItems SET Gem2 = '0' WHERE Gem2 = '49'
UPDATE CharItems SET Gem3 = '0' WHERE Gem3 = '49'
UPDATE CharItems SET Gem4 = '0' WHERE Gem4 = '49'
UPDATE CharItems SET Gem5 = '0' WHERE Gem6 = '49'

Hope it works
12/30/2012 20:24 [S]DipNot#5
Gem Fields Only Lapis Field ? Type ID Write Only ? We Want to removed?
12/30/2012 20:33 rempieremco153#6
Yes, they get removed from the gear..?
12/30/2012 20:38 [S]DipNot#7
Thank you For all answer. Removed Items. But Not Removed WH İtems Guild Stored Items and Inventory in .
12/30/2012 21:04 Sh1nra#8
Warehouse :


GuildHouse :
12/30/2012 21:12 rempieremco153#9
Wasn't that hard, was it? :P
12/30/2012 22:06 [S]DipNot#10
### Thanks All Again. Works it.