Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 15:17

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Remove Lapis Linked İtems

Discussion on Remove Lapis Linked İtems within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2012
Posts: 69
Received Thanks: 19
Remove Lapis Linked İtems

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.
[S]DipNot is offline  
Old 12/30/2012, 20:06   #2
 
elite*gold: 0
Join Date: May 2012
Posts: 174
Received Thanks: 203
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'
rempieremco153 is offline  
Thanks
5 Users
Old 12/30/2012, 20:14   #3
 
elite*gold: 0
Join Date: Aug 2012
Posts: 69
Received Thanks: 19
Errors Give ...
Attached Images
File Type: jpg errorwith.jpg (17.8 KB, 48 views)
[S]DipNot is offline  
Old 12/30/2012, 20:18   #4
 
elite*gold: 0
Join Date: May 2012
Posts: 174
Received Thanks: 203
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
rempieremco153 is offline  
Thanks
6 Users
Old 12/30/2012, 20:24   #5
 
elite*gold: 0
Join Date: Aug 2012
Posts: 69
Received Thanks: 19
Gem Fields Only Lapis Field ? Type ID Write Only ? We Want to removed?
[S]DipNot is offline  
Old 12/30/2012, 20:33   #6
 
elite*gold: 0
Join Date: May 2012
Posts: 174
Received Thanks: 203
Yes, they get removed from the gear..?
rempieremco153 is offline  
Thanks
3 Users
Old 12/30/2012, 20:38   #7
 
elite*gold: 0
Join Date: Aug 2012
Posts: 69
Received Thanks: 19
Thank you For all answer. Removed Items. But Not Removed WH İtems Guild Stored Items and Inventory in .
[S]DipNot is offline  
Thanks
1 User
Old 12/30/2012, 21:04   #8
 
Sh1nra's Avatar
 
elite*gold: 5
Join Date: Mar 2012
Posts: 1,007
Received Thanks: 498
Warehouse :


GuildHouse :
Sh1nra is offline  
Thanks
6 Users
Old 12/30/2012, 21:12   #9
 
elite*gold: 0
Join Date: May 2012
Posts: 174
Received Thanks: 203
Wasn't that hard, was it? :P
rempieremco153 is offline  
Thanks
3 Users
Old 12/30/2012, 22:06   #10
 
elite*gold: 0
Join Date: Aug 2012
Posts: 69
Received Thanks: 19
### Thanks All Again. Works it.
[S]DipNot is offline  
Reply


Similar Threads Similar Threads
How to remove 10 DG İtems drop ??
09/29/2014 - SRO Private Server - 6 Replies
How can I change and what tables.
Scroll of Soul-Linked REMOVE.
12/25/2011 - Flyff Private Server - 5 Replies
Hello, After I look at this forum, and get nothing I decide to open thread. I Want to know the "Scroll of Soul-Linked REMOVE" ID (v15-17) Exactly name of this scroll will be good too. That importent. Thanks guys,
How can I remove a virus linked on my Karma page?
06/14/2006 - Conquer Online 2 - 5 Replies
Someone left me a +karma along with a download link in the comments to a program which is infected with viruses. How do I remove this posting from my karma page? Check any suspicious links in your karma pages...



All times are GMT +1. The time now is 15:17.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.