Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
|||
| Zeile 40: | Zeile 40: | ||
===contributors_weblink=== | ===contributors_weblink=== | ||
<pre> | |||
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) | Kuba Witwoski (id missing) | ||
https://www.artstation.com/artist/kuba | https://www.artstation.com/artist/kuba | ||
| Zeile 66: | Zeile 88: | ||
Johannes Mücke (id missing) | Johannes Mücke (id missing) | ||
https://www.artstation.com/artist/wideshot | 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 | |||
</pre> | |||
===contributions=== | ===contributions=== | ||
Version vom 7. März 2016, 18:12 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) VALUES(+[ID], 'Fischer', 'Scott'); 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 (die Namen habe ich überprüft, s.u.): +[ID] Witowski Kuba +[ID] Chan Melvin +[ID] Fairclough Kenneth +[ID] Rogers André +[ID] Mücke Johannes
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
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 4730 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
illustrations_source Shadowrun 2050: +[ID] 4027 197 +[ID] 4027 200
illustrations_source
Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656) +[ID] 8488 cv +[ID] 8488 back +[ID] 8488 1 +[ID] 8488 8-9 +[ID] 8488 13 +[ID] 8488 19 +[ID] 8488 22 +[ID] 8488 29 +[ID] 8488 30 +[ID] 8488 33 +[ID] 8488 36 +[ID] 8488 39 +[ID] 8488 45 +[ID] 8488 51 +[ID] 8488 52 +[ID] 8488 54 +[ID] 8488 58 +[ID] 8488 64 +[ID] 8488 69 +[ID] 8488 72 +[ID] 8488 74 +[ID] 8488 80 +[ID] 8488 86 +[ID] 8488 88 +[ID] 8488 96 +[ID] 8488 98 +[ID] 8488 105 +[ID] 8488 109 +[ID] 8488 114 +[ID] 8488 121 +[ID] 8488 127 +[ID] 8488 134 +[ID] 8488 141 +[ID] 8488 144 +[ID] 8488 149 +[ID] 8488 151 +[ID] 4190 cv +[ID] 4190 back +[ID] 4190 1 +[ID] 4190 6-7 +[ID] 4190 14 +[ID] 4190 23 +[ID] 4190 31 +[ID] 4190 39 +[ID] 4190 40 +[ID] 4190 45 +[ID] 4190 53 +[ID] 4190 61 +[ID] 4190 68 +[ID] 4190 75 +[ID] 4190 76-77 +[ID] 4190 95 +[ID] 4190 102 +[ID] 4190 113 +[ID] 4190 117 +[ID] 4190 123 +[ID] 4190 129 +[ID] 4190 133 +[ID] 4190 144-145 +[ID] 4190 150 +[ID] 4190 158 +[ID] 4190 166 +[ID] 4190 169 +[ID] 4190 175 +[ID] 4190 177 +[ID] 4190 181 +[ID] 4190 199 +[ID] 4190 200 +[ID] 4190 203 +[ID] 4190 206-207 +[ID] 4190 208 +[ID] 4656 cv +[ID] 4656 back +[ID] 4656 1 +[ID] 4656 8-9 +[ID] 4656 14 +[ID] 4656 42 +[ID] 4656 59 +[ID] 4656 67 +[ID] 4656 70 +[ID] 4656 75 +[ID] 4656 77 +[ID] 4656 87 +[ID] 4656 95 +[ID] 4656 103 +[ID] 4656 109 +[ID] 4656 126 +[ID] 4656 135 +[ID] 4656 144 +[ID] 4656 154 +[ID] 4656 159 +[ID] 4656 170 +[ID] 4656 171 +[ID] 4656 174 +[ID] 4656 183 +[ID] 4656 189 +[ID] 4656 197 +[ID] 4656 208 +[ID] 4656 230 +[ID] 4656 240
contributions_illustration
Rigger 5 (1289), Stolen Souls (4630), Chrome Flesh (9450). Bei Stolen Souls gibt es bei (42379, 123068, 823479) das Problem, dass sowohl Raven Mimura als auch Victor Moreno an dem Bild mitgewirkt haben. Wie bilden wir das ab? Bislang habe ich die drei Abbildungen Raven Mimura (#136) zugeordnet.
9450 348406 136 42379 136 123068 136 823479 8545 356107 903 951742 9243 983465 903 85961 2331 321548 6698 908461 8147 923057 40 47918 8686 237906 903 350792 903 352907 133 841297 9243 749028 133 847039 6698 132845 8545 245089 6131 710526 8102 913472 903 570439 8227 371926 8227 345029 8227 109384 4662 463581 8545 47692 3402 478590 3715 589704 3715 719326 903 490238 903 861094 903 560837 6880 825673 903 276345 6880 814207 8123 273041 3402 491765 903 687204 4662 723459 3402 394062 8227 386241 Bei Street Grimoire (#6427) wurden einer doppelseitigen Abbildung ausversehen zwei id's gegeben (#796813 & 958763). Bitte eine davon löschen und die verbleibende Gordon Bennetto (#2331) zuordnen. Merci!
Korrektur
Dopplungen?
- 3077 - Joshua Howell
- 7157 - Joshua Rowell
- 7468 - Larry Almore
- 8047 - Larry Elmore
- 5665 - Jacob Glaser
- 8919 - Jason Glaser