[Release] Northrend recalls

[KaMakaZe]

Heres the sql to add most of northrend recalls to your database.
Im pretty sure it hasnt got every camp or cave in Northrend. But it covers most of them.

Enjoy!

insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('803','sholazarbasin','571','5552.69','4724.43','-125.241');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('802','thenexus','571','3869.8','6984.45','153.847');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('801','riplashruins','571','1421.09','5850.49','12.8219');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('800','valiancekeep','571','2285.24','5244.92','11.3552');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('799','warsonghold','571','2508.75','6172.98','53.1912');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('798','fizzcrankairstrip','571','4139.72','5279.76','25.4912');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('797','boreantundra','571','3937.93','4918.8','-10.3978');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('796','taunkalevillage','571','3445.42','4113.63','15.7898');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('795','moakiharbor','571','2800.67','919.297','21.9755');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('794','emeralddragonshrine','571','2881.42','58.1537','1.22916');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('793','venturebay','571','2827.72','-1916.72','8.98688');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('792','westguardkeep','571','1393.72','-3257.68','161.656');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('791','theisleofspears','571','556.756','-3241.17','26.3826');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('790','valgarde','571','565.948','-5009.38','11.6772');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('789','nifflevar','571','942.958','-5481.67','186.309');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('788','fortwildervar','571','2473.72','-5035.69','283.025');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('787','howlingfjord','571','2690.17','-4317.91','290.674');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('786','skorn','571','1982.67','-4120.43','214.68');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('785','gjalerbron','571','2737.09','-3697.23','221.723');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('784','grizzlyhills','571','3827.76','-3162.31','283.106');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('783','grizzlemaw','571','4021.15','-3779.31','115.013');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('782','blueskylogginggrounds','571','4261.05','-3182.63','308.816');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('781','ursocsden','571','4888.66','-3841.05','337.566');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('780','gundrak','571','6840.19','-4525.22','441.985');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('779','zuldrak','571','5451.2','-2629.19','306.253');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('778','sifreldarvillage','571','6861.95','-1070.46','802.688');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('777','thestormpeaks','571','8323.74','-1007.01','923.874');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('776','ulduar','571','9119.77','-1112.91','1216.55');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('775','templeofwisdom','571','8574.38','-593.872','925.558');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('774','icecrown','571','6936.87','1357.96','396.304');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('773','dalarancity','571','5812.79','647.158','647.413');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('772','crystalsong','571','5450.19','51.0942','149.272');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('771','theargentvanguard','571','6258.36','-18.7309','410.048');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('770','ymirheim','571','7082.37','1816.12','528.378');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('769','icecrowncitadel','571','5923.56','2130.71','637.277');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('768','wintergrasp','571','4603.89','2847.38','396.898');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('767','korkronvanguard','571','4945.93','1162.24','239.569');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('766','fordragonhold','571','4607.48','1406.34','195.03');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('765','dragonblight','571','4408.44','569.679','114.876');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('764','wyrmresttemple','571','3545.91','273.453','45.5836');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('763','newhearthglen','571','2816.32','-329.845','132.673');
insert into `recall` (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) values('762','acherus','609','2374.03','-5651.61','426.127');

Use the sql above or download it here: http://www.dangaming.co.uk/uploads/wotlkrecalls.sql

If you dont have the worldmap_info for northrend heres the sql:

insert into `worldmap_info` (`entry`, `screenid`, `type`, `maxplayers`, `minlevel`, `repopx`, `repopy`, `repopz`, `repopentry`, `area_name`, `flags`, `cooldown`, `lvl_mod_a`, `required_quest`, `required_item`, `heroic_keyid_1`, `heroic_keyid_2`, `viewingDistance`, `required_checkpoint`) values('571','571','0','0','1','0','0','0','0','Northrend','9','0','0','0','0','0','0','80','0');
insert into `worldmap_info` (`entry`, `screenid`, `type`, `maxplayers`, `minlevel`, `repopx`, `repopy`, `repopz`, `repopentry`, `area_name`, `flags`, `cooldown`, `lvl_mod_a`, `required_quest`, `required_item`, `heroic_keyid_1`, `heroic_keyid_2`, `viewingDistance`, `required_checkpoint`) values('609','609','0','0','1','0','0','0','0','DK startzone','1','0','0','0','0','0','0','80','0');

Enjoy!

[Etna]

Thx alot i needed this +rep x2

[patoman230]

thanks... thanks.. and more..thanks

[benclarke]

How do i add this to my recall list?

[benclarke]

nevermind. I guessed and iit worked. I just manual added Dal...although there already is a recall called dalaran so if you use this method make sure you name the northrend one dalarancity etc.

[KaMakaZe]

Thanks for the input. The Dalaran recall has been changed to DalaranCity.

As for adding it to your server. Its a simple sql file which can be extracted to the database via SQLyog or Navicat.
Thanks for the +Rep Glad to be helping people out.