Shadowhelix:Datenbank/Vorschläge
Zur Navigation springen
Zur Suche springen
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] http://www.studiowondercabinet.com Liam C. +[ID] http://atomiccolossus.com/blacksunpress.net/liam Miroslav Petrov +[ID] https://artofmiro.carbonmade.com +[ID] deviantart mikeypetrov James Joseph Thiesen +[ID] http://fineartamerica.com/profiles/jim-thiesen +[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 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