Hypnos

[Guide 1] Software for creating Patches Hello, in this topic you will find the software need for creating patches/fixes for a wow server and for learning to config it and for learning to use it. Beside, whatever dude that you have, you can ask it here and it will be resolved. Basicatly it can be done with notepad but we will do everything more comfortable and reliable. 1- REQUERIMENTS: 1.1. SqlYog : Its a manager of database (DB). We will use it for applycating-introducting patches in our DB. If you have knowledge about sql you can use directly mysqld but its easier for using SqlYog or Heidi (similar sotfware to SqlYog) because the interface is very intuitive and it has a lot of tools which will do very much easy our job. 1.2. Mysqld : Its the server which allow us that the BD is in communication with our DB''s Manager. The middlie man. It has to be installed and opened if we want to use SqlYog or Heidi. 1.3. DataBase: Its where we can consult every table of dates which have our wow server and its where every one of our patches will be saved so the game can execute them. Wow has 4 DB: . auth : save our account dates. . characters: save our characters dates. . hotfixes: save the last and urgents patches added after of a expansion was introduced. . world: save every thing in game, include criatures,quests,flypaths,achievements.... We will use only World and maybe sometimes Hotfixes. 1.4. Notepad++ : Its a manager of text for differents languages of programs what do more easy our job. It does that every variable, of your core, have a different color, so if you do a mistake its faster to locate it. His interface is very easy and intuitive,really easy to use. 2- DOWNLOADS: 2.1. notepad++ (download the last release): https://notepad-plus-plus.org/ 2.2. SqlYog (Its a trial version, but you can use it even when the trial periode is finished.): https://www.webyog.com/product/sqlyog 2.3. mysqld: http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.26-win32.zip (32 bits) http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.26-winx64.zip (64 bits) 2.4. Database (For downloading it you have to registre before in trinity core forum.): https://github.com/TrinityCore/TrinityCore/releases 3- INSTALATION,CONFIGURATION AND USE: 3.1. mysqld: * When you are instaling this, you save/remember the password which you use. You will need it for connecting with SqlYog to your DB. For installing it, double click. When it asks which type of DB we want, we will mark "developers". User = root and pass = ascent. Dont change the rest of options and click accept until the end. It doesnt need configuration. For using it, go to C:/Program Files/Mysql and create a direct access to your deskopt or in the place that you want. For executing it, double click in the direct access and a console will appear which has to stay opened while we use Sqlyog. For closing it, Control + C in the same time and then Yes. 3.2. SqlYog: For instaling it, double click and accept until the end. In the end the program will be opened. For configurating it,we will be asked for a conection name (you use the name that you want,example Wowlocal). Then a window will be showed,up where it says "saved connections" we will select the name which we used before, "Wowlocal". In MySQL host address writte "localhost" (withouth "") because our server will be local. Username = root password= ascent or the password which you used to install mysqld. Now you save the configuration. For using it, the first is execute mysqld if not sqlyog will give error.Now we execute SqlYog and if you configured it good,it should to connect to our DB directly (which will be empty because we didnt import the downloaded DB of trinity). I will explain a little the interface of SqlYog using the next screenshot: "root@192.168.1.7" its our connection to the mysql server. "mysql","sakila" ,"test","world" all that names in grey are DataBases. If you pay attention in "sakila",clicking in the icon "+" it deploy the folders in. If we click in the icon "+" of the folder tables again, it will show the tables which are in that database (tables = blue icons like "actor","address",etc.). If we click in the table "city" (like in the screenshot), it will show all his content in the window below. In the window below we can see all the content of a table and beside we will can see,when we apply a patch, if it had any error or if it was applyed good. If we do a query of sql (a select to search anything,for example)the result will be showed in this window below. The upper part ,in which show 3 numbered files, is the place where we will copy our patches so it is applyed. Or whatever query for doing a consulte. The upper menu and the icons. For the moment we will explain only the basic and important icons. When you have wrotten a patch with only one query and you want to apply it, you have to click the "blue play icon",the first one down of "Favorites" option. If the patch has more than 1 query so you have to use the blue icon with 2 blank arros in. For the moment, its sufficient with this ticks. You can ask if you didn''t understand anything. Maybe others options and tools will be explain later. Note: Patch can be applyed in that window or patch can be imported to apply it as we will do for installing the datebases in the next steps. 3.3. Database: Unzip thefile downloaded. It has 2 files TDB_full_world_6.02 y TDB_full_hotfixes_6.02. Open mysqld y SqlYog,and then we connect to our database. Rigth click in root@192.168.1.7 (or whatever is our usser named,first line left,up of the databases) and we choose the option "create database". We will name our database hotfixes. We will repeat the same proccess and we name the new database world. You can see now that below of root@192.168.1.7 we have our databases created (hotfixes and world). If you dont see it, click f5 for updating the interface. Then we click in the hotfixes DB so the DB is marked and we choose the option up database or db (depend of the SqlYog version), import/execute sql script. Now we search the Hotfixes DB which we downloaded before (TDB_full_hotfixes_6.02),we select it and click execute. We have imported the hotfixes DB in our databse already. We mark now,below of root@192.168.1.7 the db "world" clicking 1 time in it and we repeat the same procces again but this time we choose the world DB named TDB_full_world_6.02_2015_07_14. We have imported the DB hotfixes and world in our SqlYog now. 3.4. Notepad++ : For installing it,double click in the file and accept everything until the end. Dont need configuration. For using it,double click. In the first use you search the option File/New. Then File/Save as...,you choose the name and below in the place where it says type, we will choose "structured Query Language file (*sql)". We choose the place to save it and we save it. Doing this our patch will have .sql extension (the extension need to import patches in SqlYog). Beside, doing this when we writtre our patch in notepad++ it will show with the sql structure with differents colors so we can identify mistakes while we writte it.

