|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum) |
 |
|
 |
05-01-2009, 06:19 AM
|
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
Quote:
|
Originally Posted by trevius
1. Chat Channels - Chat Channels are not functioning in SoF. It appears that in SoF, the Chat Server and Mail Server are combined. This would probably require a rewrite of the mail and chat servers unfortunately.
|
I've just started incorporating the mail server functionality into the chatserver (it will be a new program called UCS).
It's complicated a bit by the fact that Titanium clients establish two connections to it, one for mail and one for chat. I've added an extra character to the Mailkey, M = Mail connection, C = Chat Connection, S = (SoF) Combined connection. This is set by world, since it can determine what version the client is.
I should add that in SoF, the friends list is now maintained by the server. If you add or remove a friend it sends a command to the UCS which must be responded to for the friend to be added or removed. The friends list is also sent to the client when a connection to the UCS is established.
Last edited by Derision; 05-01-2009 at 05:10 PM..
|
 |
|
 |
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  |
|
|
|
|
|
|
06-18-2009, 09:24 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Well, it wasn't as simple as I thought, so I really didn't make any breakthroughs last night. I will give it another shot tonight. I think I am close, but there is just something keeping it from working. Might still have to do some tricky conversion stuff to get AAs working between both clients properly. I am still pretty confident that we can do it using the same tables as they are now setup.
Here are the AA table packets from EQLive that make me think it is just tricking the client:
Code:
Mar 13 2009 07:28:57:131 [Decoded] [Server->Client] [Size: 120]
[OPCode: 0x3683]
000 | 02 00 00 00 01 ff ff ff ff ff ff ff ff 02 00 00 | ................
016 | 00 02 00 00 00 33 00 00 00 01 00 00 00 01 00 00 | .....3..........
032 | 00 01 00 00 00 00 00 00 00 00 00 00 00 01 00 00 | ................
048 | 00 ff ff ff ff 00 00 00 00 00 00 00 00 fe ff 01 | ................
064 | 00 0f 00 00 00 ff ff ff ff 03 00 00 00 01 00 00 | ................
080 | 00 00 00 00 00 00 00 00 03 00 00 00 ff ff ff ff | ................
096 | 00 00 00 00 01 00 00 00 04 00 00 00 02 00 00 00 | ................
112 | 00 00 00 00 01 00 00 00 | ........
Mar 13 2009 07:28:57:131 [Decoded] [Server->Client] [Size: 120]
[OPCode: 0x3683]
000 | 09 00 00 00 01 ff ff ff ff ff ff ff ff 07 00 00 | ................
016 | 00 07 00 00 00 33 00 00 00 01 00 00 00 02 00 00 | .....3..........
032 | 00 03 00 00 00 00 00 00 00 00 00 00 00 01 00 00 | ................
048 | 00 ff ff ff ff 00 00 00 00 00 00 00 00 fe ff 01 | ................
064 | 00 0f 00 00 00 08 00 00 00 0a 00 00 00 03 00 00 | ................
080 | 00 00 00 00 00 00 00 00 03 00 00 00 ff ff ff ff | ................
096 | 00 00 00 00 01 00 00 00 07 00 00 00 06 00 00 00 | ................
112 | 00 00 00 00 01 00 00 00 | ........
Mar 13 2009 07:28:57:131 [Decoded] [Server->Client] [Size: 120]
[OPCode: 0x3683]
000 | 0a 00 00 00 01 ff ff ff ff ff ff ff ff 07 00 00 | ................
016 | 00 07 00 00 00 33 00 00 00 01 00 00 00 02 00 00 | .....3..........
032 | 00 04 00 00 00 00 00 00 00 00 00 00 00 01 00 00 | ................
048 | 00 ff ff ff ff 00 00 00 00 00 00 00 00 fe ff 01 | ................
064 | 00 0f 00 00 00 09 00 00 00 0b 00 00 00 04 00 00 | ................
080 | 00 00 00 00 00 00 00 00 03 00 00 00 ff ff ff ff | ................
096 | 00 00 00 00 01 00 00 00 07 00 00 00 08 00 00 00 | ................
112 | 00 00 00 00 01 00 00 00 | ........
The first packet is Innate Str, which I didn't have anything spent in, so it just sent the one packet. The second and third packets both fall into the Innate Stamina skill ID range. Those 2 packets are what make me think the server just uses the old separate AA information but sends them twice to stack the effects. Basically, the AA Effects are the same between the 2 aas for Innate Stamina and Improved Innate Stamina. But since the improved version no longer exists in SoF, it simply sends the normal innate 2 times and the client knows to double the stats up. I am sure that the extra effects work, because if I train Chaotic Potential (doesn't exist in SoF) and Planar Power while using a Titanium client, and then log in with SoF, I still get +50 to all caps as if I had both AAs. So, the only thing that is left to figure out is how to stack the AAs so it doesn't show the unknown DB entries in the AA Window. Also, we need to have something that will do conversion stuff for when an AA is purchased above what the base AA allows. An example of what I mean by that is Innate Stamina has a max of 5 train points allowed, but Improved Innate Stamina has 10, so that totals 15 between the 2 which is what should show up for normal Innate Stamina in SoF. But, since they are actually stored separately and sent separately just like in Titanium, we need something to tell the server that after 5 are trained into Innate Stamina that it needs to start putting the remaining 10 points into the improved version.
Hopefully this is starting to make more sense. Anyone who wants to chime in or give a shot at figuring this all out is more than welcome LMAO! I think I am on to something, but just need to get 1 working so I know exactly what needs to be done. Currently, I emptied out the alt_vars AA table on my server and left only 2 entries. One being Innate Str and the other is the improved version of it. This should make it easiest for testing as I only need to worry about getting 1 working. Once one is working, the hard part should be over, but no luck just yet. |
|
|
|
06-20-2009, 02:03 PM
|
|
Developer
|
|
Join Date: Mar 2007
Location: Ohio
Posts: 648
|
|
Have we thought about using a bitmask instead of a number for clientver? Since we're only working with 3 clients (6.2, Titanium, & SoF), it would only use 3 bits (values 0-7), and allow for more flexibility (and fewer ORs in our IF statements):
Code:
0: None
1: 6.2
2: Titanium
3: 6.2 & Titanium
4: SoF
5: 6.2 & SoF
6: Titanium & SoF
7: 6.2, Titanium, & SoF
|
06-20-2009, 02:56 PM
|
 |
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
That's the way to do it, I think AndMetal. It has the advantage too that if one day another client gets added it can just be assigned 8, and the next 16, etc.
|
|
|
|
06-20-2009, 05:21 PM
|
|
Developer
|
|
Join Date: Aug 2006
Location: USA
Posts: 5,946
|
|
Yeah, I thought about that, but the main reason for having the clientver field is to correct an issue caused by the change in the layout of the AA window and the consolidation of improved AA versions. It would still be good to have a bitmask setup, but atm the only thing it would be good for would be for that it doesn't already do as-is would be to give the option to remove AAs from being sent to 6.2.
Personally, I don't think that there are many (if any) people who run current server code that are using the 6.2 client. And even though it would be nice to continue support for all clients, I don't really know if it is still worth the extra effort. And if we ever had a 4th client, that would just mean that much more work to ensure that all 4 stay fully functional with all updates. I am not saying that I think we should break the 6.2 client completely, I just don't think we should waste time on making sure it gets all of the new features we are adding in.
I also have my doubts that we will ever get a client newer than SoF, which is one of the big reasons I started working on it in the first place. A newer client would require updating the LS code. It would also mean we would need to be able to get retail disks for it, which I don't think SOE plans to do. I guess we won't know for sure until they release the next expansion probably in a couple of months.
That is a whole other topic in itself though. For the matter at hand, if someone wants to change it to a bitmask, feel free. I don't really know what all is needed in order to set one up fully, or I would do it myself.
Another point about not really need a bitmask for the AA stuff is that there will never be a scenario when you need AAs for 6.2 and SoF but not in Titanium. You will almost always have AAs starting in 1 expansion and continuing on through all later expansions. The one exception IMO is Titanium to SoF, since they consolidated AAs to reduce the number of individual AAs by combining improved versions with the base AA they are improving. This means that the number of possible combinations is really limited and even if we added more expansions, we would still not need more than 6 or 7 options. Bitmask is fine if someone wants to add it, but again, I don't think it matters that much.
On a couple of side notes; I played Live for a few hours the other night and made some AAs to help figure out how they are handled differently now. In the process, I found out about SOEs new 51/50 server, which starts players at level 51 with 50 AAs. I don't think that server is up fully yet (been locked when I checked), but once it is, I think it might help a lot for collecting what I need about AAs. Another cool thing I found out about is the new group button on the map that shows the location of your group members. I checked SoF on the emu to see if it was there, and sure enough it was. Not only was it there, but it already works! One more selling point for people to make the switch 
Last edited by trevius; 06-21-2009 at 06:07 AM..
|
|
|
|
06-20-2009, 08:00 PM
|
 |
