Shadowhelix:Datenbank/Vorschläge

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]	wpen	Gary Ruddell	
+[ID]	aventurica	Gary Ruddell	
+[ID]	isfdb-ea	1813	

Stephan Martinière
+[ID]	http://www.martiniere.com
+[ID]	facebook	smartiniere	
+[ID]	twitter	smartiniere	
+[ID]	isfdb-ea	23095	

Jan Meininghaus
+[ID]	www.jan-meininghaus.de
+[ID]	facebook	jan.meininghaus
+[ID]	behance	jan-meininghaus

Fred Gambino
+[ID]	http://www.fredgambino.co.uk
+[ID]	artstation	fredgambino
+[ID]	isfdb-ea	145765	

Attila Boros
+[ID]	isfdb-ea	23140	

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!

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

Update der Positionsangaben für Shadowrun 2nd. Vorgehen wie bei 3rd.

79682	3497		c2		full	
125047	3497		c3		full	
195274	3497		c5		full	
360974	3497		c4		full	
483051	3497		c1		full	
498731	3497		c7		full	
621387	3497		c8		full	
736149	3497		cv		full	
751092	3497		back		half-right	
967012	3497		c6		full	
480569	3497		1		center	
358217	3497		6		third-center	
129376	3497		7		third-lower	
251748	3497		9		full	
435106	3497		10		third-upper	
895243	3497		11		full	
730924	3497		13		full	
890613	3497		15		half-lower	
869514	3497		17		half-right	
286975	3497		19		center	
356140	3497		21		full	
706482	3497		25		quarter-ne	
74695	3497		27		half-lower	
593041	3497		29		quarter-ne	
235498	3497		31		full	
145602	3497		33		third-upper	
948217	3497		35		full	
478569	3497		36		quarter-ne	
514892	3497		36		quarter-sw	
364597	3497		37		quarter-ne	
957024	3497		37		quarter-sw	
58164	3497		38		half-left	
417289	3497		39		full	
150742	3497		41		full	
419385	3497		44		sixth-nw	
160394	3497		47		sixth-w	
239746	3497		49		half-right	
394056	3497		50		half-left	
641705	3497		51		half-right	
564073	3497		52		half-left	
943162	3497		53		half-right	
163487	3497		54		half-left	
261739	3497		55		half-right	
631254	3497		56		half-left	
28649	3497		57		half-right	
281976	3497		58		half-left	
456731	3497		59		half-right	
398645	3497		60		half-left	
793146	3497		61		half-right	
982740	3497		62		half-left	
541603	3497		63		half-right	
876032	3497		64		half-left	
364285	3497		65		full	
461057	3497		67		full	
634250	3497		68		quarter-se	
569870	3497		69		full	
367491	3497		71		quarter-sw	
349871	3497		72		sixth-nw	
521047	3497		73		quarter-nw	
568091	3497		74		sixth-se	
28743	3497		77		full	
936158	3497		78		quarter-sw	
502649	3497		80		quarter-se	
690318	3497		83		quarter-nw	
923870	3497		85		sixth-e	
827519	3497		87		half-left	
426805	3497		91		sixth-nw	
864157	3497		99		quarter-se	
928476	3497		100		half-left	
632510	3497		101		sixth-sw	
146827	3497		104		half-left	
304951	3497		108		half-upper	
240973	3497		110		half-left	
278465	3497		111		sixth-e	
978502	3497		112		quarter-nw	
218954	3497		117		full	
241680	3497		118		half-lower	
98154	3497		120		third-center	
138602	3497		121		third-center	
790548	3497		122		third-center	
963410	3497		126		sixth-ne	
941532	3497		129		sixth-nw	
928513	3497		130		sixth-nw	
697381	3497		134		full	
306859	3497		138		center	
379642	3497		141		quarter-nw	
35497	3497		148		center	
531920	3497		150		third-lower	
965084	3497		152		half-lower	
981563	3497		156		sixth-e	
934201	3497		157		sixth-ne	
75984	3497		161		full	
709348	3497		163		third-upper	
38152	3497		164		half-lower	
901342	3497		167		quarter-ne	
276958	3497		170		sixth-ne	
19534	3497		172		quarter-sw	
173605	3497		177		sixth-sw	
750638	3497		181		full	
87916	3497		183		sixth-se	
21584	3497		186		third-upper	
754829	3497		188		sixth-sw	
254731	3497		190		sixth-sw	
965821	3497		193		quarter-ne	
305462	3497		194		half-lower	
301482	3497		196		half-upper	
834216	3497		199		sixth-ne	
183752	3497		201		full	
26374	3497		202		quarter-sw	
54728	3497		203		quarter-nw	
209764	3497		203		quarter-se	
613780	3497		204		quarter-nw	
834150	3497		204		quarter-se	
684391	3497		205		quarter-nw	
846531	3497		205		quarter-se	
462073	3497		206		quarter-ne	
716035	3497		206		quarter-sw	
341928	3497		207		quarter-nw	
607235	3497		207		quarter-se	
47816	3497		208		quarter-ne	
75163	3497		208		quarter-sw	
103859	3497		209		quarter-ne	
836597	3497		209		quarter-sw	
795820	3497		210		quarter-ne	
938645	3497		210		quarter-sw	
469057	3497		211		quarter-nw	
728340	3497		211		quarter-se	
590738	3497		212		quarter-ne	
965470	3497		212		quarter-sw	
864570	3497		213		quarter-ne	
984517	3497		213		quarter-sw	
213908	3497		215		full	
906234	3497		220		third-upper	
162534	3497		223		sixth-ne	
81463	3497		225		half-right	
706345	3497		226		third-lower	
269408	3497		229		half-right	
570194	3497		237		full	
57816	3497		242		sixth-w	
54813	3497		243		sixth-w	
246839	3497		244		sixth-w	
439156	3497		245		third-upper	
705692	3497		246		quarter-ne	
380516	3497		247		sixth-w	
892671	3497		248		sixth-nw	
485679	3497		249		quarter-w	
240859	3497		250		sixth-sw	
136580	3497		251		sixth-ne	
490571	3497		251		sixth-se	
327150	3497		253		center	
526389	3497		265		half-lower	
657142	3497		267		full	
106784	3497		271		full	
637208	3497		273		sixth-se	
580712	3497		275		third-upper	
29431	3497		277		third-upper	
416927	3497		282		sixth-sw	
76318	3497		284		full	
648371	3497		295		full	

