· 8 years ago · Jun 04, 2018, 06:42 PM
1DROP TABLE IF EXISTS `dbc_achievement_criteria`;
2CREATE TABLE `dbc_achievement_criteria` (
3 `Field1` bigint(20) NOT NULL default '0',
4 `Field2` bigint(20) NOT NULL default '0',
5 `Field3` bigint(20) NOT NULL default '0',
6 `Field4` bigint(20) NOT NULL default '0',
7 `Field5` bigint(20) NOT NULL default '0',
8 `Field6` bigint(20) NOT NULL default '0',
9 `Field7` bigint(20) NOT NULL default '0',
10 `Field8` bigint(20) NOT NULL default '0',
11 `Field9` bigint(20) NOT NULL default '0',
12 `Field10` text NOT NULL,
13 `Field11` bigint(20) NOT NULL default '0',
14 `Field12` bigint(20) NOT NULL default '0',
15 `Field13` bigint(20) NOT NULL default '0',
16 `Field14` bigint(20) NOT NULL default '0',
17 `Field15` bigint(20) NOT NULL default '0',
18 `Field16` bigint(20) NOT NULL default '0',
19 `Field17` bigint(20) NOT NULL default '0',
20 `Field18` bigint(20) NOT NULL default '0',
21 `Field19` bigint(20) NOT NULL default '0',
22 `Field20` bigint(20) NOT NULL default '0',
23 `Field21` bigint(20) NOT NULL default '0',
24 `Field22` bigint(20) NOT NULL default '0',
25 `Field23` bigint(20) NOT NULL default '0',
26 `Field24` bigint(20) NOT NULL default '0',
27 `Field25` bigint(20) NOT NULL default '0',
28 `Field26` bigint(20) NOT NULL default '0',
29 `Field27` bigint(20) NOT NULL default '0',
30 `Field28` bigint(20) NOT NULL default '0',
31 `Field29` bigint(20) NOT NULL default '0',
32 `Field30` bigint(20) NOT NULL default '0',
33 `Field31` text NOT NULL,
34 PRIMARY KEY (`Field1`)
35) COMMENT='Export of Achievement_Criteria.dbc';
36
37DELETE FROM `dbc_achievement_criteria`;
38INSERT INTO `dbc_achievement_criteria` (`Field1`, `Field2`, `Field3`, `Field4`, `Field5`, `Field6`, `Field7`, `Field8`, `Field9`, `Field10`, `Field11`, `Field12`, `Field13`, `Field14`, `Field15`, `Field16`, `Field17`, `Field18`, `Field19`, `Field20`, `Field21`, `Field22`, `Field23`, `Field24`, `Field25`, `Field26`, `Field27`, `Field28`, `Field29`, `Field30`, `Field31`) VALUES
39(1910, 910, 27, 8676, 1, 0, 0, 0, 0, 'Elder Wildmane in Zul\'Farrak', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 10'),
40(1911, 910, 27, 8713, 1, 0, 0, 0, 0, 'Elder Starsong in the Sunken Temple', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
41(1912, 910, 27, 8635, 1, 0, 0, 0, 0, 'Elder Splitrock in Maraudon', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
42(1913, 910, 27, 8644, 1, 0, 0, 0, 0, 'Elder Stonefort in Blackrock Spire', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
43(1914, 910, 27, 8619, 1, 0, 0, 0, 0, 'Elder Morndeep in Blackrock Depths', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
44(1915, 910, 27, 8727, 1, 0, 0, 0, 0, 'Elder Farwhisper in Stratholme', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
45(5259, 910, 27, 13017, 1, 0, 0, 0, 0, 'Elder Jarten in Utgarde Keep', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
46(5260, 910, 27, 13021, 1, 0, 0, 0, 0, 'Elder Igasho in The Nexus', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
47(5261, 910, 27, 13022, 1, 0, 0, 0, 0, 'Elder Nurgen in Azjol-Nerub', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
48(5262, 910, 27, 13023, 1, 0, 0, 0, 0, 'Elder Kilias in Drak\'Tharon Keep', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
49(5263, 910, 27, 13065, 1, 0, 0, 0, 0, 'Elder Ohanzee in Gundrak', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
50(5264, 910, 27, 13066, 1, 0, 0, 0, 0, 'Elder Yurauk in the Halls of Stone', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
51(5265, 910, 27, 13067, 1, 0, 0, 0, 0, 'Elder Chogan\'gada in Utgarde Pinnacle', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
52(1916, 911, 27, 8670, 1, 0, 0, 0, 0, 'Elder Runetotem in Razor Hill', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 10'),
53(1917, 911, 27, 8720, 1, 0, 0, 0, 0, 'Elder Skygleam in Azshara', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
54(1918, 911, 27, 8717, 1, 0, 0, 0, 0, 'Elder Moonwarden in The Crossroads', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
55(1919, 911, 27, 8686, 1, 0, 0, 0, 0, 'Elder High Mountain in Camp Taurajo', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
56(1920, 911, 27, 8680, 1, 0, 0, 0, 0, 'Elder Windtotem in Ratchet', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
57(1951, 911, 27, 8715, 1, 0, 0, 0, 0, 'Elder Bladeleaf in Dolanaar', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
58(1952, 911, 27, 8721, 1, 0, 0, 0, 0, 'Elder Starweave in Auberdine', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
59(1953, 911, 27, 8673, 1, 0, 0, 0, 0, 'Elder Bloodhoof in Bloodhoof Village', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
60(1954, 911, 27, 8725, 1, 0, 0, 0, 0, 'Elder Riversong in Astranaar', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
61(1955, 911, 27, 8679, 1, 0, 0, 0, 0, 'Elder Grimtotem in Feralas', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
62(1956, 911, 27, 8685, 1, 0, 0, 0, 0, 'Elder Mistwalker in Dire Maul', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
63(1957, 911, 27, 8723, 1, 0, 0, 0, 0, 'Elder Nightwind in Felwood', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
64(1958, 911, 27, 8682, 1, 0, 0, 0, 0, 'Elder Skyseer in Freewind Post', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
65(1959, 911, 27, 8724, 1, 0, 0, 0, 0, 'Elder Morningdew in Mirage Raceway', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
66(1960, 911, 27, 8671, 1, 0, 0, 0, 0, 'Elder Ragetotem in Tanaris', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
67(1961, 911, 27, 8684, 1, 0, 0, 0, 0, 'Elder Dreamseer in Gadgetzan', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 20'),
68(1962, 911, 27, 8681, 1, 0, 0, 0, 0, 'Elder Thunderhorn in Un\'Goro', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
69(1963, 911, 27, 8726, 1, 0, 0, 0, 0, 'Elder Brightspear in Winterspring', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
70(1964, 911, 27, 8672, 1, 0, 0, 0, 0, 'Elder Stonespire in Everlook', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
71(1965, 911, 27, 8654, 1, 0, 0, 0, 0, 'Elder Primestone in Silithus', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
72(1966, 911, 27, 8719, 1, 0, 0, 0, 0, 'Elder Bladesing in Cenarion Hold', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
73(1922, 912, 27, 8653, 1, 0, 0, 0, 0, 'Elder Goldwell in Kharanos', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 10'),
74(1923, 912, 27, 8647, 1, 0, 0, 0, 0, 'Elder Bellowrage in Blasted Lands', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
75(1924, 912, 27, 8649, 1, 0, 0, 0, 0, 'Elder Stormbrow in Goldshire', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
76(1925, 912, 27, 8722, 1, 0, 0, 0, 0, 'Elder Meadowrun in Western Plaguelands', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
77(1926, 912, 27, 8716, 1, 0, 0, 0, 0, 'Elder Starglade in Zul\'Gurub', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
78(1927, 912, 27, 8674, 1, 0, 0, 0, 0, 'Elder Winterhoof in Booty Bay', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
79(1937, 912, 27, 8642, 1, 0, 0, 0, 0, 'Elder Silvervein in Thelsamar', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
80(1938, 912, 27, 8675, 1, 0, 0, 0, 0, 'Elder Skychaser in Sentinel Hill', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
81(1939, 912, 27, 8636, 1, 0, 0, 0, 0, 'Elder Rumblerock in Burning Steppes', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
82(1940, 912, 27, 8683, 1, 0, 0, 0, 0, 'Elder Dawnstrider in Flame Crest', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
83(1941, 912, 27, 8643, 1, 0, 0, 0, 0, 'Elder Highpeak in The Hinterlands', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
84(1942, 912, 27, 8651, 1, 0, 0, 0, 0, 'Elder Ironband in Searing Gorge', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
85(1944, 912, 27, 8652, 1, 0, 0, 0, 0, 'Elder Graveborn in Brill', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
86(1945, 912, 27, 8645, 1, 0, 0, 0, 0, 'Elder Obsidian in The Sepulcher', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
87(1946, 912, 27, 8688, 1, 0, 0, 0, 0, 'Elder Windrun in Eastern Plaguelands', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
88(1947, 912, 27, 8650, 1, 0, 0, 0, 0, 'Elder Snowcrown in Light\'s Hope Chapel', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 20'),
89(1950, 912, 27, 8714, 1, 0, 0, 0, 0, 'Elder Moonstrike in Scholomance', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
90(1991, 914, 27, 8677, 1, 0, 0, 0, 0, 'Elder Darkhorn in Orgrimmar', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 10'),
91(1992, 914, 27, 8678, 1, 0, 0, 0, 0, 'Elder Wheathoof in Thunder Bluff', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
92(1993, 914, 27, 8648, 1, 0, 0, 0, 0, 'Elder Darkcore in Undercity', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
93(1997, 915, 27, 8866, 1, 0, 0, 0, 0, 'Elder Bronzebeard in Ironforge', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
94(1998, 915, 27, 8646, 1, 0, 0, 0, 0, 'Elder Hammershout in Stormwind', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
95(1999, 915, 27, 8718, 1, 0, 0, 0, 0, 'Elder Bladeswift in Darnassus', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 10'),
96(5141, 1396, 27, 13012, 1, 0, 0, 0, 0, 'Elder Sardis in Valiance Keep', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 10'),
97(5142, 1396, 27, 13013, 1, 0, 0, 0, 0, 'Elder Beldak in Westfall Brigade', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
98(5143, 1396, 27, 13014, 1, 0, 0, 0, 0, 'Elder Morthie in Star\'s Rest', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
99(5144, 1396, 27, 13015, 1, 0, 0, 0, 0, 'Elder Fargal in Frosthold', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
100(5145, 1396, 27, 13033, 1, 0, 0, 0, 0, 'Elder Arp in D.E.H.T.A', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
101(5146, 1396, 27, 13016, 1, 0, 0, 0, 0, 'Elder Northal in Transitus Shield', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
102(5147, 1396, 27, 13018, 1, 0, 0, 0, 0, 'Elder Sandrene in Lakeside Landing', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
103(5148, 1396, 27, 13024, 1, 0, 0, 0, 0, 'Elder Wanikaya in Rainspeaker Rapids', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
104(5149, 1396, 27, 13025, 1, 0, 0, 0, 0, 'Elder Lunaro in Ruins of Tethys', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
105(5150, 1396, 27, 13026, 1, 0, 0, 0, 0, 'Elder Bluewolf in Wintergrasp', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
106(5151, 1396, 27, 13027, 1, 0, 0, 0, 0, 'Elder Tauros in Zim\'Torga', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
107(5154, 1396, 27, 13019, 1, 0, 0, 0, 0, 'Elder Thoim in Moa\'ki Harbor', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
108(5155, 1396, 27, 13028, 1, 0, 0, 0, 0, 'Elder Graymane in K3', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
109(5156, 1396, 27, 13020, 1, 0, 0, 0, 0, 'Elder Stonebeard in Bouldercrag\'s Refuge', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
110(5157, 1396, 27, 13029, 1, 0, 0, 0, 0, 'Elder Pamuya in Warsong Hold', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
111(5158, 1396, 27, 13030, 1, 0, 0, 0, 0, 'Elder Whurain in Camp Oneqwah', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, 'Reach level 20'),
112(5159, 1396, 27, 13031, 1, 0, 0, 0, 0, 'Elder Skywarden in Agmar\'s Hammer', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, ''),
113(5160, 1396, 27, 13032, 1, 0, 0, 0, 0, 'Elder Muraco in Camp Tunka\'lo', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16712190, 0, 0, 0, 0, '');
114
115DELETE `q` FROM `character_queststatus` AS `q`
116LEFT JOIN `dbc_achievement_criteria` AS `dbc` ON (`q`.`quest`=`dbc`.`Field4`)
117LEFT JOIN `character_achievement_progress` AS `progress` ON (`dbc`.`Field1`=`progress`.`criteria`)
118WHERE `progress`.`guid`=NULL;