Hello, Comunity of Firestorm! We have recibed a lot of tickects asking for help about this matter. So after a few hours of tedious struggle to complete this quest chain, I could find the most viable way to do it. I will explain the way,step by step to get this legendary weapon http://wowhead.com/item=49623 Before we begin, let's consider the following: -The difficulty will always be 25 players ( Normal) -We must be accompanied by at least two more players, including a healing. (Required for Valithria Dreamwalker) -The quest chain must be carried out only by the classes : Warrior, Death Knight and Paladin . -All raid bosses must die and must be defeated in order. ( Light Hammer , Workshop plague,Crimson Lounge , Frostwing Halls cameras) . -Once the mission # 2 ( Edge shadows) completed we always put out our http://wowhead.com/item=49888 -All quests must be taken and deliveries in the NPC http://wowhead.com/npc=29173 we started : Quest # 1: " The sacred and the corrupt " The first quest is very simple, because it is a simple collection . Once we get the objects, and we will deliver them in the forge , as follows: e47384fc2de98e18bec9b39969a7209co.png Quest#2: "The edge of the shadows" In this quest we will not have to do anything, because it is autocompletable . Only we take it, and we deliver it in Highlord Darion Mograine : 7552873e77cb3f4e25b93dfda2131dffo.png Quest#3: "A feast of souls" With our http://wowhead.com/item=49888, we procee to kill 50 moobs / adds that we found in the raid. I do not have attached picture of this because it is not needed. Quest#4: "Unholy infusion" Who hasnt the questline have to taunt profesor while who has the questline mount in abomination. You wait for the floor is full of the green thing, so you start to absorbe it quitly, spamming the spell 1 in the bar of abo. When the energy in abo is full,you use the spell 6 in the bar to hit profesor. Then you can kill profesor and when he is dead, the quest will get completed. Quest#5: "Blood Infusion" It is for this mission that I asked you to come accompanied . I will explain why : When we get to Blood Queen Lana'thel ,the time to start the meeting with the boss, the aggro should be taken initially by a player other than the one carries the quest chain , otherwise the mission will not be completed. Once you have begun the meeting, player carrying the quest chain can take the aggro the boss to receive 4 loads http://wowhead.com/spell=72132 dae9b8dc3c6935223b19d36f19d2363co.png When the player taking the mission, or one of his companions receive http://wowhead.com/spell=70867, he should bite himself. And players should bite him. And once we have the 4 loads , we can kill the boss without any problems. ( We take our new weapon set all the time) Quest#6: "Frost Infusion". This quest is much easier than before. We simply must go to http://wowhead.com/npc=36853 ( with our new weapon on) and expected to use the skill http://wowhead.com/spell=73061 . we also have to get 4 loads . ce5e0b21be634381945a04cb974b7832o.png When we have 4 loads , we get a buff . With this, we can kill Sindragosa smoothly, and the quest will complete . 9dcaf7263dd3b66f6051b862ffd165d6o.png Quest#7: "Chipping throne" This quest is one that requires more time to complete. We must gather 50 http://wowhead.com/item=50274/fragmento-de- frost - of - the - shadows that can be obtained from the heads : http://wowhead.com/npc=36678/profesor-putricidio and http://es.wowhead.com/npc=36597/the- king-exanime Once we have the 50 , we can go to the NPC who gave us the quest to complete. d89c9a768f6c9f3fd008ba831276ad6do.png Quest#8: "Shadowmourne ..." This is the last quest and our reward will be : http://wowhead.com/item=49623 We present the weapon we got earlier and have been wearing during the course of the raid . So easy like going to the NPC Highlord Darion Mograine , take it and complete it, as it is autocompletable . d22f10b774a3866cdf96372359e55e5co.png And after delivery of the last quest we have completed everything, and receive our reward : ba4efddb98b4e980e0926c06db981564o.png I hope the guide can be useful for everyone who wants to get the legendary weapon . If you have a question on the issue, or are still having problems after following the steps in the guide , I would be very grateful if I do know through an in- game ticket in my name. Remember that we are here to answer your questions. : D Goodbye , random . <3 Pdta: CREDITS OF THIS GUIDE ARE FOR GM RANDOM.

