0WYJduqE

1CREATE TABLE IF NOT EXISTS `scheme_buffer_profiles` (
2  `charId` int(10) unsigned NOT NULL,
3  `profiles` varchar(45) DEFAULT NULL
4) ENGINE=InnoDB DEFAULT CHARSET=latin1;
5
6CREATE TABLE IF NOT EXISTS `scheme_buffs` (
7  `buff_name` varchar(45) CHARACTER SET latin1 COLLATE latin1_spanish_ci DEFAULT NULL,
8  `buff_id` int(10) DEFAULT NULL,
9  `buff_lvl` int(10) DEFAULT NULL
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;
11
12CREATE TABLE IF NOT EXISTS `scheme_char_buffs` (
13  `charId` int(10) unsigned NOT NULL,
14  `profiles` varchar(45) DEFAULT NULL,
15  `buff_name` varchar(45) DEFAULT NULL
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18INSERT INTO `scheme_buffs` VALUES ('Improved Combat', '1499', '1');
19INSERT INTO `scheme_buffs` VALUES ('Improved Magic', '1500', '1');
20INSERT INTO `scheme_buffs` VALUES ('Improved Condition', '1501', '1');
21INSERT INTO `scheme_buffs` VALUES ('Improved Critical', '1502', '1');
22INSERT INTO `scheme_buffs` VALUES ('Improved Shield Def', '1503', '1');
23INSERT INTO `scheme_buffs` VALUES ('Improved Movement', '1504', '1');
24INSERT INTO `scheme_buffs` VALUES ('Blood Awakening', '1519', '1');
25INSERT INTO `scheme_buffs` VALUES ('Wind Walk', '1204', '2');
26INSERT INTO `scheme_buffs` VALUES ('Might', '1068', '3');
27INSERT INTO `scheme_buffs` VALUES ('Shield', '1040', '3');
28INSERT INTO `scheme_buffs` VALUES ('Greater Might', '1388', '3');
29INSERT INTO `scheme_buffs` VALUES ('Greater Shield', '1389', '3');
30INSERT INTO `scheme_buffs` VALUES ('Bless the Body', '1045', '6');
31INSERT INTO `scheme_buffs` VALUES ('Body of Avatar', '1311', '6');
32INSERT INTO `scheme_buffs` VALUES ('Bless the Soul', '1048', '6');
33INSERT INTO `scheme_buffs` VALUES ('Magic Barrier', '1036', '2');
34INSERT INTO `scheme_buffs` VALUES ('Vampiric Rage', '1268', '4');
35INSERT INTO `scheme_buffs` VALUES ('Haste', '1086', '2');
36INSERT INTO `scheme_buffs` VALUES ('Berserker Spirit', '1062', '2');
37INSERT INTO `scheme_buffs` VALUES ('Acumen', '1085', '3');
38INSERT INTO `scheme_buffs` VALUES ('Empower', '1059', '3');
39INSERT INTO `scheme_buffs` VALUES ('Wild Magic', '1303', '2');
40INSERT INTO `scheme_buffs` VALUES ('Guidance', '1240', '3');
41INSERT INTO `scheme_buffs` VALUES ('Focus', '1077', '3');
42INSERT INTO `scheme_buffs` VALUES ('Death Whisper', '1242', '3');
43INSERT INTO `scheme_buffs` VALUES ('Counter Critical', '1542', '1');
44INSERT INTO `scheme_buffs` VALUES ('Agility', '1087', '3');
45INSERT INTO `scheme_buffs` VALUES ('Concentration', '1078', '6');
46INSERT INTO `scheme_buffs` VALUES ('Regeneration', '1044', '3');
47INSERT INTO `scheme_buffs` VALUES ('Mana Regeneration', '1047', '4');
48INSERT INTO `scheme_buffs` VALUES ('Clarity', '1397', '3');
49INSERT INTO `scheme_buffs` VALUES ('Bless Shield', '1243', '6');
50INSERT INTO `scheme_buffs` VALUES ('Advanced Block', '1304', '3');
51INSERT INTO `scheme_buffs` VALUES ('Mental Shield', '1035', '4');
52INSERT INTO `scheme_buffs` VALUES ('Resist Shock', '1259', '4');
53INSERT INTO `scheme_buffs` VALUES ('Invigor', '1032', '3');
54INSERT INTO `scheme_buffs` VALUES ('Resist Fire', '1191', '3');
55INSERT INTO `scheme_buffs` VALUES ('Resist Aqua', '1182', '3');
56INSERT INTO `scheme_buffs` VALUES ('Resist Wind', '1189', '3');
57INSERT INTO `scheme_buffs` VALUES ('Resist Poison', '1033', '1');
58INSERT INTO `scheme_buffs` VALUES ('Holy Resistance', '1392', '3');
59INSERT INTO `scheme_buffs` VALUES ('Unholy Resistance', '1393', '3');
60INSERT INTO `scheme_buffs` VALUES ('Elemental Protection', '1352', '1');
61INSERT INTO `scheme_buffs` VALUES ('Divine Protection', '1353', '1');
62INSERT INTO `scheme_buffs` VALUES ('Arcane Protection', '1354', '1');
63INSERT INTO `scheme_buffs` VALUES ('Holy Weapon', '1043', '1');
64INSERT INTO `scheme_buffs` VALUES ('Dance of the Warrior', '271', '1');
65INSERT INTO `scheme_buffs` VALUES ('Dance of Inspiration', '272', '1');
66INSERT INTO `scheme_buffs` VALUES ('Dance of the Mystic', '273', '1');
67INSERT INTO `scheme_buffs` VALUES ('Dance of Fire', '274', '1');
68INSERT INTO `scheme_buffs` VALUES ('Dance of Fury', '275', '1');
69INSERT INTO `scheme_buffs` VALUES ('Dance of Concentration', '276', '1');
70INSERT INTO `scheme_buffs` VALUES ('Dance of Light', '277', '1');
71INSERT INTO `scheme_buffs` VALUES ('Dance of Aqua Guard', '307', '1');
72INSERT INTO `scheme_buffs` VALUES ('Dance of Earth Guard', '309', '1');
73INSERT INTO `scheme_buffs` VALUES ('Dance of Alignment', '530', '1');
74INSERT INTO `scheme_buffs` VALUES ('Dance of Protection', '311', '1');
75INSERT INTO `scheme_buffs` VALUES ('Dance of the Vampire', '310', '1');
76INSERT INTO `scheme_buffs` VALUES ('Dance of Berserker', '915', '1');
77INSERT INTO `scheme_buffs` VALUES ('Dance of Shadows', '366', '1');
78INSERT INTO `scheme_buffs` VALUES ('Sirens Dance', '365', '1');
79INSERT INTO `scheme_buffs` VALUES ('Song of Earth', '264', '1');
80INSERT INTO `scheme_buffs` VALUES ('Song of Life', '265', '1');
81INSERT INTO `scheme_buffs` VALUES ('Song of Water', '266', '1');
82INSERT INTO `scheme_buffs` VALUES ('Song of Warding', '267', '1');
83INSERT INTO `scheme_buffs` VALUES ('Song of Wind', '268', '1');
84INSERT INTO `scheme_buffs` VALUES ('Song of Hunter', '269', '1');
85INSERT INTO `scheme_buffs` VALUES ('Song of Vitality', '304', '1');
86INSERT INTO `scheme_buffs` VALUES ('Song of Flame Guard', '306', '1');
87INSERT INTO `scheme_buffs` VALUES ('Song of Storm Guard', '308', '1');
88INSERT INTO `scheme_buffs` VALUES ('Song of Elemental', '529', '1');
89INSERT INTO `scheme_buffs` VALUES ('Song of Invocation', '270', '1');
90INSERT INTO `scheme_buffs` VALUES ('Song of Purification', '914', '1');
91INSERT INTO `scheme_buffs` VALUES ('Song of Meditation', '363', '1');
92INSERT INTO `scheme_buffs` VALUES ('Song of Champion', '364', '1');
93INSERT INTO `scheme_buffs` VALUES ('Song of Renewal', '349', '1');
94INSERT INTO `scheme_buffs` VALUES ('Chant of Battle', '1007', '3');
95INSERT INTO `scheme_buffs` VALUES ('Chant of Shielding', '1009', '3');
96INSERT INTO `scheme_buffs` VALUES ('War Chant', '1390', '3');
97INSERT INTO `scheme_buffs` VALUES ('Earth Chant', '1391', '3');
98INSERT INTO `scheme_buffs` VALUES ('Chant of Fire', '1006', '3');
99INSERT INTO `scheme_buffs` VALUES ('Chant of Flame', '1002', '3');
100INSERT INTO `scheme_buffs` VALUES ('Chant of Fury', '1251', '2');
101INSERT INTO `scheme_buffs` VALUES ('Chant of Evasion', '1252', '3');
102INSERT INTO `scheme_buffs` VALUES ('Chant of Rage', '1253', '3');
103INSERT INTO `scheme_buffs` VALUES ('Chant of Vampire', '1310', '4');
104INSERT INTO `scheme_buffs` VALUES ('Chant of Eagle', '1309', '3');
105INSERT INTO `scheme_buffs` VALUES ('Chant of Predator', '1308', '3');
106INSERT INTO `scheme_buffs` VALUES ('Chant of Spirit', '1362', '1');
107INSERT INTO `scheme_buffs` VALUES ('Chant Of Protection', '1461', '1');
108INSERT INTO `scheme_buffs` VALUES ('Chant of Victory', '1363', '1');
109INSERT INTO `scheme_buffs` VALUES ('Chant of Magnus', '1413', '1');
110INSERT INTO `scheme_buffs` VALUES ('Eye of Paagrio', '1364', '1');
111-- INSERT INTO `scheme_buffs` VALUES ('Song of Wind Storm', '764', '1');
112INSERT INTO `scheme_buffs` VALUES ('Pagrian Gift', '1003', '3');
113INSERT INTO `scheme_buffs` VALUES ('The Wisdom of Pagrio', '1004', '3');
114INSERT INTO `scheme_buffs` VALUES ('Blessings of Pagrio', '1005', '3');
115INSERT INTO `scheme_buffs` VALUES ('The Glory of Pagrio', '1008', '3');
116INSERT INTO `scheme_buffs` VALUES ('The Vision of Pagrio', '1249', '3');
117INSERT INTO `scheme_buffs` VALUES ('The Vision of Pagrio', '1250', '3');
118INSERT INTO `scheme_buffs` VALUES ('The Tact of Pagrio', '1260', '3');
119INSERT INTO `scheme_buffs` VALUES ('The Rage of Pagrio', '1261', '2');
120INSERT INTO `scheme_buffs` VALUES ('The Honor of Pagrio', '1305', '5');
121INSERT INTO `scheme_buffs` VALUES ('The Soul of Pagrio', '1365', '1');
122INSERT INTO `scheme_buffs` VALUES ('Pagrio\'s Fist', '1416', '1');
123INSERT INTO `scheme_buffs` VALUES ('Pagrio\'s Emblem', '1415', '1');
124INSERT INTO `scheme_buffs` VALUES ('Victories of Pagrio', '1414', '1');
125INSERT INTO `scheme_buffs` VALUES ('Prophecy of Fire', '1356', '1');
126INSERT INTO `scheme_buffs` VALUES ('Prophecy of Water', '1355', '1');
127INSERT INTO `scheme_buffs` VALUES ('Prophecy of Wind', '1357', '1');
128INSERT INTO `scheme_buffs` VALUES ('Blessing of Queen', '4699', '13');
129INSERT INTO `scheme_buffs` VALUES ('Gift of Queen', '4700', '13');
130INSERT INTO `scheme_buffs` VALUES ('Blessing of Seraphim', '4702', '13');
131INSERT INTO `scheme_buffs` VALUES ('Gift of Seraphim', '4703', '13');
132INSERT INTO `scheme_buffs` VALUES ('Sharp Edge', '825', '1');
133INSERT INTO `scheme_buffs` VALUES ('Spike', '826', '1');
134INSERT INTO `scheme_buffs` VALUES ('Restring', '827', '1');
135INSERT INTO `scheme_buffs` VALUES ('Case Harden', '828', '1');
136INSERT INTO `scheme_buffs` VALUES ('Hard Tanning', '829', '1');
137INSERT INTO `scheme_buffs` VALUES ('Embroider', '830', '1');
138INSERT INTO `scheme_buffs` VALUES ('Prayer', '1307', '3');
139INSERT INTO `scheme_buffs` VALUES ('Noblesse Blessing', '1323', '1');
140-- INSERT INTO `scheme_buffs` VALUES ('DarkWeapon', '1443', '1');
141-- INSERT INTO `scheme_buffs` VALUES ('Prahnah', '1470', '1');
142-- INSERT INTO `scheme_buffs` VALUES ('MagicImpulse', '1479', '3');
143-- INSERT INTO `scheme_buffs` VALUES ('ProtectionInsti', '1478', '2');
144-- INSERT INTO `scheme_buffs` VALUES ('ProtectionFromD', '1442', '3');
145-- INSERT INTO `scheme_buffs` VALUES ('Apetite', '1476', '3');
146-- INSERT INTO `scheme_buffs` VALUES ('Improve Combat', '1499', '1');
147-- INSERT INTO `scheme_buffs` VALUES ('Improve Magic', '1500', '1');
148-- INSERT INTO `scheme_buffs` VALUES ('Improve Condition', '1501', '1');
149-- INSERT INTO `scheme_buffs` VALUES ('Improve Critical Attack', '1502', '1');
150-- INSERT INTO `scheme_buffs` VALUES ('Improve Defense', '1503', '1');
151-- INSERT INTO `scheme_buffs` VALUES ('Improve Movement', '1504', '1');
152-- INSERT INTO `scheme_buffs` VALUES ('Lord of Vampire', '1507', '1');
153-- INSERT INTO `scheme_buffs` VALUES ('Divine Enchanter Hero Spirit', '707', '1');
154-- INSERT INTO `scheme_buffs` VALUES ('Furious Soul', '482', '2');
155-- INSERT INTO `scheme_buffs` VALUES ('Pride of Kamael', '1444', '1');
156-- INSERT INTO `scheme_buffs` VALUES ('Soul to Empower', '1441', '2');
157-- INSERT INTO `scheme_buffs` VALUES ('Blood Pact', '834', '1');