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!
-
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 ;)
-
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
-
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
-
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...
-
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...
-
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
-
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?
-
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?
Who is online
Users browsing this forum: No registered users and 9 guests