Required items
Hello folks, need a little help. It's been forever since I've done anything eqemu related and I would like some info if anyone has it. What I am wanting to do is simple, I want to wipe my item table clean except for all items required for functioning spells and other misc required items. If anyone has a list of these items I would greatly appreciate you sharing it. If not I will look my self, I am simply trying to not reinvent the wheel here. Thank you for your time.
|
Quote:
|
What I mean are items like bone chips and peridots, ttems that spells consume when they are used. I want to wipe the item database and build a new one with custom items organized in a way that makes development of a custom world easier for me. I just don't want to bother with the spell files therefore I want to leave the items consumed by them.
|
Quickest way I can think of is to make a list of all the item id's required by the spells, then just run a query in your choice of MySQL browser selecting for any entries with those ids. Back those up, wipe the table, then restore, and you have yourself an empty table.
|
Simpler way is to use excel or a similar program to make a query for you. You can sort by reagent ID in navicat, and copy-paste it into excel. Something like
Code:
"Select * from items where id = (id from navicat) and If all else fails look into JOIN queries. Protip: Navicat's ordering views + Excel = heaven. |
Please use a simplied sql query rather than a long string
Code:
SELECT name from items i where id IN (1003,1001,1002) GeorgeS |
I'm sure the syntax is 100% correct, but you should be able to do something like this:
Code:
DELETE FROM items |
I was working on a query last night similar to AndMetal's, but it ended up running for about 2 hours before I killed it.
|
Quote:
|
Quote:
|
Hmm, while the syntax throws no errors there is something wrong with the statements logic as it deletes no items at all, looking into it.
Edit - When running this through an sql validator I get this The following feature outside Core SQL-200x (draft) is used: F561, "Full value expressions"" |
All times are GMT -4. The time now is 08:36 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.