Shadowhelix:Datenbank/Vorschläge
Erweiterung
contributors_referenced_name
458 Erich Schriner -> siehe Dopplungen unten
contributors
INSERT INTO contributors(forename_first) VALUES('Liam.C'); +[ID] Petrov Miroslav
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
contributors_weblink
1588 https://www.facebook.com/groups/114658181901791 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 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 Tristin Ishmael +[ID] http://www.theycallmeishmael.com +[ID] facebook tristin.ishmael +[ID] artstation sailormonkey +[ID] twitter Tristinishmael Kathy Schad +[ID] http://www.kathyschad.de Gary Ruddell +[ID] wpen Gary Ruddell +[ID] aventurica Gary Ruddell +[ID] isfdb-ea 1813 Stephan Martinière +[ID] http://www.martiniere.com +[ID] facebook smartiniere +[ID] twitter smartiniere +[ID] isfdb-ea 23095 Jan Meininghaus +[ID] www.jan-meininghaus.de +[ID] facebook jan.meininghaus +[ID] behance jan-meininghaus Fred Gambino +[ID] http://www.fredgambino.co.uk +[ID] artstation fredgambino +[ID] isfdb-ea 145765 Attila Boros +[ID] isfdb-ea 23140 Thierry Doizon +[ID] http://barontieri.com +[ID] facebook thierry.doizon +[ID] twitter barontieri +[ID] deviantart barontieri +[ID] blogspot barontieri +[ID] tumblr barontieri
contributions
Ich habe sehr viel recherchiert und mittlerweile fast alle Cover-Illustratoren der Romane vollständig. War erstaunlich viel Arbeit, ehrlich gesagt!
Thierry Doizon [+id] 1369 illustration cover art [+id] 1263 illustration cover art Jim Burns [+id] 9040 illustration cover art [+id] 1755 illustration cover art [+id] 9079 illustration cover art [+id] 8810 illustration cover art Jan Meininghaus [+id] 115 illustration cover art Stephan Martinière [+id] 4667 illustration cover art [+id] 9387 illustration cover art Fred Gambino [+id] 6545 illustration cover art Mark Harrison [+id] 1657 illustration cover art Garry Ruddell [+id] 2567 illustration cover art [+id] 8834 illustration cover art [+id] 5065 illustration cover art [+id] 1263 illustration cover art Kathy Schad [+id] 6543 illustration cover art [+id] 6339 illustration cover art Catherine Beck [+id] 1657 text Vorwort Anja Brandel [+id] 1657 text Hunger Olka Hallwasz [+id] 1657 text Nachtschicht Markolf Hoffmann [+id] 1657 text In Poseidons Armen Alice Lengauer [+id] 1657 text Hunger Marion Lohe [+id] 1657 text Geisterstunde Peter Merten [+id] 1657 text Mjölnir Simon Möller [+id] 1657 text Kein großer Verlust Thomas Palmen [+id] 1657 text Rose Florian Schlüter [+id] 1657 text Holometabolie Stefan Sumser [+id] 1657 text Der Todesbote
illustrations_source
Update der Positionsangaben für Shadowrun 2nd. Vorgehen wie bei 3rd.
79682 3497 c2 full 125047 3497 c3 full 195274 3497 c5 full 360974 3497 c4 full 483051 3497 c1 full 498731 3497 c7 full 621387 3497 c8 full 736149 3497 cv full 751092 3497 back half-right 967012 3497 c6 full 480569 3497 1 center 358217 3497 6 third-center 129376 3497 7 third-lower 251748 3497 9 full 435106 3497 10 third-upper 895243 3497 11 full 730924 3497 13 full 890613 3497 15 half-lower 869514 3497 17 half-right 286975 3497 19 center 356140 3497 21 full 706482 3497 25 quarter-ne 74695 3497 27 half-lower 593041 3497 29 quarter-ne 235498 3497 31 full 145602 3497 33 third-upper 948217 3497 35 full 478569 3497 36 quarter-ne 514892 3497 36 quarter-sw 364597 3497 37 quarter-ne 957024 3497 37 quarter-sw 58164 3497 38 half-left 417289 3497 39 full 150742 3497 41 full 419385 3497 44 sixth-nw 160394 3497 47 sixth-w 239746 3497 49 half-right 394056 3497 50 half-left 641705 3497 51 half-right 564073 3497 52 half-left 943162 3497 53 half-right 163487 3497 54 half-left 261739 3497 55 half-right 631254 3497 56 half-left 28649 3497 57 half-right 281976 3497 58 half-left 456731 3497 59 half-right 398645 3497 60 half-left 793146 3497 61 half-right 982740 3497 62 half-left 541603 3497 63 half-right 876032 3497 64 half-left 364285 3497 65 full 461057 3497 67 full 634250 3497 68 quarter-se 569870 3497 69 full 367491 3497 71 quarter-sw 349871 3497 72 sixth-nw 521047 3497 73 quarter-nw 568091 3497 74 sixth-se 28743 3497 77 full 936158 3497 78 quarter-sw 502649 3497 80 quarter-se 690318 3497 83 quarter-nw 923870 3497 85 sixth-e 827519 3497 87 half-left 426805 3497 91 sixth-nw 864157 3497 99 quarter-se 928476 3497 100 half-left 632510 3497 101 sixth-sw 146827 3497 104 half-left 304951 3497 108 half-upper 240973 3497 110 half-left 278465 3497 111 sixth-e 978502 3497 112 quarter-nw 218954 3497 117 full 241680 3497 118 half-lower 98154 3497 120 third-center 138602 3497 121 third-center 790548 3497 122 third-center 963410 3497 126 sixth-ne 941532 3497 129 sixth-nw 928513 3497 130 sixth-nw 697381 3497 134 full 306859 3497 138 center 379642 3497 141 quarter-nw 35497 3497 148 center 531920 3497 150 third-lower 965084 3497 152 half-lower 981563 3497 156 sixth-e 934201 3497 157 sixth-ne 75984 3497 161 full 709348 3497 163 third-upper 38152 3497 164 half-lower 901342 3497 167 quarter-ne 276958 3497 170 sixth-ne 19534 3497 172 quarter-sw 173605 3497 177 sixth-sw 750638 3497 181 full 87916 3497 183 sixth-se 21584 3497 186 third-upper 754829 3497 188 sixth-sw 254731 3497 190 sixth-sw 965821 3497 193 quarter-ne 305462 3497 194 half-lower 301482 3497 196 half-upper 834216 3497 199 sixth-ne 183752 3497 201 full 26374 3497 202 quarter-sw 54728 3497 203 quarter-nw 209764 3497 203 quarter-se 613780 3497 204 quarter-nw 834150 3497 204 quarter-se 684391 3497 205 quarter-nw 846531 3497 205 quarter-se 462073 3497 206 quarter-ne 716035 3497 206 quarter-sw 341928 3497 207 quarter-nw 607235 3497 207 quarter-se 47816 3497 208 quarter-ne 75163 3497 208 quarter-sw 103859 3497 209 quarter-ne 836597 3497 209 quarter-sw 795820 3497 210 quarter-ne 938645 3497 210 quarter-sw 469057 3497 211 quarter-nw 728340 3497 211 quarter-se 590738 3497 212 quarter-ne 965470 3497 212 quarter-sw 864570 3497 213 quarter-ne 984517 3497 213 quarter-sw 213908 3497 215 full 906234 3497 220 third-upper 162534 3497 223 sixth-ne 81463 3497 225 half-right 706345 3497 226 third-lower 269408 3497 229 half-right 570194 3497 237 full 57816 3497 242 sixth-w 54813 3497 243 sixth-w 246839 3497 244 sixth-w 439156 3497 245 third-upper 705692 3497 246 quarter-ne 380516 3497 247 sixth-w 892671 3497 248 sixth-nw 485679 3497 249 quarter-w 240859 3497 250 sixth-sw 136580 3497 251 sixth-ne 490571 3497 251 sixth-se 327150 3497 253 center 526389 3497 265 half-lower 657142 3497 267 full 106784 3497 271 full 637208 3497 273 sixth-se 580712 3497 275 third-upper 29431 3497 277 third-upper 416927 3497 282 sixth-sw 76318 3497 284 full 648371 3497 295 full
Update der Positionsangaben für Shadowrun 3rd. Bei den "Problemfällen" habe ich es einfach bei keiner Positionsangabe belassen, deshalb sind entsprechend nicht alle illu-ids für diese Quelle aufgeführt.
86951 1707 c6 full 293687 1707 c1 full 356981 1707 c4 full 360147 1707 c5 full 471086 1707 c7 full 480136 1707 back quarter-nw 517649 1707 c8 full 609718 1707 back sixth-sw 789123 1707 c3 full 803956 1707 cv full 934761 1707 back sixth-se 983521 1707 c2 full 315762 1707 9 full 961843 1707 13 center 934672 1707 14 half-left 716294 1707 19 half-right 83745 1707 23 full 21643 1707 24 half-upper 704891 1707 27 half-left 905821 1707 33 full 847150 1707 34 quarter-ne 213970 1707 37 full 275360 1707 42 quarter-nw 263957 1707 53 full 27381 1707 64 quarter-ne 703914 1707 65 half-left 336518 1707 66 half-left 279385 1707 67 half-left 991190 1707 68 half-left 634907 1707 69 half-left 482360 1707 70 half-left 275553 1707 71 half-left 927350 1707 72 half-left 426507 1707 73 half-left 384576 1707 74 half-left 683450 1707 75 half-left 816935 1707 76 half-left 812406 1707 77 half-left 812397 1707 78 half-left 345168 1707 79 half-left 875269 1707 80 half-left 374180 1707 83 full 527146 1707 88 half-left 280961 1707 96 half-left 347820 1707 101 full 705819 1707 106 quarter-nw 17263 1707 110 quarter-nw 893274 1707 115 quarter-ne 280941 1707 121 half-upper 198726 1707 127 quarter-ne 419250 1707 131 full 296538 1707 139 full 290385 1707 146 full 621305 1707 152 half-upper 130865 1707 155 full 716253 1707 159 full 586743 1707 165 full 135804 1707 168 half-upper 574109 1707 171 half-right 84362 1707 175 full 490157 1707 179 full 415670 1707 185 full 634925 1707 201 full 260984 1707 208 half-left 37812 1707 213 full 652013 1707 221 quarter-nw 29478 1707 222 quarter-ne 748501 1707 225 half-upper 387452 1707 227 half-right 863507 1707 229 quarter-ne 780916 1707 233 full 765489 1707 243 full 597408 1707 247 full 246198 1707 249 quarter-ne 910276 1707 250 half-left 358907 1707 255 full 172460 1707 258 quarter-nw 305914 1707 261 full 587942 1707 269 sixth-e 46815 1707 271 full 426901 1707 297 half-upper 78193 1707 315 full 98374 1707 325 sixth-nw 745892 1707 325 half-right 215384 1707 326 quarter-nw 453920 1707 326 quarter-ne 851032 1707 326 quarter-sw 869217 1707 326 quarter-se 157823 1707 327 quarter-nw 354208 1707 327 quarter-ne 409285 1707 327 quarter-sw 640823 1707 327 quarter-se 279583 1707 328 quarter-nw 756039 1707 328 quarter-ne 784936 1707 328 quarter-sw 927103 1707 328 quarter-se 135602 1707 329 quarter-nw 306417 1707 329 quarter-ne 592387 1707 329 quarter-sw 836240 1707 329 quarter-se
SR4 Anniversary (vgl. Anmerkungen in der Diskussion; Problemfälle) +[ID] 2891 7 center Problemfall +[ID] 2891 9 quarter-se Problemfall +[ID] 2891 10-11 Problemfall +[ID] 2891 12 half-left Problemfall +[ID] 2891 16 sixth-sw Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 149 Problemfall +[ID] 2891 184 third-lower Problemfall +[ID] 2891 227 sixth-se Problemfall +[ID] 2891 276-277 half-middle Problemfall +[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 298 sixth-ne Problemfall +[ID] 2891 298 sixth-e Problemfall +[ID] 2891 298 sixth-se Problemfall +[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 323 half-left Problemfall +[ID] 2891 328 sixth-nw Problemfall +[ID] 2891 328 sixth-nw Problemfall +[ID] 2891 338 sixth-w Problemfall +[ID] 2891 340 half-lower Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall +[ID] 2891 352 Problemfall
contributions_illustration
Shadowrun 2nd Edition:
5790 79682 8123 125047 5790 195274 1588 360974 4180 483051 4180 498731 1588 621387 8047 736149 5790 751092 8123 967012 5790 480569 1588 358217 4962 251748 5790 895243 8123 730924 4482 890613 5790 869514 8123 286975 5790 356140 9785 74695 5790 593041 1588 235498 8123 145602 4180 948217 4180 478569 4180 514892 4180 364597 4180 957024 4180 58164 4180 417289 8123 150742 4482 419385 8123 160394 1588 239746 1588 394056 1588 641705 1588 564073 1588 943162 1588 163487 1588 261739 1588 631254 1588 28649 1588 281976 1588 456731 1588 398645 1588 793146 1588 982740 1588 541603 1588 876032 5790 461057 9785 634250 8123 569870 9785 367491 8123 349871 9785 521047 4962 28743 8123 936158 8123 502649 5790 690318 5790 827519 1588 426805 3557 864157 8123 928476 3557 632510 4482 146827 9785 304951 5790 240973 1588 278465 1588 978502 1588 218954 1588 241680 1588 98154 1588 138602 1588 790548 1588 963410 8123 941532 1588 928513 5790 697381 4180 379642 1588 35497 9785 531920 4962 965084 3557 981563 3557 934201 8123 75984 1588 709348 8123 38152 4180 19534 8123 173605 4180 750638 8123 87916 1588 21584 3557 754829 9785 254731 4482 965821 8123 305462 9785 301482 4482 834216 8123 183752 5790 26374 1588 54728 1588 209764 1588 613780 1588 834150 1588 684391 1588 846531 1588 462073 1588 716035 1588 341928 1588 607235 1588 47816 1588 75163 1588 103859 1588 836597 1588 795820 1588 938645 1588 469057 1588 728340 1588 590738 1588 965470 1588 864570 1588 984517 5790 213908 1588 906234 4180 162534 4180 706345 1695 269408 4962 570194 3557 57816 5790 54813 8123 246839 8123 439156 8123 705692 1588 380516 8123 485679 1588 240859 9785 526389 1588 657142 1695 106784 9785 637208 5790 580712 8123 29431 4180 416927 5790 76318
Shadowrun 3rd Edition:
1588 86951 6115 293687 1212 356981 6115 360147 1212 471086 3862 480136 3862 517649 9435 609718 5475 789123 2792 803956 9435 934761 5475 983521 6115 316549 1628 16582 1588 315762 1009 192045 2792 934672 4302 716294 5475 173584 2894 83745 1772 21643 5475 905821 3536 847150 1588 275360 4180 894135 4180 375248 4180 625439 4180 325690 4180 650981 2894 263957 9435 27381 9435 703914 9435 336518 4180 279385 9435 991190 9435 634907 9435 482360 9435 275553 3862 927350 9435 426507 9435 384576 2820 683450 1588 816935 9435 812406 9435 812397 4180 345168 9435 875269 4305 374180 1772 527146 1628 568731 1772 347820 4180 705819 4305 17263 3862 893274 2894 280941 6115 198726 6666 308527 2894 419250 2894 296538 4305 290385 2894 621305 1772 130865 6666 254071 1628 297346 1588 716253 5790 586743 5790 135804 3862 574109 3862 84362 1772 490157 5790 628719 3862 415670 2894 307891 4305 634925 1588 260984 1009 279485 3862 37812 4180 652013 4180 29478 1772 748501 1009 387452 3862 863507 2792 861309 1588 765489 5790 597408 2894 246198 3862 910276 5475 897420 5790 358907 7832 943015 7832 305914 7832 687942 7832 587942 2792 158042 2894 16894 2894 426901 2767 792415 2894 78193 3557 176452 4845 84367 6933 132489 773 98374 9435 215384 9435 453920 4180 851032 9435 869217 9435 157823 9435 354208 9435 409285 3862 640823 9435 279583 9435 756039 2820 784936 1588 927103 9435 135602 9435 306417 4180 592387 9435 836240
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 (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