Projekt

Allgemein

Profil

Fehler #2486 » LFG_Loot.sql

Emme, 25.02.2012 07:01

 
1
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, ElseGroup, ConditionTypeOrReference, ConditionValue1, ConditionValue2, NegativeCondition, `Comment`)
2
VALUES
3
-- Stoff: kein Leder
4
(5, 51999, 51968, 1, 7, 414, 1, 1, 'LFG 5-25 Cloth Drop'),
5
(5, 52000, 51973, 1, 7, 414, 1, 1, 'LFG 24-34 Cloth Drop'),
6
(5, 52001, 51974, 1, 7, 414, 1, 1, 'LFG 35-45 Cloth Drop'),
7
(5, 52002, 51967, 1, 7, 414, 1, 1, 'LFG 46-55 Cloth Drop'),
8
(5, 52002, 51972, 1, 7, 414, 1, 1, 'LFG 46-55 Cloth Drop'),
9
(5, 52003, 51971, 1, 7, 414, 1, 1, 'LFG 56-60 Cloth Drop'),
10
(5, 52004, 51970, 1, 7, 414, 1, 1, 'LFG 60-64 Cloth Drop'),
11
(5, 52005, 51969, 1, 7, 414, 1, 1, 'LFG 65-70 Cloth Drop'),
12

    
13
-- Leder: Leder
14
(5, 51999, 51964, 1, 7, 414, 1, 0, 'LFG 5-25 Leather Drop'),
15
(5, 52000, 51965, 1, 7, 414, 1, 0, 'LFG 24-34 Leather Drop'),
16
(5, 52001, 51966, 1, 7, 414, 1, 0, 'LFG 35-45 Leather Drop'),
17
(5, 52002, 51962, 1, 7, 414, 1, 0, 'LFG 46-55 Leather Drop'),
18
(5, 52002, 51963, 1, 7, 414, 1, 0, 'LFG 46-55 Leather Drop'),
19
(5, 52003, 51959, 1, 7, 414, 1, 0, 'LFG 56-60 Leather Drop'),
20
(5, 52004, 51960, 1, 7, 414, 1, 0, 'LFG 60-64 Leather Drop'),
21
(5, 52005, 51961, 1, 7, 414, 1, 0, 'LFG 65-70 Leather Drop'),
22
-- Leder: keine Schwere R?stung
23
(5, 51999, 51964, 1, 7, 413, 1, 1, 'LFG 5-25 Leather Drop'),
24
(5, 52000, 51965, 1, 7, 413, 1, 1, 'LFG 24-34 Leather Drop'),
25
(5, 52001, 51966, 1, 7, 413, 1, 1, 'LFG 35-45 Leather Drop'),
26
(5, 52002, 51962, 1, 7, 413, 1, 1, 'LFG 46-55 Leather Drop'),
27
(5, 52002, 51963, 1, 7, 413, 1, 1, 'LFG 46-55 Leather Drop'),
28
(5, 52003, 51959, 1, 7, 413, 1, 1, 'LFG 56-60 Leather Drop'),
29
(5, 52004, 51960, 1, 7, 413, 1, 1, 'LFG 60-64 Leather Drop'),
30
(5, 52005, 51961, 1, 7, 413, 1, 1, 'LFG 65-70 Leather Drop'),
31

    
32
-- Schwere R?stung: Schwere R?stung
33
(5, 51999, 51978, 1, 7, 413, 1, 0, 'LFG 5-25 Mail Drop'),
34
(5, 52000, 51980, 1, 7, 413, 1, 0, 'LFG 24-34 Mail Drop'),
35
(5, 52001, 51976, 1, 7, 413, 1, 0, 'LFG 35-45 Mail Drop'),
36
(5, 52002, 51981, 1, 7, 413, 1, 0, 'LFG 46-55 Mail Drop'),
37
(5, 52002, 51982, 1, 7, 413, 1, 0, 'LFG 46-55 Mail Drop'),
38
(5, 52003, 51977, 1, 7, 413, 1, 0, 'LFG 56-60 Mail Drop'),
39
(5, 52004, 51979, 1, 7, 413, 1, 0, 'LFG 60-64 Mail Drop'),
40
(5, 52005, 51975, 1, 7, 413, 1, 0, 'LFG 65-70 Mail Drop'),
41
-- Schwere R?stung: keine Platte
42
(5, 52001, 51976, 1, 7, 293, 1, 1, 'LFG 35-45 Mail Drop'),
43
(5, 52002, 51981, 1, 7, 293, 1, 1, 'LFG 46-55 Mail Drop'),
44
(5, 52002, 51982, 1, 7, 293, 1, 1, 'LFG 46-55 Mail Drop'),
45
(5, 52003, 51977, 1, 7, 293, 1, 1, 'LFG 56-60 Mail Drop'),
46
(5, 52004, 51979, 1, 7, 293, 1, 1, 'LFG 60-64 Mail Drop'),
47
(5, 52005, 51975, 1, 7, 293, 1, 1, 'LFG 65-70 Mail Drop'),
48

    
49
-- Platte: Platte
50
(5, 52001, 51984, 1, 7, 293, 1, 0, 'LFG 35-45 Plate Mail Drop'),
51
(5, 52002, 51989, 1, 7, 293, 1, 0, 'LFG 46-55 Plate Mail Drop'),
52
(5, 52002, 51990, 1, 7, 293, 1, 0, 'LFG 46-55 Plate Mail Drop'),
53
(5, 52003, 51985, 1, 7, 293, 1, 0, 'LFG 56-60 Plate Mail Drop'),
54
(5, 52004, 51987, 1, 7, 293, 1, 0, 'LFG 60-64 Plate Mail Drop'),
55
(5, 52005, 51983, 1, 7, 293, 1, 0, 'LFG 65-70 Plate Mail Drop');
    (1-1/1)