Update der Positionsangaben für Shadowrun 3rd. Bei den "Problemfällen" habe ich es einfach bei keiner Positionsangabe belassen, deshalb sind entsprechend nicht alle illu-ids für diese Quelle aufgeführt.

86951	1707		c6		full	
293687	1707		c1		full	
356981	1707		c4		full	
360147	1707		c5		full	
471086	1707		c7		full	
480136	1707		back		quarter-nw	
517649	1707		c8		full	
609718	1707		back		sixth-sw	
789123	1707		c3		full	
803956	1707		cv		full	
934761	1707		back		sixth-se	
983521	1707		c2		full	
315762	1707		9		full	
961843	1707		13		center	
934672	1707		14		half-left	
716294	1707		19		half-right	
83745	1707		23		full	
21643	1707		24		half-upper	
704891	1707		27		half-left	
905821	1707		33		full	
847150	1707		34		quarter-ne	
213970	1707		37		full	
275360	1707		42		quarter-nw	
263957	1707		53		full	
27381	1707		64		quarter-ne	
703914	1707		65		half-left	
336518	1707		66		half-left	
279385	1707		67		half-left	
991190	1707		68		half-left	
634907	1707		69		half-left	
482360	1707		70		half-left	
275553	1707		71		half-left	
927350	1707		72		half-left	
426507	1707		73		half-left	
384576	1707		74		half-left	
683450	1707		75		half-left	
816935	1707		76		half-left	
812406	1707		77		half-left	
812397	1707		78		half-left	
345168	1707		79		half-left	
875269	1707		80		half-left	
374180	1707		83		full	
527146	1707		88		half-left	
280961	1707		96		half-left	
347820	1707		101		full	
705819	1707		106		quarter-nw	
17263	1707		110		quarter-nw	
893274	1707		115		quarter-ne	
280941	1707		121		half-upper	
198726	1707		127		quarter-ne	
419250	1707		131		full	
296538	1707		139		full	
290385	1707		146		full	
621305	1707		152		half-upper	
130865	1707		155		full	
716253	1707		159		full	
586743	1707		165		full	
135804	1707		168		half-upper	
574109	1707		171		half-right	
84362	1707		175		full	
490157	1707		179		full	
415670	1707		185		full	
634925	1707		201		full	
260984	1707		208		half-left	
37812	1707		213		full	
652013	1707		221		quarter-nw	
29478	1707		222		quarter-ne	
748501	1707		225		half-upper	
387452	1707		227		half-right	
863507	1707		229		quarter-ne	
780916	1707		233		full	
765489	1707		243		full	
597408	1707		247		full	
246198	1707		249		quarter-ne	
910276	1707		250		half-left	
358907	1707		255		full	
172460	1707		258		quarter-nw	
305914	1707		261		full	
587942	1707		269		sixth-e	
46815	1707		271		full	
426901	1707		297		half-upper	
78193	1707		315		full	
98374	1707		325		sixth-nw	
745892	1707		325		half-right	
215384	1707		326		quarter-nw	
453920	1707		326		quarter-ne	
851032	1707		326		quarter-sw	
869217	1707		326		quarter-se	
157823	1707		327		quarter-nw	
354208	1707		327		quarter-ne	
409285	1707		327		quarter-sw	
640823	1707		327		quarter-se	
279583	1707		328		quarter-nw	
756039	1707		328		quarter-ne	
784936	1707		328		quarter-sw	
927103	1707		328		quarter-se	
135602	1707		329		quarter-nw	
306417	1707		329		quarter-ne	
592387	1707		329		quarter-sw	
836240	1707		329		quarter-se	

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

