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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
 
(178 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 3: Zeile 3:
==Erweiterung==
==Erweiterung==


===contributors===
===contributor_referenced_name===
<pre>
o74849335 Erich Schriner
-> siehe Dopplungen unten
</pre>
 
===contributor===
<pre>
<pre>
INSERT INTO contributors(forename_first) VALUES('Liam.C');
INSERT INTO contributors(forename_first) VALUES('Liam.C');


INSERT INTO contributors(surname, forename_first) VALUES('Petrov', 'Miroslav');


INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
Shadowrun Online - Portraits
</pre>
+[ID] Petrov Miroslav


<pre>
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'http://widulinskiart.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'https://www.facebook.com/groups/114658181901791');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'https://www.facebook.com/peter.bergting');
</pre>


Folgende Contributors fehlen (aus Chrome Flesh, Rigger 5.0, Data Trails und Shadowrun TCG, müssen dann auch alle noch in contributions eingetragen werden). Mit Ausnahme des TCGs (erster Block), wo die Namen direkt von den Karten kommen, habe ich die Namen direkt aus den CGL-Credits und nicht aus dem Internet, kann also sein, dass die noch falsch sind (CGL ist da sehr nachlässig):
Shadowrun TCG
<pre>
+[ID] Hudson Heather
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Hudson', 'Heather');
+[ID] Ho Patrick
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick');
INSERT INTO contributors(id_contributor, surname, forename_first, forename_second) VALUES(+[ID], 'Fischer', 'Scott', 'M.');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gregory', 'Barry');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Goleash', 'Grant');


INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Petersen', 'John');


Fehlende aus Bloody Business, Hard Targets und Shadowrun Lockdown (die Namen habe ich überprüft, s.u.; Dario Coelho ist uncredited, hat aber das Lockdown Cover zusammen mit Johannes Mücke gemacht):
Tomek Wrotek (Lockdown)
+[ID] Witowski Kuba
-- Wrotek ein Anagram von Tworek?
+[ID] Chan Melvin
+[ID] Fairclough Kenneth
+[ID] Rogers André
+[ID] Mücke Johannes
+[ID] Coelho Dario
</pre>
</pre>


===contributors_weblink===
===contributor_weblink===
Update vom 17.04.:
<pre>
<pre>
Heather Hudson (id missing)
o88639178 http://www.egerkrans.com
http://www.studiowondercabinet.com
o82535164 http://www.fantasycartography.com
o56238222 http://www.tnielsen.com
o99690872 http://www.kovah.co.uk
</pre>


Liam C. (id missing)
<pre>
http://atomiccolossus.com/blacksunpress.net/liam
o92075069 https://www.facebook.com/groups/114658181901791


Miroslav Petrov (id missing)
https://artofmiro.carbonmade.com
http://mikeypetrov.deviantart.com


James Joseph Thiesen (id missing)
Heather Hudson
http://fineartamerica.com/profiles/jim-thiesen
+[ID] http://www.studiowondercabinet.com
https://www.facebook.com/JamesJosephThiesen.3


John Petersen (id missing)
http://petersen1973.deviantart.com
https://www.artstation.com/artist/scatterbrain73
http://www.petersenart.com
https://www.facebook.com/scatterbrain73
https://twitter.com/scatterbrain73


Kuba Witwoski (id missing)
Liam C.
https://www.artstation.com/artist/kuba
+[ID] http://atomiccolossus.com/blacksunpress.net/liam
http://kubawitowski.com
https://www.facebook.com/kuba.witowski.art
http://kubawitowski.tumblr.com
http://kubawitowski.deviantart.com


Melvin Chan (id missing)
http://www.melvinchanart.com
https://www.artstation.com/artist/melvinchan
http://melvinchanart.deviantart.com


Kenneth Fairclough (id missing)
Attila Boros
https://www.artstation.com/artist/kenfairclough
+[ID] isfdb-ea 145765
http://kenfairclough.blogspot.com
</pre>
http://kennethfairclough.deviantart.com


