repo.or.cz
/
getmangos.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
Removed trailing whitespaces and CRLFs
[getmangos.git]
/
sql
/
updates
/
0.6
/
3110_quest_template.sql
blob
ea92ff9952935bca2e0507da852b04e5950bb9b0
1
update `quest_template` set `RewRepFaction1` =
2
case `RewRepFaction1`
3
when 0 then 0
4
when 11 then 72
5
when 12 then 72
6
when 23 then 54
7
when 29 then 76
8
when 55 then 47
9
when 64 then 54
10
when 68 then 68
11
when 69 then 470
12
when 79 then 69
13
when 80 then 69
14
when 83 then 67
15
when 85 then 76
16
when 104 then 81
17
when 105 then 81
18
when 118 then 68
19
when 119 then 87
20
when 120 then 21
21
when 121 then 21
22
when 126 then 530
23
when 132 then 92
24
when 133 then 93
25
when 414 then 576
26
when 471 then 349
27
when 474 then 369
28
when 534 then 469
29
when 635 then 609
30
when 694 then 471
31
when 776 then 910
32
when 794 then 529
33
when 854 then 577
34
when 874 then 589
35
when 994 then 609
36
when 1214 then 729
37
when 1216 then 730
38
when 1514 then 890
39
when 1515 then 889
40
when 1555 then 909
41
when 1574 then 270
42
when 1577 then 509
43
when 1598 then 510
44
when 1601 then 910
45
when 1635 then 169
46
47
else `RewRepFaction1`*'-1'
48
end;
49
50
update `quest_template` set `RewRepFaction2` =
51
case `RewRepFaction2`
52
when 0 then 0
53
when 11 then 72
54
when 12 then 72
55
when 23 then 54
56
when 29 then 76
57
when 55 then 47
58
when 64 then 54
59
when 68 then 68
60
when 69 then 470
61
when 79 then 69
62
when 80 then 69
63
when 83 then 67
64
when 85 then 76
65
when 104 then 81
66
when 105 then 81
67
when 118 then 68
68
when 119 then 87
69
when 120 then 21
70
when 121 then 21
71
when 126 then 530
72
when 132 then 92
73
when 133 then 93
74
when 414 then 576
75
when 471 then 349
76
when 474 then 369
77
when 534 then 469
78
when 635 then 609
79
when 694 then 471
80
when 776 then 910
81
when 794 then 529
82
when 854 then 577
83
when 874 then 589
84
when 994 then 609
85
when 1214 then 729
86
when 1216 then 730
87
when 1514 then 890
88
when 1515 then 889
89
when 1555 then 909
90
when 1574 then 270
91
when 1577 then 509
92
when 1598 then 510
93
when 1601 then 910
94
when 1635 then 169
95
96
else `RewRepFaction2`*'-1'
97
end;
98