[Guide 1] Software for creating Patches

[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.

Spoiler

 

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.

Spoiler

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.

Spoiler

 

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:

Spoiler

    "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.

Spoiler

 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.

[Avoel]

What about navicat?

[Kilydan]

nice guide, maybe a guide on how to setup a actual local server would help aswell, i once tried it but couldnt even figure that part out while i would love to try some stuff out / create some small updates if im able to

[Avoel]

Just now, Kilydan said:

nice guide, maybe a guide on how to setup a actual local server would help aswell, i once tried it but couldnt even figure that part out while i would love to try some stuff out / create some small updates if im able to

Google / YouTube will help you , most ppl run a allready compiled Server where u just start an exe and your wow exe to connect on it.

Otherwise download a non-compiled if you wanna try to fix scripts as example, or just run a compiled one , and try to fix things and figure out how to use the Database :D!

[Kilydan]

Just now, Tweedy said:

Google / YouTube will help you , most ppl run a allready compiled Server where u just start an exe and your wow exe to connect on it.

Otherwise download a non-compiled if you wanna try to fix scripts as example, or just run a compiled one , and try to fix things and figure out how to use the Database :D!

as i said, tried to follow a guide, ended up with like 10 diffirent downloads needed to setup a local server with DB etc and stuff like that. evrything combined ust made my braincells commit suicide 1 by 1 cuz i couldnt see wtf i had to do anymore. (it was something a dev linked to me to guide me in the right direction, but i can understand that he didnt had too much time/wanted to waste too much time to explain everything i ahd to do in detailed steps) i tried yt/google BEFORE i asked the dev btw and it also made my brain commit suicide

[Avoel]

Just now, Kilydan said:

as i said, tried to follow a guide, ended up with like 10 diffirent downloads needed to setup a local server with DB etc and stuff like that. evrything combined ust made my braincells commit suicide 1 by 1 cuz i couldnt see wtf i had to do anymore. (it was something a dev linked to me to guide me in the right direction, but i can understand that he didnt had too much time/wanted to waste too much time to explain everything i ahd to do in detailed steps) i tried yt/google BEFORE i asked the dev btw and it also made my brain commit suicide

Sounds like you wanted to use a non-compiled Server , yea its a bit strange to set it up. I had my self in the first time some struggles cause some programs to compile didnt worked and stuff  but later i've found a way to compile and run it , was kinda strange , but it worked. Btw. it depends on which kind of fix u want to bring on , like scripts? Non-Compiled , database stuff a compiled one

[Kilydan]

Just now, Tweedy said:

Sounds like you wanted to use a non-compiled Server , yea its a bit strange to set it up. I had my self in the first time some struggles cause some programs to compile didnt worked and stuff  but later i've found a way to compile and run it , was kinda strange , but it worked. Btw. it depends on which kind of fix u want to bring on , like scripts? Non-Compiled , database stuff a compiled one

im still studying to become a programmer, i just wanted to check out what i can do, maybe teach myself some global stuff along the way while doing it on a fun way (using the game as end point) and when i can create something usefull that is currently bugged and i can work it out on my own speed i can apply the patch aswel

[Hypnos]

1 hour ago, Kilydan said:

nice guide, maybe a guide on how to setup a actual local server would help aswell, i once tried it but couldnt even figure that part out while i would love to try some stuff out / create some small updates if im able to

For the moment i havent planned it. Dunno if you tryed trinity guide, its really easy: https://trinitycore.atlassian.net/wiki/

Beside you have a lot of stuffs there for learning to fix things.

Im porting my guides of spanish forum to this one, so you will can try to fix a little things soon.

As Tweedy said there are compiled servers (its named repacks) and its more simple to run it or you can compile a trinity server starting since 0. The different is that with repacks you only can fix things with sql (repacks dont include the core) but if you compile one, you will can fix everything there with C++ or sql.

The local server is usefull for testing patches and for learning but if you only want to help firestorm it isnt need really.

Tweedy if you like navicat, you can use the manager that you like.

PS: I can help you with building your own local server if you want kilydan.

[Avoel]

Just now, Hypnos said:

For the moment i havent planned it. Dunno if you tryed trinity guide, its really easy: https://trinitycore.atlassian.net/wiki/

Beside you have a lot of stuffs there for learning to fix things.

Im porting my guides of spanish forum to this one, so you will can try to fix a little things soon.

As Tweedy said there are compiled servers (its named repacks) and its more simple to run it or you can compile a trinity server starting since 0. The different is that with repacks you only can fix things with sql (repacks dont include the core) but if you compile one, you will can fix everything there with C++ or sql.

The local server is usefull for testing patches and for learning but if you only want to help firestorm it isnt need really.

Tweedy if you like navicat, you can use the manager that you like.

PS: I can help you with building your own local server if you want kilydan.

Thanks for the Reply! Ye , cause i've used navicat a long time ago first on Metin2 private Server (lol) now im using it also for World of Warcraft  never tryd any other software

[Crackbones]

Best to use is Heidi, much easier... Trust me dude download Heidi rather as it is also better for beginners. Also dude if you are still battling to compile a server and are interested I will guide you. It is very easy.. Also very important note to beginners using VS 14, remember to also download the c++ language into it for it to support or result will be a failure when configuring with CMake