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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(-integrierte Weblinks)
Keine Bearbeitungszusammenfassung
 
(206 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, 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>
</pre>


===contributor_weblink===
Update vom 17.04.:
<pre>
<pre>
INSERT INTO contributors_weblink(id_contributor, url) VALUES(446, 'http://widulinskiart.carbonmade.com');
o88639178 http://www.egerkrans.com
INSERT INTO contributors_weblink(id_contributor, url) VALUES(3010, 'https://www.facebook.com/bOne77');
o82535164 http://www.fantasycartography.com
INSERT INTO contributors_weblink(id_contributor, url) VALUES(1588, 'https://www.facebook.com/groups/114658181901791');
o56238222 http://www.tnielsen.com
INSERT INTO contributors_weblink(id_contributor, url) VALUES(5176, 'https://www.facebook.com/arndt.drechsler');
o99690872 http://www.kovah.co.uk
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>
</pre>


Chrome Flesh:
<pre>
<pre>
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8545, 'cover art');
o92075069 https://www.facebook.com/groups/114658181901791
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 2331, 'illustration');
 
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8147, 'illustration');
 
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 2310, 'illustration');
Heather Hudson
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 3402, 'illustration');
+[ID] http://www.studiowondercabinet.com
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 4485, 'illustration');
 
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8102, 'illustration');
 
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 903, 'illustration');
Liam C.
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8964, 'illustration');
+[ID] http://atomiccolossus.com/blacksunpress.net/liam
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 5763, 'illustration');
 
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 133, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 6880, 'illustration');
</pre>


Data Trails:
Attila Boros
<pre>
+[ID] isfdb-ea 145765
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 6698, 'cover art');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5140, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2331, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8123, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8147, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2310, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 4662, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 3402, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 3904, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8545, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 2568, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 903, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 8964, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5880, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 5763, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 40, 'illustration');
</pre>
</pre>


Rigger 5.0:
===contributor_weblink_hosting_service===
<pre>
<pre>
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8227, 'cover art');
Miroslav Petrov
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4662, 'illustration');
+[ID] carbonmade artofmiro
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 3402, 'illustration');
+[ID] blogspot soulsart
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8545, 'illustration');
+[ID] deviantart mikeypetrov
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4485, 'illustration');
+[ID] twitter Soulsart
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 5837, 'illustration');
+[ID] instagram mikeypetrov
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 903, 'illustration');
+[ID] behance Soulsurvivor
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8964, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 6880, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 446, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 458, 'illustration');
</pre>


Shadowrun TCG:
o88639178 blogspot johan-egerkrans
<pre>
o88639178 facebook johanegerkranspublic
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5699, 'illustration', 'Color');
o86535591 deviantart creatorpwned
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4080, 'illustration', 'Color');
o86535591 twitter creatorpwned
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5475, 'illustration', 'Color');
o98219748 deviantart rhstillwell
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 13, 'illustration', 'Color');
o31480053 facebook atomicdogstudio
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6666, 'illustration', 'Color');
o96311682 artstation donaldcrank
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6131, 'illustration', 'Color');
o96311682 deviantart laskroto
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1009, 'illustration', 'Color');
o06663545 facebook Igor-Kieryluk-115707815193569
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5790, 'illustration', 'Color');
o06663545 artstation igorkieryluk
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1588, 'illustration', 'Color');
o56238222 facebook TheArtOfTereseNielsen
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7645, 'illustration', 'Color');
o99690872 deviantart kovah
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4180, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3557, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8123, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3963, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 9243, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4845, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1212, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3536, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 2820, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 9435, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7832, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4302, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7842, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1628, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 2792, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6115, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8207, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6937, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4962, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 3862, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4305, 'illustration', 'Color');
</pre>
</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):
===contribution===
<pre>
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Hudson', 'Heather');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Ho', 'Patrick');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Fischer', 'Scott');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Nielsen', 'Terese');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Gianni', 'Tom');
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');
===contribution_illustration===
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sintes', 'Marc');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Grierson', 'Katy');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Sondered', 'David');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Vasburg', 'Erich');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Garcia', 'Andre');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Mizzoni', 'Marco');
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Peuler', 'Chris');
INSERT INTO contributors(id_contributor, surname, forename_second, forename_first) VALUES(+[ID], 'Webster', 'Cory', 'James');
</pre>