Shadowrun 2nd Edition:

5790	79682
8123	125047
5790	195274
1588	360974
4180	483051
4180	498731
1588	621387
8047	736149
5790	751092
8123	967012
5790	480569
1588	358217
4962	251748
5790	895243
8123	730924
4482	890613
5790	869514
8123	286975
5790	356140
9785	74695
5790	593041
1588	235498
8123	145602
4180	948217
4180	478569
4180	514892
4180	364597
4180	957024
4180	58164
4180	417289
8123	150742
4482	419385
8123	160394
1588	239746
1588	394056
1588	641705
1588	564073
1588	943162
1588	163487
1588	261739
1588	631254
1588	28649
1588	281976
1588	456731
1588	398645
1588	793146
1588	982740
1588	541603
1588	876032
5790	461057
9785	634250
8123	569870
9785	367491
8123	349871
9785	521047
4962	28743
8123	936158
8123	502649
5790	690318
5790	827519
1588	426805
3557	864157
8123	928476
3557	632510
4482	146827
9785	304951
5790	240973
1588	278465
1588	978502
1588	218954
1588	241680
1588	98154
1588	138602
1588	790548
1588	963410
8123	941532
1588	928513
5790	697381
4180	379642
1588	35497
9785	531920
4962	965084
3557	981563
3557	934201
8123	75984
1588	709348
8123	38152
4180	19534
8123	173605
4180	750638
8123	87916
1588	21584
3557	754829
9785	254731
4482	965821
8123	305462
9785	301482
4482	834216
8123	183752
5790	26374
1588	54728
1588	209764
1588	613780
1588	834150
1588	684391
1588	846531
1588	462073
1588	716035
1588	341928
1588	607235
1588	47816
1588	75163
1588	103859
1588	836597
1588	795820
1588	938645
1588	469057
1588	728340
1588	590738
1588	965470
1588	864570
1588	984517
5790	213908
1588	906234
4180	162534
4180	706345
1695	269408
4962	570194
3557	57816
5790	54813
8123	246839
8123	439156
8123	705692
1588	380516
8123	485679
1588	240859
9785	526389
1588	657142
1695	106784
9785	637208
5790	580712
8123	29431
4180	416927
5790	76318

Shadowrun 3rd Edition:

1588	86951
6115	293687
1212	356981
6115	360147
1212	471086
3862	480136
3862	517649
9435	609718
5475	789123
2792	803956
9435	934761
5475	983521
6115	316549
1628	16582
1588	315762
1009	192045
2792	934672
4302	716294
5475	173584
2894	83745
1772	21643
5475	905821
3536	847150
1588	275360
4180	894135
4180	375248
4180	625439
4180	325690
4180	650981
2894	263957
9435	27381
9435	703914
9435	336518
4180	279385
9435	991190
9435	634907
9435	482360
9435	275553
3862	927350
9435	426507
9435	384576
2820	683450
1588	816935
9435	812406
9435	812397
4180	345168
9435	875269
4305	374180
1772	527146
1628	568731
1772	347820
4180	705819
4305	17263
3862	893274
2894	280941
6115	198726
6666	308527
2894	419250
2894	296538
4305	290385
2894	621305
1772	130865
6666	254071
1628	297346
1588	716253
5790	586743
5790	135804
3862	574109
3862	84362
1772	490157
5790	628719
3862	415670
2894	307891
4305	634925
1588	260984
1009	279485
3862	37812
4180	652013
4180	29478
1772	748501
1009	387452
3862	863507
2792	861309
1588	765489
5790	597408
2894	246198
3862	910276
5475	897420
5790	358907
7832	943015
7832	305914
7832	687942
7832	587942
2792	158042
2894	16894
2894	426901
2767	792415
2894	78193
3557	176452
4845	84367
6933	132489
773	98374
9435	215384
9435	453920
4180	851032
9435	869217
9435	157823
9435	354208
9435	409285
3862	640823
9435	279583
9435	756039
2820	784936
1588	927103
9435	135602
9435	306417
4180	592387
9435	836240

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