Shadowhelix:Datenbank/Vorschläge

Aus Shadowhelix
Zur Navigation springen Zur Suche springen

Shadowhelix:Datenbank

Erweiterung

contributors_referenced_name

458	Erich Schriner
-> siehe Dopplungen unten

8905	Ethan Brew

Update / Korrektur in contributions:
8905	Brewerton		Ethan	S			

contributors

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				

Folgende Personen habe ich von SR4 Anniversary nicht in contributors gefunden: Christopher Maley (Story: What Goes Around Comes Around), Steven Mohan Jr. (nicht in den Credits; aber als Autor der Kurzgeschichte What Is Inside Your Heart genannt) und der Art Director fehlt auch (Mike Vaillancourt). Ich werde in den nächsten Tagen mal deren Webseiten recherchieren, heute schaffe ich das nicht mehr.

contributors_weblink

446	http://widulinskiart.carbonmade.com	
1588	https://www.facebook.com/groups/114658181901791	


3010	facebook	bOne77	
5176	facebook	arndt.drechsler	
6115	facebook	peter.bergting	
7389	facebook	MichaelRookardArt	


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

illustrations_source

SR4 Anniversary (vgl. Anmerkungen in der Diskussion)
+[ID]	2891		cv		full	
+[ID]	2891		back		full	
+[ID]	2891		1		full	
+[ID]	2891		7		center	Problemfall
+[ID]	2891		9		quarter-se	Problemfall
+[ID]	2891		10-11			Problemfall
+[ID]	2891		12		half-left	Problemfall
+[ID]	2891		14		half-lower	
+[ID]	2891		16		sixth-sw	Problemfall
+[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		149			Problemfall
+[ID]	2891		149			Problemfall
+[ID]	2891		149			Problemfall
+[ID]	2891		149			Problemfall
+[ID]	2891		149			Problemfall
+[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		184		third-lower	Problemfall
+[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		227		sixth-se	Problemfall
+[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		276-277		half-middle	Problemfall
+[ID]	2891		283		third-upper	
+[ID]	2891		287		half-lower	
+[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		297		half-lower	
+[ID]	2891		298		sixth-ne	Problemfall
+[ID]	2891		298		sixth-e	Problemfall
+[ID]	2891		298		sixth-se	Problemfall
+[ID]	2891		301		half-lower	
+[ID]	2891		302		half-lower	
+[ID]	2891		305		full	
+[ID]	2891		307		full	
+[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		320		third-lower	
+[ID]	2891		323		half-left	Problemfall
+[ID]	2891		326		third-lower	
+[ID]	2891		328		sixth-nw	Problemfall
+[ID]	2891		328		sixth-nw	Problemfall
+[ID]	2891		329		third-lower	
+[ID]	2891		334		third-lower	
+[ID]	2891		336		third-left	
+[ID]	2891		338		sixth-w	Problemfall
+[ID]	2891		340		half-lower	Problemfall
+[ID]	2891		346		half-left	
+[ID]	2891		349		half-right	
+[ID]	2891		350		half-lower	
+[ID]	2891		352			Problemfall
+[ID]	2891		352			Problemfall
+[ID]	2891		352			Problemfall
+[ID]	2891		352			Problemfall
+[ID]	2891		352			Problemfall
+[ID]	2891		352			Problemfall
+[ID]	2891		376		full	

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