Hello, 1- Here you have a vid about completing all quests in Tanaan Jungle. https://www.youtube.com/watch?v=RmovsAXg1x8 You are level 94 now. 2- Next step,you create your Garrison and you complete all possible quests there. You would have to be level 96-97 now. 3- You go to all village near and you complete all possible quests there, you would have to be level 99 or 100 now. 4- If you arent level 100 still, you go to Nagrand and you complete the SteamWheedle Preservation Society quests. This quests are repeteable and you will get rep with this faction, beside a tittle and you will be gearing up because you have to kill rare elites for completing it. This are the quests: http://www.wowhead.com/faction=1711/steamwheedle-preservation-society#comments Important Advices about completing quests in Tanaan Jungle: Nowdays there are 3 possible buggued quests (a Dev is fixing it in this moment) so while it get fixed i will tell you the way to you dont get buggued the quests or the way to you can fix yourself the problem. a- http://www.wowhead.com/quest=34429/kill-your-hundred b- http://www.wowhead.com/quest=34434/yrel c- http://www.wowhead.com/quest=34445/a-taste-of-iron 1- Like to you dont get buggued the quests: For quests a- and c-, dont skip the end intro when the quest is completed. You have to watch the full vid when you kill the 99 and when you kill the 200. For the quest b- for the moment I dont know a way to it doesnt get buggued. Maybe if you follow Yrel really closed the next quest dont get buggued but I didnt can test it, so dunno. 2- Like to fix that 3 quests if it got buggued: - For quest a-, you have to abandone the quest and you start it again. This time you dont forget to dont skip the end intro when you kill the 99. - For quest b-, you have to get killed near of the door,then release. When you get in ghost, you go where your corpse is and you cross the door in ghost form. So you revive in of the room, in the place where your objective quest is. You can kill him now. - For quest c-, you pray for that someone of the enemy faction is near. You tell him/her to kill you so you can revive and you can move again. You have to abandone the quest and you do it again. This time, you dont forget to watch the full vid when you kill the 200. Dont skip the end intro. I listened that the last quest get buggued sometimes too, surely its the same problem. Dont skip the end intro when you are in the ship. I hope that this help someone. Good luck leveling.

