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

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


===contributors_referenced_name===
===contributor_referenced_name===
<pre>
<pre>
458 Erich Schriner
o74849335 Erich Schriner
-> siehe Dopplungen unten
-> siehe Dopplungen unten
</pre>
</pre>


===contributors===
===contributor===
Fehlende aus SR4A und diversen Romanen:
<pre>
<pre>
+[ID] Mohan Jr Steven
INSERT INTO contributors(forename_first) VALUES('Liam.C');
+[ID] Beaulieu Bradley P
+[ID] Bick Ilsa J
+[ID] Drake Maxwell Alexander
+[ID] Lorelei Shannon f
+[ID] Duval Dan C
+[ID] William Jr Keith H 1950 m
+[ID] Peebles Peter
+[ID] Steadman Broeck
+[ID] Gallian Carl
</pre>


<pre>
INSERT INTO contributors(forename_first) VALUES('Liam.C');


Shadowrun Online - Portraits
+[ID] Petrov Miroslav
+[ID] Petrov Miroslav
+[ID] Thiesen James Joseph
</pre>


Shadowrun TCG:
 
<pre>
Shadowrun TCG
+[ID] Hudson Heather
+[ID] Hudson Heather
+[ID] Ho Patrick
+[ID] Ho Patrick
+[ID] Fischer Scott M
+[ID] Gregory Barry
+[ID] Goleash Grant
</pre>


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):
<pre>
+[ID] Coelho Dário
</pre>


<pre>
Tomek Wrotek (Lockdown)
Tomek Wrotek (Lockdown)
-- Wrotek ein Anagram von Tworek?
-- Wrotek ein Anagram von Tworek?
</pre>
</pre>


===contributor_weblink===
Update vom 17.04.:
<pre>
<pre>
HBS-Artist und zwei Autoren aus der SR Anthology (weblinks s.u.):
o88639178 http://www.egerkrans.com
+[ID] Ishmael Tristin
o82535164 http://www.fantasycartography.com
o56238222 http://www.tnielsen.com
o99690872 http://www.kovah.co.uk
</pre>
</pre>


===contributors_weblink===
<pre>
<pre>
Steven Mohan, Jr.
o92075069 https://www.facebook.com/groups/114658181901791
http://www.amazon.com/Steven-Mohan-Jr./e/B004YFIOQ4
http://storyportals.com/steven-mohan-jr
http://www.sarna.net/wiki/Steven_Mohan,_Jr.


Bradley P. Beaulieu
http://quillings.com


Ilsa J. Bick
Heather Hudson
www.ilsajbick.com
+[ID] http://www.studiowondercabinet.com


Lorelei Shannon:
http://www.psychenoir.com
https://en.wikipedia.org/wiki/Lorelei_Shannon
https://www.facebook.com/lorelei.shannon
William H. Keith, Jr.
http://www.whkeith.com
https://en.wikipedia.org/wiki/William_H._Keith,_Jr.
Broeck Steadman
http://etsteadman.com
1588 https://www.facebook.com/groups/114658181901791
Heather Hudson
+[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] https://artofmiro.carbonmade.com
+[ID] http://soulsart.blogspot.com


+[ID] deviantart mikeypetrov
+[ID] twitter Soulsart


 
Attila Boros
James Joseph Thiesen
+[ID] isfdb-ea 145765
+[ID] http://fineartamerica.com/profiles/jim-thiesen
+[ID] facebook JamesJosephThiesen.3
 
 
Scott Fischer (id missing)
+[ID] http://www.fischart.com
http://scottmfischerevolvingeasel.blogspot.com
 
 
Grant Goleasch (id missing)
http://dc.wikia.com/wiki/Grant_Goleash
 
 
Dário Coelho (id missing)
 
+[ID] http://dariocoelho.com
 
+[ID] artstation dariocoelho
+[ID] deviantart dariocoelho
+[ID] facebook coelhodario
+[ID] twitter DarioDraws
 
Tristin Ishmael
+[ID] http://www.theycallmeishmael.com
+[ID] facebook tristin.ishmael
+[ID] artstation sailormonkey
+[ID] twitter Tristinishmael
</pre>
</pre>


