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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(→‎illustrations_source: -Market Panic, Serrated Edge, Shadowrun 2050, SRM 06-02)
(-contributions)
Zeile 107: Zeile 107:


===contributions===
===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)
<pre>
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
</pre>


===illustrations_source===
===illustrations_source===
Zeile 408: Zeile 278:
+[ID] Shadowrun: Crossfire en card game
+[ID] Shadowrun: Crossfire en card game
+[ID] Shadowrun: High Caliber Ops 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 (SNES) en video game
+[ID] Shadowrun (Mega Drive) en video game
+[ID] Shadowrun (Mega Drive) en video game

Version vom 20. März 2016, 19:34 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

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