Shadowhelix:Datenbank/Vorschläge

Shadowhelix:Datenbank

Erweiterung

contributors_referenced_name

458	Erich Schriner
-> siehe Dopplungen unten

8905	Ethan Brew

Update / Korrektur in contributions:
8905	Brewerton		Ethan	S			

contributors

Fehlende aus SR4A und diversen Romanen:

+[ID]	Mohan	Jr	Steven					
+[ID]	Beaulieu		Bradley	P				
+[ID]	Bick		Ilsa	J				
+[ID]	Drake		Maxwell	Alexander				
+[ID]	Lorelei		Shannon					f
+[ID]	Duval		Dan	C				
+[ID]	William	Jr	Keith	H		1950		m
+[ID]	Peebles		Peter					
+[ID]	Steadman		Broeck					
+[ID]	Gallian		Carl					

INSERT INTO contributors(forename_first) VALUES('Liam.C');

+[ID]	Petrov		Miroslav				
+[ID]	Thiesen		James	Joseph			

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

Steven Mohan, Jr.
http://www.amazon.com/Steven-Mohan-Jr./e/B004YFIOQ4
http://storyportals.com/steven-mohan-jr
http://www.sarna.net/wiki/Steven_Mohan,_Jr.

Bradley P. Beaulieu
http://quillings.com

Ilsa J. Bick
www.ilsajbick.com

Lorelei Shannon:
http://www.psychenoir.com
https://en.wikipedia.org/wiki/Lorelei_Shannon
https://www.facebook.com/lorelei.shannon

William H. Keith, Jr.
http://www.whkeith.com
https://en.wikipedia.org/wiki/William_H._Keith,_Jr.

Broeck Steadman
http://etsteadman.com


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	


James Joseph Thiesen
+[ID]	http://fineartamerica.com/profiles/jim-thiesen	
+[ID]	facebook	JamesJosephThiesen.3	


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	

contributions

Ich habe mich mal der Romane und Sammelbände angenommen, vorerst nur der Englischen:

156	5372	text		Wetwork
156	1957	text		The Breach
188	1957	text		Rune’s Avatar Café
673	5366	text		No Such Luck
903	2017	cover art		
903	4731	cover art		
903	4635	cover art		
903	3218	cover art		
903	5887	cover art		
903	1957	cover art		
1366	6494	text		A Plague of Demons
1366	6494	text		Free Fall
1588	6494	illustration		
1711	1957	text		House of Cards
2033	7094	cover art		
2179	5374	text		Snake in the City
2820	658	cover art		
2820	3488	cover art		
2820	1797	cover art		
2820	9281	cover art		
2820	7792	cover art		
2820	2897	cover art		
2820	6851	cover art		
2830	4689	text		
2830	6494	text		Would it Help to Say I'm Sorry?
2830	6494	text		It's All Done with Mirrors
2830	5377	text		Better to Reign
2830	1957	text		Images: A Wolf and Raven Story
3082	1957	text		A Life on the Line
3242	5377	cover art		
3255	5370	text		Fade Away
3580	52	cover art		
3580	8583	cover art		
3580	6711	cover art		
3580	8447	cover art		
3580	4577	cover art		
3580	4689	cover art		
3610	8510	text		
3633	6494	text		Striper
3862	6494	illustration		
3898	6494	text		Into the Shadows
4174	6494	text		Tailchaser
4180	6494	illustration		
4705	5362	text		Trade Secrets
4705	1957	text		Swamp of Spirits
5110	6494	text		Turtle In the Tower
5303	1957	text		Holiday
5437	1957	text		The Cost of Science
5917	8510	cover art		
6020	1957	text		Social Engineering
6131	1053	cover art		
6131	9710	cover art		
6131	418	cover art		
6131	6062	cover art		
6131	4104	cover art		
6244	773	cover art		
6244	82	cover art		
6244	1316	cover art		
6244	5561	cover art		
6244	6494	cover art		
6346	3490	cover art		
6346	9097	cover art		
6346	9862	cover art		
6346	4572	cover art		
6346	1370	cover art		
6409	6494	illustration		
6409	6494	text		Graverobbers
6776	5363	text		Bloody Fingers
7015	6494	text		Prologue
7456	1957	text		Queen for a Minute
7832	6494	illustration		
8013	1957	text		Sweating Bullets
8123	4954	cover art		
8463	5887	text		
8463	1957	text		Nothing Personal
8493	5364	text		Better Than
8493	1957	text		Bottom of the Ninth
8545	6955	cover art		
8817	5365	text		Caliban
8817	1957	text		The Art of the Steal
8820	5367	text		Expectations
8865	5373	text		The Good Fight
9178	5362	text		Introduction
9178	1957	text		Introduction
9243	5364	cover art		
9243	5803	cover art		
9243	7702	cover art		
9243	355	cover art		
9367	1957	text		Thunderstruck

