Remove Lapis Linked İtems

[[S]DipNot]

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.

[rempieremco153]

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'

[[S]DipNot]

Errors Give ...

[rempieremco153]

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

[[S]DipNot]

Gem Fields Only Lapis Field ? Type ID Write Only ? We Want to removed?

[rempieremco153]

Yes, they get removed from the gear..?

[[S]DipNot]

Thank you For all answer. Removed Items. But Not Removed WH İtems Guild Stored Items and Inventory in .

[Sh1nra]

Warehouse :

 Spoiler

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

GuildHouse :

 Spoiler

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

[rempieremco153]

Wasn't that hard, was it? :P

[[S]DipNot]

### Thanks All Again. Works it.