Code:
--
-- Dumping data for table 'altadv_vars'
--
INSERT INTO altadv_vars VALUES (0,'Unknown0',0,0);
INSERT INTO altadv_vars VALUES (1,'Innate Strength',1,5);
INSERT INTO altadv_vars VALUES (2,'Innate Stamina',1,5);
INSERT INTO altadv_vars VALUES (3,'Innate Agility',1,5);
INSERT INTO altadv_vars VALUES (4,'Innate Dexterity',1,5);
INSERT INTO altadv_vars VALUES (5,'Innate Intelligence',1,5);
INSERT INTO altadv_vars VALUES (6,'Innate Wisdom',1,5);
INSERT INTO altadv_vars VALUES (7,'Innate Charisma',1,5);
INSERT INTO altadv_vars VALUES (8,'Innate Fire Protection',1,5);
INSERT INTO altadv_vars VALUES (9,'Innate Cold Protection',1,5);
INSERT INTO altadv_vars VALUES (10,'Innate Magic Protection',1,5);
INSERT INTO altadv_vars VALUES (11,'Innate Poison Protection',1,5);
INSERT INTO altadv_vars VALUES (12,'Innate Disease Protection',1,5);
INSERT INTO altadv_vars VALUES (13,'Innate Run Speed',1,3);
INSERT INTO altadv_vars VALUES (14,'Innate Regeneration',1,3);
INSERT INTO altadv_vars VALUES (15,'Innate Metabolism',1,3);
INSERT INTO altadv_vars VALUES (16,'Innate Lung Capacity',1,3);
INSERT INTO altadv_vars VALUES (17,'First Aid',1,3);
INSERT INTO altadv_vars VALUES (18,'Healing Adept',2,3);
INSERT INTO altadv_vars VALUES (19,'Healing Gift',2,3);
INSERT INTO altadv_vars VALUES (20,'Spell Casting Mastery',2,3);
INSERT INTO altadv_vars VALUES (21,'Spell Casting Reinforcement',2,3);
INSERT INTO altadv_vars VALUES (22,'Mental Clarity',2,3);
INSERT INTO altadv_vars VALUES (23,'Spell Casting Fury',2,3);
INSERT INTO altadv_vars VALUES (24,'Chanelling Focus',2,3);
INSERT INTO altadv_vars VALUES (25,'Spell Casting Subtlety',2,3);
INSERT INTO altadv_vars VALUES (26,'Spell Casting Expertise',2,3);
INSERT INTO altadv_vars VALUES (27,'Spell Casting Deftness',2,3);
INSERT INTO altadv_vars VALUES (28,'Natural Durability',2,3);
INSERT INTO altadv_vars VALUES (29,'Natural Healing',2,3);
INSERT INTO altadv_vars VALUES (30,'Combat Fury',2,3);
INSERT INTO altadv_vars VALUES (31,'Fear Resistance',2,3);
INSERT INTO altadv_vars VALUES (32,'Finishing Blow',2,3);
INSERT INTO altadv_vars VALUES (33,'Combat Stability',2,3);
INSERT INTO altadv_vars VALUES (34,'Combat Agility',2,3);
INSERT INTO altadv_vars VALUES (35,'Mass Group Buff',9,1);
INSERT INTO altadv_vars VALUES (36,'Divine Resurrection',1,1);
INSERT INTO altadv_vars VALUES (37,'Innate Invis To Undead',1,1);
INSERT INTO altadv_vars VALUES (38,'Celestial Regeneration',1,1);
INSERT INTO altadv_vars VALUES (39,'Bestow Divine Aura',1,1);
INSERT INTO altadv_vars VALUES (40,'Turn Undead',1,1);
INSERT INTO altadv_vars VALUES (41,'Purify Soul',1,1);
INSERT INTO altadv_vars VALUES (42,'Quick Evacuation',1,1);
INSERT INTO altadv_vars VALUES (43,'Exodus',1,1);
INSERT INTO altadv_vars VALUES (44,'Quick Damage',1,1);
INSERT INTO altadv_vars VALUES (45,'Enhanced Root',1,1);
INSERT INTO altadv_vars VALUES (46,'Dire Charm',1,1);
INSERT INTO altadv_vars VALUES (47,'Cannibalization',1,1);
INSERT INTO altadv_vars VALUES (48,'Quick Buff',1,3);
INSERT INTO altadv_vars VALUES (49,'Alchemy Mastery',1,3);
INSERT INTO altadv_vars VALUES (50,'Rabid Bear',1,1);
INSERT INTO altadv_vars VALUES (51,'Mana Burn',1,1);
INSERT INTO altadv_vars VALUES (52,'Improved Familiar',1,1);
INSERT INTO altadv_vars VALUES (53,'Nexus Gate',1,1);
INSERT INTO altadv_vars VALUES (54,'Unknown54',0,0);
INSERT INTO altadv_vars VALUES (55,'Permanent Illusion',1,1);
INSERT INTO altadv_vars VALUES (56,'Jewel Craft Mastery',1,1);
INSERT INTO altadv_vars VALUES (57,'Gather Mana',1,1);
INSERT INTO altadv_vars VALUES (58,'Mend Companion',1,1);
INSERT INTO altadv_vars VALUES (59,'Quick Summoning',1,1);
INSERT INTO altadv_vars VALUES (60,'Frenzied Burnout',1,1);
INSERT INTO altadv_vars VALUES (61,'Elemental Form Fire',1,1);
INSERT INTO altadv_vars VALUES (62,'Elemental Form Water',1,1);
INSERT INTO altadv_vars VALUES (63,'Elemental Form Earth',1,1);
INSERT INTO altadv_vars VALUES (64,'Elemental Form Air',1,1);
INSERT INTO altadv_vars VALUES (65,'Improved Reclaim Energy',1,1);
INSERT INTO altadv_vars VALUES (66,'Turn Summoned',1,1);
INSERT INTO altadv_vars VALUES (67,'Elemental Pact',1,1);
INSERT INTO altadv_vars VALUES (68,'Life Burn',1,1);
INSERT INTO altadv_vars VALUES (69,'Dead Mesmerization',1,1);
INSERT INTO altadv_vars VALUES (70,'Fearstorm',1,1);
INSERT INTO altadv_vars VALUES (71,'Flesh To Bone',1,1);
INSERT INTO altadv_vars VALUES (72,'Call To Corpse',1,1);
INSERT INTO altadv_vars VALUES (73,'Divine Stun',9,1);
INSERT INTO altadv_vars VALUES (74,'Improved Lay Of Hands',5,1);
INSERT INTO altadv_vars VALUES (75,'Slay Undead',3,3);
INSERT INTO altadv_vars VALUES (76,'Act Of Valor',3,1);
INSERT INTO altadv_vars VALUES (77,'Holy Steed',5,1);
INSERT INTO altadv_vars VALUES (78,'Fearless',6,1);
INSERT INTO altadv_vars VALUES (79,'2 Hand Bash',6,1);
INSERT INTO altadv_vars VALUES (80,'Innate Camouflage',1,1);
INSERT INTO altadv_vars VALUES (81,'Ambidexterity',1,1);
INSERT INTO altadv_vars VALUES (82,'Archery Mastery',1,1);
INSERT INTO altadv_vars VALUES (83,'Fletching Mastery',1,1);
INSERT INTO altadv_vars VALUES (84,'Endless Quiver',1,1);
INSERT INTO altadv_vars VALUES (85,'Unholy Steed',1,1);
INSERT INTO altadv_vars VALUES (86,'Improved Harm Touch',1,1);
INSERT INTO altadv_vars VALUES (87,'Leech Touch',1,1);
INSERT INTO altadv_vars VALUES (88,'Death Peace',1,1);
INSERT INTO altadv_vars VALUES (89,'Soul Abrasion',1,1);
INSERT INTO altadv_vars VALUES (90,'Instrument Mastery',1,1);
INSERT INTO altadv_vars VALUES (91,'Unknown91',0,0);
INSERT INTO altadv_vars VALUES (92,'Unknown92',0,0);
INSERT INTO altadv_vars VALUES (93,'Unknown93',0,0);
INSERT INTO altadv_vars VALUES (94,'Jam Fest',1,1);
INSERT INTO altadv_vars VALUES (95,'Unknown95',0,0);
INSERT INTO altadv_vars VALUES (96,'Sonic Call',1,1);
INSERT INTO altadv_vars VALUES (97,'Critical Mend',1,1);
INSERT INTO altadv_vars VALUES (98,'Purify Body',1,1);
INSERT INTO altadv_vars VALUES (99,'Chain Combo',1,1);
INSERT INTO altadv_vars VALUES (100,'Rapid Feign',1,1);
INSERT INTO altadv_vars VALUES (101,'Return Kick',1,1);
INSERT INTO altadv_vars VALUES (102,'Escape',1,1);
INSERT INTO altadv_vars VALUES (103,'Poison Mastery',1,1);
INSERT INTO altadv_vars VALUES (104,'Double Riposte',3,3);
INSERT INTO altadv_vars VALUES (105,'Unknown105',0,0);
INSERT INTO altadv_vars VALUES (106,'Quick Throw',1,1);
INSERT INTO altadv_vars VALUES (107,'Purge Poison',1,1);
INSERT INTO altadv_vars VALUES (108,'Flurry',1,1);
INSERT INTO altadv_vars VALUES (109,'Rampage',1,1);
INSERT INTO altadv_vars VALUES (110,'Area Taunt',1,1);
INSERT INTO altadv_vars VALUES (111,'Warcry',1,1);
INSERT INTO altadv_vars VALUES (112,'Bandage Wound',1,1);
INSERT INTO altadv_vars VALUES (113,'Spell Casting Reinforcement Mastery',1,1);
INSERT INTO altadv_vars VALUES (114,'Unknown114',0,0);
INSERT INTO altadv_vars VALUES (115,'Extended Notes',1,1);
INSERT INTO altadv_vars VALUES (116,'Dragon Punch',1,1);
INSERT INTO altadv_vars VALUES (117,'Strong Root',1,1);
INSERT INTO altadv_vars VALUES (118,'Singing Mastery',1,1);
INSERT INTO altadv_vars VALUES (119,'Body And Mind Rejuvenation',5,1);
INSERT INTO altadv_vars VALUES (120,'Physical Enhancement',5,1);
INSERT INTO altadv_vars VALUES (121,'Adv Trap Negotiation',1,1);
INSERT INTO altadv_vars VALUES (122,'Acrobatics',1,1);
INSERT INTO altadv_vars VALUES (123,'Scribble Notes',1,1);
INSERT INTO altadv_vars VALUES (124,'Chaotic Stab',1,1);
INSERT INTO altadv_vars VALUES (125,'Pet Discipline',1,1);
-- Note PoP AA costs aren't always a set amount per level
-- Many actually increase each level, not always evenly
-- updated ID's and names from http://lucy.fnord.net/phpBB2/viewtopic.php?t=130
-- Costs and limits from http://eq.crgaming.com/archetype/default.asp
INSERT INTO altadv_vars VALUES (126,'Hobble of Spirits',0,0);
INSERT INTO altadv_vars VALUES (127,'Frenzy of Spirit',0,0);
INSERT INTO altadv_vars VALUES (128,'Paragon of Spirit',0,0);
INSERT INTO altadv_vars VALUES (129,'Advanced Innate Strength',1,10);
INSERT INTO altadv_vars VALUES (130,'Advanced Innate Stamina',1,10);
INSERT INTO altadv_vars VALUES (131,'Advanced Innate Agility',1,10);
INSERT INTO altadv_vars VALUES (132,'Advanced Innate Dexterity',1,10);
INSERT INTO altadv_vars VALUES (133,'Advanced Innate Intelligence',1,10);
INSERT INTO altadv_vars VALUES (134,'Advanced Innate Wisdom',1,10);
INSERT INTO altadv_vars VALUES (135,'Advanced Innate Charisma',1,10);
INSERT INTO altadv_vars VALUES (136,'Warding of Solusek',1,10);
INSERT INTO altadv_vars VALUES (137,'Blessing of E\'ci',1,10);
INSERT INTO altadv_vars VALUES (138,'Marr\'s Protection',1,10);
INSERT INTO altadv_vars VALUES (139,'Shroud of The Faceless',1,10);
INSERT INTO altadv_vars VALUES (140,'Bertoxxulous\' Gift',1,10);
INSERT INTO altadv_vars VALUES (141,'New Tanaan Crafting Mastery',0,0);
INSERT INTO altadv_vars VALUES (142,'Planar Power',1,5);
INSERT INTO altadv_vars VALUES (143,'Planar Durability',3,3);
INSERT INTO altadv_vars VALUES (144,'Innate Enlightenment',3,5);
INSERT INTO altadv_vars VALUES (145,'Advanced Spell Casting Mastery',0,0);
INSERT INTO altadv_vars VALUES (146,'Advanced Healing Adept',2,3);
INSERT INTO altadv_vars VALUES (147,'Advanced Healing Gift',2,3);
INSERT INTO altadv_vars VALUES (148,'Coup de Grace',2,3);
INSERT INTO altadv_vars VALUES (149,'Fury of the Ages',3,3);
INSERT INTO altadv_vars VALUES (150,'Mastery of the Past',2,3);
INSERT INTO altadv_vars VALUES (151,'Lightning Reflexes',2,5);
INSERT INTO altadv_vars VALUES (152,'Innate Defense',2,5);
INSERT INTO altadv_vars VALUES (153,'Radiant Cure',2,3);
INSERT INTO altadv_vars VALUES (154,'Hastened Divinity',2,3);
INSERT INTO altadv_vars VALUES (155,'Hastened Turning',2,3);
INSERT INTO altadv_vars VALUES (156,'Hastened Purification of Soul',2,3);
INSERT INTO altadv_vars VALUES (157,'Hastened Gathering',2,2);
INSERT INTO altadv_vars VALUES (158,'Hastened rabidity',2,3);
INSERT INTO altadv_vars VALUES (159,'Hastened exodus',2,3);
INSERT INTO altadv_vars VALUES (160,'Hastened root',2,3);
INSERT INTO altadv_vars VALUES (161,'Hastened mending',2,3);
INSERT INTO altadv_vars VALUES (162,'Hastened banishment',2,3);
INSERT INTO altadv_vars VALUES (163,'Hastened instigation',2,3);
INSERT INTO altadv_vars VALUES (164,'Furious rampage',2,3);
INSERT INTO altadv_vars VALUES (165,'Hastened Purification of the Body',0,0);
INSERT INTO altadv_vars VALUES (166,'Hasty Exit',2,3);
INSERT INTO altadv_vars VALUES (167,'Unknown167',0,0);
INSERT INTO altadv_vars VALUES (168,'Unknown168',0,0);
INSERT INTO altadv_vars VALUES (169,'Divine Arbitration',3,3);
INSERT INTO altadv_vars VALUES (170,'Wrath of the Wild',3,3);
INSERT INTO altadv_vars VALUES (171,'Virulent Paralysis',3,3);
INSERT INTO altadv_vars VALUES (172,'Harvest of Druzzil',3,1);
INSERT INTO altadv_vars VALUES (173,'Eldritch Rune',3,3);
INSERT INTO altadv_vars VALUES (174,'Servant of Ro',3,3);
INSERT INTO altadv_vars VALUES (175,'Wake the Dead',4,3);
INSERT INTO altadv_vars VALUES (176,'Suspend Minion',4,2);
INSERT INTO altadv_vars VALUES (177,'Spirit Call',3,3);
INSERT INTO altadv_vars VALUES (178,'Celestial Renewal',3,2);
INSERT INTO altadv_vars VALUES (179,'Allegiant Familiar',1,1);
INSERT INTO altadv_vars VALUES (180,'Hand of Piety',0,0);
INSERT INTO altadv_vars VALUES (181,'Mithaniel\'s Binding',0,0);
INSERT INTO altadv_vars VALUES (182,'Mending of the Tranquil',3,3);
INSERT INTO altadv_vars VALUES (183,'Raging Flurry',3,3);
INSERT INTO altadv_vars VALUES (184,'Guardian of the Forest',0,0);
INSERT INTO altadv_vars VALUES (185,'Spirit of the Wood',2,3);
INSERT INTO altadv_vars VALUES (186,'Bestial Frenzy',2,5);
INSERT INTO altadv_vars VALUES (187,'Harmonious Attack',2,5);
INSERT INTO altadv_vars VALUES (188,'Knight\'s Advantage',0,0);
INSERT INTO altadv_vars VALUES (189,'Ferocity',3,3);
INSERT INTO altadv_vars VALUES (190,'Viscid Roots',5,1);
INSERT INTO altadv_vars VALUES (191,'Sionachie\'s Crescendo',2,3);
INSERT INTO altadv_vars VALUES (192,'Ayonae\'s Tutelage',2,3);
INSERT INTO altadv_vars VALUES (193,'Feigned Minion',3,3);
INSERT INTO altadv_vars VALUES (194,'Unfailing Divinity',2,3);
INSERT INTO altadv_vars VALUES (195,'Animation Empathy',2,3);
INSERT INTO altadv_vars VALUES (196,'Rush to Judgement',0,0);
INSERT INTO altadv_vars VALUES (197,'Living Root',0,0);
INSERT INTO altadv_vars VALUES (198,'Consumption of the Soul',0,0);
INSERT INTO altadv_vars VALUES (199,'Boastful Bellow',2,1);
INSERT INTO altadv_vars VALUES (200,'Fervrent Blessing',0,0);
INSERT INTO altadv_vars VALUES (201,'Touch of the Wicked',0,0);
INSERT INTO altadv_vars VALUES (202,'Punishing Blade',3,3);
INSERT INTO altadv_vars VALUES (203,'Speed of the Knight',0,0);
INSERT INTO altadv_vars VALUES (204,'Shroud of Stealth',6,1);
INSERT INTO altadv_vars VALUES (205,'Nimble Evasion',1,5);
INSERT INTO altadv_vars VALUES (206,'Technique of Master Wu',4,5);
INSERT INTO altadv_vars VALUES (207,'Host of the Elements',0,0);
INSERT INTO altadv_vars VALUES (208,'Call of Xuzl',1,3);
INSERT INTO altadv_vars VALUES (209,'Hastened Stealth',0,0);
INSERT INTO altadv_vars VALUES (210,'Ingenuity',2,3);
INSERT INTO altadv_vars VALUES (211,'Fleet of Foot',2,2);
INSERT INTO altadv_vars VALUES (212,'Fading Memories',9,1);
INSERT INTO altadv_vars VALUES (213,'Tactical Mastery',2,3);
INSERT INTO altadv_vars VALUES (214,'Theft of Life',1,3);
INSERT INTO altadv_vars VALUES (215,'Fury of Magic',3,3);
INSERT INTO altadv_vars VALUES (216,'Fury of Magic Mastery',0,0);
INSERT INTO altadv_vars VALUES (217,'Project Illusion',4,1);
INSERT INTO altadv_vars VALUES (218,'Headshot',0,0);
INSERT INTO altadv_vars VALUES (219,'Entrap',0,0);
INSERT INTO altadv_vars VALUES (220,'Unholy Touch',0,0);
INSERT INTO altadv_vars VALUES (221,'Total Domination',2,3);
INSERT INTO altadv_vars VALUES (222,'Stalwart Endurance',2,3);
INSERT INTO altadv_vars VALUES (223,'Quick Summoning',0,0);
INSERT INTO altadv_vars VALUES (224,'Mental Clarity',2,3);
INSERT INTO altadv_vars VALUES (225,'Innate Regeneration',0,3);
INSERT INTO altadv_vars VALUES (226,'Mana Burn',0,0);