Help w/ Spanish, Japanese, Chinese, French!

Moderators: cataclysm80, hammr7, l0qii, Apocalypse2K, berkumps, dragsamou, mystical_tutor, pp

Mr.C
Librarities Legend
Posts: 418
Joined: Tue Mar 02, 2004 10:36 pm
Location: Winnipeg, Canada

Post by Mr.C » Fri Jul 15, 2005 1:25 pm

agzz wrote:What i did was after getting everything into an MS access database i made a querry that sorted out every portugese name in there more than ones. from that selection i made a new querry sorting out every english name only present ones in that first selection. (then the other way around)
So if there are a card A available in 2 sets called B and two sets where its callec C - it will not show up.
There is probibly a simple comand to fix that but i dont know it.
Yeah, and there are quite a few inconsistencies, such as the different Stone Rain's (lots of them) and Deathgrip/Death Grasp.

But, this list is very cool. Thanks!

User avatar
agzz
Legendary Terese Nielsen Fan
Posts: 354
Joined: Tue Aug 05, 2003 12:44 am
Location: Västerås, Sweden

Post by agzz » Fri Jul 15, 2005 1:45 pm

hmm, the Stone Rains are all in there as Chuva de Pedras.

The deathgrip/death grasp was my falut it didnt make the list. I took it off as a error in the database since it has two spellings of deathgrip in portugese and the scanns indicated that was an error. Didnt realise there also was another reason it indicated a 'hit'.
im adding it to the list above, thanks.

Mr.C
Librarities Legend
Posts: 418
Joined: Tue Mar 02, 2004 10:36 pm
Location: Winnipeg, Canada

Post by Mr.C » Fri Jul 15, 2005 6:38 pm

agzz wrote:hmm, the Stone Rains are all in there as Chuva de Pedras.

The deathgrip/death grasp was my falut it didnt make the list. I took it off as a error in the database since it has two spellings of deathgrip in portugese and the scanns indicated that was an error. Didnt realise there also was another reason it indicated a 'hit'.
im adding it to the list above, thanks.
http://irpg.galacnode.com/mtg

Check the portuguese section, therer you can see what i meant with inconsistencies ;)

User avatar
squt
Legendary Misprint Error Collector
Posts: 482
Joined: Mon Dec 01, 2003 9:51 pm
Location: Seattle, WA
Contact:

Post by squt » Sat Jul 16, 2005 5:24 pm

I checked over this list and have a few comments:

Isn't Aranha Portuguese for "Spider"? If PR Snag isn't a typo on the card list, this is probably a HUGE misprint.

Same goes for "Po Ao Po" - certainly "Ashes to Ashes" can't also mean "Dust to Dust" in Portuguese.

Agzz - I am currently sorting a collection of 50,000 non-english cards, and I'd be happy to send you extras of these that I find for all of your hard work (but be patient)!

Now all we need is to find similar and reliable databases for Spanish, German, French...and maybe even Japanese and Chinese. After I sort these cards, I plan on comparing Chinese and Japanese cards to known duplicate names (for example, I know Mobilize in Portal and Mobilization in Onslaught have the same name in Japanese and German, so I will check to see if they are the same in Chinese if I can ever find a Chinese Portal Mobilize - but this is just an example...).


squt

User avatar
dragsamou
Administrator
Posts: 5806
Joined: Sat Aug 02, 2003 1:17 pm
Location: Paris

Post by dragsamou » Sat Jul 16, 2005 5:38 pm

squt wrote:I if I can ever find a Chinese Portal Mobilize -

squt
Hi Mark.
Just ask me :wink:
Want/Have Lists.
viewtopic.php?f=8&t=8903
viewtopic.php?f=7&t=1515
I Love you Dad.R.I.P.

User avatar
agzz
Legendary Terese Nielsen Fan
Posts: 354
Joined: Tue Aug 05, 2003 12:44 am
Location: Västerås, Sweden

Post by agzz » Sat Jul 16, 2005 6:07 pm

Squt>> Snag is indeed a error in the database. it should be Protuberância.
and Protuberância is in database as Slit Crawler wich is really Rastejador da Obstrução. The three cards are all after eachother i the set. simply a error in making the database.

and Ashes to Ashes should be Cinzas às Cinzas as per scanns.

I am, erm was, currently working on German. However thunder and lightning caused my comp to restart.. next time i'll use the save function.. ](*,)
after the weekends or so.

Mr.C
Librarities Legend
Posts: 418
Joined: Tue Mar 02, 2004 10:36 pm
Location: Winnipeg, Canada

Post by Mr.C » Sat Jul 16, 2005 9:35 pm

squt wrote:I checked over this list and have a few comments:

