How to access creature_template and such?

[TypicalPlayer82692]

OK, so I have resorted to posting a thread about this since I cannot figure this out myself from the various videos and guides I have seen so far. How do I edit those .frm files??? I have heidisql, but don't know how to use it to open those kinds of files. I think I have to have a database imported, but how with my current mopcore emulator? Can somebody assist me with instructions that I understand? If there are any questions you want me to answer about this, please let me know.

[Veritable]

you don't open the .frm files, you use Heidisql to edit the table data itself.

I don't have it myself, but in mine, I can see the "World" database.

Inside there, there is a table called creature_template

it contains all the data, and you should be able to visually edit each creature, add new ones whatever you want.

[TypicalPlayer82692]

Oh, I don't see my Creature Template and such files in my databases, do I have to manually add them? And actually yeah,, How do I add my "World" folder Database?

[brotalnia]

1. Start the MySQL server.


2. Login with your username and password. Default should be "root" and no password.


3. Create a new empty database.


4. Import the world database into it.

[Veritable]

yup. On a side note, most of this information will be available when you download the database pack for whatever you are trying to run. For example, running the TrinityCore, there is a TrinityCore DB that includes all the .sql files you need (with instructions) on how to import items, characters, world and such into your database.

Databases Installation - TrinityCore - TrinityCore Collaboration Platform

is part of their setup guide for TrinityCore.

[TypicalPlayer82692]

Actually, I read this in the instructions: "From the unpacked 7z folder copy the SQL files that start with "TDB_world_" and "TDB_hotfixes_" (6.x branch only) to the directory where your worldserver binary is"

Where and what is a worldserver bindary?

And my permissions make it so that I cannot make a new database... Don't know how to edit that

[brotalnia]

Worldserver binary means the server core which is an .exe file (a program you can run). If you are using XAMPP for MySQL, you can start Apache and create a new account with full permissions through phpMyAdmin.

I recommend that you go ahead and look for a 1-click repack that doesn't require you to setup anything on your own, as you seem to be completely clueless. If you want to play wotlk, you can try this one.

[TypicalPlayer82692]

I have spent about 10 goddamn hours of my life working on this bullshit. Every guide doesn't even seem like it's even speaking English, every video is outdated by 2 or more goddamn years, I have a new error every 10 ****ing minutes, and the forums have helped me to no avail. I officially give up on this goddamn bullshit. Damn SQL to HELL!

[stoneharry]

I have spent about 10 goddamn hours of my life working on this bullshit. Every guide doesn't even seem like it's even speaking English, every video is outdated by 2 or more goddamn years, I have a new error every 10 ****ing minutes, and the forums have helped me to no avail. I officially give up on this goddamn bullshit. Damn SQL to HELL!

A MySQL server is a relational database implementation that provides a great many features. You have to store your server data somewhere. What about a text file? Searching for a specific row, inserting and deleting rows, reordering... all these operations would be extremely slow. So you use a database. Or a schema as they're sometimes called (Oracle). This allows you to abstract the layer of implementation away so you instead look at the data in a logical way - with databases, tables, triggers, stored procedures, functions, and other database concepts. The bit you are worried about is the tables and data.

So the server runs on a world, authentication and character database. These can be in the same databases or the tables separated out into different ones as is the traditional style. Within these databases are the tables, which you can query and view. You can operate on your data in sets. Discrete mathematics. Some of the basic examples:

SELECT * FROM `creature_template` WHERE `entry` < '1000' AND `entry` >= '500';

SELECT COUNT(*) FROM `characters` WHERE `level` = 80 ORDER BY `last_login`;

DELETE FROM `creature_spawns` WHERE `entry` IN (
    SELECT `entry` FROM `creature_template` WHERE `BaseLevel` > '30'
);

And so on. You can find guides on how to use MySQL and the syntax online. You have to be careful with your queries - if you leave the data in a bad state so that the software (the emulator) cannot interpret it correctly it will result in breaking features or corruption. This is why backups are important, and you can logically backup your database into a set of queries very easily.

You can run multiple servers on a computer as long as they all use unique ports. This is why when you edit your configuration files for the emulator you have to set the MySQL server host (which computer it is hosted on), the port (as you can run multiple instances), and the credentials.

The problem with repacks is they are destined to have issues with them. I recommend compiling and setting it up yourself. It's quite challenging if you are not computer savvy, but well worth it. We can help with any stage you get stuck with as well as support options available on the emulators forums usually. Here is the TrinityCore website which contains access to their Wikipedia, installation guides, forums, IRC, and so on: TrinityCore

You will import a database (the .sql files) into a new fresh database for the version of trinitycore you are on. You will have to apply any SQL updates they provide to get you up to the correct version as well. Again, we can help if you get stuck at any stage.

You will be able to do this if you set up your own MySQL server, which is very simple to do these days as long as you have administrator privileges on your computer. When you setup your MySQL server you setup a 'root' user that has full privileges but usually can only be connected to from localhost.

You could even host it in a linux virtual machine, the emulator is even easier to setup on there. Type in some commands and your off.