[Question] Getting teleport Alterac Valley

[Astrup]

I have some question about getting teleport to Alterac Valley.
Sometimes on some repacks i can teleport to Alterac Valley,
and some other it says: Unable instance or Instance not found or something.
How can i fix this so i can go on every repack to Alterac Valley with
.recal port AlteracValley

 

[KingXCrosses]

you can't, its blocked out i think

 

[beileroord]

Whahahaha.... Blocked out good one... We're Admins so we UNBLOCK!!!!

##ALTERAC VALLEY UPDATE 
REPLACE 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');

replace 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
   (169, 169, 0, 0, 1, 0, 0, 0, 169, 'EmeraldDream', 1, 0, 0, 0, 0, 0, 0, 80, 0);

REPLACE 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   (44, 169, 0, 0, 1, 0, 0, 0, 44, 'Old SM', 1, 0, 0, 0, 0, 0, 0, 80, 0);

REPLACE INTO recall  (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) VALUES  (10000, 'EF Statue', 169, 3105.41, 3096.78, 28.0032);

REPLACE INTO recall (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) VALUES  (10001, 'EF Trees', 169, 2732.93, -3319.63, 102.284);

REPLACE INTO recall  (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) VALUES   (10004, 'Old SM', 44, 75, -1,19);

This will make AV free again (hehehe) also adds some recalls and Azhara Crater (.gotrig 60000)

 

[Astrup]

Thanks hope this will works

##ALTERAC VALLEY UPDATE 
REPLACE 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');
 
replace 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
   (169, 169, 0, 0, 1, 0, 0, 0, 169, 'EmeraldDream', 1, 0, 0, 0, 0, 0, 0, 80, 0);
 
REPLACE 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   (44, 169, 0, 0, 1, 0, 0, 0, 44, 'Old SM', 1, 0, 0, 0, 0, 0, 0, 80, 0);
 
REPLACE INTO recall  (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) VALUES  (10000, 'EF Statue', 169, 3105.41, 3096.78, 28.0032);
 
REPLACE INTO recall (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) VALUES  (10001, 'EF Trees', 169, 2732.93, -3319.63, 102.284);
 
REPLACE INTO recall  (`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`) VALUES   (10004, 'Old SM', 44, 75, -1,19);

This will make AV free again (hehehe) also adds some recalls and Azhara Crater (.gotrig 60000)[/quote]

 

[agas]

I have very noob question.I setup my server and it is running fine. I want to teleport to all BG. How can i do it ? And where should i put his little peice of code to teleport to AV ?

thanks

 

[kein92]

Not a noob question agas I had to figure that one out myself. You need to download a program called navicat. Once you have this, start the background program in your server the one that launches mysqld-nt once you have mysqld-nt running open navicat and create a new connection the ip address should be localhost the port should be 3306 and username and password are both root. If that's the wrong password then you'll need to ask the person that made your repack what the password is. The Connection Name is whatever you want. After you do this you should see on the left side a new icons click the button that says "view" it should be between two buttons called "Table" and "Stored Procedure" after that look until you find something on the left called worldmap_info open that and look for another table inside that one called worldmap_info then replace with the code. After you're done inside worldmap_info (The first one) there will be a table called recall if you want you can replace the code there also but I don't suggest it because for me those recall ports work.

 

[GroM6]

.cheat triggerpass?