Well I tried it on a clean "Norwegian Elite 3.0" database but still get SQL errors...
Well I tried it on a clean "Norwegian Elite 3.0" database but still get SQL errors...
Very strange.
I will completely remake the instance (it wasn't that hard..) and see what I can do.
Everything is fine here.. a few syntax errors on the weapons but just remove the above text so you only have:
I just cant enter the instance.. could anyone make a worldmap_info query to activate this place ? I used this to activate 'Alterac Valley':Code:INSERT INTO items VALUES(666602, 2, 7, -1, "Blade of the Dragonblight", " ", " ", " ", 31867, 6, 0, 0, 95814, 13, 1503, 1791, 77, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 3, 140, 4, 140, 7, 70, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 600, 50000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5000, 0, 0, 0, 0, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "This blade holds all of the Blue Dragonflights energies inside of it, ready to be unleashed at your enemies.", 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 999, 0, NULL, 0, NULL, 2, 0, 4, 0, 8, 0, 0, NULL, NULL, 0, -1, 0);
Code:INSERT INTO `worldmap_info` VALUES ('30', '30', '2', '80', '1', '628.53', '-207.67', '39.0523', '0', 'Alterac Valley', '3', '0', '0', '0', '0', '0', '0', '80', '0');
Dude, Bioz, that SQL fixed my inability to port to AV. Mind uploading it for the other instances in this thread as well?
http://www.mmowned.com/forums/emulator-server-discussion/82223-instance-not-found.html
Would be greatly appreciated.
P.S. I already have them in world_map info, not sure what the difference between ours are.
If you already have them in world_map info, just change the entry id in this query and run it:
Your link does not work.Code:UPDATE `worldmap_info` SET `type`='0' WHERE (`entry`='30');
If you have this Hyjal instance in your world_map, could you share it please ?![]()
Last edited by Bioz; 01-20-2008 at 01:25 PM.
So far as i know, it's not actually an instance, it's just beyond a cave in Old Hyjal. You could try .worldport 1 4856.353516 -1803.025879 1153.93042.
Yes, exactly what Shao111 said. =]
Hell
Already tryed .worldport.. it shows loading screen for 1 second and nothing happends.
I need it in my world_map table.
That's odd, it's in Kalimdor and i don't have anything in my worldmap_info concerning Hyjal. I get there without a problem.