Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(-contributors und zugehörige weblinks (Dylan Birtolo, J.C. Hutchins))
(→‎illustrations_source: -Market Panic, Serrated Edge, Shadowrun 2050, SRM 06-02)
Zeile 240: Zeile 240:
===illustrations_source===
===illustrations_source===
<pre>
<pre>
Shadowrun 2050:
+[ID] 4027 197
+[ID] 4027 200
SR4 Anniversary (vgl. Anmerkungen in der Diskussion)
SR4 Anniversary (vgl. Anmerkungen in der Diskussion)
+[ID] 2891 cv full
+[ID] 2891 cv full
Zeile 405: Zeile 401:
+[ID] 2891 352 Problemfall
+[ID] 2891 352 Problemfall
+[ID] 2891 376 full
+[ID] 2891 376 full
SRM 06-02 (3581)
+[ID] 3581 cv half-middle
+[ID] 3581 6 half-upper
+[ID] 3581 13 half-upper
+[ID] 3581 17 half-upper
+[ID] 3581 27 sixth-ne
+[ID] 3581 28 sixth-nw
+[ID] 3581 28 sixth-se
+[ID] 3581 29 sixth-ne
+[ID] 3581 30 third-upper
+[ID] 3581 31 third-upper
+[ID] 3581 32 third-upper
+[ID] 3581 33 third-upper
+[ID] 3581 35 center
+[ID] 3581 36 center
Serrated Edge (4513)
+[ID] 4513 cv center
+[ID] 4513 back half-right
+[ID] 4513 1 full
+[ID] 4513 3 full
+[ID] 4513 8 half-upper
+[ID] 4513 12 third-upper
+[ID] 4513 20 half-upper
+[ID] 4513 23 full
+[ID] 4513 27 half-upper
+[ID] 4513 39 full
+[ID] 4513 41 half-upper
+[ID] 4513 46 half-upper
+[ID] 4513 47 full
+[ID] 4513 59 full
+[ID] 4513 60 full
+[ID] 4513 62 center
+[ID] 4513 64 half-middle
Market Panic (8945)
+[ID] 8945 cv center
+[ID] 8945 back half-right
+[ID] 8945 1 full
+[ID] 8945 6-7 half-upper
+[ID] 8945 12 half-left
+[ID] 8945 16 half-left
+[ID] 8945 22 half-upper
+[ID] 8945 27 full
+[ID] 8945 31 half-upper
+[ID] 8945 34 half-upper
+[ID] 8945 37 half-upper
+[ID] 8945 40 half-left
+[ID] 8945 47 half-upper
+[ID] 8945 49 half-upper
+[ID] 8945 52 half-upper
+[ID] 8945 57 half-right
+[ID] 8945 61 half-upper
+[ID] 8945 65 half-upper
+[ID] 8945 67 half-upper
+[ID] 8945 69 half-right
+[ID] 8945 76 half-left
+[ID] 8945 80 half-upper
+[ID] 8945 83 half-upper
+[ID] 8945 87 full
+[ID] 8945 90 half-upper
+[ID] 8945 93 half-right
+[ID] 8945 99 half-upper
+[ID] 8945 103 full
+[ID] 8945 106 half-upper
+[ID] 8945 112 half-left
+[ID] 8945 121 half-right
+[ID] 8945 127 half-upper
+[ID] 8945 133 full
+[ID] 8945 136 half-left
+[ID] 8945 147 half-upper
+[ID] 8945 161 half-right
+[ID] 8945 175 half-upper
+[ID] 8945 181 half-right
+[ID] 8945 185 half-upper
+[ID] 8945 188 half-upper
+[ID] 8945 195 half-upper
+[ID] 8945 200 half-upper
+[ID] 8945 204 half-upper
+[ID] 8945 207 full
+[ID] 8945 208 full
</pre>
</pre>



