Shadowhelix:Datenbank/Vorschläge

Aus Shadowhelix
Zur Navigation springen Zur Suche springen

Shadowhelix:Datenbank

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