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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Zeile 84: Zeile 84:
===contributions===
===contributions===
<pre>
<pre>
Data Trails (7003), Rigger 5 (1289), Run & Gun (4602), Stolen Souls (4630), Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656), Sixth World Almanac (6431)
Data Trails (7003), Rigger 5 (1289), Run & Gun (4602), Stolen Souls (4630), Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656), Sixth World Almanac (6431), Bullets & Bandages (7479, Coyotes (7421), Parazoology 2 (3876), Battle of Manhattan (1374), Borrowed Time (4090), Butte (7679), Cheyenne (3301), San Francisco (1255), Shadowrun Returns Anthology (9011), Shaken (4658)
 
1936 7003 illustration
1936 7003 illustration
3931 7003 illustration
3931 7003 illustration
4551 7003 illustration
4551 7003 illustration
6077 7003 art direction
8886 7003 text Corporate Sponsorship
7294 7003 text
3541 7003 text
4705 7003 text
1919 7003 text
207 7003 text Body Hunt
9062 7003 text
2049 7003 text GOD Speaks
5964 1289 illustration
5964 1289 illustration
2928 1289 illustration
2928 1289 illustration
Zeile 94: Zeile 104:
3715 1289 illustration
3715 1289 illustration
8123 1289 illustration u
8123 1289 illustration u
6077 1289 art direction
6413 1289 text
1097 1289 text
4705 1289 text The Order of Chaos
8938 1289 text
1919 1289 text
207 1289 text One Rig to Rule Them All
1512 1289 text
6020 1289 text Home Security
7309 1289 text
756 4602 illustration u
756 4602 illustration u
6131 4630 illustration u
6131 4630 illustration u
6077 4630 art direction
1238 4630 text
4705 4630 text
8133 4630 text
207 4630 text
6874 4630 text
2331 8488 illustration
2331 8488 illustration
8147 8488 illustration
8147 8488 illustration
Zeile 110: Zeile 136:
1997 8488 illustration
1997 8488 illustration
6481 8488 illustration u
6481 8488 illustration u
6077 8488 art direction
1360 8488 text
4705 8488 text
1517 8488 text
207 8488 text
1512 8488 text
6020 8488 text
6874 8488 text
40 8488 cover art
40 8488 cover art
2331 4190 cover art
2331 4190 cover art
Zeile 127: Zeile 161:
6880 4190 illustration
6880 4190 illustration
40 4190 illustration
40 4190 illustration
6077 4190 art direction
3610 4190 text
4705 4190 text
1432 4190 text
8938 4190 text
2128 4190 text Justice for Hire
207 4190 text Slow and Steady Death
1512 4190 text
6874 4190 text Chameleon
4662 4656 illustration
4662 4656 illustration
2542 4656 illustration
2542 4656 illustration
Zeile 134: Zeile 177:
4961 4656 illustration
4961 4656 illustration
4485 4656 illustration u
4485 4656 illustration u
6077 4656 art direction
207 4656 text Familiar Faces
8123 6431 illustration u
8123 6431 illustration u
7645 6431 illustration u
7645 6431 illustration u
1228 6431 illustration u
1228 6431 illustration u
6131 6431 illustration u
6131 6431 illustration u
6077 4656 art direction
207 4656 text Familiar Faces
6077 8488 art direction
1360 8488 text
4705 8488 text
1517 8488 text
207 8488 text
1512 8488 text
6020 8488 text
6874 8488 text
6077 4630 art direction
1238 4630 text
4705 4630 text
8133 4630 text
207 4630 text
6874 4630 text
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
6077 3301 art direction
6690 3301 art direction
6550 3301 illustration
1997 3301 illustration
6874 3301 text
6077 1255 art direction
6690 1255 art direction
8147 1255 cover art
8147 1255 illustration
8227 9011 cover art
7071 9011 illustration
7015 9011 text Foreword and Afterward
188 9011 text Locks and Keys
5303 9011 text No Sharper Spur
1711 9011 text Belonging and Never Alone
8817 9011 text The Road to Hell
6776 9011 text But Loyal to his Salt
1366 9011 text Dinner with a Friend
9367 9011 text Blowing Sky High
6020 9011 text Past Salvage and White Hat, Black Bag
156 9011 text Showtime
8133 9011 text Dog Tags
4705 9011 text The Deep End
3255 9011 text A Night's Work
</pre>
</pre>



Version vom 14. März 2016, 18:56 Uhr

Shadowhelix:Datenbank

Erweiterung

contributors

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

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

Folgende Contributors fehlen (aus Chrome Flesh, Rigger 5.0, Data Trails und Shadowrun TCG, müssen dann auch alle noch in contributions eingetragen werden). Mit Ausnahme des TCGs (erster Block), wo die Namen direkt von den Karten kommen, habe ich die Namen direkt aus den CGL-Credits und nicht aus dem Internet, kann also sein, dass die noch falsch sind (CGL ist da sehr nachlässig):

+[ID]	Hudson		Heather				
+[ID]	Ho		Patrick				
+[ID]	Fischer		Scott	M			
+[ID]	Gregory		Barry				
+[ID]	Goleash		Grant				

Fehlende aus Bloody Business, Hard Targets und 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?

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

contributions

Data Trails (7003), Rigger 5 (1289), Run & Gun (4602), Stolen Souls (4630), Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656), Sixth World Almanac (6431), Bullets & Bandages (7479, Coyotes (7421), Parazoology 2 (3876), Battle of Manhattan (1374), Borrowed Time (4090), Butte (7679), Cheyenne (3301), San Francisco (1255), Shadowrun Returns Anthology (9011), Shaken (4658)

1936	7003	illustration		
3931	7003	illustration		
4551	7003	illustration
6077	7003	art direction		
8886	7003	text		Corporate Sponsorship
7294	7003	text		
3541	7003	text		
4705	7003	text		
1919	7003	text		
207	7003	text		Body Hunt
9062	7003	text		
2049	7003	text		GOD Speaks		
5964	1289	illustration		
2928	1289	illustration		
6190	1289	illustration		
4657	1289	illustration		
3715	1289	illustration		
8123	1289	illustration	u	
6077	1289	art direction		
6413	1289	text		
1097	1289	text		
4705	1289	text		The Order of Chaos
8938	1289	text		
1919	1289	text		
207	1289	text		One Rig to Rule Them All
1512	1289	text		
6020	1289	text		Home Security
7309	1289	text		
756	4602	illustration	u	
6131	4630	illustration	u	
6077	4630	art direction		
1238	4630	text		
4705	4630	text		
8133	4630	text		
207	4630	text		
6874	4630	text		
2331	8488	illustration		
8147	8488	illustration		
2310	8488	illustration		
4662	8488	illustration		
2002	8488	illustration		
8545	8488	illustration		
4485	8488	illustration		
5917	8488	illustration		
8964	8488	illustration		
6698	8488	illustration		
133	8488	illustration		
1380	8488	illustration		
1997	8488	illustration		
6481	8488	illustration	u	
6077	8488	art direction		
1360	8488	text		
4705	8488	text		
1517	8488	text		
207	8488	text		
1512	8488	text		
6020	8488	text		
6874	8488	text		
40	8488	cover art		
2331	4190	cover art		
2331	4190	illustration		
3715	4190	illustration		
8147	4190	illustration		
2310	4190	illustration		
2011	4190	illustration		
8545	4190	illustration		
4485	4190	illustration		
1588	4190	illustration		
6573	4190	illustration		
903	4190	illustration		
2513	4190	illustration		
133	4190	illustration		
1380	4190	illustration		
6880	4190	illustration		
40	4190	illustration		
6077	4190	art direction		
3610	4190	text		
4705	4190	text		
1432	4190	text		
8938	4190	text		
2128	4190	text		Justice for Hire
207	4190	text		Slow and Steady Death
1512	4190	text		
6874	4190	text		Chameleon
4662	4656	illustration		
2542	4656	illustration		
8964	4656	illustration		
1380	4656	illustration		
4551	4656	illustration		
4961	4656	illustration		
4485	4656	illustration	u	
6077	4656	art direction		
207	4656	text		Familiar Faces
8123	6431	illustration	u	
7645	6431	illustration	u	
1228	6431	illustration	u	
6131	6431	illustration	u	
6077	4656	art direction		
207	4656	text		Familiar Faces
6077	8488	art direction		
1360	8488	text		
4705	8488	text		
1517	8488	text		
207	8488	text		
1512	8488	text		
6020	8488	text		
6874	8488	text		
6077	4630	art direction		
1238	4630	text		
4705	4630	text		
8133	4630	text		
207	4630	text		
6874	4630	text		
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		
6077	3301	art direction		
6690	3301	art direction		
6550	3301	illustration		
1997	3301	illustration		
6874	3301	text		
6077	1255	art direction		
6690	1255	art direction		
8147	1255	cover art		
8147	1255	illustration		
8227	9011	cover art		
7071	9011	illustration		
7015	9011	text		Foreword and Afterward
188	9011	text		Locks and Keys
5303	9011	text		No Sharper Spur
1711	9011	text		Belonging and Never Alone
8817	9011	text		The Road to Hell
6776	9011	text		But Loyal to his Salt
1366	9011	text		Dinner with a Friend
9367	9011	text		Blowing Sky High
6020	9011	text		Past Salvage and White Hat, Black Bag
156	9011	text		Showtime
8133	9011	text		Dog Tags
4705	9011	text		The Deep End
3255	9011	text		A Night's Work

illustrations_source

Shadowrun 2050:
+[ID]	4027		197			
+[ID]	4027		200			

Korrektur

Dopplungen?

  • 3077 - Joshua Howell
  • 7157 - Joshua Rowell
  • 7468 - Larry Almore
  • 8047 - Larry Elmore
  • 5665 - Jacob Glaser
  • 8919 - Jason Glaser