Remove POK books

[pheroux]

Hi,

(I don't know if I'm posting in the right section) But here goes...

Does anyone know how to remove all the PoK books in all the zones?

Thank you,

Phil

[Tabasco]

DELETE FROM `doors` WHERE dest_zone = 'poknowledge'

That's how I do it anyway.

[501st]

DELETE FROM 'doors' WHERE name = 'POKTELE500'

[Tabasco]

Originally Posted by 501st

DELETE FROM 'doors' WHERE name = 'POKTELE500'

If I'm not mistaken that will also remove a link between nektulos and corathus.
You could combine the two WHERE clauses to avoid that if you wanted to leave other links to PoK, but that won't disable every avenue into the zone.

[501st]

Originally Posted by Tabasco

If I'm not mistaken that will also remove a link between nektulos and corathus.
You could combine the two WHERE clauses to avoid that if you wanted to leave other links to PoK, but that won't disable every avenue into the zone.

Ahh you're right it does. I didn't even notice that. So the correct method, should he desire to preserve that link, would actually be:

DELETE FROM 'doors' WHERE name = 'POKTELE500' and dest_zone = 'poknowledge'

He only said he wanted the books gone though, don't know if he actually wants to sever all possible connections to PoK. I'm guessing just rebuilding custom zones and doesn't want them in the way. If he does, however, you're query would be the best