Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen
Loki (Diskussion | Beiträge) |
|||
Zeile 271: | Zeile 271: | ||
===contributions_illustration=== | ===contributions_illustration=== | ||
Runners Companion (825), Shadows of Asia (1945), SRM 06-02 (3581), Serrated Edge (4513), Market Panic (8945) | |||
<pre> | |||
9243 109375 | |||
9243 463502 | |||
9243 406351 | |||
830 174903 | |||
830 650917 | |||
8109 954067 | |||
8109 468032 | |||
8109 231685 | |||
5170 790823 | |||
5170 140783 | |||
5170 547096 | |||
3904 407165 | |||
3904 653914 | |||
3904 239675 | |||
3904 473980 | |||
830 702359 | |||
830 925873 | |||
830 957680 | |||
6666 509162 | |||
6666 137958 | |||
6666 715682 | |||
4180 102635 | |||
532 840935 | |||
6115 958603 | |||
8923 978450 | |||
5747 673142 | |||
8919 538794 | |||
8919 503192 | |||
5790 385164 | |||
4595 56182 | |||
5747 712583 | |||
8923 193540 | |||
830 279840 | |||
830 241078 | |||
8427 135278 | |||
5747 438671 | |||
9572 97285 | |||
9572 874602 | |||
9572 270589 | |||
6666 632759 | |||
8923 794210 | |||
5747 374265 | |||
5747 150639 | |||
3536 94257 | |||
3536 473098 | |||
5747 618543 | |||
5747 870193 | |||
1588 109528 | |||
2320 294570 | |||
5747 389751 | |||
5170 140573 | |||
5170 347192 | |||
5170 765049 | |||
5747 693827 | |||
5170 932147 | |||
8923 923715 | |||
8923 496073 | |||
8923 89567 | |||
7177 872516 | |||
7177 825061 | |||
7177 482963 | |||
7177 236501 | |||
2520 791648 | |||
2520 481239 | |||
2520 719528 | |||
2520 123698 | |||
2520 816593 | |||
2520 350829 | |||
2520 134950 | |||
2520 92143 | |||
6573 51429 | |||
6573 482179 | |||
6573 597463 | |||
6573 615408 | |||
903 163840 | |||
6131 692314 | |||
2894 634502 | |||
5176 154398 | |||
903 128694 | |||
4595 216584 | |||
7177 14756 | |||
7177 598706 | |||
8545 194852 | |||
8545 386251 | |||
8545 96142 | |||
133 120654 | |||
903 264073 | |||
7186 473089 | |||
6573 308192 | |||
4180 410398 | |||
133 35194 | |||
4485 984210 | |||
903 590317 | |||
133 421358 | |||
3402 471890 | |||
8545 695247 | |||
8545 478253 | |||
2513 386951 | |||
8545 907683 | |||
</pre> | |||
===sources=== | ===sources=== |
Version vom 24. März 2016, 18:34 Uhr
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
contributions
Ich habe mich mal der Romane und Sammelbände angenommen, vorerst nur der Englischen:
156 5362 text Wetwork 156 1957 text The Breach 188 1957 text Rune’s Avatar Café 673 5362 text No Such Luck 903 2017 cover art 903 4731 cover art 903 4635 cover art 903 3218 cover art 903 5887 cover art 903 1957 cover art 1366 6494 text A Plague of Demons 1366 6494 text Free Fall 1588 6494 illustration 1711 1957 text House of Cards 2033 7094 cover art 2179 5362 text Snake in the City 2820 658 cover art 2820 3488 cover art 2820 1797 cover art 2820 9281 cover art 2820 7792 cover art 2820 2897 cover art 2820 6851 cover art 2830 4689 text 2830 6494 text Would it Help to Say I'm Sorry? 2830 6494 text It's All Done with Mirrors 2830 5362 text Better to Reign 2830 1957 text Images: A Wolf and Raven Story 3082 1957 text A Life on the Line 3242 5362 cover art 3255 5362 text Fade Away 3580 52 cover art 3580 8583 cover art 3580 6711 cover art 3580 8447 cover art 3580 4577 cover art 3580 4689 cover art 3610 8510 text 3633 6494 text Striper 3862 6494 illustration 3898 6494 text Into the Shadows 4174 6494 text Tailchaser 4180 6494 illustration 4705 5362 text Trade Secrets 4705 1957 text Swamp of Spirits 5110 6494 text Turtle In the Tower 5303 1957 text Holiday 5437 1957 text The Cost of Science 5917 8510 cover art 6020 1957 text Social Engineering 6131 1053 cover art 6131 9710 cover art 6131 418 cover art 6131 6062 cover art 6131 4104 cover art 6244 773 cover art 6244 82 cover art 6244 1316 cover art 6244 5561 cover art 6244 6494 cover art 6346 3490 cover art 6346 9097 cover art 6346 9862 cover art 6346 4572 cover art 6346 1370 cover art 6409 6494 illustration 6409 6494 text Graverobbers 6776 5362 text Bloody Fingers 7015 6494 text Prologue 7456 1957 text Queen for a Minute 7832 6494 illustration 8013 1957 text Sweating Bullets 8123 4954 cover art 8463 5887 text 8463 1957 text Nothing Personal 8493 5362 text Better Than 8493 1957 text Bottom of the Ninth 8545 6955 cover art 8817 5362 text Caliban 8817 1957 text The Art of the Steal 8820 5362 text Expectations 8865 5362 text The Good Fight 9178 5362 text Introduction 9178 1957 text Introduction 9243 5364 cover art 9243 5803 cover art 9243 7702 cover art 9243 355 cover art 9367 1957 text Thunderstruck 6511 7639 cover art 6511 5258 cover art 1959 5362 text In Memory Of 5488 5362 text The Art of Diving in the Dark 1764 5362 text Where the Shadows are Darkest 3053 5362 text Big Jake 7582 5362 text Dead Names 7453 6494 text Whitechapel Rose 6497 2792 cover art 6497 1029 cover art 6497 2269 cover art 6497 4077 cover art 1582 1851 cover art 3805 482 cover art 6820 7467 cover art 6820 7645 cover art 2381 1957 text Revenge is a Dish Best Served by Proxy 5386 1957 text It's Nice to Be Wanted 7594 1957 text Keeping Up With Mr. Johnson
illustrations_source
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
Runners Companion (825), Shadows of Asia (1945), SRM 06-02 (3581), Serrated Edge (4513), Market Panic (8945)
9243 109375 9243 463502 9243 406351 830 174903 830 650917 8109 954067 8109 468032 8109 231685 5170 790823 5170 140783 5170 547096 3904 407165 3904 653914 3904 239675 3904 473980 830 702359 830 925873 830 957680 6666 509162 6666 137958 6666 715682 4180 102635 532 840935 6115 958603 8923 978450 5747 673142 8919 538794 8919 503192 5790 385164 4595 56182 5747 712583 8923 193540 830 279840 830 241078 8427 135278 5747 438671 9572 97285 9572 874602 9572 270589 6666 632759 8923 794210 5747 374265 5747 150639 3536 94257 3536 473098 5747 618543 5747 870193 1588 109528 2320 294570 5747 389751 5170 140573 5170 347192 5170 765049 5747 693827 5170 932147 8923 923715 8923 496073 8923 89567 7177 872516 7177 825061 7177 482963 7177 236501 2520 791648 2520 481239 2520 719528 2520 123698 2520 816593 2520 350829 2520 134950 2520 92143 6573 51429 6573 482179 6573 597463 6573 615408 903 163840 6131 692314 2894 634502 5176 154398 903 128694 4595 216584 7177 14756 7177 598706 8545 194852 8545 386251 8545 96142 133 120654 903 264073 7186 473089 6573 308192 4180 410398 133 35194 4485 984210 903 590317 133 421358 3402 471890 8545 695247 8545 478253 2513 386951 8545 907683
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