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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(Neue Vorschläge für contributors_weblink)
Keine Bearbeitungszusammenfassung
 
(212 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 2: Zeile 2:


==Erweiterung==
==Erweiterung==
===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) VALUES('Yeow', 'Darren');
INSERT INTO contributors(surname, forename_first) VALUES('Yi', 'Tim');
INSERT INTO contributors(surname, forename_first) VALUES('Balixia', 'Bruno');


INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Manold', 'Alyssa', 'Ann');
Shadowrun Online - Portraits
INSERT INTO contributors(surname, forename_first, forename_second) VALUES('Thiesen', 'James', 'Joseph');
+[ID] Petrov Miroslav
 
 
Shadowrun TCG
+[ID] Hudson Heather
+[ID] Ho Patrick
 
 
Tomek Wrotek (Lockdown)
-- Wrotek ein Anagram von Tworek?
</pre>
 
===contributor_weblink===
Update vom 17.04.:
<pre>
o88639178 http://www.egerkrans.com
o82535164 http://www.fantasycartography.com
o56238222 http://www.tnielsen.com
o99690872 http://www.kovah.co.uk
</pre>
 
<pre>
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
</pre>
</pre>


===contributor_weblink_hosting_service===
<pre>
<pre>
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'http://widulinskiart.carbonmade.com');
Miroslav Petrov
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'https://www.artstation.com/artist/widulinski');
+[ID] carbonmade artofmiro
INSERT INTO contributors_weblink(id_contributor, url) VALUES(532, 'http://hypersteve.deviantart.com');
+[ID] blogspot soulsart
INSERT INTO contributors_weblink(id_contributor, url) VALUES(717, 'http://jameswolfart.blogspot.com');
+[ID] deviantart mikeypetrov
INSERT INTO contributors_weblink(id_contributor, url) VALUES(766, 'http://barelynormalactivity.deviantart.com');
+[ID] twitter Soulsart
INSERT INTO contributors_weblink(id_contributor, url) VALUES(830, 'http://www.facebook.com/chad.sergesketter');
+[ID] instagram mikeypetrov
INSERT INTO contributors_weblink(id_contributor, url) VALUES(903, 'http://www.facebook.com/victormanuel.lezamoreno');
+[ID] behance Soulsurvivor
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'http://www.artflakes.com/de/shop/kunrong-yap');
 
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'https://www.artstation.com/artist/krypt');
o88639178 blogspot johan-egerkrans
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1045, 'http://yapkunrong.com');
o88639178 facebook johanegerkranspublic
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1156, 'http://dc-concept.blogspot.com');
o86535591 deviantart creatorpwned
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1156, 'http://danielmchavez.deviantart.com');
o86535591 twitter creatorpwned
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1367, 'http://seanmcmurchy.blogspot.com');
o98219748 deviantart rhstillwell
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'http://www.facebook.com/groups/114658181901791');
o31480053 facebook atomicdogstudio
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'http://jasonbehnke.com');
o96311682 artstation donaldcrank
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'http://jasonbehnke.deviantart.com');
o96311682 deviantart laskroto
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1982, 'https://www.facebook.com/behnkestudio');
o06663545 facebook Igor-Kieryluk-115707815193569
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1997, 'http://www.alexstoneart.com');
o06663545 artstation igorkieryluk
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1997, 'http://alexstoneart.deviantart.com');
o56238222 facebook TheArtOfTereseNielsen
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2002, 'https://www.artstation.com/artist/matthansenart');
o99690872 deviantart kovah
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2310, 'http://smilout.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2568, 'http://igorkieryluk.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(2620, 'http://www.rkpost.net');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3034, 'http://ryanbarger.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3034, 'https://www.facebook.com/ryan.barger.923');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3237, 'http://bennewmanart.bigcartel.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3242, 'https://www.artstation.com/artist/bengiskhan');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3402, 'http://bgk-bengiskhan.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3536, 'http://larrymacdougallart.tumblr.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3557, 'http://www.facebook.com/razorfang');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'http://cargocollective.com/art-ly');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'https://www.facebook.com/Lydia-Schuchmann-234211253281512/');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3562, 'https://www.behance.net/LydiaSchuchmann');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(4180, 'http://www.facebook.com/jim.nelson.9');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(4232, 'http://nateabell.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(4302, 'http://mattwilsonprime.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5100, 'http://brisbaneillustrators.com/caleb-salisbury.html');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.cgsociety.org');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.artstation.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5140, 'http://wildheadache.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5170, 'http://blog.johngravato.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'http://arndtdrechsler.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5252, 'http://www.woodillustration.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5252, 'http://stevethebunny.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5310, 'http://alradeck.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5310, 'http://alradeck.tumblr.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5618, 'https://twitter.com/emilyzeinner');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5618, 'https://www.artstation.com/artist/emilyzeinner');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5763, 'https://robertruffolo.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5763, 'https://twitter.com/rruffs');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5848, 'http://peterdora.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5848, 'http://peterman2070.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5880, 'http://kristenplescow.tumblr.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5880, 'http://kristenplescow.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5917, 'https://www.artstation.com/artist/ianllanas');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6077, 'https://www.facebook.com/brent.evans.735');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6100, 'http://envertigo.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'http://www.facebook.com/peter.bergting');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6244, 'http://www.artworksillustration.com/portfolio%20keithbirdsong.htm');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6244, 'http://www.keith-birdsong.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6343, 'http://davidsmit.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6357, 'http://ectmonster.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6550, 'http://www.artstation.com/artist/hounworks');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6550, 'http://hounworks.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6705, 'http://donatoarts.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6739, 'http://jasoncaffoe.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6880, 'http://takashitan2.wix.com/takashitanportfolio');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7071, 'http://www.davidnashart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7071, 'http://davidnashart.tumblr.com/');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7205, 'http://inkthinker.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7291, 'http://dougkovacs.com/dkblog');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.behance.net/gallery/Galefire-Portfolio/11389539');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'http://michael-galefire.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7842, 'http://www.mikesutfin.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8009, 'http://lucasdurham.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8027, 'http://www.gepart.com.au');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8046, 'https://www.facebook.com/derekgpoole');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8051, 'http://davidkeggillustration.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8051, 'http://david-kegg.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8545, 'http://davidroberthovey.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8577, 'http://mariusandrei.carbonmade.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8580, 'http://drewsil.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8621, 'http://bocetillos.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://bryansyme.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://www.bryansyme.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8653, 'http://fineartamerica.com/profiles/bryan-syme.html');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8703, 'http://runfreakrun.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8703, 'http://runfreakrun.blogspot.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8964, 'https://www.artstation.com/artist/mauroperoni');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(8964, 'http://mauroperoni.deviantart.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9435, 'http://www.facebook.com/mark.zug');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9495, 'https://www.facebook.com/MichaelKomarckIllustration');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9785, 'http://www.baldegografix.com');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9854, 'https://www.artstation.com/artist/ryanportillo');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(9854, 'http://ryanportillo.deviantart.com');
</pre>
</pre>
===contribution===
===contribution_illustration===
===illustration_source===
===source===
===person===
===index_illustration_person===
===Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis===
{| class="sortable infotable" style="width:80%;"
!Seite
!<tt>id_illustration</tt>
!Illustrator
! 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}}
|
|
|
|}


==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