Vanilla wow item Database

classicdb/database: Classic DB is a content database for
March 19, 2019 – 12:54 pm
Blog Archives - lucidmaster

A content database for mangos-classic, and World of Warcraft Client Patch 1.12 - Drums of War. It is compatible with client 1.12.1 (build 5875), 1.12.2 (build 6005) and 1.12.3 (build 6141).

Classic DB is released under the GPL v3. The file (LICENSE.mdown) must be a part of any redistributable packages made from this software. No licenses should be removed from this software if you are making redistributable copies.

Compatibility

The Classic DB database is compatible with mangos-classic rev z2685 and newer.

Getting started

The basic principle behind this database repository is to have a single SQL file holding every table in the database. When something is changed into the database the modification is done by adding a small SQL update files placed into the updates directory. Every time an user (that would be you) wishes to change something into the database, he/she have to create and add the right SQL file. This helps tracking what changes are made, when and where.

Installation

Classic DB is the main content database: mangos where the world is defined with creatures, items, objects, quests, etc.

It must be applied after creating the mangos database from your mangos core distribution, usually mangos-classic from CMaNGOS project.

If you used the default values when installing your mangos core, simply run into a bash compatible shell (like Bash Git for Windows) the following command ./InstallFullDB.sh.

It will create a single file InstallFullDB.config.

If you have modified the default values for connecting to the database, in order to use this database repository, you will have to open InstallFullDB.config, and edit in the desired database, username and password according to how you have configured your MySQL server. Default values for mangos core are username:mangos, password:mangos, database:mangos. For security reasons, it is strongly adviced to use different username and password.

Once you have the desired database user and rights configured in MySQL, you may run again the ./InstallFullDB.sh command to load the individual data tables into your database, populate them and apply all updates since the last milestone.

Contributing

You are welcome to contribute to this database project. There are three main ways of contributing. Choose the one fitting your skills.

  1. Open a ticket/issue on the database issue tracker on GitHub. Describe the issue as accurately as possible, how things currently are, how things should be instead. Example: "NPC Mighty Skeleton in Western Plaguelands does not wield its weapon. It should have a sword.". You can improve your issue report by giving the ID/entry of the creature, object, quest, spell... it helps developers to find quickly where is the problem. In-game GM commands like .guid.lookup quest (or creature, spell, object).gobject near (or target) are great to get those informations
  2. If you have SQL knowledge you can also open a ticket/issue and provide a fix, even partial. To help you to understand the DB structure, have a look a the

Sometimes it is difficult to install not only the program, but also household appliances, you cannot do without specialists. It will not be an exaggeration to say that in every kitchen, regardless of its fullness with household appliances, the main and central place remains behind rinnai hood. In modern houses and apartments, the presence of a hood above the hob has long become commonplace. In addition to a purely design function, the hood also plays the role of a “cleaner”. Installation of a modern kitchen hood gives you the opportunity to breathe air, devoid of the tart aftertaste of different dishes. (Image by Connoman from Pixabay)

There is a huge number of sites on the Internet aimed at attracting gamers. Therefore, it is quite difficult to create something new, and to attract visitors. You need to be the first in the search so that the number of people interested in your site increases. Best SEO company in Malaysia will help you to achieve such a goal. Google in its recommendations says that you do not need to be puzzled by the internal structure of the site, you should think about how visitors will read it. Search engines have started to look at sites from the point of view of the visitor and increasingly come closer to the human understanding of content (Photo by Fredrick Tendong on Unsplash).

Source: github.com
Related Posts