Necesita cliente para 9.2.7 45745

Creador del tema
Busco todo internet pero no lo visto.
Will server work with english version actually?
 
Creador del tema
Yes one more thing - are there bots to populate servr for this kind of project?
 
Creador del tema
As I am a WEB developer used to find out why there are duplicates: they are tons!
Have any idea to get rid of them? Maybe there are clearer database?

12312313123.webp
 
Yes one more thing - are there bots to populate servr for this kind of project?
Di you compile your own core or you are using a Repack? Because the only way to integrate Bots, you have to add them to the core before compile.

As I am a WEB developer used to find out why there are duplicates: they are tons!
Have any idea to get rid of them? Maybe there are clearer database?

View attachment 3784
I don't think those are duplicate, those are locations for the creatures.
 
Creador del tema
Di you compile your own core or you are using a Repack? Because the only way to integrate Bots, you have to add them to the core before compile.


I don't think those are duplicate, those are locations for the creatures.
Yes.
The SQL command is to show how much occurences of the NPC/MOB is in the same location and as you can see there are tons of 2, and even 3 npcs at the same location. That is why there are duplicates of them everywhere.

Well i got this server from this source and people in comments saying about this problem:

Going to sleep soon but tomorrow ..
I think it is not a problem to write command to delete duplicates from creature table where they are in same or close location with the same name and description.
 
As I am a WEB developer used to find out why there are duplicates: they are tons!
Have any idea to get rid of them? Maybe there are clearer database?

View attachment 3784
I didn't get clear about which duplicates you're talking, but if it refers to ID in "creature" table may have duplicates of creature ID's, but it is because there are pools for creatures that populate the world. In this case, as there are many cratures in different places with the same ID, the key for every creature in those pools is GUID.

There shouldn't be duplicated GUID's in creature table, but for creature ID's, duplicates are normal.
The place where ID shouldn´t have duplicates is the table "creature_template".

Then, "creature_template" is the database that records the creatures (including NPC) that exists in the world, and "creature" is the database that contains the data about where should be every creature in the world.

As an advice, take a look to this page: https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130075/Databases
that should give you a clearer idea about the function and structure of every table in database.

I hope that may be useful.
 
The SQL command is to show how much occurences of the NPC/MOB is in the same location and as you can see there are tons of 2, and even 3 npcs at the same location. That is why there are duplicates of them everywhere.

Well i got this server from this source and people in comments saying about this problem:

Going to sleep soon but tomorrow ..
I think it is not a problem to write command to delete duplicates from creature table where they are in same or close location with the same name and description.
Ok! I guess that those duplicated positions are meant to have available creatures in highly populated realms, where the respawn time isn´t enough because of frequent farmers. Something similar to entities (game objects like herbs, veins...), that share locations and may be also overlapped.
 
Hello, for getting duplicates creatures you need to use more conditions than x and y coords only. There are a lot of creatures spawned in the same x and y position and it isnt a duplicated.
You neeed to use x,y,z and phase for getting the real duplicated creatures because there are spawns in the same position need for phased quests or events,for example.
About clients for different language,that doesnt exists. I will do a video for explaining it correctly so everyone knows it.
All clients can be used for any language changing language and sound in the config.wtf file of client. What everything is in your language ingame depends in server traductions in databases,not in the client.
 
Creador del tema
What I really want to know is where this database comeing from? Where and how developers get that data?
 
What I really want to know is where this database comeing from? Where and how developers get that data?
I must say that I've explored only WOTLK (3.3.5a) and systems is not my knowledge area, but, as far as I've seen, the source of database could be taken from the client MPQ files.
This site: https://wowdev.wiki/Main_Page could give you a better clue.
I know that there are tools used for creating patches, and the way they work is extracting the data from mpq files to other formats. Somewhere in this forum should be a thread with tools like this. Another way to find them is a web search on how to create custom patches.

What I've found is that the structure of TC database (or another projects, like mangos) is different from mpq database but the data is the same. If I´m wrong, I´d be glad to know that.
 
winrar is telling me i need to put a password in for the repack, the password is not 123456, i have tried everything please help
 
Back
Top