Isn't Aranha Portuguese for "Spider"? If PR Snag isn't a typo on the card list, this is probably a HUGE misprint.

Same goes for "Po Ao Po" - certainly "Ashes to Ashes" can't also mean "Dust to Dust" in Portuguese.
That's an error in the database, Mark. No big f-ing misprint there. ;)

Both of them.

Now, i was going to check these things out today, but, my little sister was baptised today :D :D :D

Since i am her godfather, too, i didnt have time, maybe later on...

User avatar
agzz
Legendary Terese Nielsen Fan
Posts: 354
Joined: Tue Aug 05, 2003 12:44 am
Location: Västerås, Sweden

Post by agzz » Mon Jul 18, 2005 12:28 pm

OK, this database has been no fun working with. Seems much of it is wrong.

I am sure many of these will prove to be spelling mistakes or plain out errors.

I sorted some out where I found 15 or so cards in IA shifted one place in the list. Also quite a lot of the 3E does not match WotCs lists for german revised, but i dont know if there was changes from BB to WB?

If you spot errors DO lmk so I can fix the database for futue use.

I think I have cleaned up the 2eng/1ger part of the list and some of the 1eng/2ger part but it took me quite a while and right now I dont have time to work more on the list and I dont know where to turn to confirm.
I'd really appreciate if anyone would check up on the list. Any german member should probibly be able to exlude some rather quick just by reading through the list.


One Englsih -> Two German

AEther Storm 5E Äthersturm
AEther Storm HL AEthersturm

Agonizing Memories 7E Bedrückende Erinnerung
Agonizing Memories 6E/WL Bedrückende Erinnerungen

Arcane Laboratory 7E Zauberwerkstadt
Arcane Laboratory US Zauberwerkstatt

Aspect of Wolf 3E Wolfsrudel
Aspect of Wolf 4E/5E Wolfsblut

Balance 3E Ausgleich
Balance 4E Balance

Blessed Reversal P1 Heilige Umkehr
Blessed Reversal 7E/8E/UL Gesegnete Wendung

Bog Wraith 3E Sumpfgeist
Bog Wraith (the rest) Todlose Moorleiche

Burrowing 3E Verschanzen
Burrowing 4E/6E Wege des Maulwurfs

Circle of Protection: Black 3E Schwarzer Schutzkreis
Circle of Protection: Black (the rest) Schutzkreis gegen Schwarz
-same goes for all CoPs

Conquer 6E Erobern
Conquer 5E/IA Eroberung

Conservator 3E Schutzschild
Conservator 4E Conservator

Craw Wurm 3E Lindwurm
Craw Wurm 4E/5E/8E Tatzelwurm

Creature Bond 3E Kreaturenbündnis
Creature Bond 4E Kreaturenbindung

Crumble 3E Zerbröckeln
Crumble 4E/5E Zahn der Zeit

Delusions of Mediocrity 7E Mittelmäßigkeitswahn
Delusions of Mediocrity UL Mittelmäßigkeits-wahn

Dense Foliage 6E Dichter Bewuchs
Dense Foliage WL Dichte Belaubung

Elven Riders 6E Elfische Reiter
Elven Riders 4E/5E/ON Elfenreiter

Elvish Champion 7E Champion der Elfen
Elvish Champion IN/8E Elfischer Champion

Energy Flux 3E Energiefluß
Energy Flux 4E/5E/MME Energiefluktuation

Feroz's Ban 5E Feroz Bann
Feroz's Ban 7E/HL Feroz' Bann

Final Fortune 7E Letze Rettung
Final Fortune 6E/MR Letzte Rettung

Flight 3E Flug
Flight (rest) Flugfähigkeit

Force of Nature 3E Naturgewalt
Force of Nature 4E/5E Naturgewalten

Gaea's Liege 3E Gäas Vasall
Gaea's Liege 4E Gaeas Vasall

Gallantry OD Heldenhafte Tat
Gallantry TE Edelmut

Giant Octopus 7E Riesenoktopus
Giant Octopus 8E/P1 Riesenkrake

Glasses of Urza 3E Brille des Urza
Glasses of Urza 4E/5E/6E Urzas Brille

Goblin Elite Infantry 6E Elite-Infanterie der Goblins
Goblin Elite Infantry 7E/MR Elite-Infantrie der Goblins

Goblin Glider 7E Goblinsegler
Goblin Glider 8E/P2 Goblin Glider

Gravebane Zombie 6E Verfluchte Zombies
Gravebane Zombie MR Verfluchter Zombie

Harmattan Efreet 6E Harmattan-Ifrit
Harmattan Efreet MR Harmattan Ifrit

