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

Aus Shadowhelix
Zur Navigation springen Zur Suche springen
(-contributions (02.03.2016))
(-contributions (Chrome Flesh, Data Trails, Rigger 5.0))
Zeile 2: Zeile 2:


==Erweiterung==
==Erweiterung==
===contributors===
<pre>
<pre>
INSERT INTO contributors(forename_first) VALUES('Liam.C');
INSERT INTO contributors(forename_first) VALUES('Liam.C');
Zeile 17: Zeile 19:
INSERT INTO contributors_weblink(id_contributor, url) VALUES(7389, 'https://www.facebook.com/MichaelRookardArt');
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');
INSERT INTO contributors_weblink(id_contributor, url) VALUES(6115, 'https://www.facebook.com/peter.bergting');
</pre>
Chrome Flesh:
<pre>
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8545, 'cover art');
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');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 3402, 'illustration');
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');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 8964, 'illustration');
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');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(9450, 1380, 'illustration');
</pre>
Data Trails:
<pre>
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');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(7003, 1380, 'illustration');
</pre>
Rigger 5.0:
<pre>
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8227, 'cover art');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4662, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 3402, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 8545, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 4485, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 5837, 'illustration');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor) VALUES(1289, 903, 'illustration');
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:
<pre>
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5699, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 4080, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5475, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 13, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6666, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6131, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1009, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 5790, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 1588, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 7645, 'illustration', 'Color');
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');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 8427, 'illustration', 'Color');
INSERT INTO contributions(id_source, id_contributor, standard_descriptor, title contribution) VALUES(3110, 6802, 'illustration', 'Color');
</pre>
</pre>


Zeile 125: Zeile 37:
INSERT INTO contributors(id_contributor, surname, forename_first) VALUES(+[ID], 'Peuler', 'Chris');
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');
INSERT INTO contributors(id_contributor, surname, forename_second, forename_first) VALUES(+[ID], 'Webster', 'Cory', 'James');
</pre>
===contributions===
Shadowrun TCG:
<pre>
5699 3110 illustration Color
4080 3110 illustration Color
5475 3110 illustration Color
13 3110 illustration Color
6666 3110 illustration Color
6131 3110 illustration Color
1009 3110 illustration Color
5790 3110 illustration Color
1588 3110 illustration Color
7645 3110 illustration Color
4180 3110 illustration Color
3557 3110 illustration Color
8123 3110 illustration Color
3963 3110 illustration Color
9243 3110 illustration Color
4845 3110 illustration Color
1212 3110 illustration Color
3536 3110 illustration Color
2820 3110 illustration Color
9435 3110 illustration Color
7832 3110 illustration Color
4302 3110 illustration Color
7842 3110 illustration Color
1628 3110 illustration Color
2792 3110 illustration Color
6115 3110 illustration Color
8207 3110 illustration Color
6937 3110 illustration Color
4962 3110 illustration Color
3862 3110 illustration Color
4305 3110 illustration Color
8427 3110 illustration Color
6802 3110 illustration Color
</pre>
</pre>


Version vom 3. März 2016, 18:11 Uhr

Shadowhelix:Datenbank

Erweiterung

contributors

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');

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');

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): 

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], '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');
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');

contributions

Shadowrun TCG: 

5699	3110	illustration		Color
4080	3110	illustration		Color
5475	3110	illustration		Color
13	3110	illustration		Color
6666	3110	illustration		Color
6131	3110	illustration		Color
1009	3110	illustration		Color
5790	3110	illustration		Color
1588	3110	illustration		Color
7645	3110	illustration		Color
4180	3110	illustration		Color
3557	3110	illustration		Color
8123	3110	illustration		Color
3963	3110	illustration		Color
9243	3110	illustration		Color
4845	3110	illustration		Color
1212	3110	illustration		Color
3536	3110	illustration		Color
2820	3110	illustration		Color
9435	3110	illustration		Color
7832	3110	illustration		Color
4302	3110	illustration		Color
7842	3110	illustration		Color
1628	3110	illustration		Color
2792	3110	illustration		Color
6115	3110	illustration		Color
8207	3110	illustration		Color
6937	3110	illustration		Color
4962	3110	illustration		Color
3862	3110	illustration		Color
4305	3110	illustration		Color
8427	3110	illustration		Color
6802	3110	illustration		Color

Und hier mal ein erster Schwung für contributions_illustration (Shadow Spells, Street Grimoire, Data Trails): 

Street Grimoire:
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:
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);

Korrektur

Dopplungen?

  • 3077 - Joshua Howell
  • 7157 - Joshua Rowell
  • 7468 - Larry Almore
  • 8047 - Larry Elmore
  • 5665 - Jacob Glaser
  • 8919 - Jason Glaser
Abgerufen von „https://shadowhelix.de/index.php?title=Shadowhelix:Datenbank/Vorschläge&oldid=216944“