Shadowhelix:Datenbank/Vorschläge
Zur Navigation springen
Zur Suche springen
Erweiterung
contributor_referenced_name
458 Erich Schriner -> siehe Dopplungen unten
contributor
INSERT INTO contributors(forename_first) VALUES('Liam.C');
Shadowrun Online - Portraits
+[ID] Petrov Miroslav
Shadowrun TCG
+[ID] Hudson Heather
+[ID] Ho Patrick
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?
contributor_weblink
Update vom 17.04.:
8869 http://markbulahao.com 879 http://antihelios.de 7323 http://www.artmajeur.com/moulun 7619 http://www.ericdeschamps.com 974 http://www.egerkrans.com 4551 http://www.vasburg.com 5600 http://www.mosingo.com 7717 http://www.fantasycartography.com 8427 http://www.tnielsen.com 1936 http://www.kovah.co.uk 5964 http://www.jamescorywebster.com
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] carbonmade artofmiro +[ID] blogspot soulsart +[ID] deviantart mikeypetrov +[ID] twitter Soulsart +[ID] instagram mikeypetrov +[ID] behance Soulsurvivor Dário Coelho (id missing) +[ID] http://dariocoelho.com +[ID] artstation dariocoelho +[ID] deviantart dariocoelho +[ID] facebook coelhodario +[ID] twitter DarioDraws Attila Boros +[ID] isfdb-ea 145765
contributor_weblink_hosting_service
3808 deviantart greenboxx 3808 artstation mariusz 3808 carbonmade mariuszgandzel 8869 deviantart markbulahao 879 artstation antihelios 7323 deviantart moulunerie 7323 facebook Regis.Moulun.Art 7619 blogspot deschampsart 7619 twitter deschampsart 974 blogspot johan-egerkrans 974 facebook johanegerkranspublic 6190 tumblr marcomazzoni 6190 facebook Marco-Mazzoni-150873907978 6190 instagram marcomazzoniart 4657 deviantart creatorpwned 4657 twitter creatorpwned 4551 twitter evasburg 4551 artstation vasburg 4029 deviantart rhstillwell 1161 facebook atomicdogstudio 6724 artstation donaldcrank 6724 deviantart laskroto 8905 twitter ESBrewerton 8905 twitch EthanSBrewerton 8905 facebook john.zeleznik.7 8905 deviantart zeleznik 8905 artstation zeleznik 2568 facebook Igor-Kieryluk-115707815193569 2568 artstation igorkieryluk 7413 artstation rickotey 7413 facebook rick.otey 7413 deviantart rickotey 7413 cgsociety rickotey 7413 wordpress rickotey 5600 artstation jamesmosingo 5600 tumblr jamesmosingo 5600 deviantart mosingo 8427 facebook TheArtOfTereseNielsen 1936 deviantart kovah 5964 deviantart jamescorywebster 5964 facebook jcorywebster 5964 tumblr jamescorywebster
contribution
Ich habe mal abgeglichen, welche Illustratoren in Contributions pro Quelle stehen und dies verglichen mit den Illustratoren, die in contributions_illustrations pro Quelle angegeben sind. Folgende Einträge fehlen in contributions bislang:
133 19 illustration 4485 19 illustration 6077 19 illustration 7765 19 illustration 3536 80 illustration u 4180 172 illustration u 7645 172 illustration u 1588 789 illustration u 8147 789 illustration 133 869 illustration 6206 869 illustration 6690 869 illustration 133 1046 illustration 3904 1046 illustration 7765 1046 illustration 2520 1160 illustration 5848 1160 illustration 6930 1289 illustration u 6933 1707 illustration u 773 1707 illustration u 1588 1945 illustration u 5747 1945 illustration 5790 1945 illustration u 6666 1945 illustration u 8427 1945 illustration u 1588 2008 illustration 1588 2313 illustration u 2767 2313 illustration u 4180 2313 illustration u 4845 2313 illustration u 7645 2313 illustration u 133 2833 illustration 3098 2833 illustration 6690 2833 illustration 7765 2833 illustration 8147 2833 illustration 1695 2966 illustration u 2620 2966 illustration u 8001 2966 illustration u 8055 3237 illustration u 9785 3237 illustration u 133 3689 illustration 7765 3689 illustration 8046 3689 illustration 5176 4027 illustration u 2520 4038 illustration u 7177 4038 illustration 8051 4038 illustration u 5720 4160 illustration u 8923 4160 illustration u 3402 4190 illustration u 3510 4190 illustration u 6698 4190 illustration u 8964 4190 illustration u 2894 4513 illustration u 40 4630 illustration u 8686 4630 illustration u 133 4661 illustration 4485 4661 illustration 7765 4661 illustration 133 4775 illustration 4485 4775 illustration 7765 4775 illustration 2520 4817 illustration u 7177 4817 illustration 1997 5296 illustration 2520 5296 illustration u 7765 5296 illustration u 133 5662 illustration u 2947 5662 illustration 6357 5662 illustration 7765 5662 illustration 8123 5662 illustration u 133 6086 illustration 2520 6086 illustration 7765 6086 illustration 8109 6202 illustration u 6131 6427 illustration u 1009 6600 illustration u 3034 6600 illustration u 4180 6600 illustration u 5176 6600 illustration u 773 7003 illustration u 133 7403 illustration 4485 7403 illustration 8923 7813 illustration u 133 8001 illustration 3904 8001 illustration 7765 8001 illustration 903 8488 illustration u 2820 8571 illustration u 7645 8571 illustration u 133 8870 illustration 7765 8870 illustration 4180 8945 illustration u 9450 9450 illustration u 1683 9537 illustration 1997 9537 illustration 2520 9537 illustration u 4662 9537 illustration 6550 9537 illustration 133 9871 illustration 4485 9871 illustration 7765 9871 illustration
contribution_illustration
Diverses:
446 475069 1380 859302 1380 367412 7286 425031 7286 821057 8123 356420 1683 716428 Bitte löschen: 133 190487 Folgende IDs zusammenführen (immer jeweils die einzelnen Zeilen zu einer ID): 135482 276194 724391 479016 982740 705649 631927 743528 817034 480593 427598 871964 148950 452136 923057 47918 810629 943160 237906 150843 143695 281436 508619
Safehouses
7162 95432 7905 135296
Corporate Enclaves
7559 208145 830 59427 3904 59427 5665 708423 5665 809653 5665 650721 5747 947513 5665 418296 5665 537198 5747 420836 5665 495362 5665 268703 5665 650829 5665 375082 5665 843076 5665 43876 5665 763289 830 629105 5747 246719 830 168925 830 523647 830 681904 5747 271405 830 961340 830 124976 7162 516283 830 850473 830 174809 830 285761 3904 493510 3904 380176 3904 963784 3904 916243 3904 963285 830 172305 830 104236
Runner Havens
2620 187943 2620 873159 4595 517349 4595 754319 5747 78431 6682 476825 6682 627315 5665 830452 5747 863947 5665 234579 5665 820541 5665 752690 5170 982473 5170 786195 5170 514320 830 403785 5747 580972 830 298614 830 517094 830 417268 830 352167 5747 805631 830 391528 8001 219507 8001 965824 8923 837095 8923 273106 5170 518760
Running Wild
9495 395781 9495 298410 3350 306174 830 842971 756 371568 3350 42856 830 196802 2176 426398 6564 509123 756 398627 6077 398627 756 345692 830 475196 756 348075 6077 348075 756 897625 6077 182076 3350 279801 3350 579312 8818 89631 830 326719 756 538164 830 364087 6564 583490 3350 940152 2176 873164 2176 760145 2400 297651 2176 512978 2176 968314 8818 381764 2176 694857 2176 861542 6564 571208 8818 681527 3350 406891 3350 237045 3350 302195 3350 134208 2176 53846 830 129506 2400 327910 2176 698051 2176 980532 2176 398675 830 721948 4595 604291
Street Legends Supplemental
8227 61982 8227 198742 8227 436197 6927 478061 8147 517364 8227 924136 6927 348651 8147 549018 8580 476259 6927 538762 4485 940623 6927 189645 8227 392714
Street Legends
2280 61982 2280 109542 4485 154386 136 234905 8147 782501 9854 907214 756 673925 766 216930 8580 468923 8686 391850 9727 986034 6631 475891 40 274890 133 76832 6631 289763 6927 526487 766 957106 5837 369148 8147 802674 756 451960 4485 42398 1628 13865 40 810629 8686 943160 5100 473910 8686 809751 766 294371 3904 257083 4485 130958 3904 473596 8147 452136
Man & Machine Cyberware
2820 607259 1772 53721 2820 650128 4180 634178 2280 654803 2280 861974 2280 835204 2280 86319 2280 587392 2280 543721 4302 213508 4302 306487 1009 736219 6115 496025 6115 16475 6115 126398 1009 594286 4305 508392 4305 476803 4305 14738 13 26814 4305 371904 5790 798215 5790 153279 5790 654293 5790 651724 5790 536014 2280 610248 5790 598740 5790 742698 5790 43782 5790 658270 1212 697182 6937 582694 4305 24169 1772 349167 1212 263485 4305 87593 1772 456182 1772 876315
Shadows of North America
4771 493287 4771 216093 6131 743281 2820 438297 1772 716395 1588 613245 3536 327405 3536 521398 2280 583197 2753 346059 4595 658301 2753 352916 2280 705349 2280 37481 2280 713524 3536 820913 2753 792851 1628 596231 1772 415986
Jet Set
707 138942 707 187402 1683 28356 8147 631287 1683 175964 8147 579681 9095 829456 4485 903582 2410 247039 6459 870216 6459 783160 133 723948 9727 193054 766 610539 8580 945780 766 861209 6927 601937 1588 31956 6927 981067 1588 328796 8147 452136 766 563201 766 360897
Dirty Tricks
903 16572 903 810945 4485 435097 133 453091 1588 201859 3098 597314 4485 945387 2331 893125 903 152367 8545 618743 6927 250318 8123 597684 4485 948073 8123 354219 4485 923804 133 813205 2410 178056 2331 932487 766 563201 1588 78396 40 390175
Hazard Pay
2947 150843 2947 143695 4485 183296 133 645198 8123 571042 4485 187629 8123 241698 133 625149 1588 604123 756 281436 8123 612739 4485 598716 8123 901475 1588 582749 4485 640271 1588 51742 2947 386215 1588 794251 4485 291876 8123 708496 8123 825967 756 678290 756 938420 756 508619
Conspiracy Theories
8686 736940 8686 531620 2176 265380 1588 930658 1588 548239 6927 186975 6927 834705 2176 471968 1588 680324 8147 736514 8001 85194 40 942370 5100 509267 7199 384790 5100 435871 5100 950384 3344 978120 5837 537692 8147 923471 1588 860352 6927 976138 8001 671203 1588 105479 756 234761 2483 365108 40 120379 4806 194827 40 576198 3904 729463 5837 710829
Feral Cities
2820 14897 830 206849 830 836921 3536 901283 830 95876 830 564293 830 104785 5514 895370 830 961870 5514 15497 830 841357 830 627530 8109 415267 8109 934280 8109 139048 5514 170634 8109 386195 8109 530218 8109 176495 8109 246095 8109 35472 8109 408219 5514 45612 8109 204357 8109 763214 8109 14563 8109 643170 6115 12469 4595 379160 6115 930524 2820 805963
Emergence
8227 376520 6326 321956 9655 378902 9121 793051 9655 587631 4595 760543 9121 268943 830 47852 830 835016 4595 520384 4595 761293 9655 432867 9655 158974 6326 930768 6326 196237 830 104672 830 502794 9655 873519 6326 185062 6326 748109 9655 65124
illustration_source
War
[+id] 4535 cv full [+id] 4535 back full [+id] 4535 1 full [+id] 4535 8 half-right [+id] 4535 12 half-upper [+id] 4535 19 half-upper [+id] 4535 30 half-upper [+id] 4535 38 half-right [+id] 4535 47 half-left [+id] 4535 48 half-right [+id] 4535 52 full [+id] 4535 54 half-upper [+id] 4535 56 half-right [+id] 4535 58 half-upper [+id] 4535 62 half-left [+id] 4535 67 half-upper 903582 4535 71 half-upper [+id] 4535 74 half-upper [+id] 4535 75 half-right [+id] 4535 82 half-upper [+id] 4535 86 half-upper [+id] 4535 89 half-right [+id] 4535 92 half-upper [+id] 4535 98 half-right [+id] 4535 100 half-upper [+id] 4535 111 half-left [+id] 4535 113 half-upper [+id] 4535 116 full [+id] 4535 124 half-right [+id] 4535 128 full [+id] 4535 131 half-upper [+id] 4535 143 half-upper [+id] 4535 152 half-right [+id] 4535 158 half-upper [+id] 4535 169 half-upper [+id] 4535 171 half-upper
Digital Grimoire:
[+id] 155 4 sixth-sw [+id] 155 15 quarter-nw [+id] 155 16 third-upper
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
source
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