Search the Community

Showing results for tags 'patch'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General Information
    • Announcements
    • Information
    • Rules & Policies
    • Recruitment
    • Events
  • Development
    • Development News
    • Changelogs
    • Development Feedback
    • Learning Section
    • Submit a patch
  • Community
    • Tutorials & Guides
    • Roleplay
    • Resources
    • Off Topic
    • Class Forums
    • Localized Forums
  • Realms' Forum
    • Valdrakken
    • Oribos
    • Sethraliss
    • Sylvanas
    • Gul'dan
    • Garrosh
  • Support
    • Technical support
    • Suggestions
    • Forum's Archive
  • Firestorm Staff

Forms

  • Report a Staff Member
    • Your character name
    • Staff member who you're reporting
    • Where did the incident take place on
    • Date of incident
    • Description & Evidence
  • Report a Staff Member (Regular)
    • Your character name
    • Staff member who you're reporting
    • Where did the incident take place on
    • Date of incident
    • Description & Evidence
  • Discord ban appeal
    • Discord tag
    • Reason of the suspension
    • Date
    • Description & Evidence

Found 2 results

  1. Hello, maybe its a dumb question, but i dont realy get into it.. The Gameversion is 10.1.7 right? The game it self runs a way before that patch maybe 10.0.1 - 10.0.5 or am i wrong? So what kind of addon version should be taken, to get the best out of it, without lua errors, or any other error messages popping off and annoying messages about versions and so on
  2. [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.