Demi-God
|
|
Join Date: Mar 2009
Location: Umm
Posts: 1,492
|
|
Trev is right. I am curious if there is anyone left who is running 6.2. Given there was ultra limited time frame under which 6.2 could have been installed, YEARS ago.
|
06-20-2009, 08:12 PM
|
|
Sarnak
|
|
Join Date: Aug 2003
Location: Recycle Bin
Posts: 90
|
|
Quote:
Originally Posted by trevius
It would also mean we would need to be able to get retail disks for it, which I don't think SOE plans to do. I guess we won't know for sure until they release the next expansion probably in a couple of months.
|
Beta has been announced for next expansion. So we might get another retail disc set yet. Knowing SoE, that shower of bloodsucking leeches will slurp the remaining playerbase for every penny / dime / rupee, while its still viable to do so.
We shall see
Take the scenario of a complete newcomer to EQ, having to DL a shedload of content on a slow connection. Aint it better to have a disc solution.
I know some BB is fast but for the some it just aint that fast yet! Unless SoE know better~
__________________
I'll be back!
|
|
|
|
06-20-2009, 09:08 PM
|
|
Demi-God
|
|
Join Date: Mar 2009
Location: Umm
Posts: 1,492
|
|
from what I see SOE makes "all in one" pack every 3 expansions now.
-Titanium*
-Serpent Spine
-Prophecy of Ro
-Aniversary*
-Barren Sea
-Secrets of Faydwer*
so best gues is next all in pack will be either after next expansion, or even after the one after that one.
Which means at least 1 year from now.
Now given the tremendous ammount of effort it took to get SoF working, we do not yet know if it will be fully operational by that time frame to quickly swith to yet another all in one pack.
I also want to point out, that Trev was a starting force behind move onto SoF, and mainly cuase he found it in obudant supply at only 5.95
WHich of course gives opportunity to all curent emu users to cheaply and quickly upgrade their entire software.
Now if next all in one package going to start out at like $45+ - far fewer people will go after it until it significantly drops in price, or become available for download on torents. WHich could be YEARS from now. |
|
|
|
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 03:37 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