André Rogers (id missing)
===contributor_weblink_hosting_service===
https://www.artstation.com/artist/gemineye
<pre>
http://artofandre.blogspot.com
Miroslav Petrov
http://gemineyeart.deviantart.com
+[ID] carbonmade artofmiro
http://www.gemineyeart.com
+[ID] blogspot soulsart
https://www.facebook.com/GeminEyeArt
+[ID] deviantart mikeypetrov
+[ID] twitter Soulsart
+[ID] instagram mikeypetrov
+[ID] behance Soulsurvivor


Johannes Mücke (id missing)
o88639178 blogspot johan-egerkrans
https://www.artstation.com/artist/wideshot
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
</pre>


Scott Fischer
===contribution===
http://www.fischart.com
http://scottmfischerevolvingeasel.blogspot.com


Grant Goleasch
===contribution_illustration===
http://dc.wikia.com/wiki/Grant_Goleash


Dário Coelho
===illustration_source===
http://dariocoelho.com
https://www.artstation.com/artist/dariocoelho
http://dariocoelho.deviantart.com
https://www.facebook.com/coelhodario
https://twitter.com/DarioDraws
</pre>


===contributions===
===source===
<pre>
Data Trails (7003), Rigger 5 (1289), Run & Gun (4602), Stolen Souls (4630), Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656)
1936 7003 illustration
3931 7003 illustration
4551 7003 illustration
5964 1289 illustration
2928 1289 illustration
6190 1289 illustration
4657 1289 illustration
3715 1289 illustration
8123 1289 illustration u
756 4602 illustration u
6131 4630 illustration u
2331 8488 illustration
8147 8488 illustration
2310 8488 illustration
4662 8488 illustration
2002 8488 illustration
8545 8488 illustration
4485 8488 illustration
5917 8488 illustration
8964 8488 illustration
6698 8488 illustration
133 8488 illustration
1380 8488 illustration
1997 8488 illustration
40 8488 cover art
2331 4190 cover art
2331 4190 illustration
3715 4190 illustration
8147 4190 illustration
2310 4190 illustration
2011 4190 illustration
8545 4190 illustration
4485 4190 illustration
1588 4190 illustration
6573 4190 illustration
903 4190 illustration
2513 4190 illustration
133 4190 illustration
1380 4190 illustration
6880 4190 illustration
40 4190 illustration
4662 4656 illustration
2542 4656 illustration
8964 4656 illustration
1380 4656 illustration
4551 4656 illustration
4961 4656 illustration
4485 4656 illustration u
</pre>


===illustrations===
===person===
<pre>
illustrations_source


Shadowrun 2050:
===index_illustration_person===
+[ID] 4027 197
+[ID] 4027 200
</pre>


