Code: Select all
#define SPELL_TARGET_SELF 0
#define SPELL_TARGET_ENEMY 1
#define SPELL_TARGET_GROUP_AE 2
#define SPELL_TARGET_CASTER_PET 3
#define SPELL_TARGET_ENEMY_PET 4
#define SPELL_TARGET_ENEMY_CORPSE 5
#define SPELL_TARGET_GROUP_CORPSE 6
#define SPELL_TARGET_NONE 7
#define SPELL_TARGET_RAID_AE 8
#define SPELL_TARGET_OTHER_GROUP_AE 9
Set the buff to enemy and friendly to 1, it should be set to friendly when you examine it. Again I don't have a complete list on how the friendly flag changes the original list.Jabantiz wrote:Some of these will be different if the friendly flag is set or not but I don't have that exact list
Code: Select all
private void button_spell_update_Click(object sender, EventArgs e)
{
string id = textBox_spell_id.Text;
string soe_spell_crc = textBox_spell_soespellcrc.Text;
string type = textBox_spell_type.Text;
int cast_type = GetCastTypeID((string)comboBox_spell_casttype.SelectedItem) == -1 ? 0 : GetCastTypeID((string)comboBox_spell_casttype.SelectedItem);
string name = textBox_spell_name.Text;
string description = db.RemoveEscapeCharacters(textBox_spell_description.Text);
string icon = textBox_spell_icon.Text;
string icon_heroic = textBox_spell_iconheroicop.Text;
string icon_backdrop = textBox_spell_iconbackdrop.Text;
long class_skill = GetSkillID((string)comboBox_spell_classskill.SelectedItem) == -1 ? 0 : GetSkillID((string)comboBox_spell_classskill.SelectedItem);
long mastery_skill = GetSkillID((string)comboBox_spell_masteryskill.SelectedItem) == -1 ? 0 : GetSkillID((string)comboBox_spell_masteryskill.SelectedItem);
string min_class_skill_req = textBox_spell_minclassskillreq.Text;
int duration_until_cancel = Convert.ToInt32(checkBox_spell_durationuntilcancel.Checked);
int target_type = GetTargetTypeID((string)comboBox_spell_targettype.SelectedItem) == -1 ? 0 : GetTargetTypeID((string)comboBox_spell_targettype.SelectedItem);
string success_message = db.RemoveEscapeCharacters(textBox_spell_successmessage.Text);
string fade_message = db.RemoveEscapeCharacters(textBox_spell_fademessage.Text);
int interruptable = Convert.ToInt32(checkBox_spell_interruptable.Checked);
int cast_while_moving = Convert.ToInt32(checkBox_spellcastwhilemoving.Checked);
string luascript = db.RemoveEscapeCharacters(textBox_spell_luascript.Text);
string spell_visual = textBox_spell_spellvisual.Text;
string effect_message = db.RemoveEscapeCharacters(textBox_spell_effectmessage.Text);
int spell_book_type = GetSpellBookTypeID((string)comboBox_spell_spellbooktype.SelectedItem);
int can_effect_raid = Convert.ToInt32(checkBox_spell_caneffectraid.Checked);
int affect_only_group_members = Convert.ToInt32(checkBox_spell_affectonlygroupmembers.Checked);
int display_spell_tier = Convert.ToInt32(checkBox_spell_displayspelltier.Checked);
int friendly_spell = Convert.ToInt32(checkBox_spell_friendlyspell.Checked);
int group_spell = Convert.ToInt32(checkBox_spell_groupspell.Checked);
int det_type = GetDetTypeID((string)comboBox_spell_dettype.Text) == -1 ? 0 : GetDetTypeID((string)comboBox_spell_dettype.Text);
int control_effect_type = GetControlEffectTypeID((string)comboBox_spell_controleffecttype.Text) == -1 ? 0 : GetControlEffectTypeID((string)comboBox_spell_controleffecttype.Text);
int incurable = Convert.ToInt32(checkBox_spell_incurable.Checked);
string linked_timer_id = textBox_spell_linkedtimerid.Text;
int not_maintained = Convert.ToInt32(checkBox_spell_notmaintained.Checked);
string casting_flags = textBox_spell_castingflags.Text;
int persist_through_death = Convert.ToInt32(checkBox_spell_persistthroughdeath.Checked);
string savage_bar = textBox_spell_savagebar.Text;
string savage_bar_slot = textBox_spell_savagebarslot.Text;
int is_active = Convert.ToInt32(checkBox_spell_isactive.Checked);
int is_aa = Convert.ToInt32(checkBox_spell_isaa.Checked);
int is_deity = Convert.ToInt32(checkBox_spell_isdeity.Checked);
string deity = textBox_spell_deity.Text;
string last_auto_update = textBox_spell_lastautoupdate.Text;
string soe_last_update = textBox_spell_soelastupdate.Text;
int rows = db.RunQuery("UPDATE spells SET type=" + type + ", cast_type=" + cast_type + ", name='" + name + "', description='" + description + "', icon=" + icon + ", icon_heroic_op=" + icon_heroic + ", icon_backdrop=" + icon_backdrop + ", class_skill= " + class_skill + ", mastery_skill=" + mastery_skill + ", min_class_skill_req=" + min_class_skill_req + ", duration_until_cancel=" + duration_until_cancel + ", target_type=" + target_type + ", success_message='" + success_message + "', fade_message='" + fade_message + "', interruptable=" + interruptable + ", cast_while_moving=" + cast_while_moving + ", lua_script='" + luascript + "', spell_visual=" + spell_visual + ", effect_message='" + effect_message + "', spell_book_type=" + spell_book_type + ", can_effect_raid=" + can_effect_raid + ", affect_only_group_members=" + affect_only_group_members + ", display_spell_tier=" + display_spell_tier + ", friendly_spell=" + friendly_spell + ", group_spell=" + group_spell + ", det_type=" + det_type + ", control_effect_type=" + control_effect_type + ", incurable=" + incurable + ", linked_timer_id=" + linked_timer_id + ", not_maintained=" + not_maintained + ", casting_flags=" + casting_flags + ", persist_through_death=" + persist_through_death + ", savage_bar=" + savage_bar + ", savage_bar_slot=" + savage_bar_slot + ", is_active=" + is_active + ", is_aa=" + is_aa + ", is_deity=" + is_deity + ", deity=" + deity + " WHERE id=" + id);
}