Version vom 20. März 2016, 14:46 Uhr

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

Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656), Bullets & Bandages (7479), Coyotes (7421), Parazoology 2 (3876), Battle of Manhattan (1374), Borrowed Time (4090), Butte (7679), San Francisco (1255), Shadowrun Returns Anthology (9011), Shaken (4658), SR4 Anniversary (2891), Market Panic (8945), Serrated Edge (4513), SRM 06-02 (3581)

5176	7479	cover art		
1982	7421	cover art		
6690	3876	cover art		
40	1374	cover art		
830	1374	illustration		
6077	1374	art direction		
6690	1374	art direction		
1512	1374	text		
1711	4090	text		
5917	4090	cover art		
5303	4658	text		
903	4658	cover art		
8147	7679	cover art		
6690	7679	illustration		
8046	7679	illustration		
6077	7679	art direction		
6690	7679	art direction		
8938	7679	text		
9443	2891	text		Happy Trails
9443	2891	text		La Quienzième Section, le Sixième Monde
2179	2891	text		Game Set Match
2179	2891	text		Fresh Meat
4705	2891	text		Gaia's Heart
9178	2891	text		Night Shift
8938	2891	text		Hat Trick
3945	2891	text		Weekend Edition
1919	2891	text		Game Set Match
4878	2891	text		Best Served Cold
6431	2891	text	u	Extraction
1711	2891	text		
4530	2891	text		
5069	2891	text		
5603	2891	text		
2036	2891	text		
3994	2891	text		
8304	2891	text		
2146	2891	text		
2114	2891	text		
9487	2891	text		
8820	2891	text		
3242	2891	cover art		
1562	2891	illustration		
3242	2891	illustration		
5747	2891	illustration		North America Map
8043	2891	illustration		
2938	2891	illustration		
8123	2891	illustration		
6100	2891	illustration		
6739	2891	illustration		
1929	2891	illustration		
1156	2891	illustration		
7713	2891	illustration		
3022	2891	illustration		
8047	2891	illustration		
8027	2891	illustration		
4979	2891	illustration		
3904	2891	illustration		
1246	2891	illustration		
2810	2891	illustration		
6171	2891	illustration		
9495	2891	illustration		
8621	2891	illustration		
1407	2891	illustration		
3237	2891	illustration		
2620	2891	illustration		
1045	2891	illustration		
8703	2891	illustration		
5454	2891	illustration		
4595	2891	illustration		
6343	2891	illustration		
5618	2891	illustration		
4961	2891	illustration		
7789	2891	illustration		
2401	2891	illustration		
1228	2891	illustration		
446	2891	illustration		
5252	2891	illustration		
7448	2891	illustration		
2788	2891	illustration		
9243	2891	illustration		
9435	2891	illustration		
6413	8945	text		
4705	8945	text		
8133	8945	text		
4800	8945	text		The Fist Day of the Rest of Your Life
6445	8945	text		
207	8945	text		
6874	8945	text		
7309	8945	text		
6077	8945	art direction		
8545	8945	cover art		
133	8945	illustration		
6573	8945	illustration		
3402	8945	illustration		
7186	8945	illustration		
8545	8945	illustration		
5837	8945	illustration		
6724	8945	illustration		
8905	8945	illustration		
2331	8945	illustration		
4485	8945	illustration		
446	8945	illustration		
5964	8945	illustration		
5600	8945	illustration		
7413	8945	illustration		
4029	8945	illustration		
2513	8945	illustration		
6880	8945	illustration		
8147	8945	illustration		
903	8945	illustration		
207	4513	text		
6077	4513	art direction		
6573	4513	cover art		
7177	4513	illustration		Maps
6131	4513	illustration	u	
903	4513	illustration	u	
4595	4513	illustration	u	
5176	4513	illustration	u	
8211	3581	text		
6077	3581	art direction		
6690	3581	art direction		
7177	3581	cover art		
7177	3581	illustration		
2520	3581	illustration	u	

Tippfehler korrigiert (Mike Perry soll es sein):
6841	8488	illustration	u	

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: Hong Kong	en	novel
+[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