===illustrations_source===
===Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis===
<pre>
Bloody Business (8488), Hard Targets (4190), Boston Lockdown (4656)
+[ID] 8488 cv
+[ID] 8488 back
+[ID] 8488 1
+[ID] 8488 8-9
+[ID] 8488 13
+[ID] 8488 19
+[ID] 8488 22
+[ID] 8488 29
+[ID] 8488 30
+[ID] 8488 33
+[ID] 8488 36
+[ID] 8488 39
+[ID] 8488 45
+[ID] 8488 51
+[ID] 8488 52
+[ID] 8488 54
+[ID] 8488 58
+[ID] 8488 64
+[ID] 8488 69
+[ID] 8488 72
+[ID] 8488 74
+[ID] 8488 80
+[ID] 8488 86
+[ID] 8488 88
+[ID] 8488 96
+[ID] 8488 98
+[ID] 8488 105
+[ID] 8488 109
+[ID] 8488 114
+[ID] 8488 121
+[ID] 8488 127
+[ID] 8488 134
+[ID] 8488 141
+[ID] 8488 144
+[ID] 8488 149
+[ID] 8488 151
+[ID] 4190 cv
+[ID] 4190 back
+[ID] 4190 1
+[ID] 4190 6-7
+[ID] 4190 14
+[ID] 4190 23
+[ID] 4190 31
+[ID] 4190 39
+[ID] 4190 40
+[ID] 4190 45
+[ID] 4190 53
+[ID] 4190 61
+[ID] 4190 68
+[ID] 4190 75
+[ID] 4190 76-77
+[ID] 4190 95
+[ID] 4190 102
+[ID] 4190 113
+[ID] 4190 117
+[ID] 4190 123
+[ID] 4190 129
+[ID] 4190 133
+[ID] 4190 144-145
+[ID] 4190 150
+[ID] 4190 158
+[ID] 4190 166
+[ID] 4190 169
+[ID] 4190 175
+[ID] 4190 177
+[ID] 4190 181
+[ID] 4190 199
+[ID] 4190 200
+[ID] 4190 203
+[ID] 4190 206-207
+[ID] 4190 208
+[ID] 4656 cv
+[ID] 4656 back
+[ID] 4656 1
+[ID] 4656 8-9
+[ID] 4656 14
+[ID] 4656 42
+[ID] 4656 59
+[ID] 4656 67
+[ID] 4656 70
+[ID] 4656 75
+[ID] 4656 77
+[ID] 4656 87
+[ID] 4656 95
+[ID] 4656 103
+[ID] 4656 109
+[ID] 4656 126
+[ID] 4656 135
+[ID] 4656 144
+[ID] 4656 154
+[ID] 4656 159
+[ID] 4656 170
+[ID] 4656 171
+[ID] 4656 174
+[ID] 4656 183
+[ID] 4656 189
+[ID] 4656 197
+[ID] 4656 208
+[ID] 4656 230
+[ID] 4656 240
</pre>


===contributions_illustration===
{| class="sortable infotable" style="width:80%;"
Rigger 5 (1289), Stolen Souls (4630), Chrome Flesh (9450).
!Seite
<pre>
!<tt>id_illustration</tt>
9450 348406
!Illustrator
136 42379
! width="20px" class="unsortable" |
136 123068
!Beschreibung
136 823479
! class="unsortable" |In anderen Quellen
903 42379
!Link
903 123068
|-
903 823479
| 57
8545 356107
| <tt>o90089495</tt>
903 951742
| {{Beitrag|Peter Bergting}}
9243 983465
| {{Bildpos|halbseitig-oben}}
903 85961
|
2331 321548
|
6698 908461
|
8147 923057
|-
40 47918
| 117
8686 237906
| <tt>o33089634</tt>
903 350792
| {{Beitrag|Matthew Plog}}
903 352907
| {{Bildpos|zentral}}
133 841297
|
9243 749028
|
133 847039
|
6698 132845
|}
8545 245089
6131 710526
8102 913472
903 570439
8227 371926
8227 345029
8227 109384
4662 463581
8545 47692
3402 478590
3715 589704
3715 719326
903 490238
903 861094
903 560837
6880 825673
903 276345
6880 814207
8123 273041
3402 491765
903 687204
4662 723459
3402 394062
8227 386241
</pre>


==Korrektur==
==Korrektur==


===Dopplungen?===
===Dopplungen?===
*3077 - Joshua Howell
*o54370744 - Erich Schreiner
*7157 - Joshua Rowell
*o74849335 - Erich Schriner
 
*o18673530 - Joshua Rowell
*o71434220 - Joshua Howell
 
*o27230860 - Larry Elmore
*o99306142 - Larry Almore
 
*o37485828 - Jason Glaser
*o84801958 - Jacob Glaser


*7468 - Larry Almore
===illustration_source - SR4A - Nachbesserung?===
*8047 - Larry Elmore
<pre>
SR4 Anniversary - Problemfälle


*5665 - Jacob Glaser
o98272277 o12707240 7 center
*8919 - Jason Glaser
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, 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