After spending until about 3:00 AM digging around, here's what I found.
If I simply omit those fields from the text file using the following SQL statement, everything still breaks:
Code:
SELECT CONCAT(id,’^’,name,’^’,player_1,’^’,teleport_zone,’^’,you_cast,’^’,other_casts,’^’,cast_on_you,’^’,cast_on_other,’^’,spell_fades,’^’,range,’^’,aoerange,’^’,pushback,’^’,pushup,’^’,cast_time,’^’,recovery_time,’^’,recast_time,’^’,buffdurationformula,’^’,buffduration,’^’,AEDuration,’^’,mana,’^’,effect_base_value1,’^’,effect_base_value2,’^’,effect_base_value3,’^’,effect_base_value4,’^’,effect_base_value5,’^’,effect_base_value6,’^’,effect_base_value7,’^’,effect_base_value8,’^’,effect_base_value9,’^’,effect_base_value10,’^’,effect_base_value11,’^’,effect_base_value12,’^’,effect_limit_value1,’^’,effect_limit_value2,’^’,effect_limit_value3,’^’,effect_limit_value4,’^’,effect_limit_value5,’^’,effect_limit_value6,’^’,effect_limit_value7,’^’,effect_limit_value8,’^’,effect_limit_value9,’^’,effect_limit_value10,’^’,effect_limit_value11,’^’,effect_limit_value12,’^’,max1,’^’,max2,’^’,max3,’^’,max4,’^’,max5,’^’,max6,’^’,max7,’^’,max8,’^’,max9,’^’,max10,’^’,max11,’^’,max12,’^’,icon,’^’,memicon,’^’,components1,’^’,components2,’^’,components3,’^’,components4,’^’,component_counts1,’^’,component_counts2,’^’,component_counts3,’^’,component_counts4,’^’,NoexpendReagent1,’^’,NoexpendReagent2,’^’,NoexpendReagent3,’^’,NoexpendReagent4,’^’,formula1,’^’,formula2,’^’,formula3,’^’,formula4,’^’,formula5,’^’,formula6,’^’,formula7,’^’,formula8,’^’,formula9,’^’,formula10,’^’,formula11,’^’,formula12,’^’,LightType,’^’,goodEffect,’^’,Activated,’^’,resisttype,’^’,effectid1,’^’,effectid2,’^’,effectid3,’^’,effectid4,’^’,effectid5,’^’,effectid6,’^’,effectid7,’^’,effectid8,’^’,effectid9,’^’,effectid10,’^’,effectid11,’^’,effectid12,’^’,targettype,’^’,basediff,’^’,skill,’^’,zonetype,’^’,EnvironmentType,’^’,TimeOfDay,’^’,classes1,’^’,classes2,’^’,classes3,’^’,classes4,’^’,classes5,’^’,classes6,’^’,classes7,’^’,classes8,’^’,classes9,’^’,classes10,’^’,classes11,’^’,classes12,’^’,classes13,’^’,classes14,’^’,classes15,’^’,classes16,’^’,CastingAnim,’^’,TargetAnim,’^’,TravelType,’^’,SpellAffectIndex,’^’,disallow_sit,’^’,deities0,’^’,deities1,’^’,deities2,’^’,deities3,’^’,deities4,’^’,deities5,’^’,deities6,’^’,deities7,’^’,deities8,’^’,deities9,’^’,deities10,’^’,deities11,’^’,deities12,’^’,deities13,’^’,deities14,’^’,deities15,’^’,deities16,’^’,field142,’^’,field143,’^’,new_icon,’^’,spellanim,’^’,uninterruptable,’^’,ResistDiff,’^’,dot_stacking_exempt,’^’,deleteable,’^’,RecourseLink,’^’,no_partial_resist,’^’,field152,’^’,field153,’^’,short_buff_box,’^’,descnum,’^’,typedescnum,’^’,effectdescnum,’^’,effectdescnum2,’^’,npc_no_los,’^’,field160,’^’,reflectable,’^’,bonushate,’^’,field163,’^’,field164,’^’,ldon_trap,’^’,EndurCost,’^’,EndurTimerIndex,’^’,IsDiscipline,’^’,field169,’^’,field170,’^’,field171,’^’,field172,’^’,HateAdded,’^’,EndurUpkeep,’^’,numhitstype,’^’,numhits,’^’,pvpresistbase,’^’,pvpresistcalc,’^’,pvpresistcap,’^’,spell_category,’^’,field181,’^’,field182,’^’,field183,’^’,field184,’^’,can_mgb,’^’,nodispell,’^’,npc_category,’^’,npc_usefulness,’^’,MinResist,’^’,MaxResist,’^’,viral_targets,’^’,viral_timer,’^’,nimbuseffect,’^’,ConeStartAngle,’^’,ConeStopAngle,’^’,sneaking,’^’,not_extendable,’^’,field198,’^’,field199,’^’,suspendable,’^’,viral_range,’^’,songcap,’^’,field203,’^’,field204,’^’,no_block,’^’,field206,’^’,spellgroup,’^’,rank,’^’,field209,’^’,field210,’^’,CastRestriction,’^’,allowrest,’^’,InCombat,’^’,OutofCombat) as Spell From spells_new;
If I JUST copy over the Ice Comet spell, the Ice Comet spell works, and everything else remains broken.
1) If there is an error in any spell, the whole file is broken.
2) There is an error in one of my spells.