Shadowhelix:Datenbank/Vorschläge: Unterschied zwischen den Versionen

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(62 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 5: Zeile 5:
===contributor_referenced_name===
===contributor_referenced_name===
<pre>
<pre>
458 Erich Schriner
o74849335 Erich Schriner
-> siehe Dopplungen unten
-> siehe Dopplungen unten
</pre>
</pre>
Zeile 21: Zeile 21:
+[ID] Hudson Heather
+[ID] Hudson Heather
+[ID] Ho Patrick
+[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




Zeile 35: Zeile 30:
Update vom 17.04.:
Update vom 17.04.:
<pre>
<pre>
8869 http://markbulahao.com
o88639178 http://www.egerkrans.com
879 http://antihelios.de
o82535164 http://www.fantasycartography.com
7323 http://www.artmajeur.com/moulun
o56238222 http://www.tnielsen.com
7619 http://www.ericdeschamps.com
o99690872 http://www.kovah.co.uk
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
</pre>
</pre>


<pre>
<pre>
1588 https://www.facebook.com/groups/114658181901791
o92075069 https://www.facebook.com/groups/114658181901791




Heather Hudson
Heather Hudson
+[ID] http://www.studiowondercabinet.com
+[ID] http://www.studiowondercabinet.com




Liam C.
Liam C.
+[ID] http://atomiccolossus.com/blacksunpress.net/liam
+[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
Attila Boros
+[ID] isfdb-ea 145765
+[ID] isfdb-ea 145765
</pre>
</pre>


===contributor_weblink_hosting_service===
===contributor_weblink_hosting_service===
<pre>
<pre>
3808 deviantart greenboxx
Miroslav Petrov
3808 artstation mariusz
+[ID] carbonmade artofmiro
3808 carbonmade mariuszgandzel
+[ID] blogspot soulsart
8869 deviantart markbulahao
+[ID] deviantart mikeypetrov
879 artstation antihelios
+[ID] twitter Soulsart
7323 deviantart moulunerie
+[ID] instagram mikeypetrov
7323 facebook Regis.Moulun.Art
+[ID] behance Soulsurvivor
7619 blogspot deschampsart
 
7619 twitter deschampsart
o88639178 blogspot johan-egerkrans
974 blogspot johan-egerkrans
o88639178 facebook johanegerkranspublic
974 facebook johanegerkranspublic
o86535591 deviantart creatorpwned
6190 tumblr marcomazzoni
o86535591 twitter creatorpwned
6190 facebook Marco-Mazzoni-150873907978
o98219748 deviantart rhstillwell
6190 instagram marcomazzoniart
o31480053 facebook atomicdogstudio
4657 deviantart creatorpwned
o96311682 artstation donaldcrank
4657 twitter creatorpwned
o96311682 deviantart laskroto
4551 twitter evasburg
o06663545 facebook Igor-Kieryluk-115707815193569
4551 artstation vasburg
o06663545 artstation igorkieryluk
4029 deviantart rhstillwell
o56238222 facebook TheArtOfTereseNielsen
1161 facebook atomicdogstudio
o99690872 deviantart kovah
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
</pre>
</pre>


===contribution===
===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:
<pre>
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
</pre>


===contribution_illustration===
===contribution_illustration===
<pre>
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
</pre>


===illustration_source===
===illustration_source===
War
<pre>
[+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
</pre>


Digital Grimoire:
===source===
<pre>
 
[+id] 155 4 sixth-sw
===person===
[+id] 155 15 quarter-nw
 
[+id] 155 16 third-upper
===index_illustration_person===
</pre>


<pre>
===Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis===
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
</pre>


===source===
{| class="sortable infotable" style="width:80%;"
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.
!Seite
<pre>
!<tt>id_illustration</tt>
+[ID] Shadowrun: Crossfire en card game
!Illustrator
+[ID] Shadowrun: High Caliber Ops en card game
! width="20px" class="unsortable" |
+[ID] Shadowrun (SNES) en video game
!Beschreibung
+[ID] Shadowrun (Mega Drive) en video game
! class="unsortable" |In anderen Quellen
+[ID] Shadowrun (Mega-CD) jp video game
!Link
+[ID] Shadowrun (2007) en video game
|-
+[ID] Shadowrun Returns en video game
| 57
+[ID] Shadowrun: Dragonfall en video game
| <tt>o90089495</tt>
+[ID] Shadowrun: Dragonfall Director's Cut en video game
| {{Beitrag|Peter Bergting}}
+[ID] Shadowrun: Hong Kong en video game
| {{Bildpos|halbseitig-oben}}
+[ID] Shadowrun Chronicles en video game
|
+[ID] Shadowrun: Shadows of Hong Kong en DLC
|
</pre>
|
|-
| 117
| <tt>o33089634</tt>
| {{Beitrag|Matthew Plog}}
| {{Bildpos|zentral}}
|
|
|
|}


==Korrektur==
==Korrektur==


===Dopplungen?===
===Dopplungen?===
*458 - Erich Schreiner
*o54370744 - Erich Schreiner
*4451 - Erich Schriner
*o74849335 - Erich Schriner


*3077 - Joshua Howell
*o18673530 - Joshua Rowell
*7157 - Joshua Rowell
*o71434220 - Joshua Howell


*7468 - Larry Almore
*o27230860 - Larry Elmore
*8047 - Larry Elmore
*o99306142 - Larry Almore


*5665 - Jacob Glaser
*o37485828 - Jason Glaser
*8919 - Jason Glaser
*o84801958 - Jacob Glaser
 
===illustration_source - SR4A - Nachbesserung?===
<pre>
SR4 Anniversary - Problemfälle
 
o98272277 o12707240 7 center
o00641309 o12707240 9 quarter-se
o04784315 o12707240 10-11
o55415857 o12707240 12 half-left
o62812497 o12707240 16 sixth-sw
o14366808 o12707240 149
o85439368 o12707240 149
o18799018 o12707240 149
o14174178 o12707240 149
o29144640 o12707240 149
o48673075 o12707240 184 third-lower
o09249117 o12707240 227 sixth-se
o16843224 o12707240 276-277 half-middle
o07936949 o12707240 289 sixth-e
o79449910 o12707240 289 sixth-sw
o39980495 o12707240 290 sixth-nw
o52972497 o12707240 290 sixth-se
o96070203 o12707240 290 sixth-sw
o88185547 o12707240 291 sixth-nw
o54989489 o12707240 291 sixth-se
o01416068 o12707240 291 sixth-sw
o21311860 o12707240 292 sixth-w
o72478362 o12707240 295 sixth-sw
o67281993 o12707240 295 sixth-s
o46586461 o12707240 295 sixth-se
o30090570 o12707240 298 sixth-ne
o76288784 o12707240 298 sixth-e
o06652943 o12707240 298 sixth-se
o68675635 o12707240 313 sixth-e
o15536689 o12707240 316 third-upper
o82256089 o12707240 316 sixth-e
o75345164 o12707240 316 sixth-se
o93486866 o12707240 317 sixth-nw
o45624372 o12707240 317 sixth-w
o68284015 o12707240 317 sixth-sw
o55247081 o12707240 317 sixth-ne
o32676210 o12707240 317 sixth-e
o99826701 o12707240 317 sixth-e
o67742415 o12707240 317 sixth-se
o94075149 o12707240 318 sixth-nw
o27817328 o12707240 318 sixth-w
o49611614 o12707240 318 sixth-sw
o18935698 o12707240 318 sixth-ne
o50516876 o12707240 318 sixth-e
o78425362 o12707240 318 sixth-se
o27816328 o12707240 319 sixth-nw
o13922757 o12707240 319 sixth-ne
o94361424 o12707240 319 sixth-ne
o22494674 o12707240 319 sixth-e
o18675122 o12707240 319 sixth-se
o41583079 o12707240 320 sixth-w
o05449266 o12707240 320 sixth-sw
o14674670 o12707240 320 sixth-ne
o02118397 o12707240 320 sixth-e
o48378604 o12707240 320 sixth-e
o91665240 o12707240 323 half-left
o71616674 o12707240 328 sixth-nw
o03546821 o12707240 328 sixth-nw
o91115812 o12707240 338 sixth-w
o56783590 o12707240 340 half-lower
o72496299 o12707240 352
o33113938 o12707240 352
o47383757 o12707240 352
o85339763 o12707240 352
o51043392 o12707240 352
o04207178 o12707240 352
</pre>

Aktuelle Version vom 15. März 2018, 13:16 Uhr

Shadowhelix:Datenbank

Erweiterung

contributor_referenced_name

o74849335	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				


Tomek Wrotek (Lockdown)
-- Wrotek ein Anagram von Tworek?

contributor_weblink

Update vom 17.04.: 

o88639178	http://www.egerkrans.com		
o82535164	http://www.fantasycartography.com		
o56238222	http://www.tnielsen.com		
o99690872	http://www.kovah.co.uk		

o92075069	https://www.facebook.com/groups/114658181901791		


Heather Hudson
+[ID]	http://www.studiowondercabinet.com		


Liam C.
+[ID]	http://atomiccolossus.com/blacksunpress.net/liam		


Attila Boros
+[ID]	isfdb-ea	145765

contributor_weblink_hosting_service

Miroslav Petrov
+[ID]	carbonmade	artofmiro		
+[ID]	blogspot	soulsart		
+[ID]	deviantart	mikeypetrov		
+[ID]	twitter	Soulsart		
+[ID]	instagram	mikeypetrov		
+[ID]	behance	Soulsurvivor		

o88639178	blogspot	johan-egerkrans		
o88639178	facebook	johanegerkranspublic			
o86535591	deviantart	creatorpwned		
o86535591	twitter	creatorpwned		
o98219748	deviantart	rhstillwell		
o31480053	facebook	atomicdogstudio		
o96311682	artstation	donaldcrank		
o96311682	deviantart	laskroto		
o06663545	facebook	Igor-Kieryluk-115707815193569		
o06663545	artstation	igorkieryluk		
o56238222	facebook	TheArtOfTereseNielsen		
o99690872	deviantart	kovah

contribution

contribution_illustration

illustration_source

source

person

index_illustration_person

Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis

Seite id_illustration Illustrator Beschreibung In anderen Quellen Link
57 o90089495 Peter Bergting
117 o33089634 Matthew Plog

Korrektur

Dopplungen?

  • o54370744 - Erich Schreiner
  • o74849335 - Erich Schriner
  • o18673530 - Joshua Rowell
  • o71434220 - Joshua Howell
  • o27230860 - Larry Elmore
  • o99306142 - Larry Almore
  • o37485828 - Jason Glaser
  • o84801958 - Jacob Glaser

illustration_source - SR4A - Nachbesserung?

SR4 Anniversary - Problemfälle

o98272277	o12707240				7		center		
o00641309	o12707240				9		quarter-se		
o04784315	o12707240				10-11				
o55415857	o12707240				12		half-left		
o62812497	o12707240				16		sixth-sw		
o14366808	o12707240				149				
o85439368	o12707240				149				
o18799018	o12707240				149				
o14174178	o12707240				149				
o29144640	o12707240				149				
o48673075	o12707240				184		third-lower		
o09249117	o12707240				227		sixth-se		
o16843224	o12707240				276-277		half-middle		
o07936949	o12707240				289		sixth-e		
o79449910	o12707240				289		sixth-sw		
o39980495	o12707240				290		sixth-nw		
o52972497	o12707240				290		sixth-se		
o96070203	o12707240				290		sixth-sw		
o88185547	o12707240				291		sixth-nw		
o54989489	o12707240				291		sixth-se		
o01416068	o12707240				291		sixth-sw		
o21311860	o12707240				292		sixth-w		
o72478362	o12707240				295		sixth-sw		
o67281993	o12707240				295		sixth-s		
o46586461	o12707240				295		sixth-se		
o30090570	o12707240				298		sixth-ne		
o76288784	o12707240				298		sixth-e		
o06652943	o12707240				298		sixth-se		
o68675635	o12707240				313		sixth-e		
o15536689	o12707240				316		third-upper		
o82256089	o12707240				316		sixth-e		
o75345164	o12707240				316		sixth-se		
o93486866	o12707240				317		sixth-nw		
o45624372	o12707240				317		sixth-w			
o68284015	o12707240				317		sixth-sw		
o55247081	o12707240				317		sixth-ne		
o32676210	o12707240				317		sixth-e		
o99826701	o12707240				317		sixth-e		
o67742415	o12707240				317		sixth-se		
o94075149	o12707240				318		sixth-nw		
o27817328	o12707240				318		sixth-w			
o49611614	o12707240				318		sixth-sw		
o18935698	o12707240				318		sixth-ne		
o50516876	o12707240				318		sixth-e		
o78425362	o12707240				318		sixth-se		
o27816328	o12707240				319		sixth-nw		
o13922757	o12707240				319		sixth-ne		
o94361424	o12707240				319		sixth-ne		
o22494674	o12707240				319		sixth-e		
o18675122	o12707240				319		sixth-se		
o41583079	o12707240				320		sixth-w		
o05449266	o12707240				320		sixth-sw		
o14674670	o12707240				320		sixth-ne		
o02118397	o12707240				320		sixth-e		
o48378604	o12707240				320		sixth-e		
o91665240	o12707240				323		half-left		
o71616674	o12707240				328		sixth-nw		
o03546821	o12707240				328		sixth-nw		
o91115812	o12707240				338		sixth-w		
o56783590	o12707240				340		half-lower		
o72496299	o12707240				352				
o33113938	o12707240				352				
o47383757	o12707240				352				
o85339763	o12707240				352				
o51043392	o12707240				352				
o04207178	o12707240				352
Abgerufen von „https://shadowhelix.de/index.php?title=Shadowhelix:Datenbank/Vorschläge&oldid=233445“