===contributions===
===contributor_weblink_hosting_service===
Ich habe mich mal der Romane und Sammelbände angenommen, vorerst nur der Englischen:
<pre>
<pre>
156 5362 text Wetwork
Miroslav Petrov
156 1957 text The Breach
+[ID] carbonmade artofmiro
188 1957 text Rune’s Avatar Café
+[ID] blogspot soulsart
673 5362 text No Such Luck
+[ID] deviantart mikeypetrov
903 2017 cover art
+[ID] twitter Soulsart
903 4731 cover art
+[ID] instagram mikeypetrov
903 4635 cover art
+[ID] behance Soulsurvivor
903 3218 cover art
903 5887 cover art
903 1957 cover art
1366 6494 text A Plague of Demons
1366 6494 text Free Fall
1588 6494 illustration
1711 1957 text House of Cards
2033 7094 cover art
2179 5362 text Snake in the City
2820 658 cover art
2820 3488 cover art
2820 1797 cover art
2820 9281 cover art
2820 7792 cover art
2820 2897 cover art
2820 6851 cover art
2830 4689 text
2830 6494 text Would it Help to Say I'm Sorry?
2830 6494 text It's All Done with Mirrors
2830 5362 text Better to Reign
2830 1957 text Images: A Wolf and Raven Story
3082 1957 text A Life on the Line
3242 5362 cover art
3255 5362 text Fade Away
3580 52 cover art
3580 8583 cover art
3580 6711 cover art
3580 8447 cover art
3580 4577 cover art
3580 4689 cover art
3610 8510 text
3633 6494 text Striper
3862 6494 illustration
3898 6494 text Into the Shadows
4174 6494 text Tailchaser
4180 6494 illustration
4705 5362 text Trade Secrets
4705 1957 text Swamp of Spirits
5110 6494 text Turtle In the Tower
5303 1957 text Holiday
5437 1957 text The Cost of Science
5917 8510 cover art
6020 1957 text Social Engineering
6131 1053 cover art
6131 9710 cover art
6131 418 cover art
6131 6062 cover art
6131 4104 cover art
6244 773 cover art
6244 82 cover art
6244 1316 cover art
6244 5561 cover art
6244 6494 cover art
6346 3490 cover art
6346 9097 cover art
6346 9862 cover art
6346 4572 cover art
6346 1370 cover art
6409 6494 illustration
6409 6494 text Graverobbers
6776 5362 text Bloody Fingers
7015 6494 text Prologue
7456 1957 text Queen for a Minute
7832 6494 illustration
8013 1957 text Sweating Bullets
8123 4954 cover art
8463 5887 text
8463 1957 text Nothing Personal
8493 5362 text Better Than
8493 1957 text Bottom of the Ninth
8545 6955 cover art
8817 5362 text Caliban
8817 1957 text The Art of the Steal
8820 5362 text Expectations
8865 5362 text The Good Fight
9178 5362 text Introduction
9178 1957 text Introduction
9243 5364 cover art
9243 5803 cover art
9243 7702 cover art
9243 355 cover art
9367 1957 text Thunderstruck


6511 7639 cover art
o88639178 blogspot johan-egerkrans
6511 5258 cover art
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>


Bradley Bealieu:
===contribution===
[+ID] 5362 text In Memory Of


Ilsa J. Bick:
===contribution_illustration===
[+ID] 5362 text The Art of Diving in the Dark


Steven Mohan Jr:
===illustration_source===
[+ID] 5362 text Where the Shadows are Darkest


Shannon Lorelei:
===source===
[+ID] 6494 text Whitechapel Rose


Dan C. Duval:
===person===
[+ID] 5362 text Big Jake


William H. Keith, Jr.:
===index_illustration_person===
[+ID] 5362 text Dead Names


Jim Thiesen:
===Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis===
[+ID] 7467 cover art
[+ID] 7645 cover art


Peter Peebles:
{| class="sortable infotable" style="width:80%;"
[+ID] 2792 cover art
!Seite
[+ID] 1029 cover art
!<tt>id_illustration</tt>
[+ID] 2269 cover art
!Illustrator
[+ID] 4077 cover art
! width="20px" class="unsortable" |
!Beschreibung
! class="unsortable" |In anderen Quellen
!Link
|-
| 57
| <tt>o90089495</tt>
| {{Beitrag|Peter Bergting}}
| {{Bildpos|halbseitig-oben}}
|
|
|
|-
| 117
| <tt>o33089634</tt>
| {{Beitrag|Matthew Plog}}
| {{Bildpos|zentral}}
|
|
|
|}


Broeck Steadman:
==Korrektur==
[+ID] 1851 cover art


Carl Gallian:
===Dopplungen?===
[+ID] 482 cover art
*o54370744 - Erich Schreiner
*o74849335 - Erich Schriner


World of Shadows
*o18673530 - Joshua Rowell
2381 1957 text Revenge is a Dish Best Served by Proxy
*o71434220 - Joshua Howell
5386 1957 text It's Nice to Be Wanted
7594 1957 text Keeping Up With Mr. Johnson
</pre>


===illustrations_source===
*o27230860 - Larry Elmore
<pre>
*o99306142 - Larry Almore
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>


===contributions_illustration===
*o37485828 - Jason Glaser
*o84801958 - Jacob Glaser


===sources===
===illustration_source - SR4A - Nachbesserung?===
Kleine Korrektur (Typ fehlt bislang):
<pre>
<pre>
4689 Wolf and Raven en novel
SR4 Anniversary - Problemfälle
</pre>


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.
o98272277 o12707240 7 center
<pre>
o00641309 o12707240 9 quarter-se
+[ID] Shadowrun: Crossfire en card game
o04784315 o12707240 10-11
+[ID] Shadowrun: High Caliber Ops en card game
o55415857 o12707240 12 half-left
+[ID] Shadowrun (SNES) en video game
o62812497 o12707240 16 sixth-sw
+[ID] Shadowrun (Mega Drive) en video game
o14366808 o12707240 149
+[ID] Shadowrun (Mega-CD) jp video game
o85439368 o12707240 149
+[ID] Shadowrun (2007) en video game
o18799018 o12707240 149
+[ID] Shadowrun Returns en video game
o14174178 o12707240 149
+[ID] Shadowrun: Dragonfall en video game
o29144640 o12707240 149
+[ID] Shadowrun: Dragonfall Director's Cut en video game
o48673075 o12707240 184 third-lower
+[ID] Shadowrun: Hong Kong en video game
o09249117 o12707240 227 sixth-se
+[ID] Shadowrun Chronicles en video game
o16843224 o12707240 276-277 half-middle
+[ID] Shadowrun: Shadows of Hong Kong en DLC
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>
</pre>
==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

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