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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(- contributions (diverse))
(→‎illustrations_source: -Shadowrun Fourth Edition, SRM Season 04)
Zeile 89: Zeile 89:


===illustrations_source===
===illustrations_source===
Shadowrun 4th Edition (2313)
<pre>
+[ID] 2313 cv center
+[ID] 2313 back sixth-nw
+[ID] 2313 back sixth-sw
+[ID] 2313 back sixth-se
+[ID] 2313 5 full
+[ID] 2313 8 half-upper
+[ID] 2313 15 full
+[ID] 2313 18 half-upper
+[ID] 2313 20 half-left
+[ID] 2313 23 full
+[ID] 2313 26 half-upper
+[ID] 2313 28 half-upper
+[ID] 2313 37 full
+[ID] 2313 41 half-upper
+[ID] 2313 44 half-upper
+[ID] 2313 48 half-upper
+[ID] 2313 53 full
+[ID] 2313 57 half-upper
+[ID] 2313 65 sixth-se
+[ID] 2313 66 sixth-sw
+[ID] 2313 66 sixth-ne
+[ID] 2313 66 sixth-se
+[ID] 2313 67 sixth-w
+[ID] 2313 68 half-left
+[ID] 2313 71 full
+[ID] 2313 77
+[ID] 2313 82 half-upper
+[ID] 2313 87 half-upper
+[ID] 2313 89 half-left
+[ID] 2313 90 half-right
+[ID] 2313 91 half-left
+[ID] 2313 92 half-right
+[ID] 2313 93 half-left
+[ID] 2313 94 half-right
+[ID] 2313 95 half-left
+[ID] 2313 96 half-right
+[ID] 2313 97 half-left
+[ID] 2313 98 half-right
+[ID] 2313 99 half-left
+[ID] 2313 100 half-right
+[ID] 2313 101 half-left
+[ID] 2313 102 half-right
+[ID] 2313 103 half-left
+[ID] 2313 104 half-right
+[ID] 2313 107 full
+[ID] 2313 112 half-upper
+[ID] 2313 116 half-left
+[ID] 2313 126 half-upper
+[ID] 2313 133 full
+[ID] 2313 136 half-upper
+[ID] 2313 143 half-right
+[ID] 2313 147 sixth-w
+[ID] 2313 150 half-upper
+[ID] 2313 156 half-upper
+[ID] 2313 165 full
+[ID] 2313 171 half-upper
+[ID] 2313 177 half-upper
+[ID] 2313 182 center
+[ID] 2313 186 half-upper
+[ID] 2313 190 half-upper
+[ID] 2313 196 half-upper
+[ID] 2313 207 full
+[ID] 2313 211 half-upper
+[ID] 2313 213 half-upper
+[ID] 2313 217 half-upper
+[ID] 2313 222 half-upper
+[ID] 2313 230 half-upper
+[ID] 2313 234 half-left
+[ID] 2313 240 sixth-nw
+[ID] 2313 240 sixth-sw
+[ID] 2313 243 full
+[ID] 2313 247 half-right
+[ID] 2313 251 half-upper
+[ID] 2313 257 half-upper
+[ID] 2313 260 half-upper
+[ID] 2313 262 half-upper
+[ID] 2313 270 third-upper
+[ID] 2313 273 full
+[ID] 2313 274 half-right
+[ID] 2313 282 sixth-w
+[ID] 2313 282 sixth-ne
+[ID] 2313 282 sixth-se
+[ID] 2313 283 sixth-w
+[ID] 2313 283 sixth-e
+[ID] 2313 284 sixth-nw
+[ID] 2313 284 sixth-sw
+[ID] 2313 284 sixth-e
+[ID] 2313 285 sixth-nw
+[ID] 2313 292 sixth-nw
+[ID] 2313 292 sixth-sw
+[ID] 2313 292 sixth-ne
+[ID] 2313 292 sixth-se
+[ID] 2313 293 sixth-nw
+[ID] 2313 293 sixth-sw
+[ID] 2313 293 sixth-ne
+[ID] 2313 293 sixth-se
+[ID] 2313 294 sixth-nw
+[ID] 2313 294 sixth-ne
+[ID] 2313 294 sixth-se
+[ID] 2313 295 sixth-nw
+[ID] 2313 295 sixth-w
+[ID] 2313 295 sixth-sw
+[ID] 2313 295 sixth-ne
+[ID] 2313 295 sixth-e
+[ID] 2313 295 sixth-se
+[ID] 2313 296 sixth-sw
+[ID] 2313 296 sixth-ne
+[ID] 2313 296 sixth-se
+[ID] 2313 297 sixth-nw
+[ID] 2313 297 sixth-ne
+[ID] 2313 299 full
+[ID] 2313 306
+[ID] 2313 306
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 307
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 308
+[ID] 2313 309
+[ID] 2313 309
+[ID] 2313 309
+[ID] 2313 309
+[ID] 2313 309
+[ID] 2313 309
+[ID] 2313 310
+[ID] 2313 310
+[ID] 2313 310
+[ID] 2313 312 sixth-ne
+[ID] 2313 313 sixth-ne
+[ID] 2313 315 sixth-se
+[ID] 2313 317 sixth-sw
+[ID] 2313 317 sixth-ne
+[ID] 2313 318 sixth-nw
+[ID] 2313 323 sixth-se
+[ID] 2313 326
+[ID] 2313 327
+[ID] 2313 328
+[ID] 2313 329
+[ID] 2313 332 sixth-ne
+[ID] 2313 334 sixth-nw
+[ID] 2313 336 sixth-e
+[ID] 2313 337 sixth-nw
+[ID] 2313 337 sixth-ne
+[ID] 2313 342 sixth-nw
+[ID] 2313 342 sixth-ne
+[ID] 2313 352 center
</pre>
SRM 04-01 bis SRM 04-07 und SRM 04-09 bis SRM 04-11
<pre>
+[ID] 8870 cv half-middle
+[ID] 8870 7 half-upper
+[ID] 8870 15 half-upper
+[ID] 8870 20 half-upper
+[ID] 8870 24 sixth-nw
+[ID] 8870 24 sixth-se
+[ID] 8870 25 sixth-ne
+[ID] 8870 26 sixth-nw
+[ID] 8870 27 full
+[ID] 8870 28 full
+[ID] 8870 29 full
+[ID] 8870 30 third-upper
+[ID] 8870 31 third-upper
+[ID] 8870 32 third-upper
+[ID] 8870 33 third-upper
+[ID] 7403 cv half-middle
+[ID] 7403 10 half-upper
+[ID] 7403 15 half-upper
+[ID] 7403 20 half-upper
+[ID] 7403 26 sixth-nw
+[ID] 7403 26 sixth-ne
+[ID] 7403 27 sixth-nw
+[ID] 7403 27 sixth-ne
+[ID] 7403 28 sixth-nw
+[ID] 7403 28 sixth-ne
+[ID] 7403 29 full
+[ID] 7403 30 full
+[ID] 7403 31 full
+[ID] 7403 32 third-upper
+[ID] 7403 33 third-upper
+[ID] 7403 34 third-upper
+[ID] 7403 35 third-upper
+[ID] 7403 36 third-upper
+[ID] 4775 cv half-middle
+[ID] 4775 7 half-lower
+[ID] 4775 13 half-upper
+[ID] 4775 19 half-upper
+[ID] 4775 27 sixth-nw
+[ID] 4775 27 sixth-e
+[ID] 4775 28 sixth-sw
+[ID] 4775 29 sixth-w
+[ID] 4775 30 full
+[ID] 4775 31 full
+[ID] 4775 32 full
+[ID] 4775 33 third-upper
+[ID] 4775 34 third-upper
+[ID] 4775 35 third-upper
+[ID] 4775 36 third-upper
+[ID] 19 cv half-middle
+[ID] 19 6 half-upper
+[ID] 19 10 half-upper
+[ID] 19 12 half-upper
+[ID] 19 21 sixth-nw
+[ID] 19 22 sixth-nw
+[ID] 19 22 sixth-ne
+[ID] 19 23 sixth-sw
+[ID] 19 24 sixth-nw
+[ID] 19 24 sixth-ne
+[ID] 19 25 full
+[ID] 19 26 sixth-e
+[ID] 19 27 third-upper
+[ID] 19 28 third-upper
+[ID] 19 29 third-upper
+[ID] 19 30 third-upper
+[ID] 4661 cv half-middle
+[ID] 4661 8 half-upper
+[ID] 4661 11 half-upper
+[ID] 4661 13 half-upper
+[ID] 4661 17 sixth-w
+[ID] 4661 19 third-upper
+[ID] 4661 20 half-upper
+[ID] 4661 20 half-lower
+[ID] 1046 cv half-middle
+[ID] 1046 7 half-upper
+[ID] 1046 9 full
+[ID] 1046 13 half-upper
+[ID] 1046 17 half-upper
+[ID] 1046 23 sixth-nw
+[ID] 1046 23 sixth-ne
+[ID] 1046 24 sixth-w
+[ID] 1046 24 sixth-ne
+[ID] 1046 25 sixth-w
+[ID] 1046 26 sixth-nw
+[ID] 1046 26 sixth-e
+[ID] 1046 27 sixth-ne
+[ID] 1046 28 sixth-nw
+[ID] 1046 28 sixth-e
+[ID] 1046 30 third-upper
+[ID] 1046 31 third-upper
+[ID] 1046 32 third-upper
+[ID] 1046 33 third-upper
+[ID] 1046 34 third-upper
+[ID] 1046 35 full
+[ID] 1046 36 full
+[ID] 8001 cv half-middle
+[ID] 8001 6 half-upper
+[ID] 8001 10 half-upper
+[ID] 8001 13 half-upper
+[ID] 8001 14 half-upper
+[ID] 8001 23 sixth-nw
+[ID] 8001 23 sixth-e
+[ID] 8001 24 sixth-ne
+[ID] 8001 25 sixth-nw
+[ID] 8001 25 sixth-ne
+[ID] 8001 26 third-upper
+[ID] 8001 27 third-upper
+[ID] 8001 28 third-upper
+[ID] 8001 29 third-upper
+[ID] 8001 30 full
+[ID] 8001 31 full
+[ID] 9871 cv half-middle
+[ID] 9871 8 half-upper
+[ID] 9871 15 half-upper
+[ID] 9871 16 half-upper
+[ID] 9871 22 sixth-nw
+[ID] 9871 22 sixth-e
+[ID] 9871 23 sixth-w
+[ID] 9871 23 sixth-ne
+[ID] 9871 24 sixth-nw
+[ID] 9871 25 third-upper
+[ID] 9871 26 third-upper
+[ID] 9871 27 third-upper
+[ID] 9871 28 third-upper
+[ID] 9871 29 full
+[ID] 9871 30 full
+[ID] 9871 31 full
+[ID] 3689 cv half-middle
+[ID] 3689 7 half-upper
+[ID] 3689 15 half-right
+[ID] 3689 21 half-upper
+[ID] 3689 28 sixth-w
+[ID] 3689 28 sixth-se
+[ID] 3689 29 sixth-e
+[ID] 3689 30 sixth-w
+[ID] 3689 30 sixth-e
+[ID] 3689 31 sixth-w
+[ID] 3689 31 sixth-e
+[ID] 3689 33 third-upper
+[ID] 3689 34 third-upper
+[ID] 3689 35 third-upper
+[ID] 3689 36 third-upper
+[ID] 3689 37 full
+[ID] 3689 38 full
+[ID] 3689 39 full
+[ID] 3689 40 full
+[ID] 5662 cv half-middle
+[ID] 5662 7 half-upper
+[ID] 5662 15 half-upper
+[ID] 5662 21 half-right
+[ID] 5662 25 sixth-nw
+[ID] 5662 25 sixth-se
+[ID] 5662 26 third-upper
+[ID] 5662 27 third-upper
+[ID] 5662 28 third-upper
+[ID] 5662 29 full
+[ID] 5662 30 full
+[ID] 2833 cv half-middle
+[ID] 2833 9 half-upper
+[ID] 2833 13 half-upper
+[ID] 2833 21 half-upper
+[ID] 2833 27 sixth-nw
+[ID] 2833 27 sixth-ne
+[ID] 2833 28 sixth-nw
+[ID] 2833 28 sixth-ne
+[ID] 2833 29 sixth-nw
+[ID] 2833 29 sixth-ne
+[ID] 2833 30 sixth-nw
+[ID] 2833 31 full
+[ID] 2833 32 full
+[ID] 2833 33 full
+[ID] 2833 34 third-upper
+[ID] 2833 35 third-upper
+[ID] 2833 36 third-upper
+[ID] 2833 37 third-upper
+[ID] 2833 39 full
</pre>
<pre>
<pre>
SR4 Anniversary (vgl. Anmerkungen in der Diskussion; Problemfälle)
SR4 Anniversary (vgl. Anmerkungen in der Diskussion; Problemfälle)

