Infinite Zoning Loop

[Angelox]

This is imporatant and would be nice to have fixed;
TOFS Keys
Crystal Key - 2nd floor
Three Toothed Key - 3rd floor
Frosty Key - 4th floor
Small Rusty Key - 5th floor
Bone Finger Key - 6th floor
Large Metal Key - 7th floor
Tserrina's Key - Master Key
The top floor (Tserrina's floor) mirrors, those doors don't work right - they all warp you outside the dungeon. They are supposed to take you to different floors with the different keys, or master key ( or maybe just master key?), and one takes you outside.

As for the zonelines, I wouldn't worry about that too much - there's too much other stuff broken that needs fixing, with very few people fixing them.
A zoner npc works fine, so it drops down on the "todo list" tell all the other stuff gets fixed.

[John Adams]

Originally Posted by Angelox

As for the zonelines, I wouldn't worry about that too much - there's too much other stuff broken that needs fixing, with very few people fixing them.
A zoner npc works fine, so it drops down on the "todo list" tell all the other stuff gets fixed.

Don't take this the wrong way, but this is what I am talking about. Dismissing someone elses bug finds as "unimportant" will end up with people not helping at all. If buffer spent the time to troubleshoot and identify a fix, maybe it deserves more than being dismissed?

If I kept reporting bugs that never got any attention, I'd stop reporting bugs. No matter how insignificant.

[bufferofnewbies]

I wasn't sure which mirror went where on the top floor, so I started on the left and sent them to floor 1, floor 2, in that order.. up to floor 6. If that's wrong, just let me know the order and I will change it. I reset the mirrors on the top level to correspond to locations of where the other mirrors send you (except for the first one.. which is at zonein) and locked them with keys also (again, except for the first one).

The master key wont work to open any floors except the first floor one that sends you to the key room. That's a limitation atm with the emu, only 1 key per door as far as I can tell.

I set these as seperate commands, instead of one stream. So you will have to run them individually until I learn more about the limits of mysql.
As always: backup before you try this, as I code like old people f... well, you can fill in the blanks there.

UPDATE doors SET keyitem = '20039' WHERE zone = 'frozenshadow' AND doorid = '1';
UPDATE doors SET keyitem = '20033' WHERE zone = 'frozenshadow' AND doorid = '2';
UPDATE doors SET keyitem = '20033', dest_zone = 'frozenshadow', dest_x = '660', dest_y = '100', dest_z = '40' WHERE zone = 'frozenshadow' AND doorid = '166';
UPDATE doors SET keyitem = '20034' WHERE zone = 'frozenshadow' AND doorid = '4';
UPDATE doors SET keyitem = '20034', dest_zone = 'frozenshadow', dest_x = '670', dest_y = '750', dest_z = '75' WHERE zone = 'frozenshadow' AND doorid = '167';
UPDATE doors SET keyitem = '20035' WHERE zone = 'frozenshadow' AND doorid = '16';
UPDATE doors SET keyitem = '20035', dest_zone = 'frozenshadow', dest_x = '170', dest_y = '755', dest_z = '175' WHERE zone = 'frozenshadow' AND doorid = '165';
UPDATE doors SET keyitem = '20036' WHERE zone = 'frozenshadow' AND doorid = '27';
UPDATE doors SET keyitem = '20036', dest_zone = 'frozenshadow', dest_x = '-150', dest_y = '160', dest_z = '217' WHERE zone = 'frozenshadow' AND doorid = '169';
UPDATE doors SET keyitem = '20037' WHERE zone = 'frozenshadow' AND doorid = '34';
UPDATE doors SET keyitem = '20037', dest_zone = 'frozenshadow', dest_x = '-320', dest_y = '725', dest_z = '12' WHERE zone = 'frozenshadow' AND doorid = '168';
UPDATE doors SET keyitem = '20038' WHERE zone = 'frozenshadow' AND doorid = '44';

Let me know if anything is screwy, else I'm off to the zonelines to fix them.
edit: spelling errors, argh!