Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Loki (Diskussion | Beiträge) (-illustrations_source (Bloody Business, Hard Targets, Lockdown)) |
Loki (Diskussion | Beiträge) (-contributions_illustration (Rigger 5, Stolen Souls, Chrome Flesh)) |
||
| Zeile 156: | Zeile 156: | ||
4961 4656 illustration | 4961 4656 illustration | ||
4485 4656 illustration u | 4485 4656 illustration u | ||
</pre> | </pre> | ||
Version vom 9. März 2016, 21:16 Uhr
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) https://www.artstation.com/artist/kenfairclough http://kenfairclough.blogspot.com http://kennethfairclough.deviantart.com André Rogers (id missing) https://www.artstation.com/artist/gemineye http://artofandre.blogspot.com http://gemineyeart.deviantart.com http://www.gemineyeart.com https://www.facebook.com/GeminEyeArt Johannes Mücke (id missing) https://www.artstation.com/artist/wideshot Scott Fischer http://www.fischart.com http://scottmfischerevolvingeasel.blogspot.com Grant Goleasch http://dc.wikia.com/wiki/Grant_Goleash Dário Coelho http://dariocoelho.com https://www.artstation.com/artist/dariocoelho http://dariocoelho.deviantart.com https://www.facebook.com/coelhodario https://twitter.com/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