Shadowhelix:Datenbank/Vorschläge

Aus Shadowhelix
< Shadowhelix:Datenbank
Version vom 3. März 2016, 18:11 Uhr von Loki (Diskussion | Beiträge) (-contributions (Chrome Flesh, Data Trails, Rigger 5.0))
Zur Navigation springen Zur Suche springen

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