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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(-contributions_illustration (Rigger 5, Stolen Souls, Chrome Flesh))
Keine Bearbeitungszusammenfassung
Zeile 74: Zeile 74:
https://www.artstation.com/artist/melvinchan
https://www.artstation.com/artist/melvinchan
http://melvinchanart.deviantart.com
http://melvinchanart.deviantart.com


Kenneth Fairclough (id missing)
Kenneth Fairclough (id missing)
https://www.artstation.com/artist/kenfairclough
 
http://kenfairclough.blogspot.com
http://kenfairclough.blogspot.com
http://kennethfairclough.deviantart.com
 
+[ID] artstation kenfairclough
+[ID] deviantart kennethfairclough
 


André Rogers (id missing)
André Rogers (id missing)
https://www.artstation.com/artist/gemineye
 
http://artofandre.blogspot.com
http://artofandre.blogspot.com
http://gemineyeart.deviantart.com
http://www.gemineyeart.com
http://www.gemineyeart.com
https://www.facebook.com/GeminEyeArt
 
+[ID] artstation gemineye
+[ID] deviantart gemineyeart
+[ID] facebook GeminEyeArt
 


Johannes Mücke (id missing)
Johannes Mücke (id missing)
https://www.artstation.com/artist/wideshot


Scott Fischer
+[ID] artstation wideshot
 
 
Scott Fischer (id missing)
http://www.fischart.com
http://www.fischart.com
http://scottmfischerevolvingeasel.blogspot.com
http://scottmfischerevolvingeasel.blogspot.com


Grant Goleasch
 
Grant Goleasch (id missing)
http://dc.wikia.com/wiki/Grant_Goleash
http://dc.wikia.com/wiki/Grant_Goleash


Dário Coelho
 
http://dariocoelho.com
Dário Coelho (id missing)
https://www.artstation.com/artist/dariocoelho
 
http://dariocoelho.deviantart.com
+[ID] http://dariocoelho.com
https://www.facebook.com/coelhodario
 
https://twitter.com/DarioDraws
+[ID] artstation dariocoelho
+[ID] deviantart dariocoelho
+[ID] facebook coelhodario
+[ID] twitter DarioDraws
</pre>
</pre>



Version vom 9. März 2016, 20:21 Uhr

Shadowhelix:Datenbank

Erweiterung

contributors

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

INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');

INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'http://widulinskiart.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'https://www.facebook.com/groups/114658181901791');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'https://www.facebook.com/peter.bergting');

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):

INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Hudson', 'Heather');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick');
INSERT INTO contributors(id_contributor, surname, forename_first, forename_second) VALUES(+[ID], 'Fischer', 'Scott', 'M.');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Goleash', 'Grant');

INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Petersen', 'John');

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]	Witowski		Kuba				
+[ID]	Chan		Melvin				
+[ID]	Fairclough		Kenneth				
+[ID]	Rogers		André				
+[ID]	Mücke		Johannes				
+[ID]	Coelho		Dário				

contributors_weblink

Heather Hudson (id missing)
http://www.studiowondercabinet.com

Liam C. (id missing)
http://atomiccolossus.com/blacksunpress.net/liam

Miroslav Petrov (id missing)
https://artofmiro.carbonmade.com
http://mikeypetrov.deviantart.com

James Joseph Thiesen (id missing)
http://fineartamerica.com/profiles/jim-thiesen
https://www.facebook.com/JamesJosephThiesen.3

John Petersen (id missing)
http://petersen1973.deviantart.com
https://www.artstation.com/artist/scatterbrain73
http://www.petersenart.com
https://www.facebook.com/scatterbrain73
https://twitter.com/scatterbrain73

Kuba Witwoski (id missing)
https://www.artstation.com/artist/kuba
http://kubawitowski.com
https://www.facebook.com/kuba.witowski.art
http://kubawitowski.tumblr.com
http://kubawitowski.deviantart.com

Melvin Chan (id missing)
http://www.melvinchanart.com
https://www.artstation.com/artist/melvinchan
http://melvinchanart.deviantart.com


Kenneth Fairclough (id missing)

http://kenfairclough.blogspot.com

+[ID]	artstation	kenfairclough
+[ID]	deviantart	kennethfairclough


André Rogers (id missing)

http://artofandre.blogspot.com
http://www.gemineyeart.com

+[ID]	artstation	gemineye
+[ID]	deviantart	gemineyeart
+[ID]	facebook	GeminEyeArt


Johannes Mücke (id missing)

+[ID]	artstation	wideshot


Scott Fischer (id missing)
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)
1936	7003	illustration		
3931	7003	illustration		
4551	7003	illustration		
5964	1289	illustration		
2928	1289	illustration		
6190	1289	illustration		
4657	1289	illustration		
3715	1289	illustration		
8123	1289	illustration	u	
756	4602	illustration	u	
6131	4630	illustration	u	
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		
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		
4662	4656	illustration		
2542	4656	illustration		
8964	4656	illustration		
1380	4656	illustration		
4551	4656	illustration		
4961	4656	illustration		
4485	4656	illustration	u	

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