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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(→‎illustration_source: +Year of the Comet)
Keine Bearbeitungszusammenfassung
 
(40 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>
7323 http://www.artmajeur.com/moulun
o88639178 http://www.egerkrans.com
974 http://www.egerkrans.com
o82535164 http://www.fantasycartography.com
7717 http://www.fantasycartography.com
o56238222 http://www.tnielsen.com
8427 http://www.tnielsen.com
o99690872 http://www.kovah.co.uk
1936 http://www.kovah.co.uk
</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
 
 
Dário Coelho
+[ID] http://dariocoelho.com




Attila Boros
Attila Boros
+[ID] isfdb-ea 145765
+[ID] isfdb-ea 145765
</pre>
</pre>


===contributor_weblink_hosting_service===
===contributor_weblink_hosting_service===
<pre>
<pre>
Dário Coelho
+[ID] artstation dariocoelho
+[ID] deviantart dariocoelho
+[ID] facebook coelhodario
+[ID] twitter DarioDraws
Miroslav Petrov
Miroslav Petrov
+[ID] carbonmade artofmiro
+[ID] carbonmade artofmiro
+[ID] blogspot soulsart
+[ID] blogspot soulsart
+[ID] deviantart mikeypetrov
+[ID] deviantart mikeypetrov
+[ID] twitter Soulsart
+[ID] twitter Soulsart
+[ID] instagram mikeypetrov
+[ID] instagram mikeypetrov
+[ID] behance Soulsurvivor
+[ID] behance Soulsurvivor


3808 deviantart greenboxx
o88639178 blogspot johan-egerkrans
3808 artstation mariusz
o88639178 facebook johanegerkranspublic
3808 carbonmade mariuszgandzel
o86535591 deviantart creatorpwned
7323 deviantart moulunerie
o86535591 twitter creatorpwned
7323 facebook Regis.Moulun.Art
o98219748 deviantart rhstillwell
974 blogspot johan-egerkrans
o31480053 facebook atomicdogstudio
974 facebook johanegerkranspublic
o96311682 artstation donaldcrank
6190 tumblr marcomazzoni
o96311682 deviantart laskroto
6190 facebook Marco-Mazzoni-150873907978
o06663545 facebook Igor-Kieryluk-115707815193569
6190 instagram marcomazzoniart
o06663545 artstation igorkieryluk
4657 deviantart creatorpwned
o56238222 facebook TheArtOfTereseNielsen
4657 twitter creatorpwned
o99690872 deviantart kovah
4029 deviantart rhstillwell
1161 facebook atomicdogstudio
6724 artstation donaldcrank
6724 deviantart laskroto
2568 facebook Igor-Kieryluk-115707815193569
2568 artstation igorkieryluk
8427 facebook TheArtOfTereseNielsen
1936 deviantart kovah
</pre>
</pre>


Zeile 103: Zeile 79:


===contribution_illustration===
===contribution_illustration===
<pre>
Attitude:
8227 816504
8227 579462
830 28763
7064 506819
830 734820
8995 539214
8094 764283
830 674319
830 630187
9854 572314
1413 657901
830 618752
3510 965312
830 327986
830 209831
6631 680957
6631 928457
8995 38146
830 403768
8227 918675
7064 318659
3510 124690
9854 672948
3344 746205


Splintered State:
===illustration_source===
5167 543278
5167 825147
4485 108274
4485 583176
133 830546
7717 124078
8653 368570
7717 209478
133 250187
8147 450281
4485 809375
8653 247539


War:
===source===
8219 681942
</pre>


Folgende illustration IDs bitte zusammenführen (die Abbildungen der Kontakte könntest du direkt auch über index_illustration_person zuordnen, wenn du magst (vgl. Erweiterungen von persons):
===person===
<pre>
Mac Callister:
491038 61375 72453 937124 214793 975021 237956 431580 318409 459367 524169
Laurent Nazaire:
509321 348106 540381 694817 892136 412659 584321
Moreau:
126498 742189 736021 862403 530912 893604
Tosh Athack:
528346 549768 75961 782946 725904 457298 476518 736982
Athena Tatopoulos:
631425 690327 356492 532106 157086 72496 75813 265791 234586 308942 835126 372645
Joe Martin:
16874 465927 61538 920651 431702 920635 13946 872361 581629 491082 976814 416780
Pip:
274918 672504
Lin Yao Chang:
95678 361574 312897 796523
Simon Andrews (AAS):
195403 524670 906534 134786
James Grey:
57618 896531
Fiona Craig:
195736 586794 354198
Simon Andrews (DW):
219548 120867 301248 592836 42918
Vanessa Rodriguez (Quantum Princess):
964532 503268
Nick Ryder:
214736 461708
Becky 99:
346289 430985
Sid Gambetti:
689104 984570 26319 914673
Matt Wrath:
251379 467520
Martin Tate:
814523 768419
Goober:
698173 18657 256804
Lothan the Wise:
580716 523746 482036
Sarah Silverleaf:
687304 215783 420813
</pre>
 
===illustration_source===
<pre>
Year of the Comet
685794 2041 1 full
413950 2041 7 full
49528 2041 12 half-upper
179342 2041 17 quarter-ne
310285 2041 20 half-upper
820746 2041 23 full
368291 2041 28 center
806943 2041 29 center
293184 2041 33 half-left
67381 2041 37 quarter-nw
432970 2041 37 quarter-e
508197 2041 38 quarter-nw
58946 2041 39 quarter-w
396802 2041 39 quarter-ne
865247 2041 40 quarter-ne
278463 2041 43 full
253860 2041 47 half-upper
130594 2041 52 half-upper
720954 2041 57 full
789062 2041 62 half-upper
486539 2041 67 half-right
538264 2041 72 half-left
369458 2041 77 full
586092 2041 83 half-upper
170486 2041 87 half-upper
290154 2041 99 full
239150 2041 103 center
18235 2041 107 full
684302 2041 117 full
854076 2041 122 half-upper
697014 2041 127 full
302876 2041 135 full
413027 2041 137 sixth-ne
308196 2041 147 half-right
140528 2041 150 half-left
 
Attitude:
816504 9388 cover-back full
579462 9388 1 full
28763 9388 8 full
506819 9388 10 half-upper
65942 9388 14 full
254187 9388 21 half-left
734820 9388 25 full
267540 9388 29 half-upper
539214 9388 39 full
172403 9388 42 half-left
764283 9388 46 full
398402 9388 48 half-left
251069 9388 53 quarter-sw
674319 9388 57 half-upper
630187 9388 64 full
572314 9388 69 half-upper
657901 9388 73 half-upper
618752 9388 77 full
965312 9388 86 half-upper
327986 9388 89 full
501938 9388 97 half-upper
210756 9388 101 half-left
209831 9388 104 half-right
680957 9388 109 full
928457 9388 113 half-upper
815072 9388 119 full
502849 9388 126 half-left
38146 9388 131 full
403768 9388 134 half-right
405986 9388 139 half-upper
716905 9388 140 quarter-se
976054 9388 142 quarter-se
918675 9388 144 quarter-nw
570236 9388 146 quarter-nw
318659 9388 148 quarter-nw
402197 9388 149 half-right
124690 9388 152 full
672948 9388 158 half-upper
746205 9388 165 half-upper


Splintered State
===index_illustration_person===
543278 6856 back half-right
825147 6856 1 full
108274 6856 12 half-upper
942380 6856 14 half-left
583176 6856 22 half-left
830546 6856 26 sixth-se
590481 6856 29 half-upper
124078 6856 31 half-upper
368570 6856 36 half-upper
713569 6856 43 half-upper
209478 6856 48 half-upper
674928 6856 52 sixth-sw
869435 6856 56 quarter-ne
250187 6856 57 quarter-sw
376419 6856 58 quarter-nw
450281 6856 58 quarter-se
809375 6856 60 quarter-sw
863901 6856 61 full
247539 6856 63 half-right
</pre>


===source===
===Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis===


===person===
{| class="sortable infotable" style="width:80%;"
Ich vermisse in dieser Tabelle den Metatyp. Vorstellbar wären ferner Beruf und Geburtsjahr...
!Seite
<pre>
!<tt>id_illustration</tt>
[+id] Laurent Nazaire m
!Illustrator
[+id] Tosh Athack m
! width="20px" class="unsortable" |
[+id] Moreau m
!Beschreibung
[+id] Athena Tatopoulos f
! class="unsortable" |In anderen Quellen
[+id] Joe Martin m
!Link
[+id] Pip m
|-
[+id] Johnny "Junior" Torinni m
| 57
[+id] Lin Yao Chang m
| <tt>o90089495</tt>
[+id] Simon Andrews m
| {{Beitrag|Peter Bergting}}
[+id] James Grey m
| {{Bildpos|halbseitig-oben}}
[+id] Johnny Altenburg m
|
[+id] Fiona Craig f
|
[+id] Quantum Princess / Vanessa Rodriguez f
|
[+id] Nick Ryder m
|-
[+id] Juan Xihuitl m
| 117
[+id] Sid Gambetti m
| <tt>o33089634</tt>
[+id] Matt Wrath m
| {{Beitrag|Matthew Plog}}
[+id] Martin Tate m
| {{Bildpos|zentral}}
[+id] Becky 99 f
|
[+id] Gobber m
|
[+id] Lothan the Wise m
|
[+id] Maggie Goldberg f
|}
[+id] Sarah Silverleaf f
</pre>


==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?===
===illustration_source - SR4A - Nachbesserung?===
Zeile 345: Zeile 135:
SR4 Anniversary - Problemfälle
SR4 Anniversary - Problemfälle


284506 2891 7 center
o98272277 o12707240 7 center
628591 2891 9 quarter-se
o00641309 o12707240 9 quarter-se
308249 2891 10-11
o04784315 o12707240 10-11
79285 2891 12 half-left
o55415857 o12707240 12 half-left
507219 2891 16 sixth-sw
o62812497 o12707240 16 sixth-sw
408165 2891 149
o14366808 o12707240 149
924570 2891 149
o85439368 o12707240 149
913580 2891 149
o18799018 o12707240 149
746391 2891 149
o14174178 o12707240 149
523640 2891 149
o29144640 o12707240 149
521046 2891 184 third-lower
o48673075 o12707240 184 third-lower
163280 2891 227 sixth-se
o09249117 o12707240 227 sixth-se
79384 2891 276-277 half-middle
o16843224 o12707240 276-277 half-middle
460287 2891 289 sixth-e
o07936949 o12707240 289 sixth-e
934056 2891 289 sixth-sw
o79449910 o12707240 289 sixth-sw
210547 2891 290 sixth-nw
o39980495 o12707240 290 sixth-nw
87369 2891 290 sixth-se
o52972497 o12707240 290 sixth-se
483910 2891 290 sixth-sw
o96070203 o12707240 290 sixth-sw
745093 2891 291 sixth-nw
o88185547 o12707240 291 sixth-nw
243150 2891 291 sixth-se
o54989489 o12707240 291 sixth-se
824096 2891 291 sixth-sw
o01416068 o12707240 291 sixth-sw
358769 2891 292 sixth-w
o21311860 o12707240 292 sixth-w
471260 2891 295 sixth-sw
o72478362 o12707240 295 sixth-sw
954860 2891 295 sixth-s
o67281993 o12707240 295 sixth-s
406297 2891 295 sixth-se
o46586461 o12707240 295 sixth-se
764058 2891 298 sixth-ne
o30090570 o12707240 298 sixth-ne
563120 2891 298 sixth-e
o76288784 o12707240 298 sixth-e
129568 2891 298 sixth-se
o06652943 o12707240 298 sixth-se
502798 2891 313 sixth-e
o68675635 o12707240 313 sixth-e
468372 2891 316 third-upper
o15536689 o12707240 316 third-upper
319602 2891 316 sixth-e
o82256089 o12707240 316 sixth-e
852104 2891 316 sixth-se
o75345164 o12707240 316 sixth-se
84521 2891 317 sixth-nw
o93486866 o12707240 317 sixth-nw
42657 2891 317 sixth-w
o45624372 o12707240 317 sixth-w
823650 2891 317 sixth-sw
o68284015 o12707240 317 sixth-sw
789120 2891 317 sixth-ne
o55247081 o12707240 317 sixth-ne
862309 2891 317 sixth-e
o32676210 o12707240 317 sixth-e
408932 2891 317 sixth-e
o99826701 o12707240 317 sixth-e
19562 2891 317 sixth-se
o67742415 o12707240 317 sixth-se
439601 2891 318 sixth-nw
o94075149 o12707240 318 sixth-nw
426958 2891 318 sixth-w
o27817328 o12707240 318 sixth-w
517849 2891 318 sixth-sw
o49611614 o12707240 318 sixth-sw
573849 2891 318 sixth-ne
o18935698 o12707240 318 sixth-ne
394805 2891 318 sixth-e
o50516876 o12707240 318 sixth-e
768045 2891 318 sixth-se
o78425362 o12707240 318 sixth-se
532764 2891 319 sixth-nw
o27816328 o12707240 319 sixth-nw
548920 2891 319 sixth-ne
o13922757 o12707240 319 sixth-ne
521087 2891 319 sixth-ne
o94361424 o12707240 319 sixth-ne
165379 2891 319 sixth-e
o22494674 o12707240 319 sixth-e
85963 2891 319 sixth-se
o18675122 o12707240 319 sixth-se
196432 2891 320 sixth-w
o41583079 o12707240 320 sixth-w
74586 2891 320 sixth-sw
o05449266 o12707240 320 sixth-sw
360158 2891 320 sixth-ne
o14674670 o12707240 320 sixth-ne
807235 2891 320 sixth-e
o02118397 o12707240 320 sixth-e
619237 2891 320 sixth-e
o48378604 o12707240 320 sixth-e
417623 2891 323 half-left
o91665240 o12707240 323 half-left
781325 2891 328 sixth-nw
o71616674 o12707240 328 sixth-nw
243958 2891 328 sixth-nw
o03546821 o12707240 328 sixth-nw
612975 2891 338 sixth-w
o91115812 o12707240 338 sixth-w
259710 2891 340 half-lower
o56783590 o12707240 340 half-lower
601935 2891 352
o72496299 o12707240 352
510746 2891 352
o33113938 o12707240 352
37264 2891 352
o47383757 o12707240 352
45978 2891 352
o85339763 o12707240 352
872019 2891 352
o51043392 o12707240 352
196807 2891 352
o04207178 o12707240 352
</pre>
</pre>

Aktuelle Version vom 15. März 2018, 12: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