Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Loki (Diskussion | Beiträge) (Anpassung für archive_copy_timestamp) |
Loki (Diskussion | Beiträge) (-contributors_referenced_name; Brew / Brewerton konnte ich noch nicht bestätigen, gibt es einen Beleg, dass das der eigentliche Name ist?) |
||
Zeile 5: | Zeile 5: | ||
===contributors_referenced_name=== | ===contributors_referenced_name=== | ||
<pre> | <pre> | ||
458 Erich Schriner | 458 Erich Schriner | ||
-> siehe Dopplungen unten | |||
8905 Ethan Brew | 8905 Ethan Brew | ||
Zeile 540: | Zeile 520: | ||
===Dopplungen?=== | ===Dopplungen?=== | ||
*458 - Erich Schreiner | |||
*4451 - Erich Schriner | |||
*3077 - Joshua Howell | *3077 - Joshua Howell | ||
*7157 - Joshua Rowell | *7157 - Joshua Rowell |
Version vom 19. März 2016, 17:04 Uhr
Erweiterung
contributors_referenced_name
458 Erich Schriner -> siehe Dopplungen unten 8905 Ethan Brew Update / Korrektur in contributions: 8905 Brewerton Ethan S
contributors
INSERT INTO contributors(forename_first) VALUES('Liam.C'); +[ID] Petrov Miroslav +[ID] Thiesen James Joseph
Shadowrun TCG:
+[ID] Hudson Heather +[ID] Ho Patrick +[ID] Fischer Scott M +[ID] Gregory Barry +[ID] Goleash Grant
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
Tomek Wrotek (Lockdown) -- Wrotek ein Anagram von Tworek?
HBS-Artist und zwei Autoren aus der SR Anthology (weblinks s.u.): +[ID] Ishmael Tristin +[ID] Birtolo Dylan +[ID] Hutchins J C
Folgende Personen habe ich von SR4 Anniversary nicht in contributors gefunden: Christopher Maley (Story: What Goes Around Comes Around), Steven Mohan Jr. (nicht in den Credits; aber als Autor der Kurzgeschichte What Is Inside Your Heart genannt) und der Art Director fehlt auch (Mike Vaillancourt). Ich werde in den nächsten Tagen mal deren Webseiten recherchieren, heute schaffe ich das nicht mehr.
contributors_weblink
446 http://widulinskiart.carbonmade.com 1588 https://www.facebook.com/groups/114658181901791 3010 facebook bOne77 5176 facebook arndt.drechsler 6115 facebook peter.bergting 7389 facebook MichaelRookardArt 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 J.C. Hutchins: +[ID] http://jchutchins.net Dylan Birtolo +[ID] http://www.dylanbirtolo.com +[ID] twitter dylanbirtolo +[ID] facebook dbirtolo Tristin Ishmael +[ID] http://www.theycallmeishmael.com +[ID] facebook tristin.ishmael +[ID] artstation sailormonkey +[ID] twitter Tristinishmael
contributions
Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656), Bullets & Bandages (7479), Coyotes (7421), Parazoology 2 (3876), Battle of Manhattan (1374), Borrowed Time (4090), Butte (7679), San Francisco (1255), Shadowrun Returns Anthology (9011), Shaken (4658), SR4 Anniversary (2891), Market Panic (8945), Serrated Edge (4513), SRM 06-02 (3581)
5176 7479 cover art 1982 7421 cover art 6690 3876 cover art 40 1374 cover art 830 1374 illustration 6077 1374 art direction 6690 1374 art direction 1512 1374 text 1711 4090 text 5917 4090 cover art 5303 4658 text 903 4658 cover art 8147 7679 cover art 6690 7679 illustration 8046 7679 illustration 6077 7679 art direction 6690 7679 art direction 8938 7679 text 9443 2891 text Happy Trails 9443 2891 text La Quienzième Section, le Sixième Monde 2179 2891 text Game Set Match 2179 2891 text Fresh Meat 4705 2891 text Gaia's Heart 9178 2891 text Night Shift 8938 2891 text Hat Trick 3945 2891 text Weekend Edition 1919 2891 text Game Set Match 4878 2891 text Best Served Cold 6431 2891 text u Extraction 1711 2891 text 4530 2891 text 5069 2891 text 5603 2891 text 2036 2891 text 3994 2891 text 8304 2891 text 2146 2891 text 2114 2891 text 9487 2891 text 8820 2891 text 3242 2891 cover art 1562 2891 illustration 3242 2891 illustration 5747 2891 illustration North America Map 8043 2891 illustration 2938 2891 illustration 8123 2891 illustration 6100 2891 illustration 6739 2891 illustration 1929 2891 illustration 1156 2891 illustration 7713 2891 illustration 3022 2891 illustration 8047 2891 illustration 8027 2891 illustration 4979 2891 illustration 3904 2891 illustration 1246 2891 illustration 2810 2891 illustration 6171 2891 illustration 9495 2891 illustration 8621 2891 illustration 1407 2891 illustration 3237 2891 illustration 2620 2891 illustration 1045 2891 illustration 8703 2891 illustration 5454 2891 illustration 4595 2891 illustration 6343 2891 illustration 5618 2891 illustration 4961 2891 illustration 7789 2891 illustration 2401 2891 illustration 1228 2891 illustration 446 2891 illustration 5252 2891 illustration 7448 2891 illustration 2788 2891 illustration 9243 2891 illustration 9435 2891 illustration 6413 8945 text 4705 8945 text 8133 8945 text 4800 8945 text The Fist Day of the Rest of Your Life 6445 8945 text 207 8945 text 6874 8945 text 7309 8945 text 6077 8945 art direction 8545 8945 cover art 133 8945 illustration 6573 8945 illustration 3402 8945 illustration 7186 8945 illustration 8545 8945 illustration 5837 8945 illustration 6724 8945 illustration 8905 8945 illustration 2331 8945 illustration 4485 8945 illustration 446 8945 illustration 5964 8945 illustration 5600 8945 illustration 7413 8945 illustration 4029 8945 illustration 2513 8945 illustration 6880 8945 illustration 8147 8945 illustration 903 8945 illustration 207 4513 text 6077 4513 art direction 6573 4513 cover art 7177 4513 illustration Maps 6131 4513 illustration u 903 4513 illustration u 4595 4513 illustration u 5176 4513 illustration u 8211 3581 text 6077 3581 art direction 6690 3581 art direction 7177 3581 cover art 7177 3581 illustration 2520 3581 illustration u Tippfehler korrigiert (Mike Perry soll es sein): 6841 8488 illustration u
illustrations_source
Shadowrun 2050: +[ID] 4027 197 +[ID] 4027 200 SR4 Anniversary (vgl. Anmerkungen in der Diskussion) +[ID] 2891 cv full +[ID] 2891 back full +[ID] 2891 1 full +[ID] 2891 7 center Problemfall +[ID] 2891 9 quarter-se Problemfall +[ID] 2891 10-11 Problemfall +[ID] 2891 12 half-left Problemfall +[ID] 2891 14 half-lower +[ID] 2891 16 sixth-sw Problemfall +[ID] 2891 17 third-right +[ID] 2891 19 third-right +[ID] 2891 20-21 half-lower +[ID] 2891 25 half-upper +[ID] 2891 28 third-upper +[ID] 2891 32 third-lower +[ID] 2891 36-37 half-upper +[ID] 2891 43 third-upper +[ID] 2891 47 half-right +[ID] 2891 52 third-left +[ID] 2891 58-59 half-upper +[ID] 2891 63 third-lower +[ID] 2891 66 third-left +[ID] 2891 72 half-lower +[ID] 2891 74 third-left +[ID] 2891 76-77 half-lower +[ID] 2891 83 third-right +[ID] 2891 89 half-right +[ID] 2891 92 third-lower +[ID] 2891 96 third-left +[ID] 2891 98 third-right +[ID] 2891 99 half-left +[ID] 2891 100 half-right +[ID] 2891 101 third-left +[ID] 2891 102 half-right +[ID] 2891 103 half-left +[ID] 2891 104 half-right +[ID] 2891 105 half-left +[ID] 2891 106 half-right +[ID] 2891 107 half-left +[ID] 2891 108 third-right +[ID] 2891 109 half-left +[ID] 2891 110 half-right +[ID] 2891 111 third-left +[ID] 2891 112 half-right +[ID] 2891 113 half-left +[ID] 2891 114-115 half-lower +[ID] 2891 121 third-right +[ID] 2891 123 third-right +[ID] 2891 125 quarter-lowest +[ID] 2891 126 quarter-lowest +[ID] 2891 133 quarter-rightmost +[ID] 2891 136 quarter-lowest +[ID] 2891 139 half-lower +[ID] 2891 142-143 half-lower +[ID] 2891 147 third-right +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 153 third-right +[ID] 2891 157 third-right +[ID] 2891 161 third-lower +[ID] 2891 164 third-left +[ID] 2891 168 quarter-lowest +[ID] 2891 171 quarter-lowest +[ID] 2891 172-173 half-lower +[ID] 2891 178 third-left +[ID] 2891 179 sixth-e +[ID] 2891 184 third-lower Problemfall +[ID] 2891 192 third-lower +[ID] 2891 197 half-lower +[ID] 2891 201 third-left +[ID] 2891 205 half-lower +[ID] 2891 212-213 half-lower +[ID] 2891 218 quarter-lowest +[ID] 2891 223 half-lower +[ID] 2891 226 third-lower +[ID] 2891 227 sixth-se Problemfall +[ID] 2891 231 third-lower +[ID] 2891 235 third-right +[ID] 2891 240 third-left +[ID] 2891 244 half-lower +[ID] 2891 247 third-lower +[ID] 2891 248-249 half-upper +[ID] 2891 253 third-lower +[ID] 2891 258 third-left +[ID] 2891 263 half-lower +[ID] 2891 268 third-lower +[ID] 2891 273 quarter-lowest +[ID] 2891 276-277 half-middle Problemfall +[ID] 2891 283 third-upper +[ID] 2891 287 half-lower +[ID] 2891 289 sixth-e Problemfall +[ID] 2891 289 sixth-sw Problemfall +[ID] 2891 290 sixth-nw Problemfall +[ID] 2891 290 sixth-se Problemfall +[ID] 2891 290 sixth-sw Problemfall +[ID] 2891 291 sixth-nw Problemfall +[ID] 2891 291 sixth-se Problemfall +[ID] 2891 291 sixth-sw Problemfall +[ID] 2891 292 sixth-w Problemfall +[ID] 2891 295 sixth-sw Problemfall +[ID] 2891 295 sixth-s Problemfall +[ID] 2891 295 sixth-se Problemfall +[ID] 2891 297 half-lower +[ID] 2891 298 sixth-ne Problemfall +[ID] 2891 298 sixth-e Problemfall +[ID] 2891 298 sixth-se Problemfall +[ID] 2891 301 half-lower +[ID] 2891 302 half-lower +[ID] 2891 305 full +[ID] 2891 307 full +[ID] 2891 313 sixth-e Problemfall +[ID] 2891 316 third-upper Problemfall +[ID] 2891 316 sixth-e Problemfall +[ID] 2891 316 sixth-se Problemfall +[ID] 2891 317 sixth-nw Problemfall +[ID] 2891 317 sixth-w Problemfall +[ID] 2891 317 sixth-sw Problemfall +[ID] 2891 317 sixth-ne Problemfall +[ID] 2891 317 sixth-e Problemfall +[ID] 2891 317 sixth-e Problemfall +[ID] 2891 317 sixth-se Problemfall +[ID] 2891 318 sixth-nw Problemfall +[ID] 2891 318 sixth-w Problemfall +[ID] 2891 318 sixth-sw Problemfall +[ID] 2891 318 sixth-ne Problemfall +[ID] 2891 318 sixth-e Problemfall +[ID] 2891 318 sixth-se Problemfall +[ID] 2891 319 sixth-nw Problemfall +[ID] 2891 319 sixth-ne Problemfall +[ID] 2891 319 sixth-ne Problemfall +[ID] 2891 319 sixth-e Problemfall +[ID] 2891 319 sixth-se Problemfall +[ID] 2891 320 sixth-w Problemfall +[ID] 2891 320 sixth-sw Problemfall +[ID] 2891 320 sixth-ne Problemfall +[ID] 2891 320 sixth-e Problemfall +[ID] 2891 320 sixth-e Problemfall +[ID] 2891 320 third-lower +[ID] 2891 323 half-left Problemfall +[ID] 2891 326 third-lower +[ID] 2891 328 sixth-nw Problemfall +[ID] 2891 328 sixth-nw Problemfall +[ID] 2891 329 third-lower +[ID] 2891 334 third-lower +[ID] 2891 336 third-left +[ID] 2891 338 sixth-w Problemfall +[ID] 2891 340 half-lower Problemfall +[ID] 2891 346 half-left +[ID] 2891 349 half-right +[ID] 2891 350 half-lower +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 376 full SRM 06-02 (3581) +[ID] 3581 cv half-middle +[ID] 3581 6 half-upper +[ID] 3581 13 half-upper +[ID] 3581 17 half-upper +[ID] 3581 27 sixth-ne +[ID] 3581 28 sixth-nw +[ID] 3581 28 sixth-se +[ID] 3581 29 sixth-ne +[ID] 3581 30 third-upper +[ID] 3581 31 third-upper +[ID] 3581 32 third-upper +[ID] 3581 33 third-upper +[ID] 3581 35 center +[ID] 3581 36 center Serrated Edge (4513) +[ID] 4513 cv center +[ID] 4513 back half-right +[ID] 4513 1 full +[ID] 4513 3 full +[ID] 4513 8 half-upper +[ID] 4513 12 third-upper +[ID] 4513 20 half-upper +[ID] 4513 23 full +[ID] 4513 27 half-upper +[ID] 4513 39 full +[ID] 4513 41 half-upper +[ID] 4513 46 half-upper +[ID] 4513 47 full +[ID] 4513 59 full +[ID] 4513 60 full +[ID] 4513 62 center +[ID] 4513 64 half-middle Market Panic (8945) +[ID] 8945 cv center +[ID] 8945 back half-right +[ID] 8945 1 full +[ID] 8945 6-7 half-upper +[ID] 8945 12 half-left +[ID] 8945 16 half-left +[ID] 8945 22 half-upper +[ID] 8945 27 full +[ID] 8945 31 half-upper +[ID] 8945 34 half-upper +[ID] 8945 37 half-upper +[ID] 8945 40 half-left +[ID] 8945 47 half-upper +[ID] 8945 49 half-upper +[ID] 8945 52 half-upper +[ID] 8945 57 half-right +[ID] 8945 61 half-upper +[ID] 8945 65 half-upper +[ID] 8945 67 half-upper +[ID] 8945 69 half-right +[ID] 8945 76 half-left +[ID] 8945 80 half-upper +[ID] 8945 83 half-upper +[ID] 8945 87 full +[ID] 8945 90 half-upper +[ID] 8945 93 half-right +[ID] 8945 99 half-upper +[ID] 8945 103 full +[ID] 8945 106 half-upper +[ID] 8945 112 half-left +[ID] 8945 121 half-right +[ID] 8945 127 half-upper +[ID] 8945 133 full +[ID] 8945 136 half-left +[ID] 8945 147 half-upper +[ID] 8945 161 half-right +[ID] 8945 175 half-upper +[ID] 8945 181 half-right +[ID] 8945 185 half-upper +[ID] 8945 188 half-upper +[ID] 8945 195 half-upper +[ID] 8945 200 half-upper +[ID] 8945 204 half-upper +[ID] 8945 207 full +[ID] 8945 208 full
sources
Kategorie von High Caliber Ops müsste man sich überlegen (analog dazu Underworld vom Shadowrun TCG). Die Videospiele aufzunehmen macht Sinn, wenn wir die Contributors ebenfalls aufnehmen (womit wir ja angefangen haben). Ob die in "sources" gehören oder in eine eigene Tabelle ist eine offene Frage. Auch ob jede Sprachfassung eine eigene ID bekommen soll (besser nicht!?). DLC wie Shadows of Hong Kong braucht eigene IDs, weil sie eigene Credits usw. haben.
+[ID] Shadowrun: Crossfire en card game +[ID] Shadowrun: High Caliber Ops en card game +[ID] Shadowrun: Hong Kong en novel +[ID] Shadowrun (SNES) en video game +[ID] Shadowrun (Mega Drive) en video game +[ID] Shadowrun (Mega-CD) jp video game +[ID] Shadowrun (2007) en video game +[ID] Shadowrun Returns en video game +[ID] Shadowrun: Dragonfall en video game +[ID] Shadowrun: Dragonfall Director's Cut en video game +[ID] Shadowrun: Hong Kong en video game +[ID] Shadowrun Chronicles en video game +[ID] Shadowrun: Shadows of Hong Kong en DLC
Korrektur
Dopplungen?
- 458 - Erich Schreiner
- 4451 - Erich Schriner
- 3077 - Joshua Howell
- 7157 - Joshua Rowell
- 7468 - Larry Almore
- 8047 - Larry Elmore
- 5665 - Jacob Glaser
- 8919 - Jason Glaser