View Single Post
  #1  
Old 11-24-2021, 08:04 PM
bingram
Fire Beetle
 
Join Date: Nov 2021
Posts: 4
Default Creating a new AA

I was hoping to create a new AA using the SQL code below. I haven't been able to get it to work. Is it possible? Thanks!

Code:
/* CREATE NEW AA */
set @db_str_maxid = (select max(id) from db_str);
insert into db_str (id, type, value) values(@maxid + 1, 1, 'Strength Mutation');
insert into db_str (id, type, value) values(@maxid + 1, 4, 'You were born with more strength than normal.');
set @aa_ranks_maxid = (select max(id) from aa_ranks);
insert into aa_ranks (id, upper_hotkey_sid, lower_hotkey_sid, title_sid, desc_sid, cost, level_req, spell, spell_type, recast_time, expansion, prev_id, next_id)
values(@aa_ranks_maxid + 1, -1, -1, @db_str_maxid + 1, @db_str_maxid + 1, 0, 1, -1, 0, 0, 0, -1, -1);
set @aa_ability_maxid = (select max(id) from aa_ability);
insert into aa_ability (id, name, category, classes, races, drakkin_heritage, deities, status, type, charges, grant_only, first_rank_id, enabled, reset_on_death)
values(@aa_ability_maxid + 1, 'Strength Mutation', 5, 65535, 65535, 127, 131071, 0, 4, 0, 1, @aa_ranks_maxid + 1, 1, 0);
insert into aa_rank_effects (rank_id, slot, effect_id, base1, base2) values(@aa_ranks_maxid + 1, 1, 4, 50, 0); /* STR */
insert into aa_rank_effects (rank_id, slot, effect_id, base1, base2) values(@aa_ranks_maxid + 1, 2, 7, 50, 0); /* STA */

/* ASSIGN AA TO CHARACTER */
insert into character_alternate_abilities (id, aa_id, aa_value, charges) values(1, 30196, 1, 0)

Last edited by bingram; 11-25-2021 at 11:25 AM.. Reason: Added CODE block.
Reply With Quote