database tables in mangos

[gambit2312]

I have a question al the tables in mangos beginning with locales, so locales_achievement_reward, locales_creature etc etc....... are empty is this normal or should it also be filled with information..........? en another question for example the starving mountain lion in hillsbrad foothills is on this server invissible while he was vissible on the official server, i searched it in database and can't find it in database, and how is it easely changed from invissible to visible

greets Marcel

[antz]

Hi,

By default all the _localised tabled are blank.

If you have seen my other posts on the forum here, I am attempting to pull together a comprehensive translation pack for Mangos

- I currently have a fairly complete library of German, Franch and Spanish translations and once Rel20 is released i'll be working on getting these complete ready for Rel21.

If you try....

SELECT * FROM creature_template WHERE NAME LIKE 'starving mountain lion';

this returns results for me.

[Olion]

The creature is set to invisible usually by adding a respective aura (let alone phasing system and others for now). This is possible using DB tables:

• creature_template_addon (`entry` field is equal to creature_template.entry)
  
• creature_addon (`guid` field is equal to any creature.guid where creature.id is equal to creature_template.entry)
  
• scripts. You should check the fields `AIName` and `ScriptName` in the `creature_template` table for the lion. No more than one of these should be set. If `AIName` is 'EventAI' then you should search `creature_ai_scripts` table finding rows where `creature_id` is equal to creature_template.entry. In our case this is the cause, and though the spell "Prowl" 24450 used here seems incorrect, the mechanic is probably OK. The mobs are prowling (which is naturally for cat type mobs). You'll see their prowling freely in case of great char/mob level difference. By the way, due to the wrong EventAI script, the lions lose prowling after evade (ie after winning a combat).
  

For the tables docs, open https://www.getmangos.eu/wiki.php then select Reference Information -> DB -> Mangos -> MangosTwo and there the required table. The creature_ai_scripts table is better described for Zero.

[gambit2312]

First i want you all for trying to explain it to me, but im having problems with finding this in the database, i can't find the Starving Mountain Lion, it id must be 2384 that i know for sure, but i can't find it in the tables you mentioned

thx for ur help i apretiate it verry much greets marcel

[Olion]

I have installed Two DB just few days ago, and it's ok, the mob is described as it should be. If you see the mob on your server copy, then the table is ok and something is wrong with your "search in DB". But what? The example above is good for phpMyAdmin, for SQL standard it should end by semicolon - ; Any SQL client starting with mysql.exe from SQL server install will do.

[gambit2312]

i,m using navicad premium, and mysql55

[antz]

Which mangos database are you using ?

[Olion]

Well, here is Navicat screen for such selection. Open connection - open database - open table - Filter Wizard - set required query parameters and Ctrl-R.

[gambit2312]

thx Olion and ants thats the trick i learned something, and Olion, thx for the screen helped me allot, but why did it show up now, when i entered the id 2384 nothing shows up

thx guys greets Marcel

and maybe you can help me with this how can i make that creater visible?

[Olion]

The template tables do not contain `id` field. But the query builder will not allow to use this field in case of the field not present in the table. So, maybe you did use `creature` table instead of `creature_template`. The correct condition will be "entry is equal to 2384".

Anyway, you're welcome to ask.

[gambit2312]

yes was my mistake, but how can i make the creature vissible?

[gambit2312]

yes was may mistake, but how can i make him vissible what id or something , is starving mountain lion on youre ZERO sever also invissible? i know when i played on oficial server from blizzard that he was visible, so how can i make him visible?

[Olion]

The Prowl spell is cast upon the mob via EventAI. If you wish to turn this off, change creature_template.AIName for the mob from 'EventAI' to the empty string. It would be advisable also to remove the line from creature_ai_scripts where creature_id=(entry of the mob).

[gambit2312]

Yessssssss it work many thx Olion youre a good guy im glad you helped me with that , maybe you can help me in the future with other things............and again many many thx

Greets Marcel