Infantry Veteran VI Erfahrener Fußsoldat
Infantry Veteran 6E Erfahrender Fußsoldat

Ironroot Treefolk 5E Baumvolk der Eisenwurzler
Ironroot Treefolk 3E Ehernwurzelbaumvolk

Jayemdae Tome 6E Ketos Zauberbuch
Jayemdae Tome (rest) Ketos' Zauberbuch

Karplusan Forest IA Karplusianischer Wald
Karplusan Forest 5E/6E/7E Karplusanischer Wald

Kjeldoran Royal Guard 7E Kjeldonische Hofgarde
Kjeldoran Royal Guard IA/5E/6E Kjeldoranische Hofgarde

Living Lands 3E Lebendes Land
Living Lands 4E/5E/6E Erwachen der Wälder

Mana Flare 3E Manaregen
Mana Flare 4E/5E Manasegen

Meekstone 3E Sanftstein
Meekstone 6E/7E Stein der Sanftmut
Meekstone 4E/5E Stein des Sanftmuts

Memory Lapse 7E Gedächnislücke
Memory Lapse 5E/6E/MR/HL Gedächtnislücke

Mesa Falcon 6E Mesafalke
Mesa Falcon 5E/HL Mesafalken

Monss Goblin Raiders 5E Mons's plündernde Goblins
Monss Goblin Raiders 3E/4E Mons' plündernde Goblins

Monstrous Growth 8E/P2 Monstrous Growth
Monstrous Growth 7E/P1 Unheimliches Wachstum

Moss Diamond 6E Mossdiamant
Moss Diamond MR/7E MoOsdiamant

Mystic Compass 6E Mystischer Kompass
Mystic Compass AL Geheimnisvoller Kompaß

Natural Spring TE Natürliche Quelle
Natural Spring P1 Heilquelle

Northern Paladin 7E Paladin des Nordens
Northern Paladin 3E/4E Nordischer Paladin

Obsianus Golem 3E Schwarzer Homunkulus
Obsianus Golem 4E/6E Obsidian-Golem

Orcish Artillery 6E Ork-Artillery
Orcish Artillery 3E Orkanier-Artillerie

Orcish Oriflamme 3E Orkanier-Standarte
Orcish Oriflamme 4E-7E Standarte der Orks

Pentagram of the Ages 6E Pentagram der Zeitalter
Pentagram of the Ages 5E/IA Pentagramm der Zeitalter

Personal Incarnation 3E Persönliche Inkarnation
Personal Incarnation 4E/5E Eigene Inkarnation

Phantasmal Forces 3E Geisterkräfte
Phantasmal Forces 4E/5E Traumkrieger

Primal Clay 3E Urlehm
Primal Clay 4E/5E/6E Urlehmgestalt

Pyrotechnics 8E Pyrotechnik'
Pyrotechnics 4-7E Pyrotechnik

Raise Dead 8E/P2 Raise Dead
Raise Dead (rest) Auferstehung der Toten

Reckless Spite TE Unvorsichtiger Trotz
Reckless Spite IN Skrupelloser Wahn

Redwood Treefolk WL Baumvolk der Rotholzer
Redwood Treefolk P1/6E/7E Baumvolk der Rotholzigen

Relentless Assault 7E Unnachgiebuger Ansturm
Relentless Assault VI/6E/8E Unnachgiebiger Ansturm
Relentless Assault P2 Relentless Assault

Remove Soul 8E Seelenvernichtung'
Remove Soul 5-7E Seelenvernichtung

Reprisal 6E Vergeltung
Reprisal AL/7E Revolte

Reprocess 7E Wiederverwerter
Reprocess US Wiederverwertung

Rod of Ruin 3E Stab der Verderbnis
Rod of Ruin 4-8E Stab des Verderbens

Ruins of Trokair 6E Ruins of Trokair
Ruins of Trokair 5E Ruinen von Trokair

Scaled Wurm 6E Schuppiger Wurm
Scaled Wurm IA/5E Schuppenwurm

Scrivener OD Stadtschreiber
Scrivener EX Schreibgelehrter

Serra Paladin HL Serras Paladin
Serra Paladin 5E Serra-Paladin

Shivan Dragon 3E Schiwanischer Drache
Shivan Dragon 4-8E Shivan-Drache

Sky Diamond 6E Himmeldiamant
Sky Diamond MR/7E Himmelsdiamant

Spellbook 7E Zauberbuch
Spellbook EX/8E Zauberspruch

Spined Wurm P1 Buckelwurm
Spined Wurm SH/7E/8E Gekrümmter Wurm

Starlight P1 Sternenglanz
Starlight 7E Sternenlicht