6511	7639	cover art		
6511	5258	cover art		

Bradley Bealieu:
[+ID]	5369	text		In Memory Of

Ilsa J. Bick:
[+ID]	5376	text		The Art of Diving in the Dark

Steven Mohan Jr:
[+ID]	5368	text		Where the Shadows are Darkest

Shannon Lorelei:
[+ID]	6494	text		Whitechapel Rose

Dan C. Duval:
[+ID]	5371	text		Big Jake

William H. Keith, Jr.:
[+ID]	5375	text		Dead Names

Jim Thiesen:
[+ID]	7467	cover art		
[+ID]	7645	cover art		

Peter Peebles:
[+ID]	2792	cover art		
[+ID]	1029	cover art		
[+ID]	2269	cover art		
[+ID]	4077	cover art		

Broeck Steadman:
[+ID]	1851	cover art		

Carl Gallian:
[+ID]	482	cover art		

World of Shadows
2381	1957	text		Revenge is a Dish Best Served by Proxy
5386	1957	text		It's Nice to Be Wanted
7594	1957	text		Keeping Up With Mr. Johnson

illustrations_source

Missions Season 5 (SRM 05A-01 (6086), SRM 05A-02 (1160), SRM 05A-03 (5296), SRM 05A-04 (9537), SRM 05A-05 (4817), SRM 05A-06 (4038)

+[ID]	6086		cv		half-middle	
+[ID]	6086		7		half-upper	
+[ID]	6086		9		sixth-se	
+[ID]	6086		13		half-upper	
+[ID]	6086		14		sixth-ne	
+[ID]	6086		15		third-upper	
+[ID]	6086		17		half-right	
+[ID]	6086		23		sixth-ne	
+[ID]	6086		23		sixth-se	
+[ID]	6086		24		sixth-sw	
+[ID]	6086		25		sixth-nw	
+[ID]	6086		27		full	
+[ID]	6086		28		full	
+[ID]	6086		29		full	
+[ID]	6086		30		full	
+[ID]	6086		31		third-upper	
+[ID]	6086		32		third-upper	
+[ID]	6086		33		third-upper	
+[ID]	6086		34		third-upper	
+[ID]	1160		cv		half-middle	
+[ID]	1160		8		half-upper	
+[ID]	1160		12		half-upper	
+[ID]	1160		16		half-upper	
+[ID]	1160		23		sixth-nw	
+[ID]	1160		24		sixth-nw	
+[ID]	1160		24		sixth-ne	
+[ID]	1160		25		sixth-ne	
+[ID]	1160		28		third-upper	
+[ID]	1160		29		third-upper	
+[ID]	1160		30		third-upper	
+[ID]	1160		31		third-upper	
+[ID]	5296		cv		half-middle	
+[ID]	5296		10		half-right	
+[ID]	5296		14		half-upper	
+[ID]	5296		17		half-upper	
+[ID]	5296		22		third-upper	
+[ID]	5296		23		third-upper	
+[ID]	5296		24		third-upper	
+[ID]	5296		25		third-upper	
+[ID]	9537		cv		half-middle	
+[ID]	9537		9		half-upper	
+[ID]	9537		12		half-upper	
+[ID]	9537		15		half-upper	
+[ID]	9537		21		sixth-nw	
+[ID]	9537		22		sixth-nw	
+[ID]	9537		22		sixth-ne	
+[ID]	9537		23		sixth-nw	
+[ID]	9537		24		third-upper	
+[ID]	4817		cv		half-middle	
+[ID]	4817		9		half-upper	
+[ID]	4817		13		half-right	
+[ID]	4817		20		half-upper	
+[ID]	4817		25		sixth-ne	
+[ID]	4817		27		third-upper	
+[ID]	4038		cv		half-middle	
+[ID]	4038		10		half-upper	
+[ID]	4038		13		half-upper	
+[ID]	4038		14		half-upper	
+[ID]	4038		21		half-upper	
+[ID]	4038		28		sixth-w	
+[ID]	4038		28		sixth-se	
+[ID]	4038		29		sixth-ne	
+[ID]	4038		30		sixth-sw	
+[ID]	4038		31		sixth-sw	
+[ID]	4038		32		sixth-nw	
+[ID]	4038		33		center	
+[ID]	4038		34		center	
+[ID]	4038		35		third-upper	
+[ID]	4038		36		third-upper	
+[ID]	4038		37		third-upper	

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


SR4 Anniversary (vgl. Anmerkungen in der Diskussion)
+[ID]	2891		cv		full	
+[ID]	2891		back		full	
+[ID]	2891		1		full	
+[ID]	2891		14		half-lower	
+[ID]	2891		17		third-right	
+[ID]	2891		19		third-right	
+[ID]	2891		20-21		half-lower	
+[ID]	2891		25		half-upper	
+[ID]	2891		28		third-upper	
+[ID]	2891		32		third-lower	
+[ID]	2891		36-37		half-upper	
+[ID]	2891		43		third-upper	
+[ID]	2891		47		half-right	
+[ID]	2891		52		third-left	
+[ID]	2891		58-59		half-upper	
+[ID]	2891		63		third-lower	
+[ID]	2891		66		third-left	
+[ID]	2891		72		half-lower	
+[ID]	2891		74		third-left	
+[ID]	2891		76-77		half-lower	
+[ID]	2891		83		third-right	
+[ID]	2891		89		half-right	
+[ID]	2891		92		third-lower	
+[ID]	2891		96		third-left	
+[ID]	2891		98		third-right	
+[ID]	2891		99		half-left	
+[ID]	2891		100		half-right	
+[ID]	2891		101		third-left	
+[ID]	2891		102		half-right	
+[ID]	2891		103		half-left	
+[ID]	2891		104		half-right	
+[ID]	2891		105		half-left	
+[ID]	2891		106		half-right	
+[ID]	2891		107		half-left	
+[ID]	2891		108		third-right	
+[ID]	2891		109		half-left	
+[ID]	2891		110		half-right	
+[ID]	2891		111		third-left	
+[ID]	2891		112		half-right	
+[ID]	2891		113		half-left	
+[ID]	2891		114-115		half-lower	
+[ID]	2891		121		third-right	
+[ID]	2891		123		third-right	
+[ID]	2891		125		quarter-lowest	
+[ID]	2891		126		quarter-lowest	
+[ID]	2891		133		quarter-rightmost	
+[ID]	2891		136		quarter-lowest	
+[ID]	2891		139		half-lower	
+[ID]	2891		142-143		half-lower	
+[ID]	2891		147		third-right	
+[ID]	2891		153		third-right	
+[ID]	2891		157		third-right	
+[ID]	2891		161		third-lower	
+[ID]	2891		164		third-left	
+[ID]	2891		168		quarter-lowest	
+[ID]	2891		171		quarter-lowest	
+[ID]	2891		172-173		half-lower	
+[ID]	2891		178		third-left	
+[ID]	2891		179		sixth-e	
+[ID]	2891		192		third-lower	
+[ID]	2891		197		half-lower	
+[ID]	2891		201		third-left	
+[ID]	2891		205		half-lower	
+[ID]	2891		212-213		half-lower	
+[ID]	2891		218		quarter-lowest	
+[ID]	2891		223		half-lower	
+[ID]	2891		226		third-lower	
+[ID]	2891		231		third-lower	
+[ID]	2891		235		third-right	
+[ID]	2891		240		third-left	
+[ID]	2891		244		half-lower	
+[ID]	2891		247		third-lower	
+[ID]	2891		248-249		half-upper	
+[ID]	2891		253		third-lower	
+[ID]	2891		258		third-left	
+[ID]	2891		263		half-lower	
+[ID]	2891		268		third-lower	
+[ID]	2891		273		quarter-lowest	
+[ID]	2891		283		third-upper	
+[ID]	2891		287		half-lower	
+[ID]	2891		297		half-lower	
+[ID]	2891		301		half-lower	
+[ID]	2891		302		half-lower	
+[ID]	2891		305		full	
+[ID]	2891		307		full	
+[ID]	2891		320		third-lower	
+[ID]	2891		326		third-lower	
+[ID]	2891		329		third-lower	
+[ID]	2891		334		third-lower	
+[ID]	2891		336		third-left	
+[ID]	2891		346		half-left	
+[ID]	2891		349		half-right	
+[ID]	2891		350		half-lower	
+[ID]	2891		376		full	

contributions_illustration

Diverse zu Victor Corbella und Randall Mackey

6930	817034
6930	480593
8147	581970
8147	108734
8147	310247
8147	935074
8147	463751
8147	791632

sources

Kleine Korrektur (Typ fehlt bislang):

4689	Wolf and Raven	en	novel

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