Use the unstuck of website or you teleport out of tanaan jungle. Rejoin tanaan jungle, if you cant, you create a ticket so a gm help you. And you retake te quest,dont log out while you are doing tanaan or you can get stuck there.. Regards.

Speak with the mage Khadgar npc in Blaste Lands and he will complete the quest and he will teleport you to tanaan jungle.

Dunno why i havet "like" button here, so Thanks you ^^ .

Awesone intro, if its ok for you i will use it in my next videos.

Hello, this thread is for requering your help in testing Gara questline in ptr wod. Its almost done but i need any feedback about possible bugs before of adding it to lives servers. For the moment its missing any conditions and small details. Thanks you in advance. Regards. http://eyesofthebeast.com/2014/09/gara-spirit-beast-epic-taming-quest/

Thanks you for the feedback, i added a patch the monday. I guess that is why you did can finally ^^ . Grats btw.

That in my country is insulting. And Im sorry to tell you but this isnt retail.You are blaming people who get full geared in low rates but you want the retail system which allows you to get full gereaded in 1 week if the season has started 2 months ago... /clap And your cap increment if you get higher than 1500. Retail reset 3 times per week?....... PS: funny that someone who play tournament server says it.....

You are the second person who says that today...maybe it got buggued...i will check it but for the moment, the respawn time should to be 10-15 mins, so you wait there that time. Maybe others hunters killed them and they have to respawn,dunno really why this is happening. Please, you dont forget to give me a feedback if you get it done. Regards.

You have to use the linter so you get the buff and then you can click the dagger.

You tell me what you have done for the moment and where you are stuck exactly please.You tell me every step which you did.

The items are for creating the sffige which you use in the disturbed grave,then you need the linter buff for dagger works. Check a guide for doing the questline.

It isnt only Sombraluna players. You try to dont insult and you have any respect to others players. With that actitude you wont get what you want. Maybe you need do more bgs before you join arenas, gear isnt everything there. If you know your class and you know the way to play it you havent to care about gear in that low rate.

The guide wasnt created by me. But maybe it doesnt work the same way than in the official,dunno really.

You allow the other player to hit first the boss, then you take the agroo.

I have full geared 3 alts in wod with the last pvp gear and i almost dont play since long time ago,beside im really noob(1.8 k rate the higher). Gearing up is really easy, and it wouldnt have to be a excuse for this sugestion. Crossrealms= more honor,win or lose you get honor faster. Even when i dont like the system, if its blizzlike I would like to they add it too.

Im not agreee or desagree with the suggestion but saying that its hard to gear up in pvp it isnt true. And since CrossRealms its really easy. For the conquest gear, you need hands but not a big cap in the begin. If you want things blizzlike or easier its ok but you dont say things which arent true. That circle only is true when you have a higth rate.And when you have it you will have better gear, so the difference in gear between you and your opponent wont be much. That system is only a burst for new corners for getting pvp gear easier. Same as creating a lvl 90 in the start instead of a lvl 1. Dunno why blizzard created that system. Its a disadventage for old players. Good luck with the suggestion btw.

Third-party program, I guess its clear. It isnt need to name every program there. By the way, i dont know any private server which allows you that program,do you? And it isnt only for Visual Effects, even you know that.

It would be nice, but wait for the monday to do it. Maybe it will get fixed with the new patch

Thanks you but the credits are for GM Random, he is a GM of firestorm. I only translated the spanish guide to english ;). I hope that this helps a little people. Edited :Ow you are a Sombraluna player .

You dont use unstuck, its worse. you create a ticket in game so a gm help you or you wait for a enemy to kill you. Maybe you have some friend with a char in the opossite faction...? I will comunicate it tomorrow to the dev who scripted that zone,sorry for the inconvenients...

More disturbing are your comments, i guess you cant even distinguish spanish-latin. You should stop racism. There are people who join bgs to win and others who join to do pvp,These people are from all differents countries and no one in particular.

Nice and grats!! ^^ Thanks you for the feedback.