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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(-contributors, links (Melvin Chan, Kenneth Fairclough, André Rogers, John Petersen, Johannes Mücke, Kuba Witowski))
Zeile 6: Zeile 6:
<pre>
<pre>
INSERT INTO contributors(forename_first) VALUES('Liam.C');
INSERT INTO contributors(forename_first) VALUES('Liam.C');
INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');
INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
</pre>
</pre>
Zeile 28: Zeile 26:
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry');
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], '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):
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
+[ID] Coelho Dário
</pre>
</pre>
Zeile 47: Zeile 38:
Liam C.
Liam C.
+[ID] http://atomiccolossus.com/blacksunpress.net/liam
+[ID] http://atomiccolossus.com/blacksunpress.net/liam


Miroslav Petrov
Miroslav Petrov
+[ID] https://artofmiro.carbonmade.com
+[ID] https://artofmiro.carbonmade.com
+[ID] http://soulsart.blogspot.com
+[ID] deviantart mikeypetrov
+[ID] deviantart mikeypetrov
+[ID] twitter Soulsart


James Joseph Thiesen
James Joseph Thiesen
+[ID] http://fineartamerica.com/profiles/jim-thiesen
+[ID] http://fineartamerica.com/profiles/jim-thiesen
+[ID] facebook JamesJosephThiesen.3
+[ID] facebook JamesJosephThiesen.3
John Petersen
+[ID] http://www.petersenart.com
+[ID] deviantart petersen1973
+[ID] artstation scatterbrain73
+[ID] facebook scatterbrain73
+[ID] twitter scatterbrain73
Kuba Witwoski
+[ID] http://kubawitowski.com
+[ID] deviantart kubawitowski
+[ID] artstation kuba
+[ID] facebook kuba.witowski.art
+[ID] tumblr kubawitowski
Melvin Chan
+[ID] http://www.melvinchanart.com
+[ID] deviantart melvinchanart
+[ID] artstation melvinchan
Kenneth Fairclough (id missing)
http://kenfairclough.blogspot.com
+[ID] artstation kenfairclough
+[ID] deviantart kennethfairclough
André Rogers (id missing)
+[ID] http://www.gemineyeart.com
http://artofandre.blogspot.com
+[ID] artstation gemineye
+[ID] deviantart gemineyeart
+[ID] facebook GeminEyeArt
Johannes Mücke
+[ID] artstation wideshot




Version vom 10. März 2016, 13:40 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');

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

contributors_weblink

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)
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		
6481	8488	illustration	u	
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

contributions_illustration

Bloody Business (8488), Hard Targets (4190), Shadowrun Lockdown (4656):
40	723081
40	549267
40	432675
2331	892350
2002	507169
8545	217048
8964	314872
4485	741380
1380	215478
6841	834106
8964	478206
2310	94512
133	527468
903	39714
2331	627894
133	81469
2331	607945
2331	920763
2331	971084
903	198236
8545	539182
8964	675803
903	21493
3510	950184
8545	340691
903	725041
3402	698705
903	470239
6698	762398
3715	468529
903	198705
903	231865
8545	487125
1588	804561
2331	38479
4662	604578
8964	408527
4961	327548
4485	456793
4662	302765
4961	631927
8964	249675
8964	428756
4961	61439
4961	743528

Korrektur

Dopplungen?

  • 3077 - Joshua Howell
  • 7157 - Joshua Rowell
  • 7468 - Larry Almore
  • 8047 - Larry Elmore
  • 5665 - Jacob Glaser
  • 8919 - Jason Glaser
Abgerufen von „https://shadowhelix.de/index.php?title=Shadowhelix:Datenbank/Vorschläge&oldid=217129“