cmangos / wotlk-db

A content database for mangos-wotlk, and World of Warcraft Client Patch 3.3.5
GNU General Public License v3.0
109 stars 96 forks source link

Locales name_loc8_creatures #1238

Closed rmzV closed 7 months ago

rmzV commented 8 months ago

locales_creature_russian.csv

Generated based on "creature_template" entry and sourced from wowhead https://www.wowhead.com/wotlk/ru/npc=entry

do i need to reformat it as "-- Table locales_creature

INSERT INTO locales_creature (entry, name_loc1, name_loc2, name_loc3, name_loc4, name_loc5, name_loc6, name_loc7, name_loc8, subname_loc1, subname_loc2, subname_loc3, subname_loc4, subname_loc5, subname_loc6, subname_loc7, subname_loc8) VALUES "??

also there is some creatures that have no translation and cant be found on wowhead. we can keep it as is or can completely remove?

NeatElves commented 8 months ago

Just for fun, I looked at this example:

Wowhead - 25,NPC, base - 25,Mithril Mechanical Dragonling,Мифриловый механический дракончик

there is too much to check and you can’t delete(

rmzV commented 8 months ago

@NeatElves can you please explain more detailed?

"https://www.wowhead.com/wotlk/npc=25"-> "NPC #25 doesn't exist. It may have been removed from the game."

and in my file i have "25,NPC," so if wowhead doesnot have info-> its labed as "NPC" if required i can clean up this rows from file and keep only exact matches like : "6,Кобольд-вредитель,"

Grz3s commented 8 months ago

Locales are not part of main goal here...Our main focus, is to have English ver completed*. So sory, but i wont help you with this.. as i never did anything with them anyway.

rmzV commented 7 months ago

locales_creature.txt REady, replace txt with sql

rmzV commented 7 months ago

@Grz3s what is ""locales_page_text"" wowhead equivalent?

Grz3s commented 7 months ago

locales_page_text = page_text = https://github.com/cmangos/issues/wiki/page_text

rmzV commented 7 months ago

ty, but i looking for something like https://www.wowhead.com/page_text=16

cant find equivalent((

Grz3s commented 7 months ago

Wowhead is the last place i would look for data .. (only if no other source available - and even then, i would search for other source, to confirm what its there). You trust it to much.. and wont acknowledge, thats not te right way. Anyway:

page_text - can be found in your clinet cache\WDB\...\pagetextcache.wdb So if you have russian client (if this is the one you want ofc) .. and you played a lot on ClassicWotlk ..Your client collected that data there. (do not bother to look at our 3.3.5 cache - koz is collected from our DB)

Look here: https://github.com/cmangos/issues/wiki/Pagetextcache

rmzV commented 7 months ago

ty for clarification. ill never played on Ru-servers, so no cache for me:(

not really trust it, but it was easiest way for scrapping... if you can point me another source, i can compare it with what i already have((

moved it here https://github.com/rmzV/wotlk-db.localization

ticket can be closed..