This is an amazing project. I wish to see you maintain it.
Printable View
This is an amazing project. I wish to see you maintain it.
hehe if u extracted vmaps but answered no when it asked if you wanted to copy to server2 this would happen when you launched server2 or a failed extraction would cause it for both servers...look in your server.log and post the errors if you can't fix it, that way Ive got a better chance of telling you whats wrong...Quote:
Originally Posted by Noxen
How i can remove those robots walking in the air in Honor Hold?
It's most probably missing the co-ords for the spawn of the eye. Sorry, I don't have those available (yet!)Quote:
Originally Posted by lecso87
One way, is to select the robots, and type ".npc info". This will provide the GUID of the creatures. Go to the creatures table and remove the corresponding entry. Restart the server and they will be gone. Do this for each robot.Quote:
Originally Posted by agua
I have completed the DK trainers on the latest version of AmberGUI (V7689), with details from Thottbot for the spell IDs and the pricing.
The respective trainers in Ebon Hold are:
28471 - Lady Alistra - unholy trainer
28472 - Lord Thorval - blood trainer
28474 - Amal'thazad - frost trainer
There are currently no training entries in the UDB database for them, in the latest AmberGUI release (v.7689).
NOTE: I have also added the runeforging entries to ALL the three trainers mentioned above. The pricing for the abilities still needs to be confirmed if Blizzlike pricing required. I have used thottbot pricing, but they are not accurate. Feedback would be appreciated.
To enable the trainers in Ebon Hold, apply the SQL below to the UDB mangos database, (npc_trainer table):
//SQL Start-----------------
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','50842','5510','0','0','56');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','51426','60800','0','0','62');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','51427','65550','0','0','68');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','51428','342000','0','0','72');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','51429','342000','0','0','79');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','49896','57950','0','0','61');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49917','5510','0','0','60');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','49903','63650','0','0','67');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','49904','342000','0','0','73');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','49909','342000','0','0','78');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49918','61750','0','0','65');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49919','342000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49920','342000','0','0','75');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49921','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49892','56050','0','0','62');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49893','64600','0','0','68');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49894','342000','0','0','76');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49895','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','51376','342000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','51378','342000','0','0','75');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','51379','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','46584','5341','0','0','56');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49998','5341','0','0','56');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49999','61750','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','45463','59850','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49923','342000','0','0','76');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49924','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','47528','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','48263','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','48721','5510','0','0','58');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49939','62700','0','0','66');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49940','342000','0','0','72');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49941','342000','0','0','78');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','45524','5510','0','0','58');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','47476','5605','0','0','59');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','43265','5700','0','0','60');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49936','64600','0','0','67');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49937','342000','0','0','73');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','49938','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','49020','57950','0','0','61');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51423','63650','0','0','67');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51424','342000','0','0','73');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51425','342000','0','0','79');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','48792','58900','0','0','62');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','45529','60800','0','0','64');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','48743','62700','0','0','66');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','48707','64600','0','0','68');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','48265','342000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','47568','342000','0','0','75');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','42650','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','49142','5500','0','0','55');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','3714','57950','0','0','61');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','57532','69000','0','0','69');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','56816','63650','0','0','67');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49930','342000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49926','5605','0','0','59');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49927','60800','0','0','64');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49928','65550','0','0','69');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','49929','342000','0','0','74');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','57330','61750','0','0','65');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','57623','342000','0','0','75');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','61999','342000','0','0','72');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','56222','61750','0','0','65');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51418','171000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51419','171000','0','0','75');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','55268','171000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51409','31820','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51410','171000','0','0','75');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','51411','171000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','55258','56050','0','0','59');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','55259','30400','0','0','64');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','55260','32780','0','0','69');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','55261','171000','0','0','74');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','55262','171000','0','0','80');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','53331','5700','0','0','60');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','53331','5700','0','0','60');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','53331','5700','0','0','60');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','54447','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','54447','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','54447','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','53342','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','53342','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','53342','5415','0','0','57');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','54446','64600','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','54446','64600','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','54446','64600','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','53323','59850','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','53323','59850','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','53323','59850','0','0','63');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','53344','342000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','53344','342000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','53344','342000','0','0','70');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28471','62158','342000','0','0','72');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28472','62158','342000','0','0','72');
insert into `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) values('28474','62158','342000','0','0','72');
//SQL End-----------------
---------------
I have tested it on UDB, (after completing all the DK quests) and whilst I haven't checked all entries personally, the ones I have checked work, including the Runeforging for Lichbane. All three trainers (blood, unholy and frost) appear to work correctly. I have allocated the spells to the respective trainers.
I suggest that the entries be deleted prior to upgrading AmberGUI. Just in case they are properly done in a subsequent AmberGUI release.
To delete, execute the following SQL against the npc_trainer table in the mangos database.
//SQL Start-----------------
delete from `npc_trainer` where (`entry` = '28471');
delete from `npc_trainer` where (`entry` = '28472');
delete from `npc_trainer` where (`entry` = '28474');
//SQL End-----------------
ENJOY.
Thx Shivajiva =)
Can I patch TBC 2.4.3 to make it WOTLK? Will the Death Knight be available? :?:
Quote:
Originally Posted by macariosakay
you need to install the WOTLK addon not just the patches to get it to 3.0.9
and extract the maps for the server
where i find this WOTLK addon download??Quote:
Originally Posted by wowit
thx
Quote: Originally Posted by macariosakay
Can I patch TBC 2.4.3 to make it WOTLK? Will the Death Knight be available?
Please rephrase your question...it is too vague.
WOTLK is a retail update to 2.4.3 TBC. You can purchase it online or over the counter.
My question: Which AmberGUI release are you running?
how much of the DK staring zone working ??? please
I just got upto the quest endless hunger & cannot release the initiates ?
i'm still using shiva's repack for 2.4.3:Quote:
Originally Posted by ninofarino
i still don't have wotlk. :/:
It would be easier if you would just mark the objekt and writeQuote:
Originally Posted by ninofarino
.npc del
instead of deleting it in the tables.:sleep:
Quote:
Originally Posted by Link2
It sure would....LOL
Hi, I'll shortly post a walkthrough, with required fixes or steps, to allow you to complete the DK quest line, get friendly with Stormwind or Orgrimar and continue questing with your death knight.Quote:
Originally Posted by blackhawk
Thanks, ninofarino.. for the DK Trainers.. it
nice work shiva
thanks for replyQuote:
Originally Posted by ninofarino
thankyou so much for the repack.. i have just the same errors with the DK starting area but everything else seems to work fine. Shadowform for priests also casts a version of levitate and floating spell and a quick fix is to disable these two spells since they are not usually available to characters in game.
i have UDB 0.11.0 CS370 + MaNGOS 0.13.0 v7624 and im trying to use the update V. UDB 0.11.5 CS378 + MaNGOS 0.13.0 v7624-v7689 but it wont let me update when i try and install it, it says Error: v7624 doesn't exist!
Update Failed! Launch uninstaller?
Worker_1_Error: ServerUP=False
I don't know what im doing wrong do i have to install it to a surton area if so were? also will i have to recreate the weapons/Armors that i maid if so can i copy them from a file some were in the db?
Thanks For these great repacks!! you make it much easier this is my first time
I would recommend you update v370 up to v7624. I've been updating with those small updates bit by bit and I haven't had any problem. I think you missing important update information when you go from v370 to v7624 but I'm sure someone will correct me.Quote:
Originally Posted by Delta6327
On to my problem which seems to get buried as soon as I post my question. I'm still having problems with my hunters pet not attacking anymore with the update. I think its the actual core of MaNGOS however I'm still unsure. Is there a way to fix this problem? Any help would be great.
i havent had problems with the hunters pet... but with DK spells and also Holy Nova for priests doesnt heal... i am not sure how to fix spells on my own so i figured the best i can do is post here...
How can i play with the DK, i have the last update and client version 3.0.9 but i don't know how can i create a DK.
sorry about my noob question.
Hugs..
using this release, can i play without wotlk expansion installed?