Version vom 27. März 2016, 03:12 Uhr

Shadowhelix:Datenbank

Erweiterung

contributors_referenced_name

458	Erich Schriner
-> siehe Dopplungen unten

contributors

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

+[ID]	Petrov		Miroslav				

Shadowrun TCG:

+[ID]	Hudson		Heather				
+[ID]	Ho		Patrick				
+[ID]	Fischer		Scott	M			
+[ID]	Gregory		Barry				
+[ID]	Goleash		Grant				

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?
HBS-Artist und zwei Autoren aus der SR Anthology (weblinks s.u.):
+[ID]	Ishmael		Tristin				

contributors_weblink

1588	https://www.facebook.com/groups/114658181901791	


Heather Hudson
+[ID]	http://www.studiowondercabinet.com	

Liam C.
+[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	


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	

contributions

illustrations_source

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

contributions_illustration

Runners Companion (825), Shadows of Asia (1945), SRM 06-02 (3581), Serrated Edge (4513), Market Panic (8945)

9243	109375
9243	463502
9243	406351
830	174903
830	650917
8109	954067
8109	468032
8109	231685
5170	790823
5170	140783
5170	547096
3904	407165
3904	653914
3904	239675
3904	473980
830	702359
830	925873
830	957680
6666	509162
6666	137958
6666	715682
4180	102635
532	840935
6115	958603
8923	978450
5747	673142
8919	538794
8919	503192
5790	385164
4595	56182
5747	712583
8923	193540
830	279840
830	241078
8427	135278
5747	438671
9572	97285
9572	874602
9572	270589
6666	632759
8923	794210
5747	374265
5747	150639
3536	94257
3536	473098
5747	618543
5747	870193
1588	109528
2320	294570
5747	389751
5170	140573
5170	347192
5170	765049
5747	693827
5170	932147
8923	923715
8923	496073
8923	89567
7177	872516
7177	825061
7177	482963
7177	236501
2520	791648
2520	481239
2520	719528
2520	123698
2520	816593
2520	350829
2520	134950
2520	92143
6573	51429
6573	482179
6573	597463
6573	615408
903	163840
6131	692314
2894	634502
5176	154398
903	128694
4595	216584
7177	14756
7177	598706
8545	194852
8545	386251
8545	96142
133	120654
903	264073
7186	473089
6573	308192
4180	410398
133	35194
4485	984210
903	590317
133	421358
3402	471890
8545	695247
8545	478253
2513	386951
8545	907683

sources

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.

+[ID]	Shadowrun: Crossfire	en	card game
+[ID]	Shadowrun: High Caliber Ops	en	card game
+[ID]	Shadowrun (SNES)	en	video game
+[ID]	Shadowrun (Mega Drive)	en	video game
+[ID]	Shadowrun (Mega-CD)	jp	video game
+[ID]	Shadowrun (2007)	en	video game
+[ID]	Shadowrun Returns	en	video game
+[ID]	Shadowrun: Dragonfall	en	video game
+[ID]	Shadowrun: Dragonfall Director's Cut	en	video game
+[ID]	Shadowrun: Hong Kong	en	video game
+[ID]	Shadowrun Chronicles	en	video game
+[ID]	Shadowrun: Shadows of Hong Kong	en	DLC

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