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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(→‎contribution_illustration: +Horizon Kampagne, Spy Games)
(-contribution, contribution_illustration, illustration_source)
Zeile 95: Zeile 95:


===contribution===
===contribution===
Howling Shadows (Kim Van Deun, Michele Giorgi und Tyler Clark fehlen noch weil sie keine IDs haben):
<pre>
o82750560 o14719198 illustration
o20648078 o14719198 illustration
o24024493 o14719198 illustration
o35335286 o14719198 illustration
o67603439 o14719198 illustration
o34210373 o14719198 illustration
o03537050 o14719198 illustration
o27413345 o14719198 illustration
o92075069 o14719198 illustration
o59153784 o14719198 illustration
o30921377 o14719198 illustration
o69921485 o14719198 illustration
o04145505 o14719198 illustration
o66422333 o14719198 illustration
o54370744 o14719198 illustration
o26526716 o14719198 illustration
o56757167 o14719198 illustration
</pre>


===contribution_illustration===
===contribution_illustration===
<pre>
A Fistful of Credsticks:
o23103936 o62287059
o23103936 o03147021
o95225568 o50173207
o82535164 o75868372
o95225568 o67507492
o82535164 o58257441
o95225568 o53678864
o95225568 o25522443
o95225568 o72874801
o95225568 o46284636
o95225568 o30593830
Anarchy Subsidized:
o23103936 o20108076
o23103936 o07471843
o95225568 o11142682
o95225568 o71199334
o95225568 o12754518
o95225568 o36113215
o95225568 o11142620
o82535164 o94505048
o82535164 o83436411
o95225568 o41638760
o95225568 o95388283
Colombian Subterfuge:
o23103936 o73306687
o23103936 o98031498
o95225568 o31283139
o95225568 o37075808
o95225568 o45754828
o82535164 o54601302
o95225568 o66275820
o82535164 o11613905
o82535164 o07654454
o95225568 o75431781
The Twilight Horizon:
o23103936 o74079568
o23103936 o26783402
o47870085 o85858292
o69921485 o20964163
o92075069 o42682436
o06868757 o39829271
o84801958 o07226533
o69921485 o84032660
o26526716 o08233611
o92075069 o92265203
o86216510 o87825077
o84801958 o08816389
o57662286 o67080357
o47870085 o07688283
o57662286 o37037445
o66696823 o24576735
o66696823 o85992329
o23103936 o68320021
Spy Games:
o55359998 o98876953
o55359998 o63775710
o47870085 o09437418
o32335539 o80586296
o59153784 o11101871
o14948690 o09465746
o59153784 o55974486
o32335539 o98073809
o59153784 o11308217
o14948690 o64682166
o32335539 o40194121
o27522812 o41085434
o59153784 o97790429
o14948690 o46285623
o59153784 o35382839
o59153784 o47760882
o54123985 o64992537
o83753688 o21314016
o32335539 o78747060
o54123985 o50008036
o54123985 o66997948
</pre>


