Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Loki (Diskussion | Beiträge) (→contributions: -Les Dorscheid) |
Loki (Diskussion | Beiträge) (- contributions_illustration) |
||
Zeile 412: | Zeile 412: | ||
===contributions_illustration=== | ===contributions_illustration=== | ||
===sources=== | ===sources=== |
Version vom 31. März 2016, 20:34 Uhr
Erweiterung
contributors_referenced_name
458 Erich Schriner -> siehe Dopplungen unten
contributors
INSERT INTO contributors(forename_first) VALUES('Liam.C'); +[ID] Petrov Miroslav
Shadowrun TCG:
+[ID] Hudson Heather +[ID] Ho Patrick +[ID] Fischer Scott M +[ID] Gregory Barry +[ID] Goleash Grant
Shadowrun Lockdown (die Namen habe ich überprüft, s.u.; Dário Coelho ist uncredited, hat aber das Lockdown Cover zusammen mit Johannes Mücke gemacht):
+[ID] Coelho Dário
Tomek Wrotek (Lockdown) -- Wrotek ein Anagram von Tworek?
HBS-Artist und zwei Autoren aus der SR Anthology (weblinks s.u.): +[ID] Ishmael Tristin
contributors_weblink
1588 https://www.facebook.com/groups/114658181901791 Heather Hudson +[ID] http://www.studiowondercabinet.com Liam C. +[ID] http://atomiccolossus.com/blacksunpress.net/liam Miroslav Petrov +[ID] https://artofmiro.carbonmade.com +[ID] http://soulsart.blogspot.com +[ID] deviantart mikeypetrov +[ID] twitter Soulsart Scott Fischer (id missing) +[ID] http://www.fischart.com http://scottmfischerevolvingeasel.blogspot.com Grant Goleasch (id missing) http://dc.wikia.com/wiki/Grant_Goleash Dário Coelho (id missing) +[ID] http://dariocoelho.com +[ID] artstation dariocoelho +[ID] deviantart dariocoelho +[ID] facebook coelhodario +[ID] twitter DarioDraws Tristin Ishmael +[ID] http://www.theycallmeishmael.com +[ID] facebook tristin.ishmael +[ID] artstation sailormonkey +[ID] twitter Tristinishmael Kathy Schad +[ID] http://www.kathyschad.de Gary Ruddell +[ID] https://en.wikipedia.org/wiki/Gary_Ruddell +[ID] http://www.wiki-aventurica.de/wiki/Gary_Ruddell +[ID] http://www.isfdb.org/cgi-bin/ea.cgi?1813 Stephan Martinière +[ID] http://www.martiniere.com +[ID] facebook smartiniere +[ID] twitter smartiniere Jan Meininghaus +[ID] www.jan-meininghaus.de +[ID] facebook jan.meininghaus +[ID] behance jan-meininghaus Fred Gambino +[ID] http://www.fredgambino.co.uk Attila Boros +[ID] http://www.isfdb.org/cgi-bin/ea.cgi?145765 Thierry Doizon +[ID] http://barontieri.com +[ID] facebook thierry.doizon +[ID] twitter barontieri +[ID] deviantart barontieri +[ID] blogspot barontieri +[ID] tumblr barontieri
contributions
Ich habe sehr viel recherchiert und mittlerweile fast alle Cover-Illustratoren der Romane vollständig. War erstaunlich viel Arbeit, ehrlich gesagt!
141 1657 text Vorwort 141 1657 text Rika 156 8092 text 434 3141 text 527 4170 text 527 7392 text 527 1657 text Methan-Bolismus 1063 1657 text Verbrannte Finger 1161 7625 illustration cover art 1366 1954 text Dämonenpack 1366 1954 text Free Fall 1366 2046 text 1366 7625 text 1400 4085 text 1582 9162 illustration cover art 1588 1954 illustration 1588 7743 illustration cover art 2292 7070 text 2292 9162 text 2820 1864 illustration cover art 2820 2172 illustration cover art 2820 8092 illustration cover art 2830 1954 text Hilft es, wenn ich sag, es tut mir leid? 2830 1954 text Spiegelfechtereien 2830 3782 text 3255 1586 text 3255 3148 text 3255 4108 text 3255 7262 text 3255 7480 text 3255 2567 text 3255 8834 text 3255 5065 text 3580 2406 illustration cover art 3580 3782 illustration cover art 3580 7262 illustration cover art 3580 8543 illustration cover art 3580 9068 illustration cover art 3622 7084 illustration cover art 3633 1954 text Striper 3633 4056 text 3633 4084 text 3633 6831 text 3633 9068 text 3793 2334 text 3793 2406 text 3793 2923 text 3793 6279 text 3793 8381 text 3805 4326 illustration cover art 3862 1954 illustration 3862 2046 illustration cover art 3898 5651 text 3898 6285 text 3898 6891 text 3898 8577 text 3898 9116 text 4174 1954 text Blindgänger 4180 761 illustration cover art 4180 1954 illustration 4302 9079 illustration cover art 4595 3148 illustration cover art 4595 5198 illustration cover art 4595 7370 illustration cover art 4595 8537 illustration cover art 4595 1617 illustration cover art 4595 9257 illustration cover art 4643 1586 illustration cover art 4643 7794 illustration cover art 4705 1865 text 5012 1657 text Lieber Arm dran 5110 1954 text Turtle im Turm 5126 3397 text 5126 4326 text 5126 4333 text 5126 7794 text 5126 9432 text 5475 549 illustration cover art 5475 2802 illustration cover art 6131 2334 illustration cover art 6131 2923 illustration cover art 6131 3397 illustration cover art 6131 4333 illustration cover art 6131 5651 illustration cover art 6231 7794 text 6244 6891 illustration cover art 6244 9116 illustration cover art 6346 1741 illustration cover art 6346 4084 illustration cover art 6346 4954 illustration cover art 6346 6831 illustration cover art 6346 7070 illustration cover art 6409 1954 illustration 6409 1954 text Grabräuber 6467 755 illustration cover art 6467 1144 illustration cover art 6467 1204 illustration cover art 6467 5176 illustration cover art 6467 6099 illustration cover art 6497 2082 illustration cover art 6497 4108 illustration cover art 6497 6279 illustration cover art 6511 7480 illustration cover art 6511 8381 illustration cover art 6705 115 illustration cover art 6705 549 illustration cover art 6705 2802 illustration cover art 6705 4279 illustration cover art 6705 4963 illustration cover art 6705 5845 illustration cover art 6705 6115 illustration cover art 6820 3141 illustration cover art 6820 7409 illustration cover art 7064 4505 illustration cover art 7064 9257 illustration cover art 7210 1741 text 7210 5955 text 7210 7409 text 7210 9812 text 7453 1954 text Whitechapel Rose 7832 1954 illustration 8055 2566 illustration cover art 8123 1741 illustration 8463 5810 text 8463 8543 text 8493 2172 text 8541 2082 text 8659 1657 text Kontakt 8770 1657 text Timing ist alles 9079 3285 illustration cover art 9079 6923 illustration cover art 9178 2172 text 9243 1369 illustration cover art 9243 1954 illustration cover art 9243 4056 illustration cover art 9243 4085 illustration cover art 9243 5952 illustration cover art 9243 5955 illustration cover art 9243 6115 illustration cover art 9243 6285 illustration cover art 9243 6545 illustration cover art 9243 6679 illustration cover art 9243 8577 illustration cover art 9243 9812 illustration cover art 9243 9964 illustration cover art 9349 6923 text 9349 7070 text 9349 9162 text 9435 1755 illustration cover art 9435 7370 illustration cover art Thierry Doizon [+id] 1369 illustration cover art [+id] 1263 illustration cover art Jim Burns [+id] 9040 illustration cover art [+id] 1755 illustration cover art [+id] 9079 illustration cover art [+id] 8810 illustration cover art Jan Meininghaus [+id] 115 illustration cover art Stephan Martinière [+id] 4667 illustration cover art [+id] 9387 illustration cover art Fred Gambino [+id] 6545 illustration cover art Mark Harrison [+id] 1657 illustration cover art Garry Ruddell [+id] 2567 illustration cover art [+id] 8834 illustration cover art [+id] 5065 illustration cover art [+id] 1263 illustration cover art Kathy Schad [+id] 6543 illustration cover art [+id] 6339 illustration cover art Catherine Beck [+id] 1657 text Vorwort Anja Brandel [+id] 1657 text Hunger Olka Hallwasz [+id] 1657 text Nachtschicht Markolf Hoffmann [+id] 1657 text In Poseidons Armen Alice Lengauer [+id] 1657 text Hunger Marion Lohe [+id] 1657 text Geisterstunde Peter Merten [+id] 1657 text Mjölnir Simon Möller [+id] 1657 text Kein großer Verlust Thomas Palmen [+id] 1657 text Rose Florian Schlüter [+id] 1657 text Holometabolie Stefan Sumser [+id] 1657 text Der Todesbote
illustrations_source
SR4 Anniversary (vgl. Anmerkungen in der Diskussion; Problemfälle) +[ID] 2891 7 center Problemfall +[ID] 2891 9 quarter-se Problemfall +[ID] 2891 10-11 Problemfall +[ID] 2891 12 half-left Problemfall +[ID] 2891 16 sixth-sw Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 184 third-lower Problemfall +[ID] 2891 227 sixth-se Problemfall +[ID] 2891 276-277 half-middle Problemfall +[ID] 2891 289 sixth-e Problemfall +[ID] 2891 289 sixth-sw Problemfall +[ID] 2891 290 sixth-nw Problemfall +[ID] 2891 290 sixth-se Problemfall +[ID] 2891 290 sixth-sw Problemfall +[ID] 2891 291 sixth-nw Problemfall +[ID] 2891 291 sixth-se Problemfall +[ID] 2891 291 sixth-sw Problemfall +[ID] 2891 292 sixth-w Problemfall +[ID] 2891 295 sixth-sw Problemfall +[ID] 2891 295 sixth-s Problemfall +[ID] 2891 295 sixth-se Problemfall +[ID] 2891 298 sixth-ne Problemfall +[ID] 2891 298 sixth-e Problemfall +[ID] 2891 298 sixth-se Problemfall +[ID] 2891 313 sixth-e Problemfall +[ID] 2891 316 third-upper Problemfall +[ID] 2891 316 sixth-e Problemfall +[ID] 2891 316 sixth-se Problemfall +[ID] 2891 317 sixth-nw Problemfall +[ID] 2891 317 sixth-w Problemfall +[ID] 2891 317 sixth-sw Problemfall +[ID] 2891 317 sixth-ne Problemfall +[ID] 2891 317 sixth-e Problemfall +[ID] 2891 317 sixth-e Problemfall +[ID] 2891 317 sixth-se Problemfall +[ID] 2891 318 sixth-nw Problemfall +[ID] 2891 318 sixth-w Problemfall +[ID] 2891 318 sixth-sw Problemfall +[ID] 2891 318 sixth-ne Problemfall +[ID] 2891 318 sixth-e Problemfall +[ID] 2891 318 sixth-se Problemfall +[ID] 2891 319 sixth-nw Problemfall +[ID] 2891 319 sixth-ne Problemfall +[ID] 2891 319 sixth-ne Problemfall +[ID] 2891 319 sixth-e Problemfall +[ID] 2891 319 sixth-se Problemfall +[ID] 2891 320 sixth-w Problemfall +[ID] 2891 320 sixth-sw Problemfall +[ID] 2891 320 sixth-ne Problemfall +[ID] 2891 320 sixth-e Problemfall +[ID] 2891 320 sixth-e Problemfall +[ID] 2891 323 half-left Problemfall +[ID] 2891 328 sixth-nw Problemfall +[ID] 2891 328 sixth-nw Problemfall +[ID] 2891 338 sixth-w Problemfall +[ID] 2891 340 half-lower Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall
contributions_illustration
sources
Kategorie von High Caliber Ops müsste man sich überlegen (analog dazu Underworld vom Shadowrun TCG). Die Videospiele aufzunehmen macht Sinn, wenn wir die Contributors ebenfalls aufnehmen (womit wir ja angefangen haben). Ob die in "sources" gehören oder in eine eigene Tabelle ist eine offene Frage. Auch ob jede Sprachfassung eine eigene ID bekommen soll (besser nicht!?). DLC wie Shadows of Hong Kong braucht eigene IDs, weil sie eigene Credits usw. haben.
+[ID] Shadowrun: Crossfire en card game +[ID] Shadowrun: High Caliber Ops en card game +[ID] Shadowrun (SNES) en video game +[ID] Shadowrun (Mega Drive) en video game +[ID] Shadowrun (Mega-CD) jp video game +[ID] Shadowrun (2007) en video game +[ID] Shadowrun Returns en video game +[ID] Shadowrun: Dragonfall en video game +[ID] Shadowrun: Dragonfall Director's Cut en video game +[ID] Shadowrun: Hong Kong en video game +[ID] Shadowrun Chronicles en video game +[ID] Shadowrun: Shadows of Hong Kong en DLC
Korrektur
Dopplungen?
- 458 - Erich Schreiner
- 4451 - Erich Schriner
- 3077 - Joshua Howell
- 7157 - Joshua Rowell
- 7468 - Larry Almore
- 8047 - Larry Elmore
- 5665 - Jacob Glaser
- 8919 - Jason Glaser