Complicated Queries?

[fastelf]

Does anyone know a query code for this:

Delete all items which aren't in vendors.

[Xeneth]

You'd have to empty the creature loot tables, if that's what you mean.

[fastelf]

Dude, thats not even related to what i was on about.

Delete ALL items which AREN"T in the vendors, if they are in vendor the item doesn't get deleted.

[Xeneth]

you said all items that aren't in vendors

only other place to get items are from drops

delete the loot tables, creatures don't have drops

only way to get items are from vendors.

[jamiebabs]

items would still be there if you wanted to add items to vendors but that works

[fastelf]

Xeneth, Your completely IGNORING what i want.

I don't give a shit about about the drops, i can wipe them like there nothing.

I want a QUERY CODE to delete ALL ITEMS WHICH AREN"T IN VENDORS! If they are in vendors then the query won't delete them.

[TheSpidey]

Use PHP. It'll take some time though ;P
Deleting the drops is an easier solution. You'll have to drop that table anyways.

[fastelf]

I don't see how PHP has anything to do with SQL Queries.

[TheSpidey]

Here's a hint: You can use PHP as a programmable wrapper for SQL.

[latruwski]

hmm easy one:

DELETE FROM items WHERE NOT entry IN (SELECT item FROM vendors);

deletes all items from item table that are not sold by vendors...

tested and working on a blizzlike DB, note: takes a while to execute :P

grtz

edit: i know they are not on the first pages anymore but they still help a lot if people only read them:
http://www.mmowned.com/forums/emulat...e-queries.html
http://www.mmowned.com/forums/emulat...-part-2-a.html

[fastelf]

Thanks mate!

+Rep for helping me.

[latruwski]

Thanks mate!

+Rep for helping me.

no problem, that is what we are here for

[~ViVo~]

I'm saving that query.