Sunglasses of Urza 3E Sonnenbrille des Urza
Sunglasses of Urza 4E Urzas Sonnenbrille

Taunting Elf ON Höhnischer Elf
Taunting Elf UD Hönischer Elf

Tawnos's Weaponry 5E Tawnos' Waffen
Tawnos's Weaponry 4E Tawno's Waffen

Thicket Basilisk 3E Heckenechse
Thicket Basilisk 4-6E Buschbasilisk

Tolarian Winds US Tolarianische Stürme
Tolarian Winds 7E Tolarische Stürme

Unstable Mutation 3E Unkontrollierbare Mutation
Unstable Mutation 4E/5E Instabile Mutation

Uthden Troll 3E Uttenischer Troll
Uthden Troll 4E Uthden Troll

Wall of Water 3E Wassermauer
Wall of Water 4E Wasserwand

Vitalize 6E Beleben
Vitalize WL Erfrischung

Volcanic Hammer P2/8E Volcanic Hammer
Volcanic Hammer P1/7E Vulkanhammer

Yavimaya Enchantress 7E Yavimayablütenzauberin
Yavimaya Enchantress US/8E Yawimayablüten-zauberin


Tow English -> One German

Dominieren NE Dominate
Dominieren MI Domineer

Erfrischung WL Vitalize
Erfrischung OD Refresh

Erleuchtung MR Illumination
Erleuchtung AP Illuminate

Feuersturm P1 Fire Tempest
Feuersturm WL Firestorm

Gekrümmter Wurm MR Warping Wurm
Gekrümmter Wurm 7E/8E/SH Spined Wurm

Gezackter Blitz DS Barbed Lightning
Gezackter Blitz US Jagged Lightning

Lebenshauch IA Touch of Vitae
Lebenshauch 7E/P1 Breath of Life

Leuchtender Engel TE Angelic Protector
Leuchtender Engel MI Luminous Angel

Mobilisierung P1 Mobilize
Mobilisierung ON Mobilization

Vergeltung HL Retribution
Vergeltung 6E Reprisal

Widerruf US Recantation
Widerruf MM Renounce

Wucherndes Wachstum SH Overgrowth
Wucherndes Wachstum (all) Rampant Growth

Mr.C
Librarities Legend
Posts: 418
Joined: Tue Mar 02, 2004 10:36 pm
Location: Winnipeg, Canada

Post by Mr.C » Mon Jul 18, 2005 3:54 pm

omg. That's a lot in german...

agzz: Tell me, can you send me the database with all the names in portuguese/english? Or, better yet, just list me the cards that were printed in more than one set in portuguese, so i can check, since the database is inconsistent...

User avatar
squt
Legendary Misprint Error Collector
Posts: 482
Joined: Mon Dec 01, 2003 9:51 pm
Location: Seattle, WA
Contact:

Post by squt » Mon Jul 18, 2005 5:39 pm

There's a kid named Eugin Bruhin that made a pretty amazing database on the german name changes. He did it several years ago, so I am sure that you have discovered some new ones here. He did a good job of documenting the change of names between WB and BB - there were A LOT.
You can download the excel file here:

http://members.tripod.com/~squt/error5.html

it's at the bottom of the page.

squt

Guest

Post by Guest » Mon Jul 18, 2005 7:24 pm

proof that anyone who doesn't speak english is dumb ](*,)

User avatar
dry cereal
Legendary Part of a Complete Breakfast
Posts: 1016
Joined: Sun Aug 10, 2003 12:31 am
Location: New York CitY!?
Contact:

Post by dry cereal » Mon Jul 18, 2005 8:29 pm

omg, who is that idiot?

Mr.C
Librarities Legend
Posts: 418
Joined: Tue Mar 02, 2004 10:36 pm
Location: Winnipeg, Canada

Post by Mr.C » Mon Jul 18, 2005 9:08 pm

dry cereal wrote:omg, who is that idiot?
Good question, ben.

IP Check?

User avatar
dry cereal
Legendary Part of a Complete Breakfast
Posts: 1016
Joined: Sun Aug 10, 2003 12:31 am
Location: New York CitY!?
Contact:

Post by dry cereal » Mon Jul 18, 2005 9:10 pm

OMG!! the posts are coming from INSIDE THE HOUSE!!!

Mr.C
Librarities Legend
Posts: 418
Joined: Tue Mar 02, 2004 10:36 pm
Location: Winnipeg, Canada

Post by Mr.C » Mon Jul 18, 2005 9:38 pm

dry cereal wrote:OMG!! the posts are coming from INSIDE THE HOUSE!!!
Your brother, maybe? Your alter-ego?

Back on topic: agzz, as soon as you can,. send me the database with the portuguese names, k?

Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests