|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum) |
05-26-2009, 12:10 PM
|
 |
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Has there been a release of UCS yet ?
|
05-26-2009, 01:02 PM
|
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
Quote:
Originally Posted by provocating
Has there been a release of UCS yet ?
|
Not yet. I have it working, but I need to clean the code up a bit before releasing it. It will probably be a couple of weeks. |
05-26-2009, 01:05 PM
|
|
Demi-God
|
|
Join Date: Nov 2007
Posts: 2,175
|
|
Your code still has to look cleaner than mine.
|
06-04-2009, 03:23 PM
|
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
Was actually trying to get the opcodes for ldon objects today.
-On character select my characters hold their items in the opposite hands. Looks kinda odd with shields.
-I can confirm raids don't work; the initial raid create packet does seem to but the add players to raid packet does not.
-Something is off about LDoN objects they can't be sensed/disarmed/picked. On titanium to do this you needed a certain bodytype set but this doesn't appear to be the case. You can cast ldon spells on any target now so I assume this has moved from body type to some other field in the spawn structure.
|
 |
|
 |
06-04-2009, 06:37 PM
|
 |
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Thanks KLS. The char select issue with primary/secondary should be really easy to correct by adjusting the struct and the encode and just reversing the order of those 2 fields. I hadn't noticed this, but I also don't have any chars I use that have shields.
Thanks for confirming raids don't work. I was just wondering if anyone had even tried it yet. Judging by the difference in group structs, I figured that raids were almost certainly going to have similar changes. Maybe we can review the group struct changes and use them to help figure out what might have been changed about raids. Otherwise, we will probably need to try to create a raid on Live and collect the packets from it with SEQ.
Judging by the other changes to the spawn struct to break down certain things like Bodytype into multiple categories so that it is easier to set an NPC to spawn exactly how you want, I figured that there are other new fields like that. It shouldn't be too hard to figure out which field is required for LDoN traps by just using spawn struct hacking code that Shendare wrote. It is already in the encode for the spawn struct and just needs to be uncommented to be able to use it. It really makes identifying fields very easy, though a bit tedious since you basically have to go through each unknown until you find the right one. It is still 100X better/faster than the old way I was using to identify fields!
If I have time tonight, I plan to try to finally get the encode working for inspecting players, so that will be 1 less thing on the list of stuff that needs to be fixed for SoF. I don't think that will take very long. I tried it before, but couldn't get the strings working properly. I think with the new encodes from Derision, I should now have enough examples to get the inspect encode working. And, if I have time after doing that, I really want to knock out the stamina/endurance update packets that should now be sent and probably the manachange packets need to be encoded since they should only be dealing with mana now, and not include stamina. That is of course if SoF handles the updates the same way Live does now, which I am pretty sure it does.
|
 |
|
 |
|
|
|
06-17-2009, 08:55 AM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
After trying to add in code to support separate sets of AA related tables for SoF and Titanium, I found that it was going to be quite a bit harder to do it that way than I initially though. So, I changed the plan to simply add more fields to the existing alt_vars table and try to create a couple work-arounds. Probably 90% of the Titanium AAs are also in SoF. The few that are not, are the upgraded versions of earlier AAs. As explained earlier in this thread, this is because SOE consolidated all upgrading AAs into single AAs with more max train points in them.
It is going to take a bit of thinking and work to get the new idea working properly, but I think it will do what we need with the least amount of issues. I added some essential new fields to the alt_vars table that SoF requires, but I also added 2 new fields that it does not require, but will be used to handle the change from Titanium to SoF.
The new clientver field is for setting which client versions you want to see that particular AA in their AA Window. Here are the list of options for the clientver field atm:
0 = No Client Versions
1 = All Client Versions
2 = Titanium Only
3 = SoF Only
This field is pretty simple and is used for removing the Unknown DB messages in the AA Window for AAs that no longer exist. Currently, only SoF has this issue, but Titanium would have it as well if we ever add SoF only AAs in. This new field makes it easy to resolve it. I probably need to code something in for 6.2 Client, but I didn't yet.
I also made another field that isn't being used yet, but I have an idea about how it might be able to be used. The other field is sof_next_skill. This is essentially the opposite of what the pre_reqskill field does. The sof_next_skill will be populated with the skill ID of the upgraded version of that AA if one exists. I am not sure how to use it yet, but the idea is that we would then send the upgrade, but send it with the skill ID of the original, since I think that is what SoF wants. We would also need to do something similar to save newly purchased AAs to the player profile. This is because we need SoF and Titanium to both match up properly (or at least close) which is another reason I wanted to try using a single table for both. As far as the server is concerned, the player would essentially have the same AAs as they do on Titanium when they are playing on the SoF client. But, the client would be sent some slightly modified info so that it can show itself as having higher max train points in certain AAs that Titanium just gets upgrades for.
Anyway, the first part of this change is now on the SVN. I added an SQL update to update existing tables, but it doesn't really update all skills. So, here is the complete table that is the latest from PEQ and has the added fields that have mostly been modified to be set to what they are supposed to be set to. From what I have seen, it looks like this removed all of the Unknown DB messages and also sets many of the expansions and tabs properly. Note that running this SQL will remove your existing alt_vars table and replace it, so if you have customized AAs, you probably don't want to run this. If you just want the latest AAs, you can run this, but make sure you get the aa_effects and aa_actions from the current PEQ as well to match up:
Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for altadv_vars
-- ----------------------------
DROP TABLE IF EXISTS `altadv_vars`;
CREATE TABLE `altadv_vars` (
`skill_id` int(11) NOT NULL default '0',
`name` varchar(128) default NULL,
`cost` int(11) default NULL,
`max_level` int(11) default NULL,
`hotkey_sid` int(10) unsigned NOT NULL default '0',
`hotkey_sid2` int(10) unsigned NOT NULL default '0',
`title_sid` int(10) unsigned NOT NULL default '0',
`desc_sid` int(10) unsigned NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '1',
`spellid` int(10) unsigned NOT NULL default '0',
`prereq_skill` int(10) unsigned NOT NULL default '0',
`prereq_minpoints` int(10) unsigned NOT NULL default '0',
`spell_type` int(10) unsigned NOT NULL default '0',
`spell_refresh` int(10) unsigned NOT NULL default '0',
`classes` int(10) unsigned NOT NULL default '65534',
`berserker` int(10) unsigned NOT NULL default '0',
`class_type` int(10) unsigned NOT NULL default '0',
`cost_inc` tinyint(4) NOT NULL default '0',
`aa_expansion` tinyint(3) unsigned NOT NULL default '1',
`special_category` int(10) unsigned NOT NULL default '4294967295',
`sof_type` tinyint(3) unsigned NOT NULL default '1',
`sof_cost_inc` tinyint(3) NOT NULL default '0',
`sof_max_level` tinyint(3) unsigned NOT NULL default '1',
`sof_next_skill` int(10) unsigned NOT NULL default '0',
`clientver` tinyint(3) unsigned NOT NULL default '1',
PRIMARY KEY (`skill_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `altadv_vars` VALUES ('2', 'Innate Strength', '1', '5', '4294967295', '4294967295', '13500', '13501', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('7', 'Innate Stamina', '1', '5', '4294967295', '4294967295', '13502', '13503', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('12', 'Innate Agility', '1', '5', '4294967295', '4294967295', '13504', '13505', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('17', 'Innate Dexterity', '1', '5', '4294967295', '4294967295', '13506', '13507', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('22', 'Innate Intelligence', '1', '5', '4294967295', '4294967295', '13508', '13509', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('27', 'Innate Wisdom', '1', '5', '4294967295', '4294967295', '13510', '13511', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('32', 'Innate Charisma', '1', '5', '4294967295', '4294967295', '13512', '13513', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('37', 'Innate Fire Protection', '1', '5', '4294967295', '4294967295', '13514', '13515', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('42', 'Innate Cold Protection', '1', '5', '4294967295', '4294967295', '13516', '13517', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('47', 'Innate Magic Protection', '1', '5', '4294967295', '4294967295', '13518', '13519', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('52', 'Innate Poison Protection', '1', '5', '4294967295', '4294967295', '13520', '13521', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('57', 'Innate Disease Protection', '1', '5', '4294967295', '4294967295', '13522', '13523', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '10', '0', '1');
INSERT INTO `altadv_vars` VALUES ('62', 'Innate Run Speed', '1', '3', '4294967295', '4294967295', '13524', '13525', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('65', 'Innate Regeneration', '1', '3', '4294967295', '4294967295', '13526', '13527', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('68', 'Innate Metabolism', '1', '3', '4294967295', '4294967295', '13528', '13529', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('71', 'Innate Lung Capacity', '1', '3', '4294967295', '4294967295', '13530', '13531', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('74', 'First Aid', '1', '3', '4294967295', '4294967295', '13532', '13533', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '3', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('77', 'Healing Adept', '2', '3', '4294967295', '4294967295', '13534', '13535', '2', '4294967295', '4294967295', '0', '0', '0', '33884', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('80', 'Healing Gift', '2', '3', '4294967295', '4294967295', '13536', '13537', '2', '4294967295', '4294967295', '0', '0', '0', '33884', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('83', 'Spell Casting Mastery', '2', '3', '4294967295', '4294967295', '13538', '13539', '2', '4294967295', '4294967295', '0', '0', '0', '31812', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('86', 'Spell Casting Reinforcement', '2', '3', '4294967295', '4294967295', '13540', '13541', '2', '4294967295', '4294967295', '0', '0', '0', '50268', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('89', 'Mental Clarity', '2', '3', '4294967295', '4294967295', '13542', '13543', '2', '4294967295', '4294967295', '0', '0', '0', '64636', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('92', 'Spell Casting Fury', '2', '3', '4294967295', '4294967295', '13544', '13545', '2', '4294967295', '4294967295', '0', '0', '0', '64892', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('95', 'Channeling Focus', '2', '3', '4294967295', '4294967295', '13546', '13547', '2', '4294967295', '4294967295', '0', '0', '0', '64892', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('98', 'Spell Casting Subtlety', '2', '3', '4294967295', '4294967295', '13548', '13549', '2', '4294967295', '4294967295', '0', '0', '0', '30976', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('101', 'Spell Casting Expertise', '2', '3', '4294967295', '4294967295', '13550', '13551', '2', '4294967295', '4294967295', '0', '0', '0', '31008', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('104', 'Spell Casting Deftness', '2', '3', '4294967295', '4294967295', '13552', '13553', '2', '4294967295', '4294967295', '0', '0', '0', '14368', '0', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('107', 'Natural Durability', '2', '3', '4294967295', '4294967295', '13554', '13555', '2', '4294967295', '4294967295', '0', '0', '0', '65534', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('110', 'Natural Healing', '2', '3', '4294967295', '4294967295', '13556', '13557', '2', '4294967295', '4294967295', '0', '0', '0', '33722', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('113', 'Combat Fury', '2', '3', '4294967295', '4294967295', '13558', '13559', '2', '4294967295', '4294967295', '0', '0', '0', '33722', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('116', 'Fear Resistance', '2', '3', '4294967295', '4294967295', '13560', '13561', '2', '4294967295', '4294967295', '0', '0', '0', '33722', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('119', 'Finishing Blow', '2', '3', '4294967295', '4294967295', '13562', '13563', '2', '4294967295', '4294967295', '0', '0', '0', '33722', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('122', 'Combat Stability', '2', '3', '4294967295', '4294967295', '13564', '13565', '2', '4294967295', '4294967295', '0', '0', '0', '65534', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('125', 'Combat Agility', '2', '3', '4294967295', '4294967295', '13566', '13567', '2', '4294967295', '4294967295', '0', '0', '0', '65534', '1', '55', '2', '3', '4294967295', '2', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('128', 'Mass Group Buff', '9', '1', '13811', '13812', '13809', '13810', '3', '4294967295', '4294967295', '0', '1', '4320', '60508', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('129', 'Divine Resurrection', '5', '1', '13570', '13571', '13568', '13569', '3', '2738', '80', '3', '2', '259200', '4', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('130', 'Innate Invis to Undead', '3', '1', '13574', '13575', '13572', '13573', '3', '235', '4294967295', '0', '3', '7', '2052', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('131', 'Celestial Regeneration', '5', '1', '13578', '13579', '13576', '13577', '3', '2740', '80', '3', '4', '4320', '4', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('132', 'Bestow Divine Aura', '6', '1', '13582', '13583', '13580', '13581', '3', '2741', '4294967295', '0', '5', '8640', '4', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('133', 'Turn Undead', '3', '3', '13586', '13587', '13584', '13585', '3', '2776', '4294967295', '0', '6', '4320', '4', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('136', 'Purify Soul', '5', '1', '13590', '4294967295', '13588', '13589', '3', '2742', '4294967295', '0', '7', '4320', '4', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('137', 'Quick Evacuation', '3', '3', '4294967295', '4294967295', '13592', '13593', '3', '4294967295', '4294967295', '0', '0', '0', '4160', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('140', 'Exodus', '6', '1', '13596', '4294967295', '13594', '13595', '3', '2771', '4294967295', '0', '3', '4320', '4160', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('141', 'Quick Damage', '3', '3', '4294967295', '4294967295', '13598', '13599', '3', '4294967295', '92', '3', '0', '0', '12352', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('144', 'Enhanced Root', '5', '1', '4294967295', '4294967295', '13600', '13601', '3', '4294967295', '4294967295', '0', '0', '0', '64', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('145', 'Dire Charm', '9', '1', '13604', '13605', '13602', '13603', '3', '4294967295', '4294967295', '0', '15', '4320', '18496', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('146', 'Cannibalization', '5', '1', '13608', '13609', '13606', '13607', '3', '2749', '89', '3', '2', '180', '1024', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('147', 'Quick Buff', '3', '3', '4294967295', '4294967295', '13610', '13611', '3', '4294967295', '4294967295', '0', '0', '0', '17408', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('150', 'Alchemy Mastery', '3', '3', '4294967295', '4294967295', '13612', '13613', '3', '4294967295', '4294967295', '0', '0', '0', '1024', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('153', 'Rabid Bear', '5', '1', '13616', '13617', '13614', '13615', '3', '2750', '4294967295', '0', '3', '7200', '1024', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('154', 'Mana Burn', '5', '1', '13620', '13621', '13618', '13619', '3', '2751', '89', '3', '7', '7200', '4096', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('155', 'Improved Familiar', '9', '1', '13624', '13625', '13622', '13623', '3', '2758', '4294967295', '0', '8', '420', '4096', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('156', 'Nexus Gate', '6', '1', '13628', '13629', '13626', '13627', '3', '2734', '4294967295', '0', '2', '4320', '4096', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('158', 'Permanent Illusion', '3', '1', '4294967295', '4294967295', '13630', '13631', '3', '4294967295', '4294967295', '0', '0', '0', '16384', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('159', 'Jewelcraft Mastery', '3', '3', '4294967295', '4294967295', '13632', '13633', '3', '4294967295', '4294967295', '0', '0', '0', '16384', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('162', 'Gather Mana', '5', '1', '13636', '13637', '13634', '13635', '3', '2753', '89', '3', '3', '8640', '16384', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('163', 'Mend Companion', '5', '1', '13640', '13641', '13638', '13639', '3', '2752', '4294967295', '0', '2', '2160', '43008', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('164', 'Quick Summoning', '3', '3', '4294967295', '4294967295', '13642', '13643', '3', '4294967295', '4294967295', '0', '0', '0', '8192', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('167', 'Frenzied Burnout', '6', '1', '13646', '13647', '13644', '13645', '3', '2754', '4294967295', '0', '14', '900', '8192', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('168', 'Elemental Form: Fire', '3', '3', '13650', '13651', '13648', '13649', '3', '2795', '4294967295', '0', '4', '900', '8192', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('171', 'Elemental Form: Water', '3', '3', '13654', '13655', '13652', '13653', '3', '2798', '4294967295', '0', '4', '900', '8192', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('174', 'Elemental Form: Earth', '3', '3', '13658', '13659', '13656', '13657', '3', '2792', '4294967295', '0', '4', '900', '8192', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('177', 'Elemental Form: Air', '3', '3', '13662', '13663', '13660', '13661', '3', '2789', '4294967295', '0', '4', '900', '8192', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('180', 'Improved Reclaim Energy', '3', '1', '4294967295', '4294967295', '13664', '13665', '3', '4294967295', '4294967295', '0', '0', '0', '8192', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('181', 'Turn Summoned', '3', '3', '13668', '13669', '13666', '13667', '3', '8133', '4294967295', '0', '5', '300', '8192', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('182', 'Elemental Pact', '5', '1', '4294967295', '4294967295', '13670', '13671', '3', '4294967295', '4294967295', '0', '0', '0', '8192', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('183', 'Lifeburn', '9', '1', '13674', '13675', '13672', '13673', '3', '2755', '4294967295', '0', '4', '8640', '2048', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('184', 'Dead Mesmerization', '3', '1', '13678', '13679', '13676', '13677', '3', '2756', '4294967295', '0', '5', '4320', '2048', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('185', 'Fearstorm', '5', '1', '13682', '13683', '13680', '13681', '3', '2757', '4294967295', '0', '6', '4320', '2048', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('186', 'Flesh to Bone', '3', '1', '13686', '13687', '13684', '13685', '3', '2772', '4294967295', '0', '7', '7', '2048', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('187', 'Call to Corpse', '6', '1', '13690', '13691', '13688', '13689', '3', '2764', '4294967295', '0', '8', '4320', '2048', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('188', 'Divine Stun', '9', '1', '13694', '13695', '13692', '13693', '3', '2190', '4294967295', '0', '9', '30', '8', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('189', 'Improved Lay on Hands', '5', '1', '4294967295', '4294967295', '13696', '13697', '3', '4294967295', '4294967295', '0', '0', '0', '8', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('190', 'Slay Undead', '3', '3', '4294967295', '4294967295', '13698', '13699', '3', '4294967295', '113', '3', '0', '0', '8', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('193', 'Act of Valor', '3', '1', '13702', '13703', '13700', '13701', '3', '2775', '4294967295', '0', '3', '4320', '8', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('194', 'Holy Steed', '5', '1', '13706', '13707', '13704', '13705', '3', '2874', '4294967295', '0', '0', '1', '8', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('195', 'Fearless', '6', '1', '4294967295', '4294967295', '13708', '13709', '3', '4294967295', '116', '3', '0', '0', '40', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('196', '2 Hand Bash', '6', '1', '4294967295', '4294967295', '13710', '13711', '3', '4294967295', '4294967295', '0', '0', '0', '40', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('197', 'Innate Camouflage', '5', '1', '13714', '13715', '13712', '13713', '3', '2765', '4294967295', '0', '2', '7', '80', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('198', 'Ambidexterity', '9', '1', '4294967295', '4294967295', '13716', '13717', '3', '4294967295', '4294967295', '0', '0', '0', '33682', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('199', 'Archery Mastery', '3', '3', '4294967295', '4294967295', '13718', '13719', '3', '4294967295', '4294967295', '0', '0', '0', '16', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('205', 'Endless Quiver', '9', '1', '4294967295', '4294967295', '13722', '13723', '3', '4294967295', '4294967295', '0', '0', '0', '16', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('206', 'Unholy Steed', '5', '1', '13726', '13727', '13724', '13725', '3', '2875', '4294967295', '0', '0', '1', '32', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('207', 'Improved Harm Touch', '6', '1', '13730', '13731', '13728', '13729', '3', '2821', '4294967295', '0', '2', '4320', '32', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('208', 'Leech Touch', '6', '1', '13734', '13735', '13732', '13733', '3', '2774', '4294967295', '0', '2', '4320', '32', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('210', 'Soul Abrasion', '3', '3', '4294967295', '4294967295', '13740', '13741', '3', '4294967295', '4294967295', '0', '0', '0', '32', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('213', 'Instrument Mastery', '3', '3', '4294967295', '4294967295', '13742', '13743', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('225', 'Jam Fest', '3', '3', '4294967295', '4294967295', '13750', '13751', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('230', 'Critical Mend', '3', '3', '4294967295', '4294967295', '13757', '13758', '3', '4294967295', '74', '3', '0', '0', '128', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('233', 'Purify Body', '9', '1', '13761', '13762', '13759', '13760', '3', '2742', '4294967295', '0', '1', '1800', '128', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('237', 'Rapid Feign', '3', '3', '4294967295', '4294967295', '13765', '13766', '3', '4294967295', '4294967295', '0', '0', '0', '128', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('240', 'Return Kick', '3', '3', '4294967295', '4294967295', '13767', '13768', '3', '4294967295', '4294967295', '0', '0', '0', '128', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('243', 'Escape', '9', '1', '13771', '4294967295', '13769', '13770', '3', '0', '4294967295', '0', '1', '4320', '512', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('244', 'Poison Mastery', '3', '3', '4294967295', '4294967295', '13773', '13774', '3', '4294967295', '4294967295', '0', '0', '0', '512', '0', '59', '3', '3', '6', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('247', 'Double Riposte', '3', '3', '4294967295', '4294967295', '13775', '13776', '3', '4294967295', '4294967295', '0', '0', '0', '33466', '1', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('254', 'Purge Poison', '9', '1', '13783', '13784', '13781', '13782', '3', '5232', '4294967295', '0', '12', '4320', '512', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('255', 'Flurry', '3', '3', '4294967295', '4294967295', '13785', '13786', '3', '4294967295', '113', '3', '0', '0', '2', '1', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('258', 'Rampage', '5', '1', '13789', '4294967295', '13787', '13788', '3', '0', '4294967295', '0', '1', '600', '2', '1', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('259', 'Area Taunt', '5', '1', '13793', '13794', '13791', '13792', '3', '0', '4294967295', '0', '2', '900', '2', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('260', 'Warcry', '3', '3', '13797', '4294967295', '13795', '13796', '3', '0', '116', '3', '3', '2160', '2', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('263', 'Bandage Wound', '3', '3', '4294967295', '4294967295', '13799', '13800', '3', '4294967295', '74', '3', '0', '0', '2', '1', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('266', 'Spell Casting Reinforcement Mastery', '8', '1', '4294967295', '4294967295', '13801', '13802', '3', '4294967295', '86', '3', '0', '0', '17476', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('267', 'Spell Casting Fury Mastery', '3', '3', '4294967295', '4294967295', '13803', '13804', '3', '4294967295', '92', '3', '0', '0', '4096', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('270', 'Extended Notes', '3', '3', '4294967295', '4294967295', '13805', '13806', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('273', 'Dragon Punch', '5', '1', '4294967295', '4294967295', '13807', '13808', '3', '4294967295', '4294967295', '0', '0', '0', '128', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('274', 'Strong Root', '5', '1', '13815', '13816', '13813', '13814', '3', '2748', '4294967295', '0', '4', '4320', '4096', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('275', 'Singing Mastery', '3', '3', '4294967295', '4294967295', '13817', '13818', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('278', 'Body and Mind Rejuvenation', '5', '1', '4294967295', '4294967295', '13819', '13820', '3', '4294967295', '4294967295', '0', '0', '0', '33080', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('279', 'Physical Enhancement', '5', '1', '4294967295', '4294967295', '13821', '13822', '3', '4294967295', '4294967295', '0', '0', '0', '33722', '1', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('280', 'Adv. Trap Negotiation', '3', '3', '4294967295', '4294967295', '13823', '13824', '3', '4294967295', '4294967295', '0', '0', '0', '768', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('283', 'Acrobatics', '3', '3', '4294967295', '4294967295', '13825', '13826', '3', '4294967295', '4294967295', '0', '0', '0', '896', '0', '59', '3', '3', '4294967295', '3', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('286', 'Scribble Notes', '3', '1', '4294967295', '4294967295', '13827', '13828', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('287', 'Chaotic Stab', '6', '1', '4294967295', '4294967295', '13829', '13830', '3', '4294967295', '4294967295', '0', '0', '0', '512', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('288', 'Pet Discipline', '6', '1', '4294967295', '4294967295', '13831', '13832', '3', '4294967295', '4294967295', '0', '0', '0', '44064', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('289', 'Hobble of Spirits', '5', '1', '3300', '3301', '3298', '3299', '3', '3290', '4294967295', '0', '3', '300', '32768', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('290', 'Frenzy of Spirit', '4', '1', '3304', '3305', '3302', '3303', '3', '3289', '4294967295', '0', '4', '720', '32768', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('291', 'Paragon of Spirit', '6', '1', '3308', '3309', '3306', '3307', '3', '3291', '4294967295', '0', '5', '900', '32768', '0', '59', '0', '3', '4294967295', '3', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('292', 'Advanced Innate Strength', '1', '10', '4294967295', '4294967295', '5546', '5550', '4', '4294967295', '2', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('302', 'Advanced Innate Stamina', '1', '10', '4294967295', '4294967295', '5551', '5552', '4', '4294967295', '7', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('312', 'Advanced Innate Agility', '1', '10', '4294967295', '4294967295', '5553', '5554', '4', '4294967295', '12', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('322', 'Advanced Innate Dexterity', '1', '10', '4294967295', '4294967295', '5555', '5556', '4', '4294967295', '17', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('332', 'Advanced Innate Intelligence', '1', '10', '4294967295', '4294967295', '5557', '5558', '4', '4294967295', '22', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('342', 'Advanced Innate Wisdom', '1', '10', '4294967295', '4294967295', '5559', '5560', '4', '4294967295', '27', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('352', 'Advanced Innate Charisma', '1', '10', '4294967295', '4294967295', '5564', '5565', '4', '4294967295', '32', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('362', 'Warding of Solusek', '1', '10', '4294967295', '4294967295', '5568', '5569', '4', '4294967295', '37', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('372', 'Blessing of E\'ci', '1', '10', '4294967295', '4294967295', '5570', '5571', '4', '4294967295', '42', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('382', 'Marr\'s Protection', '1', '10', '4294967295', '4294967295', '5566', '5567', '4', '4294967295', '47', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('392', 'Shroud of The Faceless', '1', '10', '4294967295', '4294967295', '5572', '5573', '4', '4294967295', '52', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('402', 'Bertoxxulous\' Gift', '1', '10', '4294967295', '4294967295', '5574', '5575', '4', '4294967295', '57', '5', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '10', '0', '2');
INSERT INTO `altadv_vars` VALUES ('412', 'New Tanaan Crafting Mastery', '3', '6', '4294967295', '4294967295', '3286', '3287', '1', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '4', '6', '1', '0', '6', '0', '1');
INSERT INTO `altadv_vars` VALUES ('418', 'Planar Power', '2', '5', '4294967295', '4294967295', '5547', '5548', '4', '4294967295', '0', '0', '0', '0', '65534', '1', '61', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('423', 'Planar Durability', '3', '3', '4294967295', '4294967295', '5549', '5560', '4', '4294967295', '0', '0', '0', '0', '42', '1', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('426', 'Innate Enlightenment', '3', '5', '4294967295', '4294967295', '5561', '5562', '4', '4294967295', '0', '0', '0', '0', '31812', '0', '61', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('434', 'Advanced Healing Adept', '2', '3', '4294967295', '4294967295', '5578', '5579', '5', '4294967295', '77', '3', '0', '0', '33884', '0', '62', '2', '4', '4294967295', '1', '2', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('437', 'Advanced Healing Gift', '2', '3', '4294967295', '4294967295', '5580', '5581', '5', '4294967295', '80', '3', '0', '0', '33884', '0', '62', '2', '4', '4294967295', '1', '2', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('440', 'Coup de Grace', '2', '3', '4294967295', '4294967295', '5618', '5619', '5', '4294967295', '119', '3', '0', '0', '33722', '1', '62', '0', '4', '4294967295', '1', '0', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('443', 'Fury of the Ages', '3', '3', '4294967295', '4294967295', '5620', '5621', '5', '4294967295', '113', '3', '0', '0', '33722', '1', '62', '0', '4', '4294967295', '1', '0', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('446', 'Mastery of the Past', '3', '3', '4294967295', '4294967295', '5624', '5625', '5', '4294967295', '101', '3', '0', '0', '31008', '0', '62', '0', '4', '4294967295', '1', '0', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('449', 'Lightning Reflexes', '3', '5', '4294967295', '4294967295', '5636', '5637', '5', '4294967295', '125', '3', '0', '0', '65534', '1', '61', '0', '4', '4294967295', '1', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('454', 'Innate Defense', '3', '5', '4294967295', '4294967295', '5638', '5639', '5', '4294967295', '122', '3', '0', '0', '65534', '1', '61', '0', '3', '4294967295', '1', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('459', 'Radiant Cure', '2', '3', '3310', '4294967294', '9283', '9284', '5', '3297', '0', '0', '8', '180', '1092', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('477', 'Hastened Exodus', '2', '3', '4294967295', '4294967295', '5594', '5595', '5', '4294967295', '140', '1', '0', '0', '4160', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('480', 'Hastened Root', '2', '3', '4294967295', '4294967295', '5596', '5597', '5', '4294967295', '274', '1', '0', '0', '4096', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('483', 'Hastened Mending', '2', '3', '4294967295', '4294967295', '5598', '5599', '5', '4294967295', '163', '1', '0', '0', '43008', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('462', 'Hastened Divinity', '2', '3', '4294967295', '4294967295', '5582', '5583', '5', '4294967295', '132', '1', '0', '0', '4', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('468', 'Hastened Purification of the Soul', '2', '3', '4294967295', '4294967295', '5588', '5589', '5', '4294967295', '136', '1', '0', '0', '4', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('471', 'Hastened Gathering', '2', '3', '4294967295', '4294967295', '5590', '5591', '5', '4294967295', '162', '1', '0', '0', '16384', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('474', 'Hastened Rabidity', '2', '3', '4294967295', '4294967295', '5592', '5593', '5', '4294967295', '153', '1', '0', '0', '1024', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('486', 'Hastened Banishment', '2', '3', '4294967295', '4294967295', '5600', '5601', '5', '4294967295', '182', '1', '0', '0', '8192', '0', '63', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('489', 'Hastened Instigation', '2', '3', '4294967295', '4294967295', '5608', '5609', '5', '4294967295', '259', '1', '0', '0', '2', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('492', 'Furious Rampage', '2', '3', '4294967295', '4294967295', '5610', '5611', '5', '4294967295', '258', '1', '0', '0', '2', '1', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('495', 'Hastened Purification of the Body', '2', '3', '4294967295', '4294967295', '5612', '5613', '5', '4294967295', '233', '1', '0', '0', '128', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('498', 'Hasty Exit', '2', '3', '4294967295', '4294967295', '5614', '5615', '5', '4294967295', '243', '1', '0', '0', '512', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('501', 'Hastened Purification', '2', '3', '4294967295', '4294967295', '5616', '5617', '5', '4294967295', '254', '1', '0', '0', '512', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('504', 'Flash of Steel', '3', '3', '4294967295', '4294967295', '5622', '5623', '5', '4294967295', '247', '3', '0', '0', '33466', '1', '62', '0', '4', '4294967295', '1', '0', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('507', 'Divine Arbitration', '3', '3', '5696', '5697', '5532', '5533', '5', '3252', '0', '0', '9', '180', '4', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('510', 'Wrath of the Wild', '3', '3', '5698', '5699', '5534', '5535', '5', '3255', '0', '0', '4', '240', '64', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('513', 'Virulent Paralysis', '3', '3', '5700', '5701', '5536', '5537', '5', '3274', '0', '0', '4', '120', '1024', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('516', 'Harvest of Druzzil', '2', '1', '5702', '5703', '5538', '5539', '5', '3338', '0', '0', '5', '480', '4096', '0', '62', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('517', 'Eldritch Rune', '3', '3', '5706', '5707', '5542', '5543', '5', '3258', '0', '0', '4', '600', '16384', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('520', 'Servant of Ro', '3', '3', '5704', '5705', '5540', '5541', '5', '3265', '0', '0', '6', '540', '8192', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('523', 'Wake the Dead', '5', '3', '5708', '5709', '5544', '5545', '5', '3268', '0', '0', '9', '540', '2048', '0', '61', '-1', '4', '4294967295', '1', '-1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('526', 'Suspended Minion', '5', '2', '5710', '5711', '5626', '5627', '5', '5844', '0', '0', '0', '1', '60448', '0', '62', '-2', '4', '4294967295', '1', '-2', '2', '0', '1');
INSERT INTO `altadv_vars` VALUES ('528', 'Spirit Call', '4', '3', '5712', '5713', '5628', '5629', '5', '3283', '0', '0', '5', '720', '1024', '0', '61', '-1', '4', '4294967295', '1', '-1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('531', 'Celestial Renewal', '3', '2', '28226', '28227', '5630', '5631', '5', '3250', '131', '1', '4', '900', '4', '0', '63', '3', '4', '4294967295', '1', '3', '2', '0', '1');
INSERT INTO `altadv_vars` VALUES ('533', 'Allegiant Familiar', '6', '1', '9244', '4294967295', '5632', '5633', '5', '3264', '155', '1', '8', '420', '4096', '0', '64', '0', '4', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('534', 'Hand of Piety', '3', '3', '5724', '5725', '5634', '5635', '5', '3261', '189', '1', '4', '2160', '8', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('537', 'Mithaniel\'s Binding', '3', '2', '4294967295', '4294967295', '5640', '5641', '5', '4294967295', '263', '3', '0', '0', '2', '1', '63', '0', '4', '4294967295', '1', '0', '2', '0', '1');
INSERT INTO `altadv_vars` VALUES ('539', 'Mending of the Tranquil', '2', '3', '4294967295', '4294967295', '5642', '5643', '5', '4294967295', '230', '3', '0', '0', '128', '0', '63', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('542', 'Raging Flurry', '2', '3', '4294967295', '4294967295', '5644', '5645', '5', '4294967295', '255', '3', '0', '0', '2', '1', '63', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('545', 'Guardian of the Forest', '3', '3', '5714', '5715', '5646', '5647', '5', '3271', '0', '0', '3', '900', '16', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('548', 'Spirit of the Wood', '4', '3', '5716', '5717', '5648', '5649', '5', '3277', '0', '0', '5', '900', '64', '0', '61', '-1', '4', '4294967295', '1', '-1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('551', 'Bestial Frenzy', '2', '5', '4294967295', '4294967295', '5650', '5651', '5', '4294967295', '0', '0', '0', '0', '32768', '0', '61', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('556', 'Harmonious Attack', '2', '5', '4294967295', '4294967295', '5652', '5653', '5', '4294967295', '0', '0', '0', '0', '256', '0', '61', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('561', 'Knight\'s Advantage', '2', '3', '4294967295', '4294967295', '5654', '5655', '5', '4294967295', '0', '0', '0', '0', '40', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('564', 'Ferocity', '3', '3', '4294967295', '4294967295', '5656', '5657', '5', '4294967295', '0', '0', '0', '0', '658', '1', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('567', 'Viscid Roots', '5', '1', '4294967295', '4294967295', '5664', '5665', '5', '4294967295', '144', '1', '0', '0', '64', '0', '63', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('568', 'Sionachie\'s Crescendo', '2', '3', '4294967295', '4294967295', '5666', '5667', '5', '4294967295', '270', '3', '0', '0', '256', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('571', 'Ayonaes Tutelage', '2', '3', '4294967295', '4294967295', '5668', '5669', '5', '4294967295', '0', '0', '0', '0', '256', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('574', 'Feigned Minion', '3', '3', '4294967295', '4294967295', '5674', '5675', '5', '4294967295', '288', '1', '0', '0', '2048', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('577', 'Unfailing Divinity', '2', '3', '4294967295', '4294967295', '5660', '5661', '5', '4294967295', '0', '0', '0', '0', '4', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('580', 'Animation Empathy', '4', '3', '4294967295', '4294967295', '5658', '5659', '5', '4294967295', '0', '0', '0', '0', '16384', '0', '61', '-1', '4', '4294967295', '1', '-1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('583', 'Rush to Judgment', '2', '3', '4294967295', '4294967295', '5672', '5673', '5', '4294967295', '188', '1', '0', '0', '8', '0', '63', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('586', 'Living Shield', '2', '3', '4294967295', '4294967295', '3275', '3276', '5', '4294967295', '279', '1', '0', '0', '2', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('589', 'Consumption of the Soul', '3', '3', '4294967295', '4294967295', '3283', '3284', '5', '4294967295', '208', '1', '0', '0', '32', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('592', 'Boastful Bellow', '6', '1', '5718', '5719', '5676', '5677', '5', '3282', '113', '1', '2', '18', '256', '0', '63', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('593', 'Fervent Blessing', '3', '3', '4294967295', '4294967295', '5680', '5681', '5', '4294967295', '0', '0', '0', '0', '8', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('596', 'Touch of the Wicked', '2', '3', '4294967295', '4294967295', '5682', '5683', '5', '4294967295', '0', '0', '0', '0', '32', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('599', 'Punishing Blade', '2', '3', '4294967295', '4294967295', '5684', '5685', '5', '4294967295', '0', '0', '0', '0', '146', '1', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('602', 'Speed of the Knight', '3', '3', '4294967295', '4294967295', '5686', '5687', '5', '4294967295', '0', '0', '0', '0', '40', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('605', 'Shroud of Stealth', '6', '1', '4294967295', '4294967295', '5688', '5689', '5', '4294967295', '0', '0', '0', '0', '512', '0', '63', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('606', 'Nimble Evasion', '1', '5', '4294967295', '4294967295', '5690', '5691', '5', '4294967295', '0', '0', '0', '0', '512', '0', '61', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('611', 'Technique of Master Wu', '2', '5', '4294967295', '4294967295', '5692', '5693', '5', '4294967295', '0', '0', '0', '0', '128', '0', '61', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('616', 'Host of the Elements', '5', '3', '5720', '5721', '5694', '5695', '5', '3286', '0', '0', '7', '900', '8192', '0', '63', '-1', '4', '4294967295', '1', '-1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('619', 'Call of Xuzl', '3', '3', '3290', '3291', '3288', '3289', '5', '3292', '0', '0', '6', '900', '4096', '0', '61', '-1', '4', '4294967295', '1', '-1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('622', 'Hastened Stealth', '3', '3', '4294967295', '4294967295', '3314', '3315', '5', '4294967295', '0', '0', '0', '0', '512', '0', '61', '0', '4', '4294967295', '1', '0', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('625', 'Ingenuity', '1', '3', '4294967295', '4294967295', '5523', '5728', '5', '4294967295', '0', '0', '0', '0', '642', '1', '61', '1', '4', '4294967295', '1', '1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('628', 'Fleet of Foot', '2', '2', '4294967295', '4294967295', '5584', '5585', '5', '4294967295', '0', '0', '0', '0', '256', '0', '62', '2', '4', '4294967295', '1', '2', '2', '0', '1');
INSERT INTO `altadv_vars` VALUES ('630', 'Fading Memories', '6', '1', '5732', '5733', '5730', '5731', '5', '5243', '0', '0', '7', '1', '256', '0', '63', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('631', 'Tactical Mastery', '2', '3', '4294967295', '4294967295', '5734', '5735', '5', '4294967295', '0', '0', '0', '0', '2', '1', '61', '1', '4', '4294967295', '1', '1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('634', 'Theft of Life', '1', '3', '4294967295', '4294967295', '5736', '5737', '5', '4294967295', '0', '0', '0', '0', '2080', '0', '61', '1', '4', '4294967295', '1', '1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('637', 'Fury of Magic', '3', '3', '4294967295', '4294967295', '5738', '5739', '5', '4294967295', '92', '3', '0', '0', '27716', '0', '61', '3', '4', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('640', 'Fury of Magic Mastery', '2', '3', '4294967295', '4294967295', '5740', '5741', '5', '4294967295', '267', '3', '0', '0', '4096', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('643', 'Project Illusion', '4', '1', '5662', '5663', '5670', '5742', '5', '582', '158', '1', '0', '1', '16384', '0', '62', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('644', 'Headshot', '4', '1', '4294967295', '4294967295', '5743', '5744', '5', '4294967295', '199', '1', '0', '0', '16', '0', '62', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('645', 'Entrap', '4', '1', '5749', '4294967295', '5747', '5748', '5', '3614', '0', '0', '4', '5', '16', '0', '64', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('646', 'Unholy Touch', '2', '3', '4294967295', '4294967295', '9000', '9001', '5', '4294967295', '207', '1', '0', '0', '32', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('649', 'Total Domination', '2', '3', '4294967295', '4294967295', '9002', '9003', '5', '4294967295', '0', '0', '0', '0', '16384', '0', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('652', 'Stalwart Endurance', '2', '3', '4294967295', '4294967295', '5751', '5752', '5', '4294967295', '0', '0', '0', '0', '2', '1', '61', '2', '4', '4294967295', '1', '2', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('672', 'Swift Journey', '5', '2', '4294967295', '4294967295', '9151', '9152', '6', '4294967295', '62', '3', '0', '0', '65534', '1', '61', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('674', 'Convalescence', '3', '2', '4294967295', '4294967295', '9153', '9154', '6', '4294967295', '65', '3', '0', '0', '65534', '1', '61', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('676', 'Lasting Breath', '2', '2', '4294967295', '4294967295', '9155', '9156', '6', '4294967295', '71', '3', '0', '0', '65534', '1', '61', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('678', 'Packrat', '3', '5', '4294967295', '4294967295', '9325', '9326', '6', '4294967295', '0', '0', '0', '0', '65534', '1', '61', '0', '7', '4294967295', '1', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('686', 'Weapon Affinity', '2', '5', '4294967295', '4294967295', '9159', '9160', '6', '4294967295', '0', '0', '0', '0', '33722', '1', '55', '0', '4', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('691', 'Secondary Forte', '15', '1', '4294967295', '4294967295', '9161', '9162', '6', '4294967295', '0', '0', '0', '0', '31812', '0', '55', '0', '4', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('692', 'Persistent Casting', '3', '3', '4294967295', '4294967295', '9187', '9188', '6', '4294967295', '0', '0', '0', '0', '64892', '0', '55', '3', '4', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('718', 'Bestial Alignment', '3', '3', '9219', '4294967295', '9219', '9220', '6', '4521', '0', '0', '7', '4320', '32768', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('721', 'Wrath of Xuzl', '5', '2', '3290', '3291', '9199', '9200', '6', '5110', '619', '3', '6', '900', '4096', '0', '65', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('723', 'Feral Swipe', '9', '1', '9175', '4294967295', '9175', '9176', '6', '4788', '0', '0', '6', '60', '32768', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('724', 'Warder\'s Fury', '3', '5', '4294967295', '4294967295', '9177', '9178', '6', '4294967295', '0', '0', '0', '0', '32768', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('729', 'Warder\'s Alacrity', '3', '5', '4294967295', '4294967295', '9179', '9180', '6', '4294967295', '0', '0', '0', '0', '32768', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('734', 'Pet Affinity', '20', '1', '4294967295', '4294967295', '9285', '9286', '6', '4294967295', '0', '0', '0', '0', '60448', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('735', 'Mastery of the Past', '3', '3', '4294967295', '4294967295', '9163', '9164', '6', '4294967295', '0', '0', '0', '0', '32784', '0', '62', '0', '7', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('767', 'Critical Affliction', '5', '3', '4294967295', '4294967295', '9191', '9192', '6', '4294967295', '0', '0', '0', '0', '36192', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('806', 'Sinister Strikes', '15', '1', '4294967295', '4294967295', '9231', '9232', '6', '4294967295', '198', '1', '0', '0', '33682', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('921', 'Ro\'s Flaming Familiar', '15', '1', '9269', '4294967295', '9269', '9270', '6', '4833', '0', '0', '8', '60', '4096', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('922', 'E\'ci\'s Icy Familiar', '15', '1', '9227', '4294967295', '9227', '9228', '6', '4834', '0', '0', '8', '60', '4096', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('923', 'Druzzil\'s Mystical Familiar', '15', '1', '9279', '4294967295', '9279', '9280', '6', '4835', '0', '0', '8', '60', '4096', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('924', 'Advanced Fury of Magic Mastery', '5', '2', '9265', '4294967295', '9265', '9266', '6', '4294967295', '640', '3', '0', '0', '4096', '0', '65', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('926', 'Ward of Destruction', '3', '5', '9319', '4294967295', '9319', '9320', '6', '4836', '0', '0', '12', '1800', '4096', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('931', 'Frenzied Devastation', '5', '3', '9340', '4294967295', '9340', '9341', '6', '5245', '92', '1', '13', '4320', '4096', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('978', 'Eternal Breath', '5', '1', '4294967295', '4294967295', '30012', '30013', '7', '4294967295', '676', '2', '0', '0', '65534', '1', '68', '0', '8', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('979', 'Blacksmithing Mastery', '3', '3', '4294967295', '4294967295', '30016', '30017', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '59', '3', '8', '6', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('982', 'Baking Mastery', '3', '3', '4294967295', '4294967295', '30028', '30029', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '59', '3', '8', '6', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('985', 'Brewing Mastery', '3', '3', '4294967295', '4294967295', '30040', '30041', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '59', '3', '8', '6', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('988', 'Fletching Mastery', '3', '3', '4294967295', '4294967295', '30052', '30053', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '59', '3', '8', '6', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('991', 'Pottery Mastery', '3', '3', '4294967295', '4294967295', '30064', '30065', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '59', '3', '8', '6', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('994', 'Tailoring Mastery', '3', '3', '4294967295', '4294967295', '30076', '30077', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '59', '3', '8', '6', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('997', 'Salvage', '5', '3', '4294967295', '4294967295', '30088', '30089', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '60', '0', '8', '6', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1000', 'Origin', '7', '1', '30102', '4294967295', '30100', '30101', '7', '5824', '0', '0', '20', '4320', '65534', '1', '67', '0', '8', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1001', 'Chaotic Potential', '5', '5', '4294967295', '4294967295', '30104', '30105', '7', '4294967295', '418', '5', '0', '0', '65534', '1', '66', '0', '8', '4294967295', '1', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1006', 'Discordant Defiance', '5', '5', '4294967295', '4294967295', '30124', '30125', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '66', '0', '8', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1021', 'Mystical Attuning', '5', '5', '4294967295', '4294967295', '30144', '30145', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '51', '0', '8', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1026', 'Delay Death', '3', '5', '4294967295', '4294967295', '30164', '30165', '7', '4294967295', '0', '0', '0', '0', '65534', '1', '66', '0', '8', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1031', 'Healthy Aura', '3', '5', '4294967295', '4294967295', '30184', '30185', '7', '4294967295', '674', '2', '0', '0', '65534', '1', '66', '0', '8', '4294967295', '1', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1041', 'Veteran\'s Wrath', '3', '3', '4294967295', '4294967295', '30224', '30225', '7', '4294967295', '443', '3', '0', '0', '33192', '0', '67', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1053', 'Deathblow', '3', '3', '4294967295', '4294967295', '30272', '30273', '7', '4294967295', '440', '3', '0', '0', '33722', '1', '66', '0', '8', '4294967295', '1', '0', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1061', 'Reflexive Mastery', '5', '5', '4294967295', '4294967295', '30304', '30305', '7', '4294967295', '449', '5', '0', '0', '65534', '1', '66', '0', '8', '4294967295', '1', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1066', 'Defensive Instincts', '5', '5', '4294967295', '4294967295', '30324', '30325', '7', '4294967295', '454', '5', '0', '0', '65534', '1', '66', '0', '8', '4294967295', '2', '0', '5', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1071', 'Mnemonic Retention', '3', '1', '4294967295', '4294967295', '30344', '30345', '7', '4294967295', '0', '0', '0', '0', '64892', '0', '55', '0', '8', '4294967295', '2', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1072', 'Expansive Mind', '5', '5', '4294967295', '4294967295', '30348', '30349', '7', '4294967295', '0', '0', '0', '0', '64892', '0', '66', '0', '8', '4294967295', '2', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1083', 'Healing Adept Mastery', '3', '3', '4294967295', '4294967295', '30392', '30393', '7', '4294967295', '434', '3', '0', '0', '33884', '0', '66', '3', '8', '4294967295', '2', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1086', 'Healing Gift Mastery', '3', '3', '4294967295', '4294967295', '30404', '30405', '7', '4294967295', '437', '3', '0', '0', '33884', '0', '66', '3', '8', '4294967295', '2', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1089', 'Arcane Tongues', '3', '3', '4294967295', '4294967295', '30416', '30417', '7', '4294967295', '0', '0', '0', '0', '30720', '0', '66', '3', '8', '4294967295', '2', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1093', 'Slippery Attacks', '3', '5', '4294967295', '4294967295', '30432', '30433', '7', '4294967295', '0', '0', '0', '0', '33682', '0', '66', '0', '8', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1099', 'Improved Critical Affliction', '3', '3', '4294967295', '4294967295', '30456', '30457', '7', '4294967295', '767', '3', '0', '0', '36192', '0', '67', '3', '8', '4294967295', '1', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1107', 'Fury of Magic', '3', '3', '4294967295', '4294967295', '5738', '5739', '7', '4294967295', '92', '3', '0', '0', '33080', '0', '66', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1119', 'Roar of Thunder', '3', '3', '30538', '30539', '30536', '30537', '7', '5841', '0', '0', '8', '900', '32768', '0', '68', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1122', 'Persistent Minion', '7', '1', '4294967295', '4294967295', '30548', '30549', '7', '4294967295', '526', '2', '0', '0', '60448', '0', '67', '0', '8', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1123', 'Perfection of Spirit', '5', '3', '30554', '30555', '30552', '30553', '7', '5854', '291', '1', '5', '900', '32768', '0', '66', '0', '8', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1126', 'Replenish Companion', '3', '3', '30566', '30567', '30564', '30565', '7', '5845', '163', '1', '2', '2160', '43008', '0', '66', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1129', 'Advanced Pet Discipline', '5', '2', '4294967295', '4294967295', '30576', '30577', '7', '4294967295', '288', '1', '0', '0', '44064', '0', '67', '-2', '8', '4294967295', '1', '-2', '2', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1181', 'Shielding Resistance', '3', '5', '4294967295', '4294967295', '30784', '30785', '7', '4294967295', '0', '0', '0', '0', '33682', '0', '66', '0', '8', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1210', 'Destructive Fury', '3', '3', '4294967295', '4294967295', '30900', '30901', '7', '4294967295', '640', '3', '0', '0', '4096', '0', '66', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1229', 'Secondary Recall', '7', '1', '30978', '30979', '30976', '30977', '7', '6094', '0', '0', '10', '600', '4160', '0', '66', '0', '8', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1334', 'Mind Crash', '3', '3', '31410', '31411', '31408', '31409', '7', '5943', '0', '0', '11', '4320', '4096', '0', '66', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1337', 'Prolonged Destruction', '5', '3', '31422', '31423', '31420', '31421', '7', '5946', '741', '3', '13', '4320', '4096', '0', '67', '0', '8', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1340', 'Ro\'s Greater Familiar', '12', '1', '31434', '31435', '31432', '31433', '7', '5950', '724', '1', '8', '60', '4096', '0', '69', '0', '8', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1341', 'E\'ci\'s Greater Familiar', '12', '1', '31438', '31439', '31436', '31437', '7', '5951', '729', '1', '8', '60', '4096', '0', '69', '0', '8', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1342', 'Druzzil\'s Greater Familiar', '12', '1', '31442', '31443', '31440', '31441', '7', '5952', '734', '1', '8', '60', '4096', '0', '69', '0', '8', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('1343', 'Teleport Bind', '9', '1', '31446', '31447', '31444', '31445', '7', '5953', '0', '0', '9', '300', '4096', '0', '69', '0', '10', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1344', 'Devoted Familiar', '12', '1', '31450', '31451', '31448', '31449', '7', '5949', '290', '1', '8', '60', '4096', '0', '70', '0', '10', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('807', 'Strikethrough', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '2147483647', '0', '0', '0', '0', '128', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('810', 'Stonewall', '5', '5', '2147483647', '2147483647', '2147483647', '0', '6', '0', '0', '0', '0', '0', '128', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('815', 'Rapid Strikes', '4', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '128', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('820', 'Kick Mastery', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '128', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('823', 'Heightened Awareness', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '128', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('828', 'Destructive Force', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '5240', '0', '0', '2', '3600', '128', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('770', 'Fury of Magic Mastery', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '637', '3', '0', '0', '27716', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('831', 'Swarm of Decay', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '10', '1800', '2048', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('834', 'Deaths Fury', '3', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '2048', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('839', 'Quickening of Death', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '2048', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('864', 'Precision of the Pathfinder', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '16', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('867', 'Coat of Thistles', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '16', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('872', 'Flaming Arrows', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '4802', '0', '0', '5', '180', '16', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('875', 'Frost Arrows', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '4805', '0', '0', '5', '180', '16', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('915', 'Strengthened Strike', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '16', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('683', 'Heightened Endurance', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '642', '1', '61', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('846', 'Triple Backstab', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '512', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('878', 'Seized Opportunity', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '287', '1', '0', '0', '512', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('881', 'Trap Circumvention', '3', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '512', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('886', 'Improved Hasty Exit', '5', '2', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '498', '3', '0', '0', '512', '0', '65', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('888', 'Virulent Venom', '3', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '512', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('893', 'Improved Consumption of the Soul', '5', '2', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '589', '3', '0', '0', '32', '0', '65', '0', '7', '4294967295', '1', '0', '2', '0', '2');
INSERT INTO `altadv_vars` VALUES ('849', 'Hastened Piety', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '534', '3', '0', '0', '8', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('852', 'Immobilizing Bash', '5', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '8', '0', '65', '0', '7', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('855', 'Vicious Smash', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '8', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('860', 'Radiant Cure', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '3297', '0', '0', '5', '180', '8', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('863', 'Purification', '12', '1', '2147483647', '2147483647', '2147483647', '2147483647', '6', '5248', '0', '0', '6', '4320', '8', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('738', 'Spell Casting Subtlety', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '1092', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('754', 'Quickened Curing', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '459', '3', '0', '0', '1092', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '2');
INSERT INTO `altadv_vars` VALUES ('900', 'Advanced Spirit Call', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '12646', '528', '3', '5', '720', '1024', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('907', 'Sturdiness', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '2', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('918', 'Extended Shielding', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '2', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('741', 'Touch of the Divine', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '4', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('746', 'Divine Avatar', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '4549', '0', '0', '10', '2160', '4', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('749', 'Exquisite Benediction', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '4790', '0', '0', '13', '1800', '4', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('757', 'Natures Boon', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '4796', '0', '0', '6', '1800', '64', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('762', 'Advanced Tracking', '4', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '64', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('844', 'Advanced Theft of Life', '5', '2', '31455', '31456', '31453', '31454', '6', '4294967295', '634', '3', '0', '0', '2080', '0', '65', '0', '7', '4294967295', '1', '0', '2', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1140', 'Dead Aim', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '5', '0', '0', '0', '0', '0', '0', '1', '61', '0', '8', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1143', 'Frenzied Defense', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '0', '1', '65', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1149', 'Desperation', '12', '1', '2147483647', '2147483647', '2147483647', '2147483647', '6', '5853', '0', '0', '5', '1320', '0', '1', '65', '0', '8', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1150', 'Untamed Rage', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '5848', '564', '3', '2', '2160', '0', '1', '65', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1155', 'Echoing Cries', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '0', '1', '65', '3', '8', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('773', 'Doppelganger', '3', '3', '2147483647', '0', '2147483647', '2147483647', '6', '4552', '643', '1', '5', '1800', '16384', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('776', 'Enhanced Forgetfulness', '3', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '16384', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('781', 'Mesmerization Mastery', '12', '1', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '16384', '0', '65', '0', '7', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('782', 'Quick Mass Group Buff', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '128', '1', '0', '0', '16384', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('785', 'Shared Health', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '5235', '0', '0', '8', '900', '8192', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('790', 'Elemental Fury', '3', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '8192', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('795', 'Elemental Alacrity', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '8192', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('800', 'Elemental Agility', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '8192', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('803', 'Elemental Durability', '3', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '8192', '0', '65', '3', '7', '4294967295', '1', '3', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('695', 'Tune of Pursuance', '4', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '0', '0', '0', '0', '256', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('700', 'Improved Instrument Mastery', '9', '1', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '213', '3', '0', '0', '256', '0', '61', '0', '7', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('701', 'Improved Singing Mastery', '9', '1', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '275', '3', '0', '0', '256', '0', '61', '0', '7', '4294967295', '1', '0', '1', '0', '2');
INSERT INTO `altadv_vars` VALUES ('702', 'Exultant Bellowing', '3', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '4842', '592', '1', '2', '18', '256', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('707', 'Echo of Taelosia', '5', '3', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '571', '3', '0', '0', '256', '0', '65', '0', '7', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('710', 'Internal Metronome', '5', '5', '2147483647', '2147483647', '2147483647', '2147483647', '6', '0', '95', '3', '0', '0', '256', '0', '65', '0', '7', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1319', 'Soul Thief', '5', '3', '31459', '31460', '31457', '31458', '7', '4294967295', '844', '2', '0', '0', '2080', '0', '68', '0', '8', '4294967295', '1', '0', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('209', 'Death Peace', '5', '1', '13738', '13739', '13736', '13737', '7', '4294967295', '0', '0', '12', '5', '2080', '0', '65', '0', '3', '4294967295', '1', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1134', 'Blur of Axes', '3', '3', '31463', '31464', '31461', '31462', '5', '4294967295', '0', '0', '0', '0', '0', '1', '61', '1', '8', '4294967295', '1', '1', '3', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1158', 'Vicious Frenzy', '4', '5', '31467', '31468', '31465', '31466', '7', '4294967295', '1344', '3', '0', '0', '0', '1', '67', '0', '8', '4294967295', '1', '0', '5', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1373', 'Chaotic Jester', '0', '1', '1373', '1373', '1373', '1373', '8', '6882', '0', '0', '25', '72000', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1371', 'Lesson of the Devoted', '0', '1', '1371', '1371', '1371', '1371', '8', '6880', '0', '0', '23', '72000', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1372', 'Infusion of the Faithful', '0', '1', '1372', '1372', '1372', '1372', '8', '6881', '0', '0', '24', '72000', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1374', 'Expedient Recovery', '0', '1', '1374', '1374', '1374', '1374', '8', '6883', '0', '0', '26', '590400', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1376', 'Staunch Recovery', '0', '1', '1376', '1376', '1376', '1376', '8', '6885', '0', '0', '28', '259200', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1375', 'Steadfast Servant', '0', '1', '1375', '1375', '1375', '1375', '8', '6884', '0', '0', '27', '72000', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
INSERT INTO `altadv_vars` VALUES ('1377', 'Intensity of the Resolute', '0', '1', '1377', '1377', '1377', '1377', '8', '6886', '0', '0', '29', '72000', '65534', '1', '1', '0', '10', '4294967295', '4', '0', '1', '0', '1');
|
|
|
|
|
|
|
06-17-2009, 07:53 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
I actually think I finally may have figured this whole thing out, lol.
Right before going to bed last night, it occurred to me that the way Live currently sends AA information may be the same way they always have, just with a bit of a conversion. Basically, the increase in max_level for each AA that has an increase is causing it to send an additional separate AA table packet with the same skill id. This is a bit hard to explain clearly without showing someone the exact packet stuff I am talking about, which I am not going to do in this post :P
I was thinking about the Player Profile and how to use both clients with the same PP without causing issues. That is why I originally added the sof_next_skill field to the alt_vars table. I was hoping to be able to make some code that would be able to figure out when and where to do conversions similar to how to convert slots between SoF and Titanium, but quite a bit more involved. If my latest theory is correct, it might not be very involved at all!
How it will work is we will need to adjust the alt_vars table to fill in the sof_next_skill field for all AAs that have upgraded versions. I may need to rename that field since if this works, it would actually be more like the pre-req field, accept that all further upgraded AAs would also have the same ID as the previous ones for this field, and that ID is always going to be the original AA that now has increased max_level instead of upgraded versions.
I guess I should just give up on trying to explain this for now, lol. I will just test it and verify if it actually works as I think or not. If so, then I will make the required adjustments and make additional updates to the Wiki in relation to these new fields so people creating AAs will know how to populate them. I think this change might be a very simple one, just doing a simple check to see if the AAs are an upgraded version and if so, then send the skill id of the original AA they are upgrades to instead of the new skill ID. I am sure this post is hard to understand, but my theory makes clear sense to me and it makes sense of why I see things from Live packet collects that I didn't previously understand. It also clears up how to deal with the table changes as well as how to deal with the Player Profile all in 1 fix. There may need to be a few extra tweaks after this to get all AAs fully functional in SoF that are currently working in Titanium, but it shouldn't be anything too major.
After I have the table working correctly for SoF, we will be able to finish off populating it. I am sure some of the AAs will need to be moved to different tabs in the AA window and also some probably have the incorrect expansion listed for them as well, but those are just minor issues. I will post the full table again once I have the upgrade stuff worked out. I am very glad to finally be making progress on AAs in SoF as they are IMO the last remaining major issue with SoF. And even though they might be the biggest issue, probably 90% of them already work, so it isn't even really that huge of an issue.
With a little luck, I will have some good news about SoF AAs later tonight  |
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:45 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Hybrid Mode