Und hier mal ein erster Schwung für contributions_illustration (Shadow Spells, Street Grimoire, Data Trails):
===illustration_source===
<pre>
Shadow Spells:
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 326075);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 934215);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5848, 63948);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5790, 962138);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 297816);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(7645, 207986);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(3862, 918235);


Street Grimoire:
===source===
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 271835);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 824173);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 917520);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 693025);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 745098);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 102698);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8545, 450739);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8545, 412756);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5763, 624135);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8051, 983270);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 384560);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8653, 74281);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6346, 596048);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6131, 715824);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 437956);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 602948);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(133, 980342);


Data Trails:
===person===
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6698, 816904);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(6698, 491302);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 712869);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 265013);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 27319);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(903, 618974);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5763, 410625);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(5880, 562419);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(4662, 970358);
INSERT INTO contributions_illustration(id_contributor, id_illustration) VALUES(8964, 481253);
</pre>


Update vom 02.03.2016:
===index_illustration_person===
<pre>
illustrations_source
+[ID] 4602 cv
+[ID] 4602 back
+[ID] 4602 1
+[ID] 4602 5
+[ID] 4602 5
+[ID] 4602 5
+[ID] 4602 6-7
+[ID] 4602 14
+[ID] 4602 17
+[ID] 4602 18
+[ID] 4602 21
+[ID] 4602 22
+[ID] 4602 22
+[ID] 4602 23
+[ID] 4602 25
+[ID] 4602 27
+[ID] 4602 28
+[ID] 4602 29
+[ID] 4602 30
+[ID] 4602 30
+[ID] 4602 31
+[ID] 4602 31
+[ID] 4602 32
+[ID] 4602 32
+[ID] 4602 33
+[ID] 4602 33
+[ID] 4602 34
+[ID] 4602 34
+[ID] 4602 35
+[ID] 4602 35
+[ID] 4602 36
+[ID] 4602 36
+[ID] 4602 37
+[ID] 4602 37
+[ID] 4602 38
+[ID] 4602 38
+[ID] 4602 39
+[ID] 4602 40
+[ID] 4602 40
+[ID] 4602 41
+[ID] 4602 41
+[ID] 4602 42
+[ID] 4602 42
+[ID] 4602 43
+[ID] 4602 43
+[ID] 4602 44
+[ID] 4602 44
+[ID] 4602 45
+[ID] 4602 45
+[ID] 4602 46
+[ID] 4602 46
+[ID] 4602 47
+[ID] 4602 48
+[ID] 4602 48
+[ID] 4602 49
+[ID] 4602 50
+[ID] 4602 62
+[ID] 4602 64
+[ID] 4602 66
+[ID] 4602 67
+[ID] 4602 67
+[ID] 4602 68
+[ID] 4602 69
+[ID] 4602 71
+[ID] 4602 73
+[ID] 4602 74
+[ID] 4602 76
+[ID] 4602 77
+[ID] 4602 80
+[ID] 4602 82
+[ID] 4602 86
+[ID] 4602 92
+[ID] 4602 101
+[ID] 4602 103
+[ID] 4602 109
+[ID] 4602 119
+[ID] 4602 131
+[ID] 4602 138
+[ID] 4602 151
+[ID] 4602 165
+[ID] 4602 168
+[ID] 4602 173
+[ID] 4602 181
+[ID] 4602 185
+[ID] 4602 198-199
+[ID] 4602 216
+[ID] 4160 cv
+[ID] 4160 back
+[ID] 4160 1
+[ID] 4160 6-7
+[ID] 4160 14
+[ID] 4160 20
+[ID] 4160 24
+[ID] 4160 37
+[ID] 4160 43
+[ID] 4160 46
+[ID] 4160 53
+[ID] 4160 58-59
+[ID] 4160 65
+[ID] 4160 72
+[ID] 4160 79
+[ID] 4160 81
+[ID] 4160 89
+[ID] 4160 96
+[ID] 4160 129
+[ID] 4160 137
+[ID] 4160 150
+[ID] 4160 160
+[ID] 4160 161
+[ID] 4160 162
+[ID] 4160 163
+[ID] 4160 164
+[ID] 4160 165
+[ID] 4160 166
+[ID] 4160 167
+[ID] 4160 168-169
+[ID] 4160 175
+[ID] 4160 187
+[ID] 4160 199
+[ID] 4160 207
+[ID] 4160 209
+[ID] 4160 214
+[ID] 4160 230
+[ID] 4160 256
+[ID] 6600 cv
+[ID] 6600 6
+[ID] 6600 10-11
+[ID] 6600 16-17
+[ID] 6600 22
+[ID] 6600 26
+[ID] 6600 36
+[ID] 6600 37
+[ID] 6600 40
+[ID] 6600 36
+[ID] 6600 42
+[ID] 6600 46
+[ID] 6600 55
+[ID] 6600 57
+[ID] 6600 58-59
+[ID] 6600 71
+[ID] 6600 87
+[ID] 6600 91
+[ID] 6600 93
+[ID] 6600 95
+[ID] 6600 100
+[ID] 6600 103
+[ID] 6600 111
+[ID] 6600 112
+[ID] 6600 113
+[ID] 6600 114
+[ID] 6600 115
+[ID] 6600 116
+[ID] 6600 117
+[ID] 6600 118
+[ID] 6600 119
+[ID] 6600 120
+[ID] 6600 121
+[ID] 6600 122
+[ID] 6600 123
+[ID] 6600 124
+[ID] 6600 125
+[ID] 6600 126
+[ID] 6600 127
+[ID] 6600 132
+[ID] 6600 138
+[ID] 6600 148
+[ID] 6600 152
+[ID] 6600 153
+[ID] 6600 154-155
+[ID] 6600 166
+[ID] 6600 171
+[ID] 6600 186
+[ID] 6600 200
+[ID] 6600 206
+[ID] 6600 209
+[ID] 6600 210-211
+[ID] 6600 230
+[ID] 6600 237
+[ID] 6600 243
+[ID] 6600 255
+[ID] 6600 258
+[ID] 6600 260-261
+[ID] 6600 263
+[ID] 6600 268
+[ID] 6600 270
+[ID] 6600 272-273
+[ID] 6600 280
+[ID] 6600 289
+[ID] 6600 299
+[ID] 6600 308
+[ID] 6600 311
+[ID] 6600 325
+[ID] 6600 327
+[ID] 6600 337
+[ID] 6600 346
+[ID] 6600 355
+[ID] 6600 373
+[ID] 6600 374-375
+[ID] 6600 381
+[ID] 6600 386
+[ID] 6600 393
+[ID] 6600 402
+[ID] 6600 405
+[ID] 6600 415
+[ID] 6600 424
+[ID] 6600 425
+[ID] 6600 425
+[ID] 6600 426
+[ID] 6600 426
+[ID] 6600 427
+[ID] 6600 427
+[ID] 6600 428
+[ID] 6600 429
+[ID] 6600 429
+[ID] 6600 431
+[ID] 6600 439
+[ID] 6600 447
+[ID] 6600 462
+[ID] 6600 464
+[ID] 6600 466
+[ID] 6600 467


contributions
===Übernahme Angaben - altes Target: Wastelands-Abbildungsverzeichnis===
8051 6427 illustration u Color
6346 6427 illustration u Color
5790 7366 illustration u Color
7645 7366 illustration u Color
3862 7366 illustration u Color


contributions_illustration
{| class="sortable infotable" style="width:80%;"
2011 715623
!Seite
8545 491375
!<tt>id_illustration</tt>
2520 427653
!Illustrator
3402 71492
! width="20px" class="unsortable" |
773 386571
!Beschreibung
3402 602471
! class="unsortable" |In anderen Quellen
2331 38467
!Link
8545 156978
|-
2331 879326
| 57
</pre>
| <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


*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?===
<pre>
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
</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
Abgerufen von „https://shadowhelix.de/index.php?title=Shadowhelix:Datenbank/Vorschläge&oldid=233445“