===illustration_source===
===illustration_source===
<pre>
A Fistful of Credsticks:
o62287059 o16715362 back full
o03147021 o16715362 1 full
o50173207 o16715362 5 full
o75868372 o16715362 12 half-upper
o67507492 o16715362 18 half-upper
o58257441 o16715362 21 half-upper
o53678864 o16715362 25 half-upper
o25522443 o16715362 32 half-right
o72874801 o16715362 37 half-right
o46284636 o16715362 38 half-right
o30593830 o16715362 40 half-right
Anarchy Subsidized:
o20108076 o64209768 back full
o07471843 o64209768 1 full
o11142682 o64209768 4 full
o71199334 o64209768 9 half-upper
o12754518 o64209768 15 half-left
o48027551 o64209768 21 half-upper
o36113215 o64209768 25 half-upper
o11142620 o64209768 27 half-right
o94505048 o64209768 30 half-upper
o83436411 o64209768 35 half-upper
o41638760 o64209768 42 half-right
o95388283 o64209768 43 half-right
Colombian Subterfuge:
o73306687 o34282905 back half-upper
o98031498 o34282905 1 full
o31283139 o34282905 5 full
o37075808 o34282905 10 half-right
o44417011 o34282905 15 half-upper
o45754828 o34282905 19 half-upper
o99446283 o34282905 25 half-upper
o54601302 o34282905 26 half-upper
o66275820 o34282905 29 half-upper
o11613905 o34282905 30 half-upper
o07654454 o34282905 41 half-upper
o75431781 o34282905 46 half-left
The Twilight Horizon:
o74079568 o47023441 cover-back full
o26783402 o47023441 1 full
o85858292 o47023441 7 full
o20964163 o47023441 11 half-upper
o58951919 o47023441 16 half-lower
o38032717 o47023441 21 half-upper
o42682436 o47023441 26 half-upper
o47003104 o47023441 31 half-left
o39829271 o47023441 39 half-upper
o36509954 o47023441 48 half-left
o92844599 o47023441 53 half-upper
o07226533 o47023441 54 half-right
o84032660 o47023441 61 half-upper
o08233611 o47023441 72 half-left
o42816433 o47023441 78 half-right
o92265203 o47023441 83 half-upper
o84817056 o47023441 87 half-right
o87825077 o47023441 94 half-upper
o08816389 o47023441 96 half-upper
o67080357 o47023441 101 half-left
o07688283 o47023441 104 half-upper
o68642642 o47023441 110 half-right
o37037445 o47023441 116 half-upper
o68661129 o47023441 122 half-left
o33927071 o47023441 129 half-upper
o24576735 o47023441 137 half-left
o85992329 o47023441 139 center
o68320021 o47023441 152 full
Spy Games:
o98876953 o53846041 back full
o63775710 o53846041 1 full
o09437418 o53846041 7 full
o46626941 o53846041 11 half-upper
o80586296 o53846041 22 full
o07910963 o53846041 25 half-upper
o06597885 o53846041 27 full
o44416877 o53846041 34 half-left
o11101871 o53846041 36 half-right
o21536254 o53846041 39 full
o09465746 o53846041 45 half-right
o55974486 o53846041 54 full
o98073809 o53846041 59 half-upper
o11308217 o53846041 66 half-upper
o64682166 o53846041 68 quarter-ne
o40194121 o53846041 73 full
o41085434 o53846041 78 quarter-ne
o97790429 o53846041 83 half-left
o52324840 o53846041 86 half-upper
o81055066 o53846041 90 half-upper
o46285623 o53846041 93 half-upper
o44907635 o53846041 97 half-upper
o42114550 o53846041 99 full
o35382839 o53846041 101 half-right
o08005471 o53846041 104 half-upper
o47760882 o53846041 108 full
o23059993 o53846041 116 half-left
o64992537 o53846041 121 full
o26920621 o53846041 128 half-right
o37496751 o53846041 131 half-left
o21314016 o53846041 136 half-upper
o78747060 o53846041 140 full
o94289119 o53846041 147 half-upper
o50008036 o53846041 150 quarter-se
o47210128 o53846041 153 quarter-se
o49069674 o53846041 154 sixth-nw
o66997948 o53846041 162 half-upper
Howling Shadows:
[+id] o14719198 cv full
[+id] o14719198 back full
[+id] o14719198 1 full
[+id] o14719198 6-7 half-upper
[+id] o14719198 12 half-upper
[+id] o14719198 18 half-upper
o38259859 o14719198 23 full
[+id] o14719198 26 half-upper
[+id] o14719198 32 half-left
[+id] o14719198 40 half-upper
[+id] o14719198 44 half-upper
[+id] o14719198 48-49 half-upper
[+id] o14719198 57 half-upper
[+id] o14719198 59 half-upper
[+id] o14719198 60 half-left
[+id] o14719198 63 half-upper
[+id] o14719198 64 half-left
[+id] o14719198 67 half-upper
[+id] o14719198 74 half-upper
[+id] o14719198 75 half-right
[+id] o14719198 84 half-left
[+id] o14719198 89 half-right
[+id] o14719198 90 half-left
[+id] o14719198 96 half-upper
[+id] o14719198 101 half-upper
[+id] o14719198 103 half-upper
[+id] o14719198 106 half-upper
[+id] o14719198 108 half-left
[+id] o14719198 110 half-left
[+id] o14719198 113 center
[+id] o14719198 120 half-upper
[+id] o14719198 123 half-upper
[+id] o14719198 125 half-right
[+id] o14719198 126 half-right
[+id] o14719198 127 half-right
[+id] o14719198 128 half-upper
[+id] o14719198 129 half-right
[+id] o14719198 131 half-right
[+id] o14719198 132 half-left
[+id] o14719198 133 half-upper
[+id] o14719198 134 half-upper
[+id] o14719198 135 half-upper
[+id] o14719198 138-139 half-upper
[+id] o14719198 145 half-upper
[+id] o14719198 146 half-upper
[+id] o14719198 153 half-right
[+id] o14719198 154 half-upper
[+id] o14719198 155 half-right
[+id] o14719198 160 half-left
[+id] o14719198 168 half-left
[+id] o14719198 178 half-upper
[+id] o14719198 187 full
[+id] o14719198 189 half-middle
[+id] o14719198 191 half-upper
</pre>


===source===
===source===

Version vom 28. Juni 2016, 15:56 Uhr

Shadowhelix:Datenbank

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.:

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		


Dário Coelho
+[ID]	http://dariocoelho.com		


Attila Boros
+[ID]	isfdb-ea	145765		

contributor_weblink_hosting_service

Dário Coelho
+[ID]	artstation	dariocoelho		
+[ID]	deviantart	dariocoelho		
+[ID]	facebook	coelhodario		
+[ID]	twitter	DarioDraws		

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		
o34985555	tumblr	marcomazzoni		
o34985555	facebook	Marco-Mazzoni-150873907978		
o34985555	instagram	marcomazzoniart		
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

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

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